Changeset 24967

Timestamp:

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

Author:

bills

Message:

Remove args and URI from pstampJob tables

Location:

trunk

Files:

• dbconfig/changes.txt (modified) (1 diff)
• dbconfig/pstamp.md (modified) (1 diff)
• ippTools/share/pstamptool_addjob_otherjob.sql (modified) (1 diff)
• ippTools/share/pstamptool_addjob_stampjob.sql (modified) (1 diff)
• ippTools/share/pxadmin_create_tables.sql (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1201 +1201 @@
 ALTER TABLE distTarget DROP KEY clean;
 ALTER TABLE distTarget ADD CONSTRAINT UNIQUE(label, filter, stage, clean);
+
+ALTER TABLE pstampJob DROP COLUMN args;
+ALTER TABLE pstampJob DROP COLUMN uri;

trunk/dbconfig/pstamp.md

@@ -36 +36 @@
     jobType     STR         16
     fault       S32         0
-    uri         STR         255
     exp_id      S64         0
     outputBase  STR         255
-    args        STR         511
 END

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),