Show
Ignore:
Timestamp:
06/20/04 18:15:21 (20 years ago)
Author:
jalet
Message:

Added "description" attribute for printers

Location:
pykota/trunk/initscripts
Files:
3 modified

Legend:

Unmodified
Added
Removed
  • pykota/trunk/initscripts/ldap/pykota.schema

    r1522 r1556  
    208208        DESC 'PyKota Printer' 
    209209        MUST ( cn ) 
    210         MAY  ( pykotaPrinterName $ pykotaPricePerPage $ pykotaPricePerJob $ uniqueMember ) ) 
     210        MAY  ( description $ pykotaPrinterName $ pykotaPricePerPage $ pykotaPricePerJob $ uniqueMember ) ) 
    211211         
    212212# pykotaUserPQuota         
  • pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

    r1520 r1556  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.11  2004/06/20 16:15:21  jalet 
     23-- Added "description" attribute for printers 
     24-- 
    2225-- Revision 1.10  2004/06/03 23:14:09  jalet 
    2326-- Now stores the job's size in bytes in the database. 
     
    104107CREATE TABLE printers(id SERIAL PRIMARY KEY NOT NULL, 
    105108                      printername TEXT UNIQUE NOT NULL, 
     109                      description TEXT, 
    106110                      priceperpage FLOAT DEFAULT 0.0, 
    107111                      priceperjob FLOAT DEFAULT 0.0); 
  • pykota/trunk/initscripts/postgresql/upgrade-to-1.19.sql

    r1520 r1556  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.3  2004/06/20 16:15:21  jalet 
     23-- Added "description" attribute for printers 
     24-- 
    2225-- Revision 1.2  2004/06/03 23:14:10  jalet 
    2326-- Now stores the job's size in bytes in the database. 
     
    4548-- Modify the old database schema 
    4649-- 
     50ALTER TABLE printers ADD COLUMN description TEXT; 
    4751ALTER TABLE jobhistory ADD COLUMN jobsizebytes INT8; 
    4852ALTER TABLE jobhistory ADD COLUMN hostname TEXT;