Changeset 25793 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Oct 7, 2009, 1:05:22 PM (17 years ago)

Author:

bills

Message:

Add new table pstampDependent. An entry gets created by the postage stamp request parser
when the source run has been cleaned. The pstampJob is blocked from running until
the system detects that the run has been updated and magicked. (This code is yet
to be developed.)

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1250 +1250 @@
         outputBase VARCHAR(255),
         options BIGINT,
+        dep_id BIGINT,
         PRIMARY KEY(job_id, req_id),
         KEY(job_id),
         FOREIGN KEY(req_id) REFERENCES pstampRequest(req_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+
+CREATE TABLE pstampDependent (
+        dep_id BIGINT AUTO_INCREMENT,
+        state      VARCHAR(64),
+        stage      VARCHAR(64),
+        stage_id   BIGINT,
+        image_db   VARCHAR(64),
+        rlabel     VARCHAR(64),
+        need_magic TINYINT,
+        PRIMARY KEY(dep_id)
 ) ENGINE=innodb DEFAULT CHARSET=latin1;