Changeset 25929 for trunk/ippTools/share/pxadmin_create_tables.sql

Timestamp:

Oct 22, 2009, 4:51:58 PM (17 years ago)

Author:

Paul Price

Message:

Giving publishClient an 'active' column, and add mode to pubtool to turn this on and off. Only interested in active clients. This is so that I can do a publishing run that only sends data to particular clients.

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1485 +1485 @@
 CREATE TABLE publishClient (
     client_id BIGINT AUTO_INCREMENT, -- unique identifier
+    active TINYINT DEFAULT 0,        -- whether we should worry about this or not
     product VARCHAR(64),             -- product name
     stage VARCHAR(64) NOT NULL, -- stage of interest (chip, camera, diff, etc.)