You are here:  » Adding new database tables on setup

Support Forum



Adding new database tables on setup

Submitted by paddyman on Thu, 2007-09-27 20:28 in

Hi David,

Have searched the forum but was unable to find a similar question.

Where would I add a new table name and respective field names in the installation files, so that the new table would be added to the database when setup.php is run? I have a few new tables added manually to my database but now that I am using sub-directories it would be much easier for the new tables to be added automatically on installation of PT to a new sub-directory. Can't find the file to modify.

Thanks

Adrian

Submitted by support on Thu, 2007-09-27 22:24

Hi Adrian,

The file you want is setup.sql.

If you're not sure what format to copy in the SQL for your tables, the easiest thing to do (and is how setup.sql was created in the first place) is to use phpMyAdmin to export the table (structure only) - and that will give you the table creation SQL to insert into setup.sql...

Hope this helps!
Cheers,
David.

Submitted by paddyman on Fri, 2007-09-28 14:32

Should have been obvious !!

Thanks for that. Enjoy the weekend.

Adrian