Schema sample please

DynV's picture

Hello,

First please excuse me if the answer was easily reachable but I've looked at the group first 5 preview pages and did a search on schema which yielded the same preview as default so I assumed it this was the default behavior when keywords failed to bring results.

I have a site which I just created a 2nd domain for and I'd like the site to handle both. If there is an alternative to this, I'd still really like to get what I'm about to ask anyway. I'd like to have a (DB) Schema of a multisite (site) ; the site is D6 but any multisite schema would be appreciated (mention the version please).

I've read Sharing users and content across multiple sites which mention

<?php
$db_prefix
= array(
'default' =>'',
'blocks'=> 'main_',
'boxes' => 'main_',
'menu' => 'main_',
'variable' => 'main_',
'cache' => 'main_',
'cache_menu'=> 'main_',
);
?>
and it seem straightforward if I'm setting up a new site but I actually have a single-site and I'd like to convert it to a multisite. However I would use 'default' =>'shared_' instead. Also for archival purposes, I've included as footnote the settings.php section pertaining to this issue.

I've created a rename command, at the end of this paragraph, but I figure needing to switched a few of the shared_ to main_. However seeing there's no table menu, I assumed it wasn't to be taken literally and that each of those site parts was going to accept a different or even multiple table. So a multisite schema to make the comparison would be ideal. As I edit this, there are ticks around table names on the following but it seems the site sanitize them.

