diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/auth_database.sql | 5 | ||||
| -rw-r--r-- | sql/updates/auth/master/2022_12_22_00_auth.sql | 8 |
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); |