diff options
| author | TDB Release <tdb-release@build.bot> | 2025-10-29 07:02:07 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2025-10-29 07:02:07 +0000 |
| commit | cca05feeb4cb5be081694ada75a90069c96dc13d (patch) | |
| tree | f8fecfd2a8f8b68284ee89746a87b2a6f5f6bbf2 /sql/updates/auth | |
| parent | d0a4c0a1f09c261ff5b41682c4263d0769a02904 (diff) | |
TDB 1125.25101 - 2025/10/29TDB1125.25101
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2025_08_19_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_08_20_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_08_23_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_08_27_00_auth.sql | 21 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_08_29_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_09_03_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_09_04_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_09_12_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_09_20_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_10_10_00_auth.sql | 33 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_10_11_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_10_15_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_10_22_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2025_10_29_00_auth.sql (renamed from sql/updates/auth/master/2025_08_16_00_auth.sql) | 2 |
14 files changed, 1 insertions, 308 deletions
diff --git a/sql/updates/auth/master/2025_08_19_00_auth.sql b/sql/updates/auth/master/2025_08_19_00_auth.sql deleted file mode 100644 index 029fe84548d..00000000000 --- a/sql/updates/auth/master/2025_08_19_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (62680); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(62680,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62680 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(62680,'Mac','A64','WoW',0x52D3CFF8AE101B720C4DF1B5288A1E8B), -(62680,'Mac','A64','WoWC',0x7FBBF2377E83B980B2501106B2F88CA9), -(62680,'Mac','x64','WoW',0xE8E4D9C538DAB507F623EBF3F7A503A8), -(62680,'Mac','x64','WoWC',0xACAF4F2E279ECFCD00787BB199F92F2C), -(62680,'Win','A64','WoW',0xFB08879F4B65374123CF59A650885A58), -(62680,'Win','x64','WoW',0x2E4DDEDE233C86BE7967901A85134A89), -(62680,'Win','x64','WoWC',0x539619B1D95663BBB7AB003BB6D0BA5E); - -UPDATE `realmlist` SET `gamebuild`=62680 WHERE `gamebuild`=62493; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '62680'; diff --git a/sql/updates/auth/master/2025_08_20_00_auth.sql b/sql/updates/auth/master/2025_08_20_00_auth.sql deleted file mode 100644 index b0849b526bd..00000000000 --- a/sql/updates/auth/master/2025_08_20_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (62706); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(62706,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62706 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(62706,'Mac','A64','WoW',0x7372D28C666F784572DD68134C7BE334), -(62706,'Mac','A64','WoWC',0x051D00671FF57B9EDB916F132486DB36), -(62706,'Mac','x64','WoW',0xC38F4C4BE255E157128BC8A37B462F13), -(62706,'Mac','x64','WoWC',0xBCFAE421FED4748F8B02AE95E967EEED), -(62706,'Win','A64','WoW',0x30ACDD80A1EB57C6A7F2E42F00FC7D23), -(62706,'Win','x64','WoW',0xE2D46634684B91376459DB726284F1E2), -(62706,'Win','x64','WoWC',0xB09CA7D4EC722C8F3D8190A540AD4146); - -UPDATE `realmlist` SET `gamebuild`=62706 WHERE `gamebuild`=62680; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '62706'; diff --git a/sql/updates/auth/master/2025_08_23_00_auth.sql b/sql/updates/auth/master/2025_08_23_00_auth.sql deleted file mode 100644 index db4e1160213..00000000000 --- a/sql/updates/auth/master/2025_08_23_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (62748); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(62748,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62748 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(62748,'Mac','A64','WoW',0x9CAC1407FB10E3FDA83DAC1853428221), -(62748,'Mac','A64','WoWC',0x871EA7435FE7EF66FB7DA5608907D071), -(62748,'Mac','x64','WoW',0x831C90A6467734EB2F25E19A08216731), -(62748,'Mac','x64','WoWC',0x0EB9A67428B9A658EC5A1FEA4A3CFAC3), -(62748,'Win','A64','WoW',0x56C59031E7D37485DAD25A2BC4A49B86), -(62748,'Win','x64','WoW',0x099FE6DC3AD0811C751C0DA819D032B4), -(62748,'Win','x64','WoWC',0x6ECA332852D9BFF77CE2A9D71A976D55); - -UPDATE `realmlist` SET `gamebuild`=62748 WHERE `gamebuild`=62706; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '62748'; diff --git a/sql/updates/auth/master/2025_08_27_00_auth.sql b/sql/updates/auth/master/2025_08_27_00_auth.sql deleted file mode 100644 index d7124e75fc3..00000000000 --- a/sql/updates/auth/master/2025_08_27_00_auth.sql +++ /dev/null @@ -1,21 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (62801); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(62801,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=62801 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62801 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62801 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62801 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62801 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62801 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(62801,'Mac','A64','WoW',0x470490902700B0F9A4EAC34B47B71328), -(62801,'Mac','A64','WoWC',0xF2318FBA8B75E3B8A22E4B602341BF62), -(62801,'Mac','x64','WoWC',0x9D82076D2C5C4D2970873585DDC4743D), -(62801,'Win','A64','WoW',0xDFC8340DB35969E4B793EF298A3AE2B7), -(62801,'Win','x64','WoW',0x8C156FABF29ABC1D11599FAFA1E3CB77), -(62801,'Win','x64','WoWC',0x55C4950FE311327C27A7E5101ADAEE42); - -UPDATE `realmlist` SET `gamebuild`=62801 WHERE `gamebuild`=62748; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '62801'; diff --git a/sql/updates/auth/master/2025_08_29_00_auth.sql b/sql/updates/auth/master/2025_08_29_00_auth.sql deleted file mode 100644 index a8acee23ce0..00000000000 --- a/sql/updates/auth/master/2025_08_29_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (62876); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(62876,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62876 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(62876,'Mac','A64','WoW',0x93D9177AE7FCF5D5353CC368882BA6AB), -(62876,'Mac','A64','WoWC',0x7EAEA45F071D0DF95878AA4B6C1E0A3B), -(62876,'Mac','x64','WoW',0xC981B22C49FE45D1E89F8F85E3F1474E), -(62876,'Mac','x64','WoWC',0x3405E814B5F2738F5358E7BA95D20783), -(62876,'Win','A64','WoW',0xA0BE8304E27CB1DDE6CAE9DEADEDD2CE), -(62876,'Win','x64','WoW',0x477ADDD4838B7C1017F48EE3C82437BA), -(62876,'Win','x64','WoWC',0xCD36DAABF5EFF54B47BC25F40B408A54); - -UPDATE `realmlist` SET `gamebuild`=62876 WHERE `gamebuild`=62801; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '62876'; diff --git a/sql/updates/auth/master/2025_09_03_00_auth.sql b/sql/updates/auth/master/2025_09_03_00_auth.sql deleted file mode 100644 index 0c18db99552..00000000000 --- a/sql/updates/auth/master/2025_09_03_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (62958); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(62958,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=62958 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(62958,'Mac','A64','WoW',0xEE77D6BFA45BABF53FE4C772574599A6), -(62958,'Mac','A64','WoWC',0x7D3860F9B0E9E539920142F4EAEC860D), -(62958,'Mac','x64','WoW',0x63FBEC08A7D15969549287392C7CB19A), -(62958,'Mac','x64','WoWC',0x32316C8B3AF4FDCF7A67FD7769A7F12B), -(62958,'Win','A64','WoW',0x9E640307050295A43A034A1DDA8A4814), -(62958,'Win','x64','WoW',0xD72F913B55C92C58450FCFB68704783F), -(62958,'Win','x64','WoWC',0x6E767AD759A2B19C289127A4D4AEAD1F); - -UPDATE `realmlist` SET `gamebuild`=62958 WHERE `gamebuild`=62876; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '62958'; diff --git a/sql/updates/auth/master/2025_09_04_00_auth.sql b/sql/updates/auth/master/2025_09_04_00_auth.sql deleted file mode 100644 index 00bca87ffa7..00000000000 --- a/sql/updates/auth/master/2025_09_04_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63003); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63003,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63003 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63003,'Mac','A64','WoW',0x11C3DFF1F900B7144DD1C60059D73E6F), -(63003,'Mac','A64','WoWC',0x3BACD112C004A649039B6E9B95833B9F), -(63003,'Mac','x64','WoW',0x7CE021E303D8D253F7231AAF4D06EC4A), -(63003,'Mac','x64','WoWC',0x51747BD29A6B1D635D88D8EA52F6D341), -(63003,'Win','A64','WoW',0x0400F2403DD8EDF9D3DEF5AF511FA6DC), -(63003,'Win','x64','WoW',0x6D1E354D17FB3885568FD704B87F98C2), -(63003,'Win','x64','WoWC',0x082C75D4F7115F904230A5716E17995A); - -UPDATE `realmlist` SET `gamebuild`=63003 WHERE `gamebuild`=62958; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63003'; diff --git a/sql/updates/auth/master/2025_09_12_00_auth.sql b/sql/updates/auth/master/2025_09_12_00_auth.sql deleted file mode 100644 index 53658b09b56..00000000000 --- a/sql/updates/auth/master/2025_09_12_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63163); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63163,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63163 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63163,'Mac','A64','WoW',0xA8DAF8783FBCEDC838F06D14F9337EB4), -(63163,'Mac','A64','WoWC',0xA447DA7F38F1082999C66C6F403CEB21), -(63163,'Mac','x64','WoW',0x396AF90D95CC4F0DF2A58C3BE3DA6C55), -(63163,'Mac','x64','WoWC',0x0D1573C127ABCC39CBB98976F87C0D49), -(63163,'Win','A64','WoW',0xD861754AF8BF0BF9AD55131DB40D4F1D), -(63163,'Win','x64','WoW',0x79261C76FC38EBE8BEC0065DE478B8DF), -(63163,'Win','x64','WoWC',0xE831CF15178929EC992A5389822B03E0); - -UPDATE `realmlist` SET `gamebuild`=63163 WHERE `gamebuild`=63003; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63163'; diff --git a/sql/updates/auth/master/2025_09_20_00_auth.sql b/sql/updates/auth/master/2025_09_20_00_auth.sql deleted file mode 100644 index a413f5cb4f4..00000000000 --- a/sql/updates/auth/master/2025_09_20_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63305); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63305,11,2,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63305 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63305,'Mac','A64','WoW',0x22E7C05A01EA110EFDACFFC2AE4B27DE), -(63305,'Mac','A64','WoWC',0xBEB015F25B21F43EF52AF0FAA572E6E8), -(63305,'Mac','x64','WoW',0xFE6D35D91A23B18C3E05C9CF587CB27F), -(63305,'Mac','x64','WoWC',0x0D600A97C7207828F2DEC0DCA49BC0A8), -(63305,'Win','A64','WoW',0xBA66EFD522EB2CDC8D3FF9184BCD91CA), -(63305,'Win','x64','WoW',0x93C43B6A6902CA37F15C68AAB8E69321), -(63305,'Win','x64','WoWC',0x47BBB811D2AC4DA0D74FEFC0DD32940E); - -UPDATE `realmlist` SET `gamebuild`=63305 WHERE `gamebuild`=63163; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63305'; diff --git a/sql/updates/auth/master/2025_10_10_00_auth.sql b/sql/updates/auth/master/2025_10_10_00_auth.sql deleted file mode 100644 index cf4dd7571dd..00000000000 --- a/sql/updates/auth/master/2025_10_10_00_auth.sql +++ /dev/null @@ -1,33 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63506,63660,63704); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63506,11,2,5,NULL), -(63660,11,2,5,NULL), -(63704,11,2,5,NULL); - -DELETE FROM `build_auth_key` WHERE `build` IN (63506,63660,63704); -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63506,'Mac','A64','WoW',0xDE529C1341CA640EC839ED26BF4E1F15), -(63506,'Mac','A64','WoWC',0x77AC8716911DCEA2DB5F87215A2D6090), -(63506,'Mac','x64','WoW',0x3F2314EB0EE2A8A0C2C830E52C9BD5B3), -(63506,'Mac','x64','WoWC',0x20D2A070B78BFDEE73827C80CEDBDC16), -(63506,'Win','A64','WoW',0x6D5DC638BF4AE6BDC34AB8624AEA49A7), -(63506,'Win','x64','WoW',0x68631E3B12CE5AA4839C46B9C70EF231), -(63506,'Win','x64','WoWC',0x2D3D993AF54F07CC108463F88016FAFF), -(63660,'Mac','A64','WoW',0xA5FD60B6FE600DCD41DAD4DFFCF3CA0F), -(63660,'Mac','A64','WoWC',0xC33A55FFC1AB8C5CB6D2C9175F4D3018), -(63660,'Mac','x64','WoW',0x5BA8FC2098BBBD9FB30178B95B616DA6), -(63660,'Mac','x64','WoWC',0x52BA0A6B2432D7584F597AFD1638C085), -(63660,'Win','A64','WoW',0x58CDF4DAAF8EA1211A1514FBC4F668B5), -(63660,'Win','x64','WoW',0xD613DF0CB4BE97E954BD4C8F0DCC0B3C), -(63660,'Win','x64','WoWC',0x767FAAF58A1E698927D9226DEAABADC3), -(63704,'Mac','A64','WoW',0x88A6E7FA99D6E842FFB4DB126A505DA0), -(63704,'Mac','A64','WoWC',0x0BF4F67CDA8D398FA96A6330FD5B331A), -(63704,'Mac','x64','WoW',0x186CCDAFD21B074CBFD5C4960A1397F9), -(63704,'Mac','x64','WoWC',0xF6BA093EE09B78DC5E70FFA78ECAE49C), -(63704,'Win','A64','WoW',0x855B9CFD0785A946AFAEEF2CF7B988CC), -(63704,'Win','x64','WoW',0x7CB483EBD52970D0CBBB7952036CEAFA), -(63704,'Win','x64','WoWC',0x4985EB04D5FE1D78EB0CC7D490EF6E79); - -UPDATE `realmlist` SET `gamebuild`=63704 WHERE `gamebuild`=63305; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63704'; diff --git a/sql/updates/auth/master/2025_10_11_00_auth.sql b/sql/updates/auth/master/2025_10_11_00_auth.sql deleted file mode 100644 index fcfba6cbcee..00000000000 --- a/sql/updates/auth/master/2025_10_11_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63796); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63796,11,2,5,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63796 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63796,'Mac','A64','WoW',0x37C6D6728FE1C680594B374DE295759F), -(63796,'Mac','A64','WoWC',0x5F1902882D5525027A0F0255A68285E4), -(63796,'Mac','x64','WoW',0xA154B606D59E981AABE1D089ED766062), -(63796,'Mac','x64','WoWC',0x9874169656A5E844FDE8E89FDC4D01B6), -(63796,'Win','A64','WoW',0xF11BB1558CDEF01264E8D0D7D0159463), -(63796,'Win','x64','WoW',0x2D124FB65A2BAA4288570C2F8C4A5468), -(63796,'Win','x64','WoWC',0x439696AE133D1F8F28E78D40E0113F41); - -UPDATE `realmlist` SET `gamebuild`=63796 WHERE `gamebuild`=63704; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63796'; diff --git a/sql/updates/auth/master/2025_10_15_00_auth.sql b/sql/updates/auth/master/2025_10_15_00_auth.sql deleted file mode 100644 index dc9848d5dcd..00000000000 --- a/sql/updates/auth/master/2025_10_15_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63834); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63834,11,2,5,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63834 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63834,'Mac','A64','WoW',0xFBDB4BFD98FAF22C118CFB91D4B0CF56), -(63834,'Mac','A64','WoWC',0x7AC2021D201FCB81BC24A3541B7E44AD), -(63834,'Mac','x64','WoW',0xD1E411CB89026C549C8F2E4043CE596F), -(63834,'Mac','x64','WoWC',0xC1D16D8E2893A07529F54B150D1E9478), -(63834,'Win','A64','WoW',0x9ABF336240A8D5D8A53807CA03009809), -(63834,'Win','x64','WoW',0xA7E739F0FDF745A879791DECE8066BF2), -(63834,'Win','x64','WoWC',0x67808AA1E78AAFDD345070F4AB40DD5C); - -UPDATE `realmlist` SET `gamebuild`=63834 WHERE `gamebuild`=63796; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63834'; diff --git a/sql/updates/auth/master/2025_10_22_00_auth.sql b/sql/updates/auth/master/2025_10_22_00_auth.sql deleted file mode 100644 index 562b1f7b0e5..00000000000 --- a/sql/updates/auth/master/2025_10_22_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (63906); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(63906,11,2,5,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=63906 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(63906,'Mac','A64','WoW',0x2498B74093269B1CC2A597BF368BF808), -(63906,'Mac','A64','WoWC',0x1A6B72DA01501C0B1FCE84BF42F2952D), -(63906,'Mac','x64','WoW',0x3CD6B638DED480F69E9DB88B9C8E52B9), -(63906,'Mac','x64','WoWC',0x6C931FF70F78BAD0707EA57157D40718), -(63906,'Win','A64','WoW',0x5ECAB6CD8F056268F02B3ACC984A5769), -(63906,'Win','x64','WoW',0xA58FDAC26513D567C1F128339126C602), -(63906,'Win','x64','WoWC',0xCB2C6E16508E82C2529F1C6CD2E6E6D9); - -UPDATE `realmlist` SET `gamebuild`=63906 WHERE `gamebuild`=63834; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63906'; diff --git a/sql/updates/auth/master/2025_08_16_00_auth.sql b/sql/updates/auth/master/2025_10_29_00_auth.sql index 8c96feb0370..f200fa659f6 100644 --- a/sql/updates/auth/master/2025_08_16_00_auth.sql +++ b/sql/updates/auth/master/2025_10_29_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 1120.25081 auth +-- TDB 1125.25101 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED'); |
