TDB 1102.24091 - 2024/09/03TDB1102.24091

30 files changed, 243 insertions, 0 deletions

diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_11_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_11_00_auth.sql
new file mode 100644
index 00000000000..56939041955
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_11_00_auth.sql
@@ -0,0 +1,3 @@
+-- TDB 1027.24051 auth
+UPDATE `updates` SET `state`='ARCHIVED',`speed`=0;
+REPLACE INTO `updates_include` (`path`, `state`) VALUES ('$/sql/old/10.x/auth', 'ARCHIVED');
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_14_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_14_00_auth.sql
new file mode 100644
index 00000000000..523b4936441
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_14_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54673;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54673,10,2,7,NULL,NULL,'AF8B9C8A9C6128498E85228B965A004D',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54673 WHERE `gamebuild`=54630;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54673';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_16_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_16_00_auth.sql
new file mode 100644
index 00000000000..b5af834da50
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_16_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54717;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54717,10,2,7,NULL,NULL,'862BBA15158DFF6B56BCF71C1B34D41A',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54717 WHERE `gamebuild`=54673;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54717';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_17_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_17_00_auth.sql
new file mode 100644
index 00000000000..0371880c8f1
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_17_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54736;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54736,10,2,7,NULL,NULL,'FE58F039D91E1C248886A2828127CA2F',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54736 WHERE `gamebuild`=54717;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54736';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_18_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_18_00_auth.sql
new file mode 100644
index 00000000000..3813e329a32
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_18_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54762;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54762,10,2,7,NULL,NULL,'5F7FDA560030255445B713456A286CFA',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54762 WHERE `gamebuild`=54736;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54762';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_25_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_25_00_auth.sql
new file mode 100644
index 00000000000..3adcd287ac5
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_25_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54847;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54847,10,2,7,NULL,NULL,'32FDA0353160EC51EB36195CFACEF2B7',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54847 WHERE `gamebuild`=54762;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54847';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_05_29_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_05_29_00_auth.sql
new file mode 100644
index 00000000000..f109a911d08
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_05_29_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54904;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54904,10,2,7,NULL,NULL,'09CBEC3C0DEA28BCA79F1FD9B879B0E3',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54904 WHERE `gamebuild`=54847;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54904';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_06_05_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_06_05_00_auth.sql
new file mode 100644
index 00000000000..8253cf61bf1
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_06_05_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=54988;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(54988,10,2,7,NULL,NULL,'8F2791553226871977B4F9D7F1137311',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=54988 WHERE `gamebuild`=54904;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '54988';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_06_15_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_06_15_00_auth.sql
new file mode 100644
index 00000000000..b5da79cc175
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_06_15_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=55142;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55142,10,2,7,NULL,NULL,'298B99B5AD67EA3D2AB4B3E07A415305',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55142 WHERE `gamebuild`=54988;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55142';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_06_17_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_06_17_00_auth.sql
new file mode 100644
index 00000000000..3b61aea689e
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_06_17_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=55165;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55165,10,2,7,NULL,NULL,'26D4D1C01434A8A6723DCABC944B6FD0',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55165 WHERE `gamebuild`=55142;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55165';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_06_26_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_06_26_00_auth.sql
new file mode 100644
index 00000000000..8013cb78ded
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_06_26_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=55261;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55261,10,2,7,NULL,NULL,'84E153A3DD1F8249274B91047AAC7AED',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55261 WHERE `gamebuild`=55165;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55261';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_07_09_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_07_09_00_auth.sql
new file mode 100644
index 00000000000..dbccdaf9a19
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_07_09_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=55461;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55461,10,2,7,NULL,NULL,'C4522674F854EFECC76C898EC9545099',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55461 WHERE `gamebuild`=55261;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55461';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_07_16_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_07_16_00_auth.sql
new file mode 100644
index 00000000000..909c56952c7
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_07_16_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build`=55664;
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55664,10,2,7,NULL,NULL,'DBCA58486FAAA0FE54EA287A3047E923',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55664 WHERE `gamebuild`=55461;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55664';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_02_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_02_00_auth.sql
new file mode 100644
index 00000000000..dae8b80cfb4
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_02_00_auth.sql
@@ -0,0 +1,14 @@
+DELETE FROM `build_info` WHERE `build` IN (55666,55792,55793,55818,55824,55846,55933,55939);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55666,11,0,0,NULL,NULL,'F7E5A88E4D3615B652C8B9D76E7F617C',NULL,NULL,NULL),
+(55792,11,0,0,NULL,NULL,'C4DECDAA44BC548FF09EF3BB837D2147',NULL,NULL,NULL),
+(55793,11,0,0,NULL,NULL,'F9CF3232AD1C38C2028668D5BB64198F',NULL,NULL,NULL),
+(55818,11,0,0,NULL,NULL,'903A9B546248F71B16D9D9B06A072C24',NULL,NULL,NULL),
+(55824,11,0,0,NULL,NULL,'8A6F13269A2896067A1E88789FB41BA7',NULL,NULL,NULL),
+(55846,11,0,0,NULL,NULL,'BB5E1BED705872C226834B95A9E9F8A9',NULL,NULL,NULL),
+(55933,11,0,0,NULL,NULL,'C34D42CB351C400D1319D221197CF18D',NULL,NULL,NULL),
+(55939,11,0,0,NULL,NULL,'91529F4CE41DE4E54E132660ACDCADC5',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55939 WHERE `gamebuild`=55664;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55939';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_07_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_07_00_auth.sql
new file mode 100644
index 00000000000..8f80b1172e1
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_07_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (55960);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55960,11,0,0,NULL,NULL,'078C056CFC7B371BDE1BAF308E6C19AF',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=55960 WHERE `gamebuild`=55939;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '55960';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_09_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_09_00_auth.sql
new file mode 100644
index 00000000000..3193492d5cd
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_09_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56008);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56008,11,0,0,NULL,NULL,'00FCD6BFFCCCBA7A8E71E307EA6EBD0C',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56008 WHERE `gamebuild`=55960;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56008';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_15_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_15_00_auth.sql
new file mode 100644
index 00000000000..3a50b6b5935
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_15_00_auth.sql
@@ -0,0 +1,8 @@
+DELETE FROM `build_info` WHERE `build` IN (55959,56110);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(55959,11,0,2,NULL,NULL,'ED57E0538FD1CE99B171BE34823148A9',NULL,NULL,NULL),
+(56110,11,0,2,NULL,NULL,'800BCA228E2FAE37ED160F3C09E21F3A',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56110 WHERE `gamebuild`=56008;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56110';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_17_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_17_00_auth.sql
new file mode 100644
index 00000000000..1cdc5e0c0b3
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_17_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56162);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56162,11,0,2,NULL,NULL,'6F5C93BA436665A94DB67CE5361D4EA8',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56162 WHERE `gamebuild`=56110;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56162';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_18_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_18_00_auth.sql
new file mode 100644
index 00000000000..641e0d3d181
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_18_00_auth.sql
@@ -0,0 +1 @@
+ALTER TABLE `account` ADD `client_build` int unsigned NOT NULL DEFAULT '0' AFTER `muteby`;
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_21_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_21_00_auth.sql
new file mode 100644
index 00000000000..24b8e1ab712
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_21_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56196);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56196,11,0,2,NULL,NULL,'81FC14274BFF0347FFF9C8B1AA6BED9B',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56196 WHERE `gamebuild`=56162;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56196';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_22_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_22_00_auth.sql
new file mode 100644
index 00000000000..98264daf120
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_22_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56263);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56263,11,0,2,NULL,NULL,'EA8472C99236CC617BF518A924014D56',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56263 WHERE `gamebuild`=56196;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56263';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_23_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_23_00_auth.sql
new file mode 100644
index 00000000000..015d9c1498b
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_23_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56288);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56288,11,0,2,NULL,NULL,'03544E35D0480938E5C1238B3A26BDDD',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56288 WHERE `gamebuild`=56263;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56288';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_23_01_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_23_01_auth.sql
new file mode 100644
index 00000000000..da703936511
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_23_01_auth.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `account` MODIFY `expansion` tinyint unsigned NOT NULL DEFAULT 10;
+
+UPDATE `account` SET `expansion`=10 WHERE `expansion`=9;
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_24_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_24_00_auth.sql
new file mode 100644
index 00000000000..b7338a1a6b1
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_24_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56311);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56311,11,0,2,NULL,NULL,'AC6415575AEE4D32735FFAD0C57226B2',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56311 WHERE `gamebuild`=56288;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56311';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_28_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_28_00_auth.sql
new file mode 100644
index 00000000000..5ef652ec2e4
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_28_00_auth.sql
@@ -0,0 +1,7 @@
+DELETE FROM `build_info` WHERE `build` IN (56313);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(56313,11,0,2,NULL,NULL,'EAF769009A9AD3B1AA0414E1C344074B',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=56313 WHERE `gamebuild`=56311;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56313';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_28_01_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_28_01_auth.sql
new file mode 100644
index 00000000000..7e547d9cc4a
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_28_01_auth.sql
@@ -0,0 +1,6 @@
+ALTER TABLE `build_info` ADD `macArmAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL AFTER `mac64AuthSeed`;
+
+UPDATE `build_info` SET `macArmAuthSeed`='778F6A5DF79A4EF1B86F651F3B303CE7' WHERE `build`=56196;
+UPDATE `build_info` SET `macArmAuthSeed`='41710C793EF021721F14B06EC1896D3F' WHERE `build`=56288;
+UPDATE `build_info` SET `macArmAuthSeed`='412D3200715AAFDC0522DF031A941F0E' WHERE `build`=56311;
+UPDATE `build_info` SET `macArmAuthSeed`='A83ED19EE659BC95CC322D1E49BDEDBB' WHERE `build`=56313;
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_30_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_30_00_auth.sql
new file mode 100644
index 00000000000..2b36c28a3cf
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_30_00_auth.sql
@@ -0,0 +1,39 @@
+--
+-- Table structure for table `build_auth_key`
+--
+DROP TABLE IF EXISTS `build_auth_key`;
+CREATE TABLE `build_auth_key` (
+  `build` int NOT NULL,
+  `platform` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
+  `arch` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
+  `type` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
+  `key` binary(16) NOT NULL,
+  PRIMARY KEY (`build`,`platform`,`arch`,`type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+--
+-- Table structure for table `build_executable_hash`
+--
+DROP TABLE IF EXISTS `build_executable_hash`;
+CREATE TABLE `build_executable_hash` (
+  `build` int NOT NULL,
+  `platform` char(4) CHARACTER SET ascii COLLATE ascii_bin NOT NULL,
+  `executableHash` binary(20) NOT NULL,
+  PRIMARY KEY (`build`,`platform`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
+INSERT INTO `build_auth_key` SELECT `build`,'Win','x86','WoW',UNHEX(`winAuthSeed`) FROM `build_info` WHERE LENGTH(`winAuthSeed`)=32;
+INSERT INTO `build_auth_key` SELECT `build`,'Win','x64','WoW',UNHEX(`win64AuthSeed`) FROM `build_info` WHERE LENGTH(`win64AuthSeed`)=32;
+INSERT INTO `build_auth_key` SELECT `build`,'Mac','x64','WoW',UNHEX(`mac64AuthSeed`) FROM `build_info` WHERE LENGTH(`mac64AuthSeed`)=32;
+INSERT INTO `build_auth_key` SELECT `build`,'Mac','A64','WoW',UNHEX(`macArmAuthSeed`) FROM `build_info` WHERE LENGTH(`macArmAuthSeed`)=32;
+
+INSERT INTO `build_executable_hash` SELECT `build`,'Win',UNHEX(`winChecksumSeed`) FROM `build_info` WHERE LENGTH(`winChecksumSeed`)=40;
+INSERT INTO `build_executable_hash` SELECT `build`,'OSX',UNHEX(`macChecksumSeed`) FROM `build_info` WHERE LENGTH(`macChecksumSeed`)=40;
+
+ALTER TABLE `build_info`
+  DROP `winAuthSeed`,
+  DROP `win64AuthSeed`,
+  DROP `mac64AuthSeed`,
+  DROP `macArmAuthSeed`,
+  DROP `winChecksumSeed`,
+  DROP `macChecksumSeed`;
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_30_01_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_30_01_auth.sql
new file mode 100644
index 00000000000..59e78161528
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_30_01_auth.sql
@@ -0,0 +1,14 @@
+DELETE FROM `build_info` WHERE `build` IN (56380,56382);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(56380,11,0,2,NULL),
+(56382,11,0,2,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=56380 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56380 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+DELETE FROM `build_auth_key` WHERE `build`=56382 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56382 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(56380,'Win','x64','WoW',0xD081784493233E2869933FCC01F1A3C1),
+(56380,'Win','x64','WoWC',0x4FB3D72D89F5FF01DD7F4E028494A4E6),
+(56382,'Win','x64','WoW',0x67C36A3EF655534C58AD50942192BFDA),
+(56382,'Win','x64','WoWC',0xA5BD7A1C33039F58CD45CD5C7EBDF122);
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_31_00_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_31_00_auth.sql
new file mode 100644
index 00000000000..6d44f1b1d2e
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_31_00_auth.sql
@@ -0,0 +1,13 @@
+DELETE FROM `build_info` WHERE `build` IN (56421);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES
+(56421,11,0,2,NULL);
+
+DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Win' AND `arch`='x64' AND `type`='WoW';
+DELETE FROM `build_auth_key` WHERE `build`=56421 AND `platform`='Win' AND `arch`='x64' AND `type`='WoWC';
+INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES
+(56421,'Win','x64','WoW',0x3BDFA9AA4B70041F2C8B8CDE3C8DC255),
+(56421,'Win','x64','WoWC',0x0DDB8F8738647F3CD8FD585A3A78ED1B);
+
+UPDATE `realmlist` SET `gamebuild`=56421 WHERE `gamebuild`=56313;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '56421';
diff --git a/sql/old/11.x/auth/24051_2024_09_03/2024_08_31_01_auth.sql b/sql/old/11.x/auth/24051_2024_09_03/2024_08_31_01_auth.sql
new file mode 100644
index 00000000000..40000076bbe
--- /dev/null
+++ b/sql/old/11.x/auth/24051_2024_09_03/2024_08_31_01_auth.sql
@@ -0,0 +1,2 @@
+DELETE FROM build_auth_key WHERE `build` = 56421 AND `platform` = 'Mac' AND `arch` = 'A64' AND `type`='WoW';
+INSERT INTO build_auth_key VALUES (56421, 'Mac', 'A64', 'WoW', 0x5892FFABAEFDCECB0CFFAAA55D2F9B13);