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 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 mai

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 s

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 pho