iansears Posted December 4, 2002 Share Posted December 4, 2002 Certainly, we can edit each individual table name in application_top.php, and then edit every instance of it over in the whatever.sql text file prior to loading it into a database.. But didn't there used to be a $prefix entry in each call to a database table name, and a corresponding definition defined in configure.php? Is my memory failing me or was this removed? Something like: define('$prefix', 'shop3_'); OR define('$prefix', 'asparagus_'); Ian Link to comment Share on other sites More sharing options...
firehorse Posted December 30, 2002 Share Posted December 30, 2002 An excellent idea. My host only provides 1 db so it would be nice to keep all the table names separate and avoid clashing with anything that I might want to install in the future. Link to comment Share on other sites More sharing options...
Guest Posted December 30, 2002 Share Posted December 30, 2002 so whats the outcome of this is there a way of adding a prefix to the files as i'm in the same boat and have to change every file over to add shop_ etc in front of all tables. :shock: Link to comment Share on other sites More sharing options...
cannuck1964 Posted December 30, 2002 Share Posted December 30, 2002 Hi there, to set up db table prefixes, which I have currently done can be achieved by adding the prefix onto the db tables, then in the application_top.php file, change the define('TABLE_CUSTOMERS', $prefix_name . '_customers'); add in the prefix_name variable to all of the db table defines, and this will set your db table structure up, now the only problen is ensureing you are getting the right prefix for the tables....or you can hard code it so it will not change..... HTH Cheers, Peter McGrath ----------------------------- See my Profile (click here) for more information and to contact me for professional osCommerce support that includes SEO development, custom development and security implementation Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.