aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/3.3.5/2017_08_01_00_auth.sql8
-rw-r--r--sql/updates/auth/3.3.5/2017_10_13_00_auth.sql7
-rw-r--r--sql/updates/auth/3.3.5/2017_10_29_00_auth.sql15
3 files changed, 30 insertions, 0 deletions
diff --git a/sql/updates/auth/3.3.5/2017_08_01_00_auth.sql b/sql/updates/auth/3.3.5/2017_08_01_00_auth.sql
new file mode 100644
index 00000000000..3921ed76d5a
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2017_08_01_00_auth.sql
@@ -0,0 +1,8 @@
+--
+DELETE FROM `rbac_permissions` WHERE `id`=866;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(866, 'Command: list spawnpoints');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=866;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196,866);
diff --git a/sql/updates/auth/3.3.5/2017_10_13_00_auth.sql b/sql/updates/auth/3.3.5/2017_10_13_00_auth.sql
new file mode 100644
index 00000000000..145714e9564
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2017_10_13_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id`=7;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(7, 'Skip idle connection check');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=7;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196,7);
diff --git a/sql/updates/auth/3.3.5/2017_10_29_00_auth.sql b/sql/updates/auth/3.3.5/2017_10_29_00_auth.sql
new file mode 100644
index 00000000000..186012cd88e
--- /dev/null
+++ b/sql/updates/auth/3.3.5/2017_10_29_00_auth.sql
@@ -0,0 +1,15 @@
+DELETE FROM `rbac_permissions` WHERE `id` = 843; -- this id does not exist in TDB 335.63
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(843, 'Command: reload quest_greeting');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 843;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196, 843);
+
+DELETE FROM `rbac_permissions` WHERE `id` = 867;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(867, 'Command: reload quest_greeting_locale');
+
+DELETE FROM `rbac_linked_permissions` WHERE `id` = 867;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196, 867);