diff options
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/3.3.5/2017_05_29_00_auth.sql | 2 | ||||
| -rw-r--r-- | sql/updates/auth/3.3.5/2017_06_12_00_auth.sql | 10 |
2 files changed, 11 insertions, 1 deletions
diff --git a/sql/updates/auth/3.3.5/2017_05_29_00_auth.sql b/sql/updates/auth/3.3.5/2017_05_29_00_auth.sql index 7ddeabe630c..557c7c52470 100644 --- a/sql/updates/auth/3.3.5/2017_05_29_00_auth.sql +++ b/sql/updates/auth/3.3.5/2017_05_29_00_auth.sql @@ -2,6 +2,6 @@ DELETE FROM `rbac_permissions` WHERE `id` = 855; INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (855, 'Command: debug play music'); -DELETE FROM `rbac_linked_permissions` WHERE `id` = 855; +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 855; INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (198, 855); diff --git a/sql/updates/auth/3.3.5/2017_06_12_00_auth.sql b/sql/updates/auth/3.3.5/2017_06_12_00_auth.sql new file mode 100644 index 00000000000..a843472e3ff --- /dev/null +++ b/sql/updates/auth/3.3.5/2017_06_12_00_auth.sql @@ -0,0 +1,10 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (861,862,863,864); +INSERT INTO `rbac_permissions` (`id`,`name`) VALUES +(861, 'Command: group set'), +(862, 'Command: group set assistant'), +(863, 'Command: group set maintank'), +(864, 'Command: group set mainassist'); + +DELETE FROM `rbac_linked_permissions` WHERE `linkedId` IN (473,861,862,863,864); +INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES +(197,473),(197,861),(197,862),(197,863),(197,864); |