Changeset 27781

Timestamp:

Apr 27, 2010, 11:08:54 AM (16 years ago)

Author:

bills

Message:

changes to pstampDependent

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1591 +1591 @@
 ALTER TABLE pstampDependent ADD COLUMN component VARCHAR(64) after stage_id;
 ALTER TABLE pstampDependent CHANGE COLUMN no_magic need_magic TINYINT;
+ALTER TABLE pstampDependent ADD COLUMN fault SMALLINT after need_magic;
+ALTER TABLE pstampDependent ADD KEY (state);
+ALTER TABLE pstampDependent ADD KEY (stage);
+ALTER TABLE pstampDependent ADD KEY (stage_id);
 
 ALTER TABLE magicDSRun ADD KEY(stage);

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1333 +1333 @@
         rlabel     VARCHAR(64),
         need_magic TINYINT,
-        PRIMARY KEY(dep_id)
+        PRIMARY KEY(dep_id),
+        KEY(state),
+        KEY(stage),
+        KEY(stage_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;