How to set up multiple tables in one sql database

[oliverzk]

My host only allows one sql database, in which I've already installed two forums and several weblogs. I plan to set up multiple stores for some of my best users. So how can I set prefix to OSC tables to make sure they won't mingle with each other?

 

I tried to add prefix to all OSC tables manually in phpMyAdmin, then I changed all entries in '/includes/database_tables.php' accordingly. For example, I changed the table 'configuation' to 'shopping_configuation' in both phpMyAdmin and database_tables.php. However, I still get the following error message:

 

1146 - Table 'web0meet.configuration' doesn't exist

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

 

Did I miss anything? Do I need to modify the two configure.php files as well? If so, how? I've set everything such as DB_SERVER, USERNAME, PASSWORD, DB_DATABASE according to the requirements of my hosting server. However, I don't quite understand the function of the last one: STORE_SESSIONS.

 

I'm not so good at PHP so your detailed instructions are highly appreciated!