In default.settings.php there are these example prefixes I see in comments:
* $db_prefix = array(
* 'default' => 'main_',
* 'users' => 'shared_',
* 'sessions' => 'shared_',
* 'role' => 'shared_',
* 'authmap' => 'shared_',
* );
I have looked up each of these tables in phpMyAdmin. There I found not just a "users" data table but also a "users_roles" data table. Should the users_roles table also be in this $db_prefix array?
If a module's data is to be shared between sites as given in the example should all tables returned by hook_schema() be explicitly given a prefix in the $db_prefix array?
If the above is the case, that can be a lot of data tables to lookup for each module's hook_schema() if there is to be a lot of sharing. Are there any prefix managing modules that assist by altering $db_prefix in settings.php and the data table names (for a site to be split up), or at least displaying what data tables should be changed and what should be be put in the $db_prefix array?
