add 'MV_VERSION' table with version info in it

[dwfncar]

From Kirk:


you might want to consider adding an 'MV_VERSION' table such as:

CREATE TABLE MV_VERSION
(
    mv_versionVARCHAR(8) NOT NULL PRIMARY KEY,
    release_date DATETIME NOT NULL,
    updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE = MyISAM;

INSERT INTO MV_VERSION (mv_version, release_date) VALUES( '2.2',
'2017-10-11 15:00:00' );

This would allow for automatic updating of mv databases during the
installation process since the schema version would now be embedded in
each database.

[MET-887] created by tatiana

[dwfncar]

Moved to GitHub. #21
by lisag