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

Author: jorgeuriarte
Date: 2006-06-11 09:07:32-0700
New Revision: 10165

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

Log:
Followup to r10163. Script uppercased.

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=10165&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=10164&r2=10165
==============================================================================
--- 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 09:07:32-0700
@@ -37,9 +37,9 @@
 -- 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;

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

+INSERT INTO TURBINE_ROLE_PERMISSION SELECT ROLE_ID, PERMISSION_ID FROM SCARAB_B20_B21_PERMS;

 

-drop table scarab_b20_b21_perms;

+DROP TABLE SCARAB_B20_B21_PERMS;