Hopefully I can explain this properly. First I've outlined my setup and below that is the question.
-----SETUP------
System Specs
--Plesk 8
--Cent OS
--php 5
--Mysql 5
--Apache 2
--Drupal 5
DNS setup
--*.domainname.com
I am setting up two website on a single installation and single database. I am planning on expanding the number of websites using that installation to 10. For now, I would like all tables to be shared between the two sites except for the variable table which stores unique elements like theme. My sites folder is setup as such:
sites/default
sites/domainname.com
sites/subdomain1.domainname.com
default settings.php database prefix settings
$db_prefix = '';
domainname.com settings.php database prefix settings
$db_prefix = array(
'default' => '',
'variable' => 'domainname_',
)
subdomain1.domainname.com settings.php database prefix settings
$db_prefix = array(
'default' => '',
'variable' => 'subdomain1_',
)
-----QUESTION/PROBLEM-----