From f0a87e11f2668fea1eeb453a76ac03520d109029 Mon Sep 17 00:00:00 2001 From: TDB Release Date: Tue, 20 Oct 2020 21:43:38 +0000 Subject: TDB 837.20101 - 2020/10/20 --- sql/updates/auth/master/2017_08_01_00_auth.sql | 8 -------- sql/updates/auth/master/2020_08_14_00_auth.sql | 3 --- sql/updates/auth/master/2020_08_26_00_auth.sql | 7 ------- sql/updates/auth/master/2020_09_25_00_auth.sql | 1 - sql/updates/auth/master/2020_10_20_00_auth.sql | 3 +++ 5 files changed, 3 insertions(+), 19 deletions(-) delete mode 100644 sql/updates/auth/master/2017_08_01_00_auth.sql delete mode 100644 sql/updates/auth/master/2020_08_14_00_auth.sql delete mode 100644 sql/updates/auth/master/2020_08_26_00_auth.sql delete mode 100644 sql/updates/auth/master/2020_09_25_00_auth.sql create mode 100644 sql/updates/auth/master/2020_10_20_00_auth.sql (limited to 'sql/updates/auth') 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_14_00_auth.sql b/sql/updates/auth/master/2020_08_14_00_auth.sql deleted file mode 100644 index 61deac3b721..00000000000 --- a/sql/updates/auth/master/2020_08_14_00_auth.sql +++ /dev/null @@ -1,3 +0,0 @@ --- TDB 837.20081 auth -UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; -REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED'); 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_10_20_00_auth.sql b/sql/updates/auth/master/2020_10_20_00_auth.sql new file mode 100644 index 00000000000..3a890913a62 --- /dev/null +++ b/sql/updates/auth/master/2020_10_20_00_auth.sql @@ -0,0 +1,3 @@ +-- TDB 837.20101 auth +UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; +REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED'); -- cgit v1.2.3