# $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.

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

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.


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 file upgrades the PostgreSQL Quota Storage Database schema
    from versions before 1.01 to version 1.01.
    Don't use it if you already run a post-1.01 PyKota version.
    
  * 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.