Changeset 25851 for trunk/ippTools/share/pxadmin_drop_tables.sql

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/ippTools/share/pxadmin_drop_tables.sql (modified) (1 diff)

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;