Changeset 27763 for trunk/dbconfig

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.

File:

• trunk/dbconfig/changes.txt (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);
+
+