Changeset 3413 for pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql
- Timestamp:
- 09/27/08 22:02:37 (16 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/upgrade-to-1.16.sql
r3259 r3413 7 7 -- the Free Software Foundation, either version 3 of the License, or 8 8 -- (at your option) any later version. 9 -- 9 -- 10 10 -- This program is distributed in the hope that it will be useful, 11 11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of 12 12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 13 -- GNU General Public License for more details. 14 -- 14 -- 15 15 -- You should have received a copy of the GNU General Public License 16 16 -- along with this program. If not, see <http://www.gnu.org/licenses/>. 17 -- 17 -- 18 18 -- $Id$ 19 19 -- … … 22 22 -- This script has to be used if you already 23 23 -- have a pre-1.16 version of PyKota to upgrade 24 -- your database schema. 24 -- your database schema. 25 25 -- 26 26 -- YOU DON'T NEED TO USE IT IF YOU'VE JUST INSTALLED PYKOTA 27 27 -- 28 29 -- 28 29 -- 30 30 -- WARNING : YOU NEED A RECENT VERSION OF POSTGRESQL FOR THE ALTER COLUMN STATEMENT TO WORK ! 31 31 -- 32 32 33 -- 33 -- 34 34 -- Modify the old database schema 35 35 -- … … 48 48 ALTER TABLE jobhistory ADD CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota (userid, printerid); 49 49 50 -- 50 -- 51 51 -- Add new tables 52 52 -- 53 -- 53 -- 54 54 -- Create the printer groups relationship 55 55 -- … … 58 58 PRIMARY KEY (groupid, printerid)); 59 59 60 -- 60 -- 61 61 -- Now add some indexes 62 62 -- … … 66 66 CREATE UNIQUE INDEX grouppquota_up_id_ix ON grouppquota (groupid, printerid); 67 67 68 -- 68 -- 69 69 -- And now sets some ACLs 70 -- 71 REVOKE ALL ON printergroupsmembers FROM public; 70 -- 71 REVOKE ALL ON printergroupsmembers FROM public; 72 72 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON printergroupsmembers TO pykotaadmin; 73 73 GRANT SELECT ON printergroupsmembers TO pykotauser;