Changeset 21308 for trunk/ippTools/share/chiptool_pendingimfile.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/chiptool_pendingimfile.sql (modified) (2 diffs)

trunk/ippTools/share/chiptool_pendingimfile.sql

@@ -1 +1 @@
 SELECT
     chipRun.*,
-    0 as chip_imfile_id,
+    chipImfile.chip_imfile_id,
     rawImfile.class_id,
     rawImfile.uri,
@@ -9 +9 @@
     rawExp.telescope,
     rawExp.filelevel
-FROM chipRun
+FROM chipImfile
+JOIN chipRun
+    USING(chip_id)
 JOIN rawExp
     USING(exp_id)