root / pykota / trunk / initscripts / postgresql / upgrade-to-1.19.sql @ 2063

Revision 1556, 2.4 kB (checked in by jalet, 20 years ago)

Added "description" attribute for printers

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1--
2-- PyKota - Print Quotas for CUPS and LPRng
3--
4-- (c) 2003-2004 Jerome Alet <alet@librelogiciel.com>
5-- This program is free software; you can redistribute it and/or modify
6-- it under the terms of the GNU General Public License as published by
7-- the Free Software Foundation; either version 2 of the License, or
8-- (at your option) any later version.
9--
10-- This program is distributed in the hope that it will be useful,
11-- but WITHOUT ANY WARRANTY; without even the implied warranty of
12-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
13-- GNU General Public License for more details.
14--
15-- You should have received a copy of the GNU General Public License
16-- along with this program; if not, write to the Free Software
17-- Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
18--
19-- $Id$
20--
21-- $Log$
22-- Revision 1.3  2004/06/20 16:15:21  jalet
23-- Added "description" attribute for printers
24--
25-- Revision 1.2  2004/06/03 23:14:10  jalet
26-- Now stores the job's size in bytes in the database.
27-- Preliminary work on payments storage : database schemas are OK now,
28-- but no code to store payments yet.
29-- Removed schema picture, not relevant anymore.
30--
31-- Revision 1.1  2004/05/13 11:15:29  jalet
32-- Added hostname field in job history
33--
34--
35--
36-- This script has to be used if you already
37-- have a pre-1.19 version of PyKota to upgrade
38-- your database schema.
39--
40-- YOU DON'T NEED TO USE IT IF YOU'VE JUST INSTALLED PYKOTA
41--
42                       
43--                         
44-- WARNING : YOU NEED A RECENT VERSION OF POSTGRESQL FOR THE ALTER COLUMN STATEMENT TO WORK !
45--
46
47--                         
48-- Modify the old database schema
49--
50ALTER TABLE printers ADD COLUMN description TEXT;
51ALTER TABLE jobhistory ADD COLUMN jobsizebytes INT8;
52ALTER TABLE jobhistory ADD COLUMN hostname TEXT;
53CREATE INDEX jobhistory_hostname_ix ON jobhistory (hostname);
54
55CREATE TABLE payments (id SERIAL PRIMARY KEY NOT NULL,
56                       userid INT4 REFERENCES users(id),
57                       amount FLOAT,
58                       date TIMESTAMP DEFAULT now());
59CREATE INDEX payments_date_ix ON payments (date);
60
61REVOKE ALL ON payments FROM public;                       
62REVOKE ALL ON payments_id_seq FROM public;
63GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON payments TO pykotaadmin;
64GRANT SELECT, UPDATE ON payments_id_seq TO pykotaadmin;
65GRANT SELECT ON payments TO pykotauser;
Note: See TracBrowser for help on using the browser.