Has there been any talk about not maintaining a monolithic create_schema.sql and doing a more DB migrate style? From a supportability perspective its way easier if your SQL is just always deltas from the last. For example, you ship version 1 and create schema1.sql. Version 2 you add some stuff so you create a schema2.sql that adds what you need to the database (just delta). So if somebody installs from scratch they run schema1.sql and schema2.sql. If you already have version 1, you just run schema2.sql.
This is an extremely common approach and cuts down the need to test the DB from scratch and upgrade. Darren
