Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 28154)
+++ trunk/ippTools/share/Makefile.am	(revision 28181)
@@ -4,12 +4,19 @@
 
 dist_pkgdata_DATA = \
+     addtool_checkminidvodbaddrun.sql \
      addtool_donecleanup.sql \
      addtool_find_cam_id.sql \
      addtool_find_pendingexp.sql \
+     addtool_find_pendingmergeprocess.sql \
      addtool_find_processedexp.sql \
+     addtool_find_minidvodbprocessed.sql \
+     addtool_find_minidvodbrun.sql \
      addtool_pendingcleanupexp.sql \
      addtool_pendingcleanuprun.sql \
      addtool_queue_cam_id.sql \
+     addtool_queue_minidvodbrun.sql \
+     addtool_reset_faulted_minidvodbruns.sql \
      addtool_reset_faulted_runs.sql \
+     addtool_revertminidvodbprocessed.sql \
      addtool_revertprocessedexp.sql \
      camtool_donecleanup.sql \
Index: trunk/ippTools/share/addtool_checkminidvodbaddrun.sql
===================================================================
--- trunk/ippTools/share/addtool_checkminidvodbaddrun.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_checkminidvodbaddrun.sql	(revision 28181)
@@ -0,0 +1,20 @@
+-- this selects the minidvodbs that have complete addRuns
+SELECT minidvodb_id, minidvodb_name, minidvodb_path, mergedvodb_path, state, minidbg 
+AS minidvodb_group, (cnt - cnt2) as not_full, cnt as addRun_count
+FROM minidvodbRun 
+JOIN 
+   (SELECT minidvodb_name, count(state) as cnt2, cnt, minidbg, minidbn 
+   FROM addRun LEFT JOIN 
+       -- this select grabs (and counts) all the addRuns with any state
+       -- and groups them by the name
+       (SELECT minidvodb_group as minidbg, minidvodb_name as minidbn, count(state) 
+        AS cnt 
+        FROM addRun 
+        GROUP BY minidvodb_name ) 
+   AS foo1 ON minidvodb_name = minidbn
+        -- the second select grabs and counts all the addRuns with state
+        -- of 'full'         
+   WHERE addRun.state = 'full' 
+   GROUP BY minidvodb_name ) 
+AS foo2 
+USING(minidvodb_name) 
Index: trunk/ippTools/share/addtool_find_minidvodbprocessed.sql
===================================================================
--- trunk/ippTools/share/addtool_find_minidvodbprocessed.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_find_minidvodbprocessed.sql	(revision 28181)
@@ -0,0 +1,8 @@
+SELECT
+    minidvodbProcessed.*,
+    minidvodbRun.minidvodb_name	
+    minidvodbRun.minidvodb_group
+FROM minidvodbProcessed
+JOIN minidvodbRun
+    USING(minidvodb_id)
+
Index: trunk/ippTools/share/addtool_find_minidvodbrun.sql
===================================================================
--- trunk/ippTools/share/addtool_find_minidvodbrun.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_find_minidvodbrun.sql	(revision 28181)
@@ -0,0 +1,5 @@
+SELECT
+    minidvodbRun.*
+FROM minidvodbRun
+
+
Index: trunk/ippTools/share/addtool_find_minidvodbrun2.sql
===================================================================
--- trunk/ippTools/share/addtool_find_minidvodbrun2.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_find_minidvodbrun2.sql	(revision 28181)
@@ -0,0 +1,23 @@
+-- this selects the minidvodbs that have complete addRuns
+SELECT minidvodb_name, minidvodb_path, mergedvodb_path, state, minidbg 
+AS minidvodb_group 
+FROM minidvodbRun 
+JOIN 
+   (SELECT minidvodb_name, count(state) as cnt2, cnt, minidbg, minidbn 
+   FROM addRun LEFT JOIN 
+       -- this select grabs (and counts) all the addRuns with any state
+       -- and groups them by the name
+       (SELECT minidvodb_group as minidbg, minidvodb_name as minidbn, count(state) 
+        AS cnt 
+        FROM addRun 
+        GROUP BY minidvodb_name ) 
+   AS foo1 ON minidvodb_name = minidbn
+        -- the second select grabs and counts all the addRuns with state
+        -- of 'full'	     
+   WHERE addRun.state = 'full' 
+   GROUP BY minidvodb_name ) 
+AS foo2 
+USING(minidvodb_name) 
+WHERE cnt2 = cnt
+       -- the 3rd select only grabs the columns where the counts are the same
+       -- (same number of 'full' and any state)
Index: trunk/ippTools/share/addtool_find_pendingmergeprocess.sql
===================================================================
--- trunk/ippTools/share/addtool_find_pendingmergeprocess.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_find_pendingmergeprocess.sql	(revision 28181)
@@ -0,0 +1,5 @@
+SELECT minidvodbRun.* 
+FROM minidvodbRun 
+LEFT JOIN minidvodbProcessed
+USING(minidvodb_id)
+WHERE (minidvodbRun.state = 'to_be_merged' AND minidvodbProcessed.minidvodb_id IS NULL)
Index: trunk/ippTools/share/addtool_find_processedexp.sql
===================================================================
--- trunk/ippTools/share/addtool_find_processedexp.sql	(revision 28154)
+++ trunk/ippTools/share/addtool_find_processedexp.sql	(revision 28181)
@@ -2,6 +2,8 @@
     addProcessedExp.*,
     addRun.workdir
