Changeset 26485 for trunk/ippTools/share/stacktool_revertsumskyfile_delete.sql

Timestamp:

Dec 23, 2009, 6:39:17 PM (16 years ago)

Author:

bills

Message:

dont' delete stackSumSkyfile unless stackRun.state = 'new'

File:

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

trunk/ippTools/share/stacktool_revertsumskyfile_delete.sql

@@ -2 +2 @@
 USING stackSumSkyfile, stackRun
 WHERE stackSumSkyfile.stack_id = stackRun.stack_id
+    AND stackRun.state = 'new'
     AND fault != 0