> what is the best approach to assign a version to the database.
> Let's say it's starts with 1.0.1.1 then 1.0.1.2.. etc,,
> I'm looking at storing it with the DB itself. Is there a way to
> store it and read it from system variables?..
> I wanted to use a DB field but it sounds too much for what I want to accomplish.

I use plain integers (1, 2, 3, ...) as schema version numbers and
store them in a table (with a key and value column) that I also use
for other general settings.


Regards

Stefan