Core: Updated to 11.2.0

2 files changed, 68 insertions, 46 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 3d28ebe8f6b..b31dd804ba1 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1188,7 +1188,35 @@ INSERT INTO `build_auth_key` VALUES
 (61967,'Mac','x64','WoWC',0x4DE3D440D1D46A38EC32D0D524004ABA),
 (61967,'Win','A64','WoW',0x7B443BB6B4F355B9E389F4F0ACB04FE8),
 (61967,'Win','x64','WoW',0x6E194B4B53038E76E01E9538107AFF4D),
-(61967,'Win','x64','WoWC',0x9E135BF0B40BDD210EAF318AEB72801C);
+(61967,'Win','x64','WoWC',0x9E135BF0B40BDD210EAF318AEB72801C),
+(62213,'Mac','A64','WoW',0x4EB479A10C122085CFA59633DBCADA17),
+(62213,'Mac','A64','WoWC',0x101F2207C5AB43A29762838FC4C460BA),
+(62213,'Mac','x64','WoW',0x94D5B0A9620333C4F068A5F7FD5E16C6),
+(62213,'Mac','x64','WoWC',0xBAA3BAFC4F9209AFB9EDA4C89DBB506C),
+(62213,'Win','A64','WoW',0xF565E632CBC04516F235F2A412C61569),
+(62213,'Win','x64','WoW',0x062594033EA9753E81240476AB4E21BC),
+(62213,'Win','x64','WoWC',0x8584238F7E35711E8817CD53951478B2),
+(62417,'Mac','A64','WoW',0x020BBBA62C6539043095AE1603FC3A1F),
+(62417,'Mac','A64','WoWC',0xDA7BB5E78E98856A679EB442EB683DD5),
+(62417,'Mac','x64','WoW',0x8D15525965A59F4C1A886E6BCC09D75A),
+(62417,'Mac','x64','WoWC',0x02C9B276B11F9B175A59021B1EB7F9E3),
+(62417,'Win','A64','WoW',0xDC74AF249532EF367023C78F11E6F709),
+(62417,'Win','x64','WoW',0x702FC86D79262CD311393AEB3F5B88E6),
+(62417,'Win','x64','WoWC',0xB97B257A3D69BBA321DEC1427591EAD6),
+(62438,'Mac','A64','WoW',0x5C974D816F1D4806F77A60D125902B11),
+(62438,'Mac','A64','WoWC',0x333EEF08165D098594D01993FB5566C4),
+(62438,'Mac','x64','WoW',0x8EE8E906F3277B995C3FB76A9472316D),
+(62438,'Mac','x64','WoWC',0x2D92FAC97BE1600E3CF7C41C260B90E3),
+(62438,'Win','A64','WoW',0x5F43B9C77DA61431AAF5E527FC6BA0BA),
+(62438,'Win','x64','WoW',0x54B80A79B8A5C515E25366AB57F0ACB0),
+(62438,'Win','x64','WoWC',0xCAE41A1DD7CF9C2E850CE388BB1EEF6D),
+(62493,'Mac','A64','WoW',0x35663EF5187F38257E9768481F1894DC),
+(62493,'Mac','A64','WoWC',0x5A48D3A43278A6EA31B2E3AE0DE6E601),
+(62493,'Mac','x64','WoW',0x1BEEC427C9F41184EFAAC048D51C5207),
+(62493,'Mac','x64','WoWC',0x15B0A1D7EA355891634507CD840B2E16),
+(62493,'Win','A64','WoW',0x043025D94567792FA8284C282E77E57F),
+(62493,'Win','x64','WoW',0x5B038E707AB60E3A862C2E03A8487220),
+(62493,'Win','x64','WoWC',0x1A65B9347FD44EF0A77479173D098226);
 /*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -1581,7 +1609,11 @@ INSERT INTO `build_info` VALUES
 (61491,11,1,7,NULL),
 (61559,11,1,7,NULL),
 (61609,11,1,7,NULL),
-(61967,11,1,7,NULL);
+(61967,11,1,7,NULL),
+(62213,11,2,0,NULL),
+(62417,11,2,0,NULL),
+(62438,11,2,0,NULL),
+(62493,11,2,0,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3194,7 +3226,7 @@ CREATE TABLE `realmlist` (
   `timezone` tinyint unsigned NOT NULL DEFAULT '0',
   `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `population` float NOT NULL DEFAULT '0',
-  `gamebuild` int unsigned NOT NULL DEFAULT '61967',
+  `gamebuild` int unsigned NOT NULL DEFAULT '62493',
   `Region` tinyint unsigned NOT NULL DEFAULT '1',
   `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),
@@ -3209,7 +3241,7 @@ CREATE TABLE `realmlist` (
 LOCK TABLES `realmlist` WRITE;
 /*!40000 ALTER TABLE `realmlist` DISABLE KEYS */;
 INSERT INTO `realmlist` VALUES
