Changeset 30102 for branches/eam_branches/ipp-20101205/ippTools/share/pubtool_definerun.sql

Timestamp:

Dec 17, 2010, 10:05:43 AM (16 years ago)

Author:

eugene

Message:

merge from trunk

File:

• branches/eam_branches/ipp-20101205/ippTools/share/pubtool_definerun.sql (modified) (4 diffs)

branches/eam_branches/ipp-20101205/ippTools/share/pubtool_definerun.sql

@@ -3 +3 @@
     client_id,
     stage_id,
-    src_label
+    src_label,
+    output_format
 FROM (
     -- Get diffs to publish
@@ -9 +10 @@
         client_id,
         diff_id AS stage_id,
-        diffRun.label AS src_label
+        diffRun.label AS src_label,
+        output_format
     FROM publishClient
     JOIN diffRun
@@ -28 +30 @@
         client_id,
         cam_id AS stage_id,
-        camRun.label AS src_label
+        camRun.label AS src_label,
+        output_format
     FROM publishClient
     JOIN camRun
@@ -43 +46 @@
         client_id,
         diff_phot_id AS stage_id,
-        diffPhotRun.label AS src_label
+        diffPhotRun.label AS src_label,
+        output_format
     FROM publishClient
     JOIN diffPhotRun