Changeset 23885 for trunk/ippTools/share/receivetool_revert.sql

Timestamp:

Apr 16, 2009, 12:39:27 PM (17 years ago)

Author:

Paul Price

Message:

Modifying distribution client workflow (currently composed of receivetool and associated tables) since Bill points out that a fileset is composed of files, and we don't want to download them all serially.

File:

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

trunk/ippTools/share/receivetool_revert.sql

@@ -1 +1 @@
 DELETE FROM receiveResult
-USING receiveResult, receiveRun, receiveSource
-WHERE receiveResult.receive_id = receiveRun.receive_id
-    AND receiveRun.source_id = receiveSource.source_id
+USING receiveResult, receiveFile, receiveFileset, receiveSource
+WHERE receiveResult.file_id = receiveFile.file_id
+    AND receiveFile.fileset_id = receiveFileset.fileset_id
+    AND receiveFileset.source_id = receiveSource.source_id
     AND fault != 0