Changeset 19334 for trunk/dbconfig/changes.txt

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/dbconfig/changes.txt (modified) (1 diff)

trunk/dbconfig/changes.txt

@@ -423 +423 @@
 
 -- ALTER TABLE flatcorrCamLink ADD COLUMN chip_id BIGINT AFTER corr_id;
+
+ALTER TABLE chipProcessedImfile ADD COLUMN data_state VARCHAR(64) AFTER
+class_id;
+UPDATE chipProcessedImfile SET data_state = 'full';