root / pykota / trunk / initscripts / postgresql / upgrade-to-1.23.sql @ 3561

Revision 3561, 2.3 kB (checked in by jerome, 11 years ago)

Changed copyright years.

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1--
2-- PyKota - Print Quotas for CUPS
3--
4-- (c) 2003-2013 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 3 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, see <http://www.gnu.org/licenses/>.
17--
18-- $Id$
19--
20--
21--
22-- This script has to be used if you already
23-- have a pre-1.23alpha30 version of PyKota to upgrade
24-- your database schema.
25--
26-- YOU DON'T NEED TO USE IT IF YOU'VE JUST INSTALLED PYKOTA
27--
28
29--
30-- Modify the old database schema
31--
32ALTER TABLE users ADD COLUMN description TEXT;
33ALTER TABLE groups ADD COLUMN description TEXT;
34ALTER TABLE userpquota ADD COLUMN maxjobsize INT4;
35ALTER TABLE grouppquota ADD COLUMN maxjobsize INT4;
36ALTER TABLE printers ADD COLUMN maxjobsize INT4;
37ALTER TABLE printers ADD COLUMN passthrough BOOLEAN;
38ALTER TABLE printers ALTER COLUMN passthrough SET DEFAULT FALSE;
39ALTER TABLE jobhistory ADD COLUMN precomputedjobsize INT4;
40ALTER TABLE jobhistory ADD COLUMN precomputedjobprice FLOAT;
41ALTER TABLE payments ADD COLUMN description TEXT;
42
43ALTER TABLE userpquota DROP COLUMN temporarydenied;
44
45--
46-- Now updates existing datas
47--
48-- Just to be sure
49UPDATE printers SET passthrough=FALSE;
50
51--
52-- Create the table for the billing codes
53--
54CREATE TABLE billingcodes (id SERIAL PRIMARY KEY NOT NULL,
55                           label TEXT UNIQUE NOT NULL,
56                           description TEXT,
57                           balance FLOAT DEFAULT 0.0,
58                           pagecounter INT4 DEFAULT 0);
59ALTER TABLE billingcodes RENAME COLUMN label TO billingcode;
60
61REVOKE ALL ON billingcodes FROM public;
62REVOKE ALL ON billingcodes_id_seq FROM public;
63GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON billingcodes TO pykotaadmin;
64GRANT SELECT, UPDATE ON billingcodes_id_seq TO pykotaadmin;
65GRANT SELECT ON billingcodes TO pykotauser;
66
Note: See TracBrowser for help on using the browser.