Changeset 24725 for trunk/dbconfig/changes.txt

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/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1196 +1196 @@
 
 ALTER TABLE camRun ADD COLUMN magicked BIGINT;
+
+ALTER TABLE distTarget CHANGE COLUMN obs_mode label VARCHAR(64);
+ALTER TABLE distTarget ADD COLUMN filter VARCHAR(64) AFTER label;
+ALTER TABLE distTarget DROP KEY clean;
+ALTER TABLE distTarget ADD CONSTRAINT UNIQUE(label, filter, stage, clean);