Right off the top of my head, the tables you want are mdl_role and mdl_role_capabilities.
mdl_role is pretty straight forward, just lists each defined role by id, name, shortname and description as well as sortorder.
mdl_role_capabilities goes on to describe all the capabilities that each role has been assigned.
Couple thoughts on the topic...
If you're overwriting ALL ROLES from one moodle to a brand new installation (of the same version) this may actually be pretty straightforward, but if you're hoping to add roles to existing moodles proceed with caution (to say the least).
mdl_role is pretty straight forward, just lists each defined role by id, name, shortname and description as well as sortorder.
mdl_role_capabilities goes on to describe all the capabilities that each role has been assigned.
Couple thoughts on the topic...
If you're overwriting ALL ROLES from one moodle to a brand new installation (of the same version) this may actually be pretty straightforward, but if you're hoping to add roles to existing moodles proceed with caution (to say the least).
I will be upgrading 8 moodle sites using the delete moodle folder, CVS in the new version then copying the config file into the new moodle folder method. They will be upgraded from 1.63+ but I am assuming that the newly upgraded 1.7 sites will all have the default roles in the mysql tables so I don't see an issue.
Thanks for the info, I will attempt it on a test site first to see if it has any adverse effects.
Thanks for the info, I will attempt it on a test site first to see if it has any adverse effects.