Changeset 25835 for trunk/ippTools/share/disttool_pending_diff.sql

Timestamp:

Oct 14, 2009, 11:06:18 AM (17 years ago)

Author:

bills

Message:

Add data_group, dist_group, and note to the pipeline. These new columns will be used
for some of the tasks that label was used previously.

File:

• trunk/ippTools/share/disttool_pending_diff.sql (modified) (2 diffs)

trunk/ippTools/share/disttool_pending_diff.sql

@@ -2 +2 @@
     distRun.dist_id,
     distRun.label,
+    distTarget.dist_group,
     stage,
     stage_id,
@@ -18 +19 @@
     diffSkyfile.magicked
 FROM distRun
+JOIN distTarget USING(target_id, stage)
 JOIN diffRun ON stage_id = diff_id
 JOIN diffSkyfile using(diff_id)