<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=283081217-29082006><FONT face=Arial
color=#0000ff size=2>Checking the search for multisite table prefix, <A
href="http://drupal.org/search/node/multisite+table+prefix">http://drupal.org/search/node/multisite+table+prefix</A>,
you can find a few examples.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=283081217-29082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=283081217-29082006><FONT face=Arial
color=#0000ff size=2>Specifically see this page,http://drupal.org/node/22267. I
believe you will need to reverse your thinking and make the default ->
'site1', and then list all the shared tables.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=283081217-29082006></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>G<SPAN
class=283081217-29082006>reg</SPAN></FONT></FONT></FONT><BR></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> support-bounces@drupal.org
[mailto:support-bounces@drupal.org] <B>On Behalf Of </B>VJ Rao<BR><B>Sent:</B>
Tuesday, August 29, 2006 10:02 AM<BR><B>To:</B> support@drupal.org;
development@drupal.org<BR><B>Subject:</B> [support] Re:
multisite<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>I am using 4.7.3 btw. I understand this means I have to share the menu
table (for different primary links). Anything else?</DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV>V<BR><BR> </DIV>
<DIV><SPAN class=gmail_quote>On 8/28/06, <B class=gmail_sendername>VJ Rao</B>
<<A href="mailto:cmsconsultant@gmail.com">cmsconsultant@gmail.com</A>>
wrote:</SPAN>
<BLOCKQUOTE class=gmail_quote
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<DIV>
<DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>If I want to share users and data across multiple sites (If there is any
need for control, I plan to use TAC) ..which tables should I create as unique
for each website (i.e with prefix)?</DIV>
<DIV> </DIV>
<DIV>I can think of 'variable' . Does any other table need a prefix?</DIV>
<DIV> </DIV>
<DIV>If not, I can just do :</DIV>
<DIV> </DIV>
<DIV>$db_prefix = array(<BR>
'default' => '',</DIV>
<DIV> 'variable' => 'site1_'</DIV>
<DIV>);</DIV>
<DIV>in sites/site1/settings.php..</DIV>
<DIV>right?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV> </DIV>
<DIV>V</DIV>
<DIV> </DIV>
<DIV>p.s I dont use left navigation</DIV>
<DIV> </DIV></DIV></BLOCKQUOTE></DIV><BR></BODY></HTML>