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

Timestamp:

Mar 3, 2010, 4:38:26 PM (16 years ago)

Author:

bills

Message:

Add timestamp and poll interval to pstampDataStore. Don't poll for new
requests at each data store unless the time since the last poll is greater
than the requested interval
Add label to pstampDataStore. Use it to set label for requests.
Support -label in the query modes of pstamptool.

File:

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

trunk/ippTools/share/pxadmin_create_tables.sql

@@ -1269 +1269 @@
         state VARCHAR(64),
         lastFileset VARCHAR(64),
+        timestamp  DATETIME,
+        label VARCHAR(64),
         outProduct VARCHAR(64) UNIQUE,
         uri VARCHAR(255),
+        pollInterval INTEGER DEFAULT 60,
         PRIMARY KEY(ds_id),
         KEY(ds_id)