Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 24882)
+++ trunk/ippTools/share/Makefile.am	(revision 24883)
@@ -137,4 +137,9 @@
      flatcorr_dropcamera.sql \
      magictool_addmask.sql \
+     magictool_censor_raw.sql \
+     magictool_censor_chip.sql \
+     magictool_censor_camera.sql \
+     magictool_censor_warp.sql \
+     magictool_censor_diff.sql \
      magictool_create_tmp_warpcomplete.sql \
      magictool_definebyquery_insert.sql \
Index: trunk/ippTools/share/magicdstool_torevert_camera.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_camera.sql	(revision 24882)
+++ trunk/ippTools/share/magicdstool_torevert_camera.sql	(revision 24883)
@@ -19,4 +19,4 @@
     JOIN rawExp using(exp_id)
 WHERE magicDSRun.stage = 'camera'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0
Index: trunk/ippTools/share/magicdstool_torevert_chip.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 24882)
+++ trunk/ippTools/share/magicdstool_torevert_chip.sql	(revision 24883)
@@ -18,4 +18,4 @@
     JOIN rawExp using(exp_id)
 WHERE magicDSRun.stage = 'chip'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0
Index: trunk/ippTools/share/magicdstool_torevert_diff.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_diff.sql	(revision 24882)
+++ trunk/ippTools/share/magicdstool_torevert_diff.sql	(revision 24883)
@@ -18,4 +18,4 @@
     JOIN rawExp USING(exp_id)
 WHERE magicDSRun.stage = 'diff'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0
Index: trunk/ippTools/share/magicdstool_torevert_raw.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_raw.sql	(revision 24882)
+++ trunk/ippTools/share/magicdstool_torevert_raw.sql	(revision 24883)
@@ -18,4 +18,4 @@
                       AND rawImfile.tmp_class_id = summitImfile.class_id)
 WHERE magicDSRun.stage = 'raw'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0
Index: trunk/ippTools/share/magicdstool_torevert_warp.sql
===================================================================
--- trunk/ippTools/share/magicdstool_torevert_warp.sql	(revision 24882)
+++ trunk/ippTools/share/magicdstool_torevert_warp.sql	(revision 24883)
@@ -21,4 +21,4 @@
     JOIN rawExp USING(exp_id)
 WHERE magicDSRun.stage = 'warp'
-    AND magicDSRun.state = 'new'
+    AND (magicDSRun.state = 'new' OR magicDSRun.state = 'censored')
     AND magicDSFile.fault > 0
Index: trunk/ippTools/share/magictool_censor_camera.sql
===================================================================
--- trunk/ippTools/share/magictool_censor_camera.sql	(revision 24883)
+++ trunk/ippTools/share/magictool_censor_camera.sql	(revision 24883)
@@ -0,0 +1,8 @@
+UPDATE magicRun 
+    JOIN magicDSRun USING(magic_id)
+    JOIN magicDSFile USING(magic_ds_id)
+    JOIN camRun ON magic_ds_id = magicked
+SET camRun.magicked = 0,
+    magicDSRun.state = 'censored',
+    magicDSFile.fault = 42
+
Index: trunk/ippTools/share/magictool_censor_chip.sql
===================================================================
--- trunk/ippTools/share/magictool_censor_chip.sql	(revision 24883)
+++ trunk/ippTools/share/magictool_censor_chip.sql	(revision 24883)
@@ -0,0 +1,9 @@
+UPDATE chipRun 
+    JOIN chipProcessedImfile USING(chip_id, exp_id) 
+    JOIN magicDSRun ON chipRun.magicked = magicDSRun.magic_ds_id 
+    JOIN magicDSFile USING(magic_ds_id) 
+    JOIN magicRun USING(magic_id, exp_id)
+SET chipProcessedImfile.magicked = 0, 
+    chipRun.magicked = 0, 
+    magicDSRun.state = 'censored', 
+    magicDSFile.fault = 42
Index: trunk/ippTools/share/magictool_censor_diff.sql
===================================================================
--- trunk/ippTools/share/magictool_censor_diff.sql	(revision 24883)
+++ trunk/ippTools/share/magictool_censor_diff.sql	(revision 24883)
@@ -0,0 +1,9 @@
+UPDATE magicRun 
+    JOIN magicDSRun USING(magic_id)
+    JOIN magicDSFile USING(magic_ds_id)
+    JOIN diffRun ON magic_ds_id = magicked
+    JOIN diffSkyfile ON diffRun.diff_id = diffSkyfile.diff_id
+SET diffRun.magicked = 0,
+    diffSkyfile.magicked = 0,
+    magicDSRun.state = 'censored',
+    magicDSFile.fault = 42
Index: trunk/ippTools/share/magictool_censor_raw.sql
===================================================================
--- trunk/ippTools/share/magictool_censor_raw.sql	(revision 24883)
+++ trunk/ippTools/share/magictool_censor_raw.sql	(revision 24883)
@@ -0,0 +1,11 @@
+UPDATE magicRun
+    JOIN magicDSRun USING(magic_id)
+    JOIN rawExp ON rawExp.magicked = magic_ds_id
+    JOIN rawImfile USING(exp_id) 
+    JOIN magicDSFile USING(magic_ds_id) 
+    JOIN magicRun USING(magic_id, exp_id)
+SET rawImfile.magicked = 0, 
+    rawExp.magicked = 0, 
+    magicDSRun.state = 'censored', 
+    magicDSFile.fault = 42
+
Index: trunk/ippTools/share/magictool_censor_warp.sql
===================================================================
--- trunk/ippTools/share/magictool_censor_warp.sql	(revision 24883)
+++ trunk/ippTools/share/magictool_censor_warp.sql	(revision 24883)
@@ -0,0 +1,9 @@
+UPDATE magicRun 
+    JOIN magicDSRun USING(magic_id)
+    JOIN magicDSFile USING(magic_ds_id)
+    JOIN warpRun ON magic_ds_id = magicked
+    JOIN warpSkyfile using(warp_id)
+SET warpRun.magicked = 0,
+    warpSkyfile.magicked = 0,
+    magicDSRun.state = 'censored',
+    magicDSFile.fault = 42