[ic] how to add prefix to all SQL table names

Matt Brown interchange-users@interchange.redhat.com
Thu Jun 6 18:13:02 2002


I'm stuck. I can't figure out how to change the names of all the SQL tables 
(using MySQL) for a particular catalog installation. I've got a virtual 
hosting situation where Interchange is sharing a databases with other apps, 
and I'd like to be able to add a prefix to all the interchange SQL table 
names. So I'd end up with table names like ic_procucts, ic_userdb, ic_state, 
ic_pricing, etc. etc. I've seen how to change the table name for products, 
and how to add an arbitrary table, but I can't figure out how to change the 
names of the default tables. I'm just not getting it. Can anybody help??

Matt Brown