support database schema upgrades

[GoogleCodeExporter]

Yubiserve ideally needs a way to support database versions, to allow schema 
upgrades.

Maybe one of the tools listed here:

http://stackoverflow.com/questions/3923280/can-you-recommend-a-database-schema-m
igration-tool-that-is-not-tied-to-a-particu

Or: 
https://sqlalchemy-migrate.readthedocs.org/en/latest/index.html

might work.
Or something simple, like 

Original issue reported on code.google.com by glen.ogilvie@gmail.com on 20 Mar 2013 at 10:32

[GoogleCodeExporter]

Maybe it could not be the best solution but, since the tool should be 
lightweight, we could just add a database version (an integer) into it and a 
tool/script that when called do all the updates. (Your message is not complete, 
"something simple, like"?)

Original comment by b1ga...@gmail.com on 21 Mar 2013 at 2:09

[GoogleCodeExporter]

I agree that it should be a lightweight solution.  The ones listed above are 
just some ideas to start with.  I do think that schema upgrades are something 
that are common to many projects, so not inventing our own makes some sense.  
Maybe the a module for python somewhere that does this sort of thing?

Original comment by glen.ogilvie@gmail.com on 22 Mar 2013 at 2:06