Changeset 35308 for trunk/dbconfig

Timestamp:

Mar 12, 2013, 3:29:45 PM (13 years ago)

Author:

bills

Message:

sript, ippTools, and database changes to support queuing staticsky runs
on the basis of lapGroups collections of lapRuns that have finished for
each of a list of filters

Location:

trunk/dbconfig

Files:

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

trunk/dbconfig/changes.txt

@@ -2388 +2388 @@
 CREATE TABLE lapGroup  (
     seq_id  BIGINT,
+    tess_id VARCHAR(64),
     projection_cell VARCHAR(64),
     state   VARCHAR(16),
+    label   VARCHAR(654),
+    registered TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
     fault   SMALLINT,
     PRIMARY KEY(seq_id, projection_cell),

trunk/dbconfig/lap.md

@@ -33 +33 @@
 lapGroup METADATA
     seq_id          S64 0
+    tess_id         STR 64
     projection_cell STR 64
     state           STR 64
+    label           STR 64
+    registered      TAI NULL 
     fault           S16 0
 end