Changeset 31740 for branches/sc_branches/ippMonitorLap/def/lapExposures.d

Timestamp:

Jun 28, 2011, 4:37:16 PM (15 years ago)

Author:

Serge CHASTEL

Message:

Updating with CZW req

File:

• branches/sc_branches/ippMonitorLap/def/lapExposures.d (modified) (3 diffs)

branches/sc_branches/ippMonitorLap/def/lapExposures.d

@@ -1 @@
-TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) 
+TABLE lapRun JOIN lapExp USING(lap_id) JOIN rawExp USING(exp_id,filter) JOIN chipRun USING(chip_id)
 #JOIN chipRun USING(lapExp.chip_id) 
 #JOIN chipRun AS pairRun USING(lapExp.pair_id)
@@ -13 +13 @@
 FIELD lapRun.seq_id,          6, %d,     seq_id
 FIELD lapExp.lap_id,          6, %d,     lap_id
+FIELD lapExp.data_state,      6, %s,     State (lapExp)
 FIELD lapExp.exp_id,          6, %d,     Exp ID,        value, rawImfile.php, ARG1
 FIELD lapExp.chip_id,         6, %d,     Chip ID,       value, chipStageExp.php, ARG2
-#FIELD chipRun.state,          6, %s,     State
+FIELD chipRun.state,          6, %s,     State (chipRun)
 FIELD lapExp.pair_id,         6, %d,     Pair ID,       value, chipStageExp.php, ARG3
 FIELD lapRun.tess_id,         8, %s,     tess_id
@@ -30 +31 @@
 FIELD lapExp.pairwise,        2, %d,     Pairwise
 FIELD lapExp.active,          2, %d,     Active
-FIELD lapExp.data_state,      15, %s,    State (lapExp)
 FIELD rawExp.dateobs,         19, %T,     Date/Time
 FIELD rawExp.object,          8, %s,     Object