Changeset 23894 for trunk/ippTools/share

Timestamp:

Apr 16, 2009, 5:54:55 PM (17 years ago)

Author:

Paul Price

Message:

Distribution client workflow is now working!

Location:

trunk/ippTools/share

Files:

• pxadmin_drop_tables.sql (modified) (1 diff)
• receivetool_pendingfile.sql (modified) (1 diff)

trunk/ippTools/share/pxadmin_drop_tables.sql

@@ -69 +69 @@
 DROP TABLE IF EXISTS rcDSFileset;
 DROP TABLE IF EXISTS rcRun;
+DROP TABLE IF EXISTS receiveSource;
+DROP TABLE IF EXISTS receiveFileset;
+DROP TABLE IF EXISTS receiveFile;
+DROP TABLE IF EXISTS receiveResult;
 
 SET FOREIGN_KEY_CHECKS=1

trunk/ippTools/share/receivetool_pendingfile.sql

@@ -1 @@
-SELECT *
+SELECT
+    receiveFile.file_id,
+    source,
+    product,
+    workdir,
+    fileset,
+    file
 FROM receiveFile
 JOIN receiveFileset USING(fileset_id)
 JOIN receiveSource USING(source_id)
-LEFT JOIN receiveResult USING(file_id)
-WHERE receiveFile.file_id IS NULL
+LEFT JOIN receiveResult
+    ON receiveResult.file_id = receiveFile.file_id
+WHERE receiveResult.file_id IS NULL