Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 20376)
+++ trunk/ippTools/share/Makefile.am	(revision 20397)
@@ -95,4 +95,6 @@
      flatcorr_pendingprocess.sql \
      flatcorr_inputimfile.sql \
+     flatcorr_dropchip.sql \
+     flatcorr_dropcamera.sql \
      magictool_addmask.sql \
      magictool_create_tmp_warpcomplete.sql \
Index: trunk/ippTools/share/flatcorr_chiprundone.sql
===================================================================
--- trunk/ippTools/share/flatcorr_chiprundone.sql	(revision 20376)
+++ trunk/ippTools/share/flatcorr_chiprundone.sql	(revision 20397)
@@ -12,4 +12,5 @@
 WHERE
     flatcorrRun.state = 'new'
+    AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
     AND camRun.cam_id is NULL;
Index: trunk/ippTools/share/flatcorr_dropcamera.sql
===================================================================
--- trunk/ippTools/share/flatcorr_dropcamera.sql	(revision 20397)
+++ trunk/ippTools/share/flatcorr_dropcamera.sql	(revision 20397)
@@ -0,0 +1,5 @@
+
+UPDATE flatcorrCamLink
+  SET include = 0
+WHERE corr_id = %lld 
+  AND cam_id = %lld
Index: trunk/ippTools/share/flatcorr_dropchip.sql
===================================================================
--- trunk/ippTools/share/flatcorr_dropchip.sql	(revision 20397)
+++ trunk/ippTools/share/flatcorr_dropchip.sql	(revision 20397)
@@ -0,0 +1,5 @@
+
+UPDATE flatcorrChipLink
+  SET include = 0
+WHERE corr_id = %lld 
+  AND chip_id = %lld
Index: trunk/ippTools/share/flatcorr_pendingprocess.sql
===================================================================
--- trunk/ippTools/share/flatcorr_pendingprocess.sql	(revision 20376)
+++ trunk/ippTools/share/flatcorr_pendingprocess.sql	(revision 20397)
@@ -20,4 +20,5 @@
    JOIN flatcorrChipLink
      ON flatcorrChipLink.corr_id = flatcorrRun.corr_id
+  WHERE flatcorrChipLink.include = 1
    GROUP BY
      flatcorrChipLink.corr_id) AS t1
@@ -30,4 +31,5 @@
        ON flatcorrCamLink.cam_id = camRun.cam_id
    WHERE camRun.state = 'full'
+     AND flatcorrCamLink.include = 1
    GROUP BY
        flatcorrCamLink.corr_id) AS t2
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 20376)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 20397)
@@ -1100,4 +1100,5 @@
         corr_id BIGINT,
         chip_id BIGINT,
+	include TINYINT,
         PRIMARY KEY(corr_id, chip_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
@@ -1109,4 +1110,5 @@
         chip_id BIGINT,
         cam_id BIGINT,
+	include TINYINT,
         PRIMARY KEY(corr_id, cam_id),
         FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
