Changeset 27764 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

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

Author:

Paul Price

Message:

Key/index additions for distribution tables.

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

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;