Changeset 17226 for trunk/ippTools/share

Timestamp:

Mar 28, 2008, 5:00:10 PM (18 years ago)

Author:

jhoblitt

Message:

implement warptool -revertwarped query support

File:

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

trunk/ippTools/share/warptool_revertwarped.sql

@@ -1 +1 @@
 DELETE FROM warpSkyfile
+USING warpSkyfile, warpRun, camRun, chipRun, rawExp
 WHERE
-    fault != 0
+    warpSkyfile.warp_id = warpRun.warp_id
+    AND warpRun.cam_id = camRun.cam_id
+    AND camRun.chip_id = chipRun.chip_id
+    AND chipRun.exp_id = rawExp.exp_id
+    AND warpSkyfile.fault != 0