Show
Ignore:
Timestamp:
07/09/03 22:17:07 (21 years ago)
Author:
jalet
Message:

Email field added to PostgreSQL schema

Location:
pykota/trunk/initscripts/postgresql
Files:
1 added
2 modified

Legend:

Unmodified
Added
Removed

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

    r1021 r1079  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.3  2003/07/09 20:17:07  jalet 
     23-- Email field added to PostgreSQL schema 
     24-- 
    2225-- Revision 1.2  2003/06/10 16:37:54  jalet 
    2326-- Deletion of the second user which is not needed anymore. 
    … …  
    5962CREATE TABLE users(id SERIAL PRIMARY KEY NOT NULL, 
    6063                   username TEXT UNIQUE NOT NULL, 
     64                   email TEXT,  
    6165                   balance FLOAT DEFAULT 0.0, 
    6266                   lifetimepaid FLOAT DEFAULT 0.0, 

  • pykota/trunk/initscripts/postgresql/README.postgresql

    r1046 r1079  
    5656  version of PyKota. 
    5757   
    58 * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to  
    59   1.01 is still included for historical reasons. PLEASE DON'T USE IT !  
    6058   
    61 * If you are already running an old version of PyKota (<1.03) and  
    62   want to upgrade to 1.03, YOU HAVE TO RUN the  
    63   upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT  
    64   WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF  
    65   YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER.  
     59  * An SQL script to upgrade a pre-1.14 PyKota Storage DataBase to 
     60    1.14 is included. Launch it this way on the Quota Storage Server : 
     61     
     62        $ psql -U postgres pykota 
     63        pykota=# \i upgrade-to-1.14.sql 
     64        pykota=# \q 
     65        $ 
     66         
     67    This script adds an "email" field for each user. This field, if not     
     68    NULL, is used as the email address of the user when sending warning 
     69    messages in case he is over quota. 
     70     
     71What is below is for historical reasons only, real people don't use   
     72such old beasts, and YOU SHOULDN'T EITHER ! 
     73 
     74  * An sql script to upgrade a pre-1.01 PyKota Quota Storage DataBase to  
     75    1.01 is still included for historical reasons. PLEASE DON'T USE IT !  
     76   
     77  * If you are already running an old version of PyKota (<1.03) and  
     78    want to upgrade to 1.03, YOU HAVE TO RUN the  
     79    upgrade-from-before-1.03.py shell script. NOT LAUNCHING THIS SCRIPT  
     80    WILL CAUSE PYKOTA TO STOP WORKING ! PLEASE NEVER RUN THIS SCRIPT IF  
     81    YOUR EXISTING VERSION OF PYKOTA IS ALREADY 1.03 OR HIGHER.