Show
Ignore:
Timestamp:
11/23/03 20:01:37 (21 years ago)
Author:
jalet
Message:

Job price added to history

Location:
pykota/trunk/initscripts
Files:
4 modified

Legend:

Unmodified
Added
Removed

  • pykota/trunk/initscripts/ldap/pykota.schema

    r1200 r1203  
    163163        SYNTAX 1.3.6.1.4.1.1466.115.121.1.26 SINGLE-VALUE ) 
    164164         
     165# pykotaJobPrice 
     166attributetype ( 1.3.6.1.4.1.16868.1.1.23 NAME 'pykotaJobPrice' 
     167        DESC 'Price of a particular job in the history, float' 
     168        EQUALITY caseIgnoreIA5Match 
     169        SYNTAX 1.3.6.1.4.1.1466.115.121.1.26 SINGLE-VALUE ) 
     170 
    165171#         
    166172# PyKota Object Classes 
    … …  
    201207        DESC 'An entry in the job history for a printer' 
    202208        MUST ( cn $ pykotaUserName $ pykotaPrinterName $ pykotaJobId ) 
    203         MAY  ( pykotaPrinterPageCounter $ pykotaJobSize $ pykotaAction $ pykotaFileName $ pykotaTitle $ pykotaCopies $ pykotaOptions ) ) 
     209        MAY  ( pykotaPrinterPageCounter $ pykotaJobSize $ pykotaAction $ pykotaJobPrice $ pykotaFileName $ pykotaTitle $ pykotaCopies $ pykotaOptions ) ) 
    204210         
    205211# pykotaAccountBalance 

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

    r1200 r1203  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.6  2003/11/23 19:01:36  jalet 
     23-- Job price added to history 
     24-- 
    2225-- Revision 1.5  2003/11/21 14:28:45  jalet 
    2326-- More complete job history. 
    … …  
    111114                        pagecounter INT4 DEFAULT 0, 
    112115                        jobsize INT4, 
     116                        jobprice FLOAT, 
    113117                        action TEXT, 
    114118                        filename TEXT, 

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

    r1200 r1203  
    6969    This script adds some fields to the print job history, so that 
    7070    more complete information will be known. The fields that 
    71     are added are : filename, title, copies and print command options. 
    72     Also some indexes are created to speed things up. 
     71    are added are : jobprice, filename, title, copies and print  
     72    command options. Also some indexes are created to speed things up. 
    7373   
    7474What is below is for historical reasons only, real people don't use   

  • pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql

    r1201 r1203  
    2020-- 
    2121-- $Log$ 
     22-- Revision 1.2  2003/11/23 19:01:36  jalet 
     23-- Job price added to history 
     24-- 
    2225-- Revision 1.1  2003/11/21 14:29:14  jalet 
    2326-- Forgot to add this file... 
    … …  
    3942-- Modify the old database schema 
    4043-- 
     44ALTER TABLE jobhistory ADD COLUMN jobprice FLOAT; 
    4145ALTER TABLE jobhistory ADD COLUMN filename TEXT; 
    4246ALTER TABLE jobhistory ADD COLUMN title TEXT;