Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 25800)
+++ trunk/ippTools/share/Makefile.am	(revision 25816)
@@ -152,4 +152,5 @@
      faketool_unmasked.sql \
      flatcorr_chiprundone.sql \
+     flatcorr_camerarundone.sql \
      flatcorr_pendingprocess.sql \
      flatcorr_inputimfile.sql \
Index: trunk/ippTools/share/addtool_find_pendingexp.sql
===================================================================
--- trunk/ippTools/share/addtool_find_pendingexp.sql	(revision 25800)
+++ trunk/ippTools/share/addtool_find_pendingexp.sql	(revision 25816)
@@ -1,4 +1,5 @@
 SELECT
     addRun.*,
+    camProcessedExp.path_base as camroot,
     rawExp.exp_tag,
     rawExp.exp_id,
@@ -9,4 +10,6 @@
 FROM addRun
 JOIN camRun
+    USING(cam_id)
+JOIN camProcessedExp
     USING(cam_id)
 JOIN chipRun
@@ -21,4 +24,6 @@
     camRun.state = 'full'
     AND ((addRun.state = 'new' AND addProcessedExp.add_id IS NULL) OR addRun.state = 'update')
+    AND addRun.dvodb IS NOT NULL
+    AND addRun.workdir IS NOT NULL
     AND addMask.label IS NULL
 
Index: trunk/ippTools/share/addtool_queue_cam_id.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_cam_id.sql	(revision 25800)
+++ trunk/ippTools/share/addtool_queue_cam_id.sql	(revision 25816)
@@ -6,7 +6,8 @@
         '%s',           -- workdir
 	'%s',           -- workdir_state
+        '%s',           -- reduction
         '%s',           -- label
         '%s',           -- dvodb 
-	0               -- magicked
+	%d		-- image_only
     FROM camRun
     WHERE
Index: trunk/ippTools/share/flatcorr_camerarundone.sql
===================================================================
--- trunk/ippTools/share/flatcorr_camerarundone.sql	(revision 25816)
+++ trunk/ippTools/share/flatcorr_camerarundone.sql	(revision 25816)
@@ -0,0 +1,15 @@
+SELECT
+    corr_id,
+    camRun.*
+FROM flatcorrRun
+JOIN flatcorrCamLink
+    USING(corr_id)
+JOIN camRun
+    USING(cam_id)
+LEFT JOIN addRun
+    ON camRun.cam_id = addRun.cam_id
+WHERE
+    flatcorrRun.state = 'new'
+    AND flatcorrCamLink.include = 1
+    AND camRun.state = 'full'
+    AND addRun.cam_id is NULL
Index: trunk/ippTools/share/flatcorr_chiprundone.sql
===================================================================
--- trunk/ippTools/share/flatcorr_chiprundone.sql	(revision 25800)
+++ trunk/ippTools/share/flatcorr_chiprundone.sql	(revision 25816)
@@ -1,5 +1,4 @@
 SELECT
     corr_id,
-    cam_id,
     chipRun.*
 FROM flatcorrRun
@@ -14,3 +13,3 @@
     AND flatcorrChipLink.include = 1
     AND chipRun.state = 'full'
-    AND camRun.cam_id is NULL;
+    AND camRun.cam_id is NULL
Index: trunk/ippTools/share/flatcorr_pendingprocess.sql
===================================================================
--- trunk/ippTools/share/flatcorr_pendingprocess.sql	(revision 25800)
+++ trunk/ippTools/share/flatcorr_pendingprocess.sql	(revision 25816)
@@ -10,29 +10,29 @@
   reduction,
   region,
-  chip_count,
-  cam_count
+  cam_count,
+  add_count
 FROM 
   (SELECT 
      flatcorrRun.*,
-     flatcorrChipLink.corr_id as chip_corr_id,
-     count(flatcorrChipLink.chip_id) as chip_count
+     flatcorrCamLink.corr_id as cam_corr_id,
+     count(flatcorrCamLink.cam_id) as cam_count
    FROM flatcorrRun
-   JOIN flatcorrChipLink
-     ON flatcorrChipLink.corr_id = flatcorrRun.corr_id
-  WHERE flatcorrChipLink.include = 1
+   JOIN flatcorrCamLink
+  USING (corr_id)
+  WHERE flatcorrCamLink.include = 1
    GROUP BY
-     flatcorrChipLink.corr_id) AS t1
+     flatcorrCamLink.corr_id) AS t1
 LEFT JOIN
   (SELECT 
-     flatcorrCamLink.corr_id as cam_corr_id,
-     count(flatcorrCamLink.cam_id) as cam_count
-   FROM flatcorrCamLink
-   JOIN camRun
-       ON flatcorrCamLink.cam_id = camRun.cam_id
-   WHERE camRun.state = 'full'
-     AND flatcorrCamLink.include = 1
+     flatcorrAddstarLink.corr_id as add_corr_id,
+     count(flatcorrAddstarLink.add_id) as add_count
+   FROM flatcorrAddstarLink
+   JOIN addRun
+   USING (add_id)
+   WHERE addRun.state = 'full'
+     AND flatcorrAddstarLink.include = 1
    GROUP BY
-       flatcorrCamLink.corr_id) AS t2
-ON t1.chip_corr_id = t2.cam_corr_id
-WHERE chip_count = cam_count
+       flatcorrAddstarLink.corr_id) AS t2
+ON t1.cam_corr_id = t2.add_corr_id
+WHERE cam_count = add_count
 AND state = 'new'
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25800)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25816)
@@ -464,7 +464,8 @@
     workdir VARCHAR(255),
     workdir_state VARCHAR(64),
+    reduction VARCHAR(64),
     label VARCHAR(64),
     dvodb VARCHAR(255),
-    magicked BIGINT,
+    image_only TINYINT,
     PRIMARY KEY(add_id),
     KEY(add_id),
@@ -480,5 +481,4 @@
     add_id BIGINT AUTO_INCREMENT,
     dtime_addstar FLOAT,
-    n_stars INT,
     path_base VARCHAR(255),
     fault SMALLINT NOT NULL,
@@ -1182,5 +1182,5 @@
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
--- these two tables link the flatcorrRun to the associated chip and camera runs
+-- these three tables link the flatcorrRun to the associated chip, camera, and addstar runs
 CREATE TABLE flatcorrChipLink (
         corr_id BIGINT,
@@ -1201,4 +1201,15 @@
         FOREIGN KEY(chip_id) REFERENCES chipRun(chip_id),
         FOREIGN KEY(cam_id) REFERENCES camRun(cam_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE flatcorrAddstarLink (
+        corr_id BIGINT,
+        cam_id BIGINT,
+        add_id BIGINT,
+        include TINYINT,
+        PRIMARY KEY(corr_id, cam_id, add_id),
+        FOREIGN KEY (corr_id)  REFERENCES  flatcorrRun(corr_id),
+        FOREIGN KEY (cam_id)  REFERENCES  camRun(cam_id),
+        FOREIGN KEY (add_id)  REFERENCES  addRun(add_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;
 
Index: trunk/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 25800)
+++ trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 25816)
@@ -59,4 +59,5 @@
 DROP TABLE IF EXISTS flatcorrChipLink;
 DROP TABLE IF EXISTS flatcorrCamLink;
+DROP TABLE IF EXISTS flatcorrAddstarLink;
 DROP TABLE IF EXISTS pstampDataStore;
 DROP TABLE IF EXISTS pstampProject;