Core: Update to 10.1

3 files changed, 34 insertions, 0 deletions

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`;