Changeset 25493 for trunk/ippTools/share/rcserver_updatercrun.sql

Timestamp:

Sep 23, 2009, 10:22:33 AM (17 years ago)

Author:

bills

Message:

In distribution server merge rcDSProduct into rcDestination. It was illogical for
a product to be shared by multiple destinations.
In defineinterest define by query to allow destination names and target parameters
to be used. Much more administrator friendly.
Add a label to pstampRequest. Not used yet.
Split reverting of faults in distRuns from faults building components.

File:

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

trunk/ippTools/share/rcserver_updatercrun.sql

@@ -1 +1 @@
 UPDATE rcRun
 JOIN rcDestination USING(dest_id)
-JOIN rcDSProduct USING(prod_id) 
-JOIN rcDSFileset using(prod_id, fs_id)
+JOIN rcDSFileset using(dest_id, fs_id)
 SET
-rcRun.fault= 42, rcDestination.last_fileset = 'o4741g0236o.chip.14519.33.1'
-
-
-