aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorWyrserth <wyrserth@protonmail.com>2019-06-21 20:17:37 +0200
committerGiacomo Pozzoni <giacomopoz@gmail.com>2019-06-21 20:17:37 +0200
commit8163ea60c8d517ebe3a88f595dd8291df8338811 (patch)
treebf399e22a35f36f05744f70f8b6a04d19b524df2 /sql/updates/auth
parente9d803ccee2fb5d229babbf6c2c4a17b1986edb0 (diff)
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
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/3.3.5/2019_06_21_00_auth.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2019_06_21_00_auth.sql b/sql/updates/auth/3.3.5/2019_06_21_00_auth.sql
new file mode 100644
index 00000000000..1db042a632f
--- /dev/null
+++ b/sql/updates/auth/3.3.5/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);