Changeset 27764 for trunk/dbconfig

Timestamp:

Apr 23, 2010, 3:07:25 PM (16 years ago)

Author:

Paul Price

Message:

Key/index additions for distribution tables.

File:

• trunk/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1592 +1592 @@
 ALTER TABLE pstampDependent CHANGE COLUMN no_magic need_magic TINYINT;
 
-ALTER TABLE magicDSRun ADD KEY (stage);
-ALTER TABLE magicDSRun ADD KEY (stage_id);
-
-
+ALTER TABLE magicDSRun ADD KEY(stage);
+ALTER TABLE magicDSRun ADD KEY(stage_id);
+
+ALTER TABLE distRun ADD KEY(stage), ADD KEY(stage_id), ADD KEY(magic_ds_id), ADD KEY(fault), ADD KEY(data_group);
+ALTER TABLE distTarget ADD KEY(stage), ADD KEY(dist_group), ADD KEY(filter), ADD KEY(state);
+