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

Revision 2342, 2.5 kB (checked in by jerome, 19 years ago)

The pkbcodes command line tool now works fine with the PostgreSQL
backend. The dumpykota command can now dump billing codes too.
Still no code for LDAP though.
NB : a database upgrade is necessary AGAIN !
Severity : no need to play with this until there's LDAP support.

  • 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, 2005 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., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18--
19-- $Id$
20--
21--
22--
23-- This script has to be used if you already
24-- have a pre-1.23alpha12 version of PyKota to upgrade
25-- your database schema.
26--
27-- YOU DON'T NEED TO USE IT IF YOU'VE JUST INSTALLED PYKOTA
28--
29                       
30--                         
31-- Modify the old database schema
32--
33ALTER TABLE users ADD COLUMN description TEXT;
34ALTER TABLE groups ADD COLUMN description TEXT;
35ALTER TABLE userpquota ADD COLUMN maxjobsize INT4;
36ALTER TABLE userpquota ADD COLUMN temporarydenied BOOLEAN;
37ALTER TABLE userpquota ALTER COLUMN temporarydenied SET DEFAULT 'f';
38ALTER TABLE grouppquota ADD COLUMN maxjobsize INT4;
39ALTER TABLE printers ADD COLUMN maxjobsize INT4;
40ALTER TABLE printers ADD COLUMN passthrough BOOLEAN;
41ALTER TABLE printers ALTER COLUMN passthrough SET DEFAULT 'f';
42ALTER TABLE jobhistory ADD COLUMN precomputedjobsize INT4;
43ALTER TABLE jobhistory ADD COLUMN precomputedjobprice FLOAT;
44
45--
46-- Now updates existing datas
47--
48-- Just to be sure
49UPDATE userpquota SET temporarydenied='f';
50UPDATE printers SET passthrough='f';
51
52--
53-- Create the table for the billing codes
54--
55CREATE TABLE billingcodes (id SERIAL PRIMARY KEY NOT NULL,
56                           label TEXT UNIQUE NOT NULL,
57                           description TEXT,
58                           balance FLOAT DEFAULT 0.0,
59                           pagecounter INT4 DEFAULT 0);
60ALTER TABLE billingcodes RENAME COLUMN label TO billingcode;
61
62REVOKE ALL ON billingcodes FROM public;                       
63REVOKE ALL ON billingcodes_id_seq FROM public;
64GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON billingcodes TO pykotaadmin;
65GRANT SELECT, UPDATE ON billingcodes_id_seq TO pykotaadmin;
66GRANT SELECT ON billingcodes TO pykotauser;
67
Note: See TracBrowser for help on using the browser.