Index: /trunk/ippTools/share/Makefile.am
===================================================================
--- /trunk/ippTools/share/Makefile.am	(revision 29414)
+++ /trunk/ippTools/share/Makefile.am	(revision 29415)
@@ -61,4 +61,5 @@
 	chiptool_pendingimfile.sql \
 	chiptool_processedimfile.sql \
+	chiptool_revertcleanup.sql \
 	chiptool_revertprocessedimfile.sql \
 	chiptool_revertupdatedimfile.sql \
@@ -143,4 +144,5 @@
 	difftool_revertdiffskyfile_delete.sql \
 	difftool_revertdiffskyfile_updated.sql \
+	difftool_revertcleanup.sql \
 	difftool_setskyfiletoupdate.sql \
 	difftool_skyfile.sql \
@@ -358,4 +360,5 @@
 	warptool_revertwarped_delete.sql \
 	warptool_revertwarped_updated.sql \
+	warptool_revertcleanup.sql \
 	warptool_runstate.sql \
 	warptool_scmap.sql \
Index: /trunk/ippTools/share/chiptool_revertcleanup.sql
===================================================================
--- /trunk/ippTools/share/chiptool_revertcleanup.sql	(revision 29415)
+++ /trunk/ippTools/share/chiptool_revertcleanup.sql	(revision 29415)
@@ -0,0 +1,7 @@
+UPDATE chipProcessedImfile
+    JOIN chipRun using(chip_id,exp_id)
+SET chipProcessedImfile.data_state = 'full', 
+    chipRun.state = '%s'
+WHERE
+    chipRun.state = '%s'
+    AND chipProcessedImfile.data_state = '%s'
Index: /trunk/ippTools/share/difftool_revertcleanup.sql
===================================================================
--- /trunk/ippTools/share/difftool_revertcleanup.sql	(revision 29415)
+++ /trunk/ippTools/share/difftool_revertcleanup.sql	(revision 29415)
@@ -0,0 +1,7 @@
+UPDATE diffSkyfile
+    JOIN diffRun using(diff_id)
+SET diffSkyfile.data_state = 'full', 
+    diffRun.state = '%s'
+WHERE
+    diffRun.state = '%s'
+    AND diffSkyfile.data_state = '%s'
Index: /trunk/ippTools/share/warptool_revertcleanup.sql
===================================================================
--- /trunk/ippTools/share/warptool_revertcleanup.sql	(revision 29415)
+++ /trunk/ippTools/share/warptool_revertcleanup.sql	(revision 29415)
@@ -0,0 +1,7 @@
+UPDATE warpSkyfile
+    JOIN warpRun using(warp_id)
+SET warpSkyfile.data_state = 'full', 
+    warpRun.state = '%s'
+WHERE
+    warpRun.state = '%s'
+    AND warpSkyfile.data_state = '%s'