Changeset 33989 for trunk/ippTools/share

Timestamp:

Jun 7, 2012, 11:42:36 AM (14 years ago)

Author:

heather

Message:

first crack at fixing staticksy/addstar filename problems. Need to test (best
as ippdvo)

Location:

trunk/ippTools/share

Files:

• addtool_find_sky_id_multi.sql (modified) (1 diff)
• addtool_find_sky_id_multi_dvo.sql (modified) (1 diff)

trunk/ippTools/share/addtool_find_sky_id_multi.sql

@@ -2 +2 @@
      distinct(sky_id) as stage_id,
      staticskyRun.*,
-    staticskyResult.num_inputs
+    staticskyResult.num_inputs, stack_id
 FROM 
      staticskyRun

trunk/ippTools/share/addtool_find_sky_id_multi_dvo.sql

@@ -1 @@
-SELECT distinct(sky_id) as stage_id, staticskyRun.*, staticskyResult.num_inputs FROM staticskyResult
+SELECT distinct(sky_id) as stage_id, staticskyRun.*, staticskyResult.num_inputs, stack_id FROM staticskyResult
 JOIN staticskyRun USING(sky_id)
 join staticskyInput using(sky_id)