Changeset 23861 for trunk/ippTools/share/disttool_pendingfileset.sql

Timestamp:

Apr 14, 2009, 3:14:27 PM (17 years ago)

Author:

bills

Message:

add task to build data store filesets for distRuns

File:

• trunk/ippTools/share/disttool_pendingfileset.sql (modified) (1 diff)

trunk/ippTools/share/disttool_pendingfileset.sql

@@ -5 +5 @@
     stage_id,
     CONCAT_WS('.', distRun.outroot, CONVERT(distRun.dist_id, CHAR)) as dist_dir,
-    rcDSProduct.*
+    rcDSProduct.name AS product_name,
+    rcDSProduct.prod_id,
+    rcDSProduct.dbname AS ds_dbname,
+    rcDSProduct.dbhost AS ds_dbhost
 FROM rcDestination 
 JOIN rcInterest USING(dest_id)