diff options
| author | funjoker <funjoker109@gmail.com> | 2023-12-21 00:28:23 +0100 |
|---|---|---|
| committer | funjoker <funjoker109@gmail.com> | 2023-12-21 00:28:23 +0100 |
| commit | f5c8b53b2e3d4203d74ba1af2b0345efe7609db3 (patch) | |
| tree | 00ac035c9629feb07060c3a3a4dac1a247cac36d /sql/base/dev/hotfixes_database.sql | |
| parent | e5bf7ab086b51601985f2bbcafa62beee23be166 (diff) | |
TDB 343.23121 - 2023/12/20TDB343.23121
Diffstat (limited to 'sql/base/dev/hotfixes_database.sql')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 992 |
1 files changed, 619 insertions, 373 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 0c290f39e03..839fdba2588 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 8.0.34, for Linux (x86_64) +-- MySQL dump 10.13 Distrib 8.0.35, for Win64 (x86_64) -- -- Host: localhost Database: hotfixes -- ------------------------------------------------------ --- Server version 8.0.34-0ubuntu0.20.04.1 +-- Server version 8.0.35 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -36,10 +36,8 @@ CREATE TABLE `achievement` ( `Flags` int NOT NULL DEFAULT '0', `UiOrder` smallint NOT NULL DEFAULT '0', `IconFileID` int NOT NULL DEFAULT '0', - `RewardItemID` int NOT NULL DEFAULT '0', `CriteriaTree` int unsigned NOT NULL DEFAULT '0', `SharesCriteria` smallint NOT NULL DEFAULT '0', - `CovenantID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -138,14 +136,14 @@ CREATE TABLE `adventure_journal` ( `ButtonActionType` tinyint unsigned NOT NULL DEFAULT '0', `TextureFileDataID` int NOT NULL DEFAULT '0', `LfgDungeonID` smallint unsigned NOT NULL DEFAULT '0', - `QuestID` int NOT NULL DEFAULT '0', + `QuestID` int unsigned NOT NULL DEFAULT '0', `BattleMasterListID` smallint unsigned NOT NULL DEFAULT '0', `PriorityMin` tinyint unsigned NOT NULL DEFAULT '0', `PriorityMax` tinyint unsigned NOT NULL DEFAULT '0', `ItemID` int NOT NULL DEFAULT '0', `ItemQuantity` int unsigned NOT NULL DEFAULT '0', `CurrencyType` smallint unsigned NOT NULL DEFAULT '0', - `CurrencyQuantity` int unsigned NOT NULL DEFAULT '0', + `CurrencyQuantity` tinyint unsigned NOT NULL DEFAULT '0', `UiMapID` smallint unsigned NOT NULL DEFAULT '0', `BonusPlayerConditionID1` int unsigned NOT NULL DEFAULT '0', `BonusPlayerConditionID2` int unsigned NOT NULL DEFAULT '0', @@ -314,6 +312,7 @@ CREATE TABLE `area_table` ( `UwAmbience` smallint unsigned NOT NULL DEFAULT '0', `ZoneMusic` smallint unsigned NOT NULL DEFAULT '0', `UwZoneMusic` smallint unsigned NOT NULL DEFAULT '0', + `ExplorationLevel` tinyint NOT NULL DEFAULT '0', `IntroSound` smallint unsigned NOT NULL DEFAULT '0', `UwIntroSound` int unsigned NOT NULL DEFAULT '0', `FactionGroupMask` tinyint unsigned NOT NULL DEFAULT '0', @@ -323,7 +322,6 @@ CREATE TABLE `area_table` ( `WildBattlePetLevelMin` tinyint unsigned NOT NULL DEFAULT '0', `WildBattlePetLevelMax` tinyint unsigned NOT NULL DEFAULT '0', `WindSettingsID` tinyint unsigned NOT NULL DEFAULT '0', - `ContentTuningID` int NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `LiquidTypeID1` smallint unsigned NOT NULL DEFAULT '0', @@ -370,6 +368,7 @@ DROP TABLE IF EXISTS `area_trigger`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `area_trigger` ( + `Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PosX` float NOT NULL DEFAULT '0', `PosY` float NOT NULL DEFAULT '0', `PosZ` float NOT NULL DEFAULT '0', @@ -385,7 +384,7 @@ CREATE TABLE `area_trigger` ( `BoxYaw` float NOT NULL DEFAULT '0', `ShapeType` tinyint NOT NULL DEFAULT '0', `ShapeID` smallint NOT NULL DEFAULT '0', - `AreaTriggerActionSetID` int NOT NULL DEFAULT '0', + `AreaTriggerActionSetID` smallint NOT NULL DEFAULT '0', `Flags` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -393,6 +392,33 @@ CREATE TABLE `area_trigger` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `area_trigger_locale` +-- + +DROP TABLE IF EXISTS `area_trigger_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `area_trigger_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Message_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `armor_location` -- @@ -458,7 +484,6 @@ CREATE TABLE `artifact_appearance` ( `UiAltItemAppearanceID` int unsigned NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', `UiCameraID` smallint unsigned NOT NULL DEFAULT '0', - `UsablePlayerConditionID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -966,10 +991,10 @@ DROP TABLE IF EXISTS `azerite_power_set_member`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `azerite_power_set_member` ( `ID` int unsigned NOT NULL DEFAULT '0', - `AzeritePowerSetID` int NOT NULL DEFAULT '0', + `AzeritePowerSetID` int unsigned NOT NULL DEFAULT '0', `AzeritePowerID` int NOT NULL DEFAULT '0', `Class` int NOT NULL DEFAULT '0', - `Tier` tinyint NOT NULL DEFAULT '0', + `Tier` tinyint unsigned NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -1068,9 +1093,9 @@ DROP TABLE IF EXISTS `barber_shop_style`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `barber_shop_style` ( - `ID` int unsigned NOT NULL DEFAULT '0', `DisplayName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '0', `CostModifier` float NOT NULL DEFAULT '0', `Race` tinyint unsigned NOT NULL DEFAULT '0', @@ -1167,9 +1192,8 @@ DROP TABLE IF EXISTS `battle_pet_breed_quality`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battle_pet_breed_quality` ( `ID` int unsigned NOT NULL DEFAULT '0', - `MaxQualityRoll` int NOT NULL DEFAULT '0', `StateMultiplier` float NOT NULL DEFAULT '0', - `QualityEnum` tinyint NOT NULL DEFAULT '0', + `QualityEnum` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1184,7 +1208,7 @@ DROP TABLE IF EXISTS `battle_pet_breed_state`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battle_pet_breed_state` ( `ID` int unsigned NOT NULL DEFAULT '0', - `BattlePetStateID` int NOT NULL DEFAULT '0', + `BattlePetStateID` tinyint unsigned NOT NULL DEFAULT '0', `Value` smallint unsigned NOT NULL DEFAULT '0', `BattlePetBreedID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -1206,12 +1230,11 @@ CREATE TABLE `battle_pet_species` ( `CreatureID` int NOT NULL DEFAULT '0', `SummonSpellID` int NOT NULL DEFAULT '0', `IconFileDataID` int NOT NULL DEFAULT '0', - `PetTypeEnum` tinyint NOT NULL DEFAULT '0', + `PetTypeEnum` tinyint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `SourceTypeEnum` tinyint NOT NULL DEFAULT '0', `CardUIModelSceneID` int NOT NULL DEFAULT '0', `LoadoutUIModelSceneID` int NOT NULL DEFAULT '0', - `CovenantID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1254,7 +1277,7 @@ DROP TABLE IF EXISTS `battle_pet_species_state`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `battle_pet_species_state` ( `ID` int unsigned NOT NULL DEFAULT '0', - `BattlePetStateID` smallint unsigned NOT NULL DEFAULT '0', + `BattlePetStateID` tinyint unsigned NOT NULL DEFAULT '0', `Value` int NOT NULL DEFAULT '0', `BattlePetSpeciesID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -1284,7 +1307,7 @@ CREATE TABLE `battlemaster_list` ( `GroupsAllowed` tinyint NOT NULL DEFAULT '0', `MaxGroupSize` tinyint NOT NULL DEFAULT '0', `HolidayWorldState` smallint NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint NOT NULL DEFAULT '0', `IconFileDataID` int NOT NULL DEFAULT '0', `RequiredPlayerConditionID` int NOT NULL DEFAULT '0', `MapID1` smallint NOT NULL DEFAULT '0', @@ -1422,7 +1445,7 @@ DROP TABLE IF EXISTS `cfg_categories`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cfg_categories` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Name` text COLLATE utf8mb4_unicode_ci, + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `LocaleMask` smallint unsigned NOT NULL DEFAULT '0', `CreateCharsetMask` tinyint unsigned NOT NULL DEFAULT '0', `ExistingCharsetMask` tinyint unsigned NOT NULL DEFAULT '0', @@ -1442,8 +1465,8 @@ DROP TABLE IF EXISTS `cfg_categories_locale`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `cfg_categories_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL, - `Name_lang` text COLLATE utf8mb4_unicode_ci, + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -1554,8 +1577,8 @@ DROP TABLE IF EXISTS `character_loadout`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `character_loadout` ( - `ID` int unsigned NOT NULL DEFAULT '0', `RaceMask` bigint NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', `ChrClassID` tinyint NOT NULL DEFAULT '0', `Purpose` int NOT NULL DEFAULT '0', `ItemContext` tinyint NOT NULL DEFAULT '0', @@ -1588,9 +1611,9 @@ DROP TABLE IF EXISTS `chat_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chat_channels` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Shortcut` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `FactionGroup` tinyint NOT NULL DEFAULT '0', `Ruleset` int NOT NULL DEFAULT '0', @@ -1657,40 +1680,26 @@ CREATE TABLE `chr_classes` ( `NameMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `NameFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PetNameToken` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `RoleInfoString` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `DisabledString` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `HyphenatedNameMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `HyphenatedNameFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', `CreateScreenFileDataID` int unsigned NOT NULL DEFAULT '0', `SelectScreenFileDataID` int unsigned NOT NULL DEFAULT '0', `IconFileDataID` int unsigned NOT NULL DEFAULT '0', `LowResScreenFileDataID` int unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `SpellTextureBlobFileDataID` int unsigned NOT NULL DEFAULT '0', + `StartingLevel` int NOT NULL DEFAULT '0', `ArmorTypeMask` int unsigned NOT NULL DEFAULT '0', - `CharStartKitUnknown901` int NOT NULL DEFAULT '0', - `MaleCharacterCreationVisualFallback` int NOT NULL DEFAULT '0', - `MaleCharacterCreationIdleVisualFallback` int NOT NULL DEFAULT '0', - `FemaleCharacterCreationVisualFallback` int NOT NULL DEFAULT '0', - `FemaleCharacterCreationIdleVisualFallback` int NOT NULL DEFAULT '0', - `CharacterCreationIdleGroundVisualFallback` int NOT NULL DEFAULT '0', - `CharacterCreationGroundVisualFallback` int NOT NULL DEFAULT '0', - `AlteredFormCharacterCreationIdleVisualFallback` int NOT NULL DEFAULT '0', - `CharacterCreationAnimLoopWaitTimeMsFallback` int NOT NULL DEFAULT '0', `CinematicSequenceID` smallint unsigned NOT NULL DEFAULT '0', `DefaultSpec` smallint unsigned NOT NULL DEFAULT '0', + `HasStrengthAttackBonus` tinyint unsigned NOT NULL DEFAULT '0', `PrimaryStatPriority` tinyint unsigned NOT NULL DEFAULT '0', `DisplayPower` tinyint unsigned NOT NULL DEFAULT '0', `RangedAttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0', `AttackPowerPerAgility` tinyint unsigned NOT NULL DEFAULT '0', `AttackPowerPerStrength` tinyint unsigned NOT NULL DEFAULT '0', `SpellClassSet` tinyint unsigned NOT NULL DEFAULT '0', - `ClassColorR` tinyint unsigned NOT NULL DEFAULT '0', - `ClassColorG` tinyint unsigned NOT NULL DEFAULT '0', - `ClassColorB` tinyint unsigned NOT NULL DEFAULT '0', `RolesMask` tinyint unsigned NOT NULL DEFAULT '0', + `DamageBonusStat` tinyint unsigned NOT NULL DEFAULT '0', + `HasRelicSlot` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1709,11 +1718,6 @@ CREATE TABLE `chr_classes_locale` ( `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `NameMale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `NameFemale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `RoleInfoString_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `DisabledString_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `HyphenatedNameMale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `HyphenatedNameFemale_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -1862,7 +1866,6 @@ CREATE TABLE `chr_customization_option` ( `ChrCustomizationID` int NOT NULL DEFAULT '0', `ChrCustomizationReqID` int NOT NULL DEFAULT '0', `UiOrderIndex` int NOT NULL DEFAULT '0', - `AddedInPatch` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -1903,9 +1906,9 @@ DROP TABLE IF EXISTS `chr_customization_req`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `chr_customization_req` ( - `ID` int unsigned NOT NULL DEFAULT '0', `RaceMask` bigint NOT NULL DEFAULT '0', `ReqSource` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', `AchievementID` int NOT NULL DEFAULT '0', @@ -2037,35 +2040,29 @@ CREATE TABLE `chr_races` ( `ShortNameLower` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ShortNameLowerFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Flags` int NOT NULL DEFAULT '0', - `FactionID` int NOT NULL DEFAULT '0', - `CinematicSequenceID` int NOT NULL DEFAULT '0', + `MaleDisplayID` int unsigned NOT NULL DEFAULT '0', + `FemaleDisplayID` int unsigned NOT NULL DEFAULT '0', + `HighResMaleDisplayID` int unsigned NOT NULL DEFAULT '0', + `HighResFemaleDisplayID` int unsigned NOT NULL DEFAULT '0', `ResSicknessSpellID` int NOT NULL DEFAULT '0', `SplashSoundID` int NOT NULL DEFAULT '0', - `Alliance` int NOT NULL DEFAULT '0', - `RaceRelated` int NOT NULL DEFAULT '0', - `UnalteredVisualRaceID` int NOT NULL DEFAULT '0', - `DefaultClassID` int NOT NULL DEFAULT '0', `CreateScreenFileDataID` int NOT NULL DEFAULT '0', `SelectScreenFileDataID` int NOT NULL DEFAULT '0', - `NeutralRaceID` int NOT NULL DEFAULT '0', `LowResScreenFileDataID` int NOT NULL DEFAULT '0', - `AlteredFormStartVisualKitID1` int NOT NULL DEFAULT '0', - `AlteredFormStartVisualKitID2` int NOT NULL DEFAULT '0', - `AlteredFormStartVisualKitID3` int NOT NULL DEFAULT '0', - `AlteredFormFinishVisualKitID1` int NOT NULL DEFAULT '0', - `AlteredFormFinishVisualKitID2` int NOT NULL DEFAULT '0', - `AlteredFormFinishVisualKitID3` int NOT NULL DEFAULT '0', + `AlteredFormStartVisualKitID1` int unsigned NOT NULL DEFAULT '0', + `AlteredFormStartVisualKitID2` int unsigned NOT NULL DEFAULT '0', + `AlteredFormStartVisualKitID3` int unsigned NOT NULL DEFAULT '0', + `AlteredFormFinishVisualKitID1` int unsigned NOT NULL DEFAULT '0', + `AlteredFormFinishVisualKitID2` int unsigned NOT NULL DEFAULT '0', + `AlteredFormFinishVisualKitID3` int unsigned NOT NULL DEFAULT '0', `HeritageArmorAchievementID` int NOT NULL DEFAULT '0', `StartingLevel` int NOT NULL DEFAULT '0', `UiDisplayOrder` int NOT NULL DEFAULT '0', - `MaleModelFallbackRaceID` int NOT NULL DEFAULT '0', - `FemaleModelFallbackRaceID` int NOT NULL DEFAULT '0', - `MaleTextureFallbackRaceID` int NOT NULL DEFAULT '0', - `FemaleTextureFallbackRaceID` int NOT NULL DEFAULT '0', `PlayableRaceBit` int NOT NULL DEFAULT '0', + `FemaleSkeletonFileDataID` int NOT NULL DEFAULT '0', + `MaleSkeletonFileDataID` int NOT NULL DEFAULT '0', `HelmetAnimScalingRaceID` int NOT NULL DEFAULT '0', `TransmogrifyDisabledSlotMask` int NOT NULL DEFAULT '0', - `UnalteredVisualCustomizationRaceID` int NOT NULL DEFAULT '0', `AlteredFormCustomizeOffsetFallback1` float NOT NULL DEFAULT '0', `AlteredFormCustomizeOffsetFallback2` float NOT NULL DEFAULT '0', `AlteredFormCustomizeOffsetFallback3` float NOT NULL DEFAULT '0', @@ -2076,13 +2073,24 @@ CREATE TABLE `chr_races` ( `Unknown910_21` float NOT NULL DEFAULT '0', `Unknown910_22` float NOT NULL DEFAULT '0', `Unknown910_23` float NOT NULL DEFAULT '0', - `Unknown1000` int NOT NULL DEFAULT '0', + `FactionID` smallint NOT NULL DEFAULT '0', + `CinematicSequenceID` smallint NOT NULL DEFAULT '0', `BaseLanguage` tinyint NOT NULL DEFAULT '0', `CreatureType` tinyint NOT NULL DEFAULT '0', + `Alliance` tinyint NOT NULL DEFAULT '0', + `RaceRelated` tinyint NOT NULL DEFAULT '0', + `UnalteredVisualRaceID` tinyint NOT NULL DEFAULT '0', + `DefaultClassID` tinyint NOT NULL DEFAULT '0', + `NeutralRaceID` tinyint NOT NULL DEFAULT '0', + `MaleModelFallbackRaceID` tinyint NOT NULL DEFAULT '0', `MaleModelFallbackSex` tinyint NOT NULL DEFAULT '0', + `FemaleModelFallbackRaceID` tinyint NOT NULL DEFAULT '0', `FemaleModelFallbackSex` tinyint NOT NULL DEFAULT '0', + `MaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT '0', `MaleTextureFallbackSex` tinyint NOT NULL DEFAULT '0', + `FemaleTextureFallbackRaceID` tinyint NOT NULL DEFAULT '0', `FemaleTextureFallbackSex` tinyint NOT NULL DEFAULT '0', + `UnalteredVisualCustomizationRaceID` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2139,7 +2147,7 @@ CREATE TABLE `chr_specialization` ( `FemaleName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', - `ClassID` tinyint NOT NULL DEFAULT '0', + `ClassID` tinyint unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint NOT NULL DEFAULT '0', `PetTalentType` tinyint NOT NULL DEFAULT '0', `Role` tinyint NOT NULL DEFAULT '0', @@ -2198,7 +2206,6 @@ CREATE TABLE `cinematic_camera` ( `SoundID` int unsigned NOT NULL DEFAULT '0', `OriginFacing` float NOT NULL DEFAULT '0', `FileDataID` int unsigned NOT NULL DEFAULT '0', - `ConversationID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2273,18 +2280,11 @@ DROP TABLE IF EXISTS `content_tuning`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `content_tuning` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', - `ExpansionID` int NOT NULL DEFAULT '0', `MinLevel` int NOT NULL DEFAULT '0', `MaxLevel` int NOT NULL DEFAULT '0', - `MinLevelType` int NOT NULL DEFAULT '0', - `MaxLevelType` int NOT NULL DEFAULT '0', - `TargetLevelDelta` int NOT NULL DEFAULT '0', - `TargetLevelMaxDelta` int NOT NULL DEFAULT '0', - `TargetLevelMin` int NOT NULL DEFAULT '0', - `TargetLevelMax` int NOT NULL DEFAULT '0', - `MinItemLevel` int NOT NULL DEFAULT '0', - `QuestXpMultiplier` float NOT NULL DEFAULT '0', + `Flags` int NOT NULL DEFAULT '0', + `ExpectedStatModID` int NOT NULL DEFAULT '0', + `DifficultyESMID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2477,9 +2477,17 @@ CREATE TABLE `creature_display_info_extra` ( `DisplayRaceID` tinyint NOT NULL DEFAULT '0', `DisplaySexID` tinyint NOT NULL DEFAULT '0', `DisplayClassID` tinyint NOT NULL DEFAULT '0', + `SkinID` tinyint NOT NULL DEFAULT '0', + `FaceID` tinyint NOT NULL DEFAULT '0', + `HairStyleID` tinyint NOT NULL DEFAULT '0', + `HairColorID` tinyint NOT NULL DEFAULT '0', + `FacialHairID` tinyint NOT NULL DEFAULT '0', `Flags` tinyint NOT NULL DEFAULT '0', `BakeMaterialResourcesID` int NOT NULL DEFAULT '0', `HDBakeMaterialResourcesID` int NOT NULL DEFAULT '0', + `CustomDisplayOption1` tinyint unsigned NOT NULL DEFAULT '0', + `CustomDisplayOption2` tinyint unsigned NOT NULL DEFAULT '0', + `CustomDisplayOption3` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2501,6 +2509,7 @@ CREATE TABLE `creature_family` ( `MaxScaleLevel` tinyint NOT NULL DEFAULT '0', `PetFoodMask` smallint NOT NULL DEFAULT '0', `PetTalentType` tinyint NOT NULL DEFAULT '0', + `CategoryEnumID` int NOT NULL DEFAULT '0', `IconFileID` int NOT NULL DEFAULT '0', `SkillLine1` smallint NOT NULL DEFAULT '0', `SkillLine2` smallint NOT NULL DEFAULT '0', @@ -2553,8 +2562,6 @@ CREATE TABLE `creature_model_data` ( `GeoBox6` float NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `FileDataID` int unsigned NOT NULL DEFAULT '0', - `WalkSpeed` float NOT NULL DEFAULT '0', - `RunSpeed` float NOT NULL DEFAULT '0', `BloodID` int unsigned NOT NULL DEFAULT '0', `FootprintTextureID` int unsigned NOT NULL DEFAULT '0', `FootprintTextureLength` float NOT NULL DEFAULT '0', @@ -2580,10 +2587,6 @@ CREATE TABLE `creature_model_data` ( `OverrideNameScale` float NOT NULL DEFAULT '0', `OverrideSelectionRadius` float NOT NULL DEFAULT '0', `TamedPetBaseScale` float NOT NULL DEFAULT '0', - `Unknown820_1` tinyint NOT NULL DEFAULT '0', - `Unknown820_2` float NOT NULL DEFAULT '0', - `Unknown820_31` float NOT NULL DEFAULT '0', - `Unknown820_32` float NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2719,7 +2722,7 @@ CREATE TABLE `currency_container` ( `MinAmount` int NOT NULL DEFAULT '0', `MaxAmount` int NOT NULL DEFAULT '0', `ContainerIconID` int NOT NULL DEFAULT '0', - `ContainerQuality` tinyint NOT NULL DEFAULT '0', + `ContainerQuality` int NOT NULL DEFAULT '0', `OnLootSpellVisualKitID` int NOT NULL DEFAULT '0', `CurrencyTypesID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -2766,7 +2769,7 @@ CREATE TABLE `currency_types` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `CategoryID` int NOT NULL DEFAULT '0', + `CategoryID` tinyint unsigned NOT NULL DEFAULT '0', `InventoryIconFileID` int NOT NULL DEFAULT '0', `SpellWeight` int unsigned NOT NULL DEFAULT '0', `SpellCategory` tinyint unsigned NOT NULL DEFAULT '0', @@ -2774,12 +2777,7 @@ CREATE TABLE `currency_types` ( `MaxEarnablePerWeek` int unsigned NOT NULL DEFAULT '0', `Quality` tinyint NOT NULL DEFAULT '0', `FactionID` int NOT NULL DEFAULT '0', - `ItemGroupSoundsID` int NOT NULL DEFAULT '0', - `XpQuestDifficulty` int NOT NULL DEFAULT '0', `AwardConditionID` int NOT NULL DEFAULT '0', - `MaxQtyWorldStateID` int NOT NULL DEFAULT '0', - `RechargingAmountPerCycle` int unsigned NOT NULL DEFAULT '0', - `RechargingCycleDurationMS` int unsigned NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -2862,20 +2860,20 @@ CREATE TABLE `destructible_model_data` ( `ID` int unsigned NOT NULL DEFAULT '0', `State0ImpactEffectDoodadSet` tinyint NOT NULL DEFAULT '0', `State0AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0', - `State1Wmo` int NOT NULL DEFAULT '0', + `State1Wmo` int unsigned NOT NULL DEFAULT '0', `State1DestructionDoodadSet` tinyint NOT NULL DEFAULT '0', `State1ImpactEffectDoodadSet` tinyint NOT NULL DEFAULT '0', `State1AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0', - `State2Wmo` int NOT NULL DEFAULT '0', + `State2Wmo` int unsigned NOT NULL DEFAULT '0', `State2DestructionDoodadSet` tinyint NOT NULL DEFAULT '0', `State2ImpactEffectDoodadSet` tinyint NOT NULL DEFAULT '0', `State2AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0', - `State3Wmo` int NOT NULL DEFAULT '0', + `State3Wmo` int unsigned NOT NULL DEFAULT '0', `State3InitDoodadSet` tinyint unsigned NOT NULL DEFAULT '0', `State3AmbientDoodadSet` tinyint unsigned NOT NULL DEFAULT '0', `EjectDirection` tinyint unsigned NOT NULL DEFAULT '0', `DoNotHighlight` tinyint unsigned NOT NULL DEFAULT '0', - `State0Wmo` int NOT NULL DEFAULT '0', + `State0Wmo` int unsigned NOT NULL DEFAULT '0', `HealEffect` tinyint unsigned NOT NULL DEFAULT '0', `HealEffectSpeed` smallint unsigned NOT NULL DEFAULT '0', `State0NameSet` tinyint NOT NULL DEFAULT '0', @@ -2903,12 +2901,12 @@ CREATE TABLE `difficulty` ( `FallbackDifficultyID` tinyint unsigned NOT NULL DEFAULT '0', `MinPlayers` tinyint unsigned NOT NULL DEFAULT '0', `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0', - `Flags` smallint unsigned NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', `ToggleDifficultyID` tinyint unsigned NOT NULL DEFAULT '0', - `GroupSizeHealthCurveID` int unsigned NOT NULL DEFAULT '0', - `GroupSizeDmgCurveID` int unsigned NOT NULL DEFAULT '0', - `GroupSizeSpellPointsCurveID` int unsigned NOT NULL DEFAULT '0', + `GroupSizeHealthCurveID` smallint unsigned NOT NULL DEFAULT '0', + `GroupSizeDmgCurveID` smallint unsigned NOT NULL DEFAULT '0', + `GroupSizeSpellPointsCurveID` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -2954,10 +2952,8 @@ CREATE TABLE `dungeon_encounter` ( `MapID` smallint NOT NULL DEFAULT '0', `DifficultyID` int NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', - `CompleteWorldStateID` int NOT NULL DEFAULT '0', `Bit` tinyint NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `SpellIconFileID` int NOT NULL DEFAULT '0', `Faction` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -3163,17 +3159,17 @@ DROP TABLE IF EXISTS `faction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `faction` ( - `ID` int unsigned NOT NULL DEFAULT '0', `ReputationRaceMask1` bigint NOT NULL DEFAULT '0', `ReputationRaceMask2` bigint NOT NULL DEFAULT '0', `ReputationRaceMask3` bigint NOT NULL DEFAULT '0', `ReputationRaceMask4` bigint NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `ReputationIndex` smallint NOT NULL DEFAULT '0', `ParentFactionID` smallint unsigned NOT NULL DEFAULT '0', `Expansion` tinyint unsigned NOT NULL DEFAULT '0', - `FriendshipRepID` int unsigned NOT NULL DEFAULT '0', + `FriendshipRepID` tinyint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `ParagonFactionID` smallint unsigned NOT NULL DEFAULT '0', `RenownFactionID` int NOT NULL DEFAULT '0', @@ -3276,9 +3272,8 @@ DROP TABLE IF EXISTS `friendship_rep_reaction`; CREATE TABLE `friendship_rep_reaction` ( `ID` int unsigned NOT NULL DEFAULT '0', `Reaction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `FriendshipRepID` int unsigned NOT NULL DEFAULT '0', + `FriendshipRepID` tinyint unsigned NOT NULL DEFAULT '0', `ReactionThreshold` smallint unsigned NOT NULL DEFAULT '0', - `OverrideColor` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3320,12 +3315,9 @@ DROP TABLE IF EXISTS `friendship_reputation`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `friendship_reputation` ( `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `StandingModified` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `StandingChanged` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', - `FactionID` int NOT NULL DEFAULT '0', - `TextureFileID` int NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Field34146722002` int NOT NULL DEFAULT '0', + `Field34146722003` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3342,8 +3334,6 @@ CREATE TABLE `friendship_reputation_locale` ( `ID` int unsigned NOT NULL DEFAULT '0', `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `Description_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `StandingModified_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `StandingChanged_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci @@ -3387,6 +3377,7 @@ DROP TABLE IF EXISTS `gameobject_display_info`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `gameobject_display_info` ( `ID` int unsigned NOT NULL DEFAULT '0', + `ModelName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `GeoBoxMinX` float NOT NULL DEFAULT '0', `GeoBoxMinY` float NOT NULL DEFAULT '0', `GeoBoxMinZ` float NOT NULL DEFAULT '0', @@ -3397,9 +3388,6 @@ CREATE TABLE `gameobject_display_info` ( `ObjectEffectPackageID` smallint NOT NULL DEFAULT '0', `OverrideLootEffectScale` float NOT NULL DEFAULT '0', `OverrideNameScale` float NOT NULL DEFAULT '0', - `AlternateDisplayType` int NOT NULL DEFAULT '0', - `ClientCreatureDisplayInfoID` int NOT NULL DEFAULT '0', - `ClientItemID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3422,13 +3410,13 @@ CREATE TABLE `gameobjects` ( `Rot3` float NOT NULL DEFAULT '0', `Rot4` float NOT NULL DEFAULT '0', `ID` int unsigned NOT NULL DEFAULT '0', - `OwnerID` int NOT NULL DEFAULT '0', - `DisplayID` int NOT NULL DEFAULT '0', + `OwnerID` smallint unsigned NOT NULL DEFAULT '0', + `DisplayID` int unsigned NOT NULL DEFAULT '0', `Scale` float NOT NULL DEFAULT '0', - `TypeID` int NOT NULL DEFAULT '0', - `PhaseUseFlags` int NOT NULL DEFAULT '0', - `PhaseID` int NOT NULL DEFAULT '0', - `PhaseGroupID` int NOT NULL DEFAULT '0', + `TypeID` tinyint unsigned NOT NULL DEFAULT '0', + `PhaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0', + `PhaseID` smallint unsigned NOT NULL DEFAULT '0', + `PhaseGroupID` smallint unsigned NOT NULL DEFAULT '0', `PropValue1` int NOT NULL DEFAULT '0', `PropValue2` int NOT NULL DEFAULT '0', `PropValue3` int NOT NULL DEFAULT '0', @@ -3477,14 +3465,14 @@ DROP TABLE IF EXISTS `garr_ability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `garr_ability` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `GarrAbilityCategoryID` tinyint unsigned NOT NULL DEFAULT '0', - `GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0', + `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0', `IconFileDataID` int NOT NULL DEFAULT '0', `FactionChangeGarrAbilityID` smallint unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3531,11 +3519,11 @@ CREATE TABLE `garr_building` ( `AllianceName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Tooltip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `GarrTypeID` tinyint NOT NULL DEFAULT '0', - `BuildingType` tinyint NOT NULL DEFAULT '0', + `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0', + `BuildingType` tinyint unsigned NOT NULL DEFAULT '0', `HordeGameObjectID` int NOT NULL DEFAULT '0', `AllianceGameObjectID` int NOT NULL DEFAULT '0', - `GarrSiteID` int NOT NULL DEFAULT '0', + `GarrSiteID` tinyint unsigned NOT NULL DEFAULT '0', `UpgradeLevel` tinyint unsigned NOT NULL DEFAULT '0', `BuildSeconds` int NOT NULL DEFAULT '0', `CurrencyTypeID` smallint unsigned NOT NULL DEFAULT '0', @@ -3550,7 +3538,7 @@ CREATE TABLE `garr_building` ( `GarrAbilityID` smallint unsigned NOT NULL DEFAULT '0', `BonusGarrAbilityID` smallint unsigned NOT NULL DEFAULT '0', `GoldCost` smallint unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3613,14 +3601,14 @@ DROP TABLE IF EXISTS `garr_class_spec`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `garr_class_spec` ( - `ID` int unsigned NOT NULL DEFAULT '0', `ClassSpec` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ClassSpecMale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ClassSpecFemale` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `UiTextureAtlasMemberID` smallint unsigned NOT NULL DEFAULT '0', `GarrFollItemSetID` smallint unsigned NOT NULL DEFAULT '0', `FollowerClassLimit` tinyint unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3663,19 +3651,19 @@ DROP TABLE IF EXISTS `garr_follower`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `garr_follower` ( - `ID` int unsigned NOT NULL DEFAULT '0', `HordeSourceText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `AllianceSourceText` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `TitleName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `GarrTypeID` tinyint NOT NULL DEFAULT '0', - `GarrFollowerTypeID` tinyint NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0', + `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0', `HordeCreatureID` int NOT NULL DEFAULT '0', `AllianceCreatureID` int NOT NULL DEFAULT '0', `HordeGarrFollRaceID` tinyint unsigned NOT NULL DEFAULT '0', `AllianceGarrFollRaceID` tinyint unsigned NOT NULL DEFAULT '0', - `HordeGarrClassSpecID` int NOT NULL DEFAULT '0', - `AllianceGarrClassSpecID` int NOT NULL DEFAULT '0', - `Quality` tinyint NOT NULL DEFAULT '0', + `HordeGarrClassSpecID` tinyint unsigned NOT NULL DEFAULT '0', + `AllianceGarrClassSpecID` tinyint unsigned NOT NULL DEFAULT '0', + `Quality` tinyint unsigned NOT NULL DEFAULT '0', `FollowerLevel` tinyint unsigned NOT NULL DEFAULT '0', `ItemLevelWeapon` smallint unsigned NOT NULL DEFAULT '0', `ItemLevelArmor` smallint unsigned NOT NULL DEFAULT '0', @@ -3693,10 +3681,8 @@ CREATE TABLE `garr_follower` ( `HordeSlottingBroadcastTextID` int unsigned NOT NULL DEFAULT '0', `AllySlottingBroadcastTextID` int unsigned NOT NULL DEFAULT '0', `ChrClassID` tinyint unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `Gender` tinyint unsigned NOT NULL DEFAULT '0', - `AutoCombatantID` int NOT NULL DEFAULT '0', - `CovenantID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3757,7 +3743,6 @@ DROP TABLE IF EXISTS `garr_mission`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `garr_mission` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Location` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, @@ -3765,7 +3750,8 @@ CREATE TABLE `garr_mission` ( `MapPosY` float NOT NULL DEFAULT '0', `WorldPosX` float NOT NULL DEFAULT '0', `WorldPosY` float NOT NULL DEFAULT '0', - `GarrTypeID` tinyint NOT NULL DEFAULT '0', + `ID` int unsigned NOT NULL DEFAULT '0', + `GarrTypeID` tinyint unsigned NOT NULL DEFAULT '0', `GarrMissionTypeID` tinyint unsigned NOT NULL DEFAULT '0', `GarrFollowerTypeID` tinyint unsigned NOT NULL DEFAULT '0', `MaxFollowers` tinyint unsigned NOT NULL DEFAULT '0', @@ -3774,9 +3760,8 @@ CREATE TABLE `garr_mission` ( `OfferedGarrMissionTextureID` tinyint unsigned NOT NULL DEFAULT '0', `UiTextureKitID` smallint unsigned NOT NULL DEFAULT '0', `EnvGarrMechanicID` int unsigned NOT NULL DEFAULT '0', - `EnvGarrMechanicTypeID` int NOT NULL DEFAULT '0', + `EnvGarrMechanicTypeID` tinyint unsigned NOT NULL DEFAULT '0', `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', - `GarrMissionSetID` int NOT NULL DEFAULT '0', `TargetLevel` tinyint NOT NULL DEFAULT '0', `TargetItemLevel` smallint unsigned NOT NULL DEFAULT '0', `MissionDuration` int NOT NULL DEFAULT '0', @@ -3787,10 +3772,8 @@ CREATE TABLE `garr_mission` ( `OvermaxRewardPackID` int unsigned NOT NULL DEFAULT '0', `FollowerDeathChance` tinyint unsigned NOT NULL DEFAULT '0', `AreaID` int unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', - `AutoMissionScalar` float NOT NULL DEFAULT '0', - `AutoMissionScalarCurveID` int NOT NULL DEFAULT '0', - `AutoCombatantEnvCasterID` int NOT NULL DEFAULT '0', + `Flags` int unsigned NOT NULL DEFAULT '0', + `GarrMissionSetID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3932,17 +3915,12 @@ DROP TABLE IF EXISTS `garr_talent_tree`; CREATE TABLE `garr_talent_tree` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `GarrTypeID` tinyint NOT NULL DEFAULT '0', + `GarrTypeID` int NOT NULL DEFAULT '0', `ClassID` int NOT NULL DEFAULT '0', `MaxTiers` tinyint NOT NULL DEFAULT '0', `UiOrder` tinyint NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint NOT NULL DEFAULT '0', `UiTextureKitID` smallint unsigned NOT NULL DEFAULT '0', - `GarrTalentTreeType` int NOT NULL DEFAULT '0', - `PlayerConditionID` int NOT NULL DEFAULT '0', - `FeatureTypeIndex` tinyint unsigned NOT NULL DEFAULT '0', - `FeatureSubtypeIndex` tinyint NOT NULL DEFAULT '0', - `CurrencyID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -3986,6 +3964,7 @@ CREATE TABLE `gem_properties` ( `ID` int unsigned NOT NULL DEFAULT '0', `EnchantId` smallint unsigned NOT NULL DEFAULT '0', `Type` int NOT NULL DEFAULT '0', + `MinItemLevel` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4036,6 +4015,7 @@ CREATE TABLE `glyph_properties` ( `GlyphType` tinyint unsigned NOT NULL DEFAULT '0', `GlyphExclusiveCategoryID` tinyint unsigned NOT NULL DEFAULT '0', `SpellIconFileDataID` int NOT NULL DEFAULT '0', + `GlyphSlotFlags` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4058,6 +4038,22 @@ CREATE TABLE `glyph_required_spec` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `glyph_slot` +-- + +DROP TABLE IF EXISTS `glyph_slot`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `glyph_slot` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Tooltip` int NOT NULL DEFAULT '0', + `Type` int unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `gossip_npc_option` -- @@ -4068,19 +4064,16 @@ CREATE TABLE `gossip_npc_option` ( `ID` int unsigned NOT NULL DEFAULT '0', `GossipNpcOption` int NOT NULL DEFAULT '0', `LFGDungeonsID` int NOT NULL DEFAULT '0', - `TrainerID` int NOT NULL DEFAULT '0', - `GarrFollowerTypeID` int NOT NULL DEFAULT '0', - `CharShipmentID` int NOT NULL DEFAULT '0', - `GarrTalentTreeID` int NOT NULL DEFAULT '0', - `UiMapID` int NOT NULL DEFAULT '0', - `UiItemInteractionID` int NOT NULL DEFAULT '0', - `Unknown_1000_8` int NOT NULL DEFAULT '0', - `Unknown_1000_9` int NOT NULL DEFAULT '0', - `CovenantID` int NOT NULL DEFAULT '0', + `Unk341_1` int NOT NULL DEFAULT '0', + `Unk341_2` int NOT NULL DEFAULT '0', + `Unk341_3` int NOT NULL DEFAULT '0', + `Unk341_4` int NOT NULL DEFAULT '0', + `Unk341_5` int NOT NULL DEFAULT '0', + `Unk341_6` int NOT NULL DEFAULT '0', + `Unk341_7` int NOT NULL DEFAULT '0', + `Unk341_8` int NOT NULL DEFAULT '0', + `Unk341_9` int NOT NULL DEFAULT '0', `GossipOptionID` int NOT NULL DEFAULT '0', - `TraitTreeID` int NOT NULL DEFAULT '0', - `ProfessionID` int NOT NULL DEFAULT '0', - `Unknown_1002_14` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4228,6 +4221,7 @@ CREATE TABLE `holidays` ( `Priority` tinyint unsigned NOT NULL DEFAULT '0', `CalendarFilterType` tinyint NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', + `WorldStateExpressionID` int unsigned NOT NULL DEFAULT '0', `Duration1` smallint unsigned NOT NULL DEFAULT '0', `Duration2` smallint unsigned NOT NULL DEFAULT '0', `Duration3` smallint unsigned NOT NULL DEFAULT '0', @@ -4254,16 +4248,6 @@ CREATE TABLE `holidays` ( `Date14` int unsigned NOT NULL DEFAULT '0', `Date15` int unsigned NOT NULL DEFAULT '0', `Date16` int unsigned NOT NULL DEFAULT '0', - `Date17` int unsigned NOT NULL DEFAULT '0', - `Date18` int unsigned NOT NULL DEFAULT '0', - `Date19` int unsigned NOT NULL DEFAULT '0', - `Date20` int unsigned NOT NULL DEFAULT '0', - `Date21` int unsigned NOT NULL DEFAULT '0', - `Date22` int unsigned NOT NULL DEFAULT '0', - `Date23` int unsigned NOT NULL DEFAULT '0', - `Date24` int unsigned NOT NULL DEFAULT '0', - `Date25` int unsigned NOT NULL DEFAULT '0', - `Date26` int unsigned NOT NULL DEFAULT '0', `CalendarFlags1` tinyint unsigned NOT NULL DEFAULT '0', `CalendarFlags2` tinyint unsigned NOT NULL DEFAULT '0', `CalendarFlags3` tinyint unsigned NOT NULL DEFAULT '0', @@ -4410,13 +4394,40 @@ CREATE TABLE `item` ( `SubclassID` tinyint unsigned NOT NULL DEFAULT '0', `Material` tinyint unsigned NOT NULL DEFAULT '0', `InventoryType` tinyint NOT NULL DEFAULT '0', + `RequiredLevel` int NOT NULL DEFAULT '0', `SheatheType` tinyint unsigned NOT NULL DEFAULT '0', + `RandomSelect` smallint unsigned NOT NULL DEFAULT '0', + `ItemRandomSuffixGroupID` smallint unsigned NOT NULL DEFAULT '0', `SoundOverrideSubclassID` tinyint NOT NULL DEFAULT '0', + `ScalingStatDistributionID` smallint unsigned NOT NULL DEFAULT '0', `IconFileDataID` int NOT NULL DEFAULT '0', `ItemGroupSoundsID` tinyint unsigned NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', - `ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0', - `CraftingQualityID` int NOT NULL DEFAULT '0', + `MaxDurability` int unsigned NOT NULL DEFAULT '0', + `AmmunitionType` tinyint unsigned NOT NULL DEFAULT '0', + `ScalingStatValue` int NOT NULL DEFAULT '0', + `DamageType1` tinyint unsigned NOT NULL DEFAULT '0', + `DamageType2` tinyint unsigned NOT NULL DEFAULT '0', + `DamageType3` tinyint unsigned NOT NULL DEFAULT '0', + `DamageType4` tinyint unsigned NOT NULL DEFAULT '0', + `DamageType5` tinyint unsigned NOT NULL DEFAULT '0', + `Resistances1` smallint NOT NULL DEFAULT '0', + `Resistances2` smallint NOT NULL DEFAULT '0', + `Resistances3` smallint NOT NULL DEFAULT '0', + `Resistances4` smallint NOT NULL DEFAULT '0', + `Resistances5` smallint NOT NULL DEFAULT '0', + `Resistances6` smallint NOT NULL DEFAULT '0', + `Resistances7` smallint NOT NULL DEFAULT '0', + `MinDamage1` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage2` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage3` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage4` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage5` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage1` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage2` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage3` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage4` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage5` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4431,11 +4442,10 @@ DROP TABLE IF EXISTS `item_appearance`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_appearance` ( `ID` int unsigned NOT NULL DEFAULT '0', - `DisplayType` int NOT NULL DEFAULT '0', + `DisplayType` tinyint unsigned NOT NULL DEFAULT '0', `ItemDisplayInfoID` int NOT NULL DEFAULT '0', `DefaultIconFileDataID` int NOT NULL DEFAULT '0', `UiOrder` int NOT NULL DEFAULT '0', - `PlayerConditionID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4632,10 +4642,6 @@ CREATE TABLE `item_bonus_tree_node` ( `ChildItemBonusTreeID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemBonusListID` smallint unsigned NOT NULL DEFAULT '0', `ChildItemLevelSelectorID` smallint unsigned NOT NULL DEFAULT '0', - `ChildItemBonusListGroupID` int NOT NULL DEFAULT '0', - `IblGroupPointsModSetID` int NOT NULL DEFAULT '0', - `MinMythicPlusLevel` int NOT NULL DEFAULT '0', - `MaxMythicPlusLevel` int NOT NULL DEFAULT '0', `ParentItemBonusTreeID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -4651,9 +4657,9 @@ DROP TABLE IF EXISTS `item_child_equipment`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_child_equipment` ( `ID` int unsigned NOT NULL DEFAULT '0', - `ParentItemID` int NOT NULL DEFAULT '0', `ChildItemID` int NOT NULL DEFAULT '0', `ChildItemEquipSlot` tinyint unsigned NOT NULL DEFAULT '0', + `ParentItemID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4716,7 +4722,6 @@ CREATE TABLE `item_context_picker_entry` ( `ItemCreationContext` tinyint unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', `PVal` int NOT NULL DEFAULT '0', - `LabelID` int NOT NULL DEFAULT '0', `Flags` int unsigned NOT NULL DEFAULT '0', `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', `ItemContextPickerID` int unsigned NOT NULL DEFAULT '0', @@ -4888,6 +4893,7 @@ CREATE TABLE `item_effect` ( `SpellCategoryID` smallint unsigned NOT NULL DEFAULT '0', `SpellID` int NOT NULL DEFAULT '0', `ChrSpecializationID` smallint unsigned NOT NULL DEFAULT '0', + `ParentItemID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -4944,7 +4950,6 @@ CREATE TABLE `item_level_selector` ( `ID` int unsigned NOT NULL DEFAULT '0', `MinItemLevel` smallint unsigned NOT NULL DEFAULT '0', `ItemLevelSelectorQualitySetID` smallint unsigned NOT NULL DEFAULT '0', - `AzeriteUnlockMappingSet` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5057,7 +5062,7 @@ CREATE TABLE `item_modified_appearance` ( `ItemAppearanceModifierID` int NOT NULL DEFAULT '0', `ItemAppearanceID` int NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', - `TransmogSourceTypeEnum` tinyint unsigned NOT NULL DEFAULT '0', + `TransmogSourceTypeEnum` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5143,6 +5148,105 @@ CREATE TABLE `item_price_base` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `item_random_properties` +-- + +DROP TABLE IF EXISTS `item_random_properties`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_properties` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Enchantment1` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment2` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment3` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment4` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment5` smallint unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_properties_locale` +-- + +DROP TABLE IF EXISTS `item_random_properties_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_properties_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_suffix` +-- + +DROP TABLE IF EXISTS `item_random_suffix`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_suffix` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `Enchantment1` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment2` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment3` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment4` smallint unsigned NOT NULL DEFAULT '0', + `Enchantment5` smallint unsigned NOT NULL DEFAULT '0', + `AllocationPct1` smallint unsigned NOT NULL DEFAULT '0', + `AllocationPct2` smallint unsigned NOT NULL DEFAULT '0', + `AllocationPct3` smallint unsigned NOT NULL DEFAULT '0', + `AllocationPct4` smallint unsigned NOT NULL DEFAULT '0', + `AllocationPct5` smallint unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `item_random_suffix_locale` +-- + +DROP TABLE IF EXISTS `item_random_suffix_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `item_random_suffix_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `item_search_name` -- @@ -5150,11 +5254,11 @@ DROP TABLE IF EXISTS `item_search_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `item_search_name` ( - `ID` int unsigned NOT NULL DEFAULT '0', `AllowableRace` bigint NOT NULL DEFAULT '0', `Display` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `OverallQualityID` tinyint unsigned NOT NULL DEFAULT '0', - `ExpansionID` int NOT NULL DEFAULT '0', + `ExpansionID` tinyint NOT NULL DEFAULT '0', `MinFactionID` smallint unsigned NOT NULL DEFAULT '0', `MinReputation` int NOT NULL DEFAULT '0', `AllowableClass` int NOT NULL DEFAULT '0', @@ -5294,14 +5398,11 @@ CREATE TABLE `item_sparse` ( `Display2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Display1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Display` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `ExpansionID` int NOT NULL DEFAULT '0', `DmgVariance` float NOT NULL DEFAULT '0', - `LimitCategory` int NOT NULL DEFAULT '0', `DurationInInventory` int unsigned NOT NULL DEFAULT '0', `QualityModifier` float NOT NULL DEFAULT '0', `BagFamily` int unsigned NOT NULL DEFAULT '0', `StartQuestID` int NOT NULL DEFAULT '0', - `LanguageID` int NOT NULL DEFAULT '0', `ItemRange` float NOT NULL DEFAULT '0', `StatPercentageOfSocket1` float NOT NULL DEFAULT '0', `StatPercentageOfSocket2` float NOT NULL DEFAULT '0', @@ -5340,9 +5441,11 @@ CREATE TABLE `item_sparse` ( `ModifiedCraftingReagentItemID` int NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', `PlayerLevelToItemLevelCurveID` int NOT NULL DEFAULT '0', + `MaxDurability` int unsigned NOT NULL DEFAULT '0', `ItemNameDescriptionID` smallint unsigned NOT NULL DEFAULT '0', `RequiredTransmogHoliday` smallint unsigned NOT NULL DEFAULT '0', `RequiredHoliday` smallint unsigned NOT NULL DEFAULT '0', + `LimitCategory` smallint unsigned NOT NULL DEFAULT '0', `GemProperties` smallint unsigned NOT NULL DEFAULT '0', `SocketMatchEnchantmentId` smallint unsigned NOT NULL DEFAULT '0', `TotemCategoryID` smallint unsigned NOT NULL DEFAULT '0', @@ -5358,6 +5461,37 @@ CREATE TABLE `item_sparse` ( `RequiredSkill` smallint unsigned NOT NULL DEFAULT '0', `ItemLevel` smallint unsigned NOT NULL DEFAULT '0', `AllowableClass` smallint NOT NULL DEFAULT '0', + `ItemRandomSuffixGroupID` smallint unsigned NOT NULL DEFAULT '0', + `RandomSelect` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage1` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage2` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage3` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage4` smallint unsigned NOT NULL DEFAULT '0', + `MinDamage5` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage1` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage2` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage3` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage4` smallint unsigned NOT NULL DEFAULT '0', + `MaxDamage5` smallint unsigned NOT NULL DEFAULT '0', + `Resistances1` smallint NOT NULL DEFAULT '0', + `Resistances2` smallint NOT NULL DEFAULT '0', + `Resistances3` smallint NOT NULL DEFAULT '0', + `Resistances4` smallint NOT NULL DEFAULT '0', + `Resistances5` smallint NOT NULL DEFAULT '0', + `Resistances6` smallint NOT NULL DEFAULT '0', + `Resistances7` smallint NOT NULL DEFAULT '0', + `ScalingStatDistributionID` smallint unsigned NOT NULL DEFAULT '0', + `StatModifierBonusAmount1` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount2` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount3` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount4` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount5` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount6` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount7` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount8` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount9` smallint NOT NULL DEFAULT '0', + `StatModifierBonusAmount10` smallint NOT NULL DEFAULT '0', + `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0', `ArtifactID` tinyint unsigned NOT NULL DEFAULT '0', `SpellWeight` tinyint unsigned NOT NULL DEFAULT '0', `SpellWeightCategory` tinyint unsigned NOT NULL DEFAULT '0', @@ -5367,6 +5501,7 @@ CREATE TABLE `item_sparse` ( `SheatheType` tinyint unsigned NOT NULL DEFAULT '0', `Material` tinyint unsigned NOT NULL DEFAULT '0', `PageMaterialID` tinyint unsigned NOT NULL DEFAULT '0', + `LanguageID` tinyint unsigned NOT NULL DEFAULT '0', `Bonding` tinyint unsigned NOT NULL DEFAULT '0', `DamageDamageType` tinyint unsigned NOT NULL DEFAULT '0', `StatModifierBonusStat1` tinyint NOT NULL DEFAULT '0', @@ -5382,9 +5517,10 @@ CREATE TABLE `item_sparse` ( `ContainerSlots` tinyint unsigned NOT NULL DEFAULT '0', `RequiredPVPMedal` tinyint unsigned NOT NULL DEFAULT '0', `RequiredPVPRank` tinyint unsigned NOT NULL DEFAULT '0', - `RequiredLevel` tinyint NOT NULL DEFAULT '0', `InventoryType` tinyint NOT NULL DEFAULT '0', `OverallQualityID` tinyint NOT NULL DEFAULT '0', + `AmmunitionType` tinyint unsigned NOT NULL DEFAULT '0', + `RequiredLevel` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5497,13 +5633,12 @@ DROP TABLE IF EXISTS `journal_encounter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `journal_encounter` ( + `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MapX` float NOT NULL DEFAULT '0', `MapY` float NOT NULL DEFAULT '0', - `ID` int unsigned NOT NULL DEFAULT '0', `JournalInstanceID` smallint unsigned NOT NULL DEFAULT '0', - `DungeonEncounterID` smallint unsigned NOT NULL DEFAULT '0', `OrderIndex` int unsigned NOT NULL DEFAULT '0', `FirstSectionID` smallint unsigned NOT NULL DEFAULT '0', `UiMapID` smallint unsigned NOT NULL DEFAULT '0', @@ -5608,9 +5743,9 @@ DROP TABLE IF EXISTS `journal_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `journal_instance` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `MapID` smallint unsigned NOT NULL DEFAULT '0', `BackgroundFileDataID` int NOT NULL DEFAULT '0', `ButtonFileDataID` int NOT NULL DEFAULT '0', @@ -5661,7 +5796,6 @@ DROP TABLE IF EXISTS `journal_tier`; CREATE TABLE `journal_tier` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `PlayerConditionID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5795,7 +5929,7 @@ DROP TABLE IF EXISTS `language_words`; CREATE TABLE `language_words` ( `ID` int unsigned NOT NULL DEFAULT '0', `Word` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `LanguageID` int unsigned NOT NULL DEFAULT '0', + `LanguageID` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -5858,8 +5992,10 @@ CREATE TABLE `lfg_dungeons` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `MinLevel` tinyint unsigned NOT NULL DEFAULT '0', + `MaxLevel` smallint unsigned NOT NULL DEFAULT '0', `TypeID` tinyint unsigned NOT NULL DEFAULT '0', - `Subtype` tinyint NOT NULL DEFAULT '0', + `Subtype` tinyint unsigned NOT NULL DEFAULT '0', `Faction` tinyint NOT NULL DEFAULT '0', `IconTextureFileID` int NOT NULL DEFAULT '0', `RewardsBgTextureFileID` int NOT NULL DEFAULT '0', @@ -5871,6 +6007,9 @@ CREATE TABLE `lfg_dungeons` ( `GroupID` tinyint unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', `RequiredPlayerConditionId` int unsigned NOT NULL DEFAULT '0', + `TargetLevel` tinyint unsigned NOT NULL DEFAULT '0', + `TargetLevelMin` tinyint unsigned NOT NULL DEFAULT '0', + `TargetLevelMax` smallint unsigned NOT NULL DEFAULT '0', `RandomID` smallint unsigned NOT NULL DEFAULT '0', `ScenarioID` smallint unsigned NOT NULL DEFAULT '0', `FinalEncounterID` smallint unsigned NOT NULL DEFAULT '0', @@ -5883,7 +6022,6 @@ CREATE TABLE `lfg_dungeons` ( `BonusReputationAmount` smallint unsigned NOT NULL DEFAULT '0', `MentorItemLevel` smallint unsigned NOT NULL DEFAULT '0', `MentorCharLevel` tinyint unsigned NOT NULL DEFAULT '0', - `ContentTuningID` int NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -6025,7 +6163,6 @@ DROP TABLE IF EXISTS `lock`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `lock` ( `ID` int unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', `Index1` int NOT NULL DEFAULT '0', `Index2` int NOT NULL DEFAULT '0', `Index3` int NOT NULL DEFAULT '0', @@ -6120,8 +6257,6 @@ CREATE TABLE `map` ( `MapDescription1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PvpShortDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `PvpLongDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `CorpseX` float NOT NULL DEFAULT '0', - `CorpseY` float NOT NULL DEFAULT '0', `MapType` tinyint unsigned NOT NULL DEFAULT '0', `InstanceType` tinyint NOT NULL DEFAULT '0', `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0', @@ -6132,12 +6267,11 @@ CREATE TABLE `map` ( `CosmeticParentMapID` smallint NOT NULL DEFAULT '0', `TimeOffset` tinyint unsigned NOT NULL DEFAULT '0', `MinimapIconScale` float NOT NULL DEFAULT '0', + `RaidOffset` int NOT NULL DEFAULT '0', `CorpseMapID` smallint NOT NULL DEFAULT '0', `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0', `WindSettingsID` smallint NOT NULL DEFAULT '0', `ZmpFileDataID` int NOT NULL DEFAULT '0', - `WdtFileDataID` int NOT NULL DEFAULT '0', - `NavigationMaxDistance` int NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `Flags3` int NOT NULL DEFAULT '0', @@ -6205,14 +6339,14 @@ DROP TABLE IF EXISTS `map_difficulty`; CREATE TABLE `map_difficulty` ( `ID` int unsigned NOT NULL DEFAULT '0', `Message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `DifficultyID` int NOT NULL DEFAULT '0', - `LockID` int NOT NULL DEFAULT '0', - `ResetInterval` tinyint NOT NULL DEFAULT '0', - `MaxPlayers` int NOT NULL DEFAULT '0', - `ItemContext` int NOT NULL DEFAULT '0', - `ItemContextPickerID` int NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `ItemContextPickerID` int unsigned NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', + `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', + `LockID` tinyint unsigned NOT NULL DEFAULT '0', + `ResetInterval` tinyint unsigned NOT NULL DEFAULT '0', + `MaxPlayers` tinyint unsigned NOT NULL DEFAULT '0', + `ItemContext` tinyint unsigned NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `MapID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -6353,7 +6487,7 @@ CREATE TABLE `modifier_tree` ( `Type` int NOT NULL DEFAULT '0', `Asset` int NOT NULL DEFAULT '0', `SecondaryAsset` int NOT NULL DEFAULT '0', - `TertiaryAsset` int NOT NULL DEFAULT '0', + `TertiaryAsset` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -6378,8 +6512,6 @@ CREATE TABLE `mount` ( `PlayerConditionID` int unsigned NOT NULL DEFAULT '0', `MountFlyRideHeight` float NOT NULL DEFAULT '0', `UiModelSceneID` int NOT NULL DEFAULT '0', - `MountSpecialRiderAnimKitID` int NOT NULL DEFAULT '0', - `MountSpecialSpellVisualKitID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -6401,8 +6533,6 @@ CREATE TABLE `mount_capability` ( `ReqSpellKnownID` int NOT NULL DEFAULT '0', `ModSpellAuraID` int NOT NULL DEFAULT '0', `ReqMapID` smallint NOT NULL DEFAULT '0', - `PlayerConditionID` int NOT NULL DEFAULT '0', - `FlightCapabilityID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -6484,7 +6614,6 @@ CREATE TABLE `movie` ( `KeyID` tinyint unsigned NOT NULL DEFAULT '0', `AudioFileDataID` int unsigned NOT NULL DEFAULT '0', `SubtitleFileDataID` int unsigned NOT NULL DEFAULT '0', - `SubtitleFileFormat` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -6670,12 +6799,14 @@ DROP TABLE IF EXISTS `player_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `player_condition` ( - `ID` int unsigned NOT NULL DEFAULT '0', `RaceMask` bigint NOT NULL DEFAULT '0', `FailureDescription` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', + `MinLevel` smallint unsigned NOT NULL DEFAULT '0', + `MaxLevel` smallint unsigned NOT NULL DEFAULT '0', `ClassMask` int NOT NULL DEFAULT '0', `SkillLogic` int unsigned NOT NULL DEFAULT '0', - `LanguageID` int NOT NULL DEFAULT '0', + `LanguageID` tinyint unsigned NOT NULL DEFAULT '0', `MinLanguage` tinyint unsigned NOT NULL DEFAULT '0', `MaxLanguage` int NOT NULL DEFAULT '0', `MaxFactionID` smallint unsigned NOT NULL DEFAULT '0', @@ -6691,7 +6822,7 @@ CREATE TABLE `player_condition` ( `ItemFlags` tinyint unsigned NOT NULL DEFAULT '0', `AuraSpellLogic` int unsigned NOT NULL DEFAULT '0', `WorldStateExpressionID` smallint unsigned NOT NULL DEFAULT '0', - `WeatherID` int NOT NULL DEFAULT '0', + `WeatherID` tinyint unsigned NOT NULL DEFAULT '0', `PartyStatus` tinyint unsigned NOT NULL DEFAULT '0', `LifetimeMaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0', `AchievementLogic` int unsigned NOT NULL DEFAULT '0', @@ -6700,7 +6831,7 @@ CREATE TABLE `player_condition` ( `AreaLogic` int unsigned NOT NULL DEFAULT '0', `LfgLogic` int unsigned NOT NULL DEFAULT '0', `CurrencyLogic` int unsigned NOT NULL DEFAULT '0', - `QuestKillID` int NOT NULL DEFAULT '0', + `QuestKillID` int unsigned NOT NULL DEFAULT '0', `QuestKillLogic` int unsigned NOT NULL DEFAULT '0', `MinExpansionLevel` tinyint NOT NULL DEFAULT '0', `MaxExpansionLevel` tinyint NOT NULL DEFAULT '0', @@ -6711,7 +6842,7 @@ CREATE TABLE `player_condition` ( `PhaseUseFlags` tinyint unsigned NOT NULL DEFAULT '0', `PhaseID` smallint unsigned NOT NULL DEFAULT '0', `PhaseGroupID` int unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `ChrSpecializationIndex` tinyint NOT NULL DEFAULT '0', `ChrSpecializationRole` tinyint NOT NULL DEFAULT '0', `ModifierTreeID` int unsigned NOT NULL DEFAULT '0', @@ -6725,9 +6856,6 @@ CREATE TABLE `player_condition` ( `MinExpansionTier` tinyint NOT NULL DEFAULT '0', `MinPVPRank` tinyint unsigned NOT NULL DEFAULT '0', `MaxPVPRank` tinyint unsigned NOT NULL DEFAULT '0', - `ContentTuningID` int NOT NULL DEFAULT '0', - `CovenantID` int NOT NULL DEFAULT '0', - `TraitNodeEntryLogic` int unsigned NOT NULL DEFAULT '0', `SkillID1` smallint unsigned NOT NULL DEFAULT '0', `SkillID2` smallint unsigned NOT NULL DEFAULT '0', `SkillID3` smallint unsigned NOT NULL DEFAULT '0', @@ -6746,18 +6874,18 @@ CREATE TABLE `player_condition` ( `MinReputation1` tinyint unsigned NOT NULL DEFAULT '0', `MinReputation2` tinyint unsigned NOT NULL DEFAULT '0', `MinReputation3` tinyint unsigned NOT NULL DEFAULT '0', - `PrevQuestID1` int NOT NULL DEFAULT '0', - `PrevQuestID2` int NOT NULL DEFAULT '0', - `PrevQuestID3` int NOT NULL DEFAULT '0', - `PrevQuestID4` int NOT NULL DEFAULT '0', - `CurrQuestID1` int NOT NULL DEFAULT '0', - `CurrQuestID2` int NOT NULL DEFAULT '0', - `CurrQuestID3` int NOT NULL DEFAULT '0', - `CurrQuestID4` int NOT NULL DEFAULT '0', - `CurrentCompletedQuestID1` int NOT NULL DEFAULT '0', - `CurrentCompletedQuestID2` int NOT NULL DEFAULT '0', - `CurrentCompletedQuestID3` int NOT NULL DEFAULT '0', - `CurrentCompletedQuestID4` int NOT NULL DEFAULT '0', + `PrevQuestID1` int unsigned NOT NULL DEFAULT '0', + `PrevQuestID2` int unsigned NOT NULL DEFAULT '0', + `PrevQuestID3` int unsigned NOT NULL DEFAULT '0', + `PrevQuestID4` int unsigned NOT NULL DEFAULT '0', + `CurrQuestID1` int unsigned NOT NULL DEFAULT '0', + `CurrQuestID2` int unsigned NOT NULL DEFAULT '0', + `CurrQuestID3` int unsigned NOT NULL DEFAULT '0', + `CurrQuestID4` int unsigned NOT NULL DEFAULT '0', + `CurrentCompletedQuestID1` int unsigned NOT NULL DEFAULT '0', + `CurrentCompletedQuestID2` int unsigned NOT NULL DEFAULT '0', + `CurrentCompletedQuestID3` int unsigned NOT NULL DEFAULT '0', + `CurrentCompletedQuestID4` int unsigned NOT NULL DEFAULT '0', `SpellID1` int NOT NULL DEFAULT '0', `SpellID2` int NOT NULL DEFAULT '0', `SpellID3` int NOT NULL DEFAULT '0', @@ -6818,18 +6946,6 @@ CREATE TABLE `player_condition` ( `QuestKillMonster6` int unsigned NOT NULL DEFAULT '0', `MovementFlags1` int NOT NULL DEFAULT '0', `MovementFlags2` int NOT NULL DEFAULT '0', - `TraitNodeEntryID1` int NOT NULL DEFAULT '0', - `TraitNodeEntryID2` int NOT NULL DEFAULT '0', - `TraitNodeEntryID3` int NOT NULL DEFAULT '0', - `TraitNodeEntryID4` int NOT NULL DEFAULT '0', - `TraitNodeEntryMinRank1` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMinRank2` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMinRank3` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMinRank4` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMaxRank1` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMaxRank2` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMaxRank3` smallint unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryMaxRank4` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -6889,9 +7005,9 @@ DROP TABLE IF EXISTS `power_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `power_type` ( + `ID` int unsigned NOT NULL DEFAULT '0', `NameGlobalStringTag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `CostGlobalStringTag` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `ID` int unsigned NOT NULL DEFAULT '0', `PowerTypeEnum` tinyint NOT NULL DEFAULT '0', `MinPower` int NOT NULL DEFAULT '0', `MaxBasePower` int NOT NULL DEFAULT '0', @@ -7014,14 +7130,13 @@ DROP TABLE IF EXISTS `pvp_talent`; CREATE TABLE `pvp_talent` ( `Description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', - `SpecID` int NOT NULL DEFAULT '0', + `SpecID` int unsigned NOT NULL DEFAULT '0', `SpellID` int NOT NULL DEFAULT '0', `OverridesSpellID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `ActionBarSpellID` int NOT NULL DEFAULT '0', `PvpTalentCategoryID` int NOT NULL DEFAULT '0', `LevelRequired` int NOT NULL DEFAULT '0', - `PlayerConditionID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7095,13 +7210,13 @@ DROP TABLE IF EXISTS `pvp_tier`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `pvp_tier` ( - `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MinRating` smallint NOT NULL DEFAULT '0', `MaxRating` smallint NOT NULL DEFAULT '0', `PrevTier` int NOT NULL DEFAULT '0', `NextTier` int NOT NULL DEFAULT '0', - `BracketID` tinyint NOT NULL DEFAULT '0', + `BracketID` tinyint unsigned NOT NULL DEFAULT '0', `Rank` tinyint NOT NULL DEFAULT '0', `RankIconFileDataID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -7217,7 +7332,6 @@ CREATE TABLE `quest_line_x_quest` ( `QuestLineID` int unsigned NOT NULL DEFAULT '0', `QuestID` int unsigned NOT NULL DEFAULT '0', `OrderIndex` int unsigned NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7318,7 +7432,6 @@ DROP TABLE IF EXISTS `quest_v2`; CREATE TABLE `quest_v2` ( `ID` int unsigned NOT NULL DEFAULT '0', `UniqueBitFlag` smallint unsigned NOT NULL DEFAULT '0', - `UiQuestDetailsTheme` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7357,25 +7470,7 @@ DROP TABLE IF EXISTS `rand_prop_points`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `rand_prop_points` ( `ID` int unsigned NOT NULL DEFAULT '0', - `DamageReplaceStatF` float NOT NULL DEFAULT '0', - `DamageSecondaryF` float NOT NULL DEFAULT '0', `DamageReplaceStat` int NOT NULL DEFAULT '0', - `DamageSecondary` int 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', - `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', `Epic1` int unsigned NOT NULL DEFAULT '0', `Epic2` int unsigned NOT NULL DEFAULT '0', `Epic3` int unsigned NOT NULL DEFAULT '0', @@ -7451,6 +7546,80 @@ CREATE TABLE `reward_pack_x_item` ( /*!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 */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `scaling_stat_distribution` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `PlayerLevelToItemLevelCurveID` smallint unsigned NOT NULL DEFAULT '0', + `MinLevel` int NOT NULL DEFAULT '0', + `MaxLevel` int NOT NULL DEFAULT '0', + `Bonus1` int NOT NULL DEFAULT '0', + `Bonus2` int NOT NULL DEFAULT '0', + `Bonus3` int NOT NULL DEFAULT '0', + `Bonus4` int NOT NULL DEFAULT '0', + `Bonus5` int NOT NULL DEFAULT '0', + `Bonus6` int NOT NULL DEFAULT '0', + `Bonus7` int NOT NULL DEFAULT '0', + `Bonus8` int NOT NULL DEFAULT '0', + `Bonus9` int NOT NULL DEFAULT '0', + `Bonus10` int NOT NULL DEFAULT '0', + `StatID1` int NOT NULL DEFAULT '0', + `StatID2` int NOT NULL DEFAULT '0', + `StatID3` int NOT NULL DEFAULT '0', + `StatID4` int NOT NULL DEFAULT '0', + `StatID5` int NOT NULL DEFAULT '0', + `StatID6` int NOT NULL DEFAULT '0', + `StatID7` int NOT NULL DEFAULT '0', + `StatID8` int NOT NULL DEFAULT '0', + `StatID9` int NOT NULL DEFAULT '0', + `StatID10` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `scaling_stat_values` +-- + +DROP TABLE IF EXISTS `scaling_stat_values`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `scaling_stat_values` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Charlevel` int NOT NULL DEFAULT '0', + `WeaponDPS1H` int NOT NULL DEFAULT '0', + `WeaponDPS2H` int NOT NULL DEFAULT '0', + `SpellcasterDPS1H` int NOT NULL DEFAULT '0', + `SpellcasterDPS2H` int NOT NULL DEFAULT '0', + `RangedDPS` int NOT NULL DEFAULT '0', + `WandDPS` int NOT NULL DEFAULT '0', + `SpellPower` int NOT NULL DEFAULT '0', + `ShoulderBudget` int NOT NULL DEFAULT '0', + `TrinketBudget` int NOT NULL DEFAULT '0', + `WeaponBudget1H` int NOT NULL DEFAULT '0', + `PrimaryBudget` int NOT NULL DEFAULT '0', + `RangedBudget` int NOT NULL DEFAULT '0', + `TertiaryBudget` int NOT NULL DEFAULT '0', + `ClothShoulderArmor` int NOT NULL DEFAULT '0', + `LeatherShoulderArmor` int NOT NULL DEFAULT '0', + `MailShoulderArmor` int NOT NULL DEFAULT '0', + `PlateShoulderArmor` int NOT NULL DEFAULT '0', + `ClothCloakArmor` int NOT NULL DEFAULT '0', + `ClothChestArmor` int NOT NULL DEFAULT '0', + `LeatherChestArmor` int NOT NULL DEFAULT '0', + `MailChestArmor` int NOT NULL DEFAULT '0', + `PlateChestArmor` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `scenario` -- @@ -7509,7 +7678,7 @@ CREATE TABLE `scenario_step` ( `Title` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ScenarioID` smallint unsigned NOT NULL DEFAULT '0', `Criteriatreeid` int unsigned NOT NULL DEFAULT '0', - `RewardQuestID` int NOT NULL DEFAULT '0', + `RewardQuestID` int unsigned NOT NULL DEFAULT '0', `RelatedStep` int NOT NULL DEFAULT '0', `Supersedes` smallint unsigned NOT NULL DEFAULT '0', `OrderIndex` tinyint unsigned NOT NULL DEFAULT '0', @@ -7592,7 +7761,6 @@ DROP TABLE IF EXISTS `scene_script_package`; CREATE TABLE `scene_script_package` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `Unknown915` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7615,6 +7783,48 @@ CREATE TABLE `scene_script_text` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `server_messages` +-- + +DROP TABLE IF EXISTS `server_messages`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `server_messages` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `server_messages_locale` +-- + +DROP TABLE IF EXISTS `server_messages_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `server_messages_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Text_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `skill_line` -- @@ -7635,8 +7845,6 @@ CREATE TABLE `skill_line` ( `ParentTierIndex` int NOT NULL DEFAULT '0', `Flags` smallint unsigned NOT NULL DEFAULT '0', `SpellBookSpellID` int NOT NULL DEFAULT '0', - `ExpansionNameSharedStringID` int NOT NULL DEFAULT '0', - `HordeExpansionNameSharedStringID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7651,8 +7859,6 @@ DROP TABLE IF EXISTS `skill_line_ability`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_line_ability` ( `RaceMask` bigint NOT NULL DEFAULT '0', - `AbilityVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `AbilityAllVerb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', `SkillLine` smallint NOT NULL DEFAULT '0', `Spell` int NOT NULL DEFAULT '0', @@ -7662,11 +7868,13 @@ CREATE TABLE `skill_line_ability` ( `AcquireMethod` tinyint NOT NULL DEFAULT '0', `TrivialSkillLineRankHigh` smallint NOT NULL DEFAULT '0', `TrivialSkillLineRankLow` smallint NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint NOT NULL DEFAULT '0', `NumSkillUps` tinyint NOT NULL DEFAULT '0', `UniqueBit` smallint NOT NULL DEFAULT '0', `TradeSkillCategoryID` smallint NOT NULL DEFAULT '0', `SkillupSkillLineID` smallint NOT NULL DEFAULT '0', + `CharacterPoints1` int NOT NULL DEFAULT '0', + `CharacterPoints2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -7739,7 +7947,7 @@ DROP TABLE IF EXISTS `skill_line_x_trait_tree`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `skill_line_x_trait_tree` ( `ID` int unsigned NOT NULL DEFAULT '0', - `SkillLineID` int NOT NULL DEFAULT '0', + `SkillLineID` int unsigned NOT NULL DEFAULT '0', `TraitTreeID` int NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -7795,9 +8003,9 @@ DROP TABLE IF EXISTS `sound_kit`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `sound_kit` ( `ID` int unsigned NOT NULL DEFAULT '0', - `SoundType` int NOT NULL DEFAULT '0', + `SoundType` tinyint unsigned NOT NULL DEFAULT '0', `VolumeFloat` float NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` smallint unsigned NOT NULL DEFAULT '0', `MinDistance` float NOT NULL DEFAULT '0', `DistanceCutoff` float NOT NULL DEFAULT '0', `EAXDef` tinyint unsigned NOT NULL DEFAULT '0', @@ -7888,7 +8096,7 @@ DROP TABLE IF EXISTS `spell_aura_options`; CREATE TABLE `spell_aura_options` ( `ID` int unsigned NOT NULL DEFAULT '0', `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', - `CumulativeAura` smallint unsigned NOT NULL DEFAULT '0', + `CumulativeAura` int unsigned NOT NULL DEFAULT '0', `ProcCategoryRecovery` int NOT NULL DEFAULT '0', `ProcChance` tinyint unsigned NOT NULL DEFAULT '0', `ProcCharges` int NOT NULL DEFAULT '0', @@ -7910,19 +8118,15 @@ DROP TABLE IF EXISTS `spell_aura_restrictions`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_aura_restrictions` ( `ID` int unsigned NOT NULL DEFAULT '0', - `DifficultyID` int NOT NULL DEFAULT '0', - `CasterAuraState` int NOT NULL DEFAULT '0', - `TargetAuraState` int NOT NULL DEFAULT '0', - `ExcludeCasterAuraState` int NOT NULL DEFAULT '0', - `ExcludeTargetAuraState` int NOT NULL DEFAULT '0', + `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', + `CasterAuraState` tinyint unsigned NOT NULL DEFAULT '0', + `TargetAuraState` tinyint unsigned NOT NULL DEFAULT '0', + `ExcludeCasterAuraState` tinyint unsigned NOT NULL DEFAULT '0', + `ExcludeTargetAuraState` tinyint unsigned NOT NULL DEFAULT '0', `CasterAuraSpell` int NOT NULL DEFAULT '0', `TargetAuraSpell` int NOT NULL DEFAULT '0', `ExcludeCasterAuraSpell` int NOT NULL DEFAULT '0', `ExcludeTargetAuraSpell` int NOT NULL DEFAULT '0', - `CasterAuraType` int NOT NULL DEFAULT '0', - `TargetAuraType` int NOT NULL DEFAULT '0', - `ExcludeCasterAuraType` int NOT NULL DEFAULT '0', - `ExcludeTargetAuraType` int NOT NULL DEFAULT '0', `SpellID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -7939,6 +8143,7 @@ DROP TABLE IF EXISTS `spell_cast_times`; CREATE TABLE `spell_cast_times` ( `ID` int unsigned NOT NULL DEFAULT '0', `Base` int NOT NULL DEFAULT '0', + `PerLevel` smallint NOT NULL DEFAULT '0', `Minimum` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -8070,7 +8275,6 @@ CREATE TABLE `spell_cooldowns` ( `CategoryRecoveryTime` int NOT NULL DEFAULT '0', `RecoveryTime` int NOT NULL DEFAULT '0', `StartRecoveryTime` int NOT NULL DEFAULT '0', - `AuraSpellID` int NOT NULL DEFAULT '0', `SpellID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -8087,6 +8291,7 @@ DROP TABLE IF EXISTS `spell_duration`; CREATE TABLE `spell_duration` ( `ID` int unsigned NOT NULL DEFAULT '0', `Duration` int NOT NULL DEFAULT '0', + `DurationPerLevel` int unsigned NOT NULL DEFAULT '0', `MaxDuration` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -8102,16 +8307,18 @@ DROP TABLE IF EXISTS `spell_effect`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_effect` ( `ID` int unsigned NOT NULL DEFAULT '0', - `EffectAura` smallint NOT NULL DEFAULT '0', `DifficultyID` int NOT NULL DEFAULT '0', `EffectIndex` int NOT NULL DEFAULT '0', `Effect` int unsigned NOT NULL DEFAULT '0', `EffectAmplitude` float NOT NULL DEFAULT '0', `EffectAttributes` int NOT NULL DEFAULT '0', + `EffectAura` smallint NOT NULL DEFAULT '0', `EffectAuraPeriod` int NOT NULL DEFAULT '0', + `EffectBasePoints` int NOT NULL DEFAULT '0', `EffectBonusCoefficient` float NOT NULL DEFAULT '0', `EffectChainAmplitude` float NOT NULL DEFAULT '0', `EffectChainTargets` int NOT NULL DEFAULT '0', + `EffectDieSides` int NOT NULL DEFAULT '0', `EffectItemType` int NOT NULL DEFAULT '0', `EffectMechanic` int NOT NULL DEFAULT '0', `EffectPointsPerResource` float NOT NULL DEFAULT '0', @@ -8124,8 +8331,6 @@ CREATE TABLE `spell_effect` ( `Variance` float NOT NULL DEFAULT '0', `ResourceCoefficient` float NOT NULL DEFAULT '0', `GroupSizeBasePointsCoefficient` float NOT NULL DEFAULT '0', - `EffectBasePoints` float NOT NULL DEFAULT '0', - `ScalingClass` int NOT NULL DEFAULT '0', `EffectMiscValue1` int NOT NULL DEFAULT '0', `EffectMiscValue2` int NOT NULL DEFAULT '0', `EffectRadiusIndex1` int unsigned NOT NULL DEFAULT '0', @@ -8234,18 +8439,16 @@ CREATE TABLE `spell_item_enchantment` ( `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `HordeName` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, - `Duration` int NOT NULL DEFAULT '0', `EffectArg1` int unsigned NOT NULL DEFAULT '0', `EffectArg2` int unsigned NOT NULL DEFAULT '0', `EffectArg3` int unsigned NOT NULL DEFAULT '0', `EffectScalingPoints1` float NOT NULL DEFAULT '0', `EffectScalingPoints2` float NOT NULL DEFAULT '0', `EffectScalingPoints3` float NOT NULL DEFAULT '0', - `IconFileDataID` int unsigned NOT NULL DEFAULT '0', - `MinItemLevel` int NOT NULL DEFAULT '0', - `MaxItemLevel` int NOT NULL DEFAULT '0', - `TransmogUseConditionID` int unsigned NOT NULL DEFAULT '0', + `GemItemID` int unsigned NOT NULL DEFAULT '0', + `TransmogUnlockConditionID` int unsigned NOT NULL DEFAULT '0', `TransmogCost` int unsigned NOT NULL DEFAULT '0', + `IconFileDataID` int unsigned NOT NULL DEFAULT '0', `EffectPointsMin1` smallint NOT NULL DEFAULT '0', `EffectPointsMin2` smallint NOT NULL DEFAULT '0', `EffectPointsMin3` smallint NOT NULL DEFAULT '0', @@ -8401,10 +8604,10 @@ DROP TABLE IF EXISTS `spell_levels`; CREATE TABLE `spell_levels` ( `ID` int unsigned NOT NULL DEFAULT '0', `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', + `BaseLevel` smallint NOT NULL DEFAULT '0', `MaxLevel` smallint NOT NULL DEFAULT '0', + `SpellLevel` smallint NOT NULL DEFAULT '0', `MaxPassiveAuraLevel` tinyint unsigned NOT NULL DEFAULT '0', - `BaseLevel` int NOT NULL DEFAULT '0', - `SpellLevel` int NOT NULL DEFAULT '0', `SpellID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -8447,8 +8650,6 @@ CREATE TABLE `spell_misc` ( `ActiveIconFileDataID` int NOT NULL DEFAULT '0', `ContentTuningID` int NOT NULL DEFAULT '0', `ShowFutureSpellPlayerConditionID` int NOT NULL DEFAULT '0', - `SpellVisualScript` int NOT NULL DEFAULT '0', - `ActiveSpellVisualScript` int NOT NULL DEFAULT '0', `SpellID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -8514,7 +8715,6 @@ CREATE TABLE `spell_power` ( `AltPowerBarID` int NOT NULL DEFAULT '0', `PowerCostPct` float NOT NULL DEFAULT '0', `PowerCostMaxPct` float NOT NULL DEFAULT '0', - `OptionalCostPct` float NOT NULL DEFAULT '0', `PowerPctPerSecond` float NOT NULL DEFAULT '0', `PowerType` tinyint NOT NULL DEFAULT '0', `RequiredAuraSpellID` int NOT NULL DEFAULT '0', @@ -8567,7 +8767,7 @@ DROP TABLE IF EXISTS `spell_procs_per_minute_mod`; CREATE TABLE `spell_procs_per_minute_mod` ( `ID` int unsigned NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '0', - `Param` int NOT NULL DEFAULT '0', + `Param` smallint NOT NULL DEFAULT '0', `Coeff` float NOT NULL DEFAULT '0', `SpellProcsPerMinuteID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -8668,22 +8868,6 @@ CREATE TABLE `spell_reagents` ( `ReagentCount6` smallint NOT NULL DEFAULT '0', `ReagentCount7` smallint NOT NULL DEFAULT '0', `ReagentCount8` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount1` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount2` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount3` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount4` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount5` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount6` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount7` smallint NOT NULL DEFAULT '0', - `ReagentRecraftCount8` smallint NOT NULL DEFAULT '0', - `ReagentSource1` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource2` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource3` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource4` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource5` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource6` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource7` tinyint unsigned NOT NULL DEFAULT '0', - `ReagentSource8` tinyint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -8698,7 +8882,7 @@ DROP TABLE IF EXISTS `spell_reagents_currency`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_reagents_currency` ( `ID` int unsigned NOT NULL DEFAULT '0', - `SpellID` int NOT NULL DEFAULT '0', + `SpellID` int unsigned NOT NULL DEFAULT '0', `CurrencyTypesID` smallint unsigned NOT NULL DEFAULT '0', `CurrencyCount` smallint unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -8716,6 +8900,7 @@ DROP TABLE IF EXISTS `spell_scaling`; CREATE TABLE `spell_scaling` ( `ID` int unsigned NOT NULL DEFAULT '0', `SpellID` int NOT NULL DEFAULT '0', + `Class` int NOT NULL DEFAULT '0', `MinScalingLevel` int unsigned NOT NULL DEFAULT '0', `MaxScalingLevel` int unsigned NOT NULL DEFAULT '0', `ScalesFromItemLevel` smallint NOT NULL DEFAULT '0', @@ -8875,6 +9060,8 @@ CREATE TABLE `spell_visual` ( `LowViolenceSpellVisualID` int unsigned NOT NULL DEFAULT '0', `RaidSpellVisualMissileSetID` int unsigned NOT NULL DEFAULT '0', `ReducedUnexpectedCameraMovementSpellVisualID` int NOT NULL DEFAULT '0', + `AreaModel` smallint unsigned NOT NULL DEFAULT '0', + `HasMissile` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -8903,7 +9090,6 @@ CREATE TABLE `spell_visual_effect_name` ( `RibbonQualityID` int unsigned NOT NULL DEFAULT '0', `DissolveEffectID` int NOT NULL DEFAULT '0', `ModelPosition` int NOT NULL DEFAULT '0', - `Unknown901` tinyint NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -8918,10 +9104,10 @@ DROP TABLE IF EXISTS `spell_visual_kit`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `spell_visual_kit` ( `ID` int unsigned NOT NULL DEFAULT '0', - `FallbackPriority` tinyint NOT NULL DEFAULT '0', - `FallbackSpellVisualKitId` int NOT NULL DEFAULT '0', + `FallbackSpellVisualKitId` int unsigned NOT NULL DEFAULT '0', `DelayMin` smallint unsigned NOT NULL DEFAULT '0', `DelayMax` smallint unsigned NOT NULL DEFAULT '0', + `FallbackPriority` float NOT NULL DEFAULT '0', `Flags1` int NOT NULL DEFAULT '0', `Flags2` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -8956,8 +9142,6 @@ CREATE TABLE `spell_visual_missile` ( `Flags` int unsigned NOT NULL DEFAULT '0', `SpellMissileMotionID` smallint unsigned NOT NULL DEFAULT '0', `AnimKitID` int unsigned NOT NULL DEFAULT '0', - `ClutterLevel` tinyint NOT NULL DEFAULT '0', - `DecayTimeAfterImpact` int NOT NULL DEFAULT '0', `SpellVisualMissileSetID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -8976,7 +9160,7 @@ CREATE TABLE `spell_x_spell_visual` ( `DifficultyID` tinyint unsigned NOT NULL DEFAULT '0', `SpellVisualID` int unsigned NOT NULL DEFAULT '0', `Probability` float NOT NULL DEFAULT '0', - `Flags` int NOT NULL DEFAULT '0', + `Flags` tinyint unsigned NOT NULL DEFAULT '0', `Priority` int NOT NULL DEFAULT '0', `SpellIconFileID` int NOT NULL DEFAULT '0', `ActiveIconFileID` int NOT NULL DEFAULT '0', @@ -9053,12 +9237,29 @@ CREATE TABLE `talent` ( `TierID` tinyint unsigned NOT NULL DEFAULT '0', `Flags` tinyint unsigned NOT NULL DEFAULT '0', `ColumnIndex` tinyint unsigned NOT NULL DEFAULT '0', + `TabID` smallint unsigned NOT NULL DEFAULT '0', `ClassID` tinyint unsigned NOT NULL DEFAULT '0', `SpecID` smallint unsigned NOT NULL DEFAULT '0', - `SpellID` int unsigned NOT NULL DEFAULT '0', - `OverridesSpellID` int unsigned NOT NULL DEFAULT '0', - `CategoryMask1` tinyint unsigned NOT NULL DEFAULT '0', - `CategoryMask2` tinyint unsigned NOT NULL DEFAULT '0', + `SpellID` int NOT NULL DEFAULT '0', + `OverridesSpellID` int NOT NULL DEFAULT '0', + `RequiredSpellID` int NOT NULL DEFAULT '0', + `CategoryMask1` int NOT NULL DEFAULT '0', + `CategoryMask2` int NOT NULL DEFAULT '0', + `SpellRank1` int NOT NULL DEFAULT '0', + `SpellRank2` int NOT NULL DEFAULT '0', + `SpellRank3` int NOT NULL DEFAULT '0', + `SpellRank4` int NOT NULL DEFAULT '0', + `SpellRank5` int NOT NULL DEFAULT '0', + `SpellRank6` int NOT NULL DEFAULT '0', + `SpellRank7` int NOT NULL DEFAULT '0', + `SpellRank8` int NOT NULL DEFAULT '0', + `SpellRank9` int NOT NULL DEFAULT '0', + `PrereqTalent1` int NOT NULL DEFAULT '0', + `PrereqTalent2` int NOT NULL DEFAULT '0', + `PrereqTalent3` int NOT NULL DEFAULT '0', + `PrereqRank1` int NOT NULL DEFAULT '0', + `PrereqRank2` int NOT NULL DEFAULT '0', + `PrereqRank3` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9092,6 +9293,54 @@ CREATE TABLE `talent_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `talent_tab` +-- + +DROP TABLE IF EXISTS `talent_tab`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `talent_tab` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `BackgroundFile` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `OrderIndex` int NOT NULL DEFAULT '0', + `RaceMask` int NOT NULL DEFAULT '0', + `ClassMask` int NOT NULL DEFAULT '0', + `PetTalentMask` int NOT NULL DEFAULT '0', + `SpellIconID` int NOT NULL DEFAULT '0', + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `talent_tab_locale` +-- + +DROP TABLE IF EXISTS `talent_tab_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!50503 SET character_set_client = utf8mb4 */; +CREATE TABLE `talent_tab_locale` ( + `ID` int unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, + `Name_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `VerifiedBuild` int NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`,`locale`,`VerifiedBuild`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci +/*!50500 PARTITION BY LIST COLUMNS(locale) +(PARTITION deDE VALUES IN ('deDE') ENGINE = InnoDB, + PARTITION esES VALUES IN ('esES') ENGINE = InnoDB, + PARTITION esMX VALUES IN ('esMX') ENGINE = InnoDB, + PARTITION frFR VALUES IN ('frFR') ENGINE = InnoDB, + PARTITION itIT VALUES IN ('itIT') ENGINE = InnoDB, + PARTITION koKR VALUES IN ('koKR') ENGINE = InnoDB, + PARTITION ptBR VALUES IN ('ptBR') ENGINE = InnoDB, + PARTITION ruRU VALUES IN ('ruRU') ENGINE = InnoDB, + PARTITION zhCN VALUES IN ('zhCN') ENGINE = InnoDB, + PARTITION zhTW VALUES IN ('zhTW') ENGINE = InnoDB) */; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- -- Table structure for table `taxi_nodes` -- @@ -9108,12 +9357,11 @@ CREATE TABLE `taxi_nodes` ( `FlightMapOffsetX` float NOT NULL DEFAULT '0', `FlightMapOffsetY` float NOT NULL DEFAULT '0', `ID` int unsigned NOT NULL DEFAULT '0', - `ContinentID` smallint unsigned NOT NULL DEFAULT '0', - `ConditionID` int NOT NULL DEFAULT '0', + `ContinentID` int unsigned NOT NULL DEFAULT '0', + `ConditionID` int unsigned NOT NULL DEFAULT '0', `CharacterBitNumber` smallint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `UiTextureKitID` int NOT NULL DEFAULT '0', - `MinimapAtlasMemberID` int NOT NULL DEFAULT '0', `Facing` float NOT NULL DEFAULT '0', `SpecialIconConditionID` int unsigned NOT NULL DEFAULT '0', `VisibilityConditionID` int unsigned NOT NULL DEFAULT '0', @@ -9185,8 +9433,8 @@ CREATE TABLE `taxi_path_node` ( `ContinentID` smallint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `Delay` int unsigned NOT NULL DEFAULT '0', - `ArrivalEventID` int NOT NULL DEFAULT '0', - `DepartureEventID` int NOT NULL DEFAULT '0', + `ArrivalEventID` int unsigned NOT NULL DEFAULT '0', + `DepartureEventID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9291,7 +9539,7 @@ DROP TABLE IF EXISTS `trait_cond`; CREATE TABLE `trait_cond` ( `ID` int unsigned NOT NULL DEFAULT '0', `CondType` int NOT NULL DEFAULT '0', - `TraitTreeID` int NOT NULL DEFAULT '0', + `TraitTreeID` int unsigned NOT NULL DEFAULT '0', `GrantedRanks` int NOT NULL DEFAULT '0', `QuestID` int NOT NULL DEFAULT '0', `AchievementID` int NOT NULL DEFAULT '0', @@ -9354,7 +9602,7 @@ DROP TABLE IF EXISTS `trait_currency_source`; CREATE TABLE `trait_currency_source` ( `Requirement` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ID` int unsigned NOT NULL DEFAULT '0', - `TraitCurrencyID` int NOT NULL DEFAULT '0', + `TraitCurrencyID` int unsigned NOT NULL DEFAULT '0', `Amount` int NOT NULL DEFAULT '0', `QuestID` int NOT NULL DEFAULT '0', `AchievementID` int NOT NULL DEFAULT '0', @@ -9423,7 +9671,7 @@ DROP TABLE IF EXISTS `trait_definition_effect_points`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_definition_effect_points` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitDefinitionID` int NOT NULL DEFAULT '0', + `TraitDefinitionID` int unsigned NOT NULL DEFAULT '0', `EffectIndex` int NOT NULL DEFAULT '0', `OperationType` int NOT NULL DEFAULT '0', `CurveID` int NOT NULL DEFAULT '0', @@ -9471,7 +9719,7 @@ DROP TABLE IF EXISTS `trait_edge`; CREATE TABLE `trait_edge` ( `ID` int unsigned NOT NULL DEFAULT '0', `VisualStyle` int NOT NULL DEFAULT '0', - `LeftTraitNodeID` int NOT NULL DEFAULT '0', + `LeftTraitNodeID` int unsigned NOT NULL DEFAULT '0', `RightTraitNodeID` int NOT NULL DEFAULT '0', `Type` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -9488,10 +9736,10 @@ DROP TABLE IF EXISTS `trait_node`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitTreeID` int NOT NULL DEFAULT '0', + `TraitTreeID` int unsigned NOT NULL DEFAULT '0', `PosX` int NOT NULL DEFAULT '0', `PosY` int NOT NULL DEFAULT '0', - `Type` tinyint NOT NULL DEFAULT '0', + `Type` tinyint unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9540,7 +9788,7 @@ DROP TABLE IF EXISTS `trait_node_entry_x_trait_cost`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node_entry_x_trait_cost` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitNodeEntryID` int NOT NULL DEFAULT '0', + `TraitNodeEntryID` int unsigned NOT NULL DEFAULT '0', `TraitCostID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9556,7 +9804,7 @@ DROP TABLE IF EXISTS `trait_node_group`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node_group` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitTreeID` int NOT NULL DEFAULT '0', + `TraitTreeID` int unsigned NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9573,7 +9821,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_cond`; CREATE TABLE `trait_node_group_x_trait_cond` ( `ID` int unsigned NOT NULL DEFAULT '0', `TraitCondID` int NOT NULL DEFAULT '0', - `TraitNodeGroupID` int NOT NULL DEFAULT '0', + `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9588,7 +9836,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_cost`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node_group_x_trait_cost` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitNodeGroupID` int NOT NULL DEFAULT '0', + `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0', `TraitCostID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9604,7 +9852,7 @@ DROP TABLE IF EXISTS `trait_node_group_x_trait_node`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node_group_x_trait_node` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitNodeGroupID` int NOT NULL DEFAULT '0', + `TraitNodeGroupID` int unsigned NOT NULL DEFAULT '0', `TraitNodeID` int NOT NULL DEFAULT '0', `Index` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -9622,7 +9870,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cond`; CREATE TABLE `trait_node_x_trait_cond` ( `ID` int unsigned NOT NULL DEFAULT '0', `TraitCondID` int NOT NULL DEFAULT '0', - `TraitNodeID` int NOT NULL DEFAULT '0', + `TraitNodeID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9637,7 +9885,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_cost`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node_x_trait_cost` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitNodeID` int NOT NULL DEFAULT '0', + `TraitNodeID` int unsigned NOT NULL DEFAULT '0', `TraitCostID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9653,7 +9901,7 @@ DROP TABLE IF EXISTS `trait_node_x_trait_node_entry`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_node_x_trait_node_entry` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitNodeID` int NOT NULL DEFAULT '0', + `TraitNodeID` int unsigned NOT NULL DEFAULT '0', `TraitNodeEntryID` int NOT NULL DEFAULT '0', `Index` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', @@ -9670,7 +9918,7 @@ DROP TABLE IF EXISTS `trait_tree`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_tree` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitSystemID` int NOT NULL DEFAULT '0', + `TraitSystemID` int unsigned NOT NULL DEFAULT '0', `Unused1000_1` int NOT NULL DEFAULT '0', `FirstTraitNodeID` int NOT NULL DEFAULT '0', `PlayerConditionID` int NOT NULL DEFAULT '0', @@ -9691,7 +9939,7 @@ DROP TABLE IF EXISTS `trait_tree_loadout`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_tree_loadout` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitTreeID` int NOT NULL DEFAULT '0', + `TraitTreeID` int unsigned NOT NULL DEFAULT '0', `ChrSpecializationID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9707,7 +9955,7 @@ DROP TABLE IF EXISTS `trait_tree_loadout_entry`; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `trait_tree_loadout_entry` ( `ID` int unsigned NOT NULL DEFAULT '0', - `TraitTreeLoadoutID` int NOT NULL DEFAULT '0', + `TraitTreeLoadoutID` int unsigned NOT NULL DEFAULT '0', `SelectedTraitNodeID` int NOT NULL DEFAULT '0', `SelectedTraitNodeEntryID` int NOT NULL DEFAULT '0', `NumPoints` int NOT NULL DEFAULT '0', @@ -9743,7 +9991,7 @@ DROP TABLE IF EXISTS `trait_tree_x_trait_currency`; CREATE TABLE `trait_tree_x_trait_currency` ( `ID` int unsigned NOT NULL DEFAULT '0', `Index` int NOT NULL DEFAULT '0', - `TraitTreeID` int NOT NULL DEFAULT '0', + `TraitTreeID` int unsigned NOT NULL DEFAULT '0', `TraitCurrencyID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) @@ -9799,11 +10047,8 @@ CREATE TABLE `transmog_set` ( `TransmogSetGroupID` int unsigned NOT NULL DEFAULT '0', `ItemNameDescriptionID` int NOT NULL DEFAULT '0', `ParentTransmogSetID` smallint unsigned NOT NULL DEFAULT '0', - `Unknown810` tinyint unsigned NOT NULL DEFAULT '0', `ExpansionID` tinyint unsigned NOT NULL DEFAULT '0', - `PatchID` int NOT NULL DEFAULT '0', `UiOrder` smallint NOT NULL DEFAULT '0', - `PlayerConditionID` int NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9817,8 +10062,8 @@ DROP TABLE IF EXISTS `transmog_set_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `transmog_set_group` ( - `ID` int unsigned NOT NULL DEFAULT '0', `Name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, + `ID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -9947,7 +10192,7 @@ CREATE TABLE `ui_map` ( `ID` int unsigned NOT NULL DEFAULT '0', `ParentUiMapID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', - `System` tinyint unsigned NOT NULL DEFAULT '0', + `System` tinyint NOT NULL DEFAULT '0', `Type` tinyint unsigned NOT NULL DEFAULT '0', `BountySetID` int NOT NULL DEFAULT '0', `BountyDisplayLocation` int unsigned NOT NULL DEFAULT '0', @@ -9955,8 +10200,8 @@ CREATE TABLE `ui_map` ( `VisibilityPlayerConditionID` int NOT NULL DEFAULT '0', `HelpTextPosition` tinyint NOT NULL DEFAULT '0', `BkgAtlasID` int NOT NULL DEFAULT '0', - `AlternateUiMapGroup` int NOT NULL DEFAULT '0', - `ContentTuningID` int NOT NULL DEFAULT '0', + `AlternateUiMapGroup` int unsigned NOT NULL DEFAULT '0', + `ContentTuningID` int unsigned NOT NULL DEFAULT '0', `VerifiedBuild` int NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`VerifiedBuild`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -10008,7 +10253,6 @@ CREATE TABLE `ui_map_link` ( `ParentUiMapID` int NOT NULL DEFAULT '0', `OrderIndex` int NOT NULL DEFAULT '0', `ChildUiMapID` int NOT NULL DEFAULT '0', - `PlayerConditionID` int NOT NULL DEFAULT '0', `OverrideHighlightFileDataID` int NOT NULL DEFAULT '0', `OverrideHighlightAtlasID` int NOT NULL DEFAULT '0', `Flags` int NOT NULL DEFAULT '0', @@ -10177,7 +10421,7 @@ CREATE TABLE `unit_power_bar` ( `ToolTip` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `MinPower` int unsigned NOT NULL DEFAULT '0', `MaxPower` int unsigned NOT NULL DEFAULT '0', - `StartPower` int unsigned NOT NULL DEFAULT '0', + `StartPower` smallint unsigned NOT NULL DEFAULT '0', `CenterPower` tinyint unsigned NOT NULL DEFAULT '0', `RegenerationPeace` float NOT NULL DEFAULT '0', `RegenerationCombat` float NOT NULL DEFAULT '0', @@ -10288,6 +10532,7 @@ CREATE TABLE `vehicle` ( `VehicleUIIndicatorID` smallint unsigned NOT NULL DEFAULT '0', `MissileTargetingID` int NOT NULL DEFAULT '0', `VehiclePOITypeID` smallint unsigned NOT NULL DEFAULT '0', + `UiLocomotionType` int NOT NULL DEFAULT '0', `SeatID1` smallint unsigned NOT NULL DEFAULT '0', `SeatID2` smallint unsigned NOT NULL DEFAULT '0', `SeatID3` smallint unsigned NOT NULL DEFAULT '0', @@ -10362,6 +10607,7 @@ CREATE TABLE `vehicle_seat` ( `EnterUISoundID` int unsigned NOT NULL DEFAULT '0', `ExitUISoundID` int unsigned NOT NULL DEFAULT '0', `UiSkinFileDataID` int NOT NULL DEFAULT '0', + `UiSkin` int NOT NULL DEFAULT '0', `CameraEnteringDelay` float NOT NULL DEFAULT '0', `CameraEnteringDuration` float NOT NULL DEFAULT '0', `CameraExitingDelay` float NOT NULL DEFAULT '0', @@ -10515,4 +10761,4 @@ CREATE TABLE `world_state_expression` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2023-10-06 0:40:56 +-- Dump completed on 2023-12-20 23:19:40 |