Changeset 27028 for trunk/ippTools/share

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.

Location:

trunk/ippTools/share

Files:

• pubtool_definerun.sql (modified) (2 diffs)
• pxadmin_create_tables.sql (modified) (1 diff)

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1494 +1494 @@
     product VARCHAR(64),             -- product name
     stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)
+    magicked TINYINT DEFAULT 1, -- Require magicked data?
     workdir VARCHAR(255) NOT NULL, -- working directory
     comment VARCHAR(255),            -- for human memory