Changeset 34772 for branches/czw_branch/20120906/dbconfig

Timestamp:

Dec 6, 2012, 6:32:19 PM (14 years ago)

Author:

watersc1

Message:

merge from trunk. Preliminary versions of stacktool/warptool updates and regenerate_background.pl script. The warp code is finished and tested, and I still need to get the stack version resolved.

Location:

branches/czw_branch/20120906/dbconfig

Files:

• changes.txt (modified) (1 diff)
• stack.md (modified) (1 diff)
• staticsky.md (modified) (1 diff)
• warp.md (modified) (1 diff)

branches/czw_branch/20120906/dbconfig/changes.txt

@@ -2255 +2255 @@
 --update addRun set stage_extra1 = -1 where stage = 'cam' <= 483624; 
 
+ALTER TABLE warpSkyfile add column background_model SMALLINT after maskfrac_advisory;
+ALTER TABLE stackSumSkyfile add column background_model SMALLINT after software_ver;
+
+ALTER TABLE skycalResult ADD column n_detections INT after n_astrom;
+ALTER TABLE skycalResult ADD column n_extended INT after n_detections;
+
+UPDATE dbversion set schema_version = '1.1.72', updated= CURRENT_TIMESTAMP();

branches/czw_branch/20120906/dbconfig/stack.md

@@ -53 +53 @@
     fault              S16    0       # Key
     software_ver    STR         16
+    background_model   S16    0
     quality            S16    0
 END

branches/czw_branch/20120906/dbconfig/staticsky.md

@@ -54 +54 @@
     sigma_dec      F32    0.0
     n_astrom       S32    0
+    n_detections   S32    0
+    n_extended     S32    0
     zpt_obs        F32    0.0
     zpt_stdev      F32    0.0

branches/czw_branch/20120906/dbconfig/warp.md

@@ -74 +74 @@
     maskfrac_magic  F32     0.0
     maskfrac_advisory F32   0.0
+    background_model  S16   0
 END