Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 35196)
+++ trunk/ippTools/share/Makefile.am	(revision 35213)
@@ -464,8 +464,13 @@
 	sctool_list.sql \
 	releasetool_listsurvey.sql \
+	releasetool_tocalibexp.sql \
 	releasetool_listrelease.sql \
 	releasetool_listrelexp.sql \
 	releasetool_definerelexp.sql \
 	releasetool_definerelstack.sql \
-	releasetool_definerelstack_with_skycal.sql
+	releasetool_definerelstack_with_skycal.sql \
+	releasetool_definerelgroup_select_lap.sql \
+	releasetool_definerelgroup_select_data_group.sql \
+	releasetool_definerelgroup_select_exp_data_group.sql \
+	releasetool_definerelgroup_select_exp_lap.sql
 
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35196)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 35213)
@@ -2164,10 +2164,10 @@
     rel_id      INT(8) AUTO_INCREMENT,
     surveyID    INT(8),
-    releaseName VARCHAR(64),
+    release_name VARCHAR(64),
     relase_state VARCHAR(16),   -- active, pending, archive, drop 
     dataRelease INT(8),         -- PSPS dataRelease
     priority    INT(8),
     PRIMARY KEY(rel_id),
-    KEY(releaseName),
+    KEY(release_name),
     KEY(state),
     KEY(priority),
@@ -2181,4 +2181,5 @@
     chip_id     BIGINT,         -- links to the runs that supplied the data
     cam_id      BIGINT,         -- for this release
+    group_id    INT(8),         -- id of relGroup that this exposure is contained in
     state       VARCHAR(16),    -- released, pending, archive, drop  
     flags       INT UNSIGNED,   -- flags for relphot, relastro, ??
@@ -2229,4 +2230,26 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
+CREATE TABLE relGroup (
+    group_id    INT(8) AUTO_INCREMENT,
+    rel_id      INT(8),
+    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;
+
 
 
Index: trunk/ippTools/share/releasetool_definerelexp.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelexp.sql	(revision 35196)
+++ trunk/ippTools/share/releasetool_definerelexp.sql	(revision 35213)
@@ -1,5 +1,5 @@
 SELECT
     ippRelease.rel_id,
-    ippRelease.releaseName,
+    ippRelease.release_name,
     rawExp.exp_name,
     rawExp.filter,
Index: trunk/ippTools/share/releasetool_definerelgroup_select_data_group.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelgroup_select_data_group.sql	(revision 35213)
+++ trunk/ippTools/share/releasetool_definerelgroup_select_data_group.sql	(revision 35213)
@@ -0,0 +1,9 @@
+SELECT
+    ippRelease.rel_id,
+    count(exp_id) AS num_exposures
+FROM ippRelease
+    LEFT JOIN relExp using(rel_id)
+    LEFT JOIN camRun using(cam_id)
+    WHERE relExp.group_id = 0
+    AND relExp.state != 'drop'
+
Index: trunk/ippTools/share/releasetool_definerelgroup_select_exp_data_group.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelgroup_select_exp_data_group.sql	(revision 35213)
+++ trunk/ippTools/share/releasetool_definerelgroup_select_exp_data_group.sql	(revision 35213)
@@ -0,0 +1,6 @@
+SELECT relExp.relexp_id
+FROM relExp
+    JOIN camRun USING(cam_id)
+WHERE 
+    relExp.group_id = 0
+    AND relExp.state != 'drop'
Index: trunk/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql	(revision 35213)
+++ trunk/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql	(revision 35213)
@@ -0,0 +1,4 @@
+SELECT relExp.relexp_id
+FROM relGroup JOIN lapRun USING(lap_id)
+    JOIN relExp using(rel_id, exp_id)
+WHERE relExp.group_id = 0
Index: trunk/ippTools/share/releasetool_definerelgroup_select_lap.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelgroup_select_lap.sql	(revision 35213)
+++ trunk/ippTools/share/releasetool_definerelgroup_select_lap.sql	(revision 35213)
@@ -0,0 +1,11 @@
+SELECT 
+    lapRun.seq_id,
+    lapRun.lap_id,
+    ippRelease.rel_id
+FROM lapRun
+    JOIN ippRelease
+    LEFT JOIN relGroup USING(lap_id)
+WHERE (lapRun.state = 'done' or lapRun.state = 'full')
+    AND relGroup.group_id IS NULL
+-- AND lapRun.seq_id = xxx
+
Index: trunk/ippTools/share/releasetool_listrelexp.sql
===================================================================
--- trunk/ippTools/share/releasetool_listrelexp.sql	(revision 35196)
+++ trunk/ippTools/share/releasetool_listrelexp.sql	(revision 35213)
@@ -2,5 +2,6 @@
     relexp_id,
     relExp.state,
-    ippRelease.releaseName,
+    relExp.fault,
+    ippRelease.release_name,
     ippRelease.release_state,
     ippRelease.rel_id,
@@ -21,4 +22,5 @@
     camProcessedExp.path_base as cam_path_base,
     camProcessedExp.fwhm_major,
+    camProcessedExp.fwhm_minor,
     warpRun.warp_id,
     warpRun.state as warp_state,
Index: trunk/ippTools/share/releasetool_tocalibexp.sql
===================================================================
--- trunk/ippTools/share/releasetool_tocalibexp.sql	(revision 35213)
+++ trunk/ippTools/share/releasetool_tocalibexp.sql	(revision 35213)
@@ -0,0 +1,5 @@
+SELECT relExp.*,
+ippRelease.release_name,
+ippRelease.release_state
+FROM relExp JOIN ippRelease USING(rel_id)
+WHERE relExp.state = 'goto_calib' AND relExp.fault = 0
Index: trunk/ippTools/share/reltool_pendinggroup.sql
===================================================================
--- trunk/ippTools/share/reltool_pendinggroup.sql	(revision 35213)
+++ trunk/ippTools/share/reltool_pendinggroup.sql	(revision 35213)
@@ -0,0 +1,8 @@
+-- relGroups to process
+SELECT relGroup.*,
+    ippRelease.release_id,
+    ippRelease.release_name
+FROM relGroup 
+    JOIN ippRelease USING(rel_id)
+WHERE relGroup.state ='new'
+    AND relGroup.fault = 0