root / pykota / trunk / initscripts / postgresql / upgrade-to-1.21.sql @ 2076

Revision 2055, 2.7 kB (checked in by jalet, 20 years ago)

Missing upgrade script

  • 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., 59 Temple Place, Suite 330, Boston, MA 02111-1307, USA.
18--
19-- $Id$
20--
21-- $Log$
22-- Revision 1.1  2005/02/13 22:15:43  jalet
23-- Missing upgrade script
24--
25--
26--
27-- This script has to be used if you already
28-- have a pre-1.21 version of PyKota to upgrade
29-- your database schema.
30--
31-- YOU DON'T NEED TO USE IT IF YOU'VE JUST INSTALLED PYKOTA
32--
33                       
34--                         
35-- Modify the old database schema
36--
37ALTER TABLE users DROP COLUMN coefficient;
38ALTER TABLE users ADD COLUMN overcharge FLOAT;
39ALTER TABLE users ALTER COLUMN overcharge SET DEFAULT 1.0;
40UPDATE users SET overcharge=1.0;
41ALTER TABLE users ALTER COLUMN overcharge SET NOT NULL;
42
43ALTER TABLE userpquota DROP COLUMN warned;
44ALTER TABLE userpquota ADD COLUMN warncount INT4;
45ALTER TABLE userpquota ALTER COLUMN warncount SET DEFAULT 0;
46CREATE INDEX userpquota_u_id_ix ON userpquota (userid);
47CREATE INDEX userpquota_p_id_ix ON userpquota (printerid);
48UPDATE userpquota SET warncount=0;
49
50CREATE INDEX grouppquota_g_id_ix ON grouppquota (groupid);
51CREATE INDEX grouppquota_p_id_ix ON grouppquota (printerid);
52
53ALTER TABLE jobhistory ADD COLUMN md5sum TEXT;
54ALTER TABLE jobhistory ADD COLUMN pages TEXT;
55ALTER TABLE jobhistory ADD COLUMN billingcode TEXT;
56CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid);
57
58--
59-- Create the table for coefficients wrt paper sizes and the like
60--
61CREATE TABLE coefficients (id SERIAL PRIMARY KEY NOT NULL, 
62                           printerid INTEGER NOT NULL REFERENCES printers(id), 
63                           label TEXT NOT NULL, 
64                           coefficient FLOAT DEFAULT 1.0, 
65                           CONSTRAINT coeffconstraint UNIQUE (printerid, label));
66                           
67REVOKE ALL ON coefficients FROM public;                       
68REVOKE ALL ON coefficients_id_seq FROM public;
69GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON coefficients TO pykotaadmin;
70GRANT SELECT, UPDATE ON coefficients_id_seq TO pykotaadmin;
71GRANT SELECT ON coefficients TO pykotauser;
Note: See TracBrowser for help on using the browser.