Changeset 25793 for trunk/dbconfig

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

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• pstamp.md (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -1300 +1300 @@
 
 ALTER TABLE pstampJob ADD COLUMN options BIGINT;
+ALTER TABLE pstampJob ADD COLUMN dep_id BIGINT;
+CREATE TABLE pstampDependent (
+        dep_id BIGINT AUTO_INCREMENT,
+        stage      VARCHAR(64),
+        stage_id   BIGINT,
+        need_magic TINYINT,
+        image_db   VARCHAR(64),
+        rlabel     VARCHAR(64),
+        PRIMARY KEY(dep_id)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+

trunk/dbconfig/pstamp.md

@@ -40 +40 @@
     outputBase  STR         255
     options     S64         64
+    dep_id      S64         0
 END
+
+pstampDependent       METADATA
+    dep_id      S64         0       # Primary Key AUTO_INCREMENT
+    state       STR         64
+    stage       STR         64
+    stage_id    S64         0
+    imagedb     STR         64
+    rlabel      STR         64
+    no_magic    BOOL        f
+END