Changeset 1200 for pykota/trunk/initscripts/postgresql

Timestamp:

11/21/03 15:28:46 (20 years ago)

Author:

jalet

Message:

More complete job history.

Location:

pykota/trunk/initscripts/postgresql

Files:

• pykota-postgresql.sql (modified) (4 diffs)
• README.postgresql (modified) (3 diffs)

pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

@@ -20 +20 @@
 --
 -- $Log$
+-- Revision 1.5  2003/11/21 14:28:45  jalet
+-- More complete job history.
+--
 -- Revision 1.4  2003/07/16 21:53:07  jalet
 -- Really big modifications wrt new configuration file's location and content.
@@ -97 +100 @@
                         hardlimit INT4,
                         datelimit TIMESTAMP);
+CREATE UNIQUE INDEX userpquota_up_id_ix ON userpquota (userid, printerid);
                         
 --
@@ -108 +112 @@
                         jobsize INT4,
                         action TEXT,
+                        filename TEXT,
+                        title TEXT,
+                        copies INT4,
+                        options TEXT,
                         jobdate TIMESTAMP DEFAULT now());
+CREATE INDEX jobhistory_p_id_ix ON jobhistory (printerid);
+CREATE INDEX jobhistory_pd_id_ix ON jobhistory (printerid, jobdate);
                         
 --
@@ -119 +129 @@
                          hardlimit INT4,
                          datelimit TIMESTAMP);
+CREATE UNIQUE INDEX grouppquota_up_id_ix ON grouppquota (groupid, printerid);
                         
 --                         

pykota/trunk/initscripts/postgresql/README.postgresql

@@ -51 +51 @@
 Upgrade scripts :
 
+  DON'T DO ANYTHING IF THIS IS YOUR FIRST INSTALLATION
+  OF PYKOTA.
+
   Some scripts to upgrade old PyKota databases to the new
   database schema are included. You may have to run all
@@ -56 +59 @@
   version of PyKota.
   
+  * An SQL script to upgrade a pre-1.16 PyKota Storage DataBase to
+    1.16 is included. Launch it this way on the Quota Storage Server :
+    
+        $ psql -U postgres pykota
+        pykota=# \i upgrade-to-1.16.sql
+        pykota=# \q
+        $
+        
+    This script adds some fields to the print job history, so that
+    more complete information will be known. The fields that
+    are added are : filename, title, copies and print command options.
+    Also some indexes are created to speed things up.
   
+What is below is for historical reasons only, real people don't use  
+such old beasts, and YOU SHOULDN'T EITHER !
+
   * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to
     1.14 is included. Launch it this way on the Quota Storage Server :
@@ -69 +87 @@
     messages in case he is over quota.
     
-What is below is for historical reasons only, real people don't use  
-such old beasts, and YOU SHOULDN'T EITHER !
-
   * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to 
     1.01 is still included for historical reasons. PLEASE DON'T USE IT !