aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorVincent_Michael <Vincent_Michael@gmx.de>2014-01-19 21:07:21 +0100
committerVincent_Michael <Vincent_Michael@gmx.de>2014-01-19 21:10:41 +0100
commitd4479d9413abc44d6defaecdfe569d71d8fe19fb (patch)
tree0743ee516ff8072be19befbb96627e212f34b69e
parent313b294d6b7b248738e30f8164ee4624a66ac5b5 (diff)
Missing changes in 313b294d6b7b248738e30f8164ee4624a66ac5b5
-rw-r--r--sql/updates/auth/2014_01_19_01_auth_rbac_permissions.sql13
-rw-r--r--sql/updates/world/2014_01_19_02_world_command.sql1
2 files changed, 14 insertions, 0 deletions
diff --git a/sql/updates/auth/2014_01_19_01_auth_rbac_permissions.sql b/sql/updates/auth/2014_01_19_01_auth_rbac_permissions.sql
new file mode 100644
index 00000000000..7866de3d766
--- /dev/null
+++ b/sql/updates/auth/2014_01_19_01_auth_rbac_permissions.sql
@@ -0,0 +1,13 @@
+SET @oldId = 775;
+SET @id = 777;
+
+-- Add new permissions
+DELETE FROM `rbac_permissions` WHERE `id`=@oldId;
+DELETE FROM `rbac_permissions` WHERE `id`=@id;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(@id, 'Command: mailbox');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@oldId;
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@id;
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, @id);
diff --git a/sql/updates/world/2014_01_19_02_world_command.sql b/sql/updates/world/2014_01_19_02_world_command.sql
new file mode 100644
index 00000000000..09509488c85
--- /dev/null
+++ b/sql/updates/world/2014_01_19_02_world_command.sql
@@ -0,0 +1 @@
+UPDATE `command` SET `permission`=777 WHERE `name`='mailbox';