Changeset 23389 for trunk/ippTools/share/magicdstool_completed_runs.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_completed_runs.sql (modified) (4 diffs)

trunk/ippTools/share/magicdstool_completed_runs.sql

@@ -12 +12 @@
         AND magicDSFile.component = rawImfile.class_id
     WHERE
-        magicDSRun.state = 'run'
+        magicDSRun.state = 'new'
         AND magicDSRun.stage = 'raw'
     GROUP BY
@@ -30 +30 @@
         AND magicDSFile.component = chipProcessedImfile.class_id
     WHERE
-        magicDSRun.state = 'run'
+        magicDSRun.state = 'new'
         AND magicDSRun.stage = 'chip'
     GROUP BY
@@ -48 +48 @@
         AND magicDSFile.component = warpSkyfile.skycell_id
     WHERE
-        magicDSRun.state = 'run'
+        magicDSRun.state = 'new'
         AND magicDSRun.stage = 'warp'
         AND warpSkyfile.fault = 0
@@ -72 +72 @@
         AND magicDSFile.component = diffSkyfile.skycell_id
     WHERE
-        magicDSRun.state = 'run'
+        magicDSRun.state = 'new'
         AND magicDSRun.stage = 'diff'
         AND diffSkyfile.fault = 0