From b709ea9a8dcceb76bf1d057d01e86e347e207e51 Mon Sep 17 00:00:00 2001 From: Wyrserth Date: Fri, 21 Jun 2019 20:17:37 +0200 Subject: Core/RBAC: add permission that prevents accounts from earning all achievements or only realm firsts (#23459) * Core/RBAC: add permission that prevents accounts from earning all achievements or only realm firsts. * Kill evil spaces. * Rename 9999_99_99_99_auth.sql to 2019_06_21_00_auth.sql * Update auth_database.sql (cherry picked from commit 8163ea60c8d517ebe3a88f595dd8291df8338811) --- sql/updates/auth/master/2019_06_21_00_auth.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/auth/master/2019_06_21_00_auth.sql (limited to 'sql/updates/auth') diff --git a/sql/updates/auth/master/2019_06_21_00_auth.sql b/sql/updates/auth/master/2019_06_21_00_auth.sql new file mode 100644 index 00000000000..1db042a632f --- /dev/null +++ b/sql/updates/auth/master/2019_06_21_00_auth.sql @@ -0,0 +1,7 @@ +DELETE FROM `rbac_permissions` WHERE `id` IN (8, 9); +INSERT INTO `rbac_permissions` (`id`, `name`) VALUES +(8, "Cannot earn achievements"), +(9, "Cannot earn realm first achievements"); + +INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES +(194, 9); -- cgit v1.2.3