Core/Client Builds: Refactor build_info structure to support any client variants

(cherry picked from commit e94558d07892a98d78bec3633e0c82e1394b9d66)

# Conflicts:
#	sql/base/auth_database.sql
#	sql/updates/auth/cata_classic/2024_08_30_00_auth.sql

4 files changed, 683 insertions, 297 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 55e7bb77b32..b075e994174 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -498,6 +498,278 @@ LOCK TABLES `battlenet_item_favorite_appearances` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `build_auth_key`
+--
+
+DROP TABLE IF EXISTS `build_auth_key`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `build_auth_key`
+--
+
+LOCK TABLES `build_auth_key` WRITE;
+/*!40000 ALTER TABLE `build_auth_key` DISABLE KEYS */;
+INSERT INTO `build_auth_key` VALUES 
+(25549,'Mac','x64','WoW',0x66fc5e09b8706126795f140308c8c1d8),
+(25549,'Win','x64','WoW',0x1252624ed8cbd6fac7d33f5d67a535f3),
+(25549,'Win','x86','WoW',0xfe594fc35e7f9aff86d99d8a364ab297),
+(25996,'Mac','x64','WoW',0x210b970149d6f56cac9badf2aac91e8e),
+(25996,'Win','x64','WoW',0xc7ff932d6a2174a3d538ca7212136d2b),
+(25996,'Win','x86','WoW',0x23c59c5963cbef5b728d13a50878dfcb),
+(26124,'Mac','x64','WoW',0xc9ca997ab8ede1c65465cb2920869c4e),
+(26124,'Win','x64','WoW',0x46df06d0147ba67ba49af553435e093f),
+(26124,'Win','x86','WoW',0xf8c05ae372deca1d6c81da7a8d1c5c39),
+(26365,'Mac','x64','WoW',0xdbe7f860276d6b400aaa86b35d51a417),
+(26365,'Win','x64','WoW',0x59a53f307288454b419b13e694df503c),
+(26365,'Win','x86','WoW',0x2aac82c80e829e2ca902d70cfa1a833a),
+(26654,'Mac','x64','WoW',0x9234c1bd5e9687adbd19f764f2e0e811),
+(26654,'Win','x64','WoW',0xa752640e8b99fe5b57c1320bc492895a),
+(26654,'Win','x86','WoW',0xfac2d693e702b9ec9f750f17245696d8),
+(26822,'Mac','x64','WoW',0x91003668c245d14ecd8df094e065e06b),
+(26822,'Win','x64','WoW',0x2b05f6d746c0c6cc7ef79450b309e595),
+(26822,'Win','x86','WoW',0x283e8d77ecf7060be6347be4eb99c7c7),
+(26899,'Mac','x64','WoW',0x8368efc2021329110a16339d298200d4),
+(26899,'Win','x64','WoW',0x3551ef0028b51e92170559bd25644b03),
+(26899,'Win','x86','WoW',0xf462cd2fe4ea3eadf875308fdbb18c99),
+(26972,'Mac','x64','WoW',0x341cfefe3d72aca9a4407dc535ded66a),
+(26972,'Win','x64','WoW',0x6e212def6a0124a3d9ad07f5e322f7ae),
+(26972,'Win','x86','WoW',0x797ecc19662dcbd5090a4481173f1d26),
+(28153,'Win','x64','WoW',0xdd626517cc6d31932b479934ccdc0abf),
+(30706,'Win','x64','WoW',0xbb6d9866fe4a19a568015198783003fc),
+(30993,'Win','x64','WoW',0x2bad61655abc2fc3d04893b536403a91),
+(31229,'Win','x64','WoW',0x8a46f23670309f2aae85c9a47276382b),
+(31429,'Win','x64','WoW',0x7795a507af9dc3525eff724fee17e70c),
+(31478,'Win','x64','WoW',0x7973a8d54bdb8b798d9297b096e771ef),
+(32305,'Win','x64','WoW',0x21f5a6fc7ad89fbf411fda8b8738186a),
+(32494,'Win','x64','WoW',0x58984ace04919401835c61309a848f8a),
+(32580,'Win','x64','WoW',0x87c2faa0d7931bf016299025c0ddca14),
+(32638,'Win','x64','WoW',0x5d07ece7d4a867ddde615dad22b76d4e),
+(32722,'Win','x64','WoW',0x1a09be1d38a122586b4931beccead4aa),
+(32750,'Mac','x64','WoW',0xef1f4e4d099ea2a81fd4c0debc1e7086),
+(32750,'Win','x64','WoW',0xc5cb669f5a5b237d1355430877173207),
+(32978,'Mac','x64','WoW',0x1852c1f847e795d6eb45278cd433f339),
+(32978,'Win','x64','WoW',0x76ae2ea03e525d97f5688843f5489000),
+(33369,'Mac','x64','WoW',0xf5a849c70a1054f07ea3ab833ebf6671),
+(33369,'Win','x64','WoW',0x5986ac18b04d3c403f56a0cf8c4f0a14),
+(33528,'Win','x64','WoW',0x0ece033ca9b11d92f7d2792c785b47df),
+(33724,'Win','x64','WoW',0x38f7bbcf284939dd20e8c64cdbf9fe77),
+(33775,'Mac','x64','WoW',0x354d2de619d124ee1398f76b0436fcfc),
+(33775,'Win','x64','WoW',0xb826300a8449ed0f6ef16ea747fa2d2e),
+(33941,'Win','x64','WoW',0x88af1a36d2770d0a6ca086497096a889),
+(34220,'Win','x64','WoW',0xb5e35b976c6baf82505700e7d9666a2c),
+(34601,'Win','x64','WoW',0x0d7df38f725faba4f009257799a10563),
+(34769,'Win','x64','WoW',0x93f9b9af6397e3e4eed94d36d16907d2),
+(34963,'Mac','x64','WoW',0xc5658a17e702163447baaae46d130a1b),
+(34963,'Win','x64','WoW',0x7ba50c879c5d04221423b02ac3603a11),
+(35249,'Win','x64','WoW',0xc7b11f9ae9ff1409f5582902b3d10d1c),
+(35284,'Mac','x64','WoW',0xa6201b0ac5a73d13ab2fdcc79bb252af),
+(35284,'Win','x64','WoW',0xea3818e7dcfd2009dbfc83ee3c1e4f1b),
+(35435,'Mac','x64','WoW',0x8fe657c14a46bcdb2ce6da37e430450e),
+(35435,'Win','x64','WoW',0xbb397a92fe23740ea52fc2b5ba2ec8e0),
+(35662,'Mac','x64','WoW',0x5966016c368ed9f7aab603ee6703081c),
+(35662,'Win','x64','WoW',0x578bc94870c278cb6962f30e6dc203bb),
+(36753,'Win','x64','WoW',0x386fde8559b5ead67b791b490b200b88),
+(36839,'Win','x64','WoW',0x356eb4412b8efcf72e3af50d5181d529),
+(36949,'Win','x64','WoW',0x51c074cd8a09a75384b9b44188c56981),
+(37142,'Win','x64','WoW',0x5d9cfb3139f0d1b6c2b304261f9eabc9),
+(37176,'Win','x64','WoW',0x3c725ea504ec3daed143eb6ff3b48cda),
+(37474,'Mac','x64','WoW',0x024c9be7e44237b7e81c6d42e678d433),
+(37474,'Win','x64','WoW',0x0de685bbb0551086e7fbdc0b4bb06a5b),
+(38134,'Win','x64','WoW',0x32275ed0f13b357c28bdb0e611ef9e31),
+(38556,'Win','x64','WoW',0xec7d5af64364ac3e7181f3fba1b3a882),
+(39653,'Win','x64','WoW',0x10d015ab1eeb91310428d9c57ee24632),
+(39804,'Win','x64','WoW',0xe42d2bba12ed260a76f9b1e477e19ea5),
+(40000,'Win','x64','WoW',0x4cb1433ab637f09f03fbbd1b221b04b0),
+(40120,'Mac','x64','WoW',0x853f0f2985ceaed46df422583cd07a7c),
+(40120,'Win','x64','WoW',0x04f47eaefd8bdefe14aa0350ea336678),
+(40443,'Win','x64','WoW',0x8597bb43e8ab38c85504e8bfb72abbf5),
+(40593,'Win','x64','WoW',0xba14570f2d62d5f61953394164a8dae2),
+(40725,'Win','x64','WoW',0xc1ebdbeb9bb2956ebccef7c9d27a1b3b),
+(40906,'Win','x64','WoW',0xf5fc259c8635488afe0d0cd023f361d4),
+(40944,'Win','x64','WoW',0x368fc7fabaf487a8a049c11970657074),
+(40966,'Win','x64','WoW',0xd90f47af21f381d2d8f3763b994bac88),
+(41031,'Win','x64','WoW',0x019a0facd6b0d6374b7ba69a5b677449),
+(41079,'Win','x64','WoW',0xf8853cf823bc0bbe8a9677a762dfaee1),
+(41288,'Win','x64','WoW',0x871c0c9691dbc536eb24b68ec73fad5b),
+(41323,'Win','x64','WoW',0xe53d0df1fac1a59a1c8071b295a04a1d),
+(41359,'Win','x64','WoW',0x5f8d7f2a690a4375a1b52a28d6d681fa),
+(41488,'Win','x64','WoW',0x1bc91ec368705815f3f532b553dad981),
+(41793,'Win','x64','WoW',0xb3b47da3b7615570742a55b96614ee1c),
+(42010,'Win','x64','WoW',0x302970161d16417b5be553cc530e011a),
+(42423,'Win','x64','WoW',0x0b03614a7e94dd57548596be420e9dc2),
+(42488,'Win','x64','WoW',0xa78755e6928d83a271c5d1ee3cdb6f15),
+(42521,'Win','x64','WoW',0x5fe6c12fc407c6b15b4a5d3b5b4a5d3b),
+(42538,'Win','x64','WoW',0x71a7504bd53f8de518f24265d37310ae),
+(42560,'Win','x64','WoW',0x115fe8c38a8d67ca4664bb192e0f0dfe),
+(42614,'Win','x64','WoW',0x772be726feef42124255d2ea7973ca18),
+(42698,'Win','x64','WoW',0xb4497b1cd11fc974c5fb09548ac27269),
+(42825,'Win','x64','WoW',0xa14da228c6a6aff1ddba51218939e557),
+(42852,'Win','x64','WoW',0xde9f9f0c3cc8fd54d3aff99ceffce129),
+(42937,'Win','x64','WoW',0xf5fc75e70874752c92846b3333920e63),
+(42979,'Win','x64','WoW',0xe1dd38ae6450fc4d2ae4609233c59e54),
+(43114,'Win','x64','WoW',0xf75c9380ccb24a48a24eee52c1594a7e),
+(43206,'Win','x64','WoW',0xdde806532c7704ffb75f256dc5f1f3d9),
+(43340,'Win','x64','WoW',0x70e46d2d888e84df9316ea849b068cf4),
+(43345,'Win','x64','WoW',0xd911abfcda030dee8caf4ee3f60dee13),
+(43971,'Win','x64','WoW',0x681cf99e61fb0005a5c7d31d0aad1ed9),
+(44015,'Win','x64','WoW',0xfcf0bda7c98bfef92ae6d8c39a217abd),
+(44061,'Win','x64','WoW',0xfd2b5c0b3293fe0e9caa6eb0b7788119),
+(44127,'Win','x64','WoW',0x787887cec9fcc9b516481f60e4fc34a8),
+(44232,'Win','x64','WoW',0x81f0a71df7e9873bb3750022d64d33cf),
+(44325,'Win','x64','WoW',0x138a7d524d268a7f9934c3d148e8f01b),
+(44730,'Win','x64','WoW',0xfc0b18c47bb4c79f4300ca0ff3e5cac7),
+(44908,'Win','x64','WoW',0xbffaec40c9bcd591c7c959a9d5a8ba8c),
+(45114,'Win','x64','WoW',0xd7afe240bd00f06c30d0c2d16e54a8be),
+(45161,'Win','x64','WoW',0x74bd2e787a98b145b063bda9a98f6cbd),
+(45338,'Win','x64','WoW',0x5ce2094a41b61eda9df56378bc3b1de0),
+(45745,'Win','x64','WoW',0x0f6dc90161694d765a595a3af603166b),
+(46479,'Win','x64','WoW',0xcb9af4d89b60a3aba288d395d315d932),
+(46658,'Win','x64','WoW',0x3f8efb085428d75360e9efe25cd8639a),
+(46689,'Win','x64','WoW',0xd9a11d188d6ad60906f5467510efd3aa),
+(46702,'Win','x64','WoW',0x01b4d1688ff97dc9aafccd0a0b842c0b),
+(46741,'Win','x64','WoW',0x4c0f4a7ec2098af1fba745848ec79a78),
+(46801,'Win','x64','WoW',0xe6ac18d1ea5d36abffae5eded80630df),
+(46879,'Win','x64','WoW',0xefec43936051dd1a210633af1f6b63db),
+(46924,'Win','x64','WoW',0xe6ce0b1a8119f069ecf1e7dbaa7bb2f8),
+(47067,'Win','x64','WoW',0x63862cfcdea6bd2bd7f740eb36b65657),
+(47187,'Win','x64','WoW',0x711f8455c5000c237292e1e6e90631e1),
+(47213,'Win','x64','WoW',0x23c50d88ceac0a8696adde8dd244d4a2),
+(47631,'Win','x64','WoW',0xf986ab91d0aeb20822efb72f4256713c),
+(47777,'Win','x64','WoW',0xa88c04915ab9e035a104e55c4dcf5f9f),
+(47799,'Win','x64','WoW',0x7364eb093c23db2cdc9513d5a7b4933e),
+(47825,'Win','x64','WoW',0x82a3b94e5e727af3a208b471ff2054c0),
+(47849,'Win','x64','WoW',0xdd8bbe2087a28c0af4984cbe23a1c707),
+(47871,'Win','x64','WoW',0x8e4f7d30ee4982b02b3b3f8837c2c4f2),
+(47884,'Win','x64','WoW',0x2b7a002bc359f2c31104bc2de04302bf),
+(47936,'Win','x64','WoW',0x833d30d8fbc43b3fae99cd3898d70849),
+(47967,'Win','x64','WoW',0xcfe225d0089e224d9e7541d3b5c26478),
+(48001,'Win','x64','WoW',0x4b0260a37bd95b615e71048469e6d5bb),
+(48069,'Win','x64','WoW',0x558cdf958fa082e95849779c7c6945e5),
+(48317,'Win','x64','WoW',0xc096e37b45b43244e9c79916604dd4af),
+(48397,'Win','x64','WoW',0x64ba8779eaa97e6c57982b6b1a5b32e7),
+(48526,'Win','x64','WoW',0xd5b7d3303a2a741e6913ee1aeb0bcb65),
+(48676,'Win','x64','WoW',0xe059fb74dff6438cc20c7f28900f64ca),
+(48749,'Win','x64','WoW',0x92dbcca0e33dfb8a17a2b6a39246b288),
+(48838,'Win','x64','WoW',0x9e6f4e1e46ef228d2de90f7bc48aaa96),
+(48865,'Win','x64','WoW',0x4b774abe7b34d6702571b4279a4b6a13),
+(48892,'Win','x64','WoW',0xaa31bf27458321b03a1a346964dd7b9d),
+(48966,'Win','x64','WoW',0x823142ca131fbb715ff55d4343e55c6d),
+(48999,'Win','x64','WoW',0x79ba6ff0f9672eef875f64155c8b62d4),
+(49267,'Win','x64','WoW',0xeee77ea5a216e0731adbb41aefb1df31),
+(49318,'Win','x64','WoW',0xaf439aee62ee48b36c1725111e3d9bbf),
+(49343,'Win','x64','WoW',0x301a0b4c0942b9b6f605b903ad6c1f60),
+(49407,'Win','x64','WoW',0x6413820dc9885bb0693b37090cbb2f30),
+(49426,'Win','x64','WoW',0xd85edfbfe9a94a55e2b4510be41c19b2),
+(49444,'Win','x64','WoW',0x363b2b05285bdd8857419d2866316d3c),
+(49474,'Win','x64','WoW',0x44a7d2b352ee3d098a3cb4c2f1065e37),
+(49570,'Win','x64','WoW',0xb024de67acaeb9e8ee6db38dc53e8281),
+(49679,'Win','x64','WoW',0x9ce59b68d8797ebf00581f41138f4316),
+(49741,'Win','x64','WoW',0x0ef181e2bb0e946cf3b7422adeb6cd1a),
+(49801,'Win','x64','WoW',0x0832179567b66ca85dbd5678b604c683),
+(49890,'Win','x64','WoW',0x22a5b8a1eb797a64995f705b3dbcb14c),
+(50000,'Win','x64','WoW',0x02f06ffa2296fd66384295dbfd5a4c91),
+(50401,'Win','x64','WoW',0x3eef52d902cce81d16d0e255f0aa4938),
+(50438,'Win','x64','WoW',0x0b5f68f06b129cb4c57702f6d30f260b),
+(50467,'Win','x64','WoW',0x5e996b1cdcee68432d6340138e68d1eb),
+(50469,'Win','x64','WoW',0x1768ccb6589e16ab3befa9d608a393a2),
+(50504,'Win','x64','WoW',0x7d5fd20c0b32c9af5dd65433b391d49c),
+(50585,'Win','x64','WoW',0xc4f7cc38a3b84935a485f7edad3e764b),
+(50622,'Win','x64','WoW',0xd23a26fd75fd9a6073eb7060aa28e6a7),
+(50747,'Win','x64','WoW',0x2d3c386a9c45c27304ed3a3c6eb3f7c8),
+(50791,'Win','x64','WoW',0x0be7d0bb07ef37c25cbc682409091ea0),
+(51130,'Win','x64','WoW',0x44cd2c91e4f0655da387483726ce4035),
+(51187,'Win','x64','WoW',0x74e2055d3965269447b5cb1b31fc71c6),
+(51237,'Win','x64','WoW',0xc8660a21b766646fbd67f481cfcf55c3),
+(51261,'Win','x64','WoW',0x1bebb57ae450331e9f8c301aa7876fab),
+(51313,'Win','x64','WoW',0x35419ed0ab16735cf720858f45dc300c),
+(51421,'Win','x64','WoW',0x45e24d6f3335269787df2b2063939002),
+(51485,'Win','x64','WoW',0xec549e1d0a5dd85c03e7a9d93b7dc6d1),
+(51536,'Win','x64','WoW',0x570eea10a8ec169c3ff9621d1b635bb4),
+(51754,'Win','x64','WoW',0xbed5a861c071ab41fef6087e0c37bb1a),
+(51886,'Win','x64','WoW',0x09cf8919fd2eabdeaebc0c810f53b511),
+(51972,'Win','x64','WoW',0x444dc7ef3544b6670c18884dada00428),
+(52038,'Win','x64','WoW',0xa8ef004aded8a3aff5a67d2bb8d95795),
+(52068,'Win','x64','WoW',0xa44f842baccc7ee8e2975faf01f12474),
+(52095,'Win','x64','WoW',0xba36382887d16d274ea9149695f0c9c8),
+(52106,'Win','x64','WoW',0x95f43869b7d881212cbc1690b8f393ed),
+(52129,'Win','x64','WoW',0x02dd842f2a7162eeb8fd5b9d325606f8),
+(52148,'Win','x64','WoW',0x8a969717c8cdc6e7ff4c54d5cb00c224),
+(52188,'Win','x64','WoW',0x977df9993e94855ded5e328ba7a2f21f),
+(52301,'Win','x64','WoW',0x821aa3bb237b400b82f44970250539aa),
+(52393,'Win','x64','WoW',0xb013ed23b7ef51b29a45594d9bbb0d03),
+(52485,'Win','x64','WoW',0x5805ceb4650730ae489258dd30e34441),
+(52545,'Win','x64','WoW',0xfb52179a8355a46edbfbdc8e8e5cdafd),
+(52607,'Win','x64','WoW',0x8f002e4aadcaeabb08abc2880b31ad60),
+(52649,'Win','x64','WoW',0xd0b779fbecebc1ed5a85d83f03c8a75b),
+(52808,'Win','x64','WoW',0x6276712b6c8aea21cd5d94d52fee70ee),
+(52902,'Win','x64','WoW',0xd4f0a24cdf165628538c1c387a326af3),
+(52968,'Win','x64','WoW',0x2d247fd440c44d4f1bf80b075b8720f2),
+(52983,'Win','x64','WoW',0xb1e5ada5fdd06c9ab5e5d8a6983324ac),
+(53007,'Win','x64','WoW',0xa21afb4d381c56af471d994258c0eef5),
+(53040,'Win','x64','WoW',0x2f1283bf7b7f307b70dbbd75cc42d7c3),
+(53104,'Win','x64','WoW',0xdbd79ec8df044b53c78931b985cab406),
+(53162,'Win','x64','WoW',0x8a67511fbf8984eee2b630f7cb23376a),
+(53212,'Win','x64','WoW',0x08761eff2f9b639364b9a9fbffffb949),
+(53262,'Win','x64','WoW',0x614a72d53126348a4927ec0f53fd2b7a),
+(53441,'Win','x64','WoW',0xbfdd7d0fe87d5f75e6deb4f5c99d7c99),
+(53584,'Win','x64','WoW',0xcdd7a93659a03460b5a6ce1c4ace5554),
+(53627,'Win','x64','WoW',0x57f35840ba629bac4717a901347c40f1),
+(53750,'Win','x64','WoW',0xe33ba2df1c239ab1b539fe1a01fc82b1),
+(53863,'Win','x64','WoW',0x6052c8f657f398912862cfd7010dbc73),
+(54027,'Win','x64','WoW',0x2de781d4918766e5c12fbc54d63a9195),
+(54737,'Win','x64','WoW',0x81e29e958ca39ee7bf0685b548a58b51),
+(54851,'Win','x64','WoW',0x04721bcf80465e14498799c00b32d646),
+(54901,'Win','x64','WoW',0xab840e833490435689d5832d91a70871),
+(55006,'Win','x64','WoW',0xd13b75d1e7848dfbb61ab5d9fee51b49),
+(55056,'Win','x64','WoW',0x209beebbbfe6aa3ae491d9d1f1a7c98a),
+(55141,'Win','x64','WoW',0x102810005f13a3440705de344df5633f),
+(55262,'Win','x64','WoW',0xeb4b58af1b3b79ddd9e2477ba1375d42),
+(55460,'Win','x64','WoW',0xe5455f750394046cc9bd2ed0397f7418),
+(55613,'Win','x64','WoW',0x0ba3bff2e324fe30d15ba8a88cf8738b),
+(55639,'Win','x64','WoW',0xffd74533a9d95e1d38c972ba4f351b8d),
+(56014,'Win','x64','WoW',0x89ad7a75e156374d41f0cc70455b2f6b);
+/*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
+UNLOCK TABLES;
+
+DROP TABLE IF EXISTS `build_executable_hash`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `build_executable_hash`
+--
+
+LOCK TABLES `build_executable_hash` WRITE;
+/*!40000 ALTER TABLE `build_executable_hash` DISABLE KEYS */;
+INSERT INTO `build_executable_hash` VALUES
+(5875,'OSX',0x8D173CC381961EEBABF336F5E6675B101BB513E5),
+(5875,'Win',0x95EDB27C7823B363CBDDAB56A392E7CB73FCCA20),
+(8606,'OSX',0xD8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F),
+(8606,'Win',0x319AFAA3F2559682F9FF658BE01456255F456FB1),
+(12340,'OSX',0xB706D13FF2F4018839729461E3F8A0E2B5FDC034),
+(12340,'Win',0xCDCBBD5188315E6B4D19449D492DBCFAF156A347);
+/*!40000 ALTER TABLE `build_executable_hash` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `build_info`
 --
 
@@ -510,12 +782,6 @@ CREATE TABLE `build_info` (
   `minorVersion` int DEFAULT NULL,
   `bugfixVersion` int DEFAULT NULL,
   `hotfixVersion` char(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `winAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `win64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `mac64AuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `macArmAuthSeed` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `winChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
-  `macChecksumSeed` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
   PRIMARY KEY (`build`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -527,263 +793,263 @@ CREATE TABLE `build_info` (
 LOCK TABLES `build_info` WRITE;
 /*!40000 ALTER TABLE `build_info` DISABLE KEYS */;
 INSERT INTO `build_info` VALUES
