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)

1 files changed, 7 insertions, 0 deletions

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);