Changeset 24725 for trunk/dbconfig

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

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• dist.md (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);

trunk/dbconfig/dist.md

@@ -1 +1 @@
 distTarget METADATA
     target_id   S64        0       # Primary Key
-    obs_mode    STR        64
+    label       STR        64
+    filter      STR        64
     stage       STR        64
     clean       BOOL       f