Changeset 14044 for trunk/ippMonitor/def/detProcessedImfile.d

Timestamp:

Jul 6, 2007, 11:44:02 AM (19 years ago)

Author:

eugene

Message:

update for change from exp_tag to exp_id and other recent mods

File:

• trunk/ippMonitor/def/detProcessedImfile.d (modified) (1 diff)

trunk/ippMonitor/def/detProcessedImfile.d

@@ -1 @@
-TABLE detProcessedImfile
+TABLE detProcessedImfile, rawExp
 TITLE detProcessedImfile
 FILE  detProcessedImfile.php
 MENU  ipp.imfiles.dat
 
-#     field        size   name      show   link to     extras
-FIELD det_id,        7,   Det ID
-FIELD exp_tag,      15,   Exposure
-FIELD class_id,      8,   Chip ID
-FIELD bg,            8,   backgnd
-FIELD bg_stdev,      8,   stdev
-FIELD bg_mean_stdev, 8,   [stdev]
-# FIELD recipe,     10,   recipe
-# FIELD uri,        20,   uri
-# FIELD path_base,  20,   path_base
+# the following WHERE clauses are added to all queries joined by AND
+WHERE detResidExp.exp_id = rawExp.exp_id
+
+#     field                             size   name      show   link to     extras
+FIELD detProcessedImfile.det_id,        7,   Det ID
+FIELD detProcessedImfile.exp_id,        5,   Exp ID
+FIELD rawExp.exp_name,                  5,   Exp Name
+FIELD detProcessedImfile.class_id,      8,   Chip ID
+FIELD detProcessedImfile.bg,            8,   backgnd
+FIELD detProcessedImfile.bg_stdev,      8,   stdev
+FIELD detProcessedImfile.bg_mean_stdev, 8,   [stdev]
+FIELD detProcessedImfile.path_base,     5,   path_base
 
 TAIL PHP insert_image ('PPIMAGE.JPEG1');