-(5875,1,12,1,NULL,NULL,NULL,NULL,NULL,'95EDB27C7823B363CBDDAB56A392E7CB73FCCA20','8D173CC381961EEBABF336F5E6675B101BB513E5'),
-(6005,1,12,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(6141,1,12,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(8606,2,4,3,NULL,NULL,NULL,NULL,NULL,'319AFAA3F2559682F9FF658BE01456255F456FB1','D8B0ECFE534BC1131E19BAD1D4C0E813EEE4994F'),
-(9947,3,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(10505,3,2,2,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(11159,3,3,0,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(11403,3,3,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(11723,3,3,3,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(12340,3,3,5,'a',NULL,NULL,NULL,NULL,'CDCBBD5188315E6B4D19449D492DBCFAF156A347','B706D13FF2F4018839729461E3F8A0E2B5FDC034'),
-(13623,4,0,6,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(13930,3,3,5,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(14545,4,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(15595,4,3,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19116,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19243,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19342,6,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19702,6,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19802,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19831,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(19865,6,1,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20182,6,2,0,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(20201,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20216,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20253,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20338,6,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20444,6,2,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20490,6,2,2,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(20574,6,2,2,'a',NULL,NULL,NULL,NULL,NULL,NULL),
-(20726,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20779,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(20886,6,2,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(21355,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(21463,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(21742,6,2,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22248,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22293,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22345,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22410,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22423,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22498,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22522,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22566,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22594,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22624,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22747,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22810,7,0,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22900,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22908,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22950,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22995,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(22996,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(23171,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(23222,7,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(23360,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(23420,7,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(23911,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(23937,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24015,7,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24330,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24367,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24415,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24430,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24461,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(24742,7,2,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
-(25549,7,3,2,NULL,'FE594FC35E7F9AFF86D99D8A364AB297','1252624ED8CBD6FAC7D33F5D67A535F3','66FC5E09B8706126795F140308C8C1D8',NULL,NULL,NULL),
-(25996,7,3,5,NULL,'23C59C5963CBEF5B728D13A50878DFCB','C7FF932D6A2174A3D538CA7212136D2B','210B970149D6F56CAC9BADF2AAC91E8E',NULL,NULL,NULL),
-(26124,7,3,5,NULL,'F8C05AE372DECA1D6C81DA7A8D1C5C39','46DF06D0147BA67BA49AF553435E093F','C9CA997AB8EDE1C65465CB2920869C4E',NULL,NULL,NULL),
-(26365,7,3,5,NULL,'2AAC82C80E829E2CA902D70CFA1A833A','59A53F307288454B419B13E694DF503C','DBE7F860276D6B400AAA86B35D51A417',NULL,NULL,NULL),
-(26654,7,3,5,NULL,'FAC2D693E702B9EC9F750F17245696D8','A752640E8B99FE5B57C1320BC492895A','9234C1BD5E9687ADBD19F764F2E0E811',NULL,NULL,NULL),
-(26822,7,3,5,NULL,'283E8D77ECF7060BE6347BE4EB99C7C7','2B05F6D746C0C6CC7EF79450B309E595','91003668C245D14ECD8DF094E065E06B',NULL,NULL,NULL),
-(26899,7,3,5,NULL,'F462CD2FE4EA3EADF875308FDBB18C99','3551EF0028B51E92170559BD25644B03','8368EFC2021329110A16339D298200D4',NULL,NULL,NULL),
-(26972,7,3,5,NULL,'797ECC19662DCBD5090A4481173F1D26','6E212DEF6A0124A3D9AD07F5E322F7AE','341CFEFE3D72ACA9A4407DC535DED66A',NULL,NULL,NULL),
-(28153,8,0,1,NULL,NULL,'DD626517CC6D31932B479934CCDC0ABF',NULL,NULL,NULL,NULL),
-(30706,8,1,5,NULL,NULL,'BB6D9866FE4A19A568015198783003FC',NULL,NULL,NULL,NULL),
-(30993,8,2,0,NULL,NULL,'2BAD61655ABC2FC3D04893B536403A91',NULL,NULL,NULL,NULL),
-(31229,8,2,0,NULL,NULL,'8A46F23670309F2AAE85C9A47276382B',NULL,NULL,NULL,NULL),
-(31429,8,2,0,NULL,NULL,'7795A507AF9DC3525EFF724FEE17E70C',NULL,NULL,NULL,NULL),
-(31478,8,2,0,NULL,NULL,'7973A8D54BDB8B798D9297B096E771EF',NULL,NULL,NULL,NULL),
-(32305,8,2,5,NULL,NULL,'21F5A6FC7AD89FBF411FDA8B8738186A',NULL,NULL,NULL,NULL),
-(32494,8,2,5,NULL,NULL,'58984ACE04919401835C61309A848F8A',NULL,NULL,NULL,NULL),
-(32580,8,2,5,NULL,NULL,'87C2FAA0D7931BF016299025C0DDCA14',NULL,NULL,NULL,NULL),
-(32638,8,2,5,NULL,NULL,'5D07ECE7D4A867DDDE615DAD22B76D4E',NULL,NULL,NULL,NULL),
-(32722,8,2,5,NULL,NULL,'1A09BE1D38A122586B4931BECCEAD4AA',NULL,NULL,NULL,NULL),
-(32750,8,2,5,NULL,NULL,'C5CB669F5A5B237D1355430877173207','EF1F4E4D099EA2A81FD4C0DEBC1E7086',NULL,NULL,NULL),
-(32978,8,2,5,NULL,NULL,'76AE2EA03E525D97F5688843F5489000','1852C1F847E795D6EB45278CD433F339',NULL,NULL,NULL),
-(33369,8,3,0,NULL,NULL,'5986AC18B04D3C403F56A0CF8C4F0A14','F5A849C70A1054F07EA3AB833EBF6671',NULL,NULL,NULL),
-(33528,8,3,0,NULL,NULL,'0ECE033CA9B11D92F7D2792C785B47DF',NULL,NULL,NULL,NULL),
-(33724,8,3,0,NULL,NULL,'38F7BBCF284939DD20E8C64CDBF9FE77',NULL,NULL,NULL,NULL),
-(33775,8,3,0,NULL,NULL,'B826300A8449ED0F6EF16EA747FA2D2E','354D2DE619D124EE1398F76B0436FCFC',NULL,NULL,NULL),
-(33941,8,3,0,NULL,NULL,'88AF1A36D2770D0A6CA086497096A889',NULL,NULL,NULL,NULL),
-(34220,8,3,0,NULL,NULL,'B5E35B976C6BAF82505700E7D9666A2C',NULL,NULL,NULL,NULL),
-(34601,8,3,0,NULL,NULL,'0D7DF38F725FABA4F009257799A10563',NULL,NULL,NULL,NULL),
-(34769,8,3,0,NULL,NULL,'93F9B9AF6397E3E4EED94D36D16907D2',NULL,NULL,NULL,NULL),
-(34963,8,3,0,NULL,NULL,'7BA50C879C5D04221423B02AC3603A11','C5658A17E702163447BAAAE46D130A1B',NULL,NULL,NULL),
-(35249,8,3,7,NULL,NULL,'C7B11F9AE9FF1409F5582902B3D10D1C',NULL,NULL,NULL,NULL),
-(35284,8,3,7,NULL,NULL,'EA3818E7DCFD2009DBFC83EE3C1E4F1B','A6201B0AC5A73D13AB2FDCC79BB252AF',NULL,NULL,NULL),
-(35435,8,3,7,NULL,NULL,'BB397A92FE23740EA52FC2B5BA2EC8E0','8FE657C14A46BCDB2CE6DA37E430450E',NULL,NULL,NULL),
-(35662,8,3,7,NULL,NULL,'578BC94870C278CB6962F30E6DC203BB','5966016C368ED9F7AAB603EE6703081C',NULL,NULL,NULL),
-(36753,9,0,2,NULL,NULL,'386FDE8559B5EAD67B791B490B200B88',NULL,NULL,NULL,NULL),
-(36839,9,0,2,NULL,NULL,'356EB4412B8EFCF72E3AF50D5181D529',NULL,NULL,NULL,NULL),
-(36949,9,0,2,NULL,NULL,'51C074CD8A09A75384B9B44188C56981',NULL,NULL,NULL,NULL),
-(37142,9,0,2,NULL,NULL,'5D9CFB3139F0D1B6C2B304261F9EABC9',NULL,NULL,NULL,NULL),
-(37176,9,0,2,NULL,NULL,'3C725EA504EC3DAED143EB6FF3B48CDA',NULL,NULL,NULL,NULL),
-(37474,9,0,2,NULL,NULL,'0DE685BBB0551086E7FBDC0B4BB06A5B','024C9BE7E44237B7E81C6D42E678D433',NULL,NULL,NULL),
-(38134,9,0,5,NULL,NULL,'32275ED0F13B357C28BDB0E611EF9E31',NULL,NULL,NULL,NULL),
-(38556,9,0,5,NULL,NULL,'EC7D5AF64364AC3E7181F3FBA1B3A882',NULL,NULL,NULL,NULL),
-(39653,9,1,0,NULL,NULL,'10D015AB1EEB91310428D9C57EE24632',NULL,NULL,NULL,NULL),
-(39804,9,1,0,NULL,NULL,'E42D2BBA12ED260A76F9B1E477E19EA5',NULL,NULL,NULL,NULL),
-(40000,9,1,0,NULL,NULL,'4CB1433AB637F09F03FBBD1B221B04B0',NULL,NULL,NULL,NULL),
-(40120,9,1,0,NULL,NULL,'04F47EAEFD8BDEFE14AA0350EA336678','853F0F2985CEAED46DF422583CD07A7C',NULL,NULL,NULL),
-(40443,9,1,0,NULL,NULL,'8597BB43E8AB38C85504E8BFB72ABBF5',NULL,NULL,NULL,NULL),
-(40593,9,1,0,NULL,NULL,'BA14570F2D62D5F61953394164A8DAE2',NULL,NULL,NULL,NULL),
-(40725,9,1,0,NULL,NULL,'C1EBDBEB9BB2956EBCCEF7C9D27A1B3B',NULL,NULL,NULL,NULL),
-(40906,9,1,5,NULL,NULL,'F5FC259C8635488AFE0D0CD023F361D4',NULL,NULL,NULL,NULL),
-(40944,9,1,5,NULL,NULL,'368FC7FABAF487A8A049C11970657074',NULL,NULL,NULL,NULL),
-(40966,9,1,5,NULL,NULL,'D90F47AF21F381D2D8F3763B994BAC88',NULL,NULL,NULL,NULL),
-(41031,9,1,5,NULL,NULL,'019A0FACD6B0D6374B7BA69A5B677449',NULL,NULL,NULL,NULL),
-(41079,9,1,5,NULL,NULL,'F8853CF823BC0BBE8A9677A762DFAEE1',NULL,NULL,NULL,NULL),
-(41288,9,1,5,NULL,NULL,'871C0C9691DBC536EB24B68EC73FAD5B',NULL,NULL,NULL,NULL),
-(41323,9,1,5,NULL,NULL,'E53D0DF1FAC1A59A1C8071B295A04A1D',NULL,NULL,NULL,NULL),
-(41359,9,1,5,NULL,NULL,'5F8D7F2A690A4375A1B52A28D6D681FA',NULL,NULL,NULL,NULL),
-(41488,9,1,5,NULL,NULL,'1BC91EC368705815F3F532B553DAD981',NULL,NULL,NULL,NULL),
-(41793,9,1,5,NULL,NULL,'B3B47DA3B7615570742A55B96614EE1C',NULL,NULL,NULL,NULL),
-(42010,9,1,5,NULL,NULL,'302970161D16417B5BE553CC530E011A',NULL,NULL,NULL,NULL),
-(42423,9,2,0,NULL,NULL,'0B03614A7E94DD57548596BE420E9DC2',NULL,NULL,NULL,NULL),
-(42488,9,2,0,NULL,NULL,'A78755E6928D83A271C5D1EE3CDB6F15',NULL,NULL,NULL,NULL),
-(42521,9,2,0,NULL,NULL,'5FE6C12FC407C6B15B4A5D3B5B4A5D3B',NULL,NULL,NULL,NULL),
-(42538,9,2,0,NULL,NULL,'71A7504BD53F8DE518F24265D37310AE',NULL,NULL,NULL,NULL),
-(42560,9,2,0,NULL,NULL,'115FE8C38A8D67CA4664BB192E0F0DFE',NULL,NULL,NULL,NULL),
-(42614,9,2,0,NULL,NULL,'772BE726FEEF42124255D2EA7973CA18',NULL,NULL,NULL,NULL),
-(42698,9,2,0,NULL,NULL,'B4497B1CD11FC974C5FB09548AC27269',NULL,NULL,NULL,NULL),
-(42825,9,2,0,NULL,NULL,'A14DA228C6A6AFF1DDBA51218939E557',NULL,NULL,NULL,NULL),
-(42852,9,2,0,NULL,NULL,'DE9F9F0C3CC8FD54D3AFF99CEFFCE129',NULL,NULL,NULL,NULL),
-(42937,9,2,0,NULL,NULL,'F5FC75E70874752C92846B3333920E63',NULL,NULL,NULL,NULL),
-(42979,9,2,0,NULL,NULL,'E1DD38AE6450FC4D2AE4609233C59E54',NULL,NULL,NULL,NULL),
-(43114,9,2,0,NULL,NULL,'F75C9380CCB24A48A24EEE52C1594A7E',NULL,NULL,NULL,NULL),
-(43206,9,2,0,NULL,NULL,'DDE806532C7704FFB75F256DC5F1F3D9',NULL,NULL,NULL,NULL),
-(43340,9,2,0,NULL,NULL,'70E46D2D888E84DF9316EA849B068CF4',NULL,NULL,NULL,NULL),
-(43345,9,2,0,NULL,NULL,'D911ABFCDA030DEE8CAF4EE3F60DEE13',NULL,NULL,NULL,NULL),
-(43971,9,2,5,NULL,NULL,'681CF99E61FB0005A5C7D31D0AAD1ED9',NULL,NULL,NULL,NULL),
-(44015,9,2,5,NULL,NULL,'FCF0BDA7C98BFEF92AE6D8C39A217ABD',NULL,NULL,NULL,NULL),
-(44061,9,2,5,NULL,NULL,'FD2B5C0B3293FE0E9CAA6EB0B7788119',NULL,NULL,NULL,NULL),
-(44127,9,2,5,NULL,NULL,'787887CEC9FCC9B516481F60E4FC34A8',NULL,NULL,NULL,NULL),
-(44232,9,2,5,NULL,NULL,'81F0A71DF7E9873BB3750022D64D33CF',NULL,NULL,NULL,NULL),
-(44325,9,2,5,NULL,NULL,'138A7D524D268A7F9934C3D148E8F01B',NULL,NULL,NULL,NULL),
-(44730,9,2,5,NULL,NULL,'FC0B18C47BB4C79F4300CA0FF3E5CAC7',NULL,NULL,NULL,NULL),
-(44908,9,2,5,NULL,NULL,'BFFAEC40C9BCD591C7C959A9D5A8BA8C',NULL,NULL,NULL,NULL),
-(45114,9,2,7,NULL,NULL,'D7AFE240BD00F06C30D0C2D16E54A8BE',NULL,NULL,NULL,NULL),
-(45161,9,2,7,NULL,NULL,'74BD2E787A98B145B063BDA9A98F6CBD',NULL,NULL,NULL,NULL),
-(45338,9,2,7,NULL,NULL,'5CE2094A41B61EDA9DF56378BC3B1DE0',NULL,NULL,NULL,NULL),
-(45745,9,2,7,NULL,NULL,'0F6DC90161694D765A595A3AF603166B',NULL,NULL,NULL,NULL),
-(46479,10,0,2,NULL,NULL,'CB9AF4D89B60A3ABA288D395D315D932',NULL,NULL,NULL,NULL),
-(46658,10,0,2,NULL,NULL,'3F8EFB085428D75360E9EFE25CD8639A',NULL,NULL,NULL,NULL),
-(46689,10,0,2,NULL,NULL,'D9A11D188D6AD60906F5467510EFD3AA',NULL,NULL,NULL,NULL),
-(46702,10,0,2,NULL,NULL,'01B4D1688FF97DC9AAFCCD0A0B842C0B',NULL,NULL,NULL,NULL),
-(46741,10,0,2,NULL,NULL,'4C0F4A7EC2098AF1FBA745848EC79A78',NULL,NULL,NULL,NULL),
-(46801,10,0,2,NULL,NULL,'E6AC18D1EA5D36ABFFAE5EDED80630DF',NULL,NULL,NULL,NULL),
-(46879,10,0,2,NULL,NULL,'EFEC43936051DD1A210633AF1F6B63DB',NULL,NULL,NULL,NULL),
-(46924,10,0,2,NULL,NULL,'E6CE0B1A8119F069ECF1E7DBAA7BB2F8',NULL,NULL,NULL,NULL),
-(47067,10,0,2,NULL,NULL,'63862CFCDEA6BD2BD7F740EB36B65657',NULL,NULL,NULL,NULL),
-(47187,10,0,2,NULL,NULL,'711F8455C5000C237292E1E6E90631E1',NULL,NULL,NULL,NULL),
-(47213,10,0,2,NULL,NULL,'23C50D88CEAC0A8696ADDE8DD244D4A2',NULL,NULL,NULL,NULL),
-(47631,10,0,2,NULL,NULL,'F986AB91D0AEB20822EFB72F4256713C',NULL,NULL,NULL,NULL),
-(47777,10,0,5,NULL,NULL,'A88C04915AB9E035A104E55C4DCF5F9F',NULL,NULL,NULL,NULL),
-(47799,10,0,5,NULL,NULL,'7364EB093C23DB2CDC9513D5A7B4933E',NULL,NULL,NULL,NULL),
-(47825,10,0,5,NULL,NULL,'82A3B94E5E727AF3A208B471FF2054C0',NULL,NULL,NULL,NULL),
-(47849,10,0,5,NULL,NULL,'DD8BBE2087A28C0AF4984CBE23A1C707',NULL,NULL,NULL,NULL),
-(47871,10,0,5,NULL,NULL,'8E4F7D30EE4982B02B3B3F8837C2C4F2',NULL,NULL,NULL,NULL),
-(47884,10,0,5,NULL,NULL,'2B7A002BC359F2C31104BC2DE04302BF',NULL,NULL,NULL,NULL),
-(47936,10,0,5,NULL,NULL,'833D30D8FBC43B3FAE99CD3898D70849',NULL,NULL,NULL,NULL),
-(47967,10,0,5,NULL,NULL,'CFE225D0089E224D9E7541D3B5C26478',NULL,NULL,NULL,NULL),
-(48001,10,0,5,NULL,NULL,'4B0260A37BD95B615E71048469E6D5BB',NULL,NULL,NULL,NULL),
-(48069,10,0,5,NULL,NULL,'558CDF958FA082E95849779C7C6945E5',NULL,NULL,NULL,NULL),
-(48317,10,0,5,NULL,NULL,'C096E37B45B43244E9C79916604DD4AF',NULL,NULL,NULL,NULL),
-(48397,10,0,5,NULL,NULL,'64BA8779EAA97E6C57982B6B1A5B32E7',NULL,NULL,NULL,NULL),
-(48526,10,0,5,NULL,NULL,'D5B7D3303A2A741E6913EE1AEB0BCB65',NULL,NULL,NULL,NULL),
-(48676,10,0,7,NULL,NULL,'E059FB74DFF6438CC20C7F28900F64CA',NULL,NULL,NULL,NULL),
-(48749,10,0,7,NULL,NULL,'92DBCCA0E33DFB8A17A2B6A39246B288',NULL,NULL,NULL,NULL),
-(48838,10,0,7,NULL,NULL,'9E6F4E1E46EF228D2DE90F7BC48AAA96',NULL,NULL,NULL,NULL),
-(48865,10,0,7,NULL,NULL,'4B774ABE7B34D6702571B4279A4B6A13',NULL,NULL,NULL,NULL),
-(48892,10,0,7,NULL,NULL,'AA31BF27458321B03A1A346964DD7B9D',NULL,NULL,NULL,NULL),
-(48966,10,0,7,NULL,NULL,'823142CA131FBB715FF55D4343E55C6D',NULL,NULL,NULL,NULL),
-(48999,10,0,7,NULL,NULL,'79BA6FF0F9672EEF875F64155C8B62D4',NULL,NULL,NULL,NULL),
-(49267,10,0,7,NULL,NULL,'EEE77EA5A216E0731ADBB41AEFB1DF31',NULL,NULL,NULL,NULL),
-(49318,10,1,0,NULL,NULL,'AF439AEE62EE48B36C1725111E3D9BBF',NULL,NULL,NULL,NULL),
-(49343,10,0,7,NULL,NULL,'301A0B4C0942B9B6F605B903AD6C1F60',NULL,NULL,NULL,NULL),
-(49407,10,1,0,NULL,NULL,'6413820DC9885BB0693B37090CBB2F30',NULL,NULL,NULL,NULL),
-(49426,10,1,0,NULL,NULL,'D85EDFBFE9A94A55E2B4510BE41C19B2',NULL,NULL,NULL,NULL),
-(49444,10,1,0,NULL,NULL,'363B2B05285BDD8857419D2866316D3C',NULL,NULL,NULL,NULL),
-(49474,10,1,0,NULL,NULL,'44A7D2B352EE3D098A3CB4C2F1065E37',NULL,NULL,NULL,NULL),
-(49570,10,1,0,NULL,NULL,'B024DE67ACAEB9E8EE6DB38DC53E8281',NULL,NULL,NULL,NULL),
-(49679,10,1,0,NULL,NULL,'9CE59B68D8797EBF00581F41138F4316',NULL,NULL,NULL,NULL),
-(49741,10,1,0,NULL,NULL,'0EF181E2BB0E946CF3B7422ADEB6CD1A',NULL,NULL,NULL,NULL),
-(49801,10,1,0,NULL,NULL,'0832179567B66CA85DBD5678B604C683',NULL,NULL,NULL,NULL),
-(49890,10,1,0,NULL,NULL,'22A5B8A1EB797A64995F705B3DBCB14C',NULL,NULL,NULL,NULL),
-(50000,10,1,0,NULL,NULL,'02F06FFA2296FD66384295DBFD5A4C91',NULL,NULL,NULL,NULL),
-(50401,10,1,5,NULL,NULL,'3EEF52D902CCE81D16D0E255F0AA4938',NULL,NULL,NULL,NULL),
-(50438,10,1,5,NULL,NULL,'0B5F68F06B129CB4C57702F6D30F260B',NULL,NULL,NULL,NULL),
-(50467,10,1,5,NULL,NULL,'5E996B1CDCEE68432D6340138E68D1EB',NULL,NULL,NULL,NULL),
-(50469,10,1,5,NULL,NULL,'1768CCB6589E16AB3BEFA9D608A393A2',NULL,NULL,NULL,NULL),
-(50504,10,1,5,NULL,NULL,'7D5FD20C0B32C9AF5DD65433B391D49C',NULL,NULL,NULL,NULL),
-(50585,10,1,5,NULL,NULL,'C4F7CC38A3B84935A485F7EDAD3E764B',NULL,NULL,NULL,NULL),
-(50622,10,1,5,NULL,NULL,'D23A26FD75FD9A6073EB7060AA28E6A7',NULL,NULL,NULL,NULL),
-(50747,10,1,5,NULL,NULL,'2D3C386A9C45C27304ED3A3C6EB3F7C8',NULL,NULL,NULL,NULL),
-(50791,10,1,5,NULL,NULL,'0BE7D0BB07EF37C25CBC682409091EA0',NULL,NULL,NULL,NULL),
-(51130,10,1,5,NULL,NULL,'44CD2C91E4F0655DA387483726CE4035',NULL,NULL,NULL,NULL),
-(51187,10,1,7,NULL,NULL,'74E2055D3965269447B5CB1B31FC71C6',NULL,NULL,NULL,NULL),
-(51237,10,1,7,NULL,NULL,'C8660A21B766646FBD67F481CFCF55C3',NULL,NULL,NULL,NULL),
-(51261,10,1,7,NULL,NULL,'1BEBB57AE450331E9F8C301AA7876FAB',NULL,NULL,NULL,NULL),
-(51313,10,1,7,NULL,NULL,'35419ED0AB16735CF720858F45DC300C',NULL,NULL,NULL,NULL),
-(51421,10,1,7,NULL,NULL,'45E24D6F3335269787DF2B2063939002',NULL,NULL,NULL,NULL),
-(51485,10,1,7,NULL,NULL,'EC549E1D0A5DD85C03E7A9D93B7DC6D1',NULL,NULL,NULL,NULL),
-(51536,10,1,7,NULL,NULL,'570EEA10A8EC169C3FF9621D1B635BB4',NULL,NULL,NULL,NULL),
-(51754,10,1,7,NULL,NULL,'BED5A861C071AB41FEF6087E0C37BB1A',NULL,NULL,NULL,NULL),
-(51886,10,1,7,NULL,NULL,'09CF8919FD2EABDEAEBC0C810F53B511',NULL,NULL,NULL,NULL),
-(51972,10,1,7,NULL,NULL,'444DC7EF3544B6670C18884DADA00428',NULL,NULL,NULL,NULL),
-(52038,10,2,0,NULL,NULL,'A8EF004ADED8A3AFF5A67D2BB8D95795',NULL,NULL,NULL,NULL),
-(52068,10,2,0,NULL,NULL,'A44F842BACCC7EE8E2975FAF01F12474',NULL,NULL,NULL,NULL),
-(52095,10,2,0,NULL,NULL,'BA36382887D16D274EA9149695F0C9C8',NULL,NULL,NULL,NULL),
-(52106,10,2,0,NULL,NULL,'95F43869B7D881212CBC1690B8F393ED',NULL,NULL,NULL,NULL),
-(52129,10,2,0,NULL,NULL,'02DD842F2A7162EEB8FD5B9D325606F8',NULL,NULL,NULL,NULL),
-(52148,10,2,0,NULL,NULL,'8A969717C8CDC6E7FF4C54D5CB00C224',NULL,NULL,NULL,NULL),
-(52188,10,2,0,NULL,NULL,'977DF9993E94855DED5E328BA7A2F21F',NULL,NULL,NULL,NULL),
-(52301,10,2,0,NULL,NULL,'821AA3BB237B400B82F44970250539AA',NULL,NULL,NULL,NULL),
-(52393,10,2,0,NULL,NULL,'B013ED23B7EF51B29A45594D9BBB0D03',NULL,NULL,NULL,NULL),
-(52485,10,2,0,NULL,NULL,'5805CEB4650730AE489258DD30E34441',NULL,NULL,NULL,NULL),
-(52545,10,2,0,NULL,NULL,'FB52179A8355A46EDBFBDC8E8E5CDAFD',NULL,NULL,NULL,NULL),
-(52607,10,2,0,NULL,NULL,'8F002E4AADCAEABB08ABC2880B31AD60',NULL,NULL,NULL,NULL),
-(52649,10,2,0,NULL,NULL,'D0B779FBECEBC1ED5A85D83F03C8A75B',NULL,NULL,NULL,NULL),
-(52808,10,2,0,NULL,NULL,'6276712B6C8AEA21CD5D94D52FEE70EE',NULL,NULL,NULL,NULL),
-(52902,10,2,5,NULL,NULL,'D4F0A24CDF165628538C1C387A326AF3',NULL,NULL,NULL,NULL),
-(52968,10,2,5,NULL,NULL,'2D247FD440C44D4F1BF80B075B8720F2',NULL,NULL,NULL,NULL),
-(52983,10,2,5,NULL,NULL,'B1E5ADA5FDD06C9AB5E5D8A6983324AC',NULL,NULL,NULL,NULL),
-(53007,10,2,5,NULL,NULL,'A21AFB4D381C56AF471D994258C0EEF5',NULL,NULL,NULL,NULL),
-(53040,10,2,5,NULL,NULL,'2F1283BF7B7F307B70DBBD75CC42D7C3',NULL,NULL,NULL,NULL),
-(53104,10,2,5,NULL,NULL,'DBD79EC8DF044B53C78931B985CAB406',NULL,NULL,NULL,NULL),
-(53162,10,2,5,NULL,NULL,'8A67511FBF8984EEE2B630F7CB23376A',NULL,NULL,NULL,NULL),
-(53212,10,2,5,NULL,NULL,'08761EFF2F9B639364B9A9FBFFFFB949',NULL,NULL,NULL,NULL),
-(53262,10,2,5,NULL,NULL,'614A72D53126348A4927EC0F53FD2B7A',NULL,NULL,NULL,NULL),
-(53441,10,2,5,NULL,NULL,'BFDD7D0FE87D5F75E6DEB4F5C99D7C99',NULL,NULL,NULL,NULL),
-(53584,10,2,5,NULL,NULL,'CDD7A93659A03460B5A6CE1C4ACE5554',NULL,NULL,NULL,NULL),
-(53627,4,4,0,NULL,NULL,'57F35840BA629BAC4717A901347C40F1',NULL,NULL,NULL,NULL),
-(53750,4,4,0,NULL,NULL,'E33BA2DF1C239AB1B539FE1A01FC82B1',NULL,NULL,NULL,NULL),
-(53863,4,4,0,NULL,NULL,'6052C8F657F398912862CFD7010DBC73',NULL,NULL,NULL,NULL),
-(54027,4,4,0,NULL,NULL,'2DE781D4918766E5C12FBC54D63A9195',NULL,NULL,NULL,NULL),
-(54737,4,4,0,NULL,NULL,'81E29E958CA39EE7BF0685B548A58B51',NULL,NULL,NULL,NULL),
-(54851,4,4,0,NULL,NULL,'04721BCF80465E14498799C00B32D646',NULL,NULL,NULL,NULL),
-(54901,4,4,0,NULL,NULL,'AB840E833490435689D5832D91A70871',NULL,NULL,NULL,NULL),
-(55006,4,4,0,NULL,NULL,'D13B75D1E7848DFBB61AB5D9FEE51B49',NULL,NULL,NULL,NULL),
-(55056,4,4,0,NULL,NULL,'209BEEBBBFE6AA3AE491D9D1F1A7C98A',NULL,NULL,NULL,NULL),
-(55141,4,4,0,NULL,NULL,'102810005F13A3440705DE344DF5633F',NULL,NULL,NULL,NULL),
-(55262,4,4,0,NULL,NULL,'EB4B58AF1B3B79DDD9E2477BA1375D42',NULL,NULL,NULL,NULL),
-(55460,4,4,0,NULL,NULL,'E5455F750394046CC9BD2ED0397F7418',NULL,NULL,NULL,NULL),
-(55613,4,4,0,NULL,NULL,'0BA3BFF2E324FE30D15BA8A88CF8738B',NULL,NULL,NULL,NULL),
-(55639,4,4,0,NULL,NULL,'FFD74533A9D95E1D38C972BA4F351B8D',NULL,NULL,NULL,NULL),
-(56014,4,4,0,NULL,NULL,'89AD7A75E156374D41F0CC70455B2F6B',NULL,NULL,NULL,NULL);
+(5875,1,12,1,NULL),
+(6005,1,12,2,NULL),
+(6141,1,12,3,NULL),
+(8606,2,4,3,NULL),
+(9947,3,1,3,NULL),
+(10505,3,2,2,'a'),
+(11159,3,3,0,'a'),
+(11403,3,3,2,NULL),
+(11723,3,3,3,'a'),
+(12340,3,3,5,'a'),
+(13623,4,0,6,'a'),
+(13930,3,3,5,'a'),
+(14545,4,2,2,NULL),
+(15595,4,3,4,NULL),
+(19116,6,0,3,NULL),
+(19243,6,0,3,NULL),
+(19342,6,0,3,NULL),
+(19702,6,1,0,NULL),
+(19802,6,1,2,NULL),
+(19831,6,1,2,NULL),
+(19865,6,1,2,NULL),
+(20182,6,2,0,'a'),
+(20201,6,2,0,NULL),
+(20216,6,2,0,NULL),
+(20253,6,2,0,NULL),
+(20338,6,2,0,NULL),
+(20444,6,2,2,NULL),
+(20490,6,2,2,'a'),
+(20574,6,2,2,'a'),
+(20726,6,2,3,NULL),
+(20779,6,2,3,NULL),
+(20886,6,2,3,NULL),
+(21355,6,2,4,NULL),
+(21463,6,2,4,NULL),
+(21742,6,2,4,NULL),
+(22248,7,0,3,NULL),
+(22293,7,0,3,NULL),
+(22345,7,0,3,NULL),
+(22410,7,0,3,NULL),
+(22423,7,0,3,NULL),
+(22498,7,0,3,NULL),
+(22522,7,0,3,NULL),
+(22566,7,0,3,NULL),
+(22594,7,0,3,NULL),
+(22624,7,0,3,NULL),
+(22747,7,0,3,NULL),
+(22810,7,0,3,NULL),
+(22900,7,1,0,NULL),
+(22908,7,1,0,NULL),
+(22950,7,1,0,NULL),
+(22995,7,1,0,NULL),
+(22996,7,1,0,NULL),
+(23171,7,1,0,NULL),
+(23222,7,1,0,NULL),
+(23360,7,1,5,NULL),
+(23420,7,1,5,NULL),
+(23911,7,2,0,NULL),
+(23937,7,2,0,NULL),
+(24015,7,2,0,NULL),
+(24330,7,2,5,NULL),
+(24367,7,2,5,NULL),
+(24415,7,2,5,NULL),
+(24430,7,2,5,NULL),
+(24461,7,2,5,NULL),
+(24742,7,2,5,NULL),
+(25549,7,3,2,NULL),
+(25996,7,3,5,NULL),
+(26124,7,3,5,NULL),
+(26365,7,3,5,NULL),
+(26654,7,3,5,NULL),
+(26822,7,3,5,NULL),
+(26899,7,3,5,NULL),
+(26972,7,3,5,NULL),
+(28153,8,0,1,NULL),
+(30706,8,1,5,NULL),
+(30993,8,2,0,NULL),
+(31229,8,2,0,NULL),
+(31429,8,2,0,NULL),
+(31478,8,2,0,NULL),
+(32305,8,2,5,NULL),
+(32494,8,2,5,NULL),
+(32580,8,2,5,NULL),
+(32638,8,2,5,NULL),
+(32722,8,2,5,NULL),
+(32750,8,2,5,NULL),
+(32978,8,2,5,NULL),
+(33369,8,3,0,NULL),
+(33528,8,3,0,NULL),
+(33724,8,3,0,NULL),
+(33775,8,3,0,NULL),
+(33941,8,3,0,NULL),
+(34220,8,3,0,NULL),
+(34601,8,3,0,NULL),
+(34769,8,3,0,NULL),
+(34963,8,3,0,NULL),
+(35249,8,3,7,NULL),
+(35284,8,3,7,NULL),
+(35435,8,3,7,NULL),
+(35662,8,3,7,NULL),
+(36753,9,0,2,NULL),
+(36839,9,0,2,NULL),
+(36949,9,0,2,NULL),
+(37142,9,0,2,NULL),
+(37176,9,0,2,NULL),
+(37474,9,0,2,NULL),
+(38134,9,0,5,NULL),
+(38556,9,0,5,NULL),
+(39653,9,1,0,NULL),
+(39804,9,1,0,NULL),
+(40000,9,1,0,NULL),
+(40120,9,1,0,NULL),
+(40443,9,1,0,NULL),
+(40593,9,1,0,NULL),
+(40725,9,1,0,NULL),
+(40906,9,1,5,NULL),
+(40944,9,1,5,NULL),
+(40966,9,1,5,NULL),
+(41031,9,1,5,NULL),
+(41079,9,1,5,NULL),
+(41288,9,1,5,NULL),
+(41323,9,1,5,NULL),
+(41359,9,1,5,NULL),
+(41488,9,1,5,NULL),
+(41793,9,1,5,NULL),
+(42010,9,1,5,NULL),
+(42423,9,2,0,NULL),
+(42488,9,2,0,NULL),
+(42521,9,2,0,NULL),
+(42538,9,2,0,NULL),
+(42560,9,2,0,NULL),
+(42614,9,2,0,NULL),
+(42698,9,2,0,NULL),
+(42825,9,2,0,NULL),
+(42852,9,2,0,NULL),
+(42937,9,2,0,NULL),
+(42979,9,2,0,NULL),
+(43114,9,2,0,NULL),
+(43206,9,2,0,NULL),
+(43340,9,2,0,NULL),
+(43345,9,2,0,NULL),
+(43971,9,2,5,NULL),
+(44015,9,2,5,NULL),
+(44061,9,2,5,NULL),
+(44127,9,2,5,NULL),
+(44232,9,2,5,NULL),
+(44325,9,2,5,NULL),
+(44730,9,2,5,NULL),
+(44908,9,2,5,NULL),
+(45114,9,2,7,NULL),
+(45161,9,2,7,NULL),
+(45338,9,2,7,NULL),
+(45745,9,2,7,NULL),
+(46479,10,0,2,NULL),
+(46658,10,0,2,NULL),
+(46689,10,0,2,NULL),
+(46702,10,0,2,NULL),
+(46741,10,0,2,NULL),
+(46801,10,0,2,NULL),
+(46879,10,0,2,NULL),
+(46924,10,0,2,NULL),
+(47067,10,0,2,NULL),
+(47187,10,0,2,NULL),
+(47213,10,0,2,NULL),
+(47631,10,0,2,NULL),
+(47777,10,0,5,NULL),
+(47799,10,0,5,NULL),
+(47825,10,0,5,NULL),
+(47849,10,0,5,NULL),
+(47871,10,0,5,NULL),
+(47884,10,0,5,NULL),
+(47936,10,0,5,NULL),
+(47967,10,0,5,NULL),
+(48001,10,0,5,NULL),
+(48069,10,0,5,NULL),
+(48317,10,0,5,NULL),
+(48397,10,0,5,NULL),
+(48526,10,0,5,NULL),
+(48676,10,0,7,NULL),
+(48749,10,0,7,NULL),
+(48838,10,0,7,NULL),
+(48865,10,0,7,NULL),
+(48892,10,0,7,NULL),
+(48966,10,0,7,NULL),
+(48999,10,0,7,NULL),
+(49267,10,0,7,NULL),
+(49318,10,1,0,NULL),
+(49343,10,0,7,NULL),
+(49407,10,1,0,NULL),
+(49426,10,1,0,NULL),
+(49444,10,1,0,NULL),
+(49474,10,1,0,NULL),
+(49570,10,1,0,NULL),
+(49679,10,1,0,NULL),
+(49741,10,1,0,NULL),
+(49801,10,1,0,NULL),
+(49890,10,1,0,NULL),
+(50000,10,1,0,NULL),
+(50401,10,1,5,NULL),
+(50438,10,1,5,NULL),
+(50467,10,1,5,NULL),
+(50469,10,1,5,NULL),
+(50504,10,1,5,NULL),
+(50585,10,1,5,NULL),
+(50622,10,1,5,NULL),
+(50747,10,1,5,NULL),
+(50791,10,1,5,NULL),
+(51130,10,1,5,NULL),
+(51187,10,1,7,NULL),
+(51237,10,1,7,NULL),
+(51261,10,1,7,NULL),
+(51313,10,1,7,NULL),
+(51421,10,1,7,NULL),
+(51485,10,1,7,NULL),
+(51536,10,1,7,NULL),
+(51754,10,1,7,NULL),
+(51886,10,1,7,NULL),
+(51972,10,1,7,NULL),
+(52038,10,2,0,NULL),
+(52068,10,2,0,NULL),
+(52095,10,2,0,NULL),
+(52106,10,2,0,NULL),
+(52129,10,2,0,NULL),
+(52148,10,2,0,NULL),
+(52188,10,2,0,NULL),
+(52301,10,2,0,NULL),
+(52393,10,2,0,NULL),
+(52485,10,2,0,NULL),
+(52545,10,2,0,NULL),
+(52607,10,2,0,NULL),
+(52649,10,2,0,NULL),
+(52808,10,2,0,NULL),
+(52902,10,2,5,NULL),
+(52968,10,2,5,NULL),
+(52983,10,2,5,NULL),
+(53007,10,2,5,NULL),
+(53040,10,2,5,NULL),
+(53104,10,2,5,NULL),
+(53162,10,2,5,NULL),
+(53212,10,2,5,NULL),
+(53262,10,2,5,NULL),
+(53441,10,2,5,NULL),
+(53584,10,2,5,NULL),
+(53627,4,4,0,NULL),
+(53750,4,4,0,NULL),
+(53863,4,4,0,NULL),
+(54027,4,4,0,NULL),
+(54737,4,4,0,NULL),
+(54851,4,4,0,NULL),
+(54901,4,4,0,NULL),
+(55006,4,4,0,NULL),
+(55056,4,4,0,NULL),
+(55141,4,4,0,NULL),
+(55262,4,4,0,NULL),
+(55460,4,4,0,NULL),
+(55613,4,4,0,NULL),
+(55639,4,4,0,NULL),
+(56014,4,4,0,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2839,7 +3105,8 @@ INSERT INTO `updates` VALUES
 ('2024_07_18_00_auth.sql','14FE2B8507519A7D7D21A6E3CFEDD6D40A9F689D','RELEASED','2024-07-18 22:44:20',0),
 ('2024_08_09_00_auth.sql','3088FE594C953A1845B5A95A6F104A8EEF946D8C','RELEASED','2024-08-09 12:15:53',0),
 ('2024_08_18_00_auth.sql','5C1D0A3FE0245F4030FE446288AE533556EC6C9E','RELEASED','2024-08-18 20:36:28',0),
-('2024_08_28_01_auth.sql','BC5D74553AF2D92606F55C1C462D2700FE73BD34','RELEASED','2024-08-29 04:45:54',0);
+('2024_08_28_01_auth.sql','BC5D74553AF2D92606F55C1C462D2700FE73BD34','RELEASED','2024-08-29 04:45:54',0),
+('2024_08_30_00_auth.sql','BD76942F1C29AAA2450E051E7CA552672B5E331B','RELEASED','2024-08-30 19:24:30',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql b/sql/updates/auth/cata_classic/2024_08_30_00_auth.sql
new file mode 100644
index 00000000000..2b36c28a3cf
--- /dev/null
+++ b/sql/updates/auth/cata_classic/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/src/server/shared/Realm/ClientBuildInfo.cpp b/src/server/shared/Realm/ClientBuildInfo.cpp
index c2ab1632282..d3d73071802 100644
--- a/src/server/shared/Realm/ClientBuildInfo.cpp
+++ b/src/server/shared/Realm/ClientBuildInfo.cpp
@@ -17,6 +17,7 @@
 
 #include "ClientBuildInfo.h"
 #include "DatabaseEnv.h"
+#include "Log.h"
 #include "Util.h"
 #include <algorithm>
 #include <cctype>
@@ -57,14 +58,7 @@ bool Platform::IsValid(std::string_view platform)
     if (platform.length() > sizeof(uint32))
         return false;
 
-    uint32 platformInt = 0;
-    for (uint8 c : platform)
-    {
-        platformInt <<= 8;
-        platformInt |= c;
-    }
-
-    switch (platformInt)
+    switch (ToFourCC(platform))
     {
         case Win_x86:
         case Win_x64:
@@ -80,17 +74,73 @@ bool Platform::IsValid(std::string_view platform)
     return false;
 }
 
+bool PlatformType::IsValid(std::string_view platformType)
+{
+    if (platformType.length() > sizeof(uint32))
+        return false;
+
+    switch (ToFourCC(platformType))
+    {
+        case Windows:
+        case macOS:
+            return true;
+        default:
+            break;
+    }
+
+    return false;
+}
+
+bool Arch::IsValid(std::string_view arch)
+{
+    if (arch.length() > sizeof(uint32))
+        return false;
+
+    switch (ToFourCC(arch))
+    {
+        case x86:
+        case x64:
+        case Arm32:
+        case Arm64:
+        case WA32:
+            return true;
+        default:
+            break;
+    }
+
+    return false;
+}
+
+bool Type::IsValid(std::string_view type)
+{
+    if (type.length() > sizeof(uint32))
+        return false;
+
+    switch (ToFourCC(type))
+    {
+        case Retail:
+        case RetailChina:
+        case Beta:
+        case BetaRelease:
+        case Ptr:
+        case PtrRelease:
+            return true;
+        default:
+            break;
+    }
+
+    return false;
+}
+
 void LoadBuildInfo()
 {
     Builds.clear();
 
-    //                                                              0             1              2              3      4              5              6
-    if (QueryResult result = LoginDatabase.Query("SELECT majorVersion, minorVersion, bugfixVersion, hotfixVersion, build, win64AuthSeed, mac64AuthSeed, macArmAuthSeed FROM build_info ORDER BY build ASC"))
+    //                                                              0             1              2              3      4
+    if (QueryResult result = LoginDatabase.Query("SELECT majorVersion, minorVersion, bugfixVersion, hotfixVersion, build FROM build_info ORDER BY build ASC"))
     {
         do
         {
-            using namespace ClientBuild;
-
             Field* fields = result->Fetch();
             Info& build = Builds.emplace_back();
             build.MajorVersion = fields[0].GetUInt32();
@@ -103,30 +153,50 @@ void LoadBuildInfo()
                 build.HotfixVersion = { };
 
             build.Build = fields[4].GetUInt32();
-            std::string win64AuthSeedHexStr = fields[5].GetString();
-            if (win64AuthSeedHexStr.length() == AuthKey::Size * 2)
+
+        } while (result->NextRow());
+    }
+
+    //                                                        0           1       2       3      4
+    if (QueryResult result = LoginDatabase.Query("SELECT `build`, `platform`, `arch`, `type`, `key` FROM `build_auth_key`"))
+    {
+        do
+        {
+            Field* fields = result->Fetch();
+
+            uint32 build = fields[0].GetInt32();
+            auto buildInfo = std::ranges::find(Builds, build, &Info::Build);
+            if (buildInfo == Builds.end())
+            {
+                TC_LOG_ERROR("sql.sql", "ClientBuild::LoadBuildInfo: Unknown `build` {} in `build_auth_key` - missing from `build_info`, skipped.", build);
+                continue;
+            }
+
+            std::string_view platformType = fields[1].GetStringView();
+            if (!PlatformType::IsValid(platformType))
             {
-                AuthKey& buildKey = build.AuthKeys.emplace_back();
-                buildKey.Variant = { .Platform = PlatformType::Windows, .Arch = Arch::x64, .Type = Type::Retail };
-                HexStrToByteArray(win64AuthSeedHexStr, buildKey.Key);
+                TC_LOG_ERROR("sql.sql", "ClientBuild::LoadBuildInfo: Invalid platform {} for `build` {} in `build_auth_key`, skipped.", platformType, build);
+                continue;
             }
 
-            std::string mac64AuthSeedHexStr = fields[6].GetString();
-            if (mac64AuthSeedHexStr.length() == AuthKey::Size * 2)
+            std::string_view arch = fields[2].GetStringView();
+            if (!Arch::IsValid(arch))
             {
-                AuthKey& buildKey = build.AuthKeys.emplace_back();
-                buildKey.Variant = { .Platform = PlatformType::macOS, .Arch = Arch::x64, .Type = Type::Retail };
-                HexStrToByteArray(mac64AuthSeedHexStr, buildKey.Key);
+                TC_LOG_ERROR("sql.sql", "ClientBuild::LoadBuildInfo: Invalid `arch` {} for `build` {} in `build_auth_key`, skipped.", arch, build);
+                continue;
             }
 
-            std::string macArmAuthSeedHexStr = fields[7].GetString();
-            if (macArmAuthSeedHexStr.length() == AuthKey::Size * 2)
+            std::string_view type = fields[3].GetStringView();
+            if (!Type::IsValid(type))
             {
-                AuthKey& buildKey = build.AuthKeys.emplace_back();
-                buildKey.Variant = { .Platform = PlatformType::macOS, .Arch = Arch::Arm64, .Type = Type::Retail };
-                HexStrToByteArray(macArmAuthSeedHexStr, buildKey.Key);
+                TC_LOG_ERROR("sql.sql", "ClientBuild::LoadBuildInfo: Invalid `type` {} for `build` {} in `build_auth_key`, skipped.", type, build);
+                continue;
             }
 
+            AuthKey& buildKey = buildInfo->AuthKeys.emplace_back();
+            buildKey.Variant = { .Platform = ToFourCC(platformType), .Arch = ToFourCC(arch), .Type = ToFourCC(type) };
+            buildKey.Key = fields[4].GetBinary<AuthKey::Size>();
+
         } while (result->NextRow());
     }
 }
diff --git a/src/server/shared/Realm/ClientBuildInfo.h b/src/server/shared/Realm/ClientBuildInfo.h
index 9d99c28b744..56acd3af3de 100644
--- a/src/server/shared/Realm/ClientBuildInfo.h
+++ b/src/server/shared/Realm/ClientBuildInfo.h
@@ -25,21 +25,25 @@
 
 namespace ClientBuild
 {
-consteval uint32 operator""_fourcc(char const* chars, std::size_t length)
+inline constexpr uint32 ToFourCC(std::string_view text)
 {
-    if (length > sizeof(uint32))
-        throw "Text can only be max 4 characters long";
-
     uint32 uintValue = 0;
-    for (uint8 c : std::string_view(chars, length))
+    for (uint8 c : text)
     {
         uintValue <<= 8;
         uintValue |= c;
     }
-
     return uintValue;
 }
 
+consteval uint32 operator""_fourcc(char const* chars, std::size_t length)
+{
+    if (length > sizeof(uint32))
+        throw "Text can only be max 4 characters long";
+
+    return ToFourCC({ chars, length });
+}
+
 TC_SHARED_API std::array<char, 5> ToCharArray(uint32 value);
 
 namespace Platform
@@ -58,6 +62,8 @@ namespace PlatformType
 {
     inline constexpr uint32 Windows     = "Win"_fourcc;
     inline constexpr uint32 macOS       = "Mac"_fourcc;
+
+    TC_SHARED_API bool IsValid(std::string_view platformType);
 }
 
 namespace Arch
@@ -67,6 +73,8 @@ namespace Arch
     inline constexpr uint32 Arm32       = "A32"_fourcc;
     inline constexpr uint32 Arm64       = "A64"_fourcc;
     inline constexpr uint32 WA32        = "WA32"_fourcc;
+
+    TC_SHARED_API bool IsValid(std::string_view arch);
 }
 
 namespace Type
@@ -77,6 +85,8 @@ namespace Type
     inline constexpr uint32 BetaRelease = "WoWE"_fourcc;
     inline constexpr uint32 Ptr         = "WoWT"_fourcc;
     inline constexpr uint32 PtrRelease  = "WoWR"_fourcc;
+
+    TC_SHARED_API bool IsValid(std::string_view type);
 }
 
 struct VariantId