Changeset 20737 for trunk/ippTools/share/magictool_definebyquery_temp_create.sql

Timestamp:

Nov 13, 2008, 3:51:51 PM (17 years ago)

Author:

Paul Price

Message:

No need to have the warp_id in the magicBestDiffs table; besides, it
was wrong because the query in magictool_definebyquery_temp_insert.sql
doesn't set it correctly (was setting it to a random valid warp_id,
not necessarily the warp_id corresponding to the diff_id).

File:

• trunk/ippTools/share/magictool_definebyquery_temp_create.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)