IPP Software

Navigation

Tools

IPP Links

Communication

Pan-STARRS Links

Context Navigation

← Previous Change
Next Change →

Changeset 24244 for branches/cnb_branches/cnb_branch_20090301/ippTools/share/magictool_inputskyfile.sql

Timestamp:

May 26, 2009, 1:59:32 PM (17 years ago)

Author:

beaumont

Message:

merged with trunk

Location:

branches/cnb_branches/cnb_branch_20090301

Files:

: 3 edited

. (modified) (1 prop)
ippTools/share (modified) (1 prop)
ippTools/share/magictool_inputskyfile.sql (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed

branches/cnb_branches/cnb_branch_20090301

Property svn:mergeinfo changed

/branches/pap (added)	merged: 23511,23520-23521,23532,23578-23581,23596-23599,23603-23604,23606-23608,23619-23621,23638-23639,23641,23646-23648,23651-23653,23656,23672-23674,23677-23684,23690,23704,23711,23719,23723,23730-23735
/branches/pap_magic (added)	merged: 24120,24132-24136,24145,24147-24154,24156-24164,24168-24173
/trunk	merged: 23600-23602,23605,23609-23618,23622-23627,23629-23637,23640,23642-23645,23654-23655,23657-23671,23675-23676,23685-23688,23692-23703,23705-23707,23709-23710,23712-23713,23716-23717,23720-23722,23724,23728,23736-23740,23742-23748,23750-23753,23756-23759,23761,23763-23769,23771,23773-23851,23853,23859,23861-23866,23868-23874,23876-23928,23931-23940,23944-23947,23949-24012,24014-24068,24070-24119,24121-24131,24137-24144,24146,24155,24165-24167,24174-24175,24177-24220,24222-24237,24239-24242

branches/cnb_branches/cnb_branch_20090301/ippTools/share

Property svn:ignore

old	new
1	1	Makefile.in
2	2	Makefile
	3	pxadmin_create_mirror_tables.sql

branches/cnb_branches/cnb_branch_20090301/ippTools/share/magictool_inputskyfile.sql

-              r23594
+              r24244
 SELECT
     magicInputSkyfile.*,
+    diffSkyfile.uri
+    magicRun.inverse,
+    diffSkyfile.path_base
 FROM magicRun
+JOIN magicInputSkyfile
+    USING(magic_id)
+JOIN magicInputSkyfile USING(magic_id)
 JOIN diffSkyfile
     ON magicInputSkyfile.diff_id = diffSkyfile.diff_id
     AND magicInputSkyfile.node = diffSkyfile.skycell_id
+    ON diffSkyfile.diff_id = magicRun.diff_id
+    AND diffSkyfile.skycell_id = magicInputSkyfile.node
 WHERE
     magicRun.state = 'new'

Note: See TracChangeset for help on using the changeset viewer.

Download in other formats: