aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2020-10-20 21:43:38 +0000
committerTDB Release <tdb-release@build.bot>2020-10-20 21:43:38 +0000
commitf0a87e11f2668fea1eeb453a76ac03520d109029 (patch)
treef042d172af9021ea1bff44bfd46a5311470edc29 /sql/updates/auth
parent44b24fa12203b4ddbe34e40a5e6a7b925358781a (diff)
TDB 837.20101 - 2020/10/20TDB837.20101
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2017_08_01_00_auth.sql8
-rw-r--r--sql/updates/auth/master/2020_08_26_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_09_25_00_auth.sql1
-rw-r--r--sql/updates/auth/master/2020_10_20_00_auth.sql (renamed from sql/updates/auth/master/2020_08_14_00_auth.sql)2
4 files changed, 1 insertions, 17 deletions
diff --git a/sql/updates/auth/master/2017_08_01_00_auth.sql b/sql/updates/auth/master/2017_08_01_00_auth.sql
deleted file mode 100644
index 3921ed76d5a..00000000000
--- a/sql/updates/auth/master/2017_08_01_00_auth.sql
+++ /dev/null
@@ -1,8 +0,0 @@
---
-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/master/2020_08_26_00_auth.sql b/sql/updates/auth/master/2020_08_26_00_auth.sql
deleted file mode 100644
index 0b806685687..00000000000
--- a/sql/updates/auth/master/2020_08_26_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=35662;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(35662,8,3,7,NULL,NULL,'578BC94870C278CB6962F30E6DC203BB',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=35662 WHERE `gamebuild`=35435;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '35662';
diff --git a/sql/updates/auth/master/2020_09_25_00_auth.sql b/sql/updates/auth/master/2020_09_25_00_auth.sql
deleted file mode 100644
index 181f17118f7..00000000000
--- a/sql/updates/auth/master/2020_09_25_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='5966016C368ED9F7AAB603EE6703081C' WHERE `build`=35662;
diff --git a/sql/updates/auth/master/2020_08_14_00_auth.sql b/sql/updates/auth/master/2020_10_20_00_auth.sql
index 61deac3b721..3a890913a62 100644
--- a/sql/updates/auth/master/2020_08_14_00_auth.sql
+++ b/sql/updates/auth/master/2020_10_20_00_auth.sql
@@ -1,3 +1,3 @@
--- TDB 837.20081 auth
+-- TDB 837.20101 auth
UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED');