Index: /branches/eam_branch_20080806/dbconfig/changes.txt
===================================================================
--- /branches/eam_branch_20080806/dbconfig/changes.txt	(revision 19066)
+++ /branches/eam_branch_20080806/dbconfig/changes.txt	(revision 19067)
@@ -362,2 +362,5 @@
 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;
Index: /branches/eam_branch_20080806/dbconfig/det.md
===================================================================
--- /branches/eam_branch_20080806/dbconfig/det.md	(revision 19066)
+++ /branches/eam_branch_20080806/dbconfig/det.md	(revision 19067)
@@ -112,4 +112,5 @@
 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,4 +249,5 @@
     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