Changeset 24120 for branches/pap_magic/ippTools/share/difftool_skyfile.sql

Timestamp:

May 8, 2009, 5:21:35 PM (17 years ago)

Author:

Paul Price

Message:

Branching for magic development (make it work with warpwarp diffs).

Location:

branches/pap_magic

Files:

• . (copied) (copied from trunk )
• ippTools/share/difftool_skyfile.sql (modified) (1 diff)

branches/pap_magic/ippTools/share/difftool_skyfile.sql

@@ -8 +8 @@
     stack1,
     warp2,
-    stack2,
-    exp_id
+    stack2
 FROM diffRun
-JOIN diffSkyfile
-    USING(diff_id)
-JOIN diffInputSkyfile
-    USING (diff_id, skycell_id)
+JOIN diffSkyfile USING(diff_id)
+JOIN diffInputSkyfile USING(diff_id, skycell_id)
 JOIN warpRun
     ON warpRun.warp_id = diffInputSkyfile.warp1
-JOIN rawExp
-    USING(exp_id)
+JOIN fakeRun USING(fake_id)
+JOIN camRun USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)