Simple script to manage the release from Subersion to site process, and create a version file _vni_ that simply contains the current release version information for easy display by including into PHP (or via whatever other include method is available).
#!/bin/ksh svn update svn status svn info | awk -f make-vers.awk # mysql -uroot <mysql\ databases/db-create.sql
Database version control has been something that used to cause me problems, a lot of problems, because it wasn't within the normal controlled sources. This had to change - and it isn't something that is easy to do as it requires discipline because the databases don't really integrate with any source control system. (Correct me if I'm wrong - I'll be very pleased).