Changeset 19219 for trunk/ippTools/share

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

Location:

trunk/ippTools/share

Files:

• pstamptool_addjob_otherjob.sql (modified) (1 diff)
• pstamptool_addjob_stampjob.sql (modified) (1 diff)
• pxadmin_create_tables.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)

trunk/ippTools/share/pstamptool_addjob_stampjob.sql

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1015 +1015 @@
         fault SMALLINT,
         uri VARCHAR(255),
+        exp_id BIGINT,
         outputBase VARCHAR(255),
         args VARCHAR(511),