DB: Add missing rbac data for .modify currency

2 files changed, 12 insertions, 1 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 8bb51c6deec..952b7f7c607 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1401,6 +1401,7 @@ INSERT INTO `rbac_linked_permissions` VALUES
 (197,771),
 (197,772),
 (197,774),
+(197,775),
 (197,805),
 (197,811),
 (197,813),
@@ -2146,6 +2147,7 @@ INSERT INTO `rbac_permissions` VALUES
 (772,'Command: wp unload'),
 (773,'Command: wp reload'),
 (774,'Command: wp show'),
+(775,'Command: modify currency'),
 (776,'Command: debug phase'),
 (777,'Command: mailbox'),
 (778,'Command: ahbot'),
@@ -2638,7 +2640,8 @@ INSERT INTO `updates` VALUES
 ('2022_12_17_00_auth.sql','0D3963AC2DBF74A4C8B88EA4A680C046FCCF8E70','ARCHIVED','2022-12-17 07:34:53',0),
 ('2022_12_17_01_auth.sql','5D1E2EA3C3CE087F7FB647CD0DE000979961863C','ARCHIVED','2022-12-17 13:09:19',0),
 ('2022_12_20_00_auth.sql','BA88146743B060A14937688C0DB94BF11C6CF1BA','ARCHIVED','2022-12-20 03:10:07',0),
-('2022_12_21_00_auth.sql','B395CAE993D65E035AA621941D4C384E2E2E7DF5','RELEASED','2022-12-21 01:16:56',0);
+('2022_12_21_00_auth.sql','B395CAE993D65E035AA621941D4C384E2E2E7DF5','RELEASED','2022-12-21 01:16:56',0),
+('2022_12_22_00_auth.sql','BBF3CDD7927520F0381ECEF1F30152CBD5344D6A','RELEASED','2022-12-22 16:35:36',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/master/2022_12_22_00_auth.sql b/sql/updates/auth/master/2022_12_22_00_auth.sql
new file mode 100644
index 00000000000..3516d88b5c7
--- /dev/null
+++ b/sql/updates/auth/master/2022_12_22_00_auth.sql
@@ -0,0 +1,8 @@
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=775;
+DELETE FROM `rbac_permissions` WHERE `id`=775;
+
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(775,'Command: modify currency');
+
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(197,775);