Changeset 19088
- Timestamp:
- Aug 16, 2008, 1:02:37 PM (18 years ago)
- Location:
- trunk/dbconfig
- Files:
-
- 2 edited
-
changes.txt (modified) (1 diff)
-
det.md (modified) (9 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/dbconfig/changes.txt
r18449 r19088 362 362 update chipRun set state = 'full' where state = 'stop'; 363 363 364 -- add 'data_state' to detrend tables 365 366 alter table detProcessedImfile add column data_state varchar(64) after path_base; 367 alter table detProcessedExp add column data_state varchar(64) after path_base; 368 alter table detStackedImfile add column data_state varchar(64) after user_5; 369 alter table detNormalizedStatImfile add column data_state varchar(64) after norm; 370 alter table detNormalizedImfile add column data_state varchar(64) after path_base; 371 alter table detNormalizedExp add column data_state varchar(64) after path_base; 372 alter table detResidImfile add column data_state varchar(64) after path_base; 373 alter table detResidExp add column data_state varchar(64) after path_base; 374 alter table detRunSummary add column data_state varchar(64) after iteration; 375 alter table detRegisteredImfile add column data_state varchar(64) after path_base; -
trunk/dbconfig/det.md
r15315 r19088 56 56 user_5 F64 0.0 57 57 path_base STR 255 58 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 58 59 fault S16 0 # Key NOT NULL 59 60 END … … 75 76 user_5 F64 0.0 76 77 path_base STR 255 78 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 77 79 fault S16 0 # Key NOT NULL 78 80 END … … 96 98 user_4 F64 0.0 97 99 user_5 F64 0.0 100 # XXX does it make sense to 'clean' the stacked imfiled? 101 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 98 102 fault S16 0 # Key NOT NULL 99 103 END … … 104 108 class_id STR 64 # Primary Key 105 109 norm F32 0.0 106 fault S16 0 # Key NOT NULL 107 END 108 110 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 111 fault S16 0 # Key NOT NULL 112 END 113 114 ## XXX this must match in fields with detRegisteredImfile 109 115 detNormalizedImfile METADATA 110 116 det_id S64 0 # Primary Key fkey(det_id) ref detInputExp(det_id) … … 121 127 user_5 F64 0.0 122 128 path_base STR 255 129 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 123 130 fault S16 0 # Key NOT NULL 124 131 END … … 137 144 user_5 F64 0.0 138 145 path_base STR 255 146 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 139 147 fault S16 0 # Key NOT NULL 140 148 END … … 179 187 user_5 F64 0.0 180 188 path_base STR 255 189 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 181 190 fault S16 0 # Key NOT NULL 182 191 END … … 205 214 user_5 F64 0.0 206 215 path_base STR 255 216 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 207 217 accept BOOL f 208 218 fault S16 0 # Key NOT NULL 209 219 END 210 220 221 # XXX this probably should have been defined at the start of a new iteration, not at the end. 211 222 detRunSummary METADATA 212 223 det_id S64 0 # Primary Key fkey(det_id, iteration) ref detInputExp(det_id, iteration) 213 224 iteration S32 0 # Primary Key fkey(det_id, iteration) ref detResidExp(det_id, iteration) 225 data_state STR 64 # full, goto_cleaned, cleaned, goto_full, goto_purged, purged 214 226 bg F64 0.0 215 227 bg_stdev F64 0.0 … … 237 249 user_5 F64 0.0 238 250 path_base STR 255 251 data_state STR 64 # full, cleaned, purged (only track end states; request states are in detRunSummary by iteration) 239 252 fault S16 0 # Key NOT NULL 240 253 END
Note:
See TracChangeset
for help on using the changeset viewer.
