Re: How to alter the schema of a database to introduce new features or change the current features

On Wed, Jul 14, 2010 at 09:28:53PM -0700, Slith One wrote: > I'm developing an app using Zend Framwork using Git for version control. > > What is the best approach for updating the schema and the database > when one of us makes an update to the db structure? > > currently, we have to blow out the tables and recreate them manually > to reflect the new updates. I'm probably being naive, but don't you have an ALTER TABLE sql statement available to you? Also, for what it's worth, I don't build tables manually (at the command line or whatever). I always create a script which will build the tables I need. If, for some crazy reason, I do have to restart from scratch, it's a simple matter to alter that script and re-run it. Paul -- Paul M. Foster