aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/auth
diff options
context:
space:
mode:
authorTDB Release <tdb-release@build.bot>2020-06-17 17:09:48 +0000
committerTDB Release <tdb-release@build.bot>2020-06-17 17:09:48 +0000
commit6e62bf5a1eebb8e8fc9f59eab7ee590025fc3f31 (patch)
tree4cf3974f834ac722ae373e16bd10245770bb8fad /sql/updates/auth
parent574ee17d6d1116048b3d9bb776c65dc053bccd85 (diff)
TDB 830.20061 - 2020/06/17TDB830.20061
Diffstat (limited to 'sql/updates/auth')
-rw-r--r--sql/updates/auth/master/2019_07_15_00_auth.sql2
-rw-r--r--sql/updates/auth/master/2019_07_26_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_08_11_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_08_18_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_10_27_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_11_13_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_11_20_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_11_23_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_12_04_00_auth.sql3
-rw-r--r--sql/updates/auth/master/2019_12_07_00_auth.sql106
-rw-r--r--sql/updates/auth/master/2019_12_10_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2019_12_14_00_auth.sql1
-rw-r--r--sql/updates/auth/master/2020_01_11_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_01_12_00_auth.sql1
-rw-r--r--sql/updates/auth/master/2020_02_17_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_02_24_00_auth.sql1
-rw-r--r--sql/updates/auth/master/2020_03_03_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_03_20_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_03_23_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_03_31_00_auth.sql1
-rw-r--r--sql/updates/auth/master/2020_04_04_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_04_30_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_05_19_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_06_04_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_06_17_00_auth.sql7
-rw-r--r--sql/updates/auth/master/2020_06_17_01_auth.sql3
26 files changed, 3 insertions, 213 deletions
diff --git a/sql/updates/auth/master/2019_07_15_00_auth.sql b/sql/updates/auth/master/2019_07_15_00_auth.sql
deleted file mode 100644
index ac13241781b..00000000000
--- a/sql/updates/auth/master/2019_07_15_00_auth.sql
+++ /dev/null
@@ -1,2 +0,0 @@
--- TDB 820.19071 auth
-UPDATE `updates` SET `state`='ARCHIVED';
diff --git a/sql/updates/auth/master/2019_07_26_00_auth.sql b/sql/updates/auth/master/2019_07_26_00_auth.sql
deleted file mode 100644
index 2b4660a7e4c..00000000000
--- a/sql/updates/auth/master/2019_07_26_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=31229 WHERE `gamebuild`=30993;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '31229';
diff --git a/sql/updates/auth/master/2019_08_11_00_auth.sql b/sql/updates/auth/master/2019_08_11_00_auth.sql
deleted file mode 100644
index 934c62f5500..00000000000
--- a/sql/updates/auth/master/2019_08_11_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=31429 WHERE `gamebuild`=31229;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '31429';
diff --git a/sql/updates/auth/master/2019_08_18_00_auth.sql b/sql/updates/auth/master/2019_08_18_00_auth.sql
deleted file mode 100644
index 793e4dfd9d2..00000000000
--- a/sql/updates/auth/master/2019_08_18_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=31478 WHERE `gamebuild`=31429;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '31478';
diff --git a/sql/updates/auth/master/2019_10_27_00_auth.sql b/sql/updates/auth/master/2019_10_27_00_auth.sql
deleted file mode 100644
index d96382b9632..00000000000
--- a/sql/updates/auth/master/2019_10_27_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=32305 WHERE `gamebuild`=31478;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32305';
diff --git a/sql/updates/auth/master/2019_11_13_00_auth.sql b/sql/updates/auth/master/2019_11_13_00_auth.sql
deleted file mode 100644
index ece5d674504..00000000000
--- a/sql/updates/auth/master/2019_11_13_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=32494 WHERE `gamebuild`=32305;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32494';
diff --git a/sql/updates/auth/master/2019_11_20_00_auth.sql b/sql/updates/auth/master/2019_11_20_00_auth.sql
deleted file mode 100644
index 0540eb2a014..00000000000
--- a/sql/updates/auth/master/2019_11_20_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=32580 WHERE `gamebuild`=32494;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32580';
diff --git a/sql/updates/auth/master/2019_11_23_00_auth.sql b/sql/updates/auth/master/2019_11_23_00_auth.sql
deleted file mode 100644
index 4df0a0e234b..00000000000
--- a/sql/updates/auth/master/2019_11_23_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=32638 WHERE `gamebuild`=32580;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32638';
diff --git a/sql/updates/auth/master/2019_12_04_00_auth.sql b/sql/updates/auth/master/2019_12_04_00_auth.sql
deleted file mode 100644
index 059de16d7ff..00000000000
--- a/sql/updates/auth/master/2019_12_04_00_auth.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-UPDATE `realmlist` SET `gamebuild`=32722 WHERE `gamebuild`=32638;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32722';
diff --git a/sql/updates/auth/master/2019_12_07_00_auth.sql b/sql/updates/auth/master/2019_12_07_00_auth.sql
deleted file mode 100644
index 1cbe9f22482..00000000000
--- a/sql/updates/auth/master/2019_12_07_00_auth.sql
+++ /dev/null
@@ -1,106 +0,0 @@
---
--- Table structure for table `build_info`
---
-DROP TABLE IF EXISTS `build_info`;
-CREATE TABLE `build_info` (
- `build` int(11) NOT NULL,
- `majorVersion` int(11) DEFAULT NULL,
- `minorVersion` int(11) DEFAULT NULL,
- `bugfixVersion` int(11) DEFAULT NULL,
- `hotfixVersion` char(3) DEFAULT NULL,
- `winAuthSeed` varchar(32) DEFAULT NULL,
- `win64AuthSeed` varchar(32) DEFAULT NULL,
- `mac64AuthSeed` varchar(32) DEFAULT NULL,
- `winChecksumSeed` varchar(40) DEFAULT NULL,
- `macChecksumSeed` varchar(40) DEFAULT NULL,
- PRIMARY KEY (`build`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
---
--- Dumping data for table `build_info`
---
-INSERT INTO `build_info` VALUES
-(5875,1,12,1,NULL,NULL,NULL,NULL,'95EDB27C7823B363CBDDAB56A392E7CB73FCCA20','8D173CC381961EEBABF336F5E6675B101BB513E5'),
-(6005,1,12,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(6141,1,12,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(8606,2,4,3,NULL,NULL,NULL,NULL,'319AFAA3F2559682F9FF658BE01456255F456FB1','D8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F'),
-(9947,3,1,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(10505,3,2,2,'a',NULL,NULL,NULL,NULL,NULL),
-(11159,3,3,0,'a',NULL,NULL,NULL,NULL,NULL),
-(11403,3,3,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(11723,3,3,3,'a',NULL,NULL,NULL,NULL,NULL),
-(12340,3,3,5,'a',NULL,NULL,NULL,'CDCBBD5188315E6B4D19449D492DBCFAF156A347','B706D13FF2F4018839729461E3F8A0E2B5FDC034'),
-(13623,4,0,6,'a',NULL,NULL,NULL,NULL,NULL),
-(13930,3,3,5,'a',NULL,NULL,NULL,NULL,NULL),
-(14545,4,2,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(15595,4,3,4,NULL,NULL,NULL,NULL,NULL,NULL),
-(19116,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(19243,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(19342,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(19702,6,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(19802,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(19831,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(19865,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(20182,6,2,0,'a',NULL,NULL,NULL,NULL,NULL),
-(20201,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(20216,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(20253,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(20338,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(20444,6,2,2,NULL,NULL,NULL,NULL,NULL,NULL),
-(20490,6,2,2,'a',NULL,NULL,NULL,NULL,NULL),
-(20574,6,2,2,'a',NULL,NULL,NULL,NULL,NULL),
-(20726,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(20779,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(20886,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(21355,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL),
-(21463,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL),
-(21742,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL),
-(22248,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22293,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22345,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22410,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22423,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22498,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22522,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22566,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22594,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22624,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22747,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22810,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL),
-(22900,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(22908,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(22950,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(22995,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(22996,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(23171,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(23222,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(23360,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(23420,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(23911,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(23937,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(24015,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL),
-(24330,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(24367,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(24415,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(24430,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(24461,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(24742,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL),
-(25549,7,3,2,NULL,'FE594FC35E7F9AFF86D99D8A364AB297','1252624ED8CBD6FAC7D33F5D67A535F3','66FC5E09B8706126795F140308C8C1D8',NULL,NULL),
-(25996,7,3,5,NULL,'23C59C5963CBEF5B728D13A50878DFCB','C7FF932D6A2174A3D538CA7212136D2B','210B970149D6F56CAC9BADF2AAC91E8E',NULL,NULL),
-(26124,7,3,5,NULL,'F8C05AE372DECA1D6C81DA7A8D1C5C39','46DF06D0147BA67BA49AF553435E093F','C9CA997AB8EDE1C65465CB2920869C4E',NULL,NULL),
-(26365,7,3,5,NULL,'2AAC82C80E829E2CA902D70CFA1A833A','59A53F307288454B419B13E694DF503C','DBE7F860276D6B400AAA86B35D51A417',NULL,NULL),
-(26654,7,3,5,NULL,'FAC2D693E702B9EC9F750F17245696D8','A752640E8B99FE5B57C1320BC492895A','9234C1BD5E9687ADBD19F764F2E0E811',NULL,NULL),
-(26822,7,3,5,NULL,'283E8D77ECF7060BE6347BE4EB99C7C7','2B05F6D746C0C6CC7EF79450B309E595','91003668C245D14ECD8DF094E065E06B',NULL,NULL),
-(26899,7,3,5,NULL,'F462CD2FE4EA3EADF875308FDBB18C99','3551EF0028B51E92170559BD25644B03','8368EFC2021329110A16339D298200D4',NULL,NULL),
-(26972,7,3,5,NULL,'797ECC19662DCBD5090A4481173F1D26','6E212DEF6A0124A3D9AD07F5E322F7AE','341CFEFE3D72ACA9A4407DC535DED66A',NULL,NULL),
-(28153,8,0,1,NULL,NULL,'DD626517CC6D31932B479934CCDC0ABF',NULL,NULL,NULL),
-(30706,8,1,5,NULL,NULL,'BB6D9866FE4A19A568015198783003FC',NULL,NULL,NULL),
-(30993,8,2,0,NULL,NULL,'2BAD61655ABC2FC3D04893B536403A91',NULL,NULL,NULL),
-(31229,8,2,0,NULL,NULL,'8A46F23670309F2AAE85C9A47276382B',NULL,NULL,NULL),
-(31429,8,2,0,NULL,NULL,'7795A507AF9DC3525EFF724FEE17E70C',NULL,NULL,NULL),
-(31478,8,2,0,NULL,NULL,'7973A8D54BDB8B798D9297B096E771EF',NULL,NULL,NULL),
-(32305,8,2,5,NULL,NULL,'21F5A6FC7AD89FBF411FDA8B8738186A',NULL,NULL,NULL),
-(32494,8,2,5,NULL,NULL,'58984ACE04919401835C61309A848F8A',NULL,NULL,NULL),
-(32580,8,2,5,NULL,NULL,'87C2FAA0D7931BF016299025C0DDCA14',NULL,NULL,NULL),
-(32638,8,2,5,NULL,NULL,'5D07ECE7D4A867DDDE615DAD22B76D4E',NULL,NULL,NULL),
-(32722,8,2,5,NULL,NULL,'1A09BE1D38A122586B4931BECCEAD4AA',NULL,NULL,NULL);
diff --git a/sql/updates/auth/master/2019_12_10_00_auth.sql b/sql/updates/auth/master/2019_12_10_00_auth.sql
deleted file mode 100644
index cafae5c9e73..00000000000
--- a/sql/updates/auth/master/2019_12_10_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=32750;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(32750,8,2,5,NULL,NULL,'C5CB669F5A5B237D1355430877173207',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=32750 WHERE `gamebuild`=32722;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32750';
diff --git a/sql/updates/auth/master/2019_12_14_00_auth.sql b/sql/updates/auth/master/2019_12_14_00_auth.sql
deleted file mode 100644
index c781194ce1b..00000000000
--- a/sql/updates/auth/master/2019_12_14_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='EF1F4E4D099EA2A81FD4C0DEBC1E7086' WHERE `build`=32750;
diff --git a/sql/updates/auth/master/2020_01_11_00_auth.sql b/sql/updates/auth/master/2020_01_11_00_auth.sql
deleted file mode 100644
index 73d58aea7a6..00000000000
--- a/sql/updates/auth/master/2020_01_11_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=32978;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(32978,8,2,5,NULL,NULL,'76AE2EA03E525D97F5688843F5489000',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=32978 WHERE `gamebuild`=32750;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '32978';
diff --git a/sql/updates/auth/master/2020_01_12_00_auth.sql b/sql/updates/auth/master/2020_01_12_00_auth.sql
deleted file mode 100644
index 92efe4dcd87..00000000000
--- a/sql/updates/auth/master/2020_01_12_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='1852C1F847E795D6EB45278CD433F339' WHERE `build`=32978;
diff --git a/sql/updates/auth/master/2020_02_17_00_auth.sql b/sql/updates/auth/master/2020_02_17_00_auth.sql
deleted file mode 100644
index 2fd279e6505..00000000000
--- a/sql/updates/auth/master/2020_02_17_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=33369;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(33369,8,3,0,NULL,NULL,'5986AC18B04D3C403F56A0CF8C4F0A14',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=33369 WHERE `gamebuild`=32978;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '33369';
diff --git a/sql/updates/auth/master/2020_02_24_00_auth.sql b/sql/updates/auth/master/2020_02_24_00_auth.sql
deleted file mode 100644
index ee115a5f54c..00000000000
--- a/sql/updates/auth/master/2020_02_24_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='F5A849C70A1054F07EA3AB833EBF6671' WHERE `build`=33369;
diff --git a/sql/updates/auth/master/2020_03_03_00_auth.sql b/sql/updates/auth/master/2020_03_03_00_auth.sql
deleted file mode 100644
index 5bf233d0b07..00000000000
--- a/sql/updates/auth/master/2020_03_03_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=33528;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(33528,8,3,0,NULL,NULL,'0ECE033CA9B11D92F7D2792C785B47DF',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=33528 WHERE `gamebuild`=33369;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '33528';
diff --git a/sql/updates/auth/master/2020_03_20_00_auth.sql b/sql/updates/auth/master/2020_03_20_00_auth.sql
deleted file mode 100644
index 8fc5a6c2162..00000000000
--- a/sql/updates/auth/master/2020_03_20_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=33724;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(33724,8,3,0,NULL,NULL,'38F7BBCF284939DD20E8C64CDBF9FE77',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=33724 WHERE `gamebuild`=33528;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '33724';
diff --git a/sql/updates/auth/master/2020_03_23_00_auth.sql b/sql/updates/auth/master/2020_03_23_00_auth.sql
deleted file mode 100644
index c17523f59b8..00000000000
--- a/sql/updates/auth/master/2020_03_23_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=33775;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(33775,8,3,0,NULL,NULL,'B826300A8449ED0F6EF16EA747FA2D2E',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=33775 WHERE `gamebuild`=33724;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '33775';
diff --git a/sql/updates/auth/master/2020_03_31_00_auth.sql b/sql/updates/auth/master/2020_03_31_00_auth.sql
deleted file mode 100644
index f2e02b374a1..00000000000
--- a/sql/updates/auth/master/2020_03_31_00_auth.sql
+++ /dev/null
@@ -1 +0,0 @@
-UPDATE `build_info` SET `mac64AuthSeed`='354D2DE619D124EE1398F76B0436FCFC' WHERE `build`=33775;
diff --git a/sql/updates/auth/master/2020_04_04_00_auth.sql b/sql/updates/auth/master/2020_04_04_00_auth.sql
deleted file mode 100644
index f57c5c404bf..00000000000
--- a/sql/updates/auth/master/2020_04_04_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=33941;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(33941,8,3,0,NULL,NULL,'88AF1A36D2770D0A6CA086497096A889',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=33941 WHERE `gamebuild`=33775;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '33941';
diff --git a/sql/updates/auth/master/2020_04_30_00_auth.sql b/sql/updates/auth/master/2020_04_30_00_auth.sql
deleted file mode 100644
index 7a9c08672b5..00000000000
--- a/sql/updates/auth/master/2020_04_30_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=34220;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(34220,8,3,0,NULL,NULL,'B5E35B976C6BAF82505700E7D9666A2C',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=34220 WHERE `gamebuild`=33941;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '34220';
diff --git a/sql/updates/auth/master/2020_05_19_00_auth.sql b/sql/updates/auth/master/2020_05_19_00_auth.sql
deleted file mode 100644
index 7ddeabe630c..00000000000
--- a/sql/updates/auth/master/2020_05_19_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `rbac_permissions` WHERE `id` = 855;
-INSERT INTO `rbac_permissions` (`id`,`name`) VALUES
-(855, 'Command: debug play music');
-
-DELETE FROM `rbac_linked_permissions` WHERE `id` = 855;
-INSERT INTO `rbac_linked_permissions` (`id`,`linkedId`) VALUES
-(198, 855);
diff --git a/sql/updates/auth/master/2020_06_04_00_auth.sql b/sql/updates/auth/master/2020_06_04_00_auth.sql
deleted file mode 100644
index e8c11c02a1d..00000000000
--- a/sql/updates/auth/master/2020_06_04_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=34601;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(34601,8,3,0,NULL,NULL,'0D7DF38F725FABA4F009257799A10563',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=34601 WHERE `gamebuild`=34220;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '34601';
diff --git a/sql/updates/auth/master/2020_06_17_00_auth.sql b/sql/updates/auth/master/2020_06_17_00_auth.sql
deleted file mode 100644
index e9544845cd3..00000000000
--- a/sql/updates/auth/master/2020_06_17_00_auth.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DELETE FROM `build_info` WHERE `build`=34769;
-INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
-(34769,8,3,0,NULL,NULL,'93F9B9AF6397E3E4EED94D36D16907D2',NULL,NULL,NULL);
-
-UPDATE `realmlist` SET `gamebuild`=34769 WHERE `gamebuild`=34601;
-
-ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int(10) unsigned NOT NULL DEFAULT '34769';
diff --git a/sql/updates/auth/master/2020_06_17_01_auth.sql b/sql/updates/auth/master/2020_06_17_01_auth.sql
new file mode 100644
index 00000000000..7cee90391bd
--- /dev/null
+++ b/sql/updates/auth/master/2020_06_17_01_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 830.20061 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/8.x/auth', 'ARCHIVED');