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

Timestamp:

Oct 22, 2009, 4:51:58 PM (17 years ago)

Author:

Paul Price

Message:

Giving publishClient an 'active' column, and add mode to pubtool to turn this on and off. Only interested in active clients. This is so that I can do a publishing run that only sends data to particular clients.

File:

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

trunk/ippTools/share/pubtool_revert.sql

@@ -3 +3 @@
 WHERE publishDone.pub_id = publishRun.pub_id
     AND publishRun.client_id = publishClient.client_id
+    AND publishClient.active = 1
     AND publishDone.fault != 0