Original data:
1) web app in php (well, it does not matter what language), lying in git (or other CVS)
2) MySQL database
3) All SQL code stored in the database as stored procedures.
How to synchronize application code and database schema and stored procedures?
Procedures matter of course is easier — you can each procedure put in a separate file that is tracked in git (or other CVS)
But what about the table structure? Generates handles for each change of ALTER TABLE and put them in separate files — time consuming.
Maybe there are some utilities that do it automatically, a La Oracle Database Version Control?
I want to have the option when upgrading the application to execute one sql script that updates the database. Unless of course it's possible.