Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 35192)
+++ trunk/ippTools/share/Makefile.am	(revision 35196)
@@ -466,4 +466,6 @@
 	releasetool_listrelease.sql \
 	releasetool_listrelexp.sql \
-	releasetool_definerelexp.sql
+	releasetool_definerelexp.sql \
+	releasetool_definerelstack.sql \
+	releasetool_definerelstack_with_skycal.sql
 
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35192)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35196)
@@ -2124,4 +2124,6 @@
       zpt_obs FLOAT,
       zpt_stdev FLOAT,
+      fwhm_major  FLOAT,
+      fwhm_minor  FLOAT,
       quality SMALLINT NOT NULL,
       hostname VARCHAR(64) NOT NULL,
@@ -2185,4 +2187,5 @@
     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
@@ -2190,4 +2193,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),
@@ -2201,6 +2205,7 @@
     skycal_id   BIGINT,         -- id of the sky calibration run that supplied the calibration
                                 -- for this release of this skycell.
-    skycell_id  varchar(64),
-    tess_id     varchar(64),
+    skycell_id  VARCHAR(64),
+    tess_id     VARCHAR(64),
+    filter      VARCHAR(16),
     state       VARCHAR(16),    -- released, pending, archive, drop  
     flags       INT UNSIGNED,
@@ -2208,11 +2213,16 @@
     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
     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(stack_id) REFERENCES stackRun(stack_id)
Index: trunk/ippTools/share/releasetool_definerelstack.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelstack.sql	(revision 35196)
+++ trunk/ippTools/share/releasetool_definerelstack.sql	(revision 35196)
@@ -0,0 +1,16 @@
+SELECT
+    ippRelease.rel_id,
+    stackRun.stack_id,
+    0 as skycal_id,
+    stackRun.skycell_id,
+    stackRun.tess_id,
+    stackRun.filter,
+    0 AS mjd_obs,
+    0 AS zpt_obs,
+    0 AS zpt_stdev
+
+FROM ippRelease
+JOIN stackRun
+LEFT JOIN relStack AS previousRelStack USING(rel_id, tess_id, skycell_id, filter)
+
+WHERE previousRelStack.relstack_id IS NULL
Index: trunk/ippTools/share/releasetool_definerelstack_with_skycal.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelstack_with_skycal.sql	(revision 35196)
+++ trunk/ippTools/share/releasetool_definerelstack_with_skycal.sql	(revision 35196)
@@ -0,0 +1,19 @@
+SELECT
+    ippRelease.rel_id,
+    stackRun.stack_id,
+    IFNULL(skycalRun.skycal_id, 0) as skycal_id,
+    stackRun.skycell_id,
+    stackRun.tess_id,
+    stackRun.filter,
+    stackSumSkyfile.mjd_obs,
+    skycalResult.zpt_obs,
+    skycalResult.zpt_stdev
+
+FROM ippRelease
+JOIN stackRun
+JOIN stackSumSkyfile USING(stack_id)
+LEFT JOIN relStack AS previousRelStack USING(rel_id, tess_id, skycell_id, filter)
+JOIN skycalRun ON skycalRun.stack_id = stackRun.stack_id
+JOIN skycalResult ON skycalRun.skycal_id = skycalResult.skycal_id
+
+WHERE previousRelStack.relstack_id IS NULL