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

Timestamp:

Sep 2, 2008, 2:05:26 PM (18 years ago)

Author:

bills

Message:

Add modes for transitioning chipProcessedImfiles from full to cleaned
and cleaned to full and full to purged.
Added COLUMN data_state to chipProcessedImfile to record the state.

File:

• trunk/ippTools/share/pxadmin_create_tables.sql (modified) (2 diffs)

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -261 +261 @@
     exp_id BIGINT,
     class_id VARCHAR(64),
+    data_state VARCHAR(64),
     uri VARCHAR(255),
     bg FLOAT,
@@ -289 +290 @@
     fault SMALLINT NOT NULL,
     PRIMARY KEY(chip_id, exp_id, class_id),
+    KEY(data_state),
     KEY(fault),
     FOREIGN KEY (chip_id, exp_id)