diff options
| author | TDB Release <tdb-release@build.bot> | 2025-03-29 01:17:19 +0000 |
|---|---|---|
| committer | TDB Release <tdb-release@build.bot> | 2025-03-29 01:17:19 +0000 |
| commit | 5641955918480a1d493637fdcaafaa2db0c2226b (patch) | |
| tree | 296682d2f3982aab9fc8e523364c51c6a88a4496 /sql/updates/auth | |
| parent | dfcd41abefec371e6af9db7db92c1dd55aa701ff (diff) | |
TDB 1110.25031 - 2025/03/29TDB1110.25031
Diffstat (limited to 'sql/updates/auth')
16 files changed, 1 insertions, 343 deletions
diff --git a/sql/updates/auth/master/2025_01_11_00_auth.sql b/sql/updates/auth/master/2025_01_11_00_auth.sql deleted file mode 100644 index 90df3c73715..00000000000 --- a/sql/updates/auth/master/2025_01_11_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58533); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58533,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58533 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58533,'Mac','A64','WoW',0xE637AA32D5DE914B119AF68CC9C9BAAB), -(58533,'Mac','A64','WoWC',0xE693DD275CEEE2D682EC973D79251977), -(58533,'Mac','x64','WoW',0xDE3723EF7EB991A1B27684E6513934D6), -(58533,'Mac','x64','WoWC',0xA93EF4385174001B69F43FF0DF345701), -(58533,'Win','A64','WoW',0x3823D2E16D6E314884CD586949524F2C), -(58533,'Win','x64','WoW',0x18490A077F4FBA0973E0B62A489EE664), -(58533,'Win','x64','WoWC',0x3DC9E22F553D631A5CA067F7809A3D2D); - -UPDATE `realmlist` SET `gamebuild`=58533 WHERE `gamebuild`=58238; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58533'; diff --git a/sql/updates/auth/master/2025_01_15_00_auth.sql b/sql/updates/auth/master/2025_01_15_00_auth.sql deleted file mode 100644 index c78de84b8d8..00000000000 --- a/sql/updates/auth/master/2025_01_15_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58608); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58608,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58608 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58608,'Mac','A64','WoW',0x3A3B639B7FC344EDB4314860638110F1), -(58608,'Mac','A64','WoWC',0x8F46148144EDF86BD45D23B0F23CE38B), -(58608,'Mac','x64','WoW',0x29EC11F81992F19AD9707B272419ADDA), -(58608,'Mac','x64','WoWC',0x2BF5613D82AD3A242B5DD0B140CE4416), -(58608,'Win','A64','WoW',0x6FD8AD7CCB3B7DAD45115CA93D3A68F3), -(58608,'Win','x64','WoW',0x21B3EDEB1A65388DD5988056D2BE72B2), -(58608,'Win','x64','WoWC',0xAC65E4DC868EFE4362E72BBCDD746853); - -UPDATE `realmlist` SET `gamebuild`=58608 WHERE `gamebuild`=58533; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58608'; diff --git a/sql/updates/auth/master/2025_01_15_01_auth.sql b/sql/updates/auth/master/2025_01_15_01_auth.sql deleted file mode 100644 index 98cdf680c1a..00000000000 --- a/sql/updates/auth/master/2025_01_15_01_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58630); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58630,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58630 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58630,'Mac','A64','WoW',0x045A964F3B8D153E273A3AD862C5C38A), -(58630,'Mac','A64','WoWC',0x3CDC1868FD7BB4E50629421328ED8269), -(58630,'Mac','x64','WoW',0x0D58880FA5FA7A7FD5C2466CEB398601), -(58630,'Mac','x64','WoWC',0x9745E7626C0D7D0A7F57DF1BB1EA4F16), -(58630,'Win','A64','WoW',0xF74A9CB9D6918780C813E2EEE0F24DE0), -(58630,'Win','x64','WoW',0x8C9CDCC711892EAAEA793DBBF3B0C850), -(58630,'Win','x64','WoWC',0xC6A3638E0BAB3A98F40B8371E1BDAECA); - -UPDATE `realmlist` SET `gamebuild`=58630 WHERE `gamebuild`=58608; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58630'; diff --git a/sql/updates/auth/master/2025_01_22_00_auth.sql b/sql/updates/auth/master/2025_01_22_00_auth.sql deleted file mode 100644 index ac1833fc9c9..00000000000 --- a/sql/updates/auth/master/2025_01_22_00_auth.sql +++ /dev/null @@ -1,21 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58680); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58680,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58680 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58680 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58680 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58680 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58680 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58680 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58680,'Mac','A64','WoW',0x5EE6ABE5386E08867F642B3DFD15A9D4), -(58680,'Mac','A64','WoWC',0x22C636BB4ABBC4AD9AE8F30B6D947774), -(58680,'Mac','x64','WoWC',0xA5FF81211CDCDD60B53C14F932732969), -(58680,'Win','A64','WoW',0x9D6DC8BED265C898836593A9E654A1E1), -(58680,'Win','x64','WoW',0xC1CEFF499F2C2ABF1913E55F65CF278C), -(58680,'Win','x64','WoWC',0x0D6FC77C1D3830AAA871A9E29DCBE380); - -UPDATE `realmlist` SET `gamebuild`=58680 WHERE `gamebuild`=58630; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58680'; diff --git a/sql/updates/auth/master/2025_01_29_00_auth.sql b/sql/updates/auth/master/2025_01_29_00_auth.sql deleted file mode 100644 index 36bb21c27ca..00000000000 --- a/sql/updates/auth/master/2025_01_29_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58773); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58773,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58773 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58773,'Mac','A64','WoW',0x52D40564B2DF8D1DC02AC698F3FCF9C1), -(58773,'Mac','A64','WoWC',0xF0EBD5EF23A71883AF137174E4B1B01A), -(58773,'Mac','x64','WoW',0xAC2A56DCB12639F43F15F43BA9A9F996), -(58773,'Mac','x64','WoWC',0x8431C2D85A026E13E3E114C7AE83F0DE), -(58773,'Win','A64','WoW',0x9ADF3B9E70DF0176CEC196480BA407A3), -(58773,'Win','x64','WoW',0x648474DEE9F16AF1C02BD63F7F3E9B01), -(58773,'Win','x64','WoWC',0x362C80C4498FFA1DE3CC0AF243E1337A); - -UPDATE `realmlist` SET `gamebuild`=58773 WHERE `gamebuild`=58680; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58773'; diff --git a/sql/updates/auth/master/2025_01_31_00_auth.sql b/sql/updates/auth/master/2025_01_31_00_auth.sql deleted file mode 100644 index d47b413c86c..00000000000 --- a/sql/updates/auth/master/2025_01_31_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58867); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58867,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58867 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58867,'Mac','A64','WoW',0x0BA2958770DFBFDB933851A4AADB4950), -(58867,'Mac','A64','WoWC',0x0D747A5931DF5B155B5CC4892D63E1D8), -(58867,'Mac','x64','WoW',0xA3696DF215AAB11F4F340C5C4393FB89), -(58867,'Mac','x64','WoWC',0xB7C65FC1DA519ED5304019262FEFEFA6), -(58867,'Win','A64','WoW',0xEF8C2258197FDBC6DA5C39699BDEB7A1), -(58867,'Win','x64','WoW',0x7C1627A7325C57FAD21A29D57BBF80A6), -(58867,'Win','x64','WoWC',0x3F8E07E581847B644D6F76489477540D); - -UPDATE `realmlist` SET `gamebuild`=58867 WHERE `gamebuild`=58773; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58867'; diff --git a/sql/updates/auth/master/2025_02_03_00_auth.sql b/sql/updates/auth/master/2025_02_03_00_auth.sql deleted file mode 100644 index 11a0c5f7f05..00000000000 --- a/sql/updates/auth/master/2025_02_03_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (58911); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(58911,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=58911 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(58911,'Mac','A64','WoW',0xDEE67D3A0C9D8EDD5A94C7BD8FA1E657), -(58911,'Mac','A64','WoWC',0x6D3C242B3C76686FEEE9B18444C113C7), -(58911,'Mac','x64','WoW',0x78D3576614AED3DE8FB8C90AFF838F3B), -(58911,'Mac','x64','WoWC',0xA4C80CDBC805A19FAB8EF1BAA483DB9A), -(58911,'Win','A64','WoW',0xF02130BA7BFF2C0292F25F3C6240B2E8), -(58911,'Win','x64','WoW',0x5EF341D9F5A27F796D5BD786A5BD5A16), -(58911,'Win','x64','WoWC',0xA9C0BEA1B7351665091E6754A0A90A16); - -UPDATE `realmlist` SET `gamebuild`=58911 WHERE `gamebuild`=58867; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '58911'; diff --git a/sql/updates/auth/master/2025_02_19_00_auth.sql b/sql/updates/auth/master/2025_02_19_00_auth.sql deleted file mode 100644 index 80667110427..00000000000 --- a/sql/updates/auth/master/2025_02_19_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59207); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59207,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59207 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59207,'Mac','A64','WoW',0x2EC5EAA28DA705573D808A7E911F5D00), -(59207,'Mac','A64','WoWC',0x23A35FDC661E9761FEAC93BF20A926EE), -(59207,'Mac','x64','WoW',0x9E2B97FF7DEA87E951DDE91A65C2595B), -(59207,'Mac','x64','WoWC',0x5FB60ADC82C68D1E50B70956BFBC77BC), -(59207,'Win','A64','WoW',0x41AF3D9F83318D4FC4406BF5C23B20AB), -(59207,'Win','x64','WoW',0x170FB48807771D186547DF96C59E5306), -(59207,'Win','x64','WoWC',0xA9038B171DE62AF741304A4C0F273814); - -UPDATE `realmlist` SET `gamebuild`=59207 WHERE `gamebuild`=58911; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59207'; diff --git a/sql/updates/auth/master/2025_02_21_00_auth.sql b/sql/updates/auth/master/2025_02_21_00_auth.sql deleted file mode 100644 index 7b62ffdee9b..00000000000 --- a/sql/updates/auth/master/2025_02_21_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59302); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59302,11,0,7,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59302 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59302,'Mac','A64','WoW',0x70A6BE00213BB70AB96C51280D72D186), -(59302,'Mac','A64','WoWC',0x6A5CFE0D3A4BDEC7D16D33E9ACA7D71D), -(59302,'Mac','x64','WoW',0x9FD959000AFAA2E5F10A4ABE33AC62BE), -(59302,'Mac','x64','WoWC',0xD39B478EFD342D568DCBC2E85FCA574D), -(59302,'Win','A64','WoW',0x60B1757CA707789C9ACD6F1FB69E28D5), -(59302,'Win','x64','WoW',0x330E4E7EF1E07DA8382C813650D7E7B5), -(59302,'Win','x64','WoWC',0xB5A0C54F6B334515E68260F6334E7593); - -UPDATE `realmlist` SET `gamebuild`=59302 WHERE `gamebuild`=59207; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59302'; diff --git a/sql/updates/auth/master/2025_03_02_00_auth.sql b/sql/updates/auth/master/2025_03_02_00_auth.sql deleted file mode 100644 index 0ebf84c7a8f..00000000000 --- a/sql/updates/auth/master/2025_03_02_00_auth.sql +++ /dev/null @@ -1,33 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59347,59425,59466); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59347,11,1,0,NULL), -(59425,11,1,0,NULL), -(59466,11,1,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build` IN (59347,59425,59466); -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59347,'Mac','A64','WoW',0xC7B81BB6F9207DA0CCEBFAC3186FC073), -(59347,'Mac','A64','WoWC',0xBAB986A50C7FDB89467AA5613A6BA345), -(59347,'Mac','x64','WoW',0x1A11343133BF1ABDBF0FF6B287B37C23), -(59347,'Mac','x64','WoWC',0x3A624C37EE150CC9B71CA3AD1F4532CF), -(59347,'Win','A64','WoW',0x80CAC49F6EA99AC68CA9B834466CA5DC), -(59347,'Win','x64','WoW',0x63228339538F9552D16855976C64848B), -(59347,'Win','x64','WoWC',0xBB45FAC562EB7CF3FC4C137C1AE93AF6), -(59425,'Mac','A64','WoW',0x14A01BEF9E9DB7C5A40438CE87E99B85), -(59425,'Mac','A64','WoWC',0x38B98DA1F8765C927C724CFE4E1D92C2), -(59425,'Mac','x64','WoW',0x9D230A7C010BA2E5B385CB4E24A59529), -(59425,'Mac','x64','WoWC',0xB0BF826891290E30173DCA5CF2B39F50), -(59425,'Win','A64','WoW',0xF40FED2615A2454E31B044B1AD564B7D), -(59425,'Win','x64','WoW',0x5FE3E3980A15A1D4ED64240BC0C6932D), -(59425,'Win','x64','WoWC',0xECA5DA344AF973B0D25AC1103FB694B8), -(59466,'Mac','A64','WoW',0xF6CB8EB7AB66F8909ADCA85052BFAE40), -(59466,'Mac','A64','WoWC',0x213104EC1BEF7656FC3930DCE4176184), -(59466,'Mac','x64','WoW',0x99075D27FF98A87368A08E87A3F105C3), -(59466,'Mac','x64','WoWC',0x516115232E1A8B3F1E3CA709F20EA84D), -(59466,'Win','A64','WoW',0x04F0986C0EAD648F8C7B27736A30088A), -(59466,'Win','x64','WoW',0x118FFD674F5B51C277F5C8505E9479D3), -(59466,'Win','x64','WoWC',0xC299CB416E332E4BBE5AA1AAE905A437); - -UPDATE `realmlist` SET `gamebuild`=59466 WHERE `gamebuild` IN (59302,59347,59425); - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59466'; diff --git a/sql/updates/auth/master/2025_03_04_00_auth.sql b/sql/updates/auth/master/2025_03_04_00_auth.sql deleted file mode 100644 index 28cb2180db8..00000000000 --- a/sql/updates/auth/master/2025_03_04_00_auth.sql +++ /dev/null @@ -1,12 +0,0 @@ --- --- Table structure for table `battlenet_account_warband_scenes` --- -DROP TABLE IF EXISTS `battlenet_account_warband_scenes`; -CREATE TABLE `battlenet_account_warband_scenes` ( - `battlenetAccountId` int unsigned NOT NULL, - `warbandSceneId` int NOT NULL DEFAULT '0', - `isFavorite` tinyint(1) DEFAULT '0', - `hasFanfare` tinyint(1) DEFAULT '0', - PRIMARY KEY (`battlenetAccountId`,`warbandSceneId`), - CONSTRAINT `fk_battlenet_account_warband_scenes__accountId` FOREIGN KEY (`battlenetAccountId`) REFERENCES `battlenet_accounts` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; diff --git a/sql/updates/auth/master/2025_03_05_00_auth.sql b/sql/updates/auth/master/2025_03_05_00_auth.sql deleted file mode 100644 index 29256009a3f..00000000000 --- a/sql/updates/auth/master/2025_03_05_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59538); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59538,11,1,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59538 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59538,'Mac','A64','WoW',0x1DDC6F14195D1F85B7026AEDCCFE2875), -(59538,'Mac','A64','WoWC',0xE34E2419F557FA85EE5D026CB1BC6246), -(59538,'Mac','x64','WoW',0xCBC396C3E20090798DF9CF8B67DCDBEE), -(59538,'Mac','x64','WoWC',0x73DDA3618C8D13A0DAA79C2007B894DD), -(59538,'Win','A64','WoW',0x498203B085106FA1A039A8B5E55DD31C), -(59538,'Win','x64','WoW',0x72B905CC388F523E1A30FBF23DA0C9AB), -(59538,'Win','x64','WoWC',0xA198A8FF303007EAC43B74AA90489BBC); - -UPDATE `realmlist` SET `gamebuild`=59538 WHERE `gamebuild`=59466; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59538'; diff --git a/sql/updates/auth/master/2025_03_08_00_auth.sql b/sql/updates/auth/master/2025_03_08_00_auth.sql deleted file mode 100644 index 95abf788609..00000000000 --- a/sql/updates/auth/master/2025_03_08_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59570); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59570,11,1,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59570 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59570,'Mac','A64','WoW',0x6318C6C300367C8E114042584DA7F82C), -(59570,'Mac','A64','WoWC',0x6F1554122133FA8F4EE189022CFFD122), -(59570,'Mac','x64','WoW',0x13968B08B91BD4A922C3340A77E30C87), -(59570,'Mac','x64','WoWC',0x29D0C5C6E3F8408D064EA76930EE92E7), -(59570,'Win','A64','WoW',0x1ED3EA5DBEF495E4A01AE989E8F44CD8), -(59570,'Win','x64','WoW',0x7571E0C3459C7F9BFDC64BF5AF035F08), -(59570,'Win','x64','WoWC',0xC5CA2210F4E39657EE415FCAA53D4B23); - -UPDATE `realmlist` SET `gamebuild`=59570 WHERE `gamebuild`=59538; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59570'; diff --git a/sql/updates/auth/master/2025_03_13_00_auth.sql b/sql/updates/auth/master/2025_03_13_00_auth.sql deleted file mode 100644 index 564fb67961c..00000000000 --- a/sql/updates/auth/master/2025_03_13_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59679); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59679,11,1,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59679 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59679,'Mac','A64','WoW',0x721E18C6BB25D4878A91801985A0D18F), -(59679,'Mac','A64','WoWC',0x45CB8600B7404B46B032183CCE4B340A), -(59679,'Mac','x64','WoW',0x2E3CD97FD83976BB7D56D3489CE40D79), -(59679,'Mac','x64','WoWC',0x4D28DE9F333624311D3150F871C472EF), -(59679,'Win','A64','WoW',0xE4435EE6E4968B5106E6596B60EE2DB6), -(59679,'Win','x64','WoW',0x54E4C53C5DC1930794DE4D1DD0365FE2), -(59679,'Win','x64','WoWC',0xB23BFD99EBCD872EA39230E1AABCD19B); - -UPDATE `realmlist` SET `gamebuild`=59679 WHERE `gamebuild`=59570; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59679'; diff --git a/sql/updates/auth/master/2025_03_26_00_auth.sql b/sql/updates/auth/master/2025_03_26_00_auth.sql deleted file mode 100644 index 3507f60de65..00000000000 --- a/sql/updates/auth/master/2025_03_26_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (59888); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(59888,11,1,0,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=59888 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(59888,'Mac','A64','WoW',0xB64283161581FFC8D5FA9D5EF2689C1D), -(59888,'Mac','A64','WoWC',0xB9E0C8C20A63C3B7EA8037A6968C1305), -(59888,'Mac','x64','WoW',0x92D62F3B10B01DF8A6FF042BE8567D19), -(59888,'Mac','x64','WoWC',0xB0F4010BAF63ECC5E798BC49827016E9), -(59888,'Win','A64','WoW',0x7BC71337460CB90B26FEBEC9FC14B553), -(59888,'Win','x64','WoW',0x17B6A2C47452572A8EBF9200C1CA1C92), -(59888,'Win','x64','WoWC',0x709AD6F51891994D41CBA1F49F812123); - -UPDATE `realmlist` SET `gamebuild`=59888 WHERE `gamebuild`=59679; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '59888'; diff --git a/sql/updates/auth/master/2024_12_22_00_auth.sql b/sql/updates/auth/master/2025_03_29_00_auth.sql index a43db5fca0b..278195aa147 100644 --- a/sql/updates/auth/master/2024_12_22_00_auth.sql +++ b/sql/updates/auth/master/2025_03_29_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 1107.24121 auth +-- TDB 1110.25031 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED'); |
