aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/base/auth_database.sql35
-rw-r--r--sql/base/characters_database.sql4
-rw-r--r--sql/updates/auth/master/2025_10_10_00_auth.sql33
-rw-r--r--sql/updates/characters/master/2025_10_10_00_characters.sql3
-rw-r--r--sql/updates/hotfixes/master/2025_10_10_00_hotfixes.sql101
5 files changed, 170 insertions, 6 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index 8b68665b886..c1bc7bdea88 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1278,7 +1278,28 @@ INSERT INTO `build_auth_key` VALUES
(63305,'Mac','x64','WoWC',0x0D600A97C7207828F2DEC0DCA49BC0A8),
(63305,'Win','A64','WoW',0xBA66EFD522EB2CDC8D3FF9184BCD91CA),
(63305,'Win','x64','WoW',0x93C43B6A6902CA37F15C68AAB8E69321),
-(63305,'Win','x64','WoWC',0x47BBB811D2AC4DA0D74FEFC0DD32940E);
+(63305,'Win','x64','WoWC',0x47BBB811D2AC4DA0D74FEFC0DD32940E),
+(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);
/*!40000 ALTER TABLE `build_auth_key` ENABLE KEYS */;
UNLOCK TABLES;
@@ -1684,7 +1705,10 @@ INSERT INTO `build_info` VALUES
(62958,11,2,0,NULL),
(63003,11,2,0,NULL),
(63163,11,2,0,NULL),
-(63305,11,2,0,NULL);
+(63305,11,2,0,NULL),
+(63506,11,2,5,NULL),
+(63660,11,2,5,NULL),
+(63704,11,2,5,NULL);
/*!40000 ALTER TABLE `build_info` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3297,7 +3321,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 '63305',
+ `gamebuild` int unsigned NOT NULL DEFAULT '63704',
`Region` tinyint unsigned NOT NULL DEFAULT '1',
`Battlegroup` tinyint unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
@@ -3312,7 +3336,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,63305,1,1);
+(1,'Trinity','127.0.0.1','127.0.0.1',NULL,NULL,'255.255.255.0',8085,0,0,1,0,0,63704,1,1);
/*!40000 ALTER TABLE `realmlist` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3832,7 +3856,8 @@ INSERT INTO `updates` VALUES
('2025_09_03_00_auth.sql','E32EA92D13EBDB5A6DF5101BDA89D89B782EBBAA','RELEASED','2025-09-03 20:30:58',0),
('2025_09_04_00_auth.sql','B002D8EC5D883576ECC575DC545881837AB66FD3','RELEASED','2025-09-04 21:43:14',0),
('2025_09_12_00_auth.sql','B95D44F12BA980040BAEB982B01D359B55C2EA2B','RELEASED','2025-09-12 23:13:31',0),
-('2025_09_20_00_auth.sql','752B003BBEBDDD3E1BBFB342AD154EB50D5E6DC9','RELEASED','2025-09-20 01:31:35',0);
+('2025_09_20_00_auth.sql','752B003BBEBDDD3E1BBFB342AD154EB50D5E6DC9','RELEASED','2025-09-20 01:31:35',0),
+('2025_10_10_00_auth.sql','D2CCA4D100F71481C1AD347EE00D025BF873B2F2','RELEASED','2025-10-10 00:02:43',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index f7459ab4aa2..5b79fafc964 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1849,6 +1849,7 @@ CREATE TABLE `character_trait_config` (
`localIdentifier` int DEFAULT NULL,
`skillLineId` int DEFAULT NULL,
`traitSystemId` int DEFAULT NULL,
+ `variationId` int DEFAULT NULL,
`name` varchar(260) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`guid`,`traitConfigId`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -3824,7 +3825,8 @@ INSERT INTO `updates` VALUES
('2025_08_13_00_characters.sql','0A559553A1DD9FC973AB01C3B1A9284B07CFBB36','ARCHIVED','2025-08-12 20:17:45',0),
('2025_08_16_00_characters.sql','8DF6284B6C7BEDAB599F7E4802FF8BCD80613A92','ARCHIVED','2025-08-16 14:58:22',0),
('2025_08_19_00_characters.sql','EC197D88883CDA2B885675FE096DD56CCB143608','RELEASED','2025-08-19 01:03:26',0),
-('2025_09_09_00_characters.sql','CF3F0738623248620204175B049AAF0833262222','RELEASED','2025-09-09 14:11:21',0);
+('2025_09_09_00_characters.sql','CF3F0738623248620204175B049AAF0833262222','RELEASED','2025-09-09 14:11:21',0),
+('2025_10_10_00_characters.sql','F1EF875805AF1E87A413387F5449FE37D5205E94','RELEASED','2025-10-09 23:58:44',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
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`;