Changeset 27028 for trunk/ippTools/share/pubtool_definerun.sql

Timestamp:

Feb 22, 2010, 1:44:30 PM (16 years ago)

Author:

Paul Price

Message:

Schema change to support requirement of magicked detections for MOPS publishing.

File:

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

trunk/ippTools/share/pubtool_definerun.sql

@@ -15 +15 @@
         AND publishClient.active = 1
         AND diffRun.state = 'full'
+        AND (diffRun.magicked > 0 OR publishClient.magicked = 0)
     -- WHERE hook %s
     UNION
@@ -27 +28 @@
         AND publishClient.active = 1
         AND camRun.state = 'full'
+        AND (camRun.magicked > 0 OR publishClient.magicked = 0)
     -- WHERE hook %s
     ) AS publishToDo