Changeset 29357 for trunk/ippTools/share/pubtool_revert.sql

Timestamp:

Oct 8, 2010, 11:13:00 AM (16 years ago)

Author:

bills

Message:

only revert runs in state new

File:

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

trunk/ippTools/share/pubtool_revert.sql

@@ -2 +2 @@
 USING publishDone, publishRun, publishClient
 WHERE publishDone.pub_id = publishRun.pub_id
+    AND publishRun.state = 'new'
     AND publishRun.client_id = publishClient.client_id
     AND publishClient.active = 1