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

Timestamp:

Jul 8, 2009, 6:16:07 PM (17 years ago)

Author:

bills

Message:

change distTarget.obs_mode to distTarget.label add filter require that
label, filter, stage, cleaned be unique

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1214 +1214 @@
 CREATE TABLE distTarget (
     target_id   BIGINT AUTO_INCREMENT,
-    obs_mode    VARCHAR(64),
+    label       VARCHAR(64),
+    filter      VARCHAR(64),
     stage       VARCHAR(64),
     clean       TINYINT,
@@ -1220 +1221 @@
     comment     VARCHAR(255),
     PRIMARY KEY(target_id)
+    CONSTRAINT UNIQUE (label, filter, stage, clean),
 )  ENGINE=innodb DEFAULT CHARSET=latin1;