diff options
Diffstat (limited to 'sql/updates/auth')
| -rw-r--r-- | sql/updates/auth/master/2024_09_05_00_auth.sql | 9 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_09_05_01_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_09_11_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_09_18_00_auth.sql | 23 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_09_18_01_auth.sql | 21 | ||||
| -rw-r--r-- | sql/updates/auth/master/2024_09_23_00_auth.sql (renamed from sql/updates/auth/master/2024_09_03_00_auth.sql) | 2 |
6 files changed, 1 insertions, 100 deletions
diff --git a/sql/updates/auth/master/2024_09_05_00_auth.sql b/sql/updates/auth/master/2024_09_05_00_auth.sql deleted file mode 100644 index 5008d467ab1..00000000000 --- a/sql/updates/auth/master/2024_09_05_00_auth.sql +++ /dev/null @@ -1,9 +0,0 @@ -DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56421,'Mac','A64','WoWC',0x629666D6D9EFFE4B73C1EDD74638DEAA), -(56421,'Mac','x64','WoWC',0x4B61E4F4F3B220FF5B48A6988F0FFB42), -(56421,'Mac','x64','WoW',0x4F0FCD1113F783C484BF45C98327DE62), -(56421,'Win','A64','WoW',0x178888C71560707CC9C1C1D6B45B4838); diff --git a/sql/updates/auth/master/2024_09_05_01_auth.sql b/sql/updates/auth/master/2024_09_05_01_auth.sql deleted file mode 100644 index d8db68e7325..00000000000 --- a/sql/updates/auth/master/2024_09_05_01_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56461); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(56461,11,0,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56461 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56461,'Mac','A64','WoW',0xE51FE6EAE45322991916F619481DB0B1), -(56461,'Mac','A64','WoWC',0x85447CD695C2DC2F618B23996B4A503C), -(56461,'Mac','x64','WoW',0xE26878DF3437782F6E93E833B4CD843A), -(56461,'Mac','x64','WoWC',0x8B60B0DDD55907673FD1C11EDAE58859), -(56461,'Win','A64','WoW',0x2F862AB724092B99C8A1F6A7B53F6A9D), -(56461,'Win','x64','WoW',0x153CD89E30C4D5C3DBE603EECB470FB4), -(56461,'Win','x64','WoWC',0x79BD4C88012F0DA42605D76A153722CC); - -UPDATE `realmlist` SET `gamebuild`=56461 WHERE `gamebuild`=56421; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56461'; diff --git a/sql/updates/auth/master/2024_09_11_00_auth.sql b/sql/updates/auth/master/2024_09_11_00_auth.sql deleted file mode 100644 index c69af833d34..00000000000 --- a/sql/updates/auth/master/2024_09_11_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56513); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(56513,11,0,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56513 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56513,'Mac','A64','WoW',0xC7E757E0DE67619251F942B6C98A53B7), -(56513,'Mac','A64','WoWC',0x3CC0640E46D557C4D9A6250AA8D5B387), -(56513,'Mac','x64','WoW',0xD1443824E37B73CB1FD993CE2DFAA098), -(56513,'Mac','x64','WoWC',0xEAD9A0B761C4C9C812FAD54CE0D96B46), -(56513,'Win','A64','WoW',0x753468F753E8D3841B5D6B061E300501), -(56513,'Win','x64','WoW',0x9BD8D105049CC6459FE32EC7099AB60E), -(56513,'Win','x64','WoWC',0xBB5A35C2EB6E2026FFE01202FDEBD6E9); - -UPDATE `realmlist` SET `gamebuild`=56513 WHERE `gamebuild`=56461; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56513'; diff --git a/sql/updates/auth/master/2024_09_18_00_auth.sql b/sql/updates/auth/master/2024_09_18_00_auth.sql deleted file mode 100644 index 951d4b5ccc1..00000000000 --- a/sql/updates/auth/master/2024_09_18_00_auth.sql +++ /dev/null @@ -1,23 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56625); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(56625,11,0,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56625 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56625,'Mac','A64','WoW',0xC7AD97B9970260D0BDE7AA03EEF87E2D), -(56625,'Mac','A64','WoWC',0xDEBDB4589756730F5EF60B337226E515), -(56625,'Mac','x64','WoW',0xEB5665FDC81E3538944BA82E435A53E6), -(56625,'Mac','x64','WoWC',0xAA5B3910A3D13C89F3D9467058080836), -(56625,'Win','A64','WoW',0x684153873E5023671685B270DA879668), -(56625,'Win','x64','WoW',0x80859C23C3E7F827829D47A08A1B8C92), -(56625,'Win','x64','WoWC',0x606914ED212277FDDBBAE49BE6E8CCAF); - -UPDATE `realmlist` SET `gamebuild`=56625 WHERE `gamebuild`=56513; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56625'; diff --git a/sql/updates/auth/master/2024_09_18_01_auth.sql b/sql/updates/auth/master/2024_09_18_01_auth.sql deleted file mode 100644 index 4df91310654..00000000000 --- a/sql/updates/auth/master/2024_09_18_01_auth.sql +++ /dev/null @@ -1,21 +0,0 @@ -DELETE FROM `build_info` WHERE `build` IN (56647); -INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES -(56647,11,0,2,NULL); - -DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Mac' AND `arch`='A64' AND `type`='WoWC'; -DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Mac' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Win' AND `arch`='A64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW'; -DELETE FROM `build_auth_key` WHERE `build`=56647 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC'; -INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES -(56647,'Mac','A64','WoW',0x1911B50FA20E5DEF8C1E5D3C7479E4E2), -(56647,'Mac','A64','WoWC',0xF0F2BEC3DE590AE7A59CCFDB42201D5F), -(56647,'Mac','x64','WoW',0x022A06825C7CF55528A5ED03E87D6AE4), -(56647,'Win','A64','WoW',0x0F36C48D68E358598318F0B30FDFCB61), -(56647,'Win','x64','WoW',0x2E9C456B66C0D5CAD601E8FD7A2FEA7A), -(56647,'Win','x64','WoWC',0x543A69AB802D0873D84AB08DEC4D8CAC); - -UPDATE `realmlist` SET `gamebuild`=56647 WHERE `gamebuild`=56625; - -ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56647'; diff --git a/sql/updates/auth/master/2024_09_03_00_auth.sql b/sql/updates/auth/master/2024_09_23_00_auth.sql index f953e7436c4..c4d4e867cdd 100644 --- a/sql/updates/auth/master/2024_09_03_00_auth.sql +++ b/sql/updates/auth/master/2024_09_23_00_auth.sql @@ -1,3 +1,3 @@ --- TDB 1102.24091 auth +-- TDB 1102.24092 auth UPDATE `updates` SET `state`='ARCHIVED',`speed`=0; REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/11.x/auth', 'ARCHIVED'); |
