diff options
| author | TDB Release <tdb-release@build.bot> | 2020-06-17 17:09:48 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2020-06-17 17:09:48 +0000 |
| commit | 6e62bf5a1eebb8e8fc9f59eab7ee590025fc3f31 (patch) | |
| tree | 4cf3974f834ac722ae373e16bd10245770bb8fad /sql/updates/auth | |
| parent | 574ee17d6d1116048b3d9bb776c65dc053bccd85 (diff) | |
TDB 830.20061 - 2020/06/17TDB830.20061
Diffstat (limited to 'sql/updates/auth')
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'); |
