Index: branches/eam_branches/ipp-20130207/dbconfig/background.md
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/background.md	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/background.md	(revision 35236)
@@ -5,4 +5,5 @@
     chip_bg_id          S64     0
     chip_id             S64     0
+    cam_id              S64     0
     state               STR     64
     workdir             STR     255
Index: branches/eam_branches/ipp-20130207/dbconfig/cam.md
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/cam.md	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/cam.md	(revision 35236)
@@ -118,4 +118,5 @@
     deteff_uq      F32      0
     quality        S16      0
+    background_model  S16   0
 END
 
Index: branches/eam_branches/ipp-20130207/dbconfig/changes.txt
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/changes.txt	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/changes.txt	(revision 35236)
@@ -2267,8 +2267,24 @@
 
 
+-- 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.74', updated= CURRENT_TIMESTAMP();
+
+
+-- Note the following 3 changes were implemented in the ipp-20121218 tag
+-- without changing the schema_version from 1.1.74
+
+-- Add cam_id to chipBackgroundRun
+ALTER TABLE chipBackgroundRun ADD COLUMN cam_id BIGINT DEFAULT 0 AFTER chip_id;
+
+-- add fwhm measuements to skycalResult
+ALTER TABLE skycalResult ADD COLUMN fwhm_major FLOAT AFTER zpt_stdev;
+ALTER TABLE skycalResult ADD COLUMN fwhm_minor FLOAT AFTER fwhm_major;
+
 -- new tables for managing the "release" of ipp data
 
 CREATE TABLE survey (
-    surveyID    INT(8),
+    surveyID    INT,
     surveyName  VARCHAR(16) NOT NULL,
     description VARCHAR(255),
@@ -2277,14 +2293,15 @@
 ) ENGINE=InnoDB CHARSET=latin1;
 
-
 CREATE TABLE ippRelease (
-    rel_id      INT(8) AUTO_INCREMENT,
-    surveyID    INT(8),
-    releaseName VARCHAR(64),
-    release_state VARCHAR(16),    -- active, pending archive drop 
-    dataRelease INT(8),         -- PSPS dataRelease
+    rel_id      INT AUTO_INCREMENT,
+    surveyID    INT,
+    release_name VARCHAR(64),
+    release_state VARCHAR(16),   -- active, pending, archive, drop 
+    dataRelease INT,         -- PSPS dataRelease
+    priority    INT,
     PRIMARY KEY(rel_id),
-    KEY(releaseName),
-    KEY(state),
+    KEY(release_name),
+    KEY(release_state),
+    KEY(priority),
     FOREIGN KEY(surveyID) REFERENCES survey(surveyID)
 ) ENGINE=Innodb DEFAULT CHARSET=latin1;
@@ -2292,14 +2309,16 @@
 CREATE TABLE relExp (
     relexp_id   BIGINT AUTO_INCREMENT,
-    rel_id      INT(8),
+    rel_id      INT,
     exp_id      BIGINT,
     chip_id     BIGINT,         -- links to the runs that supplied the data
     cam_id      BIGINT,         -- for this release
+    group_id    INT,         -- id of relGroup that this exposure is contained in
     state       VARCHAR(16),    -- released, pending, archive, drop  
-    flags       INT UNSIGNED,   -- flags for relphot, relastro, ??
+    flags       INT UNSIGNED,  -- flags for relphot, relastro, ??
     zpt_obs     FLOAT,          -- calibrated zero point for this release of
     zpt_stdev   FLOAT,          -- this exposure
     path_base   VARCHAR(255),   -- path_base of any supporting files for this
                                 -- release of this exposure.
+    fault SMALLINT NOT NULL,
     registered  DATETIME,       -- insertion time for this row
     time_stamp  DATETIME,       -- time of last update for this row
@@ -2307,4 +2326,5 @@
     FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
     KEY (state),
+    KEY (fault),
     FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id),
     FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),
@@ -2314,9 +2334,11 @@
 CREATE TABLE relStack (
     relstack_id BIGINT AUTO_INCREMENT,
-    rel_id      INT(8),
+    rel_id      INT,
+    stack_id    BIGINT,         -- id of the stackRun
     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),
+                                -- for this release of this skycell.
+    skycell_id  VARCHAR(64),
+    tess_id     VARCHAR(64),
+    filter      VARCHAR(16),
     state       VARCHAR(16),    -- released, pending, archive, drop  
     flags       INT UNSIGNED,
@@ -2324,14 +2346,55 @@
     zpt_obs     FLOAT,          -- calibrated zero point for this release of this skycell
     zpt_stdev   FLOAT,
-    fwhm_major  FLOAT,          -- seeing as measured by staticsky
+    mjd_obs     INT UNSIGNED,   -- for nightly stacks the mjd_obs, zero for deep and reference
     path_base   VARCHAR(255),   -- path_base of any supporting files,
+    fault SMALLINT NOT NULL,
     registered  DATETIME,
     time_stamp  DATETIME,
     PRIMARY KEY (relstack_id),
     KEY (tess_id, skycell_id),
