Changing the Database Table Prefix
I'd like to run multiple installations of Vanilla on my server, but I only have one mySQL database.
I edited the mysql files to create differently named sets of tables. But I can't find anywhere to tell Vanilla to use a different prefix.
Is there any way to change the table prefix of either 0.9.2 or version 1? From LUM_ to something else?
Well I just found the last time I asked this. Mark said then it would be an option in the next version, but I can't see where this option is.
I edited the mysql files to create differently named sets of tables. But I can't find anywhere to tell Vanilla to use a different prefix.
Is there any way to change the table prefix of either 0.9.2 or version 1? From LUM_ to something else?
Well I just found the last time I asked this. Mark said then it would be an option in the next version, but I can't see where this option is.
0
This discussion has been closed.
Comments
$Configuration['DATABASE_TABLE_PREFIX'] = 'whatever';
$DatabaseTables['User'] = 'LUM_User';
also?
It *is* defined in appg/database.php *WITH* the LUM_ prefix.
The SqlBuilder object doesn't add any prefix to the user table.
This is done so that you can explicitly define a user table with a name other than "LUM_User".
So, if you were going to integrate Vanilla's user table with your TennisShoeWarehouse database, you could open up your conf/database.php and add this:
$DatabaseTables['User'] = 'TennisShoeWarehouseUsers';