Changeset 1473 for pykota/trunk/initscripts/postgresql
- Timestamp:
- 05/13/04 13:15:29 (21 years ago)
- Location:
- pykota/trunk/initscripts/postgresql
- Files:
-
- 1 added
- 2 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/pykota-postgresql.sql
r1257 r1473 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.9 2004/05/13 11:15:29 jalet 23 -- Added hostname field in job history 24 -- 22 25 -- Revision 1.8 2004/01/08 14:10:32 jalet 23 26 -- Copyright year changed. … … 118 121 userid INT4, 119 122 printerid INT4, 123 hostname TEXT, 120 124 pagecounter INT4 DEFAULT 0, 121 125 jobsize INT4, -
pykota/trunk/initscripts/postgresql/README.postgresql
r1257 r1473 59 59 version of PyKota. 60 60 61 * An SQL script to upgrade a 1.18 PyKota Storage DataBase to 62 1.19 is included. Launch it this way on the Quota Storage Server : 63 64 $ psql -U postgres pykota 65 pykota=# \i upgrade-to-1.19.sql 66 pykota=# \q 67 $ 68 69 This script adds a field to the print job history. The field that 70 is added is : hostname 71 61 72 * An SQL script to upgrade a pre-1.16 PyKota Storage DataBase to 62 73 1.16 is included. Launch it this way on the Quota Storage Server :