We need an automated way to update the database, especially for #writeas.org -- but it'll also be helpful for us.
Add an app_config database table with fields similar to user/collection attributes table. Upon app start, SELECT FROM app_config WHERE attribute = 'db_version';
If it isn't there, add it and set it to 1. Otherwise check it against a DB migrations module, and run any necessary migrations.
Also add this version number to schema.sql in the repo.