diff options
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/auth/master/2025_10_10_00_auth.sql | 33 | ||||
| -rw-r--r-- | sql/updates/characters/master/2025_10_10_00_characters.sql | 3 | ||||
| -rw-r--r-- | sql/updates/hotfixes/master/2025_10_10_00_hotfixes.sql | 101 |
3 files changed, 137 insertions, 0 deletions
diff --git a/sql/updates/auth/master/2025_10_10_00_auth.sql b/sql/updates/auth/master/2025_10_10_00_auth.sql new file mode 100644 index 00000000000..cf4dd7571dd --- /dev/null +++ b/sql/updates/auth/master/2025_10_10_00_auth.sql @@ -0,0 +1,33 @@ +DELETE FROM `build_info` WHERE `build` IN (63506,63660,63704); +INSERT INTO `build_info` (`build`,`majorVersion`,`minorVersion`,`bugfixVersion`,`hotfixVersion`) VALUES +(63506,11,2,5,NULL), +(63660,11,2,5,NULL), +(63704,11,2,5,NULL); + +DELETE FROM `build_auth_key` WHERE `build` IN (63506,63660,63704); +INSERT INTO `build_auth_key` (`build`,`platform`,`arch`,`type`,`key`) VALUES +(63506,'Mac','A64','WoW',0xDE529C1341CA640EC839ED26BF4E1F15), +(63506,'Mac','A64','WoWC',0x77AC8716911DCEA2DB5F87215A2D6090), +(63506,'Mac','x64','WoW',0x3F2314EB0EE2A8A0C2C830E52C9BD5B3), +(63506,'Mac','x64','WoWC',0x20D2A070B78BFDEE73827C80CEDBDC16), +(63506,'Win','A64','WoW',0x6D5DC638BF4AE6BDC34AB8624AEA49A7), +(63506,'Win','x64','WoW',0x68631E3B12CE5AA4839C46B9C70EF231), +(63506,'Win','x64','WoWC',0x2D3D993AF54F07CC108463F88016FAFF), +(63660,'Mac','A64','WoW',0xA5FD60B6FE600DCD41DAD4DFFCF3CA0F), +(63660,'Mac','A64','WoWC',0xC33A55FFC1AB8C5CB6D2C9175F4D3018), +(63660,'Mac','x64','WoW',0x5BA8FC2098BBBD9FB30178B95B616DA6), +(63660,'Mac','x64','WoWC',0x52BA0A6B2432D7584F597AFD1638C085), +(63660,'Win','A64','WoW',0x58CDF4DAAF8EA1211A1514FBC4F668B5), +(63660,'Win','x64','WoW',0xD613DF0CB4BE97E954BD4C8F0DCC0B3C), +(63660,'Win','x64','WoWC',0x767FAAF58A1E698927D9226DEAABADC3), +(63704,'Mac','A64','WoW',0x88A6E7FA99D6E842FFB4DB126A505DA0), +(63704,'Mac','A64','WoWC',0x0BF4F67CDA8D398FA96A6330FD5B331A), +(63704,'Mac','x64','WoW',0x186CCDAFD21B074CBFD5C4960A1397F9), +(63704,'Mac','x64','WoWC',0xF6BA093EE09B78DC5E70FFA78ECAE49C), +(63704,'Win','A64','WoW',0x855B9CFD0785A946AFAEEF2CF7B988CC), +(63704,'Win','x64','WoW',0x7CB483EBD52970D0CBBB7952036CEAFA), +(63704,'Win','x64','WoWC',0x4985EB04D5FE1D78EB0CC7D490EF6E79); + +UPDATE `realmlist` SET `gamebuild`=63704 WHERE `gamebuild`=63305; + +ALTER TABLE `realmlist` CHANGE `gamebuild` `gamebuild` int unsigned NOT NULL DEFAULT '63704'; diff --git a/sql/updates/characters/master/2025_10_10_00_characters.sql b/sql/updates/characters/master/2025_10_10_00_characters.sql new file mode 100644 index 00000000000..0c8b8bfc61e --- /dev/null +++ b/sql/updates/characters/master/2025_10_10_00_characters.sql @@ -0,0 +1,3 @@ +ALTER TABLE `character_trait_config` ADD `variationId` int DEFAULT NULL AFTER `traitSystemId`; + +UPDATE `character_trait_config` SET `variationId`=0 WHERE `type`=3; diff --git a/sql/updates/hotfixes/master/2025_10_10_00_hotfixes.sql b/sql/updates/hotfixes/master/2025_10_10_00_hotfixes.sql new file mode 100644 index 00000000000..6756e64e38a --- /dev/null +++ b/sql/updates/hotfixes/master/2025_10_10_00_hotfixes.sql @@ -0,0 +1,101 @@ +ALTER TABLE `area_table` MODIFY `PvpCombatWorldStateID` int NOT NULL DEFAULT 0 AFTER `MountFlags`; + +ALTER TABLE `broadcast_text` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `EmotesID`; + +ALTER TABLE `chr_specialization` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `Role`; + +ALTER TABLE `content_tuning` ADD `PrimaryStatScalingModPlayerDataElementCharacterID` int NOT NULL DEFAULT 0 AFTER `DamagePrimaryStatCurveID`; +ALTER TABLE `content_tuning` ADD `PrimaryStatScalingModPlayerDataElementCharacterMultiplier` float NOT NULL DEFAULT 0 AFTER `PrimaryStatScalingModPlayerDataElementCharacterID`; + +ALTER TABLE `curve` MODIFY `Flags` int NOT NULL DEFAULT 0 AFTER `Type`; + +ALTER TABLE `curve_point` MODIFY `OrderIndex` int UNSIGNED NOT NULL DEFAULT 0 AFTER `CurveID`; + +ALTER TABLE `item` MODIFY `ItemGroupSoundsID` int UNSIGNED NOT NULL DEFAULT 0 AFTER `IconFileDataID`; + +ALTER TABLE `item_bonus_tree_node` ADD `ItemCreationContextGroupID` int NOT NULL DEFAULT 0 AFTER `MaxMythicPlusLevel`; +ALTER TABLE `item_bonus_tree_node` ADD `Flags` int NOT NULL DEFAULT 0 AFTER `ItemCreationContextGroupID`; + +-- +-- Table structure for table `item_creation_context` +-- +DROP TABLE IF EXISTS `item_creation_context`; +CREATE TABLE `item_creation_context` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', + `ItemCreationContextGroupID` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `item_offset_curve` +-- +DROP TABLE IF EXISTS `item_offset_curve`; +CREATE TABLE `item_offset_curve` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `CurveID` int NOT NULL DEFAULT '0', + `Offset` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +-- +-- Table structure for table `item_scaling_config` +-- +DROP TABLE IF EXISTS `item_scaling_config`; +CREATE TABLE `item_scaling_config` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `ItemOffsetCurveID` int NOT NULL DEFAULT '0', + `ItemLevel` int NOT NULL DEFAULT '0', + `RequiredLevel` int NOT NULL DEFAULT '0', + `Unknown1125` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +ALTER TABLE `item_sparse` ADD `ItemLevelOffsetCurveID` int NOT NULL DEFAULT 0 AFTER `PlayerLevelToItemLevelCurveID`; +ALTER TABLE `item_sparse` ADD `ItemLevelOffsetItemLevel` int NOT NULL DEFAULT 0 AFTER `ItemLevelOffsetCurveID`; + +ALTER TABLE `player_condition` MODIFY `Achievement1` int UNSIGNED NOT NULL DEFAULT 0 AFTER `AuraStacks4`; +ALTER TABLE `player_condition` MODIFY `Achievement2` int UNSIGNED NOT NULL DEFAULT 0 AFTER `Achievement1`; +ALTER TABLE `player_condition` MODIFY `Achievement3` int UNSIGNED NOT NULL DEFAULT 0 AFTER `Achievement2`; +ALTER TABLE `player_condition` MODIFY `Achievement4` int UNSIGNED NOT NULL DEFAULT 0 AFTER `Achievement3`; + +ALTER TABLE `player_data_element_account` ADD `Unknown1125` int NOT NULL DEFAULT 0 AFTER `Type`; + +ALTER TABLE `player_data_element_character` ADD `Unknown1125` int NOT NULL DEFAULT 0 AFTER `Type`; + +ALTER TABLE `player_data_flag_account` ADD `Unknown1125` int NOT NULL DEFAULT 0 AFTER `Unknown1107`; + +ALTER TABLE `player_data_flag_character` ADD `Unknown1125` int NOT NULL DEFAULT 0 AFTER `Unknown1107`; + +ALTER TABLE `scene_script` MODIFY `FirstSceneScriptID` int UNSIGNED NOT NULL DEFAULT 0 AFTER `ID`; +ALTER TABLE `scene_script` MODIFY `NextSceneScriptID` int UNSIGNED NOT NULL DEFAULT 0 AFTER `FirstSceneScriptID`; + +ALTER TABLE `spell_categories` MODIFY `DefenseType` int NOT NULL DEFAULT 0 AFTER `Category`; +ALTER TABLE `spell_categories` MODIFY `PreventionType` int NOT NULL DEFAULT 0 AFTER `Mechanic`; + +ALTER TABLE `spell_interrupts` MODIFY `InterruptFlags` int NOT NULL DEFAULT 0 AFTER `DifficultyID`; + +ALTER TABLE `trait_cost` ADD `CurveID` int NOT NULL DEFAULT 0 AFTER `TraitCurrencyID`; + +ALTER TABLE `trait_currency` ADD `PlayerDataElementAccountID` int NOT NULL DEFAULT 0 AFTER `Icon`; +ALTER TABLE `trait_currency` ADD `PlayerDataElementCharacterID` int NOT NULL DEFAULT 0 AFTER `PlayerDataElementAccountID`; + +-- +-- Table structure for table `trait_system` +-- +DROP TABLE IF EXISTS `trait_system`; +CREATE TABLE `trait_system` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `WidgetSetID` int NOT NULL DEFAULT '0', + `TraitChangeSpell` int NOT NULL DEFAULT '0', + `ItemID` int NOT NULL DEFAULT '0', + `VariationType` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + +ALTER TABLE `ui_map_assignment` ADD `Unknown1125` int NOT NULL DEFAULT 0 AFTER `WmoGroupID`; |