Changeset 25851 for trunk/dbconfig/changes.txt

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.

File:

• trunk/dbconfig/changes.txt (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();