Changeset 27764

Timestamp:

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

Author:

Paul Price

Message:

Key/index additions for distribution tables.

Location:

trunk

Files:

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

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);
+

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1345 +1345 @@
     comment     VARCHAR(255),
     PRIMARY KEY(target_id),
+    KEY(stage),
+    KEY(dist_group),
+    KEY(filter),
+    KEY(state),
     CONSTRAINT UNIQUE (dist_group, filter, stage, clean)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
@@ -1368 +1372 @@
     KEY(state),
     KEY(label),
+    KEY(stage),
+    KEY(stage_id),
+    KEY(magic_ds_id),
+    KEY(fault),
+    KEY(data_group),
     FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;