Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 32570)
+++ trunk/ippTools/share/Makefile.am	(revision 32573)
@@ -76,4 +76,6 @@
 	chiptool_definecopy.sql \
 	chiptool_donecleanup.sql \
+	chiptool_dropprocessedimfile_update.sql \
+	chiptool_dropprocessedimfile_delete.sql \
 	chiptool_find_rawexp.sql \
 	chiptool_listrun.sql \
Index: trunk/ippTools/share/chiptool_dropprocessedimfile_delete.sql
===================================================================
--- trunk/ippTools/share/chiptool_dropprocessedimfile_delete.sql	(revision 32573)
+++ trunk/ippTools/share/chiptool_dropprocessedimfile_delete.sql	(revision 32573)
@@ -0,0 +1,6 @@
+DELETE FROM magicDSFile
+    USING magicDSRun, magicDSFile, chipRun, chipProcessedImfile
+WHERE chipRun.chip_id = chipProcessedImfile.chip_id
+    AND magicDSRun.stage ='chip' and magicDSRun.stage_id = chipRun.chip_id
+    AND magicDSFile.magic_ds_id = magicDSFile.magic_ds_id
+    AND magicDSFile.component = chipProcessedImfile.class_id
Index: trunk/ippTools/share/chiptool_dropprocessedimfile_update.sql
===================================================================
--- trunk/ippTools/share/chiptool_dropprocessedimfile_update.sql	(revision 32573)
+++ trunk/ippTools/share/chiptool_dropprocessedimfile_update.sql	(revision 32573)
@@ -0,0 +1,5 @@
+UPDATE chipProcessedImfile 
+    SET quality = %d,
+        data_state = 'full',
+        magicked = 0,
+        fault = 0