Changeset 19334 for trunk/dbconfig

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.

Location:

trunk/dbconfig

Files:

• changes.txt (modified) (1 diff)
• chip.md (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';

trunk/dbconfig/chip.md

@@ -17 +17 @@
     exp_id          S64     64      # Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id)
     class_id        STR     64      # Primary Key
+    data_state      STR     64      # Key
     uri             STR     255
     bg              F32     0.0