Changeset 24967 for trunk/ippTools

Timestamp:

Jul 31, 2009, 3:39:53 PM (17 years ago)

Author:

bills

Message:

Remove args and URI from pstampJob tables

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, exp_id, outputBase, fault)
- VALUES( %lld, '%s', '%s', '%s', '%s', %lld, '%s', %s)
+ (req_id, rownum, state, jobType, exp_id, outputBase, fault)
+ VALUES( %lld, '%s', '%s', '%s', %lld, '%s', %s)

trunk/ippTools/share/pstamptool_addjob_stampjob.sql

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1203 +1203 @@
         jobType VARCHAR(16),
         fault SMALLINT,
-        uri VARCHAR(255),
         exp_id BIGINT,
         outputBase VARCHAR(255),
-        args VARCHAR(511),
         PRIMARY KEY(job_id, req_id),
         KEY(job_id),