Changeset 27740 for trunk/ippTools/share

Timestamp:

Apr 23, 2010, 11:23:02 AM (16 years ago)

Author:

bills

Message:

Enable the postage stamp server to handle requests for stamps
from cleaned up data.

Location:

trunk/ippTools/share

Files:

• pstamptool_pendingdependent.sql (modified) (1 diff)
• pstamptool_revertdependent.sql (added)
• pstamptool_updatejob.sql (added)

trunk/ippTools/share/pstamptool_pendingdependent.sql

@@ -1 @@
-SELECT *
+SELECT DISTINCT pstampDependent.*
 FROM pstampDependent
-WHERE state = 'new'
+JOIN pstampJob USING(dep_id)
+JOIN pstampRequest USING(req_id)
+WHERE pstampDependent.state = 'new'
+    AND pstampJob.state = 'run'