From 6b8bb270a8b316504289dad654e5aef88cd8d27f Mon Sep 17 00:00:00 2001 From: TDB Release Date: Sun, 4 Jul 2021 22:30:16 +0000 Subject: TDB 905.21071 - 2021/07/04 --- sql/base/dev/hotfixes_database.sql | 1224 +++++++++++++++++++++++++++++------- sql/base/dev/world_database.sql | 388 ++++++++---- 2 files changed, 1289 insertions(+), 323 deletions(-) (limited to 'sql/base/dev') diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 31ffa49d357..08d014c7bfd 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 5.7.34, for Linux (x86_64) -- -- Host: localhost Database: hotfixes -- ------------------------------------------------------ --- Server version 5.7.30-0ubuntu0.18.04.1 +-- Server version 5.7.34 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -39,11 +39,56 @@ CREATE TABLE `achievement` ( `RewardItemID` int(11) NOT NULL DEFAULT '0', `CriteriaTree` int(10) unsigned NOT NULL DEFAULT '0', `SharesCriteria` smallint(6) NOT NULL DEFAULT '0', + `CovenantID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) 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 `achievement_category` +-- + +DROP TABLE IF EXISTS `achievement_category`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_category` ( + `Name` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Parent` smallint(6) NOT NULL DEFAULT '0', + `UiOrder` tinyint(4) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `achievement_category_locale` +-- + +DROP TABLE IF EXISTS `achievement_category_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `achievement_category_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `achievement_locale` -- @@ -73,6 +118,130 @@ CREATE TABLE `achievement_locale` ( PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `adventure_journal` +-- + +DROP TABLE IF EXISTS `adventure_journal`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `adventure_journal` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text COLLATE utf8mb4_unicode_ci, + `Description` text COLLATE utf8mb4_unicode_ci, + `ButtonText` text COLLATE utf8mb4_unicode_ci, + `RewardDescription` text COLLATE utf8mb4_unicode_ci, + `ContinueDescription` text COLLATE utf8mb4_unicode_ci, + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ButtonActionType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `TextureFileDataID` int(11) NOT NULL DEFAULT '0', + `LfgDungeonID` smallint(5) unsigned NOT NULL DEFAULT '0', + `QuestID` int(11) NOT NULL DEFAULT '0', + `BattleMasterListID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PriorityMin` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PriorityMax` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemID` int(11) NOT NULL DEFAULT '0', + `ItemQuantity` int(10) unsigned NOT NULL DEFAULT '0', + `CurrencyType` smallint(5) unsigned NOT NULL DEFAULT '0', + `CurrencyQuantity` int(10) unsigned NOT NULL DEFAULT '0', + `UiMapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BonusPlayerConditionID1` int(10) unsigned NOT NULL DEFAULT '0', + `BonusPlayerConditionID2` int(10) unsigned NOT NULL DEFAULT '0', + `BonusValue1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BonusValue2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `adventure_journal_locale` +-- + +DROP TABLE IF EXISTS `adventure_journal_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `adventure_journal_locale` ( + `ID` int(10) 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, + `ButtonText_lang` text COLLATE utf8mb4_unicode_ci, + `RewardDescription_lang` text COLLATE utf8mb4_unicode_ci, + `ContinueDescription_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `adventure_map_poi` +-- + +DROP TABLE IF EXISTS `adventure_map_poi`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `adventure_map_poi` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Title` text COLLATE utf8mb4_unicode_ci, + `Description` text COLLATE utf8mb4_unicode_ci, + `WorldPositionX` float NOT NULL DEFAULT '0', + `WorldPositionY` float NOT NULL DEFAULT '0', + `Type` tinyint(4) NOT NULL DEFAULT '0', + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `QuestID` int(10) unsigned NOT NULL DEFAULT '0', + `LfgDungeonID` int(10) unsigned NOT NULL DEFAULT '0', + `RewardItemID` int(11) NOT NULL DEFAULT '0', + `UiTextureAtlasMemberID` int(10) unsigned NOT NULL DEFAULT '0', + `UiTextureKitID` int(10) unsigned NOT NULL DEFAULT '0', + `MapID` int(11) NOT NULL DEFAULT '0', + `AreaTableID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `adventure_map_poi_locale` +-- + +DROP TABLE IF EXISTS `adventure_map_poi_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `adventure_map_poi_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Title_lang` text COLLATE utf8mb4_unicode_ci, + `Description_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `anim_kit` -- @@ -145,7 +314,6 @@ CREATE TABLE `area_table` ( `UwAmbience` smallint(5) unsigned NOT NULL DEFAULT '0', `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0', `UwZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0', - `ExplorationLevel` tinyint(4) NOT NULL DEFAULT '0', `IntroSound` smallint(5) unsigned NOT NULL DEFAULT '0', `UwIntroSound` int(10) unsigned NOT NULL DEFAULT '0', `FactionGroupMask` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -155,6 +323,7 @@ CREATE TABLE `area_table` ( `WildBattlePetLevelMin` tinyint(3) unsigned NOT NULL DEFAULT '0', `WildBattlePetLevelMax` tinyint(3) unsigned NOT NULL DEFAULT '0', `WindSettingsID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ContentTuningID` int(11) NOT NULL DEFAULT '0', `Flags1` int(11) NOT NULL DEFAULT '0', `Flags2` int(11) NOT NULL DEFAULT '0', `LiquidTypeID1` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -965,7 +1134,7 @@ DROP TABLE IF EXISTS `battle_pet_breed_state`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_breed_state` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `BattlePetStateID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BattlePetStateID` int(11) NOT NULL DEFAULT '0', `Value` smallint(5) unsigned NOT NULL DEFAULT '0', `BattlePetBreedID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -992,6 +1161,7 @@ CREATE TABLE `battle_pet_species` ( `SourceTypeEnum` tinyint(4) NOT NULL DEFAULT '0', `CardUIModelSceneID` int(11) NOT NULL DEFAULT '0', `LoadoutUIModelSceneID` int(11) NOT NULL DEFAULT '0', + `CovenantID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1064,9 +1234,9 @@ CREATE TABLE `battlemaster_list` ( `GroupsAllowed` tinyint(4) NOT NULL DEFAULT '0', `MaxGroupSize` tinyint(4) NOT NULL DEFAULT '0', `HolidayWorldState` smallint(6) NOT NULL DEFAULT '0', - `Flags` tinyint(4) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', `IconFileDataID` int(11) NOT NULL DEFAULT '0', - `RequiredPlayerConditionID` smallint(6) NOT NULL DEFAULT '0', + `RequiredPlayerConditionID` int(11) NOT NULL DEFAULT '0', `MapID1` smallint(6) NOT NULL DEFAULT '0', `MapID2` smallint(6) NOT NULL DEFAULT '0', `MapID3` smallint(6) NOT NULL DEFAULT '0', @@ -1129,7 +1299,7 @@ CREATE TABLE `broadcast_text` ( `Text` text COLLATE utf8mb4_unicode_ci, `Text1` text COLLATE utf8mb4_unicode_ci, `ID` int(10) unsigned NOT NULL DEFAULT '0', - `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LanguageID` int(11) NOT NULL DEFAULT '0', `ConditionID` int(11) NOT NULL DEFAULT '0', `EmotesID` smallint(5) unsigned NOT NULL DEFAULT '0', `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -1194,90 +1364,6 @@ CREATE TABLE `cfg_regions` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `char_base_section` --- - -DROP TABLE IF EXISTS `char_base_section`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `char_base_section` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `LayoutResType` tinyint(3) unsigned NOT NULL DEFAULT '0', - `VariationEnum` tinyint(3) unsigned NOT NULL DEFAULT '0', - `ResolutionVariationEnum` tinyint(3) unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` int(11) 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_sections` --- - -DROP TABLE IF EXISTS `char_sections`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `char_sections` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `RaceID` tinyint(4) NOT NULL DEFAULT '0', - `SexID` tinyint(4) NOT NULL DEFAULT '0', - `BaseSection` tinyint(4) NOT NULL DEFAULT '0', - `VariationIndex` tinyint(4) NOT NULL DEFAULT '0', - `ColorIndex` tinyint(4) NOT NULL DEFAULT '0', - `Flags` smallint(6) NOT NULL DEFAULT '0', - `MaterialResourcesID1` int(11) NOT NULL DEFAULT '0', - `MaterialResourcesID2` int(11) NOT NULL DEFAULT '0', - `MaterialResourcesID3` int(11) NOT NULL DEFAULT '0', - `VerifiedBuild` int(11) 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_start_outfit` --- - -DROP TABLE IF EXISTS `char_start_outfit`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `char_start_outfit` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `ClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `SexID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `OutfitID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `PetDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `PetFamilyID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `ItemID1` int(11) NOT NULL DEFAULT '0', - `ItemID2` int(11) NOT NULL DEFAULT '0', - `ItemID3` int(11) NOT NULL DEFAULT '0', - `ItemID4` int(11) NOT NULL DEFAULT '0', - `ItemID5` int(11) NOT NULL DEFAULT '0', - `ItemID6` int(11) NOT NULL DEFAULT '0', - `ItemID7` int(11) NOT NULL DEFAULT '0', - `ItemID8` int(11) NOT NULL DEFAULT '0', - `ItemID9` int(11) NOT NULL DEFAULT '0', - `ItemID10` int(11) NOT NULL DEFAULT '0', - `ItemID11` int(11) NOT NULL DEFAULT '0', - `ItemID12` int(11) NOT NULL DEFAULT '0', - `ItemID13` int(11) NOT NULL DEFAULT '0', - `ItemID14` int(11) NOT NULL DEFAULT '0', - `ItemID15` int(11) NOT NULL DEFAULT '0', - `ItemID16` int(11) NOT NULL DEFAULT '0', - `ItemID17` int(11) NOT NULL DEFAULT '0', - `ItemID18` int(11) NOT NULL DEFAULT '0', - `ItemID19` int(11) NOT NULL DEFAULT '0', - `ItemID20` int(11) NOT NULL DEFAULT '0', - `ItemID21` int(11) NOT NULL DEFAULT '0', - `ItemID22` int(11) NOT NULL DEFAULT '0', - `ItemID23` int(11) NOT NULL DEFAULT '0', - `ItemID24` int(11) NOT NULL DEFAULT '0', - `RaceID` int(10) unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` int(11) 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` -- @@ -1325,22 +1411,33 @@ CREATE TABLE `char_titles_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `character_facial_hair_styles` +-- Table structure for table `character_loadout` -- -DROP TABLE IF EXISTS `character_facial_hair_styles`; +DROP TABLE IF EXISTS `character_loadout`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `character_facial_hair_styles` ( +CREATE TABLE `character_loadout` ( + `RaceMask` bigint(20) NOT NULL DEFAULT '0', `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Geoset1` int(11) NOT NULL DEFAULT '0', - `Geoset2` int(11) NOT NULL DEFAULT '0', - `Geoset3` int(11) NOT NULL DEFAULT '0', - `Geoset4` int(11) NOT NULL DEFAULT '0', - `Geoset5` int(11) NOT NULL DEFAULT '0', - `RaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `SexID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `VariationID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ChrClassID` tinyint(4) NOT NULL DEFAULT '0', + `Purpose` tinyint(4) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `character_loadout_item` +-- + +DROP TABLE IF EXISTS `character_loadout_item`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `character_loadout_item` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `CharacterLoadoutID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1354,11 +1451,12 @@ DROP TABLE IF EXISTS `chat_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat_channels` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text COLLATE utf8mb4_unicode_ci, `Shortcut` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', `Flags` int(11) NOT NULL DEFAULT '0', `FactionGroup` tinyint(4) NOT NULL DEFAULT '0', + `Ruleset` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1392,6 +1490,23 @@ CREATE TABLE `chat_channels_locale` ( PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `chr_class_ui_display` +-- + +DROP TABLE IF EXISTS `chr_class_ui_display`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_class_ui_display` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ChrClassesID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AdvGuidePlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `SplashPlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_classes` -- @@ -1405,14 +1520,29 @@ CREATE TABLE `chr_classes` ( `NameMale` text COLLATE utf8mb4_unicode_ci, `NameFemale` text COLLATE utf8mb4_unicode_ci, `PetNameToken` text COLLATE utf8mb4_unicode_ci, + `Description` text COLLATE utf8mb4_unicode_ci, + `RoleInfoString` text COLLATE utf8mb4_unicode_ci, + `DisabledString` text COLLATE utf8mb4_unicode_ci, + `HyphenatedNameMale` text COLLATE utf8mb4_unicode_ci, + `HyphenatedNameFemale` text COLLATE utf8mb4_unicode_ci, `ID` int(10) unsigned NOT NULL DEFAULT '0', `CreateScreenFileDataID` int(10) unsigned NOT NULL DEFAULT '0', `SelectScreenFileDataID` int(10) unsigned NOT NULL DEFAULT '0', `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', `LowResScreenFileDataID` int(10) unsigned NOT NULL DEFAULT '0', - `StartingLevel` int(11) NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', `SpellTextureBlobFileDataID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `RolesMask` int(10) unsigned NOT NULL DEFAULT '0', + `ArmorTypeMask` int(10) unsigned NOT NULL DEFAULT '0', + `CharStartKitUnknown901` int(11) NOT NULL DEFAULT '0', + `MaleCharacterCreationVisualFallback` int(11) NOT NULL DEFAULT '0', + `MaleCharacterCreationIdleVisualFallback` int(11) NOT NULL DEFAULT '0', + `FemaleCharacterCreationVisualFallback` int(11) NOT NULL DEFAULT '0', + `FemaleCharacterCreationIdleVisualFallback` int(11) NOT NULL DEFAULT '0', + `CharacterCreationIdleGroundVisualFallback` int(11) NOT NULL DEFAULT '0', + `CharacterCreationGroundVisualFallback` int(11) NOT NULL DEFAULT '0', + `AlteredFormCharacterCreationIdleVisualFallback` int(11) NOT NULL DEFAULT '0', + `CharacterCreationAnimLoopWaitTimeMsFallback` int(11) NOT NULL DEFAULT '0', `CinematicSequenceID` smallint(5) unsigned NOT NULL DEFAULT '0', `DefaultSpec` smallint(5) unsigned NOT NULL DEFAULT '0', `PrimaryStatPriority` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -1421,6 +1551,9 @@ CREATE TABLE `chr_classes` ( `AttackPowerPerAgility` tinyint(3) unsigned NOT NULL DEFAULT '0', `AttackPowerPerStrength` tinyint(3) unsigned NOT NULL DEFAULT '0', `SpellClassSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ChatColorR` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ChatColorG` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ChatColorB` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1439,6 +1572,11 @@ CREATE TABLE `chr_classes_locale` ( `Name_lang` text COLLATE utf8mb4_unicode_ci, `NameMale_lang` text COLLATE utf8mb4_unicode_ci, `NameFemale_lang` text COLLATE utf8mb4_unicode_ci, + `Description_lang` text COLLATE utf8mb4_unicode_ci, + `RoleInfoString_lang` text COLLATE utf8mb4_unicode_ci, + `DisabledString_lang` text COLLATE utf8mb4_unicode_ci, + `HyphenatedNameMale_lang` text COLLATE utf8mb4_unicode_ci, + `HyphenatedNameFemale_lang` text COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -1471,6 +1609,232 @@ CREATE TABLE `chr_classes_x_power_types` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `chr_customization_choice` +-- + +DROP TABLE IF EXISTS `chr_customization_choice`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_choice` ( + `Name` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ChrCustomizationOptionID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationReqID` int(11) NOT NULL DEFAULT '0', + `SortOrder` smallint(5) unsigned NOT NULL DEFAULT '0', + `SwatchColor1` int(11) NOT NULL DEFAULT '0', + `SwatchColor2` int(11) NOT NULL DEFAULT '0', + `UiOrderIndex` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_customization_choice_locale` +-- + +DROP TABLE IF EXISTS `chr_customization_choice_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_choice_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `chr_customization_display_info` +-- + +DROP TABLE IF EXISTS `chr_customization_display_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_display_info` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ShapeshiftFormID` int(11) NOT NULL DEFAULT '0', + `DisplayID` int(11) NOT NULL DEFAULT '0', + `BarberShopMinCameraDistance` float NOT NULL DEFAULT '0', + `BarberShopHeightOffset` float NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_customization_element` +-- + +DROP TABLE IF EXISTS `chr_customization_element`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_element` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ChrCustomizationChoiceID` int(11) NOT NULL DEFAULT '0', + `RelatedChrCustomizationChoiceID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationGeosetID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationSkinnedModelID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationMaterialID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationBoneSetID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationCondModelID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationDisplayInfoID` int(11) NOT NULL DEFAULT '0', + `ChrCustItemGeoModifyID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_customization_option` +-- + +DROP TABLE IF EXISTS `chr_customization_option`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_option` ( + `Name` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SecondaryID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `ChrModelID` int(11) NOT NULL DEFAULT '0', + `SortIndex` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationCategoryID` int(11) NOT NULL DEFAULT '0', + `OptionType` int(11) NOT NULL DEFAULT '0', + `BarberShopCostModifier` float NOT NULL DEFAULT '0', + `ChrCustomizationID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationReqID` int(11) NOT NULL DEFAULT '0', + `UiOrderIndex` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_customization_option_locale` +-- + +DROP TABLE IF EXISTS `chr_customization_option_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_option_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `chr_customization_req` +-- + +DROP TABLE IF EXISTS `chr_customization_req`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_req` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `ClassMask` int(11) NOT NULL DEFAULT '0', + `AchievementID` int(11) NOT NULL DEFAULT '0', + `OverrideArchive` int(11) NOT NULL DEFAULT '0', + `ItemModifiedAppearanceID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_customization_req_choice` +-- + +DROP TABLE IF EXISTS `chr_customization_req_choice`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_customization_req_choice` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ChrCustomizationChoiceID` int(11) NOT NULL DEFAULT '0', + `ChrCustomizationReqID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_model` +-- + +DROP TABLE IF EXISTS `chr_model`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_model` ( + `FaceCustomizationOffset1` float NOT NULL DEFAULT '0', + `FaceCustomizationOffset2` float NOT NULL DEFAULT '0', + `FaceCustomizationOffset3` float NOT NULL DEFAULT '0', + `CustomizeOffset1` float NOT NULL DEFAULT '0', + `CustomizeOffset2` float NOT NULL DEFAULT '0', + `CustomizeOffset3` float NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Sex` int(11) NOT NULL DEFAULT '0', + `DisplayID` int(11) NOT NULL DEFAULT '0', + `CharComponentTextureLayoutID` int(11) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `SkeletonFileDataID` int(11) NOT NULL DEFAULT '0', + `ModelFallbackChrModelID` int(11) NOT NULL DEFAULT '0', + `TextureFallbackChrModelID` int(11) NOT NULL DEFAULT '0', + `HelmVisFallbackChrModelID` int(11) NOT NULL DEFAULT '0', + `CustomizeScale` float NOT NULL DEFAULT '0', + `CustomizeFacing` float NOT NULL DEFAULT '0', + `CameraDistanceOffset` float NOT NULL DEFAULT '0', + `BarberShopCameraOffsetScale` float NOT NULL DEFAULT '0', + `BarberShopCameraRotationOffset` float NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_race_x_chr_model` +-- + +DROP TABLE IF EXISTS `chr_race_x_chr_model`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `chr_race_x_chr_model` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ChrRacesID` int(11) NOT NULL DEFAULT '0', + `ChrModelID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `chr_races` -- @@ -1485,20 +1849,22 @@ CREATE TABLE `chr_races` ( `NameFemale` text COLLATE utf8mb4_unicode_ci, `NameLowercase` text COLLATE utf8mb4_unicode_ci, `NameFemaleLowercase` text COLLATE utf8mb4_unicode_ci, + `NameS` text COLLATE utf8mb4_unicode_ci, + `NameFemaleS` text COLLATE utf8mb4_unicode_ci, + `NameLowercaseS` text COLLATE utf8mb4_unicode_ci, + `NameFemaleLowercaseS` text COLLATE utf8mb4_unicode_ci, + `RaceFantasyDescription` text COLLATE utf8mb4_unicode_ci, + `NameL` text COLLATE utf8mb4_unicode_ci, + `NameFemaleL` text COLLATE utf8mb4_unicode_ci, + `NameLowercaseL` text COLLATE utf8mb4_unicode_ci, + `NameFemaleLowercaseL` text COLLATE utf8mb4_unicode_ci, `ID` int(10) unsigned NOT NULL DEFAULT '0', `Flags` int(11) NOT NULL DEFAULT '0', - `MaleDisplayId` int(10) unsigned NOT NULL DEFAULT '0', - `FemaleDisplayId` int(10) unsigned NOT NULL DEFAULT '0', - `HighResMaleDisplayId` int(10) unsigned NOT NULL DEFAULT '0', - `HighResFemaleDisplayId` int(10) unsigned NOT NULL DEFAULT '0', + `BaseLanguage` int(11) NOT NULL DEFAULT '0', + `ResSicknessSpellID` int(11) NOT NULL DEFAULT '0', + `SplashSoundID` int(11) NOT NULL DEFAULT '0', `CreateScreenFileDataID` int(11) NOT NULL DEFAULT '0', `SelectScreenFileDataID` int(11) NOT NULL DEFAULT '0', - `MaleCustomizeOffset1` float NOT NULL DEFAULT '0', - `MaleCustomizeOffset2` float NOT NULL DEFAULT '0', - `MaleCustomizeOffset3` float NOT NULL DEFAULT '0', - `FemaleCustomizeOffset1` float NOT NULL DEFAULT '0', - `FemaleCustomizeOffset2` float NOT NULL DEFAULT '0', - `FemaleCustomizeOffset3` float NOT NULL DEFAULT '0', `LowResScreenFileDataID` int(11) NOT NULL DEFAULT '0', `AlteredFormStartVisualKitID1` int(10) unsigned NOT NULL DEFAULT '0', `AlteredFormStartVisualKitID2` int(10) unsigned NOT NULL DEFAULT '0', @@ -1509,21 +1875,19 @@ CREATE TABLE `chr_races` ( `HeritageArmorAchievementID` int(11) NOT NULL DEFAULT '0', `StartingLevel` int(11) NOT NULL DEFAULT '0', `UiDisplayOrder` int(11) NOT NULL DEFAULT '0', - `FemaleSkeletonFileDataID` int(11) NOT NULL DEFAULT '0', - `MaleSkeletonFileDataID` int(11) NOT NULL DEFAULT '0', - `HelmVisFallbackRaceID` int(11) NOT NULL DEFAULT '0', + `PlayableRaceBit` int(11) NOT NULL DEFAULT '0', + `HelmetAnimScalingRaceID` int(11) NOT NULL DEFAULT '0', `TransmogrifyDisabledSlotMask` int(11) NOT NULL DEFAULT '0', + `AlteredFormCustomizeOffsetFallback1` float NOT NULL DEFAULT '0', + `AlteredFormCustomizeOffsetFallback2` float NOT NULL DEFAULT '0', + `AlteredFormCustomizeOffsetFallback3` float NOT NULL DEFAULT '0', + `AlteredFormCustomizeRotationFallback` float NOT NULL DEFAULT '0', `FactionID` smallint(6) NOT NULL DEFAULT '0', `CinematicSequenceID` smallint(6) NOT NULL DEFAULT '0', - `ResSicknessSpellID` smallint(6) NOT NULL DEFAULT '0', - `SplashSoundID` smallint(6) NOT NULL DEFAULT '0', - `BaseLanguage` tinyint(4) NOT NULL DEFAULT '0', `CreatureType` tinyint(4) NOT NULL DEFAULT '0', `Alliance` tinyint(4) NOT NULL DEFAULT '0', `RaceRelated` tinyint(4) NOT NULL DEFAULT '0', `UnalteredVisualRaceID` tinyint(4) NOT NULL DEFAULT '0', - `CharComponentTextureLayoutID` tinyint(4) NOT NULL DEFAULT '0', - `CharComponentTexLayoutHiResID` tinyint(4) NOT NULL DEFAULT '0', `DefaultClassID` tinyint(4) NOT NULL DEFAULT '0', `NeutralRaceID` tinyint(4) NOT NULL DEFAULT '0', `MaleModelFallbackRaceID` tinyint(4) NOT NULL DEFAULT '0', @@ -1534,6 +1898,7 @@ CREATE TABLE `chr_races` ( `MaleTextureFallbackSex` tinyint(4) NOT NULL DEFAULT '0', `FemaleTextureFallbackRaceID` tinyint(4) NOT NULL DEFAULT '0', `FemaleTextureFallbackSex` tinyint(4) NOT NULL DEFAULT '0', + `UnalteredVisualCustomizationRaceID` tinyint(3) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1553,6 +1918,15 @@ CREATE TABLE `chr_races_locale` ( `NameFemale_lang` text COLLATE utf8mb4_unicode_ci, `NameLowercase_lang` text COLLATE utf8mb4_unicode_ci, `NameFemaleLowercase_lang` text COLLATE utf8mb4_unicode_ci, + `NameS_lang` text COLLATE utf8mb4_unicode_ci, + `NameFemaleS_lang` text COLLATE utf8mb4_unicode_ci, + `NameLowercaseS_lang` text COLLATE utf8mb4_unicode_ci, + `NameFemaleLowercaseS_lang` text COLLATE utf8mb4_unicode_ci, + `RaceFantasyDescription_lang` text COLLATE utf8mb4_unicode_ci, + `NameL_lang` text COLLATE utf8mb4_unicode_ci, + `NameFemaleL_lang` text COLLATE utf8mb4_unicode_ci, + `NameLowercaseL_lang` text COLLATE utf8mb4_unicode_ci, + `NameFemaleLowercaseL_lang` text COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -1677,10 +2051,17 @@ DROP TABLE IF EXISTS `content_tuning`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `content_tuning` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `MinLevel` int(11) NOT NULL DEFAULT '0', - `MaxLevel` int(11) NOT NULL DEFAULT '0', `Flags` int(11) NOT NULL DEFAULT '0', `ExpansionID` int(11) NOT NULL DEFAULT '0', + `MinLevel` int(11) NOT NULL DEFAULT '0', + `MaxLevel` int(11) NOT NULL DEFAULT '0', + `MinLevelType` int(11) NOT NULL DEFAULT '0', + `MaxLevelType` int(11) NOT NULL DEFAULT '0', + `TargetLevelDelta` int(11) NOT NULL DEFAULT '0', + `TargetLevelMaxDelta` int(11) NOT NULL DEFAULT '0', + `TargetLevelMin` int(11) NOT NULL DEFAULT '0', + `TargetLevelMax` int(11) NOT NULL DEFAULT '0', + `MinItemLevel` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1855,17 +2236,9 @@ CREATE TABLE `creature_display_info_extra` ( `DisplayRaceID` tinyint(4) NOT NULL DEFAULT '0', `DisplaySexID` tinyint(4) NOT NULL DEFAULT '0', `DisplayClassID` tinyint(4) NOT NULL DEFAULT '0', - `SkinID` tinyint(4) NOT NULL DEFAULT '0', - `FaceID` tinyint(4) NOT NULL DEFAULT '0', - `HairStyleID` tinyint(4) NOT NULL DEFAULT '0', - `HairColorID` tinyint(4) NOT NULL DEFAULT '0', - `FacialHairID` tinyint(4) NOT NULL DEFAULT '0', `Flags` tinyint(4) NOT NULL DEFAULT '0', `BakeMaterialResourcesID` int(11) NOT NULL DEFAULT '0', `HDBakeMaterialResourcesID` int(11) NOT NULL DEFAULT '0', - `CustomDisplayOption1` tinyint(3) unsigned NOT NULL DEFAULT '0', - `CustomDisplayOption2` tinyint(3) unsigned NOT NULL DEFAULT '0', - `CustomDisplayOption3` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2100,18 +2473,20 @@ CREATE TABLE `currency_types` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text COLLATE utf8mb4_unicode_ci, `Description` text COLLATE utf8mb4_unicode_ci, - `CategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CategoryID` int(11) NOT NULL DEFAULT '0', `InventoryIconFileID` int(11) NOT NULL DEFAULT '0', `SpellWeight` int(10) unsigned NOT NULL DEFAULT '0', `SpellCategory` tinyint(3) unsigned NOT NULL DEFAULT '0', `MaxQty` int(10) unsigned NOT NULL DEFAULT '0', `MaxEarnablePerWeek` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Quality` tinyint(4) NOT NULL DEFAULT '0', `FactionID` int(11) NOT NULL DEFAULT '0', `ItemGroupSoundsID` int(11) NOT NULL DEFAULT '0', - `ConvertToPlayerExperience` int(11) NOT NULL DEFAULT '0', - `PlayerConditionID` int(11) NOT NULL DEFAULT '0', + `XpQuestDifficulty` int(11) NOT NULL DEFAULT '0', + `AwardConditionID` int(11) NOT NULL DEFAULT '0', + `MaxQtyWorldStateID` int(11) NOT NULL DEFAULT '0', + `Flags1` int(11) NOT NULL DEFAULT '0', + `Flags2` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2172,6 +2547,8 @@ CREATE TABLE `curve_point` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `PosX` float NOT NULL DEFAULT '0', `PosY` float NOT NULL DEFAULT '0', + `PosPreSquishX` float NOT NULL DEFAULT '0', + `PosPreSquishY` float NOT NULL DEFAULT '0', `CurveID` smallint(5) unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -2190,20 +2567,20 @@ CREATE TABLE `destructible_model_data` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `State0ImpactEffectDoodadSet` tinyint(4) NOT NULL DEFAULT '0', `State0AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', - `State1Wmo` smallint(5) unsigned NOT NULL DEFAULT '0', + `State1Wmo` int(11) NOT NULL DEFAULT '0', `State1DestructionDoodadSet` tinyint(4) NOT NULL DEFAULT '0', `State1ImpactEffectDoodadSet` tinyint(4) NOT NULL DEFAULT '0', `State1AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', - `State2Wmo` smallint(5) unsigned NOT NULL DEFAULT '0', + `State2Wmo` int(11) NOT NULL DEFAULT '0', `State2DestructionDoodadSet` tinyint(4) NOT NULL DEFAULT '0', `State2ImpactEffectDoodadSet` tinyint(4) NOT NULL DEFAULT '0', `State2AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', - `State3Wmo` smallint(5) unsigned NOT NULL DEFAULT '0', + `State3Wmo` int(11) NOT NULL DEFAULT '0', `State3InitDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', `State3AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', `EjectDirection` tinyint(3) unsigned NOT NULL DEFAULT '0', `DoNotHighlight` tinyint(3) unsigned NOT NULL DEFAULT '0', - `State0Wmo` smallint(5) unsigned NOT NULL DEFAULT '0', + `State0Wmo` int(11) NOT NULL DEFAULT '0', `HealEffect` tinyint(3) unsigned NOT NULL DEFAULT '0', `HealEffectSpeed` smallint(5) unsigned NOT NULL DEFAULT '0', `State0NameSet` tinyint(4) NOT NULL DEFAULT '0', @@ -2280,7 +2657,7 @@ CREATE TABLE `dungeon_encounter` ( `Name` text COLLATE utf8mb4_unicode_ci, `ID` int(10) unsigned NOT NULL DEFAULT '0', `MapID` smallint(6) NOT NULL DEFAULT '0', - `DifficultyID` tinyint(4) NOT NULL DEFAULT '0', + `DifficultyID` int(11) NOT NULL DEFAULT '0', `OrderIndex` int(11) NOT NULL DEFAULT '0', `CompleteWorldStateID` int(11) NOT NULL DEFAULT '0', `Bit` tinyint(4) NOT NULL DEFAULT '0', @@ -2585,6 +2962,99 @@ CREATE TABLE `faction_template` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `friendship_rep_reaction` +-- + +DROP TABLE IF EXISTS `friendship_rep_reaction`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `friendship_rep_reaction` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Reaction` text COLLATE utf8mb4_unicode_ci, + `FriendshipRepID` int(10) unsigned NOT NULL DEFAULT '0', + `ReactionThreshold` smallint(5) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `friendship_rep_reaction_locale` +-- + +DROP TABLE IF EXISTS `friendship_rep_reaction_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `friendship_rep_reaction_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Reaction_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `friendship_reputation` +-- + +DROP TABLE IF EXISTS `friendship_reputation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `friendship_reputation` ( + `Description` text COLLATE utf8mb4_unicode_ci, + `StandingModified` text COLLATE utf8mb4_unicode_ci, + `StandingChanged` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `FactionID` int(11) NOT NULL DEFAULT '0', + `TextureFileID` int(11) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `friendship_reputation_locale` +-- + +DROP TABLE IF EXISTS `friendship_reputation_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `friendship_reputation_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Description_lang` text COLLATE utf8mb4_unicode_ci, + `StandingModified_lang` text COLLATE utf8mb4_unicode_ci, + `StandingChanged_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `gameobject_display_info` -- @@ -2626,13 +3096,13 @@ CREATE TABLE `gameobjects` ( `Rot3` float NOT NULL DEFAULT '0', `Rot4` float NOT NULL DEFAULT '0', `ID` int(10) unsigned NOT NULL DEFAULT '0', - `OwnerID` smallint(5) unsigned NOT NULL DEFAULT '0', - `DisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `OwnerID` int(11) NOT NULL DEFAULT '0', + `DisplayID` int(11) NOT NULL DEFAULT '0', `Scale` float NOT NULL DEFAULT '0', - `TypeID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', - `PhaseID` smallint(5) unsigned NOT NULL DEFAULT '0', - `PhaseGroupID` smallint(5) unsigned NOT NULL DEFAULT '0', + `TypeID` int(11) NOT NULL DEFAULT '0', + `PhaseUseFlags` int(11) NOT NULL DEFAULT '0', + `PhaseID` int(11) NOT NULL DEFAULT '0', + `PhaseGroupID` int(11) NOT NULL DEFAULT '0', `PropValue1` int(11) NOT NULL DEFAULT '0', `PropValue2` int(11) NOT NULL DEFAULT '0', `PropValue3` int(11) NOT NULL DEFAULT '0', @@ -2739,7 +3209,7 @@ CREATE TABLE `garr_building` ( `BuildingType` tinyint(3) unsigned NOT NULL DEFAULT '0', `HordeGameObjectID` int(11) NOT NULL DEFAULT '0', `AllianceGameObjectID` int(11) NOT NULL DEFAULT '0', - `GarrSiteID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GarrSiteID` int(11) NOT NULL DEFAULT '0', `UpgradeLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `BuildSeconds` int(11) NOT NULL DEFAULT '0', `CurrencyTypeID` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -2899,6 +3369,8 @@ CREATE TABLE `garr_follower` ( `ChrClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `Gender` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AutoCombatantID` int(11) NOT NULL DEFAULT '0', + `CovenantID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3059,7 +3531,22 @@ CREATE TABLE `gem_properties` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `EnchantId` smallint(5) unsigned NOT NULL DEFAULT '0', `Type` int(11) NOT NULL DEFAULT '0', - `MinItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `global_curve` +-- + +DROP TABLE IF EXISTS `global_curve`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `global_curve` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `CurveID` int(11) NOT NULL DEFAULT '0', + `Type` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3331,14 +3818,31 @@ CREATE TABLE `hotfix_blob` ( DROP TABLE IF EXISTS `hotfix_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `hotfix_data` ( - `Id` int(11) NOT NULL, +CREATE TABLE `hotfix_data` ( + `Id` int(11) NOT NULL, + `TableHash` int(10) unsigned NOT NULL, + `RecordId` int(11) NOT NULL, + `Status` tinyint(3) unsigned NOT NULL DEFAULT '3', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`Id`,`TableHash`,`RecordId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `hotfix_optional_data` +-- + +DROP TABLE IF EXISTS `hotfix_optional_data`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `hotfix_optional_data` ( `TableHash` int(10) unsigned NOT NULL, - `RecordId` int(11) NOT NULL, - `Deleted` tinyint(3) unsigned DEFAULT '0', - `VerifiedBuild` int(11) NOT NULL DEFAULT '0', - PRIMARY KEY (`Id`,`TableHash`,`RecordId`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; + `RecordId` int(10) unsigned NOT NULL, + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Key` int(10) unsigned NOT NULL, + `Data` blob NOT NULL, + `VerifiedBuild` int(11) NOT NULL DEFAULT '0' +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -3421,6 +3925,7 @@ CREATE TABLE `item` ( `SoundOverrideSubclassID` tinyint(4) NOT NULL DEFAULT '0', `IconFileDataID` int(11) NOT NULL DEFAULT '0', `ItemGroupSoundsID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ModifiedCraftingReagentItemID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3439,6 +3944,7 @@ CREATE TABLE `item_appearance` ( `ItemDisplayInfoID` int(11) NOT NULL DEFAULT '0', `DefaultIconFileDataID` int(11) NOT NULL DEFAULT '0', `UiOrder` int(11) NOT NULL DEFAULT '0', + `PlayerConditionID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3560,6 +4066,7 @@ CREATE TABLE `item_bonus` ( `Value1` int(11) NOT NULL DEFAULT '0', `Value2` int(11) NOT NULL DEFAULT '0', `Value3` int(11) NOT NULL DEFAULT '0', + `Value4` int(11) NOT NULL DEFAULT '0', `ParentItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT '0', `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -3596,6 +4103,8 @@ CREATE TABLE `item_bonus_tree_node` ( `ChildItemBonusTreeID` smallint(5) unsigned NOT NULL DEFAULT '0', `ChildItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT '0', `ChildItemLevelSelectorID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemBonusListGroupID` int(11) NOT NULL DEFAULT '0', + `ParentItemBonusTreeNodeID` int(11) NOT NULL DEFAULT '0', `ParentItemBonusTreeID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -4003,6 +4512,25 @@ CREATE TABLE `item_modified_appearance` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `item_modified_appearance_extra` +-- + +DROP TABLE IF EXISTS `item_modified_appearance_extra`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `item_modified_appearance_extra` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `IconFileDataID` int(11) NOT NULL DEFAULT '0', + `UnequippedIconFileDataID` int(11) NOT NULL DEFAULT '0', + `SheatheType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DisplayWeaponSubclassID` tinyint(4) NOT NULL DEFAULT '0', + `DisplayInventoryType` tinyint(4) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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_name_description` -- @@ -4253,6 +4781,9 @@ CREATE TABLE `item_sparse` ( `Flags3` int(11) NOT NULL DEFAULT '0', `Flags4` int(11) NOT NULL DEFAULT '0', `FactionRelated` int(11) NOT NULL DEFAULT '0', + `ModifiedCraftingReagentItemID` int(11) NOT NULL DEFAULT '0', + `ContentTuningID` int(11) NOT NULL DEFAULT '0', + `PlayerLevelToItemLevelCurveID` int(11) NOT NULL DEFAULT '0', `ItemNameDescriptionID` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredTransmogHoliday` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredHoliday` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -4268,7 +4799,6 @@ CREATE TABLE `item_sparse` ( `StartQuestID` smallint(5) unsigned NOT NULL DEFAULT '0', `PageID` smallint(5) unsigned NOT NULL DEFAULT '0', `ItemDelay` smallint(5) unsigned NOT NULL DEFAULT '0', - `ScalingStatDistributionID` smallint(5) unsigned NOT NULL DEFAULT '0', `MinFactionID` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -4438,6 +4968,64 @@ CREATE TABLE `keychain` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `language_words` +-- + +DROP TABLE IF EXISTS `language_words`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `language_words` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Word` text COLLATE utf8mb4_unicode_ci, + `LanguageID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `languages` +-- + +DROP TABLE IF EXISTS `languages`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `languages` ( + `Name` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `languages_locale` +-- + +DROP TABLE IF EXISTS `languages_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `languages_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `lfg_dungeons` -- @@ -4449,8 +5037,6 @@ CREATE TABLE `lfg_dungeons` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text COLLATE utf8mb4_unicode_ci, `Description` text COLLATE utf8mb4_unicode_ci, - `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', - `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT '0', `TypeID` tinyint(3) unsigned NOT NULL DEFAULT '0', `Subtype` tinyint(3) unsigned NOT NULL DEFAULT '0', `Faction` tinyint(4) NOT NULL DEFAULT '0', @@ -4464,9 +5050,6 @@ CREATE TABLE `lfg_dungeons` ( `GroupID` tinyint(3) unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', `RequiredPlayerConditionId` int(10) unsigned NOT NULL DEFAULT '0', - `TargetLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', - `TargetLevelMin` tinyint(3) unsigned NOT NULL DEFAULT '0', - `TargetLevelMax` smallint(5) unsigned NOT NULL DEFAULT '0', `RandomID` smallint(5) unsigned NOT NULL DEFAULT '0', `ScenarioID` smallint(5) unsigned NOT NULL DEFAULT '0', `FinalEncounterID` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -4479,6 +5062,7 @@ CREATE TABLE `lfg_dungeons` ( `BonusReputationAmount` smallint(5) unsigned NOT NULL DEFAULT '0', `MentorItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', `MentorCharLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ContentTuningID` int(11) NOT NULL DEFAULT '0', `Flags1` int(11) NOT NULL DEFAULT '0', `Flags2` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -4620,6 +5204,7 @@ DROP TABLE IF EXISTS `lock`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lock` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', `Index1` int(11) NOT NULL DEFAULT '0', `Index2` int(11) NOT NULL DEFAULT '0', `Index3` int(11) NOT NULL DEFAULT '0', @@ -4710,6 +5295,7 @@ CREATE TABLE `map` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Directory` text COLLATE utf8mb4_unicode_ci, `MapName` text COLLATE utf8mb4_unicode_ci, + `InternalName` text COLLATE utf8mb4_unicode_ci, `MapDescription0` text COLLATE utf8mb4_unicode_ci, `MapDescription1` text COLLATE utf8mb4_unicode_ci, `PvpShortDescription` text COLLATE utf8mb4_unicode_ci, @@ -4789,6 +5375,51 @@ CREATE TABLE `map_difficulty_locale` ( PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `map_difficulty_x_condition` +-- + +DROP TABLE IF EXISTS `map_difficulty_x_condition`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `map_difficulty_x_condition` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `FailureDescription` text COLLATE utf8mb4_unicode_ci, + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `OrderIndex` int(11) NOT NULL DEFAULT '0', + `MapDifficultyID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `map_difficulty_x_condition_locale` +-- + +DROP TABLE IF EXISTS `map_difficulty_x_condition_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `map_difficulty_x_condition_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `FailureDescription_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `map_locale` -- @@ -5077,6 +5708,23 @@ CREATE TABLE `override_spell_data` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `paragon_reputation` +-- + +DROP TABLE IF EXISTS `paragon_reputation`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `paragon_reputation` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `FactionID` int(10) unsigned NOT NULL DEFAULT '0', + `LevelThreshold` int(11) NOT NULL DEFAULT '0', + `QuestID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `phase` -- @@ -5119,11 +5767,9 @@ CREATE TABLE `player_condition` ( `RaceMask` bigint(20) NOT NULL DEFAULT '0', `FailureDescription` text COLLATE utf8mb4_unicode_ci, `ID` int(10) unsigned NOT NULL DEFAULT '0', - `MinLevel` smallint(5) unsigned NOT NULL DEFAULT '0', - `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT '0', `ClassMask` int(11) NOT NULL DEFAULT '0', `SkillLogic` int(10) unsigned NOT NULL DEFAULT '0', - `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LanguageID` int(11) NOT NULL DEFAULT '0', `MinLanguage` tinyint(3) unsigned NOT NULL DEFAULT '0', `MaxLanguage` int(11) NOT NULL DEFAULT '0', `MaxFactionID` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -5139,7 +5785,7 @@ CREATE TABLE `player_condition` ( `ItemFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', `AuraSpellLogic` int(10) unsigned NOT NULL DEFAULT '0', `WorldStateExpressionID` smallint(5) unsigned NOT NULL DEFAULT '0', - `WeatherID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `WeatherID` int(11) NOT NULL DEFAULT '0', `PartyStatus` tinyint(3) unsigned NOT NULL DEFAULT '0', `LifetimeMaxPVPRank` tinyint(3) unsigned NOT NULL DEFAULT '0', `AchievementLogic` int(10) unsigned NOT NULL DEFAULT '0', @@ -5148,7 +5794,7 @@ CREATE TABLE `player_condition` ( `AreaLogic` int(10) unsigned NOT NULL DEFAULT '0', `LfgLogic` int(10) unsigned NOT NULL DEFAULT '0', `CurrencyLogic` int(10) unsigned NOT NULL DEFAULT '0', - `QuestKillID` smallint(5) unsigned NOT NULL DEFAULT '0', + `QuestKillID` int(11) NOT NULL DEFAULT '0', `QuestKillLogic` int(10) unsigned NOT NULL DEFAULT '0', `MinExpansionLevel` tinyint(4) NOT NULL DEFAULT '0', `MaxExpansionLevel` tinyint(4) NOT NULL DEFAULT '0', @@ -5159,7 +5805,7 @@ CREATE TABLE `player_condition` ( `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', `PhaseID` smallint(5) unsigned NOT NULL DEFAULT '0', `PhaseGroupID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', `ChrSpecializationIndex` tinyint(4) NOT NULL DEFAULT '0', `ChrSpecializationRole` tinyint(4) NOT NULL DEFAULT '0', `ModifierTreeID` int(10) unsigned NOT NULL DEFAULT '0', @@ -5173,6 +5819,8 @@ CREATE TABLE `player_condition` ( `MinExpansionTier` tinyint(4) NOT NULL DEFAULT '0', `MinPVPRank` tinyint(3) unsigned NOT NULL DEFAULT '0', `MaxPVPRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ContentTuningID` int(11) NOT NULL DEFAULT '0', + `CovenantID` int(11) NOT NULL DEFAULT '0', `SkillID1` smallint(5) unsigned NOT NULL DEFAULT '0', `SkillID2` smallint(5) unsigned NOT NULL DEFAULT '0', `SkillID3` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -5191,18 +5839,18 @@ CREATE TABLE `player_condition` ( `MinReputation1` tinyint(3) unsigned NOT NULL DEFAULT '0', `MinReputation2` tinyint(3) unsigned NOT NULL DEFAULT '0', `MinReputation3` tinyint(3) unsigned NOT NULL DEFAULT '0', - `PrevQuestID1` smallint(5) unsigned NOT NULL DEFAULT '0', - `PrevQuestID2` smallint(5) unsigned NOT NULL DEFAULT '0', - `PrevQuestID3` smallint(5) unsigned NOT NULL DEFAULT '0', - `PrevQuestID4` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrQuestID1` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrQuestID2` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrQuestID3` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrQuestID4` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID1` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID2` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID3` smallint(5) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID4` smallint(5) unsigned NOT NULL DEFAULT '0', + `PrevQuestID1` int(11) NOT NULL DEFAULT '0', + `PrevQuestID2` int(11) NOT NULL DEFAULT '0', + `PrevQuestID3` int(11) NOT NULL DEFAULT '0', + `PrevQuestID4` int(11) NOT NULL DEFAULT '0', + `CurrQuestID1` int(11) NOT NULL DEFAULT '0', + `CurrQuestID2` int(11) NOT NULL DEFAULT '0', + `CurrQuestID3` int(11) NOT NULL DEFAULT '0', + `CurrQuestID4` int(11) NOT NULL DEFAULT '0', + `CurrentCompletedQuestID1` int(11) NOT NULL DEFAULT '0', + `CurrentCompletedQuestID2` int(11) NOT NULL DEFAULT '0', + `CurrentCompletedQuestID3` int(11) NOT NULL DEFAULT '0', + `CurrentCompletedQuestID4` int(11) NOT NULL DEFAULT '0', `SpellID1` int(11) NOT NULL DEFAULT '0', `SpellID2` int(11) NOT NULL DEFAULT '0', `SpellID3` int(11) NOT NULL DEFAULT '0', @@ -5502,6 +6150,55 @@ CREATE TABLE `pvp_talent_slot_unlock` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `pvp_tier` +-- + +DROP TABLE IF EXISTS `pvp_tier`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pvp_tier` ( + `Name` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MinRating` smallint(6) NOT NULL DEFAULT '0', + `MaxRating` smallint(6) NOT NULL DEFAULT '0', + `PrevTier` int(11) NOT NULL DEFAULT '0', + `NextTier` int(11) NOT NULL DEFAULT '0', + `BracketID` tinyint(4) NOT NULL DEFAULT '0', + `Rank` tinyint(4) NOT NULL DEFAULT '0', + `RankIconFileDataID` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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_tier_locale` +-- + +DROP TABLE IF EXISTS `pvp_tier_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `pvp_tier_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `quest_faction_reward` -- @@ -5526,6 +6223,68 @@ CREATE TABLE `quest_faction_reward` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `quest_info` +-- + +DROP TABLE IF EXISTS `quest_info`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_info` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `InfoName` text COLLATE utf8mb4_unicode_ci, + `Type` tinyint(4) NOT NULL DEFAULT '0', + `Modifiers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Profession` smallint(5) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `quest_info_locale` +-- + +DROP TABLE IF EXISTS `quest_info_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_info_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, + `InfoName_lang` text COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int(11) 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 `quest_line_x_quest` +-- + +DROP TABLE IF EXISTS `quest_line_x_quest`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_line_x_quest` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `QuestLineID` int(10) unsigned NOT NULL DEFAULT '0', + `QuestID` int(10) unsigned NOT NULL DEFAULT '0', + `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `quest_money_reward` -- @@ -5659,13 +6418,30 @@ DROP TABLE IF EXISTS `rand_prop_points`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rand_prop_points` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', + `DamageReplaceStatF` float NOT NULL DEFAULT '0', + `DamageSecondaryF` float NOT NULL DEFAULT '0', `DamageReplaceStat` int(11) NOT NULL DEFAULT '0', `DamageSecondary` int(11) NOT NULL DEFAULT '0', + `EpicF1` float NOT NULL DEFAULT '0', + `EpicF2` float NOT NULL DEFAULT '0', + `EpicF3` float NOT NULL DEFAULT '0', + `EpicF4` float NOT NULL DEFAULT '0', + `EpicF5` float NOT NULL DEFAULT '0', `Epic1` int(10) unsigned NOT NULL DEFAULT '0', `Epic2` int(10) unsigned NOT NULL DEFAULT '0', `Epic3` int(10) unsigned NOT NULL DEFAULT '0', `Epic4` int(10) unsigned NOT NULL DEFAULT '0', `Epic5` int(10) unsigned NOT NULL DEFAULT '0', + `SuperiorF1` float NOT NULL DEFAULT '0', + `SuperiorF2` float NOT NULL DEFAULT '0', + `SuperiorF3` float NOT NULL DEFAULT '0', + `SuperiorF4` float NOT NULL DEFAULT '0', + `SuperiorF5` float NOT NULL DEFAULT '0', + `GoodF1` float NOT NULL DEFAULT '0', + `GoodF2` float NOT NULL DEFAULT '0', + `GoodF3` float NOT NULL DEFAULT '0', + `GoodF4` float NOT NULL DEFAULT '0', + `GoodF5` float NOT NULL DEFAULT '0', `Superior1` int(10) unsigned NOT NULL DEFAULT '0', `Superior2` int(10) unsigned NOT NULL DEFAULT '0', `Superior3` int(10) unsigned NOT NULL DEFAULT '0', @@ -5735,23 +6511,6 @@ CREATE TABLE `reward_pack_x_item` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `scaling_stat_distribution` --- - -DROP TABLE IF EXISTS `scaling_stat_distribution`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `scaling_stat_distribution` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `PlayerLevelToItemLevelCurveID` smallint(5) unsigned NOT NULL DEFAULT '0', - `MinLevel` int(11) NOT NULL DEFAULT '0', - `MaxLevel` int(11) NOT NULL DEFAULT '0', - `VerifiedBuild` int(11) 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 `scenario` -- @@ -5811,7 +6570,7 @@ CREATE TABLE `scenario_step` ( `Title` text COLLATE utf8mb4_unicode_ci, `ScenarioID` smallint(5) unsigned NOT NULL DEFAULT '0', `Criteriatreeid` int(10) unsigned NOT NULL DEFAULT '0', - `RewardQuestID` smallint(5) unsigned NOT NULL DEFAULT '0', + `RewardQuestID` int(11) NOT NULL DEFAULT '0', `RelatedStep` int(11) NOT NULL DEFAULT '0', `Supersedes` smallint(5) unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -5958,7 +6717,7 @@ CREATE TABLE `skill_line_ability` ( `AcquireMethod` tinyint(4) NOT NULL DEFAULT '0', `TrivialSkillLineRankHigh` smallint(6) NOT NULL DEFAULT '0', `TrivialSkillLineRankLow` smallint(6) NOT NULL DEFAULT '0', - `Flags` tinyint(4) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', `NumSkillUps` tinyint(4) NOT NULL DEFAULT '0', `UniqueBit` smallint(6) NOT NULL DEFAULT '0', `TradeSkillCategoryID` smallint(6) NOT NULL DEFAULT '0', @@ -6167,7 +6926,6 @@ DROP TABLE IF EXISTS `spell_cast_times`; CREATE TABLE `spell_cast_times` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Base` int(11) NOT NULL DEFAULT '0', - `PerLevel` smallint(6) NOT NULL DEFAULT '0', `Minimum` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6315,7 +7073,6 @@ DROP TABLE IF EXISTS `spell_duration`; CREATE TABLE `spell_duration` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Duration` int(11) NOT NULL DEFAULT '0', - `DurationPerLevel` int(10) unsigned NOT NULL DEFAULT '0', `MaxDuration` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6334,7 +7091,7 @@ CREATE TABLE `spell_effect` ( `EffectAura` smallint(6) NOT NULL DEFAULT '0', `DifficultyID` int(11) NOT NULL DEFAULT '0', `EffectIndex` int(11) NOT NULL DEFAULT '0', - `Effect` int(10) unsigned NOT NULL DEFAULT '0', + `Effect` int(11) NOT NULL DEFAULT '0', `EffectAmplitude` float NOT NULL DEFAULT '0', `EffectAttributes` int(11) NOT NULL DEFAULT '0', `EffectAuraPeriod` int(11) NOT NULL DEFAULT '0', @@ -6459,18 +7216,20 @@ DROP TABLE IF EXISTS `spell_item_enchantment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_item_enchantment` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text COLLATE utf8mb4_unicode_ci, `HordeName` text COLLATE utf8mb4_unicode_ci, + `ID` int(10) unsigned NOT NULL DEFAULT '0', `EffectArg1` int(10) unsigned NOT NULL DEFAULT '0', `EffectArg2` int(10) unsigned NOT NULL DEFAULT '0', `EffectArg3` int(10) unsigned NOT NULL DEFAULT '0', `EffectScalingPoints1` float NOT NULL DEFAULT '0', `EffectScalingPoints2` float NOT NULL DEFAULT '0', `EffectScalingPoints3` float NOT NULL DEFAULT '0', - `TransmogPlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', - `TransmogCost` int(10) unsigned NOT NULL DEFAULT '0', `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `TransmogCost` int(10) unsigned NOT NULL DEFAULT '0', + `MinItemLevel` int(11) NOT NULL DEFAULT '0', + `MaxItemLevel` int(11) NOT NULL DEFAULT '0', + `TransmogUseConditionID` int(10) unsigned NOT NULL DEFAULT '0', `EffectPointsMin1` smallint(6) NOT NULL DEFAULT '0', `EffectPointsMin2` smallint(6) NOT NULL DEFAULT '0', `EffectPointsMin3` smallint(6) NOT NULL DEFAULT '0', @@ -6565,6 +7324,22 @@ CREATE TABLE `spell_item_enchantment_locale` ( PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `spell_label` +-- + +DROP TABLE IF EXISTS `spell_label`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_label` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `LabelID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `spell_learn_spell` -- @@ -6592,10 +7367,10 @@ DROP TABLE IF EXISTS `spell_levels`; CREATE TABLE `spell_levels` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `BaseLevel` smallint(6) NOT NULL DEFAULT '0', `MaxLevel` smallint(6) NOT NULL DEFAULT '0', - `SpellLevel` smallint(6) NOT NULL DEFAULT '0', `MaxPassiveAuraLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BaseLevel` int(11) NOT NULL DEFAULT '0', + `SpellLevel` int(11) NOT NULL DEFAULT '0', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6625,6 +7400,7 @@ CREATE TABLE `spell_misc` ( `Attributes12` int(11) NOT NULL DEFAULT '0', `Attributes13` int(11) NOT NULL DEFAULT '0', `Attributes14` int(11) NOT NULL DEFAULT '0', + `Attributes15` int(11) NOT NULL DEFAULT '0', `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', `CastingTimeIndex` smallint(5) unsigned NOT NULL DEFAULT '0', `DurationIndex` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -6636,6 +7412,9 @@ CREATE TABLE `spell_misc` ( `SpellIconFileDataID` int(11) NOT NULL DEFAULT '0', `ActiveIconFileDataID` int(11) NOT NULL DEFAULT '0', `ContentTuningID` int(11) NOT NULL DEFAULT '0', + `ShowFutureSpellPlayerConditionID` int(11) NOT NULL DEFAULT '0', + `SpellVisualScript` int(11) NOT NULL DEFAULT '0', + `ActiveSpellVisualScript` int(11) NOT NULL DEFAULT '0', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6753,7 +7532,7 @@ DROP TABLE IF EXISTS `spell_procs_per_minute_mod`; CREATE TABLE `spell_procs_per_minute_mod` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `Param` smallint(6) NOT NULL DEFAULT '0', + `Param` int(11) NOT NULL DEFAULT '0', `Coeff` float NOT NULL DEFAULT '0', `SpellProcsPerMinuteID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -7032,7 +7811,6 @@ CREATE TABLE `spell_x_spell_visual` ( `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', `SpellVisualID` int(10) unsigned NOT NULL DEFAULT '0', `Probability` float NOT NULL DEFAULT '0', - `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `Priority` tinyint(3) unsigned NOT NULL DEFAULT '0', `SpellIconFileID` int(11) NOT NULL DEFAULT '0', `ActiveIconFileID` int(11) NOT NULL DEFAULT '0', @@ -7351,6 +8129,24 @@ CREATE TABLE `transmog_holiday` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `transmog_illusion` +-- + +DROP TABLE IF EXISTS `transmog_illusion`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `transmog_illusion` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `UnlockConditionID` int(11) NOT NULL DEFAULT '0', + `TransmogCost` int(11) NOT NULL DEFAULT '0', + `SpellItemEnchantmentID` int(11) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) 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 `transmog_set` -- @@ -7517,14 +8313,13 @@ CREATE TABLE `ui_map` ( `Flags` int(11) NOT NULL DEFAULT '0', `System` int(11) NOT NULL DEFAULT '0', `Type` int(11) NOT NULL DEFAULT '0', - `LevelRangeMin` int(10) unsigned NOT NULL DEFAULT '0', - `LevelRangeMax` int(10) unsigned NOT NULL DEFAULT '0', `BountySetID` int(11) NOT NULL DEFAULT '0', `BountyDisplayLocation` int(10) unsigned NOT NULL DEFAULT '0', `VisibilityPlayerConditionID` int(11) NOT NULL DEFAULT '0', `HelpTextPosition` tinyint(4) NOT NULL DEFAULT '0', `BkgAtlasID` int(11) NOT NULL DEFAULT '0', `AlternateUiMapGroup` int(11) NOT NULL DEFAULT '0', + `ContentTuningID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7578,6 +8373,7 @@ CREATE TABLE `ui_map_link` ( `ChildUiMapID` int(11) NOT NULL DEFAULT '0', `OverrideHighlightFileDataID` int(11) NOT NULL DEFAULT '0', `OverrideHighlightAtlasID` int(11) NOT NULL DEFAULT '0', + `Flags` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7750,9 +8546,9 @@ CREATE TABLE `vehicle` ( `FacingLimitRight` float NOT NULL DEFAULT '0', `FacingLimitLeft` float NOT NULL DEFAULT '0', `CameraYawOffset` float NOT NULL DEFAULT '0', - `UiLocomotionType` tinyint(3) unsigned NOT NULL DEFAULT '0', `VehicleUIIndicatorID` smallint(5) unsigned NOT NULL DEFAULT '0', `MissileTargetingID` int(11) NOT NULL DEFAULT '0', + `VehiclePOITypeID` smallint(5) unsigned NOT NULL DEFAULT '0', `SeatID1` smallint(5) unsigned NOT NULL DEFAULT '0', `SeatID2` smallint(5) unsigned NOT NULL DEFAULT '0', `SeatID3` smallint(5) unsigned NOT NULL DEFAULT '0', @@ -7980,4 +8776,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-10-20 21:36:54 +-- Dump completed on 2021-07-04 22:23:28 diff --git a/sql/base/dev/world_database.sql b/sql/base/dev/world_database.sql index 2075f6ec9f1..a22e0044097 100644 --- a/sql/base/dev/world_database.sql +++ b/sql/base/dev/world_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.7.30, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 5.7.34, for Linux (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ --- Server version 5.7.30-0ubuntu0.18.04.1 +-- Server version 5.7.34 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -93,6 +93,30 @@ CREATE TABLE `achievement_reward_locale` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `areatrigger` +-- + +DROP TABLE IF EXISTS `areatrigger`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `areatrigger` ( + `SpawnId` bigint(20) unsigned NOT NULL, + `AreaTriggerId` int(10) unsigned NOT NULL, + `IsServerSide` tinyint(1) unsigned NOT NULL, + `MapId` int(10) unsigned NOT NULL, + `PosX` float NOT NULL, + `PosY` float NOT NULL, + `PosZ` float NOT NULL, + `Orientation` float NOT NULL, + `PhaseUseFlags` tinyint(3) unsigned DEFAULT '0', + `PhaseId` int(10) unsigned DEFAULT '0', + `PhaseGroup` int(10) unsigned DEFAULT '0', + `Comment` varchar(255) DEFAULT NULL, + PRIMARY KEY (`SpawnId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `areatrigger_involvedrelation` -- @@ -160,6 +184,7 @@ DROP TABLE IF EXISTS `areatrigger_template`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `areatrigger_template` ( `Id` int(10) unsigned NOT NULL, + `IsServerSide` tinyint(1) unsigned NOT NULL, `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Data0` float NOT NULL DEFAULT '0', @@ -170,7 +195,7 @@ CREATE TABLE `areatrigger_template` ( `Data5` float NOT NULL DEFAULT '0', `ScriptName` char(64) NOT NULL DEFAULT '', `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`Id`) + PRIMARY KEY (`Id`,`IsServerSide`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -183,10 +208,11 @@ DROP TABLE IF EXISTS `areatrigger_template_actions`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `areatrigger_template_actions` ( `AreaTriggerId` int(10) unsigned NOT NULL, + `IsServerSide` tinyint(1) unsigned NOT NULL, `ActionType` int(10) unsigned NOT NULL, `ActionParam` int(10) unsigned NOT NULL, `TargetType` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`AreaTriggerId`,`ActionType`,`ActionParam`) + PRIMARY KEY (`AreaTriggerId`,`IsServerSide`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -379,22 +405,6 @@ CREATE TABLE `conditions` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Condition System'; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `conversation_actor_template` --- - -DROP TABLE IF EXISTS `conversation_actor_template`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `conversation_actor_template` ( - `Id` int(10) unsigned NOT NULL, - `CreatureId` int(10) unsigned NOT NULL DEFAULT '0', - `CreatureModelId` int(10) unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0', - PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `conversation_actors` -- @@ -407,6 +417,8 @@ CREATE TABLE `conversation_actors` ( `ConversationActorId` int(10) unsigned NOT NULL DEFAULT '0', `ConversationActorGuid` bigint(20) unsigned NOT NULL DEFAULT '0', `Idx` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureId` int(10) unsigned NOT NULL DEFAULT '0', + `CreatureDisplayInfoId` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ConversationId`,`Idx`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -780,11 +792,11 @@ CREATE TABLE `creature_template` ( `ExperienceModifier` float NOT NULL DEFAULT '1', `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0', `movementId` int(11) unsigned NOT NULL DEFAULT '0', - `FadeRegionRadius` float NOT NULL DEFAULT '0', `WidgetSetID` int(11) NOT NULL DEFAULT '0', `WidgetSetUnitConditionID` int(11) NOT NULL DEFAULT '0', `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1', `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0', + `spell_school_immune_mask` int(3) unsigned NOT NULL DEFAULT '0', `flags_extra` int(10) unsigned NOT NULL DEFAULT '0', `ScriptName` varchar(64) NOT NULL DEFAULT '', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -1058,6 +1070,7 @@ CREATE TABLE `game_event` ( `occurence` bigint(20) unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event', `length` bigint(20) unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event', `holiday` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', + `holidayStage` tinyint(3) unsigned NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console', `world_event` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event', `announce` tinyint(3) unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', @@ -1299,7 +1312,7 @@ CREATE TABLE `game_tele` ( `map` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) -) ENGINE=MyISAM AUTO_INCREMENT=1683 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; +) ENGINE=MyISAM AUTO_INCREMENT=1689 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -1379,6 +1392,7 @@ CREATE TABLE `gameobject_addon` ( `invisibilityType` tinyint(3) unsigned NOT NULL DEFAULT '0', `invisibilityValue` int(10) unsigned NOT NULL DEFAULT '0', `WorldEffectID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `AIAnimKitID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -1499,7 +1513,7 @@ CREATE TABLE `gameobject_template` ( `Data31` int(10) NOT NULL DEFAULT '0', `Data32` int(10) NOT NULL DEFAULT '0', `Data33` int(11) NOT NULL DEFAULT '0', - `RequiredLevel` int(10) NOT NULL DEFAULT '0', + `ContentTuningId` int(11) NOT NULL DEFAULT '0', `AIName` char(64) NOT NULL DEFAULT '', `ScriptName` varchar(64) NOT NULL DEFAULT '', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -1522,6 +1536,7 @@ CREATE TABLE `gameobject_template_addon` ( `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0', `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0', `WorldEffectID` mediumint(8) unsigned NOT NULL DEFAULT '0', + `AIAnimKitID` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2338,6 +2353,7 @@ DROP TABLE IF EXISTS `playerchoice_response`; CREATE TABLE `playerchoice_response` ( `ChoiceId` int(11) NOT NULL, `ResponseId` int(11) NOT NULL, + `ResponseIdentifier` smallint(5) unsigned NOT NULL, `Index` int(10) unsigned NOT NULL, `ChoiceArtFileId` int(11) NOT NULL DEFAULT '0', `Flags` int(11) NOT NULL DEFAULT '0', @@ -2345,6 +2361,7 @@ CREATE TABLE `playerchoice_response` ( `UiTextureAtlasElementID` int(10) unsigned NOT NULL DEFAULT '0', `SoundKitID` int(10) unsigned NOT NULL DEFAULT '0', `GroupID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `UiTextureKitID` int(11) NOT NULL DEFAULT '0', `Header` varchar(511) NOT NULL, `SubHeader` varchar(100) NOT NULL DEFAULT '', `ButtonTooltip` varchar(400) NOT NULL DEFAULT '', @@ -2379,6 +2396,26 @@ CREATE TABLE `playerchoice_response_locale` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `playerchoice_response_maw_power` +-- + +DROP TABLE IF EXISTS `playerchoice_response_maw_power`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playerchoice_response_maw_power` ( + `ChoiceId` int(11) NOT NULL, + `ResponseId` int(11) NOT NULL, + `TypeArtFileID` int(11) DEFAULT '0', + `Rarity` int(11) DEFAULT '0', + `RarityColor` int(10) unsigned DEFAULT '0', + `SpellID` int(11) DEFAULT '0', + `MaxStacks` int(11) DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ChoiceId`,`ResponseId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `playerchoice_response_reward` -- @@ -2457,6 +2494,25 @@ CREATE TABLE `playerchoice_response_reward_item` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `playerchoice_response_reward_item_choice` +-- + +DROP TABLE IF EXISTS `playerchoice_response_reward_item_choice`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `playerchoice_response_reward_item_choice` ( + `ChoiceId` int(11) NOT NULL, + `ResponseId` int(11) NOT NULL, + `Index` int(10) unsigned NOT NULL, + `ItemId` int(10) unsigned NOT NULL DEFAULT '0', + `BonusListIDs` text, + `Quantity` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`ChoiceId`,`ResponseId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `playercreateinfo` -- @@ -2559,6 +2615,7 @@ CREATE TABLE `points_of_interest` ( `Flags` mediumint(8) unsigned NOT NULL DEFAULT '0', `Importance` mediumint(8) unsigned NOT NULL DEFAULT '0', `Name` text, + `Unknown905` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2855,6 +2912,7 @@ CREATE TABLE `quest_poi` ( `Flags` int(11) NOT NULL DEFAULT '0', `WorldEffectID` int(11) NOT NULL DEFAULT '0', `PlayerConditionID` int(11) NOT NULL DEFAULT '0', + `NavigationPlayerConditionID` int(11) NOT NULL DEFAULT '0', `SpawnTrackingID` int(11) NOT NULL DEFAULT '0', `AlwaysAllowMergingBlobs` tinyint(1) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', @@ -2876,6 +2934,7 @@ CREATE TABLE `quest_poi_points` ( `Idx2` int(11) NOT NULL DEFAULT '0', `X` int(11) NOT NULL DEFAULT '0', `Y` int(11) NOT NULL DEFAULT '0', + `Z` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`QuestID`,`Idx1`,`Idx2`), KEY `questId_id` (`QuestID`) @@ -2917,6 +2976,43 @@ CREATE TABLE `quest_request_items_locale` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `quest_reward_choice_items` +-- + +DROP TABLE IF EXISTS `quest_reward_choice_items`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_reward_choice_items` ( + `QuestID` int(10) unsigned NOT NULL, + `Type1` tinyint(3) unsigned DEFAULT '0', + `Type2` tinyint(3) unsigned DEFAULT '0', + `Type3` tinyint(3) unsigned DEFAULT '0', + `Type4` tinyint(3) unsigned DEFAULT '0', + `Type5` tinyint(3) unsigned DEFAULT '0', + `Type6` tinyint(3) unsigned DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`QuestID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `quest_reward_display_spell` +-- + +DROP TABLE IF EXISTS `quest_reward_display_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `quest_reward_display_spell` ( + `QuestID` int(10) unsigned NOT NULL, + `Idx` int(10) unsigned NOT NULL, + `SpellID` int(10) unsigned DEFAULT '0', + `PlayerConditionID` int(10) unsigned DEFAULT '0', + `VerifiedBuild` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`QuestID`,`Idx`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `quest_template` -- @@ -2927,11 +3023,8 @@ DROP TABLE IF EXISTS `quest_template`; CREATE TABLE `quest_template` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `QuestType` tinyint(3) unsigned NOT NULL DEFAULT '2', - `QuestLevel` int(11) NOT NULL DEFAULT '-1', - `ScalingFactionGroup` int(11) NOT NULL DEFAULT '0', - `MaxScalingLevel` int(11) NOT NULL DEFAULT '255', `QuestPackageID` int(10) unsigned NOT NULL DEFAULT '0', - `MinLevel` int(11) NOT NULL DEFAULT '0', + `ContentTuningID` int(10) unsigned NOT NULL DEFAULT '0', `QuestSortID` smallint(6) NOT NULL DEFAULT '0', `QuestInfoID` smallint(5) unsigned NOT NULL DEFAULT '0', `SuggestedGroupNum` tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -3003,23 +3096,23 @@ CREATE TABLE `quest_template` ( `RewardFactionID1` int(10) unsigned NOT NULL DEFAULT '0', `RewardFactionValue1` int(11) NOT NULL DEFAULT '0', `RewardFactionOverride1` int(11) NOT NULL DEFAULT '0', - `RewardFactionCapIn1` int(10) unsigned NOT NULL DEFAULT '0', + `RewardFactionCapIn1` int(10) NOT NULL DEFAULT '0', `RewardFactionID2` int(10) unsigned NOT NULL DEFAULT '0', `RewardFactionValue2` int(11) NOT NULL DEFAULT '0', `RewardFactionOverride2` int(11) NOT NULL DEFAULT '0', - `RewardFactionCapIn2` int(10) unsigned NOT NULL DEFAULT '0', + `RewardFactionCapIn2` int(10) NOT NULL DEFAULT '0', `RewardFactionID3` int(10) unsigned NOT NULL DEFAULT '0', `RewardFactionValue3` int(11) NOT NULL DEFAULT '0', `RewardFactionOverride3` int(11) NOT NULL DEFAULT '0', - `RewardFactionCapIn3` int(10) unsigned NOT NULL DEFAULT '0', + `RewardFactionCapIn3` int(10) NOT NULL DEFAULT '0', `RewardFactionID4` int(10) unsigned NOT NULL DEFAULT '0', `RewardFactionValue4` int(11) NOT NULL DEFAULT '0', `RewardFactionOverride4` int(11) NOT NULL DEFAULT '0', - `RewardFactionCapIn4` int(10) unsigned NOT NULL DEFAULT '0', + `RewardFactionCapIn4` int(10) NOT NULL DEFAULT '0', `RewardFactionID5` int(10) unsigned NOT NULL DEFAULT '0', `RewardFactionValue5` int(11) NOT NULL DEFAULT '0', `RewardFactionOverride5` int(11) NOT NULL DEFAULT '0', - `RewardFactionCapIn5` int(10) unsigned NOT NULL DEFAULT '0', + `RewardFactionCapIn5` int(10) NOT NULL DEFAULT '0', `RewardFactionFlags` int(10) unsigned NOT NULL DEFAULT '0', `RewardCurrencyID1` int(10) unsigned NOT NULL DEFAULT '0', `RewardCurrencyQty1` int(10) unsigned NOT NULL DEFAULT '0', @@ -3224,6 +3317,7 @@ CREATE TABLE `scenario_poi` ( `Flags` int(11) NOT NULL DEFAULT '0', `WorldEffectID` int(11) NOT NULL DEFAULT '0', `PlayerConditionID` int(11) NOT NULL DEFAULT '0', + `NavigationPlayerConditionID` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`CriteriaTreeID`,`BlobIndex`,`Idx1`), KEY `idx` (`CriteriaTreeID`,`BlobIndex`) @@ -3243,6 +3337,7 @@ CREATE TABLE `scenario_poi_points` ( `Idx2` int(11) NOT NULL DEFAULT '0', `X` int(11) NOT NULL DEFAULT '0', `Y` int(11) NOT NULL DEFAULT '0', + `Z` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`CriteriaTreeID`,`Idx1`,`Idx2`), KEY `questId_id` (`CriteriaTreeID`) @@ -3276,6 +3371,7 @@ CREATE TABLE `scene_template` ( `SceneId` int(10) unsigned NOT NULL, `Flags` int(10) unsigned NOT NULL DEFAULT '0', `ScriptPackageID` int(10) unsigned NOT NULL DEFAULT '0', + `Encrypted` tinyint(1) unsigned NOT NULL DEFAULT '0', `ScriptName` varchar(64) NOT NULL DEFAULT '', PRIMARY KEY (`SceneId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3336,6 +3432,140 @@ CREATE TABLE `script_waypoint` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `serverside_spell` +-- + +DROP TABLE IF EXISTS `serverside_spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `serverside_spell` ( + `Id` int(10) unsigned NOT NULL, + `DifficultyID` int(11) NOT NULL DEFAULT '0', + `CategoryId` int(10) unsigned NOT NULL DEFAULT '0', + `Dispel` int(10) unsigned NOT NULL DEFAULT '0', + `Mechanic` int(10) unsigned NOT NULL DEFAULT '0', + `Attributes` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx2` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx6` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx7` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx8` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx9` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx10` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx11` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx12` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx13` int(10) unsigned NOT NULL DEFAULT '0', + `AttributesEx14` int(10) unsigned NOT NULL DEFAULT '0', + `Stances` bigint(20) unsigned NOT NULL DEFAULT '0', + `StancesNot` bigint(20) unsigned NOT NULL DEFAULT '0', + `Targets` int(10) unsigned NOT NULL DEFAULT '0', + `TargetCreatureType` int(10) unsigned NOT NULL DEFAULT '0', + `RequiresSpellFocus` int(10) unsigned NOT NULL DEFAULT '0', + `FacingCasterFlags` int(10) unsigned NOT NULL DEFAULT '0', + `CasterAuraState` int(10) unsigned NOT NULL DEFAULT '0', + `TargetAuraState` int(10) unsigned NOT NULL DEFAULT '0', + `ExcludeCasterAuraState` int(10) unsigned NOT NULL DEFAULT '0', + `ExcludeTargetAuraState` int(10) unsigned NOT NULL DEFAULT '0', + `CasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', + `TargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', + `ExcludeCasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', + `ExcludeTargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', + `CastingTimeIndex` int(10) unsigned NOT NULL DEFAULT '1', + `RecoveryTime` int(10) unsigned NOT NULL DEFAULT '0', + `CategoryRecoveryTime` int(10) unsigned NOT NULL DEFAULT '0', + `StartRecoveryCategory` int(10) unsigned NOT NULL DEFAULT '0', + `StartRecoveryTime` int(10) unsigned NOT NULL DEFAULT '0', + `InterruptFlags` int(10) unsigned NOT NULL DEFAULT '0', + `AuraInterruptFlags1` int(10) unsigned NOT NULL DEFAULT '0', + `AuraInterruptFlags2` int(10) unsigned NOT NULL DEFAULT '0', + `ChannelInterruptFlags1` int(10) unsigned NOT NULL DEFAULT '0', + `ChannelInterruptFlags2` int(10) unsigned NOT NULL DEFAULT '0', + `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0', + `ProcChance` int(10) unsigned NOT NULL DEFAULT '0', + `ProcCharges` int(10) unsigned NOT NULL DEFAULT '0', + `ProcCooldown` int(10) unsigned NOT NULL DEFAULT '0', + `ProcBasePPM` float NOT NULL DEFAULT '0', + `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', + `BaseLevel` int(10) unsigned NOT NULL DEFAULT '0', + `SpellLevel` int(10) unsigned NOT NULL DEFAULT '0', + `DurationIndex` int(10) unsigned NOT NULL DEFAULT '0', + `RangeIndex` int(10) unsigned NOT NULL DEFAULT '1', + `Speed` float NOT NULL DEFAULT '0', + `LaunchDelay` float NOT NULL DEFAULT '0', + `StackAmount` int(10) unsigned NOT NULL DEFAULT '0', + `EquippedItemClass` int(11) NOT NULL DEFAULT '-1', + `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0', + `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0', + `ContentTuningId` int(10) unsigned NOT NULL DEFAULT '0', + `SpellName` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, + `ConeAngle` float NOT NULL DEFAULT '0', + `ConeWidth` float NOT NULL DEFAULT '0', + `MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0', + `MaxAffectedTargets` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyName` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags2` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags3` int(10) unsigned NOT NULL DEFAULT '0', + `SpellFamilyFlags4` int(10) unsigned NOT NULL DEFAULT '0', + `DmgClass` int(10) unsigned NOT NULL DEFAULT '0', + `PreventionType` int(10) unsigned NOT NULL DEFAULT '0', + `AreaGroupId` int(11) NOT NULL DEFAULT '0', + `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0', + `ChargeCategoryId` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`Id`,`DifficultyID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `serverside_spell_effect` +-- + +DROP TABLE IF EXISTS `serverside_spell_effect`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `serverside_spell_effect` ( + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `EffectIndex` int(11) NOT NULL DEFAULT '0', + `DifficultyID` int(11) NOT NULL DEFAULT '0', + `Effect` int(11) NOT NULL DEFAULT '0', + `EffectAura` smallint(11) NOT NULL DEFAULT '0', + `EffectAmplitude` float NOT NULL DEFAULT '0', + `EffectAttributes` int(11) NOT NULL DEFAULT '0', + `EffectAuraPeriod` int(11) NOT NULL DEFAULT '0', + `EffectBonusCoefficient` float NOT NULL DEFAULT '0', + `EffectChainAmplitude` float NOT NULL DEFAULT '0', + `EffectChainTargets` int(11) NOT NULL DEFAULT '0', + `EffectItemType` int(11) NOT NULL DEFAULT '0', + `EffectMechanic` int(11) NOT NULL DEFAULT '0', + `EffectPointsPerResource` float NOT NULL DEFAULT '0', + `EffectPosFacing` float NOT NULL DEFAULT '0', + `EffectRealPointsPerLevel` float NOT NULL DEFAULT '0', + `EffectTriggerSpell` int(11) NOT NULL DEFAULT '0', + `BonusCoefficientFromAP` float NOT NULL DEFAULT '0', + `PvpMultiplier` float NOT NULL DEFAULT '0', + `Coefficient` float NOT NULL DEFAULT '0', + `Variance` float NOT NULL DEFAULT '0', + `ResourceCoefficient` float NOT NULL DEFAULT '0', + `GroupSizeBasePointsCoefficient` float NOT NULL DEFAULT '0', + `EffectBasePoints` float NOT NULL DEFAULT '0', + `EffectMiscValue1` int(11) NOT NULL DEFAULT '0', + `EffectMiscValue2` int(11) NOT NULL DEFAULT '0', + `EffectRadiusIndex1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectRadiusIndex2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMask1` int(11) NOT NULL DEFAULT '0', + `EffectSpellClassMask2` int(11) NOT NULL DEFAULT '0', + `EffectSpellClassMask3` int(11) NOT NULL DEFAULT '0', + `EffectSpellClassMask4` int(11) NOT NULL DEFAULT '0', + `ImplicitTarget1` smallint(11) NOT NULL DEFAULT '0', + `ImplicitTarget2` smallint(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`SpellID`,`EffectIndex`,`DifficultyID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `skill_discovery_template` -- @@ -3614,49 +3844,12 @@ DROP TABLE IF EXISTS `spell_custom_attr`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_custom_attr` ( - `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', - `attributes` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', + `entry` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', + `attributes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SpellInfo custom attributes'; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `spell_dbc` --- - -DROP TABLE IF EXISTS `spell_dbc`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `spell_dbc` ( - `Id` int(10) unsigned NOT NULL, - `Attributes` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx2` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx6` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx7` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx8` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx9` int(10) unsigned NOT NULL DEFAULT '0', - `AttributesEx10` int(10) unsigned NOT NULL DEFAULT '0', - `CastingTimeIndex` int(10) unsigned NOT NULL DEFAULT '1', - `DurationIndex` int(10) unsigned NOT NULL DEFAULT '0', - `RangeIndex` int(10) unsigned NOT NULL DEFAULT '1', - `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0', - `SpellAuraOptionsId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellCastingRequirementsId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellCategoriesId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellClassOptionsId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellEquippedItemsId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellLevelsId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellTargetRestrictionsId` int(10) unsigned NOT NULL DEFAULT '0', - `SpellInterruptsId` int(10) unsigned NOT NULL DEFAULT '0', - `Comment` text NOT NULL, - PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Custom spell.dbc entries'; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `spell_enchant_proc_data` -- @@ -3900,43 +4093,6 @@ CREATE TABLE `spell_totem_model` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `spelleffect_dbc` --- - -DROP TABLE IF EXISTS `spelleffect_dbc`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `spelleffect_dbc` ( - `Id` int(10) unsigned NOT NULL, - `Effect` int(10) unsigned NOT NULL DEFAULT '0', - `EffectValueMultiplier` float unsigned NOT NULL DEFAULT '0', - `EffectApplyAuraName` int(10) unsigned NOT NULL DEFAULT '0', - `EffectAmplitude` int(10) unsigned NOT NULL DEFAULT '0', - `EffectBasePoints` int(10) NOT NULL DEFAULT '0', - `EffectBonusMultiplier` float unsigned NOT NULL DEFAULT '0', - `EffectDamageMultiplier` float unsigned NOT NULL DEFAULT '0', - `EffectChainTarget` int(10) unsigned NOT NULL DEFAULT '0', - `EffectDieSides` int(10) NOT NULL DEFAULT '0', - `EffectItemType` int(10) unsigned NOT NULL DEFAULT '0', - `EffectMechanic` int(10) unsigned NOT NULL DEFAULT '0', - `EffectMiscValue` int(10) NOT NULL DEFAULT '0', - `EffectMiscValueB` int(10) NOT NULL DEFAULT '0', - `EffectRadiusIndex` int(10) unsigned NOT NULL DEFAULT '0', - `EffectRadiusIndexMax` int(10) unsigned NOT NULL DEFAULT '0', - `EffectRealPointsPerLevel` float unsigned NOT NULL DEFAULT '0', - `EffectSpellClassMaskA` int(10) unsigned NOT NULL DEFAULT '0', - `EffectSpellClassMaskB` int(10) unsigned NOT NULL DEFAULT '0', - `EffectSpellClassMaskC` int(10) unsigned NOT NULL DEFAULT '0', - `EffectTriggerSpell` int(10) unsigned NOT NULL DEFAULT '0', - `EffectImplicitTargetA` int(10) unsigned NOT NULL DEFAULT '0', - `EffectImplicitTargetB` int(10) unsigned NOT NULL DEFAULT '0', - `EffectSpellId` int(10) unsigned NOT NULL, - `EffectIndex` int(10) unsigned NOT NULL, - PRIMARY KEY (`Id`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `terrain_swap_defaults` -- @@ -4113,6 +4269,20 @@ CREATE TABLE `vehicle_accessory` ( ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `vehicle_template` +-- + +DROP TABLE IF EXISTS `vehicle_template`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `vehicle_template` ( + `creatureId` int(10) unsigned NOT NULL, + `despawnDelayMs` int(11) NOT NULL DEFAULT '0', + PRIMARY KEY (`creatureId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `vehicle_template_accessory` -- @@ -4264,4 +4434,4 @@ CREATE TABLE `world_safe_locs` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2020-10-20 21:36:52 +-- Dump completed on 2021-07-04 22:23:27 -- cgit v1.2.3