Scarab commit: svn commit: r10166 - branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql

Author: jorgeuriarte
Date: 2006-06-11 09:40:18-0700
New Revision: 10166

Modified:
   branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql

Log:
Provides 'comment' permission granting for b21-migrated instances (postgresql).

Modified: branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql?view=diff&rev=10166&p1=branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql&p2=branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql&r1=10165&r2=10166
==============================================================================
--- branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql	(original)
+++ branches/release/b21/src/sql/postgresql/upgrade/postgresql-upgrade-1.0b20-1.0b21-1.sql	2006-06-11 09:40:18-0700
@@ -31,3 +31,14 @@
 ---
 INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME) VALUES (21, 'Issue | Comment');
 INSERT INTO TURBINE_PERMISSION (PERMISSION_ID, PERMISSION_NAME) VALUES (20, 'Issue | Delete');
+
+---
+--- Grant the new 'comment' (21) permission to anyone previously having 'edit' (1)
+--- permission
+---
+CREATE TABLE SCARAB_B20_B21_PERMS AS
+SELECT ROLE_ID, 21 AS PERMISSION_ID FROM TURBINE_ROLE_PERMISSION WHERE PERMISSION_ID = 1;
+
+INSERT INTO TURBINE_ROLE_PERMISSION SELECT ROLE_ID, PERMISSION_ID FROM SCARAB_B20_B21_PERMS;
+
+DROP TABLE SCARAB_B20_B21_PERMS;