Changeset 20106

Timestamp:

Oct 13, 2008, 11:57:05 AM (18 years ago)

Author:

eugene

Message:

adding obs_mode, obs_group fields to rawExp, rawImfile (dbconfig now at 1.1.44)

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -635 +635 @@
 
 * 1.1.43
+
+ALTER TABLE rawExp ADD COLUMN obs_mode VARCHAR(64) AFTER comment;
+ALTER TABLE rawExp ADD COLUMN obs_group VARCHAR(64) AFTER obs_mode;
+
+ALTER TABLE rawImfile ADD COLUMN obs_mode VARCHAR(64) AFTER comment;
+ALTER TABLE rawImfile ADD COLUMN obs_group VARCHAR(64) AFTER obs_mode;
+
+* 1.1.44

trunk/dbconfig/config.md

@@ -2 +2 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.43
+    pkg_version     STR     1.1.44
 END

trunk/dbconfig/tasks.md

@@ -1 @@
-# $Id: tasks.md,v 1.155 2008-09-23 20:12:05 eugene Exp $
+# $Id: tasks.md,v 1.156 2008-10-13 21:57:05 eugene Exp $
 
 # this table records all exposure ID ever seen from the summit
@@ -121 +121 @@
     filter      STR         64
     comment     STR         80
+    obs_mode    STR         64      # data usage goal (eg, survey name, engineering, etc)
+    obs_group   STR         64      # identifier for data block (eg, observation sequence)
     airmass     F32         0.0
     ra          F64         0.0
@@ -186 +188 @@
     filter      STR         64
     comment     STR         80
+    obs_mode    STR         64      # data usage goal (eg, survey name, engineering, etc)
+    obs_group   STR         64      # identifier for data block (eg, observation sequence)
     airmass     F32         0.0
     ra          F64         0.0