Changeset 17776 for trunk/dbconfig

Timestamp:

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

Author:

jhoblitt

Message:

add INDEX UNIQUE(exp_id, tmp_class_id) to rawImfile

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• config.md (modified) (1 diff)
• tasks.md (modified) (2 diffs)

trunk/dbconfig/changes.txt

@@ -150 +150 @@
 ### 1.1.34
 ALTER TABLE rawImfile ADD KEY(exp_name);
+
+### 1.1.35
+ALTER TABLE rawImfile ADD INDEX UNQIUE(exp_id, tmp_class_id);

trunk/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.34
+    pkg_version     STR     1.1.35
 END

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