Changeset 16828 for trunk/ippTools/share

Timestamp:

Mar 5, 2008, 11:07:22 AM (18 years ago)

Author:

Paul Price

Message:

No warpInputExp any more.

Location:

trunk/ippTools/share

Files:

• difftool_inputskyfile.sql (modified) (2 diffs)
• stacktool_inputskyfile.sql (modified) (1 diff)

trunk/ippTools/share/difftool_inputskyfile.sql

@@ -17 +17 @@
         AND diffInputSkyfile.skycell_id = warpSkyfile.skycell_id
         AND diffInputSkyfile.tess_id    = warpSkyfile.tess_id
-    JOIN warpInputExp
-        ON diffInputSkyfile.warp_id = warpInputExp.warp_id
+    JOIN warpRun
+        ON diffInputSkyfile.warp_id = warpRun.warp_id
     JOIN camProcessedExp
-        ON warpInputExp.cam_id = camProcessedExp.cam_id
+        ON warpRun.cam_id = camProcessedExp.cam_id
     JOIN chipRun
         ON camProcessedExp.chip_id = chipRun.chip_id
@@ -47 +47 @@
     JOIN stackInputSkyfile
         ON diffInputSkyfile.stack_id = stackInputSkyfile.stack_id
-    JOIN warpInputExp
-        ON stackInputSkyfile.warp_id = warpInputExp.warp_id
+    JOIN warpRun
+        ON stackInputSkyfile.warp_id = warpRun.warp_id
     JOIN camProcessedExp
-        ON warpInputExp.cam_id = camProcessedExp.cam_id
+        ON warpRun.cam_id = camProcessedExp.cam_id
     JOIN chipRun
         ON camProcessedExp.chip_id = chipRun.chip_id

trunk/ippTools/share/stacktool_inputskyfile.sql

@@ -9 +9 @@
     AND stackRun.skycell_id       = warpSkyfile.skycell_id
     AND stackRun.tess_id          = warpSkyfile.tess_id
-JOIN warpInputExp
-    ON stackInputSkyfile.warp_id = warpInputExp.warp_id
+JOIN warpRun
+    ON stackInputSkyfile.warp_id = warpRun.warp_id
 JOIN camProcessedExp
-    ON warpInputExp.cam_id = camProcessedExp.cam_id
+    ON warpRun.cam_id = camProcessedExp.cam_id
 JOIN chipRun
     ON camProcessedExp.chip_id = chipRun.chip_id