Store current db schema version in db

This is a forum to suggest new features for mojoPortal. 

This thread is closed to new posts. You must sign in to post in the forums.
12/4/2006 5:03:11 AM
Alexander V. Yushchenko
Gravatar
Total Posts 488
View Posts

Re: Store current db schema version in db

It would be nice to add current schema version to the database and to check it on startup.

For example, you can add a table "mp_PortalSettings" with the field SchemaVersion and the only record in it.
In case curent db version does not correspond to one required by the code, an exception can be thrown (like "please, run upgrade scripts from ...").
At the next step, even automatic upgrade is possible. :)
12/4/2006 1:00:01 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Store current db schema version in db

Yes this is what I have planned. I will add the new table in the next version that has other schema changes. Automatic upgrade is the longer term plan, but I will get the version table in there in the next version that has other schema changes, probably the release after this coming release.

Thanks,

Joe
You must sign in to post in the forums. This thread is closed to new posts.