Changeset 21308 for trunk/ippTools/share/warptool_towarped.sql

Timestamp:

Feb 5, 2009, 9:35:41 AM (17 years ago)

Author:

bills

Message:

Changed the way image ids are handled. For chip and warp new tables are
added the sole purpose of which are to create the image ids before
the images are created. For diff the id is added to diffInputSkyfile

File:

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

trunk/ippTools/share/warptool_towarped.sql

@@ -1 +1 @@
 SELECT DISTINCT
     warpSkyCellMap.warp_id,
-    0 as warp_skyfile_id,
+    warpImfile.warp_skyfile_id,
     warpSkyCellMap.skycell_id,
     warpSkyCellMap.tess_id,
@@ -13 +13 @@
 JOIN warpSkyCellMap
     USING(warp_id)
+JOIN warpImfile
+    ON warpSkyCellMap.warp_id = warpImfile.warp_id
+    AND warpSkyCellMap.skycell_id = warpImfile.skycell_id
 JOIN fakeRun
     USING(fake_id)