Changeset 887 for pykota/trunk/initscripts

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.

Location:

pykota/trunk/initscripts

Files:

• pykota-postgresql.sql (modified) (2 diffs)
• README (modified) (1 diff)
• README.postgresql (modified) (4 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);

pykota/trunk/initscripts/README

@@ -22 +22 @@
 This directory contains scripts to initialise the PyKota
 storage database. Use the one which best suits your need
-depending on the storage backend you want to use. Each
-script has an associated README file, be sure to read 
-this as well :
+depending on the storage backend you want to use.
 
-        File                            Backend
-        --------------------------------------------------
-         pykota-posgresql.sql | PostgreSQL storage
-pykota-upgrade-postgresql.sql | Upgrade database schema from pre 1.01
-                              |
-        
-============================================================
+
+Files :
+=======
+
+  * pykota-postgresql.sql :
+  
+    This file creates an empty Quota Storage Database, using PostgreSQL
+    as a backend. You have to use it the first time you install PyKota
+    if you want to use PostgreSQL as the Quota Storage Backend.
+    
+  * pykota-upgrade-postgresql.sql :
+  
+    This files upgrades the PostgreSQL Quota Storage Database schema
+    from versions before 1.01 to version 1.01.
+    
+  * upgrade-1.01-to-1.03.sh :
+  
+    This shell script upgrades the PostgreSQL Quota Storage Database schema
+    from versions 1.01 or 1.02 to version 1.03.
+    PLEASE DO A BACKUP OF YOUR PYKOTA DATABASE BEFORE RUNNING THIS SCRIPT !
+    Also this script will try to connect to PostgreSQL as the postgres user
+    (i.e. PostgreSQL's administrator), on the local machine (PyKota Storage 
+    Server), without prompting for a password. Please read this script and 
+    adapt it to your own configuration before running it. THIS IS IMPORTANT.
+  

pykota/trunk/initscripts/README.postgresql

@@ -27 +27 @@
 
 If you have already installed PyKota, and have datas in your
-Quota Storage DataBase, you may prefer to  skip this section
+Quota Storage DataBase, you may prefer to skip this section
 and read the next one.
 
@@ -49 +49 @@
 ============================================================
 
-Upgrade script :
+Upgrade scripts :
 
-  An sql script to upgrade a pre-1.01 PyKota Quota Storage 
-  DataBase is included, if you want to keep your datas from
-  a pre-1.01 PyKota version, then please launch the following
-  commands :
+  Some scripts to upgrade old PyKota databases to the new
+  database schema are included. You may have to run all
+  of them or only some of them, depending on your 
+  version of PyKota.
+  
+* An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to 
+  1.01 is included. If your PyKota version is equal or higher than 1.01 then
+  you can skip to the next section. Otherwise, if you want to keep your datas
+  from a pre-1.01 PyKota version, then please launch the following commands : 
   
         - Launch the psql frontend and connect to the
@@ -76 +81 @@
   to run this upgrade script.
   
-WARNING :  
+  WARNING :  
 
   This script requires a recent version of PostgreSQL to run
@@ -85 +90 @@
   fields are pagecounter and lifepagecounter, just forgot them.
   
-IMPORTANT :
-
-  Because the modifications are just about Group Print Quotas
-  and because Group Print Quotas are currently not fully   
-  implemented, you can delay the launch of this upgrade
-  script until you really need Group Print Quotas.
-  In other terms, running this script is not mandatory
-  for PyKota to continue to work correctly, at least
-  until Group Print Quotas will be fully implemented.
-  
+* If you are already running PyKota 1.01 or 1.02 and want to upgrade to 
+  1.03, YOU HAVE TO RUN the upgrade-1.01-to-1.03.sh shell script.
+  NOT LAUNCHING THIS SCRIPT WILL CAUSE PYKOTA TO STOP WORKING !
+  Please don't run this script if your version of PyKota is already
+  1.03 or higher.