Changeset 30314 for trunk/ippTools/share

Timestamp:

Jan 20, 2011, 10:24:30 AM (16 years ago)

Author:

bills

Message:

add a column pstampDataStore.need_magic that indicates whether requests from that source
are allowed to extract uncensored postage stamps.

Location:

trunk/ippTools/share

Files:

• pstamptool_pendingreq.sql (modified) (1 diff)
• pxadmin_create_tables.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_pendingreq.sql

@@ -3 +3 @@
     pstampRequest.*,
     pstampDataStore.outProduct AS ds_outProduct,
+    IFNULL(pstampDataStore.need_magic, 1) AS need_magic,
     IFNULL(Label.priority, 10000) AS priority
 FROM pstampRequest

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1391 +1391 @@
         uri VARCHAR(255),
         pollInterval INTEGER DEFAULT 60,
+        need_magic TINYINT,
         PRIMARY KEY(ds_id),
         KEY(ds_id)