Changeset 35134 for trunk/dbconfig

Timestamp:

Feb 8, 2013, 11:50:49 AM (13 years ago)

Author:

bills

Message:

For warp_bg stage add column alt_cam_label. If set use the smf file
from that cam run for the astrometry. This is intended to be a
camRun with the nomal backckground subtraction.

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/background.md

@@ -48 +48 @@
     dist_group          STR     64
     reduction           STR     64
+    alt_cam_label       STR     64
     note                STR     255
     registered          TAI     NULL

trunk/dbconfig/changes.txt

@@ -2266 +2266 @@
 UPDATE dbversion set schema_version = '1.1.73', updated= CURRENT_TIMESTAMP();
 
+ALTER TABLE warpBackgroundRun ADD COLUMN alt_cam_label VARCHAR(255) AFTER reduction;
+
+UPDATE dbversion set schema_version = '1.1.74', updated= CURRENT_TIMESTAMP();
 
 -- new tables for managing the "release" of ipp data
@@ -2335 +2338 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-UPDATE dbversion set schema_version = '1.1.74', updated= CURRENT_TIMESTAMP();
+ALTER TABLE warpBackgroundRun ADD COLUMN alt_cam_label VARCHAR(255) AFTER reduction;
+
+UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();