Index: branches/eam_branches/ipp-20130307/ippTools/share/Makefile.am
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/Makefile.am	(revision 35267)
+++ branches/eam_branches/ipp-20130307/ippTools/share/Makefile.am	(revision 35350)
@@ -457,4 +457,7 @@
 	laptool_WSdiff_check.sql \
 	laptool_stacks.sql \
+	laptool_pendinggroup.sql \
+	laptool_revertgroup.sql \
+	laptool_filtersforgroup.sql \
 	vptool_find_rawexp.sql \
 	vptool_pendingimfile.sql \
Index: branches/eam_branches/ipp-20130307/ippTools/share/addtool_find_processedexp_cam.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/addtool_find_processedexp_cam.sql	(revision 35267)
+++ branches/eam_branches/ipp-20130307/ippTools/share/addtool_find_processedexp_cam.sql	(revision 35350)
@@ -1,5 +1,11 @@
 SELECT
     addProcessedExp.*,
-    addRun.workdir
+    addRun.label,
+    addRun.workdir,
+    camRun.cam_id,
+    camRun.label as cam_label,
+    camRun.data_group as cam_data_group,
+    rawExp.exp_id,
+    exp_name
 FROM addProcessedExp
 JOIN addRun
Index: branches/eam_branches/ipp-20130307/ippTools/share/laptool_filtersforgroup.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/laptool_filtersforgroup.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/laptool_filtersforgroup.sql	(revision 35350)
@@ -0,0 +1,2 @@
+SELECT DISTINCT filter
+FROM lapGroup JOIN lapRun USING(seq_id, tess_id, projection_cell)
Index: branches/eam_branches/ipp-20130307/ippTools/share/laptool_pendinggroup.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/laptool_pendinggroup.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/laptool_pendinggroup.sql	(revision 35350)
@@ -0,0 +1,4 @@
+SELECT DISTINCT lapGroup.*,
+    lapRun.dist_group
+FROM lapGroup JOIN lapRun USING(seq_id, tess_id, projection_cell)
+WHERE lapGroup.state ='new' AND lapGroup.fault = 0
Index: branches/eam_branches/ipp-20130307/ippTools/share/laptool_revertgroup.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/laptool_revertgroup.sql	(revision 35350)
+++ branches/eam_branches/ipp-20130307/ippTools/share/laptool_revertgroup.sql	(revision 35350)
@@ -0,0 +1,3 @@
+UPDATE lapGroup 
+SET fault = 0
+WHERE fault != 0
Index: branches/eam_branches/ipp-20130307/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/pxadmin_create_tables.sql	(revision 35267)
+++ branches/eam_branches/ipp-20130307/ippTools/share/pxadmin_create_tables.sql	(revision 35350)
@@ -1441,5 +1441,8 @@
         outProduct VARCHAR(64),
         uri VARCHAR(255),
-        outdir     VARCHAR(255),
+        outdir VARCHAR(255),
+        username VARCHAR(255),
+        proj_id BIGINT,
+        registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
         timestamp TIMESTAMP,
         fault SMALLINT,
@@ -1448,5 +1451,6 @@
         KEY(state),
         KEY(fault),
-        KEY(label)
+        KEY(label),
+        KEY(username)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
@@ -2194,4 +2198,5 @@
     KEY (state),
     KEY (fault),
+    KEY (group_id),
     FOREIGN KEY(exp_id) REFERENCES rawExp(exp_id),
     FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),
@@ -2253,8 +2258,11 @@
 CREATE TABLE lapGroup  (
     seq_id  BIGINT,
+    tess_id VARCHAR(64),
     projection_cell VARCHAR(64),
     state   VARCHAR(16),
+    label   VARCHAR(64),
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time group was registered
     fault   SMALLINT,
-    PRIMARY KEY(seq_id, projection_cell),
+    PRIMARY KEY(seq_id, tess_id, projection_cell),
     KEY(state),
     KEY(fault),
Index: branches/eam_branches/ipp-20130307/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql	(revision 35267)
+++ branches/eam_branches/ipp-20130307/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql	(revision 35350)
@@ -1,4 +1,6 @@
 SELECT relExp.relexp_id
-FROM relGroup JOIN lapRun USING(lap_id)
+FROM relGroup 
+    JOIN lapRun USING(lap_id)
+    JOIN lapExp USING(lap_id)
     JOIN relExp using(rel_id, exp_id)
 WHERE relExp.group_id = 0
Index: branches/eam_branches/ipp-20130307/ippTools/share/releasetool_pendingrelgroup.sql
===================================================================
--- branches/eam_branches/ipp-20130307/ippTools/share/releasetool_pendingrelgroup.sql	(revision 35267)
+++ branches/eam_branches/ipp-20130307/ippTools/share/releasetool_pendingrelgroup.sql	(revision 35350)
@@ -1,3 +1,5 @@
-SELECT relGroup.*
+SELECT 
+    relGroup.*,
+    ippRelease.release_name
 FROM relGroup
     JOIN ippRelease USING(rel_id)