diff options
Diffstat (limited to 'sql/base/dev')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 255 | ||||
| -rw-r--r-- | sql/base/dev/world_database.sql | 179 |
2 files changed, 342 insertions, 92 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 1db012d7a3e..d7a7b72b335 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.32, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64) -- -- Host: localhost Database: hotfixes -- ------------------------------------------------------ --- Server version 8.0.32-0ubuntu0.20.04.2 +-- Server version 8.0.33-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -318,7 +318,7 @@ CREATE TABLE `area_table` ( `UwIntroSound` int unsigned NOT NULL DEFAULT '0', `FactionGroupMask` tinyint unsigned NOT NULL DEFAULT '0', `AmbientMultiplier` float NOT NULL DEFAULT '0', - `MountFlags` tinyint unsigned NOT NULL DEFAULT '0', + `MountFlags` int NOT NULL DEFAULT '0', `PvpCombatWorldStateID` smallint NOT NULL DEFAULT '0', `WildBattlePetLevelMin` tinyint unsigned NOT NULL DEFAULT '0', `WildBattlePetLevelMax` tinyint unsigned NOT NULL DEFAULT '0', @@ -1110,6 +1110,55 @@ CREATE TABLE `barber_shop_style_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `battle_pet_ability` +-- + +DROP TABLE IF EXISTS `battle_pet_ability`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `battle_pet_ability` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text COLLATE utf8mb4_unicode_ci, + `Description` text COLLATE utf8mb4_unicode_ci, + `IconFileDataID` int NOT NULL DEFAULT '0', + `PetTypeEnum` tinyint NOT NULL DEFAULT '0', + `Cooldown` int unsigned NOT NULL DEFAULT '0', + `BattlePetVisualID` smallint unsigned NOT NULL DEFAULT '0', + `Flags` tinyint 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 `battle_pet_ability_locale` +-- + +DROP TABLE IF EXISTS `battle_pet_ability_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `battle_pet_ability_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `Description_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `battle_pet_breed_quality` -- @@ -1384,6 +1433,27 @@ CREATE TABLE `cfg_regions` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `challenge_mode_item_bonus_override` +-- + +DROP TABLE IF EXISTS `challenge_mode_item_bonus_override`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `challenge_mode_item_bonus_override` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `ItemBonusTreeGroupID` int NOT NULL DEFAULT '0', + `DstItemBonusTreeID` int NOT NULL DEFAULT '0', + `Type` tinyint NOT NULL DEFAULT '0', + `Value` int NOT NULL DEFAULT '0', + `MythicPlusSeasonID` int NOT NULL DEFAULT '0', + `PvPSeasonID` int NOT NULL DEFAULT '0', + `SrcItemBonusTreeID` 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 `char_titles` -- @@ -1646,6 +1716,7 @@ CREATE TABLE `chr_customization_choice` ( `UiOrderIndex` smallint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `AddedInPatch` int NOT NULL DEFAULT '0', + `SoundKitID` int NOT NULL DEFAULT '0', `SwatchColor1` int NOT NULL DEFAULT '0', `SwatchColor2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -1717,6 +1788,7 @@ CREATE TABLE `chr_customization_element` ( `ChrCustomizationDisplayInfoID` int NOT NULL DEFAULT '0', `ChrCustItemGeoModifyID` int NOT NULL DEFAULT '0', `ChrCustomizationVoiceID` int NOT NULL DEFAULT '0', + `AnimKitID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1784,6 +1856,7 @@ DROP TABLE IF EXISTS `chr_customization_req`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chr_customization_req` ( `ID` int unsigned NOT NULL DEFAULT '0', + `RaceMask` bigint NOT NULL DEFAULT '0', `ReqSource` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Flags` int NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', @@ -2107,6 +2180,43 @@ CREATE TABLE `cinematic_sequences` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `conditional_chr_model` +-- + +DROP TABLE IF EXISTS `conditional_chr_model`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `conditional_chr_model` ( + `ID` int NOT NULL DEFAULT '0', + `ChrModelID` int unsigned NOT NULL DEFAULT '0', + `ChrCustomizationReqID` int NOT NULL DEFAULT '0', + `PlayerConditionID` int NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `ChrCustomizationCategoryID` 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 `conditional_content_tuning` +-- + +DROP TABLE IF EXISTS `conditional_content_tuning`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `conditional_content_tuning` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `OrderIndex` int NOT NULL DEFAULT '0', + `RedirectContentTuningID` int NOT NULL DEFAULT '0', + `RedirectFlag` int NOT NULL DEFAULT '0', + `ParentContentTuningID` 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 `content_tuning` -- @@ -2126,6 +2236,7 @@ CREATE TABLE `content_tuning` ( `TargetLevelMin` int NOT NULL DEFAULT '0', `TargetLevelMax` int NOT NULL DEFAULT '0', `MinItemLevel` int NOT NULL DEFAULT '0', + `QuestXpMultiplier` float NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2150,6 +2261,22 @@ CREATE TABLE `content_tuning_x_expected` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `content_tuning_x_label` +-- + +DROP TABLE IF EXISTS `content_tuning_x_label`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `content_tuning_x_label` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `LabelID` int NOT NULL DEFAULT '0', + `ContentTuningID` 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 `conversation_line` -- @@ -2467,12 +2594,12 @@ CREATE TABLE `criteria` ( `Type` smallint NOT NULL DEFAULT '0', `Asset` int NOT NULL DEFAULT '0', `ModifierTreeId` int unsigned NOT NULL DEFAULT '0', - `StartEvent` tinyint unsigned NOT NULL DEFAULT '0', + `StartEvent` int NOT NULL DEFAULT '0', `StartAsset` int NOT NULL DEFAULT '0', `StartTimer` smallint unsigned NOT NULL DEFAULT '0', - `FailEvent` tinyint unsigned NOT NULL DEFAULT '0', + `FailEvent` int NOT NULL DEFAULT '0', `FailAsset` int NOT NULL DEFAULT '0', - `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `EligibilityWorldStateID` smallint NOT NULL DEFAULT '0', `EligibilityWorldStateValue` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -2492,7 +2619,7 @@ CREATE TABLE `criteria_tree` ( `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Parent` int unsigned NOT NULL DEFAULT '0', `Amount` int unsigned NOT NULL DEFAULT '0', - `Operator` tinyint NOT NULL DEFAULT '0', + `Operator` int NOT NULL DEFAULT '0', `CriteriaID` int unsigned NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', @@ -2667,7 +2794,7 @@ CREATE TABLE `curve_point` ( `PreSLSquishPosX` float NOT NULL DEFAULT '0', `PreSLSquishPosY` float NOT NULL DEFAULT '0', `ID` int unsigned NOT NULL DEFAULT '0', - `CurveID` smallint unsigned NOT NULL DEFAULT '0', + `CurveID` int NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -3220,6 +3347,9 @@ CREATE TABLE `gameobject_display_info` ( `ObjectEffectPackageID` smallint NOT NULL DEFAULT '0', `OverrideLootEffectScale` float NOT NULL DEFAULT '0', `OverrideNameScale` float NOT NULL DEFAULT '0', + `AlternateDisplayType` int NOT NULL DEFAULT '0', + `ClientCreatureDisplayInfoID` int NOT NULL DEFAULT '0', + `ClientItemID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4387,6 +4517,28 @@ CREATE TABLE `item_bonus` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_bonus_list_group_entry` +-- + +DROP TABLE IF EXISTS `item_bonus_list_group_entry`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_bonus_list_group_entry` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `ItemBonusListGroupID` int NOT NULL DEFAULT '0', + `ItemBonusListID` int NOT NULL DEFAULT '0', + `ItemLevelSelectorID` int NOT NULL DEFAULT '0', + `SequenceValue` int NOT NULL DEFAULT '0', + `ItemExtendedCostID` int NOT NULL DEFAULT '0', + `PlayerConditionID` int NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `ItemLogicalCostGroupID` 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_bonus_list_level_delta` -- @@ -4402,6 +4554,22 @@ CREATE TABLE `item_bonus_list_level_delta` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_bonus_tree` +-- + +DROP TABLE IF EXISTS `item_bonus_tree`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_bonus_tree` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `InventoryTypeSlotMask` 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_bonus_tree_node` -- @@ -4416,6 +4584,8 @@ CREATE TABLE `item_bonus_tree_node` ( `ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemBonusListGroupID` int NOT NULL DEFAULT '0', `IblGroupPointsModSetID` int NOT NULL DEFAULT '0', + `MinMythicPlusLevel` int NOT NULL DEFAULT '0', + `MaxMythicPlusLevel` int NOT NULL DEFAULT '0', `ParentItemBonusTreeID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -4485,6 +4655,27 @@ CREATE TABLE `item_class_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_context_picker_entry` +-- + +DROP TABLE IF EXISTS `item_context_picker_entry`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_context_picker_entry` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `ItemCreationContext` tinyint unsigned NOT NULL DEFAULT '0', + `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', + `PVal` int NOT NULL DEFAULT '0', + `LabelID` int NOT NULL DEFAULT '0', + `Flags` int unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', + `ItemContextPickerID` 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` -- @@ -6243,6 +6434,24 @@ CREATE TABLE `movie` ( `KeyID` tinyint unsigned NOT NULL DEFAULT '0', `AudioFileDataID` int unsigned NOT NULL DEFAULT '0', `SubtitleFileDataID` int unsigned NOT NULL DEFAULT '0', + `SubtitleFileFormat` 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 `mythic_plus_season` +-- + +DROP TABLE IF EXISTS `mythic_plus_season`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `mythic_plus_season` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `MilestoneSeason` int NOT NULL DEFAULT '0', + `ExpansionLevel` int NOT NULL DEFAULT '0', + `HeroicLFGDungeonMinGear` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -6729,6 +6938,23 @@ CREATE TABLE `pvp_item` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `pvp_season` +-- + +DROP TABLE IF EXISTS `pvp_season`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `pvp_season` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `MilestoneSeason` int NOT NULL DEFAULT '0', + `AllianceAchievementID` int NOT NULL DEFAULT '0', + `HordeAchievementID` 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 `pvp_talent` -- @@ -7723,7 +7949,7 @@ DROP TABLE IF EXISTS `spell_category`; CREATE TABLE `spell_category` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `Flags` tinyint NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', `UsesPerWeek` tinyint unsigned NOT NULL DEFAULT '0', `MaxCharges` tinyint NOT NULL DEFAULT '0', `ChargeRecoveryTime` int NOT NULL DEFAULT '0', @@ -8073,7 +8299,7 @@ DROP TABLE IF EXISTS `spell_keybound_override`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_keybound_override` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Function` text COLLATE utf8mb4_unicode_ci, + `Function` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Type` tinyint NOT NULL DEFAULT '0', `Data` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', @@ -9671,10 +9897,11 @@ CREATE TABLE `ui_map` ( `ID` int unsigned NOT NULL DEFAULT '0', `ParentUiMapID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `System` int unsigned NOT NULL DEFAULT '0', - `Type` int unsigned NOT NULL DEFAULT '0', + `System` tinyint unsigned NOT NULL DEFAULT '0', + `Type` tinyint unsigned NOT NULL DEFAULT '0', `BountySetID` int NOT NULL DEFAULT '0', `BountyDisplayLocation` int unsigned NOT NULL DEFAULT '0', + `VisibilityPlayerConditionID2` int NOT NULL DEFAULT '0', `VisibilityPlayerConditionID` int NOT NULL DEFAULT '0', `HelpTextPosition` tinyint NOT NULL DEFAULT '0', `BkgAtlasID` int NOT NULL DEFAULT '0', @@ -9996,7 +10223,7 @@ DROP TABLE IF EXISTS `vehicle`; CREATE TABLE `vehicle` ( `ID` int unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `FlagsB` tinyint unsigned NOT NULL DEFAULT '0', + `FlagsB` int NOT NULL DEFAULT '0', `TurnSpeed` float NOT NULL DEFAULT '0', `PitchSpeed` float NOT NULL DEFAULT '0', `PitchMin` float NOT NULL DEFAULT '0', @@ -10238,4 +10465,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2023-04-02 1:02:34 +-- Dump completed on 2023-07-14 8:24:54 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index e98242646cd..ceba3d852c7 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.32, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.33, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 8.0.32-0ubuntu0.20.04.2 +-- Server version 8.0.33-0ubuntu0.20.04.2 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -550,6 +550,7 @@ CREATE TABLE `conversation_line_template` ( `UiCameraID` int unsigned NOT NULL DEFAULT '0', `ActorIdx` tinyint unsigned NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `ChatType` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -606,7 +607,6 @@ CREATE TABLE `creature` ( `unit_flags` int unsigned NOT NULL DEFAULT '0', `unit_flags2` int unsigned NOT NULL DEFAULT '0', `unit_flags3` int unsigned NOT NULL DEFAULT '0', - `dynamicflags` int unsigned NOT NULL DEFAULT '0', `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -824,10 +824,11 @@ DROP TABLE IF EXISTS `creature_questitem`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_questitem` ( `CreatureEntry` int unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', `Idx` int unsigned NOT NULL DEFAULT '0', `ItemId` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', - PRIMARY KEY (`CreatureEntry`,`Idx`) + PRIMARY KEY (`CreatureEntry`,`DifficultyID`,`Idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -893,9 +894,6 @@ DROP TABLE IF EXISTS `creature_template`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `creature_template` ( `entry` int unsigned NOT NULL DEFAULT '0', - `difficulty_entry_1` int unsigned NOT NULL DEFAULT '0', - `difficulty_entry_2` int unsigned NOT NULL DEFAULT '0', - `difficulty_entry_3` int unsigned NOT NULL DEFAULT '0', `KillCredit1` int unsigned NOT NULL DEFAULT '0', `KillCredit2` int unsigned NOT NULL DEFAULT '0', `name` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, @@ -903,8 +901,6 @@ CREATE TABLE `creature_template` ( `subname` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `TitleAlt` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `IconName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, - `gossip_menu_id` int unsigned NOT NULL DEFAULT '0', - `HealthScalingExpansion` int NOT NULL DEFAULT '0', `RequiredExpansion` int NOT NULL DEFAULT '0', `VignetteID` int NOT NULL DEFAULT '0', `faction` smallint unsigned NOT NULL DEFAULT '0', @@ -922,31 +918,15 @@ CREATE TABLE `creature_template` ( `unit_flags` int unsigned NOT NULL DEFAULT '0', `unit_flags2` int unsigned NOT NULL DEFAULT '0', `unit_flags3` int unsigned NOT NULL DEFAULT '0', - `dynamicflags` int unsigned NOT NULL DEFAULT '0', `family` int NOT NULL DEFAULT '0', `trainer_class` tinyint unsigned NOT NULL DEFAULT '0', `type` tinyint unsigned NOT NULL DEFAULT '0', - `type_flags` int unsigned NOT NULL DEFAULT '0', - `type_flags2` int unsigned NOT NULL DEFAULT '0', - `lootid` int unsigned NOT NULL DEFAULT '0', - `pickpocketloot` int unsigned NOT NULL DEFAULT '0', - `skinloot` int unsigned NOT NULL DEFAULT '0', `VehicleId` int unsigned NOT NULL DEFAULT '0', - `mingold` int unsigned NOT NULL DEFAULT '0', - `maxgold` int unsigned NOT NULL DEFAULT '0', `AIName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `MovementType` tinyint unsigned NOT NULL DEFAULT '0', - `HoverHeight` float NOT NULL DEFAULT '1', - `HealthModifier` float NOT NULL DEFAULT '1', - `HealthModifierExtra` float NOT NULL DEFAULT '1', - `ManaModifier` float NOT NULL DEFAULT '1', - `ManaModifierExtra` float NOT NULL DEFAULT '1', - `ArmorModifier` float NOT NULL DEFAULT '1', - `DamageModifier` float NOT NULL DEFAULT '1', `ExperienceModifier` float NOT NULL DEFAULT '1', `RacialLeader` tinyint unsigned NOT NULL DEFAULT '0', `movementId` int unsigned NOT NULL DEFAULT '0', - `CreatureDifficultyID` int NOT NULL DEFAULT '0', `WidgetSetID` int NOT NULL DEFAULT '0', `WidgetSetUnitConditionID` int NOT NULL DEFAULT '0', `RegenHealth` tinyint unsigned NOT NULL DEFAULT '1', @@ -988,6 +968,60 @@ CREATE TABLE `creature_template_addon` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `creature_template_difficulty` +-- + +DROP TABLE IF EXISTS `creature_template_difficulty`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `creature_template_difficulty` ( + `Entry` int unsigned NOT NULL, + `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', + `LevelScalingDeltaMin` smallint NOT NULL DEFAULT '0', + `LevelScalingDeltaMax` smallint NOT NULL DEFAULT '0', + `ContentTuningID` int NOT NULL DEFAULT '0', + `HealthScalingExpansion` int NOT NULL DEFAULT '0', + `HealthModifier` float NOT NULL DEFAULT '1', + `ManaModifier` float NOT NULL DEFAULT '1', + `ArmorModifier` float NOT NULL DEFAULT '1', + `DamageModifier` float NOT NULL DEFAULT '1', + `CreatureDifficultyID` int NOT NULL DEFAULT '0', + `TypeFlags` int unsigned NOT NULL DEFAULT '0', + `TypeFlags2` int unsigned NOT NULL DEFAULT '0', + `LootID` int unsigned NOT NULL DEFAULT '0', + `PickPocketLootID` int unsigned NOT NULL DEFAULT '0', + `SkinLootID` int unsigned NOT NULL DEFAULT '0', + `GoldMin` int unsigned NOT NULL DEFAULT '0', + `GoldMax` int unsigned NOT NULL DEFAULT '0', + `StaticFlags1` int unsigned NOT NULL DEFAULT '0', + `StaticFlags2` int unsigned NOT NULL DEFAULT '0', + `StaticFlags3` int unsigned NOT NULL DEFAULT '0', + `StaticFlags4` int unsigned NOT NULL DEFAULT '0', + `StaticFlags5` int unsigned NOT NULL DEFAULT '0', + `StaticFlags6` int unsigned NOT NULL DEFAULT '0', + `StaticFlags7` int unsigned NOT NULL DEFAULT '0', + `StaticFlags8` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`Entry`,`DifficultyID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `creature_template_gossip` +-- + +DROP TABLE IF EXISTS `creature_template_gossip`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `creature_template_gossip` ( + `CreatureID` int unsigned NOT NULL, + `MenuID` int unsigned NOT NULL, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`CreatureID`,`MenuID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `creature_template_locale` -- @@ -1061,21 +1095,17 @@ CREATE TABLE `creature_template_resistance` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `creature_template_scaling` +-- Table structure for table `creature_template_sparring` -- -DROP TABLE IF EXISTS `creature_template_scaling`; +DROP TABLE IF EXISTS `creature_template_sparring`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `creature_template_scaling` ( +CREATE TABLE `creature_template_sparring` ( `Entry` int unsigned NOT NULL, - `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', - `LevelScalingDeltaMin` smallint NOT NULL DEFAULT '0', - `LevelScalingDeltaMax` smallint NOT NULL DEFAULT '0', - `ContentTuningID` int NOT NULL DEFAULT '0', - `VerifiedBuild` int NOT NULL DEFAULT '0', - PRIMARY KEY (`Entry`,`DifficultyID`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + `NoNPCDamageBelowHealthPct` float NOT NULL, + PRIMARY KEY (`Entry`,`NoNPCDamageBelowHealthPct`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1211,6 +1241,20 @@ CREATE TABLE `disenchant_loot_template` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `event_script_names` +-- + +DROP TABLE IF EXISTS `event_script_names`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `event_script_names` ( + `Id` int unsigned NOT NULL, + `ScriptName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + PRIMARY KEY (`Id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `event_scripts` -- @@ -1524,7 +1568,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=1965 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; +) ENGINE=InnoDB AUTO_INCREMENT=1967 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1920,7 +1964,6 @@ DROP TABLE IF EXISTS `graveyard_zone`; CREATE TABLE `graveyard_zone` ( `ID` int unsigned NOT NULL DEFAULT '0', `GhostZone` int unsigned NOT NULL DEFAULT '0', - `Faction` smallint unsigned NOT NULL DEFAULT '0', `Comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`ID`,`GhostZone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Trigger System'; @@ -3079,6 +3122,24 @@ CREATE TABLE `quest_objectives` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `quest_objectives_completion_effect` +-- + +DROP TABLE IF EXISTS `quest_objectives_completion_effect`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `quest_objectives_completion_effect` ( + `ObjectiveID` int NOT NULL, + `GameEventID` int DEFAULT NULL, + `SpellID` int DEFAULT NULL, + `ConversationID` int DEFAULT NULL, + `UpdatePhaseShift` tinyint(1) DEFAULT '0', + `UpdateZoneAuras` tinyint(1) DEFAULT '0', + PRIMARY KEY (`ObjectiveID`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `quest_objectives_locale` -- @@ -3320,6 +3381,7 @@ CREATE TABLE `quest_reward_display_spell` ( `Idx` int unsigned NOT NULL, `SpellID` int unsigned DEFAULT '0', `PlayerConditionID` int unsigned DEFAULT '0', + `Type` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`QuestID`,`Idx`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3437,7 +3499,7 @@ CREATE TABLE `quest_template` ( `AcceptedSoundKitID` int unsigned NOT NULL DEFAULT '0', `CompleteSoundKitID` int unsigned NOT NULL DEFAULT '0', `AreaGroupID` int unsigned NOT NULL DEFAULT '0', - `TimeAllowed` int unsigned NOT NULL DEFAULT '0', + `TimeAllowed` bigint NOT NULL DEFAULT '0', `AllowableRaces` bigint unsigned DEFAULT '0', `TreasurePickerID` int NOT NULL DEFAULT '0', `Expansion` int NOT NULL DEFAULT '0', @@ -3728,25 +3790,6 @@ CREATE TABLE `script_spline_chain_waypoints` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `script_waypoint` --- - -DROP TABLE IF EXISTS `script_waypoint`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `script_waypoint` ( - `entry` int unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', - `pointid` int unsigned NOT NULL DEFAULT '0', - `location_x` float NOT NULL DEFAULT '0', - `location_y` float NOT NULL DEFAULT '0', - `location_z` float NOT NULL DEFAULT '0', - `waittime` int unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', - `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (`entry`,`pointid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Script Creature waypoints'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- -- Table structure for table `serverside_spell` -- @@ -4749,26 +4792,6 @@ CREATE TABLE `waypoint_scripts` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `waypoints` --- - -DROP TABLE IF EXISTS `waypoints`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!50503 SET character_set_client = utf8mb4 */; -CREATE TABLE `waypoints` ( - `entry` int unsigned NOT NULL DEFAULT '0', - `pointid` int unsigned NOT NULL DEFAULT '0', - `position_x` float NOT NULL DEFAULT '0', - `position_y` float NOT NULL DEFAULT '0', - `position_z` float NOT NULL DEFAULT '0', - `orientation` float DEFAULT NULL, - `delay` int unsigned NOT NULL DEFAULT '0', - `point_comment` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - PRIMARY KEY (`entry`,`pointid`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Creature waypoints'; -/*!40101 SET character_set_client = @saved_cs_client */; - --- -- Table structure for table `world_safe_locs` -- @@ -4872,4 +4895,4 @@ CREATE TABLE `world_state` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2023-04-02 1:02:30 +-- Dump completed on 2023-07-14 8:24:49 |