Changeset 24149 for branches/pap_magic/ippTools/share/magictool_inputskyfile.sql

Timestamp:

May 12, 2009, 4:07:48 PM (17 years ago)

Author:

Paul Price

Message:

Reworking magic (and some diff) to be ready for performing magic on warp-warp diffs. Several database changes to diff and magic tables because we can no longer assume that a diff is associated with a single exposure. Ready for testing.

File:

• branches/pap_magic/ippTools/share/magictool_inputskyfile.sql (modified) (1 diff)

branches/pap_magic/ippTools/share/magictool_inputskyfile.sql

@@ -1 +1 @@
 SELECT
     magicInputSkyfile.*,
-    diffSkyfile.uri
+    magicRun.inverse,
+    diffSkyfile.path_base
 FROM magicRun
-JOIN magicInputSkyfile
-    USING(magic_id)
+JOIN magicInputSkyfile USING(magic_id)
 JOIN diffSkyfile
     ON magicInputSkyfile.diff_id = diffSkyfile.diff_id