diff options
| -rw-r--r-- | sql/base/auth_database.sql | 7 | ||||
| -rw-r--r-- | sql/updates/auth/master/2023_12_24_00_auth.sql | 9 |
2 files changed, 15 insertions, 1 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql index e5358105e34..b1c72397cba 100644 --- a/sql/base/auth_database.sql +++ b/sql/base/auth_database.sql @@ -945,6 +945,8 @@ INSERT INTO `rbac_linked_permissions` VALUES (192,792), (192,793), (192,794), +(192,795), +(192,796), (192,835), (192,844), (192,845), @@ -2233,6 +2235,8 @@ INSERT INTO `rbac_permissions` VALUES (792,'Command: ahbot reload'), (793,'Command: ahbot status'), (794,'Command: .guild info'), +(795,'Command: instance setbossstate'), +(796,'Command: instance getbossstate'), (797,'Command: pvpstats'), (798,'Command: .mod xp'), (802,'Command: .ticket bug'), @@ -2773,7 +2777,8 @@ INSERT INTO `updates` VALUES ('2023_12_12_00_auth.sql','EDC092787956178A08D15B9245EE4716ED0847B0','RELEASED','2023-12-12 05:47:47',0), ('2023_12_13_00_auth.sql','C3D6AA45BECD5A7F8A420FE0022AAF6A349C5E3F','RELEASED','2023-12-13 06:42:48',0), ('2023_12_19_00_auth.sql','6761E7111F613E57A7D684E18E38FCA3F5CD66A6','RELEASED','2023-12-19 08:54:36',0), -('2023_12_21_00_auth.sql','DB294EF35C00AA92C79786F7A0BFBCE739D4E193','RELEASED','2023-12-21 09:08:30',0); +('2023_12_21_00_auth.sql','DB294EF35C00AA92C79786F7A0BFBCE739D4E193','RELEASED','2023-12-21 09:08:30',0), +('2023_12_24_00_auth.sql','F59B3A895750FD83177324B89BFCEBD8A43DD577','RELEASED','2023-12-24 06:24:58',0); /*!40000 ALTER TABLE `updates` ENABLE KEYS */; UNLOCK TABLES; diff --git a/sql/updates/auth/master/2023_12_24_00_auth.sql b/sql/updates/auth/master/2023_12_24_00_auth.sql new file mode 100644 index 00000000000..6242c21a362 --- /dev/null +++ b/sql/updates/auth/master/2023_12_24_00_auth.sql @@ -0,0 +1,9 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (795, 796); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(795,'Command: instance setbossstate'), +(796,'Command: instance getbossstate'); + +DELETE FROM `rbac_linked_permissions` WHERE `id`= 192 AND `linkedId` IN (795, 796); +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(192,795), +(192,796); |