Add mailbox command

2 files changed, 15 insertions, 0 deletions

diff --git a/sql/updates/auth/xxxx_xx_xx_xx_auth_rbac_permissions.sql b/sql/updates/auth/xxxx_xx_xx_xx_auth_rbac_permissions.sql
new file mode 100644
index 00000000000..b68cf584d47
--- /dev/null
+++ b/sql/updates/auth/xxxx_xx_xx_xx_auth_rbac_permissions.sql
@@ -0,0 +1,10 @@
+SET @id = 775;

+

+-- Add new permissions

+DELETE FROM `rbac_permissions` WHERE `id`=@id;

+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES

+(@id, 'Command: mailbox');

+

+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=@id;

+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES

+(196, @id);

diff --git a/sql/updates/world/xxxx_xx_xx_xx_world_command.txt b/sql/updates/world/xxxx_xx_xx_xx_world_command.txt
new file mode 100644
index 00000000000..fb36904b393
--- /dev/null
+++ b/sql/updates/world/xxxx_xx_xx_xx_world_command.txt
@@ -0,0 +1,5 @@
+SET @id = 775;

+

+DELETE FROM `command` WHERE `name` = 'mailbox';

+INSERT INTO `command` (`name`, `permission`, `help`) VALUES

+('mailbox', @id, 'Syntax: .mailbox\r\n\r\nShow your mailbox content.');