Changeset 2024

Show
Ignore:
Timestamp:
01/11/05 00:23:25 (20 years ago)
Author:
jalet
Message:

Added the billing code to the history

Location:
pykota/trunk/initscripts
Files:
2 modified

Legend:

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

    r1997 r2024  
    220220        SYNTAX 1.3.6.1.4.1.1466.115.121.1.26 ) 
    221221 
     222# pykotaBillingCode 
     223attributetype ( 1.3.6.1.4.1.16868.1.1.32 NAME 'pykotaBillingCode' 
     224        DESC 'Optional billing code for the print job' 
     225        EQUALITY caseIgnoreMatch 
     226        SUBSTR caseIgnoreSubstringsMatch 
     227        SYNTAX 1.3.6.1.4.1.1466.115.121.1.15 SINGLE-VALUE ) 
     228         
    222229 
    223230#         
     
    259266        DESC 'An entry in the job history for a printer' 
    260267        MUST ( cn $ pykotaUserName $ pykotaPrinterName $ pykotaJobId ) 
    261         MAY  ( pykotaPrinterPageCounter $ pykotaJobSize $ pykotaAction $ pykotaJobPrice $ pykotaFileName $ pykotaTitle $ pykotaCopies $ pykotaOptions $ pykotaHostName $ pykotaJobSizeBytes $ pykotaMD5Sum $ pykotaPages ) ) 
     268        MAY  ( pykotaBillingCode $ pykotaPrinterPageCounter $ pykotaJobSize $ pykotaAction $ pykotaJobPrice $ pykotaFileName $ pykotaTitle $ pykotaCopies $ pykotaOptions $ pykotaHostName $ pykotaJobSizeBytes $ pykotaMD5Sum $ pykotaPages ) ) 
    262269         
    263270# pykotaAccountBalance 
  • pykota/trunk/initscripts/postgresql/pykota-postgresql.sql

    r1994 r2024  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.13  2005/01/10 23:23:25  jalet 
     23-- Added the billing code to the history 
     24-- 
    2225-- Revision 1.12  2004/12/23 18:40:18  jalet 
    2326-- Added the coefficient table, and many columns to existing tables 
     
    148151                        md5sum TEXT, 
    149152                        pages TEXT, 
     153                        billingcode TEXT, 
    150154                        jobdate TIMESTAMP DEFAULT now(), 
    151155                        CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota(userid, printerid));