aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSpp <spp@jorge.gr>2013-09-10 15:47:17 +0200
committerSpp <spp@jorge.gr>2013-09-10 15:47:17 +0200
commit0ed83024e0c4771f82096dcb9da032c7adcdad53 (patch)
treefe9aec9325bd7dc7e506d0754545e787b995037c
parent953575abfa631b9c58d8a8acc1fc8a37359f6fa6 (diff)
Core/RBAC: Fix typos in recent SQL files
-rw-r--r--sql/updates/auth/2013_09_10_13_auth_misc.sql16
-rw-r--r--sql/updates/world/2013_09_10_14_world_command.sql1
-rw-r--r--sql/updates/world/2013_09_10_15_world_command.sql33
3 files changed, 22 insertions, 28 deletions
diff --git a/sql/updates/auth/2013_09_10_13_auth_misc.sql b/sql/updates/auth/2013_09_10_13_auth_misc.sql
index 825028dcb5a..becedad564d 100644
--- a/sql/updates/auth/2013_09_10_13_auth_misc.sql
+++ b/sql/updates/auth/2013_09_10_13_auth_misc.sql
@@ -11,14 +11,14 @@ INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
(@id+3, 'titles remove'),
(@id+4, 'titles set'),
(@id+5, 'titles set mask'),
-(@id+6, 'titles wp'),
-(@id+7, 'titles wp add'),
-(@id+8, 'titles wp event'),
-(@id+9, 'titles wp load'),
-(@id+10, 'titles wp modify'),
-(@id+11, 'titles wp unload'),
-(@id+12, 'titles wp reload'),
-(@id+13, 'titles wp show');
+(@id+6, 'wp'),
+(@id+7, 'wp add'),
+(@id+8, 'wp event'),
+(@id+9, 'wp load'),
+(@id+10, 'wp modify'),
+(@id+11, 'wp unload'),
+(@id+12, 'wp reload'),
+(@id+13, 'wp show');
-- Add permissions to "corresponding Commands Role"
DELETE FROM `rbac_role_permissions` WHERE `permissionId` BETWEEN @id AND @id+13;
diff --git a/sql/updates/world/2013_09_10_14_world_command.sql b/sql/updates/world/2013_09_10_14_world_command.sql
index 853dcc77fe0..36723992ed0 100644
--- a/sql/updates/world/2013_09_10_14_world_command.sql
+++ b/sql/updates/world/2013_09_10_14_world_command.sql
@@ -3,7 +3,6 @@
SET @id = 742;
-- Update command table with new RBAC permissions
-UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'tele';
UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'ticket';
UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'ticket assign';
UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'ticket close';
diff --git a/sql/updates/world/2013_09_10_15_world_command.sql b/sql/updates/world/2013_09_10_15_world_command.sql
index ff70ba9b18d..1f90dfdf2a4 100644
--- a/sql/updates/world/2013_09_10_15_world_command.sql
+++ b/sql/updates/world/2013_09_10_15_world_command.sql
@@ -3,22 +3,17 @@
SET @id = 761;
-- Update command table with new RBAC permissions
-UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'ticket';
-UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'ticket assign';
-UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'ticket close';
-UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'ticket closedlist';
-UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'ticket comment';
-UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'ticket complete';
-UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'ticket delete';
-UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'ticket escalate';
-UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'ticket escalatedlist';
-UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'ticket list';
-UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'ticket onlinelist';
-UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'ticket reset';
-UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'ticket response';
-UPDATE `command` SET `permission` = @id+13 WHERE `name` = 'ticket response append';
-UPDATE `command` SET `permission` = @id+14 WHERE `name` = 'ticket response appendln';
-UPDATE `command` SET `permission` = @id+15 WHERE `name` = 'ticket togglesystem';
-UPDATE `command` SET `permission` = @id+16 WHERE `name` = 'ticket unassign';
-UPDATE `command` SET `permission` = @id+17 WHERE `name` = 'ticket viewid';
-UPDATE `command` SET `permission` = @id+18 WHERE `name` = 'ticket viewname';
+UPDATE `command` SET `permission` = @id+0 WHERE `name` = 'titles';
+UPDATE `command` SET `permission` = @id+1 WHERE `name` = 'titles add';
+UPDATE `command` SET `permission` = @id+2 WHERE `name` = 'titles current';
+UPDATE `command` SET `permission` = @id+3 WHERE `name` = 'titles remove';
+UPDATE `command` SET `permission` = @id+4 WHERE `name` = 'titles set';
+UPDATE `command` SET `permission` = @id+5 WHERE `name` = 'titles set mask';
+UPDATE `command` SET `permission` = @id+6 WHERE `name` = 'wp';
+UPDATE `command` SET `permission` = @id+7 WHERE `name` = 'wp add';
+UPDATE `command` SET `permission` = @id+8 WHERE `name` = 'wp event';
+UPDATE `command` SET `permission` = @id+9 WHERE `name` = 'wp load';
+UPDATE `command` SET `permission` = @id+10 WHERE `name` = 'wp modify';
+UPDATE `command` SET `permission` = @id+11 WHERE `name` = 'wp unload';
+UPDATE `command` SET `permission` = @id+12 WHERE `name` = 'wp reload';
+UPDATE `command` SET `permission` = @id+13 WHERE `name` = 'wp show';