trigger on cvs update / How to handle changes in sql schema?

[Janning Vygen]

Hi,

a web site and its SQL schema is managed with CVS and has multiple 
developers. Each developer has its own testserver. So he can 
checkout, test and commit changes. 
The production database can be mirrored to the testserver with a 
provided shell script. So you can use real data on your testserver.
so far so good.

if one developer wants to change the database schema, he changes the 
schema sql files in directory src/sql. He will also write a file 
update.sql which can be used to sync old databases with the new 
schema.

He tests it and it works so he does a 'cvs commit'.( but its not yet 
installed on production server)

Another user does 'cvs update' and keeps developing. Now he has new 
schema and new Files but still the old mirrored production database 
which doesnt fit. He could run update.sql manually.

I would like to have a trigger on a cvs update command on a certain 
file which calls a shell script which does the following:
- mirror production database
- run update.sql

Later you can run an install script to install new site and new sql 
schema on production server and database. This script should run 
update.sql on production server and calls echo -n > 'update.sql' to 
truncate the update file and should do a cvs commit on update.sql.

After installing every user can do a cvs update and it will cause the 
production database to be mirrored and it will run an empty 
update.sql against it. 

so i need a trigger on 'cvs update' 
OR
somebody helps me with a much finer solution for problems of that 
kind.

I read cvs doku but only found loginfo, commitinfo and so on.

regards 
janning

-- 
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de