Changeset 25851 for trunk/ippTools/share

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/ippTools/share

Files:

• Makefile.am (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (1 diff)
• pxadmin_drop_tables.sql (modified) (1 diff)
• pxadmin_update_version.sql (added)

trunk/ippTools/share/Makefile.am

@@ -216 +216 @@
      pxadmin_create_mirror_tables.sql \
      pxadmin_drop_tables.sql \
+     pxadmin_update_version.sql \
      pubtool_definerun.sql \
      pubtool_pending.sql \

trunk/ippTools/share/pxadmin_create_tables.sql

@@ +1 @@
+CREATE TABLE dbversion (
+    schema_version VARCHAR(64),
+    updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
 CREATE TABLE pzDataStore (
     camera VARCHAR(64),

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -1 +1 @@
 SET FOREIGN_KEY_CHECKS=0;
 
+DROP TABLE IF EXISTS dbversion;
 DROP TABLE IF EXISTS pzDataStore;
 DROP TABLE IF EXISTS summitExp;