Changeset 18573 for trunk/ippTools/share/magictool_inputs.sql

Timestamp:

Jul 15, 2008, 4:16:16 PM (18 years ago)

Author:

Paul Price

Message:

Adding revert options, fault code handling.

File:

• trunk/ippTools/share/magictool_inputs.sql (modified) (2 diffs)

trunk/ippTools/share/magictool_inputs.sql

@@ -3 +3 @@
 -- Single skycells
 SELECT
+    magicRun.magic_id,
+    magicRun.state,
     magicInputSkyfile.node,
-    magicRun.state,
     diffSkyfile.uri,
     diffSkyfile.fault
 FROM magicInputSkyfile
 JOIN diffSkyfile
-    using(diff_id)
+    USING(diff_id)
 JOIN magicRun
     USING(magic_id)
@@ -15 +16 @@
 -- Merged skycells
 SELECT
+    magicRun.magic_id,
+    magicRun.state,
     magicTree.node,
-    magicRun.state,
     magicNodeResult.uri,
     magicNodeResult.fault