aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2019-03-19 07:20:15 +0000
committerTDB Release <tdb-release@build.bot>2019-03-19 07:20:15 +0000
commit3358cc2a4772aedf6415b5ba7ca3fdbbf808da24 (patch)
treecbf384404d28bb48b827514934d7bdf68c795d0d /sql/updates/auth
parent995aabe4bbbe17233376e7ee84a2ae52a82b424b (diff)
TDB 335.19031 - 2019/03/19TDB335.19031
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/3.3.5/2018_03_06_00_auth.sql5
-rw-r--r--sql/updates/auth/3.3.5/2018_03_08_00_auth.sql7
-rw-r--r--sql/updates/auth/3.3.5/2018_06_23_00_auth.sql3
-rw-r--r--sql/updates/auth/3.3.5/2018_08_30_00_auth.sql9
-rw-r--r--sql/updates/auth/3.3.5/2018_09_06_00_auth.sql3
-rw-r--r--sql/updates/auth/3.3.5/2018_09_17_00_auth.sql6
-rw-r--r--sql/updates/auth/3.3.5/2018_12_30_00_auth.sql3
-rw-r--r--sql/updates/auth/3.3.5/2019_03_19_00_auth.sql (renamed from sql/updates/auth/3.3.5/2018_02_19_00_auth.sql)2
8 files changed, 1 insertions, 37 deletions
diff --git a/sql/updates/auth/3.3.5/2018_03_06_00_auth.sql b/sql/updates/auth/3.3.5/2018_03_06_00_auth.sql
deleted file mode 100644
index ddaf1d13f0c..00000000000
--- a/sql/updates/auth/3.3.5/2018_03_06_00_auth.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-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/updates/auth/3.3.5/2018_03_08_00_auth.sql b/sql/updates/auth/3.3.5/2018_03_08_00_auth.sql
deleted file mode 100644
index 8b0e18b1e6c..00000000000
--- a/sql/updates/auth/3.3.5/2018_03_08_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-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/updates/auth/3.3.5/2018_06_23_00_auth.sql b/sql/updates/auth/3.3.5/2018_06_23_00_auth.sql
deleted file mode 100644
index 3bbe03f8c19..00000000000
--- a/sql/updates/auth/3.3.5/2018_06_23_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
---
-DROP TABLE IF EXISTS `ip2nation`;
-DROP TABLE IF EXISTS `ip2nationCountries`;
diff --git a/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql b/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql
deleted file mode 100644
index 1ee1f8d7ee4..00000000000
--- a/sql/updates/auth/3.3.5/2018_08_30_00_auth.sql
+++ /dev/null
@@ -1,9 +0,0 @@
---
-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/updates/auth/3.3.5/2018_09_06_00_auth.sql b/sql/updates/auth/3.3.5/2018_09_06_00_auth.sql
deleted file mode 100644
index 5a9718edcfb..00000000000
--- a/sql/updates/auth/3.3.5/2018_09_06_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 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/updates/auth/3.3.5/2018_09_17_00_auth.sql b/sql/updates/auth/3.3.5/2018_09_17_00_auth.sql
deleted file mode 100644
index 7aa76283e57..00000000000
--- a/sql/updates/auth/3.3.5/2018_09_17_00_auth.sql
+++ /dev/null
@@ -1,6 +0,0 @@
---
-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/updates/auth/3.3.5/2018_12_30_00_auth.sql b/sql/updates/auth/3.3.5/2018_12_30_00_auth.sql
deleted file mode 100644
index ba82aab6838..00000000000
--- a/sql/updates/auth/3.3.5/2018_12_30_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
--- 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');
diff --git a/sql/updates/auth/3.3.5/2018_02_19_00_auth.sql b/sql/updates/auth/3.3.5/2019_03_19_00_auth.sql
index 78879b5db86..62715adcad9 100644
--- a/sql/updates/auth/3.3.5/2018_02_19_00_auth.sql
+++ b/sql/updates/auth/3.3.5/2019_03_19_00_auth.sql
@@ -1,2 +1,2 @@
--- TDB 335.64 auth
+-- TDB 335.19031 auth
UPDATE `updates` SET `state`='ARCHIVED';