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

Author: jorgeuriarte
Date: 2006-06-11 07:50:27-0700
New Revision: 10163

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

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

Modified: branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-1.sql
Url: http://scarab.tigris.org/source/browse/scarab/branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-1.sql?view=diff&rev=10163&p1=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-1.sql&p2=branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-1.sql&r1=10162&r2=10163
==============================================================================
--- branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-1.sql	(original)
+++ branches/release/b21/src/sql/mysql/upgrade/mysql-upgrade-1.0b20-1.0b21-1.sql	2006-06-11 07:50:27-0700
@@ -32,3 +32,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

+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;