Changeset 2024

Show
Ignore:
Timestamp:
01/11/05 00:23:25 (19 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));