Database upgrade strategy

[creepone]

Current strategy of dealing with data is to drop and recreate the database manually when necessary. We need a way to upgrade it automatically depending on its schema version.

This could be a script that compares the version of the database, determines a set of scripts that are relevant for the upgrade (e.g. based on a naming convention) and executes them. Each schema change in the code would then be represented by a script that can make the assumption of running on a certain version of the database while transforming it.