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

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

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -2258 +2258 @@
 CREATE TABLE lapGroup  (
     seq_id  BIGINT,
+    tess_id VARCHAR(64),
     projection_cell VARCHAR(64),
     state   VARCHAR(16),
+    label   VARCHAR(64),
+    registered TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- time group was registered
     fault   SMALLINT,
-    PRIMARY KEY(seq_id, projection_cell),
+    PRIMARY KEY(seq_id, tess_id, projection_cell),
     KEY(state),
     KEY(fault),