IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 24185


Ignore:
Timestamp:
May 14, 2009, 3:30:50 PM (17 years ago)
Author:
bills
Message:

adapt to changes in the diff and magic tables

Location:
trunk/ippTools/share
Files:
3 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippTools/share/magicdstool_completed_runs.sql

    r23688 r24185  
    6666    JOIN magicInputSkyfile USING(magic_id)
    6767    JOIN diffSkyfile
    68         ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
     68        ON magicRun.diff_id = diffSkyfile.diff_id
    6969        AND magicInputSkyfile.node = diffSkyfile.skycell_id
    7070    LEFT JOIN magicDSFile

  • trunk/ippTools/share/magicdstool_getrunids.sql

    r20973 r24185  
    99JOIN magicInputSkyfile USING(magic_id)
    1010JOIN diffSkyfile
    11     ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
     11    ON magicRun.diff_id = diffSkyfile.diff_id
    1212    AND magicInputSkyfile.node = diffSkyfile.skycell_id
    1313JOIN diffInputSkyfile

  • trunk/ippTools/share/magicdstool_getskycells.sql

    r23688 r24185  
    22    diffSkyfile.diff_id,
    33    diffSkyfile.skycell_id,
    4     diffSkyfile.uri,
    54    diffSkyfile.path_base
    65FROM magicDSRun
    76JOIN magicRun USING(magic_id)
    8 JOIN magicInputSkyfile USING(magic_id, diff_id)
     7JOIN magicInputSkyfile USING(magic_id)
    98JOIN diffSkyfile
    10     ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
     9    ON magicRun.diff_id = diffSkyfile.diff_id
    1110    AND magicInputSkyfile.node = diffSkyfile.skycell_id
    1211JOIN diffInputSkyfile
Note: See TracChangeset for help on using the changeset viewer.