Changeset 23389 for trunk/ippTools/share/magicdstool_todestreak.sql

Timestamp:

Mar 18, 2009, 10:18:37 AM (17 years ago)

Author:

bills

Message:

change states from 'run' and 'stop' to 'new' and 'full'
add label to magicDSRun

File:

• trunk/ippTools/share/magicdstool_todestreak.sql (modified) (4 diffs)

trunk/ippTools/share/magicdstool_todestreak.sql

@@ -26 +26 @@
     AND magicDSFile.component = rawImfile.class_id
 WHERE
-    magicDSRun.state = 'run'
+    magicDSRun.state = 'new'
     AND magicDSRun.stage = 'raw'
     AND magicDSFile.component IS NULL
@@ -57 +57 @@
     AND magicDSFile.component = chipProcessedImfile.class_id
 WHERE
-    magicDSRun.state = 'run'
+    magicDSRun.state = 'new'
     AND magicDSRun.stage = 'chip'
     AND chipRun.state = 'full'
@@ -91 +91 @@
     AND magicDSFile.component = warpSkyfile.skycell_id
 WHERE
-    magicDSRun.state = 'run'
+    magicDSRun.state = 'new'
     AND magicDSRun.stage = 'warp'
     AND warpRun.state = 'full'
@@ -127 +127 @@
     AND magicDSFile.component = diffSkyfile.skycell_id
 WHERE
-    magicDSRun.state = 'run'
+    magicDSRun.state = 'new'
     AND magicDSRun.stage = 'diff'
     AND diffSkyfile.fault = 0