Changeset 19219 for trunk/ippTools/share/pstamptool_addjob_otherjob.sql

Timestamp:

Aug 26, 2008, 1:25:33 PM (18 years ago)

Author:

bills

Message:

add exp_id to pstampJob.
Rename -processedreq to -updatereq and -processedjob to -updatejob
to be clearer about what these modes do.
Fix handling of the various ids as S64 instead of strings

File:

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

trunk/ippTools/share/pstamptool_addjob_otherjob.sql

@@ -1 +1 @@
 INSERT INTO pstampJob
- (req_id, rownum, state, jobType, uri, outputBase, fault)
- VALUES( %s, '%s', '%s', '%s', '%s', '%s', %s)
+ (req_id, rownum, state, jobType, uri, exp_id, outputBase, fault)
+ VALUES( %lld, '%s', '%s', '%s', '%s', %lld, '%s', %s)