Changeset 32999 for trunk/ippTools

Timestamp:

Dec 22, 2011, 9:43:44 AM (15 years ago)

Author:

bills

Message:

add key(state) and changed order of the keys to match the current gpc1 database

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -190 +190 @@
     magicked BIGINT,
     PRIMARY KEY(exp_id),
+    KEY(end_stage),
+    KEY(fault),
+    KEY(state),
     KEY(exp_name),
-    KEY(end_stage),
-    KEY(fault),
     FOREIGN KEY(exp_id) REFERENCES newExp(exp_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;