Changeset 35144 for branches/czw_branch/20130211/dbconfig/changes.txt

Timestamp:

Feb 11, 2013, 2:06:32 PM (13 years ago)

Author:

watersc1

Message:

background continuity changes.

File:

• branches/czw_branch/20130211/dbconfig/changes.txt (modified) (3 diffs)

branches/czw_branch/20130211/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
@@ -2285 +2282 @@
     surveyID    INT(8),
     releaseName VARCHAR(64),
-    release_state VARCHAR(16),    -- active, pending archive drop 
+    state       VARCHAR(16),    -- active, pending archive drop 
     dataRelease INT(8),         -- PSPS dataRelease
     PRIMARY KEY(rel_id),
@@ -2315 +2312 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
-CREATE TABLE relStack (
-    relstack_id BIGINT AUTO_INCREMENT,
-    rel_id      INT(8),
-    skycal_id   BIGINT,         -- id of the sky calibration run that supplied the calibration
-                                -- for this release. We get back to stack from here
-    skycell_id  varchar(64),
-    tess_id     varchar(64),
-    state       VARCHAR(16),    -- released, pending, archive, drop  
-    flags       INT UNSIGNED,
-    stack_type  VARCHAR(16),    -- nightly, deep, reference
-    zpt_obs     FLOAT,          -- calibrated zero point for this release of this skycell
-    zpt_stdev   FLOAT,
-    fwhm_major  FLOAT,          -- seeing as measured by staticsky
-    path_base   VARCHAR(255),   -- path_base of any supporting files,
-    registered  DATETIME,
-    time_stamp  DATETIME,
-    PRIMARY KEY (relstack_id),
-    KEY (tess_id, skycell_id),
-    KEY (rel_id, tess_id, skycell_id),
-    FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
-    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
-) ENGINE=innodb DEFAULT CHARSET=latin1;
-
-ALTER TABLE warpBackgroundRun ADD COLUMN alt_cam_label VARCHAR(255) AFTER reduction;
-
+UPDATE dbversion set schema_version = '1.1.74', updated= CURRENT_TIMESTAMP();
+
+-- Update camProcessedExp to hold a background_model value
+
+ALTER TABLE camProcessedExp add column background_model SMALLINT after quality;
 UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();
+