Changeset 23700 for trunk/ippTools/share/disttool_pendingcomponent.sql

Timestamp:

Apr 3, 2009, 10:59:27 AM (17 years ago)

Author:

bills

Message:

add no_magic flag to the output

File:

• trunk/ippTools/share/disttool_pendingcomponent.sql (modified) (7 diffs)

trunk/ippTools/share/disttool_pendingcomponent.sql

@@ -13 +13 @@
     NULL as state,
     NULL as data_state,
+    distRun.no_magic,
     rawImfile.magicked
 FROM distRun
@@ -59 +60 @@
     chipRun.state,
     chipProcessedImfile.data_state,
+    distRun.no_magic,
     chipProcessedImfile.magicked
 FROM distRun
@@ -87 +89 @@
     camRun.state,
     NULL,
-    0
+    distRun.no_magic,
+    chipProcessedImfile.magicked
 FROM distRun
 JOIN camRun ON camRun.cam_id = distRun.stage_id
@@ -117 +120 @@
     fakeRun.state,
     NULL,
+    distRun.no_magic,
     0
 FROM distRun
@@ -146 +150 @@
     warpRun.state,
     warpSkyfile.data_state,
+    distRun.no_magic,
     warpSkyfile.magicked
 FROM distRun
@@ -179 +184 @@
     -- diffSkyfile.data_state,
     'full' AS data_state,
+    distRun.no_magic,
     diffSkyfile.magicked
 FROM distRun
@@ -209 +215 @@
     -- stackSumSkyfile.data_state,
     'full' AS data_state,
+    1 AS no_magic,
     0 AS magicked
 FROM distRun