From: Paul M Foster on
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 M. Foster