Changeset 20477

Timestamp:

Oct 30, 2008, 11:20:02 AM (18 years ago)

Author:

bills

Message:

add warp_id in magicBestDiffs

Location:

trunk/ippTools/share

Files:

• magictool_definebyquery_temp_create.sql (modified) (1 diff)
• magictool_definebyquery_temp_insert.sql (modified) (1 diff)

trunk/ippTools/share/magictool_definebyquery_temp_create.sql

@@ -3 +3 @@
 skycell_id VARCHAR(64),
 tess_id VARCHAR(64),
+warp_id BIGINT,
 diff_id BIGINT,
 PRIMARY KEY(exp_id, skycell_id, tess_id)

trunk/ippTools/share/magictool_definebyquery_temp_insert.sql

@@ -5 +5 @@
     warpSkyfile.skycell_id,
     warpSkyfile.tess_id,
+    warpRun.warp_id AS warp_id,
     MAX(diffSkyfile.diff_id) AS diff_id
 FROM rawExp