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

Timestamp:

Jun 16, 2010, 3:23:47 PM (16 years ago)

Author:

Paul Price

Message:

When magicked data is cleaned, the 'magicked' column is set to -1.

File:

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

trunk/ippTools/share/pubtool_definerun.sql

@@ -21 +21 @@
         AND publishClient.active = 1
         AND diffRun.state IN ('full', 'cleaned', 'goto_cleaned')
-        AND (diffRun.magicked > 0 OR diffRun.diff_mode = 4 OR publishClient.magicked = 0)
+        AND (diffRun.magicked != 0 OR diffRun.diff_mode = 4 OR publishClient.magicked = 0)
     -- WHERE hook %s
     UNION
@@ -36 +36 @@
         AND publishClient.active = 1
         AND camRun.state IN ('full', 'cleaned', 'goto_cleaned')
-        AND (camRun.magicked > 0 OR publishClient.magicked = 0)
+        AND (camRun.magicked != 0 OR publishClient.magicked = 0)
     -- WHERE hook %s
     ) AS publishToDo