Changeset 27763

Timestamp:

Apr 23, 2010, 3:00:45 PM (16 years ago)

Author:

Paul Price

Message:

Add key/index to magicDSRun to make it go faster for cleanup.

Location:

trunk

Files:

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

trunk/dbconfig/changes.txt

@@ -1589 +1589 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-
 ALTER TABLE pstampDependent ADD COLUMN component VARCHAR(64) after stage_id;
 ALTER TABLE pstampDependent CHANGE COLUMN no_magic need_magic TINYINT;
 
+ALTER TABLE magicDSRun ADD KEY (stage);
+ALTER TABLE magicDSRun ADD KEY (stage_id);
+
+

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1175 +1175 @@
         KEY(label),
         KEY(fault),
+        KEY(stage),
+        KEY(stage_id),
         FOREIGN KEY(magic_id) REFERENCES magicRun(magic_id),
         FOREIGN KEY(inv_magic_id) REFERENCES magicRun(magic_id)