-(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,61967,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,62493,1,1);
 /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -3718,7 +3750,8 @@ INSERT INTO `updates` VALUES
 ('2025_06_25_00_auth.sql','27DC7FB423FFB3788082CCFC18D5432650B09FB3','ARCHIVED','2025-06-25 01:15:04',0),
 ('2025_06_27_00_auth.sql','243C89DFED0058323EF9690D124C1F20036D461B','ARCHIVED','2025-06-27 14:22:49',0),
 ('2025_07_14_00_auth.sql','5F975A202CF84F2BFEA366E0BEDF8FA63035CD62','ARCHIVED','2025-07-14 23:10:54',0),
-('2025_07_21_00_auth.sql','44AA781EE1B1C66E8433E50A2E20916EB1BEFE23','ARCHIVED','2025-07-21 22:51:05',0);
+('2025_07_21_00_auth.sql','44AA781EE1B1C66E8433E50A2E20916EB1BEFE23','ARCHIVED','2025-07-21 22:51:05',0),
+('2025_08_13_00_auth.sql','5F67141AB407AEC202E8048765256AB11C5621EA','RELEASED','2025-08-12 19:26:13',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index be834419bdc..a70185ede3d 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -591,6 +591,33 @@ LOCK TABLES `character_aura_stored_location` WRITE;
 UNLOCK TABLES;
 
 --
+-- Table structure for table `character_bank_tab_settings`
+--
+
+DROP TABLE IF EXISTS `character_bank_tab_settings`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `character_bank_tab_settings` (
+  `characterGuid` bigint unsigned NOT NULL,
+  `tabId` tinyint unsigned NOT NULL,
+  `name` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `icon` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `description` varchar(2048) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
+  `depositFlags` int DEFAULT '0',
+  PRIMARY KEY (`characterGuid`,`tabId`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `character_bank_tab_settings`
+--
+
+LOCK TABLES `character_bank_tab_settings` WRITE;
+/*!40000 ALTER TABLE `character_bank_tab_settings` DISABLE KEYS */;
+/*!40000 ALTER TABLE `character_bank_tab_settings` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
 -- Table structure for table `character_banned`
 --
 
@@ -1913,39 +1940,6 @@ LOCK TABLES `character_transmog_outfits` WRITE;
 UNLOCK TABLES;
 
 --
--- Table structure for table `character_void_storage`
---
-
-DROP TABLE IF EXISTS `character_void_storage`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!50503 SET character_set_client = utf8mb4 */;
-CREATE TABLE `character_void_storage` (
-  `itemId` bigint unsigned NOT NULL,
-  `playerGuid` bigint unsigned NOT NULL,
-  `itemEntry` int unsigned NOT NULL,
-  `slot` tinyint unsigned NOT NULL,
-  `creatorGuid` bigint unsigned NOT NULL DEFAULT '0',
-  `randomBonusListId` int unsigned NOT NULL DEFAULT '0',
-  `fixedScalingLevel` int unsigned DEFAULT '0',
-  `artifactKnowledgeLevel` int unsigned DEFAULT '0',
-  `context` tinyint unsigned NOT NULL DEFAULT '0',
-  `bonusListIDs` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
-  PRIMARY KEY (`itemId`),
-  UNIQUE KEY `idx_player_slot` (`playerGuid`,`slot`),
-  KEY `idx_player` (`playerGuid`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `character_void_storage`
---
-
-LOCK TABLES `character_void_storage` WRITE;
-/*!40000 ALTER TABLE `character_void_storage` DISABLE KEYS */;
-/*!40000 ALTER TABLE `character_void_storage` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
 -- Table structure for table `characters`
 --
 
@@ -1971,14 +1965,8 @@ CREATE TABLE `characters` (
   `bagSlotFlags4` int unsigned NOT NULL DEFAULT '0',
   `bagSlotFlags5` int unsigned NOT NULL DEFAULT '0',
   `bankSlots` tinyint unsigned NOT NULL DEFAULT '0',
+  `bankTabs` tinyint unsigned NOT NULL DEFAULT '0',
   `bankBagFlags` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags1` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags2` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags3` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags4` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags5` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags6` int unsigned NOT NULL DEFAULT '0',
-  `bankBagSlotFlags7` int unsigned NOT NULL DEFAULT '0',
   `restState` tinyint unsigned NOT NULL DEFAULT '0',
   `playerFlags` int unsigned NOT NULL DEFAULT '0',
   `playerFlagsEx` int unsigned NOT NULL DEFAULT '0',
@@ -3832,7 +3820,8 @@ INSERT INTO `updates` VALUES
 ('2025_03_29_00_characters.sql','6A49C236D0B8CCD8A5B6B51F60E116B3380772D7','ARCHIVED','2025-03-29 01:12:13',0),
 ('2025_05_31_00_characters.sql','C240EB5C4008B6AA0514802A18D7DD875680DE82','ARCHIVED','2025-05-31 19:45:56',0),
 ('2025_06_27_00_characters.sql','35088BA5BA4BD3B7FAAD6FD4FAE38E52A5B71CD8','ARCHIVED','2025-06-27 14:22:08',0),
-('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0);
+('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0),
+('2025_08_13_00_characters.sql','9C2321777E6C34F18799C8967B1CA0C44F17DA18','RELEASED','2025-08-12 20:17:45',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;