Core: Update to 10.1

5 files changed, 50 insertions, 5 deletions

diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 8dfac2b3365..0be52bedd87 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -707,7 +707,10 @@ INSERT INTO `build_info` VALUES
 (48966,10,0,7,NULL,NULL,'823142CA131FBB715FF55D4343E55C6D',NULL,NULL,NULL),
 (48999,10,0,7,NULL,NULL,'79BA6FF0F9672EEF875F64155C8B62D4',NULL,NULL,NULL),
 (49267,10,0,7,NULL,NULL,'EEE77EA5A216E0731ADBB41AEFB1DF31',NULL,NULL,NULL),
-(49343,10,0,7,NULL,NULL,'301A0B4C0942B9B6F605B903AD6C1F60',NULL,NULL,NULL);
+(49343,10,0,7,NULL,NULL,'301A0B4C0942B9B6F605B903AD6C1F60',NULL,NULL,NULL),
+(49318,10,1,0,NULL,NULL,'AF439AEE62EE48B36C1725111E3D9BBF',NULL,NULL,NULL),
+(49407,10,1,0,NULL,NULL,'6413820DC9885BB0693B37090CBB2F30',NULL,NULL,NULL),
+(49426,10,1,0,NULL,NULL,'D85EDFBFE9A94A55E2B4510BE41C19B2',NULL,NULL,NULL);
 /*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2315,7 +2318,7 @@ CREATE TABLE `realmlist` (
   `timezone` tinyint unsigned NOT NULL DEFAULT '0',
   `allowedSecurityLevel` tinyint unsigned NOT NULL DEFAULT '0',
   `population` float unsigned NOT NULL DEFAULT '0',
-  `gamebuild` int unsigned NOT NULL DEFAULT '49343',
+  `gamebuild` int unsigned NOT NULL DEFAULT '49426',
   `Region` tinyint unsigned NOT NULL DEFAULT '1',
   `Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
   PRIMARY KEY (`id`),
@@ -2330,7 +2333,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','255.255.255.0',8085,0,0,1,0,0,49343,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1','255.255.255.0',8085,0,0,1,0,0,49426,1,1);
 /*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2686,7 +2689,8 @@ INSERT INTO `updates` VALUES
 ('2023_04_06_00_auth.sql','FECA06F32D077B1660D9FF8204D94F5C8E4065B4','RELEASED','2023-04-06 04:18:58',0),
 ('2023_04_12_00_auth.sql','E28F892FCC2A923683E5EEE24E98C618A9534318','RELEASED','2023-04-12 00:26:10',0),
 ('2023_04_25_00_auth.sql','AF297F37715F4A4C84E84182358C26CA83B0C655','RELEASED','2023-04-25 11:14:36',0),
-('2023_04_28_00_auth.sql','A686A23CE63EE116F0F100F93ABB07CD0450E937','RELEASED','2023-04-28 01:50:20',0);
+('2023_04_28_00_auth.sql','A686A23CE63EE116F0F100F93ABB07CD0450E937','RELEASED','2023-04-28 01:50:20',0),
+('2023_05_04_00_auth.sql','1015EC7619C1F43B9FD70C8971F883D0CBF4D002','RELEASED','2023-05-04 16:02:32',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 28744467d85..77de88e7914 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1668,6 +1668,9 @@ CREATE TABLE `character_stats` (
   `maxpower5` int unsigned NOT NULL DEFAULT '0',
   `maxpower6` int unsigned NOT NULL DEFAULT '0',
   `maxpower7` int unsigned NOT NULL DEFAULT '0',
+  `maxpower8` int unsigned NOT NULL DEFAULT '0',
+  `maxpower9` int unsigned NOT NULL DEFAULT '0',
+  `maxpower10` int unsigned NOT NULL DEFAULT '0',
   `strength` int unsigned NOT NULL DEFAULT '0',
   `agility` int unsigned NOT NULL DEFAULT '0',
   `stamina` int unsigned NOT NULL DEFAULT '0',
@@ -1937,6 +1940,9 @@ CREATE TABLE `characters` (
   `power5` int unsigned NOT NULL DEFAULT '0',
   `power6` int unsigned NOT NULL DEFAULT '0',
   `power7` int unsigned NOT NULL DEFAULT '0',
+  `power8` int unsigned NOT NULL DEFAULT '0',
+  `power9` int unsigned NOT NULL DEFAULT '0',
+  `power10` int unsigned NOT NULL DEFAULT '0',
   `latency` int unsigned NOT NULL DEFAULT '0',
   `activeTalentGroup` tinyint unsigned NOT NULL DEFAULT '0',
   `lootSpecId` int unsigned NOT NULL DEFAULT '0',
@@ -3699,7 +3705,8 @@ INSERT INTO `updates` VALUES
 ('2023_01_29_00_characters.sql','24FA9E0F616BF77AC588A25A8A8699903A19A5FE','ARCHIVED','2023-01-29 16:31:12',0),
 ('2023_02_03_00_characters.sql','A04BA4386B3D5C60407D22CA4BF9A4A6258AA39D','ARCHIVED','2023-02-03 01:13:52',0),
 ('2023_02_08_00_characters.sql','C9DF607CCE99540F613F5E25E17090176C995C7C','ARCHIVED','2023-02-08 21:41:17',0),
-('2023_04_02_00_characters.sql','AAC1B81AFE4716CF4DAB6BCF01D22F421BFAD253','ARCHIVED','2023-04-02 01:02:26',0);
+('2023_04_02_00_characters.sql','AAC1B81AFE4716CF4DAB6BCF01D22F421BFAD253','ARCHIVED','2023-04-02 01:02:26',0),
+('2023_05_04_00_characters.sql','9AC370E51507F5BD368707E90D8F6BF0FF16CA09','RELEASED','2023-05-04 16:17:31',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/auth/master/2023_05_04_00_auth.sql b/sql/updates/auth/master/2023_05_04_00_auth.sql
new file mode 100644
index 00000000000..c081beddc8c
--- /dev/null
+++ b/sql/updates/auth/master/2023_05_04_00_auth.sql
@@ -0,0 +1,9 @@
+DELETE FROM `build_info` WHERE `build` IN (49318,49407,49426);
+INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`,`winAuthSeed`,`win64AuthSeed`,`mac64AuthSeed`,`winChecksumSeed`,`macChecksumSeed`) VALUES
+(49318,10,1,0,NULL,NULL,'AF439AEE62EE48B36C1725111E3D9BBF',NULL,NULL,NULL),
+(49407,10,1,0,NULL,NULL,'6413820DC9885BB0693B37090CBB2F30',NULL,NULL,NULL),
+(49426,10,1,0,NULL,NULL,'D85EDFBFE9A94A55E2B4510BE41C19B2',NULL,NULL,NULL);
+
+UPDATE `realmlist` SET `gamebuild`=49426 WHERE `gamebuild`=49343;
+
+ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '49426';
diff --git a/sql/updates/characters/master/2023_05_04_00_characters.sql b/sql/updates/characters/master/2023_05_04_00_characters.sql
new file mode 100644
index 00000000000..39c40b14220
--- /dev/null
+++ b/sql/updates/characters/master/2023_05_04_00_characters.sql
@@ -0,0 +1,8 @@
+
+ALTER TABLE `characters` ADD `power8` int unsigned NOT NULL DEFAULT 0 AFTER `power7`;
+ALTER TABLE `characters` ADD `power9` int unsigned NOT NULL DEFAULT 0 AFTER `power8`;
+ALTER TABLE `characters` ADD `power10` int unsigned NOT NULL DEFAULT 0 AFTER `power9`;
+
+ALTER TABLE `character_stats` ADD `maxpower8` int unsigned NOT NULL DEFAULT 0 AFTER `maxpower7`;
+ALTER TABLE `character_stats` ADD `maxpower9` int unsigned NOT NULL DEFAULT 0 AFTER `maxpower8`;
+ALTER TABLE `character_stats` ADD `maxpower10` int unsigned NOT NULL DEFAULT 0 AFTER `maxpower9`;
diff --git a/sql/updates/hotfixes/master/2023_05_04_00_hotfixes.sql b/sql/updates/hotfixes/master/2023_05_04_00_hotfixes.sql
new file mode 100644
index 00000000000..d54b7a19318
--- /dev/null
+++ b/sql/updates/hotfixes/master/2023_05_04_00_hotfixes.sql
@@ -0,0 +1,17 @@
+ALTER TABLE `chr_customization_choice` ADD `SoundKitID` int NOT NULL DEFAULT 0 AFTER `AddedInPatch`;
+
+ALTER TABLE `chr_customization_element` ADD `AnimKitID` int NOT NULL DEFAULT 0 AFTER `ChrCustomizationVoiceID`;
+
+ALTER TABLE `content_tuning` ADD `QuestXpMultiplier` float NOT NULL DEFAULT 0 AFTER `MinItemLevel`;
+
+ALTER TABLE `curve_point` MODIFY `CurveID` int NOT NULL DEFAULT 0 AFTER `ID`;
+
+ALTER TABLE `item_bonus_tree_node` ADD `Unknown1010_1` int NOT NULL DEFAULT 0 AFTER `IblGroupPointsModSetID`;
+ALTER TABLE `item_bonus_tree_node` ADD `Unknown1010_2` int NOT NULL DEFAULT 0 AFTER `Unknown1010_1`;
+
+ALTER TABLE `movie` ADD `SubtitleFileFormat` int NOT NULL DEFAULT 0 AFTER `SubtitleFileDataID`;
+
+ALTER TABLE `ui_map` MODIFY `System` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `Flags`;
+ALTER TABLE `ui_map` MODIFY `Type` tinyint UNSIGNED NOT NULL DEFAULT 0 AFTER `System`;
+
+ALTER TABLE `vehicle` MODIFY `FlagsB` int NOT NULL DEFAULT 0 AFTER `Flags`;