Changeset 887 for pykota/trunk/initscripts/pykota-postgresql.sql

Timestamp:

04/08/03 22:38:08 (21 years ago)

Author:

jalet

Message:

The last job Id is saved now for each printer, this will probably
allow other accounting methods in the future.

Files:

• pykota/trunk/initscripts/pykota-postgresql.sql (modified) (2 diffs)

pykota/trunk/initscripts/pykota-postgresql.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.7  2003/04/08 20:38:08  jalet
+-- The last job Id is saved now for each printer, this will probably
+-- allow other accounting methods in the future.
+--
 -- Revision 1.6  2003/03/29 13:45:27  jalet
 -- GPL paragraphs were incorrectly (from memory) copied into the sources.
@@ -84 +88 @@
 CREATE TABLE printers(id SERIAL PRIMARY KEY NOT NULL,
                       printername TEXT UNIQUE NOT NULL,
+                      lastjobid TEXT,
                       lastusername TEXT,
                       pagecounter INT4 DEFAULT 0);