Changeset 31038 for trunk/ippTools/share/regtool_pendingburntoolimfile.sql

Timestamp:

Mar 24, 2011, 2:09:53 PM (15 years ago)

Author:

watersc1

Message:

implementation of summit_id index in summit{Exp,Imfile},pzDownload{Exp,Imfile},newExp tables.

File:

• trunk/ippTools/share/regtool_pendingburntoolimfile.sql (modified) (1 diff)

trunk/ippTools/share/regtool_pendingburntoolimfile.sql

@@ -22 +22 @@
        FROM
        summitExp
-       JOIN summitImfile USING(exp_name)
-       LEFT JOIN pzDownloadExp USING(exp_name)
-       LEFT JOIN newExp ON summitExp.exp_name = tmp_exp_name
+       JOIN summitImfile USING(summit_id)
+       LEFT JOIN pzDownloadExp USING(summit_id)
+       LEFT JOIN newExp USING(summit_id)
        LEFT JOIN newImfile ON (summitImfile.class_id = newImfile.tmp_class_id AND newExp.exp_id = newImfile.exp_id)
        LEFT JOIN rawExp ON rawExp.exp_id = newExp.exp_id