-    KEY (rel_id, tess_id, skycell_id),
+    KEY (rel_id, tess_id, skycell_id, filter, mjd_obs),
+    KEY (stack_type),
+    KEY (mjd_obs),
+    KEY (state),
+    KEY (fault),
     FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id),
-    FOREIGN KEY(skycal_id) REFERENCES skycalRun(skycal_id)
-) ENGINE=innodb DEFAULT CHARSET=latin1;
-
-UPDATE dbversion set schema_version = '1.1.74', updated= CURRENT_TIMESTAMP();
+    FOREIGN KEY(stack_id) REFERENCES stackRun(stack_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE relGroup (
+    group_id    INT AUTO_INCREMENT,
+    rel_id      INT,
+    group_type  VARCHAR(16),
+    lap_id      BIGINT,
+    group_name  VARCHAR(16),
+    state       VARCHAR(16),    -- new full
+    label       VARCHAR(64),
+    exp_list_path   VARCHAR(255),
+    fault SMALLINT NOT NULL,
+    registered  DATETIME,
+    PRIMARY KEY (group_id),
+    KEY (rel_id, group_name),
+    KEY (group_type),
+    KEY (lap_id),
+    KEY (group_name),
+    KEY (state),
+    KEY (label),
+    KEY (fault),
+    FOREIGN KEY(rel_id) REFERENCES ippRelease(rel_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+-- new table grouping multi filter lap runs into a group. This is used to
+-- determine when all 5 filters for a projection cell have completed processing
+CREATE TABLE lapGroup  (
+    seq_id  BIGINT,
+    projection_cell VARCHAR(64),
+    state   VARCHAR(16),
+    fault   SMALLINT,
+    PRIMARY KEY(seq_id, projection_cell),
+    KEY(state),
+    KEY(fault),
+    FOREIGN KEY(seq_id) REFERENCES lapSequence(seq_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+UPDATE dbversion set schema_version = '1.1.75', updated= CURRENT_TIMESTAMP();
+
Index: branches/eam_branches/ipp-20130207/dbconfig/config.md
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/config.md	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/config.md	(revision 35236)
@@ -2,4 +2,4 @@
     pkg_name        STR     ippdb
     pkg_namespace   STR     ippdb
-    pkg_version     STR     1.1.71717171717171
+    pkg_version     STR     1.1.75
 END
Index: branches/eam_branches/ipp-20130207/dbconfig/lap.md
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/lap.md	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/lap.md	(revision 35236)
@@ -30,2 +30,9 @@
     data_state     STR         64   # Key
 END
+
+lapGroup METADATA
+    seq_id          S64 0
+    projection_cell STR 64
+    state           STR 64
+    fault           S16 0
+end
Index: branches/eam_branches/ipp-20130207/dbconfig/release.md
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/release.md	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/release.md	(revision 35236)
@@ -8,5 +8,5 @@
     rel_id      S32     0   # Primary Key AUTO_INCREMENT
     surveyID    S32     0   # fkey(surveyID) ref survey(surveyID)
-    releaseName STR     64
+    release_name STR     64
     release_state STR   16
     dataRelease S32     0
@@ -20,4 +20,5 @@
     chip_id     S64     0
     cam_id      S64     0
+    group_id    S32     0
     state       STR     16
     flags       U32     0
@@ -25,4 +26,5 @@
     zpt_stdev   F32     0
     path_base   STR     255
+    fault       S16     0
     registered  TAI     NULL
     time_stamp  UTC     NULL
@@ -32,7 +34,9 @@
     relstack_id S64     0   # Primary Key AUTO_INCREMENT
     rel_id      S32     0   # fkey(rel_id) ref ippRelease(rel_id)
-    skycal_id   S64     0   # fkey(skycal_id) ref skycalRun(skycal_id)
+    stack_id    S64     0   # fkey(stack_id) ref stackRun(stack_id)
+    skycal_id   S64     0 
     skycell_id  STR     64
     tess_id     STR     64
+    filter      STR     64
     state       STR     16
     flags       U32     0
@@ -40,7 +44,21 @@
     zpt_obs     F32     0
     zpt_stdev   F32     0
-    fwhm_major  F32     0
+    mjd_obs     U32     0
     path_base   STR     255
+    fault       S16     0
     registered  TAI     NULL
     time_stamp  TAI     NULL
 END
+
+relGroup METADATA
+    group_id    S32     0   # Primary Key AUTO_INCREMENT
+    rel_id      S32     0
+    group_type  STR     16
+    lap_id      S64     0
+    group_name  STR     16
+    state       STR     16
+    label       STR     64
+    exp_list_path STR   255
+    fault       S16     0
+    registered  TAI     NULL
+END
Index: branches/eam_branches/ipp-20130207/dbconfig/staticsky.md
===================================================================
--- branches/eam_branches/ipp-20130207/dbconfig/staticsky.md	(revision 35125)
+++ branches/eam_branches/ipp-20130207/dbconfig/staticsky.md	(revision 35236)
@@ -59,4 +59,6 @@
     zpt_obs        F32    0.0
     zpt_stdev      F32    0.0
+    fwhm_major     F32    0.0
+    fwhm_minor     F32    0.0
     quality        S16    0	  # Key
     software_ver   STR    16