Changeset 24740

Timestamp:

Jul 9, 2009, 2:47:21 PM (17 years ago)

Author:

bills

Message:

add a constraint to insure that targets are unique

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1284 +1284 @@
     PRIMARY KEY(int_id),
     FOREIGN KEY(dest_id) REFERENCES rcDestination(dest_id),
-    FOREIGN KEY(target_id) REFERENCES distTarget(target_id)
+    FOREIGN KEY(target_id) REFERENCES distTarget(target_id),
+    CONSTRAINT UNIQUE (dest_id, target_id)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;