The tables you want to share depends on what is the kind of information that you want to share between the sites. Is the content shared? Is the user database and session shared? Is the theme shared? Sequence table stores the unique ids created in user, menu, vocabulary,... tables.
name id users_uid 5 menu_mid 57 vocabulary_vid 1 term_data_tid 2 node_nid 11 node_revisions_vid 11 files_fid 4
Shyamala
----- Original Message ----- From: "Xavier Bestel" xavier.bestel@free.fr To: support@drupal.org Sent: Thursday, January 10, 2008 3:55 PM Subject: Re: [support] Multisite on same database
Hi,
ok, now I understand better how it works. However, I don't really know which tables will need to be separated. What's the purpose of {sessions} and {sequences} ? Is there a place where I can quickly lear about them, in order to know which ones to unshare ?
For now, I have unshared {menu}, {panels_info} and {panels_area}, and I have special variables for site_name, site_slogan, theme and front_*.
Thanks, Xav
On Wed, 2008-01-09 at 23:19 -0200, Alessandro Feijó wrote:
I think with Views & Taxonomy its possible, maybe you will wanna use Panels module too
You'll have a lot of config to do, several days, but when done, will be nice :)
Are you intimate with settings.php? You can chose with tables will be generic or to each site. Look at $db_prefix.
i.e.
$db_prefix = array( 'sessions' => 'siteA_', 'sequences' => 'siteA_', 'menu' => 'siteA_', 'url_alias' => 'siteA_', );
based on what you wrote, at least those 4 tables you will need to have one for each site.
Feijó
----- Original Message ----- From: "Xavier Bestel" xavier.bestel@free.fr To: support@drupal.org Sent: Wednesday, January 09, 2008 6:13 PM Subject: [support] Multisite on same database
Hi,
I'd like to have a particular setup:
- 3 sites called A.com, B.com and C.com
- all running the same drupal 5 install, with the same nodes
- all 3 with a different theme
- all 3 with a different organisation (different primary links,
frontpage, etc.)
- a mean to "assign" nodes to one or the other site.
I was thinking, maybe using taxonomy and have A.com have all the nodes, then B.com have only the node tagged "B-nodes" and C.com the sites tagged "C-nodes".
Is something like that possible ?
Thanks, Xav
-- [ Drupal support list | http://lists.drupal.org/ ]
