Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 29509)
+++ trunk/ippTools/share/Makefile.am	(revision 29528)
@@ -264,4 +264,7 @@
 	magicdstool_torevert_warp.sql \
 	magicdstool_torevert_diff.sql \
+	minidvodbtool_find_minidvodb_id_dvo.sql \
+	minidvodbtool_find_minidvodbcopy.sql \
+	minidvodbtool_revertminidvodbcopy.sql \
 	pstamptool_completedreq.sql \
 	pstamptool_datastore.sql \
Index: trunk/ippTools/share/minidvodbtool_find_minidvodb_id_dvo.sql
===================================================================
--- trunk/ippTools/share/minidvodbtool_find_minidvodb_id_dvo.sql	(revision 29528)
+++ trunk/ippTools/share/minidvodbtool_find_minidvodb_id_dvo.sql	(revision 29528)
@@ -0,0 +1,8 @@
+SELECT minidvodbRun.* FROM minidvodbRun
+JOIN minidvodbProcessed USING(minidvodb_id)
+WHERE minidvodbRun.state = 'merged'
+    AND minidvodb_id NOT IN (SELECT minidvodb_id
+       FROM minidvodbCopy
+       JOIN minidvodbRun USING(minidvodb_id)
+       WHERE %s
+      )
Index: trunk/ippTools/share/minidvodbtool_find_minidvodbcopy.sql
===================================================================
--- trunk/ippTools/share/minidvodbtool_find_minidvodbcopy.sql	(revision 29528)
+++ trunk/ippTools/share/minidvodbtool_find_minidvodbcopy.sql	(revision 29528)
@@ -0,0 +1,7 @@
+SELECT
+    minidvodbCopy.*,
+    minidvodbRun.minidvodb_path
+FROM minidvodbCopy
+    JOIN minidvodbRun using (minidvodb_id)
+
+
Index: trunk/ippTools/share/minidvodbtool_queue_minidvodb_id.sql
===================================================================
--- trunk/ippTools/share/minidvodbtool_queue_minidvodb_id.sql	(revision 29528)
+++ trunk/ippTools/share/minidvodbtool_queue_minidvodb_id.sql	(revision 29528)
@@ -0,0 +1,15 @@
+INSERT INTO minidvodbCopy
+    SELECT
+        0,              -- minidvodbcopy_id
+        minidvodb_id,         -- minidvodb_id
+        '%s',           -- minidvodb_rsync_path
+        '%s',           -- destination_host
+	%d,           -- fault
+        '%s',           -- state
+        %s,           -- epoch
+        %f           -- dtime
+        
+    FROM minidvodbRun
+    WHERE
+        minidvodbRun.state = 'merged'
+        AND minidvodbRun.minidvodb_id = %lld
Index: trunk/ippTools/share/minidvodbtool_revertminidvodbcopy.sql
===================================================================
--- trunk/ippTools/share/minidvodbtool_revertminidvodbcopy.sql	(revision 29528)
+++ trunk/ippTools/share/minidvodbtool_revertminidvodbcopy.sql	(revision 29528)
@@ -0,0 +1,7 @@
+UPDATE minidvodbCopy
+ --   SET minidvodbCopy.state = 'new',
+    SET minidvodbCopy.fault = 0
+WHERE
+    minidvodbCopy.state = 'new'
+    AND minidvodbCopy.fault >0    
+
