Changeset 17657

Timestamp:

May 13, 2008, 12:04:17 PM (18 years ago)

Author:

jhoblitt

Message:

add index to rawImfile.exp_name

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -147 +147 @@
 ALTER TABLE summitExp ADD COLUMN fault smallint(6) NOT NULL AFTER imfiles;
 ALTER TABLE summitExp ADD KEY(fault);
+
+### 1.1.34
+ALTER TABLE rawImfile ADD KEY(exp_name);

trunk/dbconfig/config.md

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

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.149 2008-05-08 01:45:23 jhoblitt Exp $
+# $Id: tasks.md,v 1.150 2008-05-13 22:04:17 jhoblitt Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -100 +100 @@
 rawExp METADATA
     exp_id      S64         64      # Primary Key fkey(exp_id) ref newExp(exp_id)
-    exp_name    STR         64
+    exp_name    STR         64      # Key
     camera      STR         64
     telescope   STR         64