# $Id$

PyKota - Print Quota for CUPS

(c) 2003 Jerome Alet <alet@librelogiciel.com>
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.

This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.

You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.

============================================================

Documentation for the pykota-postgresql.sql script :
----------------------------------------------------

This script is to be used to create an empty Quota Storage
DataBase using PostgreSQL as a backend.

If you have already installed PyKota, and have datas in your
Quota Storage DataBase, you may prefer to  skip this section
and read the next one.

        - Launch the psql frontend and connect to the
          database template1 as a PostgreSQL administrator
          (i.e. the postgres user) :
          
            $ psql -h localhost -U postgres template1
          
        - Executes the pykota-postgresql.sql script :  
        
            template1=# \i pykota-postgresql.sql
            
        - Quit the psql frontend :    
        
            template1=# \q
            
        - Your PostgreSQL PyKota storage is now ready
          for use.
        
============================================================

Upgrade script :

  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 :
  
        - Launch the psql frontend and connect to the
          database pykota as a PostgreSQL administrator
          (i.e. the postgres user) :
          
            $ psql -h localhost -U postgres pykota
          
        - Executes the pykota-upgrade-postgresql.sql script :  
        
            pykota=# \i pykota-upgrade-postgresql.sql
            
        - Quit the psql frontend :    
        
            pykota=# \q
            
        - Your PostgreSQL PyKota storage is now ready
          for use.
  
  If you already run PyKota v1.01 or above, you don't need
  to run this upgrade script.
  
WARNING :  

  This script requires a recent version of PostgreSQL to run
  successfully, because it requires the ALTER TABLE DROP COLUMN
  syntax to be supported. However in case you've got an older
  version, upgrading PostgreSQL is not mandatory, you will just 
  have two unused fields in the grouppquota table, these
  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.