Changeset 17776 for trunk/dbconfig/tasks.md

Timestamp:

May 22, 2008, 11:17:33 AM (18 years ago)

Author:

jhoblitt

Message:

add INDEX UNIQUE(exp_id, tmp_class_id) to rawImfile

File:

• trunk/dbconfig/tasks.md (modified) (2 diffs)

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.150 2008-05-13 22:04:17 jhoblitt Exp $
+# $Id: tasks.md,v 1.151 2008-05-22 21:17:33 jhoblitt Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -159 +159 @@
 rawImfile METADATA
     exp_id      S64         64      # Primary Key fkey(exp_id, tmp_class_id) ref newImfile(exp_id, tmp_class_id)
-    exp_name    STR         64
+    exp_name    STR         64      # UNIQUE(exp_id, tmp_class_id)
     camera      STR         64
     telescope   STR         64