Changeset 24427 for branches/pap_mops/ippTools/share/pubtool_revert.sql

Timestamp:

Jun 15, 2009, 5:28:09 PM (17 years ago)

Author:

Paul Price

Message:

Adding script to do the actual publishing to DataStore. Decided to bundle all components into the same script (we're working with detections, it's serial, should be fast) to simply things (can remove the 'advance' mode for pubtool). Everything compiles, not tested yet.

File:

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

branches/pap_mops/ippTools/share/pubtool_revert.sql

@@ -1 @@
-DELETE FROM publishFile
-USING publishFile, publishRun, publishClient
-WHERE publishFile.pub_id = publishRun.pub_id
+DELETE FROM publishDone
+USING publishDone, publishRun, publishClient
+WHERE publishDone.pub_id = publishRun.pub_id
     AND publishRun.client_id = publishClient.client_id
-    AND receiveResult.fault != 0
+    AND publishDone.fault != 0