Changeset 24951 for branches/czw_branch/cleanup/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Jul 30, 2009, 5:20:29 PM (17 years ago)

Author:

watersc1

Message:

Finished up my edits to the detrend cleanup, and some changes to my
copy of burntool and the pslib astrometry. Detrend cleanup has not
been tested yet. That's up next.

Location:

branches/czw_branch/cleanup

Files:

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

branches/czw_branch/cleanup/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,
     state       VARCHAR(64),
     comment     VARCHAR(255),
-    PRIMARY KEY(target_id)
+    PRIMARY KEY(target_id),
+    CONSTRAINT UNIQUE (label, filter, stage, clean)
 )  ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -1282 +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;