Changeset 24885 for trunk/ippTools/share/magictool_censor_raw.sql

Timestamp:

Jul 21, 2009, 3:07:43 PM (17 years ago)

Author:

bills

Message:

disable this mode it sin't ready yet

File:

• trunk/ippTools/share/magictool_censor_raw.sql (modified) (1 diff)

trunk/ippTools/share/magictool_censor_raw.sql

@@ -1 +1 @@
 UPDATE magicRun
     JOIN magicDSRun USING(magic_id)
+    JOIN magicDSFile USING(magic_ds_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)
+    JOIN rawImfile ON rawExp.exp_id = rawImfile.exp_id
 SET rawImfile.magicked = 0, 
     rawExp.magicked = 0,