Changeset 910

Show
Ignore:
Timestamp:
04/14/03 21:58:59 (22 years ago)
Author:
jalet
Message:

New database schema for users' account balance

Location:
pykota/trunk
Files:
2 modified

Legend:

Unmodified
Added
Removed

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

    r900 r910  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.11  2003/04/14 19:58:59  jalet 
     23-- New database schema for users' account balance 
     24-- 
    2225-- Revision 1.10  2003/04/10 21:47:20  jalet 
    2326-- Job history added. Upgrade script neutralized for now ! 
    … …  
    8487-- 
    8588CREATE TABLE users(id SERIAL PRIMARY KEY NOT NULL, 
    86                    username TEXT UNIQUE NOT NULL); 
     89                   username TEXT UNIQUE NOT NULL, 
     90                   balance FLOAT DEFAULT 0.0, 
     91                   lieftimepaid FLOAT DEFAULT 0.0, 
     92                   limitby TEXT DEFAULT 'quota'); 
    8793                    
    8894-- 
    … …  
    96102-- 
    97103CREATE TABLE printers(id SERIAL PRIMARY KEY NOT NULL, 
    98                       printername TEXT UNIQUE NOT NULL); 
     104                      printername TEXT UNIQUE NOT NULL, 
     105                      priceperpage FLOAT DEFAULT 0.0, 
     106                      priceperjob FLOAT DEFAULT 0.0); 
    99107                     
    100108-- 

  • pykota/trunk/NEWS

    r909 r910  
    2828          The upgrade script will be finalized ASAP, be patient, 
    2929          or drop your old quota database to start anew. 
     30           
     31        - The new database schema allows to keep an history of all 
     32          jobs as well as charge users per page and/or per job,  
     33          and track users' account balance. 
    3034           
    3135        - The installation script now allows to install the sample