Changeset 19067

Timestamp:

Aug 14, 2008, 2:41:54 PM (18 years ago)

Author:

eugene

Message:

updates for cleanup stages

Location:

branches/eam_branch_20080806/dbconfig

Files:

• changes.txt (modified) (1 diff)
• det.md (modified) (2 diffs)

branches/eam_branch_20080806/dbconfig/changes.txt

@@ -362 +362 @@
 update chipRun set state = 'full' where state = 'stop';
 
+-- add 'data_state' to detrend tables
+
+alter table detRegisteredImfile add column data_state varchar(64) after path_base;

branches/eam_branch_20080806/dbconfig/det.md

@@ -112 +112 @@
 END
 
+## XXX this must match in fields with detRegisteredImfile
 detNormalizedImfile METADATA
     det_id      S64         0       # Primary Key fkey(det_id) ref detInputExp(det_id)
@@ -248 +249 @@
     user_5      F64         0.0
     path_base   STR         255
+    data_state  STR         64      # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration)
     fault       S16         0       # Key NOT NULL
 END