-FROM addRun
-JOIN camProcessedExp
+FROM addProcessedExp
+JOIN addRun
+    USING(add_id)
+JOIN camRun
     USING(cam_id)
 JOIN chipRun
Index: trunk/ippTools/share/addtool_queue_cam_id.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_cam_id.sql	(revision 28154)
+++ trunk/ippTools/share/addtool_queue_cam_id.sql	(revision 28181)
@@ -11,5 +11,8 @@
         '%s',           -- dvodb 
         '%s',           -- note
-	%d		-- image_only
+	%d,		-- image_only
+	%d,		-- minidvodb
+	'%s',           -- minidvodb_group 
+ 	'%s'	        -- minidvodb_name
     FROM camRun
     WHERE
Index: trunk/ippTools/share/addtool_queue_minidvodbrun.sql
===================================================================
--- trunk/ippTools/share/addtool_queue_minidvodbrun.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_queue_minidvodbrun.sql	(revision 28181)
@@ -0,0 +1,12 @@
+-- create rcRun's for all destinations that have filesets that they are interested in available
+INSERT INTO minidvodbRun
+SELECT                  -- rows in this select must match rcRun
+    minidvodb_name,
+    minidvodb_path,
+    mergedvodb_path,
+    'new'
+
+FROM addRun 
+LEFT JOIN minidvodbRun USING(minidvodb_name)
+-- WHERE minidvodbRun.minidvodb_name IS NULL
+  
Index: trunk/ippTools/share/addtool_reset_faulted_minidvodbruns.sql
===================================================================
--- trunk/ippTools/share/addtool_reset_faulted_minidvodbruns.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_reset_faulted_minidvodbruns.sql	(revision 28181)
@@ -0,0 +1,6 @@
+UPDATE minidvodbProcessed, minidvodbRun, addRun
+SET minidvodbRun.state = 'to_be_merged'
+WHERE
+    minidvodbProcessed.minidvodb_id = minidvodbRun.minidvodb_id
+    AND addRun.minidvodb_id = minidvodbRun.minidvodb_id
+    AND minidvodbProcessed.fault != 0
Index: trunk/ippTools/share/addtool_revertminidvodbprocessed.sql
===================================================================
--- trunk/ippTools/share/addtool_revertminidvodbprocessed.sql	(revision 28181)
+++ trunk/ippTools/share/addtool_revertminidvodbprocessed.sql	(revision 28181)
@@ -0,0 +1,6 @@
+DELETE FROM minidvodbProcessed
+USING minidvodbProcessed, minidvodbRun, addRun
+WHERE
+    minidvodbProcessed.minidvodb_id = minidvodbRun.minidvodb_id
+    AND addRun.minidvodb_name = minidvodbRun.minidvodb_name
+    AND minidvodbProcessed.fault != 0