RENAME TABLE `access` TO `shared_access`;
RENAME TABLE `accesslog` TO `shared_accesslog`;
RENAME TABLE `actions` TO `shared_actions`;
RENAME TABLE `actions_aid` TO `shared_actions_aid`;
RENAME TABLE `aggregator_category` TO `shared_aggregator_category`;
RENAME TABLE `aggregator_category_feed` TO `shared_aggregator_category_feed`;
RENAME TABLE `aggregator_category_item` TO `shared_aggregator_category_item`;
RENAME TABLE `aggregator_feed` TO `shared_aggregator_feed`;
RENAME TABLE `aggregator_item` TO `shared_aggregator_item`;
RENAME TABLE `authmap` TO `shared_authmap`;
RENAME TABLE `batch` TO `shared_batch`;
RENAME TABLE `blocks` TO `shared_blocks`;
RENAME TABLE `blocks_roles` TO `shared_blocks_roles`;
RENAME TABLE `boxes` TO `shared_boxes`;
RENAME TABLE `browscap` TO `shared_browscap`;
RENAME TABLE `browscap_statistics` TO `shared_browscap_statistics`;
RENAME TABLE `cache` TO `shared_cache`;
RENAME TABLE `cache_block` TO `shared_cache_block`;
RENAME TABLE `cache_browscap` TO `shared_cache_browscap`;
RENAME TABLE `cache_filter` TO `shared_cache_filter`;
RENAME TABLE `cache_form` TO `shared_cache_form`;
RENAME TABLE `cache_menu` TO `shared_cache_menu`;
RENAME TABLE `cache_page` TO `shared_cache_page`;
RENAME TABLE `cache_update` TO `shared_cache_update`;
RENAME TABLE `captcha_points` TO `shared_captcha_points`;
RENAME TABLE `captcha_sessions` TO `shared_captcha_sessions`;
RENAME TABLE `comments` TO `shared_comments`;
RENAME TABLE `contact` TO `shared_contact`;
RENAME TABLE `content_access` TO `shared_content_access`;
RENAME TABLE `devel_queries` TO `shared_devel_queries`;
RENAME TABLE `devel_times` TO `shared_devel_times`;
RENAME TABLE `files` TO `shared_files`;
RENAME TABLE `filters` TO `shared_filters`;
RENAME TABLE `filter_formats` TO `shared_filter_formats`;
RENAME TABLE `flood` TO `shared_flood`;
RENAME TABLE `guestbook` TO `shared_guestbook`;
RENAME TABLE `history` TO `shared_history`;
RENAME TABLE `imagecache_action` TO `shared_imagecache_action`;
RENAME TABLE `imagecache_preset` TO `shared_imagecache_preset`;
RENAME TABLE `int_meta_fields` TO `shared_int_meta_fields`;
RENAME TABLE `linkchecker_boxes` TO `shared_linkchecker_boxes`;
RENAME TABLE `linkchecker_comments` TO `shared_linkchecker_comments`;
RENAME TABLE `linkchecker_links` TO `shared_linkchecker_links`;
RENAME TABLE `linkchecker_nodes` TO `shared_linkchecker_nodes`;
RENAME TABLE `masquerade` TO `shared_masquerade`;
RENAME TABLE `masquerade_users` TO `shared_masquerade_users`;
RENAME TABLE `menu_custom` TO `shared_menu_custom`;
RENAME TABLE `menu_links` TO `shared_menu_links`;
RENAME TABLE `menu_restricter` TO `shared_menu_restricter`;
RENAME TABLE `menu_router` TO `shared_menu_router`;
RENAME TABLE `node` TO `shared_node`;
RENAME TABLE `node_access` TO `shared_node_access`;
RENAME TABLE `node_comment_statistics` TO `shared_node_comment_statistics`;
RENAME TABLE `node_counter` TO `shared_node_counter`;
RENAME TABLE `node_revisions` TO `shared_node_revisions`;
RENAME TABLE `node_type` TO `shared_node_type`;
RENAME TABLE `openid_association` TO `shared_openid_association`;
RENAME TABLE `openid_nonce` TO `shared_openid_nonce`;
RENAME TABLE `permission` TO `shared_permission`;
RENAME TABLE `poll` TO `shared_poll`;
RENAME TABLE `poll_choices` TO `shared_poll_choices`;
RENAME TABLE `poll_votes` TO `shared_poll_votes`;
RENAME TABLE `print_node_conf` TO `shared_print_node_conf`;
RENAME TABLE `print_page_counter` TO `shared_print_page_counter`;
RENAME TABLE `profile_fields` TO `shared_profile_fields`;
RENAME TABLE `profile_values` TO `shared_profile_values`;
RENAME TABLE `role` TO `shared_role`;
RENAME TABLE `search_dataset` TO `shared_search_dataset`;
RENAME TABLE `search_index` TO `shared_search_index`;
RENAME TABLE `search_node_links` TO `shared_search_node_links`;
RENAME TABLE `search_total` TO `shared_search_total`;
RENAME TABLE `semaphore` TO `shared_semaphore`;
RENAME TABLE `sessions` TO `shared_sessions`;
RENAME TABLE `smileys` TO `shared_smileys`;
RENAME TABLE `system` TO `shared_system`;
RENAME TABLE `term_data` TO `shared_term_data`;
RENAME TABLE `term_hierarchy` TO `shared_term_hierarchy`;
RENAME TABLE `term_node` TO `shared_term_node`;
RENAME TABLE `term_relation` TO `shared_term_relation`;
RENAME TABLE `term_synonym` TO `shared_term_synonym`;
RENAME TABLE `trigger_assignments` TO `shared_trigger_assignments`;
RENAME TABLE `upload` TO `shared_upload`;
RENAME TABLE `url_alias` TO `shared_url_alias`;
RENAME TABLE `users` TO `shared_users`;
RENAME TABLE `users_roles` TO `shared_users_roles`;
RENAME TABLE `variable` TO `shared_variable`;
RENAME TABLE `vocabulary` TO `shared_vocabulary`;
RENAME TABLE `vocabulary_node_types` TO `shared_vocabulary_node_types`;
RENAME TABLE `watchdog` TO `shared_watchdog`;
RENAME TABLE `xmlsitemap` TO `shared_xmlsitemap`;
RENAME TABLE `xmlsitemap_node` TO `shared_xmlsitemap_node`;
RENAME TABLE `xmlsitemap_taxonomy` TO `shared_xmlsitemap_taxonomy`;

Thank you kindly for your help

Footnotes

<?php
/**
* Database settings:
*
* [...]
*
* You can optionally set prefixes for some or all database table names
* by using the $db_prefix setting. If a prefix is specified, the table
* name will be prepended with its value. Be sure to use valid database
* characters only, usually alphanumeric and underscore. If no prefixes
* are desired, leave it as an empty string ''.
*
* To have all database names prefixed, set $db_prefix as a string:
*
*   $db_prefix = 'main_';
*
* To provide prefixes for specific tables, set $db_prefix as an array.
* The array's keys are the table names and the values are the prefixes.
* The 'default' element holds the prefix for any tables not specified
* elsewhere in the array. Example:
*
*   $db_prefix = array(
*     'default'   => 'main_',
*     'users'     => 'shared_',
*     'sessions'  => 'shared_',
*     'role'      => 'shared_',
*     'authmap'   => 'shared_',
*   );
*
* [...]
*/
?>

End of footnotes