TDB 335.19031 - 2019/03/19TDB335.19031

8 files changed, 38 insertions, 0 deletions

diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_02_19_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_02_19_00_auth.sql
new file mode 100644
index 00000000000..78879b5db86
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_02_19_00_auth.sql
@@ -0,0 +1,2 @@
+-- TDB 335.64 auth
+UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_03_06_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_03_06_00_auth.sql
new file mode 100644
index 00000000000..ddaf1d13f0c
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_03_06_00_auth.sql
@@ -0,0 +1,5 @@
+DELETE FROM `rbac_permissions` WHERE `id`=872;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES
+(872, 'Command: server debug');
+INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
+(196, 872);
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_03_08_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_03_08_00_auth.sql
new file mode 100644
index 00000000000..8b0e18b1e6c
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_03_08_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `rbac_permissions` WHERE `id` = 873;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(873, 'Command: reload creature_movement_override');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId` = 873;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(196, 873);
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_06_23_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_06_23_00_auth.sql
new file mode 100644
index 00000000000..3bbe03f8c19
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_06_23_00_auth.sql
@@ -0,0 +1,3 @@
+--
+DROP TABLE IF EXISTS `ip2nation`;
+DROP TABLE IF EXISTS `ip2nationCountries`;
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_08_30_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_08_30_00_auth.sql
new file mode 100644
index 00000000000..1ee1f8d7ee4
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_08_30_00_auth.sql
@@ -0,0 +1,9 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=874;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
+(874, "Command: go instance");
+
+SET @parent := (SELECT `id` FROM `rbac_linked_permissions` WHERE `linkedId`=852);
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=874;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
+(@parent, 874);
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_09_06_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_09_06_00_auth.sql
new file mode 100644
index 00000000000..5a9718edcfb
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_09_06_00_auth.sql
@@ -0,0 +1,3 @@
+-- rbac simplify
+DELETE FROM `rbac_linked_permissions` WHERE `linkedid` IN (378,379,380,381,382,383,384,385,386,852,874);
+DELETE FROM `rbac_permissions` WHERE `id` IN (378,379,380,381,382,383,384,385,386,852,874);
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_09_17_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_09_17_00_auth.sql
new file mode 100644
index 00000000000..7aa76283e57
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_09_17_00_auth.sql
@@ -0,0 +1,6 @@
+-- 
+DELETE FROM `rbac_permissions` WHERE `id`=852;
+INSERT INTO `rbac_permissions` (`id`,`name`) VALUES (852, 'Command: debug dummy');
+
+DELETE FROM `rbac_linked_permissions` WHERE `linkedId`=852;
+INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES (196,852);
diff --git a/sql/old/3.3.5a/auth/64_2019_03_19/2018_12_30_00_auth.sql b/sql/old/3.3.5a/auth/64_2019_03_19/2018_12_30_00_auth.sql
new file mode 100644
index 00000000000..ba82aab6838
--- /dev/null
+++ b/sql/old/3.3.5a/auth/64_2019_03_19/2018_12_30_00_auth.sql
@@ -0,0 +1,3 @@
+-- Port Trainer changes from master to 3.3.5
+DELETE FROM `rbac_permissions` WHERE `id`=672;
+INSERT INTO `rbac_permissions` (`id`, `name`) VALUES (672, 'Command: reload trainer');