Index: branches/czw_branch/20130211/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- branches/czw_branch/20130211/ippTools/share/pxadmin_create_tables.sql	(revision 35143)
+++ branches/czw_branch/20130211/ippTools/share/pxadmin_create_tables.sql	(revision 35144)
@@ -521,4 +521,5 @@
     deteff_uq FLOAT,
     quality SMALLINT NOT NULL DEFAULT 0,
+    background_model SMALLINT,
     PRIMARY KEY(cam_id),
     KEY(fault),
@@ -1843,6 +1844,5 @@
     data_group VARCHAR(64),           -- group for data
     dist_group VARCHAR(64),           -- group for distribution
-    reduction VARCHAR(64),            -- reduction class (for altering recipe)
-    alt_cam_label VARCHAR(64),        -- label for alternate version of astrometry (optional)
+    reduction VARCHAR(64),    -- reduction class (for altering recipe)
     note VARCHAR(255),        -- note
     registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time run was registered
@@ -2162,11 +2162,9 @@
     surveyID    INT(8),
     releaseName VARCHAR(64),
-    relase_state VARCHAR(16),   -- active, pending, archive, drop 
+    state       VARCHAR(16),    -- active, pending archive drop 
     dataRelease INT(8),         -- PSPS dataRelease
-    priority    INT(8),
     PRIMARY KEY(rel_id),
     KEY(releaseName),
     KEY(state),
-    KEY(priority),
     FOREIGN KEY(surveyID) REFERENCES survey(surveyID)
 ) ENGINE=Innodb DEFAULT CHARSET=latin1;
@@ -2194,29 +2192,5 @@
 ) 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;
-
-
-
--- These comment lines are here to avoid an empty query error.
+
+-- This comment line is here to avoid empty query error.
 -- Another way to avoid that problem is to omit the semicolon above but I think that is untidy.
Index: branches/czw_branch/20130211/ippTools/share/warptool_scmap.sql
===================================================================
--- branches/czw_branch/20130211/ippTools/share/warptool_scmap.sql	(revision 35143)
+++ branches/czw_branch/20130211/ippTools/share/warptool_scmap.sql	(revision 35144)
@@ -5,4 +5,5 @@
     camProcessedExp.path_base as cam_path_base,
     camProcessedExp.fault as cam_fault,
+    camProcessedExp.background_model AS cam_background_model,
     chipProcessedImfile.chip_id,
     chipRun.state,