Changeset 25851 for trunk/dbconfig

Timestamp:

Oct 15, 2009, 11:37:32 AM (17 years ago)

Author:

bills

Message:

Add a new table to the database dbversion where we will store the
schema version number. In -exportrun save the version in the output files.
Then in -importrun insure that the input file version matches the schema.

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• dbversion.md (added)
• ipp.m4 (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1410 +1410 @@
 
 ALTER TABLE rcDestination ADD CONSTRAINT UNIQUE(name);
+
+CREATE TABLE dbversion (
+    schema_version VARCHAR(64),
+    updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+INSERT INTO dbversion VALUES('1.1.56', CURRENT_TIMESTAMP);
+
+
 -- Vesion 1.1.57
+
+-- add changes for 1.1.57 here. Then uncomment the following before commiting
+
+-- UPDATE dbversion set schema_version = '1.1.57',  updated= CURRENT_TIMESTAMP();

trunk/dbconfig/ipp.m4

@@ -9 +9 @@
 dnl include(telescope.md)
 dnl include(skycell.md)
+include(dbversion.md)
 include(summitcopy.md)
 include(new.md)