Re: [PHP] How to alter the schema of a database to introducenewfeatures or change the current features

2010-07-15 Thread Pete Ford
On 15/07/10 09:14, Ashley Sheridan wrote: ALTER TABLE is the way to go. If in doubt, look at the SQL phpMyAdmin produces when you make the changes in there. Thanks, Ash http://www.ashleysheridan.co.uk Yeah, scripting ALTER TABLE commands ... :) -- Peter Ford, Developer

RE: [PHP] How to alter the schema of a database to introducenewfeatures or change the current features

2010-07-15 Thread Bob McConnell
From: Pete Ford On 15/07/10 09:14, Ashley Sheridan wrote: ALTER TABLE is the way to go. If in doubt, look at the SQL phpMyAdmin produces when you make the changes in there. Yeah, scripting ALTER TABLE commands ... :) We maintain two files for every schema, site_schema.pgsql and

Re: [PHP] How to alter the schema of a database to introducenewfeatures or change the current features

2010-07-15 Thread Richard Quadling
On 15 July 2010 13:29, Bob McConnell r...@cbord.com wrote: From: Pete Ford On 15/07/10 09:14, Ashley Sheridan wrote: ALTER TABLE is the way to go. If in doubt, look at the SQL phpMyAdmin produces when you make the changes in there. Yeah, scripting ALTER TABLE commands ... :) We maintain