Posted by DynV on May 25, 2012 at 12:01am
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_',
);
?>'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