Changeset 1240 for pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql
- Timestamp:
- 12/27/03 17:49:25 (20 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql
r1203 r1240 20 20 -- 21 21 -- $Log$ 22 -- Revision 1.3 2003/12/27 16:49:25 uid67467 23 -- Should be ok now. 24 -- 22 25 -- Revision 1.2 2003/11/23 19:01:36 jalet 23 26 -- Job price added to history … … 48 51 ALTER TABLE jobhistory ADD COLUMN options TEXT; 49 52 53 -- 54 -- Remove bad integrity rules 55 -- and replace them with a new one 56 -- 57 ALTER TABLE jobhistory DROP CONSTRAINT "$1"; 58 ALTER TABLE jobhistory DROP CONSTRAINT "$2"; 59 ALTER TABLE jobhistory ADD CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota (userid, printerid); 60 61 -- 62 -- Add new tables 63 -- 64 -- 65 -- Create the printer groups relationship 66 -- 67 CREATE TABLE printergroupsmembers(groupid INT4 REFERENCES printers(id), 68 printerid INT4 REFERENCES printers(id), 69 PRIMARY KEY (groupid, printerid)); 70 50 71 -- 51 72 -- Now add some indexes … … 56 77 CREATE UNIQUE INDEX grouppquota_up_id_ix ON grouppquota (groupid, printerid); 57 78 79 -- 80 -- And now sets some ACLs 81 -- 82 REVOKE ALL ON printergroupsmembers FROM public; 83 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON printergroupsmembers TO pykotaadmin; 84 GRANT SELECT ON printergroupsmembers TO pykotauser; 85