Changeset 27856 for trunk/dbconfig

Timestamp:

May 4, 2010, 10:50:29 AM (16 years ago)

Author:

bills

Message:

Add table Label which through priority column may be used to order
items pending for processing.
Implement usage of this table in the pstamptool pending modes and
chiptool -pendingimfile.
Various other postage stamp changes including adding pstampDependent.outdir

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (2 diffs)
• ipp.m4 (modified) (1 diff)
• label.md (added)

trunk/dbconfig/changes.txt

@@ -1595 +1595 @@
 ALTER TABLE pstampDependent ADD KEY (stage);
 ALTER TABLE pstampDependent ADD KEY (stage_id);
+ALTER TABLE pstampDependent ADD KEY (component);
+ALTER TABLE pstampDependent ADD KEY (imagedb);
 
 ALTER TABLE magicDSRun ADD KEY(stage);
@@ -1602 +1604 @@
 ALTER TABLE distTarget ADD KEY(stage), ADD KEY(dist_group), ADD KEY(filter), ADD KEY(state);
 
+CREATE TABLE Label (
+    label       VARCHAR(64),
+    priority    INT,
+    active      TINYINT,
+    comment     VARCHAR(80),
+    PRIMARY KEY(label),
+    KEY(priority),
+    KEY(active)
+) ENGINE=innodb DEFAULT CHARSET=latin1;
+

trunk/dbconfig/ipp.m4

@@ -21 +21 @@
 include(stack.md)
 include(det.md)
+include(label.md)
 include(magic.md)
 include(calibration.md)