aboutsummaryrefslogtreecommitdiff
path: root/sql/base
diff options
context:
space:
mode:
Diffstat (limited to 'sql/base')
-rw-r--r--sql/base/auth_database.sql33
-rw-r--r--sql/base/characters_database.sql13
-rw-r--r--sql/base/dev/hotfixes_database.sql119
-rw-r--r--sql/base/dev/world_database.sql11
4 files changed, 132 insertions, 44 deletions
diff --git a/sql/base/auth_database.sql b/sql/base/auth_database.sql
index b80a48aa279..f0c270e0c77 100644
--- a/sql/base/auth_database.sql
+++ b/sql/base/auth_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64)
--
-- Host: localhost Database: auth
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.2
+-- Server version 8.0.43-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3872,19 +3872,20 @@ INSERT INTO `updates` VALUES
('2025_07_21_00_auth.sql','44AA781EE1B1C66E8433E50A2E20916EB1BEFE23','ARCHIVED','2025-07-21 22:51:05',0),
('2025_08_13_00_auth.sql','5F67141AB407AEC202E8048765256AB11C5621EA','ARCHIVED','2025-08-12 19:26:13',0),
('2025_08_16_00_auth.sql','DCAB779D0FC212FDF964D055BEC17AC1255A013C','ARCHIVED','2025-08-16 14:58:22',0),
-('2025_08_19_00_auth.sql','A6FCCF57663965E7DDA3796C8C202D4AEBF5C76D','RELEASED','2025-08-19 22:09:06',0),
-('2025_08_20_00_auth.sql','88263DAF5D8BF6B2B8F9D279135B9747E4931B51','RELEASED','2025-08-20 21:27:33',0),
-('2025_08_23_00_auth.sql','4C543EB13488D5885EB41DBC1DF036125C92D999','RELEASED','2025-08-23 14:43:33',0),
-('2025_08_27_00_auth.sql','E7F59ADBE2F6534B226990267061AEFBFA3843FB','RELEASED','2025-08-27 10:16:36',0),
-('2025_08_29_00_auth.sql','222F1E2DE1D898F9A580E94574681B59D40E0402','RELEASED','2025-08-29 10:36:07',0),
-('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_10_10_00_auth.sql','D2CCA4D100F71481C1AD347EE00D025BF873B2F2','RELEASED','2025-10-10 00:02:43',0),
-('2025_10_11_00_auth.sql','9D39A17F4B14666677A409232A73986076FC4108','RELEASED','2025-10-11 12:34:55',0),
-('2025_10_15_00_auth.sql','AD32FF4A48BFC671ED2F17409D4283E2CD3577E1','RELEASED','2025-10-15 09:56:37',0),
-('2025_10_22_00_auth.sql','A363CDF2B9EDED18DA077351CB2B0DC3A9E5E752','RELEASED','2025-10-22 10:32:36',0);
+('2025_08_19_00_auth.sql','A6FCCF57663965E7DDA3796C8C202D4AEBF5C76D','ARCHIVED','2025-08-19 22:09:06',0),
+('2025_08_20_00_auth.sql','88263DAF5D8BF6B2B8F9D279135B9747E4931B51','ARCHIVED','2025-08-20 21:27:33',0),
+('2025_08_23_00_auth.sql','4C543EB13488D5885EB41DBC1DF036125C92D999','ARCHIVED','2025-08-23 14:43:33',0),
+('2025_08_27_00_auth.sql','E7F59ADBE2F6534B226990267061AEFBFA3843FB','ARCHIVED','2025-08-27 10:16:36',0),
+('2025_08_29_00_auth.sql','222F1E2DE1D898F9A580E94574681B59D40E0402','ARCHIVED','2025-08-29 10:36:07',0),
+('2025_09_03_00_auth.sql','E32EA92D13EBDB5A6DF5101BDA89D89B782EBBAA','ARCHIVED','2025-09-03 20:30:58',0),
+('2025_09_04_00_auth.sql','B002D8EC5D883576ECC575DC545881837AB66FD3','ARCHIVED','2025-09-04 21:43:14',0),
+('2025_09_12_00_auth.sql','B95D44F12BA980040BAEB982B01D359B55C2EA2B','ARCHIVED','2025-09-12 23:13:31',0),
+('2025_09_20_00_auth.sql','752B003BBEBDDD3E1BBFB342AD154EB50D5E6DC9','ARCHIVED','2025-09-20 01:31:35',0),
+('2025_10_10_00_auth.sql','D2CCA4D100F71481C1AD347EE00D025BF873B2F2','ARCHIVED','2025-10-10 00:02:43',0),
+('2025_10_11_00_auth.sql','9D39A17F4B14666677A409232A73986076FC4108','ARCHIVED','2025-10-11 12:34:55',0),
+('2025_10_15_00_auth.sql','AD32FF4A48BFC671ED2F17409D4283E2CD3577E1','ARCHIVED','2025-10-15 09:56:37',0),
+('2025_10_22_00_auth.sql','A363CDF2B9EDED18DA077351CB2B0DC3A9E5E752','ARCHIVED','2025-10-22 10:32:36',0),
+('2025_10_29_00_auth.sql','CA6DC3F6A070AD894AB0DF2B21168D1BD7445A38','ARCHIVED','2025-10-29 06:57:00',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -4028,4 +4029,4 @@ SET character_set_client = @saved_cs_client;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-08-16 14:58:24
+-- Dump completed on 2025-10-29 6:57:03
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 5b79fafc964..be46acd4112 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64)
--
-- Host: localhost Database: characters
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.2
+-- Server version 8.0.43-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -3824,9 +3824,10 @@ INSERT INTO `updates` VALUES
('2025_07_21_00_characters.sql','056A99B9AA90186E5B3177BF54C86607B6518BE9','ARCHIVED','2025-07-21 22:51:05',0),
('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_10_10_00_characters.sql','F1EF875805AF1E87A413387F5449FE37D5205E94','RELEASED','2025-10-09 23:58:44',0);
+('2025_08_19_00_characters.sql','EC197D88883CDA2B885675FE096DD56CCB143608','ARCHIVED','2025-08-19 01:03:26',0),
+('2025_09_09_00_characters.sql','CF3F0738623248620204175B049AAF0833262222','ARCHIVED','2025-09-09 14:11:21',0),
+('2025_10_10_00_characters.sql','F1EF875805AF1E87A413387F5449FE37D5205E94','ARCHIVED','2025-10-09 23:58:44',0),
+('2025_10_29_00_characters.sql','DC6A5D66E866352AC243869B627D282EE6A8B4F2','ARCHIVED','2025-10-29 06:57:00',0);
/*!40000 ALTER TABLE `updates` ENABLE KEYS */;
UNLOCK TABLES;
@@ -3954,4 +3955,4 @@ UNLOCK TABLES;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-08-16 14:58:24
+-- Dump completed on 2025-10-29 6:57:03
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql
index d88b1324dc2..edc93ee26aa 100644
--- a/sql/base/dev/hotfixes_database.sql
+++ b/sql/base/dev/hotfixes_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64)
--
-- Host: localhost Database: hotfixes
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.2
+-- Server version 8.0.43-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -319,7 +319,7 @@ CREATE TABLE `area_table` (
`FactionGroupMask` tinyint unsigned NOT NULL DEFAULT '0',
`AmbientMultiplier` float NOT NULL DEFAULT '0',
`MountFlags` int NOT NULL DEFAULT '0',
- `PvpCombatWorldStateID` smallint NOT NULL DEFAULT '0',
+ `PvpCombatWorldStateID` int NOT NULL DEFAULT '0',
`WildBattlePetLevelMin` tinyint unsigned NOT NULL DEFAULT '0',
`WildBattlePetLevelMax` tinyint unsigned NOT NULL DEFAULT '0',
`WindSettingsID` tinyint unsigned NOT NULL DEFAULT '0',
@@ -1375,7 +1375,7 @@ CREATE TABLE `broadcast_text` (
`LanguageID` int NOT NULL DEFAULT '0',
`ConditionID` int NOT NULL DEFAULT '0',
`EmotesID` smallint unsigned NOT NULL DEFAULT '0',
- `Flags` smallint unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`ChatBubbleDurationMs` int unsigned NOT NULL DEFAULT '0',
`VoiceOverPriorityID` int NOT NULL DEFAULT '0',
`SoundKitID1` int unsigned NOT NULL DEFAULT '0',
@@ -2189,7 +2189,7 @@ CREATE TABLE `chr_specialization` (
`OrderIndex` tinyint NOT NULL DEFAULT '0',
`PetTalentType` tinyint NOT NULL DEFAULT '0',
`Role` tinyint NOT NULL DEFAULT '0',
- `Flags` int unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`SpellIconFileID` int NOT NULL DEFAULT '0',
`PrimaryStatPriority` tinyint NOT NULL DEFAULT '0',
`AnimReplacements` int NOT NULL DEFAULT '0',
@@ -2325,6 +2325,8 @@ CREATE TABLE `content_tuning` (
`DamageItemLevelCurveID` int NOT NULL DEFAULT '0',
`HealthPrimaryStatCurveID` int NOT NULL DEFAULT '0',
`DamagePrimaryStatCurveID` int NOT NULL DEFAULT '0',
+ `PrimaryStatScalingModPlayerDataElementCharacterID` int NOT NULL DEFAULT '0',
+ `PrimaryStatScalingModPlayerDataElementCharacterMultiplier` float NOT NULL DEFAULT '0',
`MinLevel` int NOT NULL DEFAULT '0',
`MaxLevel` int NOT NULL DEFAULT '0',
`MinLevelType` int NOT NULL DEFAULT '0',
@@ -2914,7 +2916,7 @@ DROP TABLE IF EXISTS `curve`;
CREATE TABLE `curve` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Type` tinyint unsigned NOT NULL DEFAULT '0',
- `Flags` tinyint unsigned NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -2934,7 +2936,7 @@ CREATE TABLE `curve_point` (
`PreSLSquishPosY` float NOT NULL DEFAULT '0',
`ID` int unsigned NOT NULL DEFAULT '0',
`CurveID` int unsigned NOT NULL DEFAULT '0',
- `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0',
+ `OrderIndex` 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;
@@ -4563,7 +4565,7 @@ CREATE TABLE `item` (
`SheatheType` tinyint unsigned NOT NULL DEFAULT '0',
`SoundOverrideSubclassID` tinyint NOT NULL DEFAULT '0',
`IconFileDataID` int NOT NULL DEFAULT '0',
- `ItemGroupSoundsID` tinyint unsigned NOT NULL DEFAULT '0',
+ `ItemGroupSoundsID` int unsigned NOT NULL DEFAULT '0',
`ContentTuningID` int NOT NULL DEFAULT '0',
`ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0',
`CraftingQualityID` int NOT NULL DEFAULT '0',
@@ -4786,6 +4788,8 @@ CREATE TABLE `item_bonus_tree_node` (
`IblGroupPointsModSetID` int NOT NULL DEFAULT '0',
`MinMythicPlusLevel` int NOT NULL DEFAULT '0',
`MaxMythicPlusLevel` int NOT NULL DEFAULT '0',
+ `ItemCreationContextGroupID` int NOT NULL DEFAULT '0',
+ `Flags` int NOT NULL DEFAULT '0',
`ParentItemBonusTreeID` int unsigned NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -4876,6 +4880,22 @@ CREATE TABLE `item_context_picker_entry` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `item_creation_context`
+--
+
+DROP TABLE IF EXISTS `item_creation_context`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `item_currency_cost`
--
@@ -5277,6 +5297,22 @@ CREATE TABLE `item_name_description_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `item_offset_curve`
+--
+
+DROP TABLE IF EXISTS `item_offset_curve`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `item_price_base`
--
@@ -5294,6 +5330,24 @@ CREATE TABLE `item_price_base` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `item_scaling_config`
+--
+
+DROP TABLE IF EXISTS `item_scaling_config`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `item_search_name`
--
@@ -5504,6 +5558,8 @@ CREATE TABLE `item_sparse` (
`ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0',
`ContentTuningID` int NOT NULL DEFAULT '0',
`PlayerLevelToItemLevelCurveID` int NOT NULL DEFAULT '0',
+ `ItemLevelOffsetCurveID` int NOT NULL DEFAULT '0',
+ `ItemLevelOffsetItemLevel` int NOT NULL DEFAULT '0',
`ItemNameDescriptionID` smallint unsigned NOT NULL DEFAULT '0',
`RequiredTransmogHoliday` smallint unsigned NOT NULL DEFAULT '0',
`RequiredHoliday` smallint unsigned NOT NULL DEFAULT '0',
@@ -7119,10 +7175,10 @@ CREATE TABLE `player_condition` (
`AuraStacks2` tinyint unsigned NOT NULL DEFAULT '0',
`AuraStacks3` tinyint unsigned NOT NULL DEFAULT '0',
`AuraStacks4` tinyint unsigned NOT NULL DEFAULT '0',
- `Achievement1` smallint unsigned NOT NULL DEFAULT '0',
- `Achievement2` smallint unsigned NOT NULL DEFAULT '0',
- `Achievement3` smallint unsigned NOT NULL DEFAULT '0',
- `Achievement4` smallint unsigned NOT NULL DEFAULT '0',
+ `Achievement1` int unsigned NOT NULL DEFAULT '0',
+ `Achievement2` int unsigned NOT NULL DEFAULT '0',
+ `Achievement3` int unsigned NOT NULL DEFAULT '0',
+ `Achievement4` int unsigned NOT NULL DEFAULT '0',
`AreaID1` smallint unsigned NOT NULL DEFAULT '0',
`AreaID2` smallint unsigned NOT NULL DEFAULT '0',
`AreaID3` smallint unsigned NOT NULL DEFAULT '0',
@@ -7210,6 +7266,7 @@ CREATE TABLE `player_data_element_account` (
`ID` int unsigned NOT NULL DEFAULT '0',
`StorageIndex` int NOT NULL DEFAULT '0',
`Type` 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;
@@ -7226,6 +7283,7 @@ CREATE TABLE `player_data_element_character` (
`ID` int unsigned NOT NULL DEFAULT '0',
`StorageIndex` int NOT NULL DEFAULT '0',
`Type` 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;
@@ -7242,6 +7300,7 @@ CREATE TABLE `player_data_flag_account` (
`ID` int unsigned NOT NULL DEFAULT '0',
`StorageIndex` int NOT NULL DEFAULT '0',
`Unknown1107` 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;
@@ -7258,6 +7317,7 @@ CREATE TABLE `player_data_flag_character` (
`ID` int unsigned NOT NULL DEFAULT '0',
`StorageIndex` int NOT NULL DEFAULT '0',
`Unknown1107` 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;
@@ -8004,8 +8064,8 @@ DROP TABLE IF EXISTS `scene_script`;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `scene_script` (
`ID` int unsigned NOT NULL DEFAULT '0',
- `FirstSceneScriptID` smallint unsigned NOT NULL DEFAULT '0',
- `NextSceneScriptID` smallint unsigned NOT NULL DEFAULT '0',
+ `FirstSceneScriptID` int unsigned NOT NULL DEFAULT '0',
+ `NextSceneScriptID` int unsigned NOT NULL DEFAULT '0',
`Unknown915` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
@@ -8465,10 +8525,10 @@ CREATE TABLE `spell_categories` (
`ID` int unsigned NOT NULL DEFAULT '0',
`DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
`Category` smallint NOT NULL DEFAULT '0',
- `DefenseType` tinyint NOT NULL DEFAULT '0',
+ `DefenseType` int NOT NULL DEFAULT '0',
`DispelType` tinyint NOT NULL DEFAULT '0',
`Mechanic` tinyint NOT NULL DEFAULT '0',
- `PreventionType` tinyint NOT NULL DEFAULT '0',
+ `PreventionType` int NOT NULL DEFAULT '0',
`StartRecoveryCategory` smallint NOT NULL DEFAULT '0',
`ChargeCategory` smallint NOT NULL DEFAULT '0',
`SpellID` int unsigned NOT NULL DEFAULT '0',
@@ -8733,7 +8793,7 @@ DROP TABLE IF EXISTS `spell_interrupts`;
CREATE TABLE `spell_interrupts` (
`ID` int unsigned NOT NULL DEFAULT '0',
`DifficultyID` tinyint unsigned NOT NULL DEFAULT '0',
- `InterruptFlags` smallint NOT NULL DEFAULT '0',
+ `InterruptFlags` int NOT NULL DEFAULT '0',
`AuraInterruptFlags1` int NOT NULL DEFAULT '0',
`AuraInterruptFlags2` int NOT NULL DEFAULT '0',
`ChannelInterruptFlags1` int NOT NULL DEFAULT '0',
@@ -9866,6 +9926,7 @@ CREATE TABLE `trait_cost` (
`ID` int unsigned NOT NULL DEFAULT '0',
`Amount` int NOT NULL DEFAULT '0',
`TraitCurrencyID` int NOT NULL DEFAULT '0',
+ `CurveID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -9884,6 +9945,8 @@ CREATE TABLE `trait_currency` (
`CurrencyTypesID` int NOT NULL DEFAULT '0',
`Flags` int NOT NULL DEFAULT '0',
`Icon` int NOT NULL DEFAULT '0',
+ `PlayerDataElementAccountID` int NOT NULL DEFAULT '0',
+ `PlayerDataElementCharacterID` int NOT NULL DEFAULT '0',
`VerifiedBuild` int NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`,`VerifiedBuild`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
@@ -10255,6 +10318,25 @@ CREATE TABLE `trait_sub_tree_locale` (
/*!40101 SET character_set_client = @saved_cs_client */;
--
+-- Table structure for table `trait_system`
+--
+
+DROP TABLE IF EXISTS `trait_system`;
+/*!40101 SET @saved_cs_client = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+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;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
-- Table structure for table `trait_tree`
--
@@ -10582,6 +10664,7 @@ CREATE TABLE `ui_map_assignment` (
`AreaID` int NOT NULL DEFAULT '0',
`WmoDoodadPlacementID` int NOT NULL DEFAULT '0',
`WmoGroupID` 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;
@@ -11221,4 +11304,4 @@ CREATE TABLE `world_state_expression` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-08-16 14:58:29
+-- Dump completed on 2025-10-29 6:57:07
diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql
index b2dcebb26e4..554c77fd489 100644
--- a/sql/base/dev/world_database.sql
+++ b/sql/base/dev/world_database.sql
@@ -1,8 +1,8 @@
--- MySQL dump 10.13 Distrib 8.0.42, for Linux (x86_64)
+-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64)
--
-- Host: localhost Database: world
-- ------------------------------------------------------
--- Server version 8.0.42-0ubuntu0.22.04.2
+-- Server version 8.0.43-0ubuntu0.22.04.2
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -157,6 +157,7 @@ CREATE TABLE `areatrigger_create_properties` (
`SpellForVisuals` int DEFAULT NULL,
`TimeToTargetScale` int unsigned NOT NULL DEFAULT '0',
`Speed` float NOT NULL DEFAULT '1',
+ `SpeedIsTime` tinyint unsigned NOT NULL DEFAULT '0',
`Shape` tinyint unsigned NOT NULL DEFAULT '0',
`ShapeData0` float NOT NULL DEFAULT '0',
`ShapeData1` float NOT NULL DEFAULT '0',
@@ -1404,6 +1405,7 @@ CREATE TABLE `game_event` (
`length` bigint unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event',
`holiday` int unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id',
`holidayStage` tinyint unsigned NOT NULL DEFAULT '0',
+ `WorldStateId` int DEFAULT NULL,
`description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Description of the event displayed in console',
`world_event` tinyint unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event',
`announce` tinyint unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config',
@@ -1631,7 +1633,7 @@ CREATE TABLE `game_tele` (
`map` smallint unsigned NOT NULL DEFAULT '0',
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
-) ENGINE=InnoDB AUTO_INCREMENT=2305 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
+) ENGINE=InnoDB AUTO_INCREMENT=2308 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command';
/*!40101 SET character_set_client = @saved_cs_client */;
--
@@ -2183,6 +2185,7 @@ CREATE TABLE `jump_charge_params` (
`spellVisualId` int DEFAULT NULL,
`progressCurveId` int DEFAULT NULL,
`parabolicCurveId` int DEFAULT NULL,
+ `triggerSpellId` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
@@ -5063,4 +5066,4 @@ CREATE TABLE `world_state` (
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- Dump completed on 2025-08-16 14:58:26
+-- Dump completed on 2025-10-29 6:57:05