-- MySQL dump 10.17 Distrib 10.3.15-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: hotfixes_8 -- ------------------------------------------------------ -- Server version 10.3.15-MariaDB-1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `achievement` -- DROP TABLE IF EXISTS `achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement` ( `Description` text DEFAULT NULL, `Title` text DEFAULT NULL, `Reward` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `InstanceID` smallint(6) NOT NULL DEFAULT 0, `Faction` tinyint(4) NOT NULL DEFAULT 0, `Supercedes` smallint(6) NOT NULL DEFAULT 0, `Category` smallint(6) NOT NULL DEFAULT 0, `MinimumCriteria` tinyint(4) NOT NULL DEFAULT 0, `Points` tinyint(4) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `UiOrder` smallint(6) NOT NULL DEFAULT 0, `IconFileID` int(11) NOT NULL DEFAULT 0, `RewardItemID` int(11) NOT NULL DEFAULT 0, `CriteriaTree` int(10) unsigned NOT NULL DEFAULT 0, `SharesCriteria` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_locale` -- DROP TABLE IF EXISTS `achievement_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `Title_lang` text DEFAULT NULL, `Reward_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `anim_kit` -- DROP TABLE IF EXISTS `anim_kit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `anim_kit` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `OneShotDuration` int(10) unsigned NOT NULL DEFAULT 0, `OneShotStopAnimKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `LowDefAnimKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `animation_data` -- DROP TABLE IF EXISTS `animation_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `animation_data` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `BehaviorID` smallint(5) unsigned NOT NULL DEFAULT 0, `BehaviorTier` tinyint(3) unsigned NOT NULL DEFAULT 0, `Fallback` int(11) NOT NULL DEFAULT 0, `Flags1` int(11) NOT NULL DEFAULT 0, `Flags2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `area_group_member` -- DROP TABLE IF EXISTS `area_group_member`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `area_group_member` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `AreaID` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaGroupID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `area_table` -- DROP TABLE IF EXISTS `area_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `area_table` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ZoneName` text DEFAULT NULL, `AreaName` text DEFAULT NULL, `ContinentID` smallint(5) unsigned NOT NULL DEFAULT 0, `ParentAreaID` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaBit` smallint(6) NOT NULL DEFAULT 0, `SoundProviderPref` tinyint(3) unsigned NOT NULL DEFAULT 0, `SoundProviderPrefUnderwater` tinyint(3) unsigned NOT NULL DEFAULT 0, `AmbienceID` smallint(5) unsigned NOT NULL DEFAULT 0, `UwAmbience` smallint(5) unsigned NOT NULL DEFAULT 0, `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT 0, `UwZoneMusic` smallint(5) unsigned NOT NULL DEFAULT 0, `ExplorationLevel` tinyint(4) NOT NULL DEFAULT 0, `IntroSound` smallint(5) unsigned NOT NULL DEFAULT 0, `UwIntroSound` int(10) unsigned NOT NULL DEFAULT 0, `FactionGroupMask` tinyint(3) unsigned NOT NULL DEFAULT 0, `AmbientMultiplier` float NOT NULL DEFAULT 0, `MountFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, `PvpCombatWorldStateID` smallint(6) NOT NULL DEFAULT 0, `WildBattlePetLevelMin` tinyint(3) unsigned NOT NULL DEFAULT 0, `WildBattlePetLevelMax` tinyint(3) unsigned NOT NULL DEFAULT 0, `WindSettingsID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags1` int(11) NOT NULL DEFAULT 0, `Flags2` int(11) NOT NULL DEFAULT 0, `LiquidTypeID1` smallint(5) unsigned NOT NULL DEFAULT 0, `LiquidTypeID2` smallint(5) unsigned NOT NULL DEFAULT 0, `LiquidTypeID3` smallint(5) unsigned NOT NULL DEFAULT 0, `LiquidTypeID4` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `area_table_locale` -- DROP TABLE IF EXISTS `area_table_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `area_table_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `AreaName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `area_trigger` -- DROP TABLE IF EXISTS `area_trigger`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `area_trigger` ( `PosX` float NOT NULL DEFAULT 0, `PosY` float NOT NULL DEFAULT 0, `PosZ` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ContinentID` smallint(6) NOT NULL DEFAULT 0, `PhaseUseFlags` tinyint(4) NOT NULL DEFAULT 0, `PhaseID` smallint(6) NOT NULL DEFAULT 0, `PhaseGroupID` smallint(6) NOT NULL DEFAULT 0, `Radius` float NOT NULL DEFAULT 0, `BoxLength` float NOT NULL DEFAULT 0, `BoxWidth` float NOT NULL DEFAULT 0, `BoxHeight` float NOT NULL DEFAULT 0, `BoxYaw` float NOT NULL DEFAULT 0, `ShapeType` tinyint(4) NOT NULL DEFAULT 0, `ShapeID` smallint(6) NOT NULL DEFAULT 0, `AreaTriggerActionSetID` smallint(6) NOT NULL DEFAULT 0, `Flags` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `armor_location` -- DROP TABLE IF EXISTS `armor_location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `armor_location` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Clothmodifier` float NOT NULL DEFAULT 0, `Leathermodifier` float NOT NULL DEFAULT 0, `Chainmodifier` float NOT NULL DEFAULT 0, `Platemodifier` float NOT NULL DEFAULT 0, `Modifier` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact` -- DROP TABLE IF EXISTS `artifact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact` ( `Name` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `UiTextureKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `UiNameColor` int(11) NOT NULL DEFAULT 0, `UiBarOverlayColor` int(11) NOT NULL DEFAULT 0, `UiBarBackgroundColor` int(11) NOT NULL DEFAULT 0, `ChrSpecializationID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ArtifactCategoryID` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiModelSceneID` int(10) unsigned NOT NULL DEFAULT 0, `SpellVisualKitID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_appearance` -- DROP TABLE IF EXISTS `artifact_appearance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_appearance` ( `Name` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ArtifactAppearanceSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `DisplayIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `UnlockPlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `ItemAppearanceModifierID` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiSwatchColor` int(11) NOT NULL DEFAULT 0, `UiModelSaturation` float NOT NULL DEFAULT 0, `UiModelOpacity` float NOT NULL DEFAULT 0, `OverrideShapeshiftFormID` tinyint(3) unsigned NOT NULL DEFAULT 0, `OverrideShapeshiftDisplayID` int(10) unsigned NOT NULL DEFAULT 0, `UiItemAppearanceID` int(10) unsigned NOT NULL DEFAULT 0, `UiAltItemAppearanceID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiCameraID` smallint(5) unsigned NOT NULL DEFAULT 0, `UsablePlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_appearance_locale` -- DROP TABLE IF EXISTS `artifact_appearance_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_appearance_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_appearance_set` -- DROP TABLE IF EXISTS `artifact_appearance_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_appearance_set` ( `Name` text DEFAULT NULL, `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `DisplayIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiCameraID` smallint(5) unsigned NOT NULL DEFAULT 0, `AltHandUICameraID` smallint(5) unsigned NOT NULL DEFAULT 0, `ForgeAttachmentOverride` tinyint(4) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_appearance_set_locale` -- DROP TABLE IF EXISTS `artifact_appearance_set_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_appearance_set_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_category` -- DROP TABLE IF EXISTS `artifact_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_category` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `XpMultCurrencyID` smallint(6) NOT NULL DEFAULT 0, `XpMultCurveID` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_locale` -- DROP TABLE IF EXISTS `artifact_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_power` -- DROP TABLE IF EXISTS `artifact_power`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_power` ( `DisplayPosX` float NOT NULL DEFAULT 0, `DisplayPosY` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxPurchasableRank` tinyint(3) unsigned NOT NULL DEFAULT 0, `Label` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `Tier` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_power_link` -- DROP TABLE IF EXISTS `artifact_power_link`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_power_link` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PowerA` smallint(5) unsigned NOT NULL DEFAULT 0, `PowerB` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_power_picker` -- DROP TABLE IF EXISTS `artifact_power_picker`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_power_picker` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_power_rank` -- DROP TABLE IF EXISTS `artifact_power_rank`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_power_rank` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RankIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `ItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT 0, `AuraPointsOverride` float NOT NULL DEFAULT 0, `ArtifactPowerID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_quest_xp` -- DROP TABLE IF EXISTS `artifact_quest_xp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_quest_xp` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty1` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty2` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty3` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty4` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty5` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty6` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty7` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty8` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty9` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty10` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_tier` -- DROP TABLE IF EXISTS `artifact_tier`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_tier` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ArtifactTier` int(10) unsigned NOT NULL DEFAULT 0, `MaxNumTraits` int(10) unsigned NOT NULL DEFAULT 0, `MaxArtifactKnowledge` int(10) unsigned NOT NULL DEFAULT 0, `KnowledgePlayerCondition` int(10) unsigned NOT NULL DEFAULT 0, `MinimumEmpowerKnowledge` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `artifact_unlock` -- DROP TABLE IF EXISTS `artifact_unlock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `artifact_unlock` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PowerID` int(10) unsigned NOT NULL DEFAULT 0, `PowerRank` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `auction_house` -- DROP TABLE IF EXISTS `auction_house`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auction_house` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `FactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `DepositRate` tinyint(3) unsigned NOT NULL DEFAULT 0, `ConsignmentRate` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `auction_house_locale` -- DROP TABLE IF EXISTS `auction_house_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auction_house_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `bank_bag_slot_prices` -- DROP TABLE IF EXISTS `bank_bag_slot_prices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bank_bag_slot_prices` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Cost` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `banned_addons` -- DROP TABLE IF EXISTS `banned_addons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `banned_addons` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Version` text DEFAULT NULL, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `barber_shop_style` -- DROP TABLE IF EXISTS `barber_shop_style`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `barber_shop_style` ( `DisplayName` text DEFAULT NULL, `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `Type` tinyint(3) unsigned NOT NULL DEFAULT 0, `CostModifier` float NOT NULL DEFAULT 0, `Race` tinyint(3) unsigned NOT NULL DEFAULT 0, `Sex` tinyint(3) unsigned NOT NULL DEFAULT 0, `Data` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `barber_shop_style_locale` -- DROP TABLE IF EXISTS `barber_shop_style_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `barber_shop_style_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `DisplayName_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battle_pet_breed_quality` -- DROP TABLE IF EXISTS `battle_pet_breed_quality`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_breed_quality` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `StateMultiplier` float NOT NULL DEFAULT 0, `QualityEnum` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battle_pet_breed_state` -- DROP TABLE IF EXISTS `battle_pet_breed_state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_breed_state` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `BattlePetStateID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Value` smallint(5) unsigned NOT NULL DEFAULT 0, `BattlePetBreedID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battle_pet_species` -- DROP TABLE IF EXISTS `battle_pet_species`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_species` ( `Description` text DEFAULT NULL, `SourceText` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `CreatureID` int(11) NOT NULL DEFAULT 0, `SummonSpellID` int(11) NOT NULL DEFAULT 0, `IconFileDataID` int(11) NOT NULL DEFAULT 0, `PetTypeEnum` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `SourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `CardUIModelSceneID` int(11) NOT NULL DEFAULT 0, `LoadoutUIModelSceneID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battle_pet_species_locale` -- DROP TABLE IF EXISTS `battle_pet_species_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_species_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `SourceText_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battle_pet_species_state` -- DROP TABLE IF EXISTS `battle_pet_species_state`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_species_state` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `BattlePetStateID` smallint(5) unsigned NOT NULL DEFAULT 0, `Value` int(11) NOT NULL DEFAULT 0, `BattlePetSpeciesID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battlemaster_list` -- DROP TABLE IF EXISTS `battlemaster_list`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battlemaster_list` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `GameType` text DEFAULT NULL, `ShortDescription` text DEFAULT NULL, `LongDescription` text DEFAULT NULL, `InstanceType` tinyint(4) NOT NULL DEFAULT 0, `MinLevel` tinyint(4) NOT NULL DEFAULT 0, `MaxLevel` tinyint(4) NOT NULL DEFAULT 0, `RatedPlayers` tinyint(4) NOT NULL DEFAULT 0, `MinPlayers` tinyint(4) NOT NULL DEFAULT 0, `MaxPlayers` tinyint(4) NOT NULL DEFAULT 0, `GroupsAllowed` tinyint(4) NOT NULL DEFAULT 0, `MaxGroupSize` tinyint(4) NOT NULL DEFAULT 0, `HolidayWorldState` smallint(6) NOT NULL DEFAULT 0, `Flags` tinyint(4) NOT NULL DEFAULT 0, `IconFileDataID` int(11) NOT NULL DEFAULT 0, `RequiredPlayerConditionID` smallint(6) NOT NULL DEFAULT 0, `MapID1` smallint(6) NOT NULL DEFAULT 0, `MapID2` smallint(6) NOT NULL DEFAULT 0, `MapID3` smallint(6) NOT NULL DEFAULT 0, `MapID4` smallint(6) NOT NULL DEFAULT 0, `MapID5` smallint(6) NOT NULL DEFAULT 0, `MapID6` smallint(6) NOT NULL DEFAULT 0, `MapID7` smallint(6) NOT NULL DEFAULT 0, `MapID8` smallint(6) NOT NULL DEFAULT 0, `MapID9` smallint(6) NOT NULL DEFAULT 0, `MapID10` smallint(6) NOT NULL DEFAULT 0, `MapID11` smallint(6) NOT NULL DEFAULT 0, `MapID12` smallint(6) NOT NULL DEFAULT 0, `MapID13` smallint(6) NOT NULL DEFAULT 0, `MapID14` smallint(6) NOT NULL DEFAULT 0, `MapID15` smallint(6) NOT NULL DEFAULT 0, `MapID16` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battlemaster_list_locale` -- DROP TABLE IF EXISTS `battlemaster_list_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battlemaster_list_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `GameType_lang` text DEFAULT NULL, `ShortDescription_lang` text DEFAULT NULL, `LongDescription_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `broadcast_text` -- DROP TABLE IF EXISTS `broadcast_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `broadcast_text` ( `Text` text DEFAULT NULL, `Text1` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ConditionID` int(11) NOT NULL DEFAULT 0, `EmotesID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ChatBubbleDurationMs` int(10) unsigned NOT NULL DEFAULT 0, `SoundEntriesID1` int(10) unsigned NOT NULL DEFAULT 0, `SoundEntriesID2` int(10) unsigned NOT NULL DEFAULT 0, `EmoteID1` smallint(5) unsigned NOT NULL DEFAULT 0, `EmoteID2` smallint(5) unsigned NOT NULL DEFAULT 0, `EmoteID3` smallint(5) unsigned NOT NULL DEFAULT 0, `EmoteDelay1` smallint(5) unsigned NOT NULL DEFAULT 0, `EmoteDelay2` smallint(5) unsigned NOT NULL DEFAULT 0, `EmoteDelay3` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `broadcast_text_locale` -- DROP TABLE IF EXISTS `broadcast_text_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `broadcast_text_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Text_lang` text DEFAULT NULL, `Text1_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cfg_regions` -- DROP TABLE IF EXISTS `cfg_regions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cfg_regions` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Tag` text DEFAULT NULL, `RegionID` smallint(5) unsigned NOT NULL DEFAULT 0, `Raidorigin` int(10) unsigned NOT NULL DEFAULT 0, `RegionGroupMask` tinyint(3) unsigned NOT NULL DEFAULT 0, `ChallengeOrigin` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `char_base_section` -- DROP TABLE IF EXISTS `char_base_section`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `char_base_section` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `LayoutResType` tinyint(3) unsigned NOT NULL DEFAULT 0, `VariationEnum` tinyint(3) unsigned NOT NULL DEFAULT 0, `ResolutionVariationEnum` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `char_sections` -- DROP TABLE IF EXISTS `char_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `char_sections` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RaceID` tinyint(4) NOT NULL DEFAULT 0, `SexID` tinyint(4) NOT NULL DEFAULT 0, `BaseSection` tinyint(4) NOT NULL DEFAULT 0, `VariationIndex` tinyint(4) NOT NULL DEFAULT 0, `ColorIndex` tinyint(4) NOT NULL DEFAULT 0, `Flags` smallint(6) NOT NULL DEFAULT 0, `MaterialResourcesID1` int(11) NOT NULL DEFAULT 0, `MaterialResourcesID2` int(11) NOT NULL DEFAULT 0, `MaterialResourcesID3` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `char_start_outfit` -- DROP TABLE IF EXISTS `char_start_outfit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `char_start_outfit` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ClassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SexID` tinyint(3) unsigned NOT NULL DEFAULT 0, `OutfitID` tinyint(3) unsigned NOT NULL DEFAULT 0, `PetDisplayID` int(10) unsigned NOT NULL DEFAULT 0, `PetFamilyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemID1` int(11) NOT NULL DEFAULT 0, `ItemID2` int(11) NOT NULL DEFAULT 0, `ItemID3` int(11) NOT NULL DEFAULT 0, `ItemID4` int(11) NOT NULL DEFAULT 0, `ItemID5` int(11) NOT NULL DEFAULT 0, `ItemID6` int(11) NOT NULL DEFAULT 0, `ItemID7` int(11) NOT NULL DEFAULT 0, `ItemID8` int(11) NOT NULL DEFAULT 0, `ItemID9` int(11) NOT NULL DEFAULT 0, `ItemID10` int(11) NOT NULL DEFAULT 0, `ItemID11` int(11) NOT NULL DEFAULT 0, `ItemID12` int(11) NOT NULL DEFAULT 0, `ItemID13` int(11) NOT NULL DEFAULT 0, `ItemID14` int(11) NOT NULL DEFAULT 0, `ItemID15` int(11) NOT NULL DEFAULT 0, `ItemID16` int(11) NOT NULL DEFAULT 0, `ItemID17` int(11) NOT NULL DEFAULT 0, `ItemID18` int(11) NOT NULL DEFAULT 0, `ItemID19` int(11) NOT NULL DEFAULT 0, `ItemID20` int(11) NOT NULL DEFAULT 0, `ItemID21` int(11) NOT NULL DEFAULT 0, `ItemID22` int(11) NOT NULL DEFAULT 0, `ItemID23` int(11) NOT NULL DEFAULT 0, `ItemID24` int(11) NOT NULL DEFAULT 0, `RaceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `char_titles` -- DROP TABLE IF EXISTS `char_titles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `char_titles` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Name1` text DEFAULT NULL, `MaskID` smallint(6) NOT NULL DEFAULT 0, `Flags` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `char_titles_locale` -- DROP TABLE IF EXISTS `char_titles_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `char_titles_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Name1_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `character_facial_hair_styles` -- DROP TABLE IF EXISTS `character_facial_hair_styles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `character_facial_hair_styles` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Geoset1` int(11) NOT NULL DEFAULT 0, `Geoset2` int(11) NOT NULL DEFAULT 0, `Geoset3` int(11) NOT NULL DEFAULT 0, `Geoset4` int(11) NOT NULL DEFAULT 0, `Geoset5` int(11) NOT NULL DEFAULT 0, `RaceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SexID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VariationID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chat_channels` -- DROP TABLE IF EXISTS `chat_channels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat_channels` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Shortcut` text DEFAULT NULL, `Flags` int(11) NOT NULL DEFAULT 0, `FactionGroup` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chat_channels_locale` -- DROP TABLE IF EXISTS `chat_channels_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat_channels_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Shortcut_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_classes` -- DROP TABLE IF EXISTS `chr_classes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_classes` ( `Name` text DEFAULT NULL, `Filename` text DEFAULT NULL, `NameMale` text DEFAULT NULL, `NameFemale` text DEFAULT NULL, `PetNameToken` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `CreateScreenFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `SelectScreenFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `IconFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `LowResScreenFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `StartingLevel` int(11) NOT NULL DEFAULT 0, `SpellTextureBlobFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `CinematicSequenceID` smallint(5) unsigned NOT NULL DEFAULT 0, `DefaultSpec` smallint(5) unsigned NOT NULL DEFAULT 0, `PrimaryStatPriority` tinyint(3) unsigned NOT NULL DEFAULT 0, `DisplayPower` tinyint(3) unsigned NOT NULL DEFAULT 0, `RangedAttackPowerPerAgility` tinyint(3) unsigned NOT NULL DEFAULT 0, `AttackPowerPerAgility` tinyint(3) unsigned NOT NULL DEFAULT 0, `AttackPowerPerStrength` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellClassSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_classes_locale` -- DROP TABLE IF EXISTS `chr_classes_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_classes_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `NameMale_lang` text DEFAULT NULL, `NameFemale_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_classes_x_power_types` -- DROP TABLE IF EXISTS `chr_classes_x_power_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_classes_x_power_types` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PowerType` tinyint(4) NOT NULL DEFAULT 0, `ClassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_races` -- DROP TABLE IF EXISTS `chr_races`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_races` ( `ClientPrefix` text DEFAULT NULL, `ClientFileString` text DEFAULT NULL, `Name` text DEFAULT NULL, `NameFemale` text DEFAULT NULL, `NameLowercase` text DEFAULT NULL, `NameFemaleLowercase` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `MaleDisplayId` int(10) unsigned NOT NULL DEFAULT 0, `FemaleDisplayId` int(10) unsigned NOT NULL DEFAULT 0, `HighResMaleDisplayId` int(10) unsigned NOT NULL DEFAULT 0, `HighResFemaleDisplayId` int(10) unsigned NOT NULL DEFAULT 0, `CreateScreenFileDataID` int(11) NOT NULL DEFAULT 0, `SelectScreenFileDataID` int(11) NOT NULL DEFAULT 0, `MaleCustomizeOffset1` float NOT NULL DEFAULT 0, `MaleCustomizeOffset2` float NOT NULL DEFAULT 0, `MaleCustomizeOffset3` float NOT NULL DEFAULT 0, `FemaleCustomizeOffset1` float NOT NULL DEFAULT 0, `FemaleCustomizeOffset2` float NOT NULL DEFAULT 0, `FemaleCustomizeOffset3` float NOT NULL DEFAULT 0, `LowResScreenFileDataID` int(11) NOT NULL DEFAULT 0, `AlteredFormStartVisualKitID1` int(10) unsigned NOT NULL DEFAULT 0, `AlteredFormStartVisualKitID2` int(10) unsigned NOT NULL DEFAULT 0, `AlteredFormStartVisualKitID3` int(10) unsigned NOT NULL DEFAULT 0, `AlteredFormFinishVisualKitID1` int(10) unsigned NOT NULL DEFAULT 0, `AlteredFormFinishVisualKitID2` int(10) unsigned NOT NULL DEFAULT 0, `AlteredFormFinishVisualKitID3` int(10) unsigned NOT NULL DEFAULT 0, `HeritageArmorAchievementID` int(11) NOT NULL DEFAULT 0, `StartingLevel` int(11) NOT NULL DEFAULT 0, `UiDisplayOrder` int(11) NOT NULL DEFAULT 0, `FemaleSkeletonFileDataID` int(11) NOT NULL DEFAULT 0, `MaleSkeletonFileDataID` int(11) NOT NULL DEFAULT 0, `HelmVisFallbackRaceID` int(11) NOT NULL DEFAULT 0, `FactionID` smallint(6) NOT NULL DEFAULT 0, `CinematicSequenceID` smallint(6) NOT NULL DEFAULT 0, `ResSicknessSpellID` smallint(6) NOT NULL DEFAULT 0, `SplashSoundID` smallint(6) NOT NULL DEFAULT 0, `BaseLanguage` tinyint(4) NOT NULL DEFAULT 0, `CreatureType` tinyint(4) NOT NULL DEFAULT 0, `Alliance` tinyint(4) NOT NULL DEFAULT 0, `RaceRelated` tinyint(4) NOT NULL DEFAULT 0, `UnalteredVisualRaceID` tinyint(4) NOT NULL DEFAULT 0, `CharComponentTextureLayoutID` tinyint(4) NOT NULL DEFAULT 0, `CharComponentTexLayoutHiResID` tinyint(4) NOT NULL DEFAULT 0, `DefaultClassID` tinyint(4) NOT NULL DEFAULT 0, `NeutralRaceID` tinyint(4) NOT NULL DEFAULT 0, `MaleModelFallbackRaceID` tinyint(4) NOT NULL DEFAULT 0, `MaleModelFallbackSex` tinyint(4) NOT NULL DEFAULT 0, `FemaleModelFallbackRaceID` tinyint(4) NOT NULL DEFAULT 0, `FemaleModelFallbackSex` tinyint(4) NOT NULL DEFAULT 0, `MaleTextureFallbackRaceID` tinyint(4) NOT NULL DEFAULT 0, `MaleTextureFallbackSex` tinyint(4) NOT NULL DEFAULT 0, `FemaleTextureFallbackRaceID` tinyint(4) NOT NULL DEFAULT 0, `FemaleTextureFallbackSex` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_races_locale` -- DROP TABLE IF EXISTS `chr_races_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_races_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `NameFemale_lang` text DEFAULT NULL, `NameLowercase_lang` text DEFAULT NULL, `NameFemaleLowercase_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_specialization` -- DROP TABLE IF EXISTS `chr_specialization`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_specialization` ( `Name` text DEFAULT NULL, `FemaleName` text DEFAULT NULL, `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ClassID` tinyint(4) NOT NULL DEFAULT 0, `OrderIndex` tinyint(4) NOT NULL DEFAULT 0, `PetTalentType` tinyint(4) NOT NULL DEFAULT 0, `Role` tinyint(4) NOT NULL DEFAULT 0, `Flags` int(10) unsigned NOT NULL DEFAULT 0, `SpellIconFileID` int(11) NOT NULL DEFAULT 0, `PrimaryStatPriority` tinyint(4) NOT NULL DEFAULT 0, `AnimReplacements` int(11) NOT NULL DEFAULT 0, `MasterySpellID1` int(11) NOT NULL DEFAULT 0, `MasterySpellID2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `chr_specialization_locale` -- DROP TABLE IF EXISTS `chr_specialization_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_specialization_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `FemaleName_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cinematic_camera` -- DROP TABLE IF EXISTS `cinematic_camera`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cinematic_camera` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `OriginX` float NOT NULL DEFAULT 0, `OriginY` float NOT NULL DEFAULT 0, `OriginZ` float NOT NULL DEFAULT 0, `SoundID` int(10) unsigned NOT NULL DEFAULT 0, `OriginFacing` float NOT NULL DEFAULT 0, `FileDataID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `cinematic_sequences` -- DROP TABLE IF EXISTS `cinematic_sequences`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cinematic_sequences` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SoundID` int(10) unsigned NOT NULL DEFAULT 0, `Camera1` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera2` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera3` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera4` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera5` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera6` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera7` smallint(5) unsigned NOT NULL DEFAULT 0, `Camera8` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `content_tuning` -- DROP TABLE IF EXISTS `content_tuning`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `content_tuning` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `MinLevel` int(11) NOT NULL DEFAULT 0, `MaxLevel` int(11) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `ExpansionID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `content_tuning_x_expected` -- DROP TABLE IF EXISTS `content_tuning_x_expected`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `content_tuning_x_expected` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ExpectedStatModID` int(11) NOT NULL DEFAULT 0, `ContentTuningID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `conversation_line` -- DROP TABLE IF EXISTS `conversation_line`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversation_line` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `BroadcastTextID` int(10) unsigned NOT NULL DEFAULT 0, `SpellVisualKitID` int(10) unsigned NOT NULL DEFAULT 0, `AdditionalDuration` int(11) NOT NULL DEFAULT 0, `NextConversationLineID` smallint(5) unsigned NOT NULL DEFAULT 0, `AnimKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `SpeechType` tinyint(3) unsigned NOT NULL DEFAULT 0, `StartAnimation` tinyint(3) unsigned NOT NULL DEFAULT 0, `EndAnimation` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature` -- DROP TABLE IF EXISTS `creature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT 0, `ItemID1` mediumint(8) unsigned NOT NULL DEFAULT 0, `ItemID2` mediumint(8) unsigned NOT NULL DEFAULT 0, `ItemID3` mediumint(8) unsigned NOT NULL DEFAULT 0, `Mount` mediumint(8) unsigned NOT NULL DEFAULT 0, `DisplayID1` mediumint(8) unsigned NOT NULL DEFAULT 0, `DisplayID2` mediumint(8) unsigned NOT NULL DEFAULT 0, `DisplayID3` mediumint(8) unsigned NOT NULL DEFAULT 0, `DisplayID4` mediumint(8) unsigned NOT NULL DEFAULT 0, `DisplayIDProbability1` float NOT NULL DEFAULT 0, `DisplayIDProbability2` float NOT NULL DEFAULT 0, `DisplayIDProbability3` float NOT NULL DEFAULT 0, `DisplayIDProbability4` float NOT NULL DEFAULT 0, `Name` text NOT NULL, `FemaleName` text NOT NULL, `SubName` text NOT NULL, `FemaleSubName` text NOT NULL, `Type` mediumint(3) unsigned NOT NULL DEFAULT 0, `Family` tinyint(3) unsigned NOT NULL DEFAULT 0, `Classification` tinyint(3) unsigned NOT NULL DEFAULT 0, `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(5) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_difficulty` -- DROP TABLE IF EXISTS `creature_difficulty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_difficulty` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT 0, `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT 0, `Flags1` int(10) unsigned NOT NULL DEFAULT 0, `Flags2` int(10) unsigned NOT NULL DEFAULT 0, `Flags3` int(10) unsigned NOT NULL DEFAULT 0, `Flags4` int(10) unsigned NOT NULL DEFAULT 0, `Flags5` int(10) unsigned NOT NULL DEFAULT 0, `Flags6` int(10) unsigned NOT NULL DEFAULT 0, `Flags7` int(10) unsigned NOT NULL DEFAULT 0, `FactionTemplateID` smallint(5) unsigned NOT NULL DEFAULT 0, `Expansion` tinyint(4) NOT NULL DEFAULT 0, `MinLevel` tinyint(4) NOT NULL DEFAULT 0, `MaxLevel` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(5) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_display_info` -- DROP TABLE IF EXISTS `creature_display_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_display_info` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ModelID` smallint(5) unsigned NOT NULL DEFAULT 0, `SoundID` smallint(5) unsigned NOT NULL DEFAULT 0, `SizeClass` tinyint(4) NOT NULL DEFAULT 0, `CreatureModelScale` float NOT NULL DEFAULT 0, `CreatureModelAlpha` tinyint(3) unsigned NOT NULL DEFAULT 0, `BloodID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ExtendedDisplayInfoID` int(11) NOT NULL DEFAULT 0, `NPCSoundID` smallint(5) unsigned NOT NULL DEFAULT 0, `ParticleColorID` smallint(5) unsigned NOT NULL DEFAULT 0, `PortraitCreatureDisplayInfoID` int(11) NOT NULL DEFAULT 0, `PortraitTextureFileDataID` int(11) NOT NULL DEFAULT 0, `ObjectEffectPackageID` smallint(5) unsigned NOT NULL DEFAULT 0, `AnimReplacementSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `StateSpellVisualKitID` int(11) NOT NULL DEFAULT 0, `PlayerOverrideScale` float NOT NULL DEFAULT 0, `PetInstanceScale` float NOT NULL DEFAULT 0, `UnarmedWeaponType` tinyint(4) NOT NULL DEFAULT 0, `MountPoofSpellVisualKitID` int(11) NOT NULL DEFAULT 0, `DissolveEffectID` int(11) NOT NULL DEFAULT 0, `Gender` tinyint(4) NOT NULL DEFAULT 0, `DissolveOutEffectID` int(11) NOT NULL DEFAULT 0, `CreatureModelMinLod` tinyint(4) NOT NULL DEFAULT 0, `TextureVariationFileDataID1` int(11) NOT NULL DEFAULT 0, `TextureVariationFileDataID2` int(11) NOT NULL DEFAULT 0, `TextureVariationFileDataID3` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_display_info_extra` -- DROP TABLE IF EXISTS `creature_display_info_extra`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_display_info_extra` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DisplayRaceID` tinyint(4) NOT NULL DEFAULT 0, `DisplaySexID` tinyint(4) NOT NULL DEFAULT 0, `DisplayClassID` tinyint(4) NOT NULL DEFAULT 0, `SkinID` tinyint(4) NOT NULL DEFAULT 0, `FaceID` tinyint(4) NOT NULL DEFAULT 0, `HairStyleID` tinyint(4) NOT NULL DEFAULT 0, `HairColorID` tinyint(4) NOT NULL DEFAULT 0, `FacialHairID` tinyint(4) NOT NULL DEFAULT 0, `Flags` tinyint(4) NOT NULL DEFAULT 0, `BakeMaterialResourcesID` int(11) NOT NULL DEFAULT 0, `HDBakeMaterialResourcesID` int(11) NOT NULL DEFAULT 0, `CustomDisplayOption1` tinyint(3) unsigned NOT NULL DEFAULT 0, `CustomDisplayOption2` tinyint(3) unsigned NOT NULL DEFAULT 0, `CustomDisplayOption3` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_family` -- DROP TABLE IF EXISTS `creature_family`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_family` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `MinScale` float NOT NULL DEFAULT 0, `MinScaleLevel` tinyint(4) NOT NULL DEFAULT 0, `MaxScale` float NOT NULL DEFAULT 0, `MaxScaleLevel` tinyint(4) NOT NULL DEFAULT 0, `PetFoodMask` smallint(6) NOT NULL DEFAULT 0, `PetTalentType` tinyint(4) NOT NULL DEFAULT 0, `IconFileID` int(11) NOT NULL DEFAULT 0, `SkillLine1` smallint(6) NOT NULL DEFAULT 0, `SkillLine2` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_family_locale` -- DROP TABLE IF EXISTS `creature_family_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_family_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_model_data` -- DROP TABLE IF EXISTS `creature_model_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_model_data` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `GeoBox1` float NOT NULL DEFAULT 0, `GeoBox2` float NOT NULL DEFAULT 0, `GeoBox3` float NOT NULL DEFAULT 0, `GeoBox4` float NOT NULL DEFAULT 0, `GeoBox5` float NOT NULL DEFAULT 0, `GeoBox6` float NOT NULL DEFAULT 0, `Flags` int(10) unsigned NOT NULL DEFAULT 0, `FileDataID` int(10) unsigned NOT NULL DEFAULT 0, `BloodID` int(10) unsigned NOT NULL DEFAULT 0, `FootprintTextureID` int(10) unsigned NOT NULL DEFAULT 0, `FootprintTextureLength` float NOT NULL DEFAULT 0, `FootprintTextureWidth` float NOT NULL DEFAULT 0, `FootprintParticleScale` float NOT NULL DEFAULT 0, `FoleyMaterialID` int(10) unsigned NOT NULL DEFAULT 0, `FootstepCameraEffectID` int(10) unsigned NOT NULL DEFAULT 0, `DeathThudCameraEffectID` int(10) unsigned NOT NULL DEFAULT 0, `SoundID` int(10) unsigned NOT NULL DEFAULT 0, `SizeClass` int(10) unsigned NOT NULL DEFAULT 0, `CollisionWidth` float NOT NULL DEFAULT 0, `CollisionHeight` float NOT NULL DEFAULT 0, `WorldEffectScale` float NOT NULL DEFAULT 0, `CreatureGeosetDataID` int(10) unsigned NOT NULL DEFAULT 0, `HoverHeight` float NOT NULL DEFAULT 0, `AttachedEffectScale` float NOT NULL DEFAULT 0, `ModelScale` float NOT NULL DEFAULT 0, `MissileCollisionRadius` float NOT NULL DEFAULT 0, `MissileCollisionPush` float NOT NULL DEFAULT 0, `MissileCollisionRaise` float NOT NULL DEFAULT 0, `MountHeight` float NOT NULL DEFAULT 0, `OverrideLootEffectScale` float NOT NULL DEFAULT 0, `OverrideNameScale` float NOT NULL DEFAULT 0, `OverrideSelectionRadius` float NOT NULL DEFAULT 0, `TamedPetBaseScale` float NOT NULL DEFAULT 0, `Unknown820_1` tinyint(4) 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` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_type` -- DROP TABLE IF EXISTS `creature_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_type` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_type_locale` -- DROP TABLE IF EXISTS `creature_type_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_type_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `criteria` -- DROP TABLE IF EXISTS `criteria`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `criteria` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Type` smallint(6) NOT NULL DEFAULT 0, `Asset` int(10) NOT NULL DEFAULT 0, `ModifierTreeId` int(10) unsigned NOT NULL DEFAULT 0, `StartEvent` tinyint(3) unsigned NOT NULL DEFAULT 0, `StartAsset` int(11) NOT NULL DEFAULT 0, `StartTimer` smallint(5) unsigned NOT NULL DEFAULT 0, `FailEvent` tinyint(3) unsigned NOT NULL DEFAULT 0, `FailAsset` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `EligibilityWorldStateID` smallint(6) NOT NULL DEFAULT 0, `EligibilityWorldStateValue` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `criteria_tree` -- DROP TABLE IF EXISTS `criteria_tree`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `criteria_tree` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Description` text DEFAULT NULL, `Parent` int(10) unsigned NOT NULL DEFAULT 0, `Amount` int(10) unsigned NOT NULL DEFAULT 0, `Operator` tinyint(4) NOT NULL DEFAULT 0, `CriteriaID` int(10) unsigned NOT NULL DEFAULT 0, `OrderIndex` int(11) NOT NULL DEFAULT 0, `Flags` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `criteria_tree_locale` -- DROP TABLE IF EXISTS `criteria_tree_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `criteria_tree_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `currency_types` -- DROP TABLE IF EXISTS `currency_types`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `currency_types` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Description` text DEFAULT NULL, `CategoryID` tinyint(3) unsigned NOT NULL DEFAULT 0, `InventoryIconFileID` int(11) NOT NULL DEFAULT 0, `SpellWeight` int(10) unsigned NOT NULL DEFAULT 0, `SpellCategory` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxQty` int(10) unsigned NOT NULL DEFAULT 0, `MaxEarnablePerWeek` int(10) unsigned NOT NULL DEFAULT 0, `Flags` int(10) unsigned NOT NULL DEFAULT 0, `Quality` tinyint(4) NOT NULL DEFAULT 0, `FactionID` int(11) NOT NULL DEFAULT 0, `ItemGroupSoundsID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `currency_types_locale` -- DROP TABLE IF EXISTS `currency_types_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `currency_types_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `curve` -- DROP TABLE IF EXISTS `curve`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `curve` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Type` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `curve_point` -- DROP TABLE IF EXISTS `curve_point`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `curve_point` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PosX` float NOT NULL DEFAULT 0, `PosY` float NOT NULL DEFAULT 0, `CurveID` smallint(5) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `destructible_model_data` -- DROP TABLE IF EXISTS `destructible_model_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `destructible_model_data` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `State0ImpactEffectDoodadSet` tinyint(4) NOT NULL DEFAULT 0, `State0AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `State1Wmo` smallint(5) unsigned NOT NULL DEFAULT 0, `State1DestructionDoodadSet` tinyint(4) NOT NULL DEFAULT 0, `State1ImpactEffectDoodadSet` tinyint(4) NOT NULL DEFAULT 0, `State1AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `State2Wmo` smallint(5) unsigned NOT NULL DEFAULT 0, `State2DestructionDoodadSet` tinyint(4) NOT NULL DEFAULT 0, `State2ImpactEffectDoodadSet` tinyint(4) NOT NULL DEFAULT 0, `State2AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `State3Wmo` smallint(5) unsigned NOT NULL DEFAULT 0, `State3InitDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `State3AmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `EjectDirection` tinyint(3) unsigned NOT NULL DEFAULT 0, `DoNotHighlight` tinyint(3) unsigned NOT NULL DEFAULT 0, `State0Wmo` smallint(5) unsigned NOT NULL DEFAULT 0, `HealEffect` tinyint(3) unsigned NOT NULL DEFAULT 0, `HealEffectSpeed` smallint(5) unsigned NOT NULL DEFAULT 0, `State0NameSet` tinyint(4) NOT NULL DEFAULT 0, `State1NameSet` tinyint(4) NOT NULL DEFAULT 0, `State2NameSet` tinyint(4) NOT NULL DEFAULT 0, `State3NameSet` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `difficulty` -- DROP TABLE IF EXISTS `difficulty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `difficulty` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `InstanceType` tinyint(3) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `OldEnumValue` tinyint(4) NOT NULL DEFAULT 0, `FallbackDifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinPlayers` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemContext` tinyint(3) unsigned NOT NULL DEFAULT 0, `ToggleDifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `GroupSizeHealthCurveID` smallint(5) unsigned NOT NULL DEFAULT 0, `GroupSizeDmgCurveID` smallint(5) unsigned NOT NULL DEFAULT 0, `GroupSizeSpellPointsCurveID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `difficulty_locale` -- DROP TABLE IF EXISTS `difficulty_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `difficulty_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dungeon_encounter` -- DROP TABLE IF EXISTS `dungeon_encounter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dungeon_encounter` ( `Name` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `MapID` smallint(6) NOT NULL DEFAULT 0, `DifficultyID` tinyint(4) NOT NULL DEFAULT 0, `OrderIndex` int(11) NOT NULL DEFAULT 0, `CompleteWorldStateID` int(11) NOT NULL DEFAULT 0, `Bit` tinyint(4) NOT NULL DEFAULT 0, `CreatureDisplayID` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellIconFileID` int(11) NOT NULL DEFAULT 0, `Faction` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `dungeon_encounter_locale` -- DROP TABLE IF EXISTS `dungeon_encounter_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dungeon_encounter_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `durability_costs` -- DROP TABLE IF EXISTS `durability_costs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `durability_costs` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost1` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost2` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost3` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost4` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost5` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost6` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost7` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost8` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost9` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost10` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost11` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost12` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost13` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost14` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost15` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost16` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost17` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost18` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost19` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost20` smallint(5) unsigned NOT NULL DEFAULT 0, `WeaponSubClassCost21` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost1` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost2` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost3` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost4` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost5` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost6` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost7` smallint(5) unsigned NOT NULL DEFAULT 0, `ArmorSubClassCost8` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `durability_quality` -- DROP TABLE IF EXISTS `durability_quality`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `durability_quality` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Data` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `emotes` -- DROP TABLE IF EXISTS `emotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emotes` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RaceMask` bigint(20) NOT NULL DEFAULT 0, `EmoteSlashCommand` text DEFAULT NULL, `AnimID` int(11) NOT NULL DEFAULT 0, `EmoteFlags` int(10) unsigned NOT NULL DEFAULT 0, `EmoteSpecProc` tinyint(3) unsigned NOT NULL DEFAULT 0, `EmoteSpecProcParam` int(10) unsigned NOT NULL DEFAULT 0, `EventSoundID` int(10) unsigned NOT NULL DEFAULT 0, `SpellVisualKitID` int(10) unsigned NOT NULL DEFAULT 0, `ClassMask` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `emotes_text` -- DROP TABLE IF EXISTS `emotes_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emotes_text` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `EmoteID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `emotes_text_sound` -- DROP TABLE IF EXISTS `emotes_text_sound`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emotes_text_sound` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RaceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ClassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SexID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SoundID` int(10) unsigned NOT NULL DEFAULT 0, `EmotesTextID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `expected_stat` -- DROP TABLE IF EXISTS `expected_stat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expected_stat` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ExpansionID` int(11) NOT NULL DEFAULT 0, `CreatureHealth` float NOT NULL DEFAULT 0, `PlayerHealth` float NOT NULL DEFAULT 0, `CreatureAutoAttackDps` float NOT NULL DEFAULT 0, `CreatureArmor` float NOT NULL DEFAULT 0, `PlayerMana` float NOT NULL DEFAULT 0, `PlayerPrimaryStat` float NOT NULL DEFAULT 0, `PlayerSecondaryStat` float NOT NULL DEFAULT 0, `ArmorConstant` float NOT NULL DEFAULT 0, `CreatureSpellDamage` float NOT NULL DEFAULT 0, `Lvl` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `expected_stat_mod` -- DROP TABLE IF EXISTS `expected_stat_mod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `expected_stat_mod` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `CreatureHealthMod` float NOT NULL DEFAULT 0, `PlayerHealthMod` float NOT NULL DEFAULT 0, `CreatureAutoAttackDPSMod` float NOT NULL DEFAULT 0, `CreatureArmorMod` float NOT NULL DEFAULT 0, `PlayerManaMod` float NOT NULL DEFAULT 0, `PlayerPrimaryStatMod` float NOT NULL DEFAULT 0, `PlayerSecondaryStatMod` float NOT NULL DEFAULT 0, `ArmorConstantMod` float NOT NULL DEFAULT 0, `CreatureSpellDamageMod` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `faction` -- DROP TABLE IF EXISTS `faction`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faction` ( `ReputationRaceMask1` bigint(20) NOT NULL DEFAULT 0, `ReputationRaceMask2` bigint(20) NOT NULL DEFAULT 0, `ReputationRaceMask3` bigint(20) NOT NULL DEFAULT 0, `ReputationRaceMask4` bigint(20) NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ReputationIndex` smallint(6) NOT NULL DEFAULT 0, `ParentFactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `Expansion` tinyint(3) unsigned NOT NULL DEFAULT 0, `FriendshipRepID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ParagonFactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `ReputationClassMask1` smallint(6) NOT NULL DEFAULT 0, `ReputationClassMask2` smallint(6) NOT NULL DEFAULT 0, `ReputationClassMask3` smallint(6) NOT NULL DEFAULT 0, `ReputationClassMask4` smallint(6) NOT NULL DEFAULT 0, `ReputationFlags1` smallint(5) unsigned NOT NULL DEFAULT 0, `ReputationFlags2` smallint(5) unsigned NOT NULL DEFAULT 0, `ReputationFlags3` smallint(5) unsigned NOT NULL DEFAULT 0, `ReputationFlags4` smallint(5) unsigned NOT NULL DEFAULT 0, `ReputationBase1` int(11) NOT NULL DEFAULT 0, `ReputationBase2` int(11) NOT NULL DEFAULT 0, `ReputationBase3` int(11) NOT NULL DEFAULT 0, `ReputationBase4` int(11) NOT NULL DEFAULT 0, `ReputationMax1` int(11) NOT NULL DEFAULT 0, `ReputationMax2` int(11) NOT NULL DEFAULT 0, `ReputationMax3` int(11) NOT NULL DEFAULT 0, `ReputationMax4` int(11) NOT NULL DEFAULT 0, `ParentFactionMod1` float NOT NULL DEFAULT 0, `ParentFactionMod2` float NOT NULL DEFAULT 0, `ParentFactionCap1` tinyint(3) unsigned NOT NULL DEFAULT 0, `ParentFactionCap2` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `faction_locale` -- DROP TABLE IF EXISTS `faction_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faction_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `faction_template` -- DROP TABLE IF EXISTS `faction_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `faction_template` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Faction` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `FactionGroup` tinyint(3) unsigned NOT NULL DEFAULT 0, `FriendGroup` tinyint(3) unsigned NOT NULL DEFAULT 0, `EnemyGroup` tinyint(3) unsigned NOT NULL DEFAULT 0, `Enemies1` smallint(5) unsigned NOT NULL DEFAULT 0, `Enemies2` smallint(5) unsigned NOT NULL DEFAULT 0, `Enemies3` smallint(5) unsigned NOT NULL DEFAULT 0, `Enemies4` smallint(5) unsigned NOT NULL DEFAULT 0, `Friend1` smallint(5) unsigned NOT NULL DEFAULT 0, `Friend2` smallint(5) unsigned NOT NULL DEFAULT 0, `Friend3` smallint(5) unsigned NOT NULL DEFAULT 0, `Friend4` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobject_display_info` -- DROP TABLE IF EXISTS `gameobject_display_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject_display_info` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `GeoBoxMinX` float NOT NULL DEFAULT 0, `GeoBoxMinY` float NOT NULL DEFAULT 0, `GeoBoxMinZ` float NOT NULL DEFAULT 0, `GeoBoxMaxX` float NOT NULL DEFAULT 0, `GeoBoxMaxY` float NOT NULL DEFAULT 0, `GeoBoxMaxZ` float NOT NULL DEFAULT 0, `FileDataID` int(11) NOT NULL DEFAULT 0, `ObjectEffectPackageID` smallint(6) NOT NULL DEFAULT 0, `OverrideLootEffectScale` float NOT NULL DEFAULT 0, `OverrideNameScale` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobjects` -- DROP TABLE IF EXISTS `gameobjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobjects` ( `Name` text DEFAULT NULL, `PosX` float NOT NULL DEFAULT 0, `PosY` float NOT NULL DEFAULT 0, `PosZ` float NOT NULL DEFAULT 0, `Rot1` float NOT NULL DEFAULT 0, `Rot2` float NOT NULL DEFAULT 0, `Rot3` float NOT NULL DEFAULT 0, `Rot4` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `OwnerID` smallint(5) unsigned NOT NULL DEFAULT 0, `DisplayID` smallint(5) unsigned NOT NULL DEFAULT 0, `Scale` float NOT NULL DEFAULT 0, `TypeID` tinyint(3) unsigned NOT NULL DEFAULT 0, `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, `PhaseID` smallint(5) unsigned NOT NULL DEFAULT 0, `PhaseGroupID` smallint(5) unsigned NOT NULL DEFAULT 0, `PropValue1` int(11) NOT NULL DEFAULT 0, `PropValue2` int(11) NOT NULL DEFAULT 0, `PropValue3` int(11) NOT NULL DEFAULT 0, `PropValue4` int(11) NOT NULL DEFAULT 0, `PropValue5` int(11) NOT NULL DEFAULT 0, `PropValue6` int(11) NOT NULL DEFAULT 0, `PropValue7` int(11) NOT NULL DEFAULT 0, `PropValue8` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobjects_locale` -- DROP TABLE IF EXISTS `gameobjects_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobjects_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_ability` -- DROP TABLE IF EXISTS `garr_ability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_ability` ( `Name` text DEFAULT NULL, `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `GarrAbilityCategoryID` tinyint(3) unsigned NOT NULL DEFAULT 0, `GarrFollowerTypeID` tinyint(3) unsigned NOT NULL DEFAULT 0, `IconFileDataID` int(11) NOT NULL DEFAULT 0, `FactionChangeGarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_ability_locale` -- DROP TABLE IF EXISTS `garr_ability_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_ability_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_building` -- DROP TABLE IF EXISTS `garr_building`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_building` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `HordeName` text DEFAULT NULL, `AllianceName` text DEFAULT NULL, `Description` text DEFAULT NULL, `Tooltip` text DEFAULT NULL, `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT 0, `BuildingType` tinyint(3) unsigned NOT NULL DEFAULT 0, `HordeGameObjectID` int(11) NOT NULL DEFAULT 0, `AllianceGameObjectID` int(11) NOT NULL DEFAULT 0, `GarrSiteID` tinyint(3) unsigned NOT NULL DEFAULT 0, `UpgradeLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `BuildSeconds` int(11) NOT NULL DEFAULT 0, `CurrencyTypeID` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyQty` int(11) NOT NULL DEFAULT 0, `HordeUiTextureKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `AllianceUiTextureKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `IconFileDataID` int(11) NOT NULL DEFAULT 0, `AllianceSceneScriptPackageID` smallint(5) unsigned NOT NULL DEFAULT 0, `HordeSceneScriptPackageID` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxAssignments` int(11) NOT NULL DEFAULT 0, `ShipmentCapacity` tinyint(3) unsigned NOT NULL DEFAULT 0, `GarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT 0, `BonusGarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT 0, `GoldCost` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_building_locale` -- DROP TABLE IF EXISTS `garr_building_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_building_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `HordeName_lang` text DEFAULT NULL, `AllianceName_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `Tooltip_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_building_plot_inst` -- DROP TABLE IF EXISTS `garr_building_plot_inst`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_building_plot_inst` ( `MapOffsetX` float NOT NULL DEFAULT 0, `MapOffsetY` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `GarrBuildingID` tinyint(3) unsigned NOT NULL DEFAULT 0, `GarrSiteLevelPlotInstID` smallint(5) unsigned NOT NULL DEFAULT 0, `UiTextureAtlasMemberID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_class_spec` -- DROP TABLE IF EXISTS `garr_class_spec`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_class_spec` ( `ClassSpec` text DEFAULT NULL, `ClassSpecMale` text DEFAULT NULL, `ClassSpecFemale` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `UiTextureAtlasMemberID` smallint(5) unsigned NOT NULL DEFAULT 0, `GarrFollItemSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `FollowerClassLimit` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_class_spec_locale` -- DROP TABLE IF EXISTS `garr_class_spec_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_class_spec_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `ClassSpec_lang` text DEFAULT NULL, `ClassSpecMale_lang` text DEFAULT NULL, `ClassSpecFemale_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_follower` -- DROP TABLE IF EXISTS `garr_follower`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_follower` ( `HordeSourceText` text DEFAULT NULL, `AllianceSourceText` text DEFAULT NULL, `TitleName` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT 0, `GarrFollowerTypeID` tinyint(3) unsigned NOT NULL DEFAULT 0, `HordeCreatureID` int(11) NOT NULL DEFAULT 0, `AllianceCreatureID` int(11) NOT NULL DEFAULT 0, `HordeGarrFollRaceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `AllianceGarrFollRaceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `HordeGarrClassSpecID` int(11) NOT NULL DEFAULT 0, `AllianceGarrClassSpecID` int(11) NOT NULL DEFAULT 0, `Quality` tinyint(3) unsigned NOT NULL DEFAULT 0, `FollowerLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemLevelWeapon` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemLevelArmor` smallint(5) unsigned NOT NULL DEFAULT 0, `HordeSourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `AllianceSourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `HordeIconFileDataID` int(11) NOT NULL DEFAULT 0, `AllianceIconFileDataID` int(11) NOT NULL DEFAULT 0, `HordeGarrFollItemSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `AllianceGarrFollItemSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `HordeUITextureKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `AllianceUITextureKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `Vitality` tinyint(3) unsigned NOT NULL DEFAULT 0, `HordeFlavorGarrStringID` tinyint(3) unsigned NOT NULL DEFAULT 0, `AllianceFlavorGarrStringID` tinyint(3) unsigned NOT NULL DEFAULT 0, `HordeSlottingBroadcastTextID` int(10) unsigned NOT NULL DEFAULT 0, `AllySlottingBroadcastTextID` int(10) unsigned NOT NULL DEFAULT 0, `ChrClassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `Gender` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_follower_locale` -- DROP TABLE IF EXISTS `garr_follower_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_follower_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `HordeSourceText_lang` text DEFAULT NULL, `AllianceSourceText_lang` text DEFAULT NULL, `TitleName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_follower_x_ability` -- DROP TABLE IF EXISTS `garr_follower_x_ability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_follower_x_ability` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `FactionIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `GarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT 0, `GarrFollowerID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_plot` -- DROP TABLE IF EXISTS `garr_plot`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_plot` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `PlotType` tinyint(3) unsigned NOT NULL DEFAULT 0, `HordeConstructObjID` int(11) NOT NULL DEFAULT 0, `AllianceConstructObjID` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiCategoryID` tinyint(3) unsigned NOT NULL DEFAULT 0, `UpgradeRequirement1` int(10) unsigned NOT NULL DEFAULT 0, `UpgradeRequirement2` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_plot_building` -- DROP TABLE IF EXISTS `garr_plot_building`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_plot_building` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `GarrPlotID` tinyint(3) unsigned NOT NULL DEFAULT 0, `GarrBuildingID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_plot_instance` -- DROP TABLE IF EXISTS `garr_plot_instance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_plot_instance` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `GarrPlotID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_site_level` -- DROP TABLE IF EXISTS `garr_site_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_site_level` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `TownHallUiPosX` float NOT NULL DEFAULT 0, `TownHallUiPosY` float NOT NULL DEFAULT 0, `GarrSiteID` int(10) unsigned NOT NULL DEFAULT 0, `GarrLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MapID` smallint(5) unsigned NOT NULL DEFAULT 0, `UpgradeMovieID` smallint(5) unsigned NOT NULL DEFAULT 0, `UiTextureKitID` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxBuildingLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `UpgradeCost` smallint(5) unsigned NOT NULL DEFAULT 0, `UpgradeGoldCost` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `garr_site_level_plot_inst` -- DROP TABLE IF EXISTS `garr_site_level_plot_inst`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_site_level_plot_inst` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `UiMarkerPosX` float NOT NULL DEFAULT 0, `UiMarkerPosY` float NOT NULL DEFAULT 0, `GarrSiteLevelID` smallint(5) unsigned NOT NULL DEFAULT 0, `GarrPlotInstanceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiMarkerSize` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gem_properties` -- DROP TABLE IF EXISTS `gem_properties`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gem_properties` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `EnchantId` smallint(5) unsigned NOT NULL DEFAULT 0, `Type` int(11) NOT NULL DEFAULT 0, `MinItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `glyph_bindable_spell` -- DROP TABLE IF EXISTS `glyph_bindable_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `glyph_bindable_spell` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `GlyphPropertiesID` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `glyph_properties` -- DROP TABLE IF EXISTS `glyph_properties`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `glyph_properties` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(10) unsigned NOT NULL DEFAULT 0, `GlyphType` tinyint(3) unsigned NOT NULL DEFAULT 0, `GlyphExclusiveCategoryID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellIconFileDataID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `glyph_required_spec` -- DROP TABLE IF EXISTS `glyph_required_spec`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `glyph_required_spec` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ChrSpecializationID` smallint(5) unsigned NOT NULL DEFAULT 0, `GlyphPropertiesID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `guild_color_background` -- DROP TABLE IF EXISTS `guild_color_background`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_color_background` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Red` tinyint(3) unsigned NOT NULL DEFAULT 0, `Blue` tinyint(3) unsigned NOT NULL DEFAULT 0, `Green` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `guild_color_border` -- DROP TABLE IF EXISTS `guild_color_border`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_color_border` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Red` tinyint(3) unsigned NOT NULL DEFAULT 0, `Blue` tinyint(3) unsigned NOT NULL DEFAULT 0, `Green` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `guild_color_emblem` -- DROP TABLE IF EXISTS `guild_color_emblem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_color_emblem` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Red` tinyint(3) unsigned NOT NULL DEFAULT 0, `Blue` tinyint(3) unsigned NOT NULL DEFAULT 0, `Green` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `guild_perk_spells` -- DROP TABLE IF EXISTS `guild_perk_spells`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_perk_spells` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `heirloom` -- DROP TABLE IF EXISTS `heirloom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `heirloom` ( `SourceText` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `LegacyUpgradedItemID` int(11) NOT NULL DEFAULT 0, `StaticUpgradedItemID` int(11) NOT NULL DEFAULT 0, `SourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `LegacyItemID` int(11) NOT NULL DEFAULT 0, `UpgradeItemID1` int(11) NOT NULL DEFAULT 0, `UpgradeItemID2` int(11) NOT NULL DEFAULT 0, `UpgradeItemID3` int(11) NOT NULL DEFAULT 0, `UpgradeItemID4` int(11) NOT NULL DEFAULT 0, `UpgradeItemBonusListID1` smallint(5) unsigned NOT NULL DEFAULT 0, `UpgradeItemBonusListID2` smallint(5) unsigned NOT NULL DEFAULT 0, `UpgradeItemBonusListID3` smallint(5) unsigned NOT NULL DEFAULT 0, `UpgradeItemBonusListID4` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `heirloom_locale` -- DROP TABLE IF EXISTS `heirloom_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `heirloom_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `SourceText_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `holidays` -- DROP TABLE IF EXISTS `holidays`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `holidays` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Region` smallint(5) unsigned NOT NULL DEFAULT 0, `Looping` tinyint(3) unsigned NOT NULL DEFAULT 0, `HolidayNameID` int(10) unsigned NOT NULL DEFAULT 0, `HolidayDescriptionID` int(10) unsigned NOT NULL DEFAULT 0, `Priority` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFilterType` tinyint(4) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `Duration1` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration2` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration3` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration4` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration5` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration6` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration7` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration8` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration9` smallint(5) unsigned NOT NULL DEFAULT 0, `Duration10` smallint(5) unsigned NOT NULL DEFAULT 0, `Date1` int(10) unsigned NOT NULL DEFAULT 0, `Date2` int(10) unsigned NOT NULL DEFAULT 0, `Date3` int(10) unsigned NOT NULL DEFAULT 0, `Date4` int(10) unsigned NOT NULL DEFAULT 0, `Date5` int(10) unsigned NOT NULL DEFAULT 0, `Date6` int(10) unsigned NOT NULL DEFAULT 0, `Date7` int(10) unsigned NOT NULL DEFAULT 0, `Date8` int(10) unsigned NOT NULL DEFAULT 0, `Date9` int(10) unsigned NOT NULL DEFAULT 0, `Date10` int(10) unsigned NOT NULL DEFAULT 0, `Date11` int(10) unsigned NOT NULL DEFAULT 0, `Date12` int(10) unsigned NOT NULL DEFAULT 0, `Date13` int(10) unsigned NOT NULL DEFAULT 0, `Date14` int(10) unsigned NOT NULL DEFAULT 0, `Date15` int(10) unsigned NOT NULL DEFAULT 0, `Date16` int(10) unsigned NOT NULL DEFAULT 0, `Date17` int(10) unsigned NOT NULL DEFAULT 0, `Date18` int(10) unsigned NOT NULL DEFAULT 0, `Date19` int(10) unsigned NOT NULL DEFAULT 0, `Date20` int(10) unsigned NOT NULL DEFAULT 0, `Date21` int(10) unsigned NOT NULL DEFAULT 0, `Date22` int(10) unsigned NOT NULL DEFAULT 0, `Date23` int(10) unsigned NOT NULL DEFAULT 0, `Date24` int(10) unsigned NOT NULL DEFAULT 0, `Date25` int(10) unsigned NOT NULL DEFAULT 0, `Date26` int(10) unsigned NOT NULL DEFAULT 0, `CalendarFlags1` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags2` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags3` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags4` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags5` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags6` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags7` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags8` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags9` tinyint(3) unsigned NOT NULL DEFAULT 0, `CalendarFlags10` tinyint(3) unsigned NOT NULL DEFAULT 0, `TextureFileDataID1` int(11) NOT NULL DEFAULT 0, `TextureFileDataID2` int(11) NOT NULL DEFAULT 0, `TextureFileDataID3` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hotfix_blob` -- DROP TABLE IF EXISTS `hotfix_blob`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hotfix_blob` ( `TableHash` int(10) unsigned NOT NULL, `RecordId` int(11) NOT NULL, `Blob` blob DEFAULT NULL, PRIMARY KEY (`TableHash`,`RecordId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `hotfix_data` -- DROP TABLE IF EXISTS `hotfix_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `hotfix_data` ( `Id` int(11) NOT NULL, `TableHash` int(10) unsigned NOT NULL, `RecordId` int(11) NOT NULL, `Deleted` tinyint(3) unsigned DEFAULT 0, PRIMARY KEY (`Id`,`TableHash`,`RecordId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_price_armor` -- DROP TABLE IF EXISTS `import_price_armor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `import_price_armor` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ClothModifier` float NOT NULL DEFAULT 0, `LeatherModifier` float NOT NULL DEFAULT 0, `ChainModifier` float NOT NULL DEFAULT 0, `PlateModifier` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_price_quality` -- DROP TABLE IF EXISTS `import_price_quality`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `import_price_quality` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Data` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_price_shield` -- DROP TABLE IF EXISTS `import_price_shield`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `import_price_shield` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Data` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `import_price_weapon` -- DROP TABLE IF EXISTS `import_price_weapon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `import_price_weapon` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Data` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item` -- DROP TABLE IF EXISTS `item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ClassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SubclassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Material` tinyint(3) unsigned NOT NULL DEFAULT 0, `InventoryType` tinyint(4) NOT NULL DEFAULT 0, `SheatheType` tinyint(3) unsigned NOT NULL DEFAULT 0, `SoundOverrideSubclassID` tinyint(4) NOT NULL DEFAULT 0, `IconFileDataID` int(11) NOT NULL DEFAULT 0, `ItemGroupSoundsID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_appearance` -- DROP TABLE IF EXISTS `item_appearance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_appearance` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DisplayType` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemDisplayInfoID` int(11) NOT NULL DEFAULT 0, `DefaultIconFileDataID` int(11) NOT NULL DEFAULT 0, `UiOrder` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_armor_quality` -- DROP TABLE IF EXISTS `item_armor_quality`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_armor_quality` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Qualitymod1` float NOT NULL DEFAULT 0, `Qualitymod2` float NOT NULL DEFAULT 0, `Qualitymod3` float NOT NULL DEFAULT 0, `Qualitymod4` float NOT NULL DEFAULT 0, `Qualitymod5` float NOT NULL DEFAULT 0, `Qualitymod6` float NOT NULL DEFAULT 0, `Qualitymod7` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_armor_shield` -- DROP TABLE IF EXISTS `item_armor_shield`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_armor_shield` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Quality1` float NOT NULL DEFAULT 0, `Quality2` float NOT NULL DEFAULT 0, `Quality3` float NOT NULL DEFAULT 0, `Quality4` float NOT NULL DEFAULT 0, `Quality5` float NOT NULL DEFAULT 0, `Quality6` float NOT NULL DEFAULT 0, `Quality7` float NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_armor_total` -- DROP TABLE IF EXISTS `item_armor_total`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_armor_total` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(6) NOT NULL DEFAULT 0, `Cloth` float NOT NULL DEFAULT 0, `Leather` float NOT NULL DEFAULT 0, `Mail` float NOT NULL DEFAULT 0, `Plate` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_bag_family` -- DROP TABLE IF EXISTS `item_bag_family`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bag_family` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_bag_family_locale` -- DROP TABLE IF EXISTS `item_bag_family_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bag_family_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_bonus` -- DROP TABLE IF EXISTS `item_bonus`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bonus` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Value1` int(11) NOT NULL DEFAULT 0, `Value2` int(11) NOT NULL DEFAULT 0, `Value3` int(11) NOT NULL DEFAULT 0, `ParentItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT 0, `Type` tinyint(3) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_bonus_list_level_delta` -- DROP TABLE IF EXISTS `item_bonus_list_level_delta`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bonus_list_level_delta` ( `ItemLevelDelta` smallint(6) NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_bonus_tree_node` -- DROP TABLE IF EXISTS `item_bonus_tree_node`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bonus_tree_node` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemContext` tinyint(3) unsigned NOT NULL DEFAULT 0, `ChildItemBonusTreeID` smallint(5) unsigned NOT NULL DEFAULT 0, `ChildItemBonusListID` smallint(5) unsigned NOT NULL DEFAULT 0, `ChildItemLevelSelectorID` smallint(5) unsigned NOT NULL DEFAULT 0, `ParentItemBonusTreeID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_child_equipment` -- DROP TABLE IF EXISTS `item_child_equipment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_child_equipment` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ParentItemID` int(11) NOT NULL DEFAULT 0, `ChildItemID` int(11) NOT NULL DEFAULT 0, `ChildItemEquipSlot` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_class` -- DROP TABLE IF EXISTS `item_class`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_class` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ClassName` text DEFAULT NULL, `ClassID` tinyint(4) NOT NULL DEFAULT 0, `PriceModifier` float NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_class_locale` -- DROP TABLE IF EXISTS `item_class_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_class_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `ClassName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_currency_cost` -- DROP TABLE IF EXISTS `item_currency_cost`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_currency_cost` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_damage_ammo` -- DROP TABLE IF EXISTS `item_damage_ammo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_damage_ammo` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Quality1` float NOT NULL DEFAULT 0, `Quality2` float NOT NULL DEFAULT 0, `Quality3` float NOT NULL DEFAULT 0, `Quality4` float NOT NULL DEFAULT 0, `Quality5` float NOT NULL DEFAULT 0, `Quality6` float NOT NULL DEFAULT 0, `Quality7` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_damage_one_hand` -- DROP TABLE IF EXISTS `item_damage_one_hand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_damage_one_hand` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Quality1` float NOT NULL DEFAULT 0, `Quality2` float NOT NULL DEFAULT 0, `Quality3` float NOT NULL DEFAULT 0, `Quality4` float NOT NULL DEFAULT 0, `Quality5` float NOT NULL DEFAULT 0, `Quality6` float NOT NULL DEFAULT 0, `Quality7` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_damage_one_hand_caster` -- DROP TABLE IF EXISTS `item_damage_one_hand_caster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_damage_one_hand_caster` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Quality1` float NOT NULL DEFAULT 0, `Quality2` float NOT NULL DEFAULT 0, `Quality3` float NOT NULL DEFAULT 0, `Quality4` float NOT NULL DEFAULT 0, `Quality5` float NOT NULL DEFAULT 0, `Quality6` float NOT NULL DEFAULT 0, `Quality7` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_damage_two_hand` -- DROP TABLE IF EXISTS `item_damage_two_hand`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_damage_two_hand` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Quality1` float NOT NULL DEFAULT 0, `Quality2` float NOT NULL DEFAULT 0, `Quality3` float NOT NULL DEFAULT 0, `Quality4` float NOT NULL DEFAULT 0, `Quality5` float NOT NULL DEFAULT 0, `Quality6` float NOT NULL DEFAULT 0, `Quality7` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_damage_two_hand_caster` -- DROP TABLE IF EXISTS `item_damage_two_hand_caster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_damage_two_hand_caster` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Quality1` float NOT NULL DEFAULT 0, `Quality2` float NOT NULL DEFAULT 0, `Quality3` float NOT NULL DEFAULT 0, `Quality4` float NOT NULL DEFAULT 0, `Quality5` float NOT NULL DEFAULT 0, `Quality6` float NOT NULL DEFAULT 0, `Quality7` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_disenchant_loot` -- DROP TABLE IF EXISTS `item_disenchant_loot`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_disenchant_loot` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Subclass` tinyint(4) NOT NULL DEFAULT 0, `Quality` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `SkillRequired` smallint(5) unsigned NOT NULL DEFAULT 0, `ExpansionID` tinyint(4) NOT NULL DEFAULT 0, `Class` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_effect` -- DROP TABLE IF EXISTS `item_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_effect` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `LegacySlotIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `TriggerType` tinyint(4) NOT NULL DEFAULT 0, `Charges` smallint(6) NOT NULL DEFAULT 0, `CoolDownMSec` int(11) NOT NULL DEFAULT 0, `CategoryCoolDownMSec` int(11) NOT NULL DEFAULT 0, `SpellCategoryID` smallint(5) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `ChrSpecializationID` smallint(5) unsigned NOT NULL DEFAULT 0, `ParentItemID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_extended_cost` -- DROP TABLE IF EXISTS `item_extended_cost`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_extended_cost` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RequiredArenaRating` smallint(5) unsigned NOT NULL DEFAULT 0, `ArenaBracket` tinyint(4) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinFactionID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinReputation` tinyint(3) unsigned NOT NULL DEFAULT 0, `RequiredAchievement` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemID1` int(11) NOT NULL DEFAULT 0, `ItemID2` int(11) NOT NULL DEFAULT 0, `ItemID3` int(11) NOT NULL DEFAULT 0, `ItemID4` int(11) NOT NULL DEFAULT 0, `ItemID5` int(11) NOT NULL DEFAULT 0, `ItemCount1` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemCount2` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemCount3` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemCount4` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemCount5` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyID1` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyID2` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyID3` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyID4` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyID5` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyCount1` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount2` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount3` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount4` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount5` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_level_selector` -- DROP TABLE IF EXISTS `item_level_selector`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_level_selector` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `MinItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemLevelSelectorQualitySetID` smallint(5) unsigned NOT NULL DEFAULT 0, `AzeriteUnlockMappingSet` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_level_selector_quality` -- DROP TABLE IF EXISTS `item_level_selector_quality`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_level_selector_quality` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `QualityItemBonusListID` int(11) NOT NULL DEFAULT 0, `Quality` tinyint(4) NOT NULL DEFAULT 0, `ParentILSQualitySetID` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_level_selector_quality_set` -- DROP TABLE IF EXISTS `item_level_selector_quality_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_level_selector_quality_set` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `IlvlRare` smallint(6) NOT NULL DEFAULT 0, `IlvlEpic` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_limit_category` -- DROP TABLE IF EXISTS `item_limit_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_limit_category` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Quantity` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_limit_category_condition` -- DROP TABLE IF EXISTS `item_limit_category_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_limit_category_condition` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `AddQuantity` tinyint(4) NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `ParentItemLimitCategoryID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_limit_category_locale` -- DROP TABLE IF EXISTS `item_limit_category_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_limit_category_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_modified_appearance` -- DROP TABLE IF EXISTS `item_modified_appearance`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_modified_appearance` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `ItemAppearanceModifierID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemAppearanceID` smallint(5) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `TransmogSourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_price_base` -- DROP TABLE IF EXISTS `item_price_base`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_price_base` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Armor` float NOT NULL DEFAULT 0, `Weapon` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_search_name` -- DROP TABLE IF EXISTS `item_search_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_search_name` ( `AllowableRace` bigint(20) NOT NULL DEFAULT 0, `Display` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `OverallQualityID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ExpansionID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinFactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `MinReputation` tinyint(3) unsigned NOT NULL DEFAULT 0, `AllowableClass` int(11) NOT NULL DEFAULT 0, `RequiredLevel` tinyint(4) NOT NULL DEFAULT 0, `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredAbility` int(10) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags1` int(11) NOT NULL DEFAULT 0, `Flags2` int(11) NOT NULL DEFAULT 0, `Flags3` int(11) NOT NULL DEFAULT 0, `Flags4` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_search_name_locale` -- DROP TABLE IF EXISTS `item_search_name_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_search_name_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Display_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_set` -- DROP TABLE IF EXISTS `item_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_set` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `SetFlags` int(10) unsigned NOT NULL DEFAULT 0, `RequiredSkill` int(10) unsigned NOT NULL DEFAULT 0, `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemID1` int(10) unsigned NOT NULL DEFAULT 0, `ItemID2` int(10) unsigned NOT NULL DEFAULT 0, `ItemID3` int(10) unsigned NOT NULL DEFAULT 0, `ItemID4` int(10) unsigned NOT NULL DEFAULT 0, `ItemID5` int(10) unsigned NOT NULL DEFAULT 0, `ItemID6` int(10) unsigned NOT NULL DEFAULT 0, `ItemID7` int(10) unsigned NOT NULL DEFAULT 0, `ItemID8` int(10) unsigned NOT NULL DEFAULT 0, `ItemID9` int(10) unsigned NOT NULL DEFAULT 0, `ItemID10` int(10) unsigned NOT NULL DEFAULT 0, `ItemID11` int(10) unsigned NOT NULL DEFAULT 0, `ItemID12` int(10) unsigned NOT NULL DEFAULT 0, `ItemID13` int(10) unsigned NOT NULL DEFAULT 0, `ItemID14` int(10) unsigned NOT NULL DEFAULT 0, `ItemID15` int(10) unsigned NOT NULL DEFAULT 0, `ItemID16` int(10) unsigned NOT NULL DEFAULT 0, `ItemID17` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_set_locale` -- DROP TABLE IF EXISTS `item_set_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_set_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_set_spell` -- DROP TABLE IF EXISTS `item_set_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_set_spell` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ChrSpecID` smallint(5) unsigned NOT NULL DEFAULT 0, `SpellID` int(10) unsigned NOT NULL DEFAULT 0, `Threshold` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_sparse` -- DROP TABLE IF EXISTS `item_sparse`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_sparse` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `AllowableRace` bigint(20) NOT NULL DEFAULT 0, `Description` text DEFAULT NULL, `Display3` text DEFAULT NULL, `Display2` text DEFAULT NULL, `Display1` text DEFAULT NULL, `Display` text DEFAULT NULL, `DmgVariance` float NOT NULL DEFAULT 0, `DurationInInventory` int(10) unsigned NOT NULL DEFAULT 0, `QualityModifier` float NOT NULL DEFAULT 0, `BagFamily` int(10) unsigned NOT NULL DEFAULT 0, `ItemRange` float NOT NULL DEFAULT 0, `StatPercentageOfSocket1` float NOT NULL DEFAULT 0, `StatPercentageOfSocket2` float NOT NULL DEFAULT 0, `StatPercentageOfSocket3` float NOT NULL DEFAULT 0, `StatPercentageOfSocket4` float NOT NULL DEFAULT 0, `StatPercentageOfSocket5` float NOT NULL DEFAULT 0, `StatPercentageOfSocket6` float NOT NULL DEFAULT 0, `StatPercentageOfSocket7` float NOT NULL DEFAULT 0, `StatPercentageOfSocket8` float NOT NULL DEFAULT 0, `StatPercentageOfSocket9` float NOT NULL DEFAULT 0, `StatPercentageOfSocket10` float NOT NULL DEFAULT 0, `StatPercentEditor1` int(11) NOT NULL DEFAULT 0, `StatPercentEditor2` int(11) NOT NULL DEFAULT 0, `StatPercentEditor3` int(11) NOT NULL DEFAULT 0, `StatPercentEditor4` int(11) NOT NULL DEFAULT 0, `StatPercentEditor5` int(11) NOT NULL DEFAULT 0, `StatPercentEditor6` int(11) NOT NULL DEFAULT 0, `StatPercentEditor7` int(11) NOT NULL DEFAULT 0, `StatPercentEditor8` int(11) NOT NULL DEFAULT 0, `StatPercentEditor9` int(11) NOT NULL DEFAULT 0, `StatPercentEditor10` int(11) NOT NULL DEFAULT 0, `Stackable` int(11) NOT NULL DEFAULT 0, `MaxCount` int(11) NOT NULL DEFAULT 0, `RequiredAbility` int(10) unsigned NOT NULL DEFAULT 0, `SellPrice` int(10) unsigned NOT NULL DEFAULT 0, `BuyPrice` int(10) unsigned NOT NULL DEFAULT 0, `VendorStackCount` int(10) unsigned NOT NULL DEFAULT 0, `PriceVariance` float NOT NULL DEFAULT 0, `PriceRandomValue` float NOT NULL DEFAULT 0, `Flags1` int(11) NOT NULL DEFAULT 0, `Flags2` int(11) NOT NULL DEFAULT 0, `Flags3` int(11) NOT NULL DEFAULT 0, `Flags4` int(11) NOT NULL DEFAULT 0, `FactionRelated` int(11) NOT NULL DEFAULT 0, `ItemNameDescriptionID` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredTransmogHoliday` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredHoliday` smallint(5) unsigned NOT NULL DEFAULT 0, `LimitCategory` smallint(5) unsigned NOT NULL DEFAULT 0, `GemProperties` smallint(5) unsigned NOT NULL DEFAULT 0, `SocketMatchEnchantmentId` smallint(5) unsigned NOT NULL DEFAULT 0, `TotemCategoryID` smallint(5) unsigned NOT NULL DEFAULT 0, `InstanceBound` smallint(5) unsigned NOT NULL DEFAULT 0, `ZoneBound` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemSet` smallint(5) unsigned NOT NULL DEFAULT 0, `LockID` smallint(5) unsigned NOT NULL DEFAULT 0, `StartQuestID` smallint(5) unsigned NOT NULL DEFAULT 0, `PageID` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemDelay` smallint(5) unsigned NOT NULL DEFAULT 0, `ScalingStatDistributionID` smallint(5) unsigned NOT NULL DEFAULT 0, `MinFactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `AllowableClass` smallint(6) NOT NULL DEFAULT 0, `ExpansionID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellWeight` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellWeightCategory` tinyint(3) unsigned NOT NULL DEFAULT 0, `SocketType1` tinyint(3) unsigned NOT NULL DEFAULT 0, `SocketType2` tinyint(3) unsigned NOT NULL DEFAULT 0, `SocketType3` tinyint(3) unsigned NOT NULL DEFAULT 0, `SheatheType` tinyint(3) unsigned NOT NULL DEFAULT 0, `Material` tinyint(3) unsigned NOT NULL DEFAULT 0, `PageMaterialID` tinyint(3) unsigned NOT NULL DEFAULT 0, `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Bonding` tinyint(3) unsigned NOT NULL DEFAULT 0, `DamageDamageType` tinyint(3) unsigned NOT NULL DEFAULT 0, `StatModifierBonusStat1` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat2` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat3` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat4` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat5` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat6` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat7` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat8` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat9` tinyint(4) NOT NULL DEFAULT 0, `StatModifierBonusStat10` tinyint(4) NOT NULL DEFAULT 0, `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinReputation` tinyint(3) unsigned NOT NULL DEFAULT 0, `RequiredPVPMedal` tinyint(3) unsigned NOT NULL DEFAULT 0, `RequiredPVPRank` tinyint(3) unsigned NOT NULL DEFAULT 0, `RequiredLevel` tinyint(4) NOT NULL DEFAULT 0, `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT 0, `OverallQualityID` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_sparse_locale` -- DROP TABLE IF EXISTS `item_sparse_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_sparse_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `Display3_lang` text DEFAULT NULL, `Display2_lang` text DEFAULT NULL, `Display1_lang` text DEFAULT NULL, `Display_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_spec` -- DROP TABLE IF EXISTS `item_spec`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_spec` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemType` tinyint(3) unsigned NOT NULL DEFAULT 0, `PrimaryStat` tinyint(3) unsigned NOT NULL DEFAULT 0, `SecondaryStat` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpecializationID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_spec_override` -- DROP TABLE IF EXISTS `item_spec_override`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_spec_override` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpecID` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_upgrade` -- DROP TABLE IF EXISTS `item_upgrade`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_upgrade` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemUpgradePathID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ItemLevelIncrement` tinyint(3) unsigned NOT NULL DEFAULT 0, `PrerequisiteID` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyType` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrencyAmount` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_x_bonus_tree` -- DROP TABLE IF EXISTS `item_x_bonus_tree`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_x_bonus_tree` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemBonusTreeID` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `keychain` -- DROP TABLE IF EXISTS `keychain`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `keychain` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Key1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key3` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key5` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key6` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key7` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key8` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key9` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key10` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key11` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key12` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key13` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key14` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key15` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key16` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key17` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key18` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key19` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key20` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key21` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key22` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key23` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key24` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key25` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key26` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key27` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key28` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key29` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key30` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key31` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key32` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lfg_dungeons` -- DROP TABLE IF EXISTS `lfg_dungeons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lfg_dungeons` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Description` text DEFAULT NULL, `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `TypeID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Subtype` tinyint(3) unsigned NOT NULL DEFAULT 0, `Faction` tinyint(4) NOT NULL DEFAULT 0, `IconTextureFileID` int(11) NOT NULL DEFAULT 0, `RewardsBgTextureFileID` int(11) NOT NULL DEFAULT 0, `PopupBgTextureFileID` int(11) NOT NULL DEFAULT 0, `ExpansionLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MapID` smallint(6) NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinGear` float NOT NULL DEFAULT 0, `GroupID` tinyint(3) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `RequiredPlayerConditionId` int(10) unsigned NOT NULL DEFAULT 0, `TargetLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `TargetLevelMin` tinyint(3) unsigned NOT NULL DEFAULT 0, `TargetLevelMax` smallint(5) unsigned NOT NULL DEFAULT 0, `RandomID` smallint(5) unsigned NOT NULL DEFAULT 0, `ScenarioID` smallint(5) unsigned NOT NULL DEFAULT 0, `FinalEncounterID` smallint(5) unsigned NOT NULL DEFAULT 0, `CountTank` tinyint(3) unsigned NOT NULL DEFAULT 0, `CountHealer` tinyint(3) unsigned NOT NULL DEFAULT 0, `CountDamage` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinCountTank` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinCountHealer` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinCountDamage` tinyint(3) unsigned NOT NULL DEFAULT 0, `BonusReputationAmount` smallint(5) unsigned NOT NULL DEFAULT 0, `MentorItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `MentorCharLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags1` int(11) NOT NULL DEFAULT 0, `Flags2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lfg_dungeons_locale` -- DROP TABLE IF EXISTS `lfg_dungeons_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lfg_dungeons_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `light` -- DROP TABLE IF EXISTS `light`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `light` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `GameCoordsX` float NOT NULL DEFAULT 0, `GameCoordsY` float NOT NULL DEFAULT 0, `GameCoordsZ` float NOT NULL DEFAULT 0, `GameFalloffStart` float NOT NULL DEFAULT 0, `GameFalloffEnd` float NOT NULL DEFAULT 0, `ContinentID` smallint(6) NOT NULL DEFAULT 0, `LightParamsID1` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID2` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID3` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID4` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID5` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID6` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID7` smallint(5) unsigned NOT NULL DEFAULT 0, `LightParamsID8` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `liquid_type` -- DROP TABLE IF EXISTS `liquid_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `liquid_type` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Texture1` text DEFAULT NULL, `Texture2` text DEFAULT NULL, `Texture3` text DEFAULT NULL, `Texture4` text DEFAULT NULL, `Texture5` text DEFAULT NULL, `Texture6` text DEFAULT NULL, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `SoundBank` tinyint(3) unsigned NOT NULL DEFAULT 0, `SoundID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(10) unsigned NOT NULL DEFAULT 0, `MaxDarkenDepth` float NOT NULL DEFAULT 0, `FogDarkenIntensity` float NOT NULL DEFAULT 0, `AmbDarkenIntensity` float NOT NULL DEFAULT 0, `DirDarkenIntensity` float NOT NULL DEFAULT 0, `LightID` smallint(5) unsigned NOT NULL DEFAULT 0, `ParticleScale` float NOT NULL DEFAULT 0, `ParticleMovement` tinyint(3) unsigned NOT NULL DEFAULT 0, `ParticleTexSlots` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaterialID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinimapStaticCol` int(11) NOT NULL DEFAULT 0, `FrameCountTexture1` tinyint(3) unsigned NOT NULL DEFAULT 0, `FrameCountTexture2` tinyint(3) unsigned NOT NULL DEFAULT 0, `FrameCountTexture3` tinyint(3) unsigned NOT NULL DEFAULT 0, `FrameCountTexture4` tinyint(3) unsigned NOT NULL DEFAULT 0, `FrameCountTexture5` tinyint(3) unsigned NOT NULL DEFAULT 0, `FrameCountTexture6` tinyint(3) unsigned NOT NULL DEFAULT 0, `Color1` int(11) NOT NULL DEFAULT 0, `Color2` int(11) NOT NULL DEFAULT 0, `Float1` float NOT NULL DEFAULT 0, `Float2` float NOT NULL DEFAULT 0, `Float3` float NOT NULL DEFAULT 0, `Float4` float NOT NULL DEFAULT 0, `Float5` float NOT NULL DEFAULT 0, `Float6` float NOT NULL DEFAULT 0, `Float7` float NOT NULL DEFAULT 0, `Float8` float NOT NULL DEFAULT 0, `Float9` float NOT NULL DEFAULT 0, `Float10` float NOT NULL DEFAULT 0, `Float11` float NOT NULL DEFAULT 0, `Float12` float NOT NULL DEFAULT 0, `Float13` float NOT NULL DEFAULT 0, `Float14` float NOT NULL DEFAULT 0, `Float15` float NOT NULL DEFAULT 0, `Float16` float NOT NULL DEFAULT 0, `Float17` float NOT NULL DEFAULT 0, `Float18` float NOT NULL DEFAULT 0, `Int1` int(10) unsigned NOT NULL DEFAULT 0, `Int2` int(10) unsigned NOT NULL DEFAULT 0, `Int3` int(10) unsigned NOT NULL DEFAULT 0, `Int4` int(10) unsigned NOT NULL DEFAULT 0, `Coefficient1` float NOT NULL DEFAULT 0, `Coefficient2` float NOT NULL DEFAULT 0, `Coefficient3` float NOT NULL DEFAULT 0, `Coefficient4` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lock` -- DROP TABLE IF EXISTS `lock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lock` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Index1` int(11) NOT NULL DEFAULT 0, `Index2` int(11) NOT NULL DEFAULT 0, `Index3` int(11) NOT NULL DEFAULT 0, `Index4` int(11) NOT NULL DEFAULT 0, `Index5` int(11) NOT NULL DEFAULT 0, `Index6` int(11) NOT NULL DEFAULT 0, `Index7` int(11) NOT NULL DEFAULT 0, `Index8` int(11) NOT NULL DEFAULT 0, `Skill1` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill2` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill3` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill4` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill5` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill6` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill7` smallint(5) unsigned NOT NULL DEFAULT 0, `Skill8` smallint(5) unsigned NOT NULL DEFAULT 0, `Type1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type3` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type5` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type6` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type7` tinyint(3) unsigned NOT NULL DEFAULT 0, `Type8` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action3` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action5` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action6` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action7` tinyint(3) unsigned NOT NULL DEFAULT 0, `Action8` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mail_template` -- DROP TABLE IF EXISTS `mail_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mail_template` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Body` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mail_template_locale` -- DROP TABLE IF EXISTS `mail_template_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mail_template_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Body_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `map` -- DROP TABLE IF EXISTS `map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `map` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Directory` text DEFAULT NULL, `MapName` text DEFAULT NULL, `MapDescription0` text DEFAULT NULL, `MapDescription1` text DEFAULT NULL, `PvpShortDescription` text DEFAULT NULL, `PvpLongDescription` text DEFAULT NULL, `CorpseX` float NOT NULL DEFAULT 0, `CorpseY` float NOT NULL DEFAULT 0, `MapType` tinyint(3) unsigned NOT NULL DEFAULT 0, `InstanceType` tinyint(4) NOT NULL DEFAULT 0, `ExpansionID` tinyint(3) unsigned NOT NULL DEFAULT 0, `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT 0, `LoadingScreenID` smallint(6) NOT NULL DEFAULT 0, `TimeOfDayOverride` smallint(6) NOT NULL DEFAULT 0, `ParentMapID` smallint(6) NOT NULL DEFAULT 0, `CosmeticParentMapID` smallint(6) NOT NULL DEFAULT 0, `TimeOffset` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinimapIconScale` float NOT NULL DEFAULT 0, `CorpseMapID` smallint(6) NOT NULL DEFAULT 0, `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT 0, `WindSettingsID` smallint(6) NOT NULL DEFAULT 0, `ZmpFileDataID` int(11) NOT NULL DEFAULT 0, `WdtFileDataID` int(11) NOT NULL DEFAULT 0, `Flags1` int(11) NOT NULL DEFAULT 0, `Flags2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `map_difficulty` -- DROP TABLE IF EXISTS `map_difficulty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `map_difficulty` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Message` text DEFAULT NULL, `DifficultyID` int(11) NOT NULL DEFAULT 0, `LockID` int(11) NOT NULL DEFAULT 0, `ResetInterval` tinyint(4) NOT NULL DEFAULT 0, `MaxPlayers` int(11) NOT NULL DEFAULT 0, `ItemContext` int(11) NOT NULL DEFAULT 0, `ItemContextPickerID` int(11) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `ContentTuningID` int(11) NOT NULL DEFAULT 0, `MapID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `map_difficulty_locale` -- DROP TABLE IF EXISTS `map_difficulty_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `map_difficulty_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Message_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `map_locale` -- DROP TABLE IF EXISTS `map_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `map_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `MapName_lang` text DEFAULT NULL, `MapDescription0_lang` text DEFAULT NULL, `MapDescription1_lang` text DEFAULT NULL, `PvpShortDescription_lang` text DEFAULT NULL, `PvpLongDescription_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `modifier_tree` -- DROP TABLE IF EXISTS `modifier_tree`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modifier_tree` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Parent` int(10) unsigned NOT NULL DEFAULT 0, `Operator` tinyint(4) NOT NULL DEFAULT 0, `Amount` tinyint(4) NOT NULL DEFAULT 0, `Type` int(11) NOT NULL DEFAULT 0, `Asset` int(11) NOT NULL DEFAULT 0, `SecondaryAsset` int(11) NOT NULL DEFAULT 0, `TertiaryAsset` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mount` -- DROP TABLE IF EXISTS `mount`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount` ( `Name` text DEFAULT NULL, `SourceText` text DEFAULT NULL, `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `MountTypeID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `SourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `SourceSpellID` int(11) NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `MountFlyRideHeight` float NOT NULL DEFAULT 0, `UiModelSceneID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mount_capability` -- DROP TABLE IF EXISTS `mount_capability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount_capability` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ReqRidingSkill` smallint(5) unsigned NOT NULL DEFAULT 0, `ReqAreaID` smallint(5) unsigned NOT NULL DEFAULT 0, `ReqSpellAuraID` int(10) unsigned NOT NULL DEFAULT 0, `ReqSpellKnownID` int(11) NOT NULL DEFAULT 0, `ModSpellAuraID` int(11) NOT NULL DEFAULT 0, `ReqMapID` smallint(6) NOT NULL DEFAULT 0, `PlayerConditionID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mount_locale` -- DROP TABLE IF EXISTS `mount_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `SourceText_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mount_type_x_capability` -- DROP TABLE IF EXISTS `mount_type_x_capability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount_type_x_capability` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `MountTypeID` smallint(5) unsigned NOT NULL DEFAULT 0, `MountCapabilityID` smallint(5) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mount_x_display` -- DROP TABLE IF EXISTS `mount_x_display`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount_x_display` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `CreatureDisplayInfoID` int(11) NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `MountID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `movie` -- DROP TABLE IF EXISTS `movie`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `movie` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Volume` tinyint(3) unsigned NOT NULL DEFAULT 0, `KeyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `AudioFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `SubtitleFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `name_gen` -- DROP TABLE IF EXISTS `name_gen`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `name_gen` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `RaceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Sex` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `names_profanity` -- DROP TABLE IF EXISTS `names_profanity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `names_profanity` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Language` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `names_reserved` -- DROP TABLE IF EXISTS `names_reserved`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `names_reserved` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `names_reserved_locale` -- DROP TABLE IF EXISTS `names_reserved_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `names_reserved_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `LocaleMask` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `num_talents_at_level` -- DROP TABLE IF EXISTS `num_talents_at_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `num_talents_at_level` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `NumTalents` int(11) NOT NULL DEFAULT 0, `NumTalentsDeathKnight` int(11) NOT NULL DEFAULT 0, `NumTalentsDemonHunter` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `override_spell_data` -- DROP TABLE IF EXISTS `override_spell_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `override_spell_data` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Spells1` int(11) NOT NULL DEFAULT 0, `Spells2` int(11) NOT NULL DEFAULT 0, `Spells3` int(11) NOT NULL DEFAULT 0, `Spells4` int(11) NOT NULL DEFAULT 0, `Spells5` int(11) NOT NULL DEFAULT 0, `Spells6` int(11) NOT NULL DEFAULT 0, `Spells7` int(11) NOT NULL DEFAULT 0, `Spells8` int(11) NOT NULL DEFAULT 0, `Spells9` int(11) NOT NULL DEFAULT 0, `Spells10` int(11) NOT NULL DEFAULT 0, `PlayerActionBarFileDataID` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phase` -- DROP TABLE IF EXISTS `phase`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phase` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `phase_x_phase_group` -- DROP TABLE IF EXISTS `phase_x_phase_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `phase_x_phase_group` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PhaseID` smallint(5) unsigned NOT NULL DEFAULT 0, `PhaseGroupID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_condition` -- DROP TABLE IF EXISTS `player_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_condition` ( `RaceMask` bigint(20) NOT NULL DEFAULT 0, `FailureDescription` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `MinLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `ClassMask` int(11) NOT NULL DEFAULT 0, `SkillLogic` int(10) unsigned NOT NULL DEFAULT 0, `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinLanguage` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxLanguage` int(11) NOT NULL DEFAULT 0, `MaxFactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxReputation` tinyint(3) unsigned NOT NULL DEFAULT 0, `ReputationLogic` int(10) unsigned NOT NULL DEFAULT 0, `CurrentPvpFaction` tinyint(4) NOT NULL DEFAULT 0, `PvpMedal` tinyint(3) unsigned NOT NULL DEFAULT 0, `PrevQuestLogic` int(10) unsigned NOT NULL DEFAULT 0, `CurrQuestLogic` int(10) unsigned NOT NULL DEFAULT 0, `CurrentCompletedQuestLogic` int(10) unsigned NOT NULL DEFAULT 0, `SpellLogic` int(10) unsigned NOT NULL DEFAULT 0, `ItemLogic` int(10) unsigned NOT NULL DEFAULT 0, `ItemFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, `AuraSpellLogic` int(10) unsigned NOT NULL DEFAULT 0, `WorldStateExpressionID` smallint(5) unsigned NOT NULL DEFAULT 0, `WeatherID` tinyint(3) unsigned NOT NULL DEFAULT 0, `PartyStatus` tinyint(3) unsigned NOT NULL DEFAULT 0, `LifetimeMaxPVPRank` tinyint(3) unsigned NOT NULL DEFAULT 0, `AchievementLogic` int(10) unsigned NOT NULL DEFAULT 0, `Gender` tinyint(4) NOT NULL DEFAULT 0, `NativeGender` tinyint(4) NOT NULL DEFAULT 0, `AreaLogic` int(10) unsigned NOT NULL DEFAULT 0, `LfgLogic` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyLogic` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillID` smallint(5) unsigned NOT NULL DEFAULT 0, `QuestKillLogic` int(10) unsigned NOT NULL DEFAULT 0, `MinExpansionLevel` tinyint(4) NOT NULL DEFAULT 0, `MaxExpansionLevel` tinyint(4) NOT NULL DEFAULT 0, `MinAvgItemLevel` int(11) NOT NULL DEFAULT 0, `MaxAvgItemLevel` int(11) NOT NULL DEFAULT 0, `MinAvgEquippedItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxAvgEquippedItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, `PhaseID` smallint(5) unsigned NOT NULL DEFAULT 0, `PhaseGroupID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ChrSpecializationIndex` tinyint(4) NOT NULL DEFAULT 0, `ChrSpecializationRole` tinyint(4) NOT NULL DEFAULT 0, `ModifierTreeID` int(10) unsigned NOT NULL DEFAULT 0, `PowerType` tinyint(4) NOT NULL DEFAULT 0, `PowerTypeComp` tinyint(3) unsigned NOT NULL DEFAULT 0, `PowerTypeValue` tinyint(3) unsigned NOT NULL DEFAULT 0, `WeaponSubclassMask` int(11) NOT NULL DEFAULT 0, `MaxGuildLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinGuildLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxExpansionTier` tinyint(4) NOT NULL DEFAULT 0, `MinExpansionTier` tinyint(4) NOT NULL DEFAULT 0, `MinPVPRank` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxPVPRank` tinyint(3) unsigned NOT NULL DEFAULT 0, `SkillID1` smallint(5) unsigned NOT NULL DEFAULT 0, `SkillID2` smallint(5) unsigned NOT NULL DEFAULT 0, `SkillID3` smallint(5) unsigned NOT NULL DEFAULT 0, `SkillID4` smallint(5) unsigned NOT NULL DEFAULT 0, `MinSkill1` smallint(5) unsigned NOT NULL DEFAULT 0, `MinSkill2` smallint(5) unsigned NOT NULL DEFAULT 0, `MinSkill3` smallint(5) unsigned NOT NULL DEFAULT 0, `MinSkill4` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxSkill1` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxSkill2` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxSkill3` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxSkill4` smallint(5) unsigned NOT NULL DEFAULT 0, `MinFactionID1` int(10) unsigned NOT NULL DEFAULT 0, `MinFactionID2` int(10) unsigned NOT NULL DEFAULT 0, `MinFactionID3` int(10) unsigned NOT NULL DEFAULT 0, `MinReputation1` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinReputation2` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinReputation3` tinyint(3) unsigned NOT NULL DEFAULT 0, `PrevQuestID1` smallint(5) unsigned NOT NULL DEFAULT 0, `PrevQuestID2` smallint(5) unsigned NOT NULL DEFAULT 0, `PrevQuestID3` smallint(5) unsigned NOT NULL DEFAULT 0, `PrevQuestID4` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrQuestID1` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrQuestID2` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrQuestID3` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrQuestID4` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrentCompletedQuestID1` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrentCompletedQuestID2` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrentCompletedQuestID3` smallint(5) unsigned NOT NULL DEFAULT 0, `CurrentCompletedQuestID4` smallint(5) unsigned NOT NULL DEFAULT 0, `SpellID1` int(11) NOT NULL DEFAULT 0, `SpellID2` int(11) NOT NULL DEFAULT 0, `SpellID3` int(11) NOT NULL DEFAULT 0, `SpellID4` int(11) NOT NULL DEFAULT 0, `ItemID1` int(11) NOT NULL DEFAULT 0, `ItemID2` int(11) NOT NULL DEFAULT 0, `ItemID3` int(11) NOT NULL DEFAULT 0, `ItemID4` int(11) NOT NULL DEFAULT 0, `ItemCount1` int(10) unsigned NOT NULL DEFAULT 0, `ItemCount2` int(10) unsigned NOT NULL DEFAULT 0, `ItemCount3` int(10) unsigned NOT NULL DEFAULT 0, `ItemCount4` int(10) unsigned NOT NULL DEFAULT 0, `Explored1` smallint(5) unsigned NOT NULL DEFAULT 0, `Explored2` smallint(5) unsigned NOT NULL DEFAULT 0, `Time1` int(10) unsigned NOT NULL DEFAULT 0, `Time2` int(10) unsigned NOT NULL DEFAULT 0, `AuraSpellID1` int(11) NOT NULL DEFAULT 0, `AuraSpellID2` int(11) NOT NULL DEFAULT 0, `AuraSpellID3` int(11) NOT NULL DEFAULT 0, `AuraSpellID4` int(11) NOT NULL DEFAULT 0, `AuraStacks1` tinyint(3) unsigned NOT NULL DEFAULT 0, `AuraStacks2` tinyint(3) unsigned NOT NULL DEFAULT 0, `AuraStacks3` tinyint(3) unsigned NOT NULL DEFAULT 0, `AuraStacks4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Achievement1` smallint(5) unsigned NOT NULL DEFAULT 0, `Achievement2` smallint(5) unsigned NOT NULL DEFAULT 0, `Achievement3` smallint(5) unsigned NOT NULL DEFAULT 0, `Achievement4` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaID1` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaID2` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaID3` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaID4` smallint(5) unsigned NOT NULL DEFAULT 0, `LfgStatus1` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgStatus2` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgStatus3` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgStatus4` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgCompare1` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgCompare2` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgCompare3` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgCompare4` tinyint(3) unsigned NOT NULL DEFAULT 0, `LfgValue1` int(10) unsigned NOT NULL DEFAULT 0, `LfgValue2` int(10) unsigned NOT NULL DEFAULT 0, `LfgValue3` int(10) unsigned NOT NULL DEFAULT 0, `LfgValue4` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyID1` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyID2` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyID3` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyID4` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount1` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount2` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount3` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyCount4` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillMonster1` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillMonster2` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillMonster3` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillMonster4` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillMonster5` int(10) unsigned NOT NULL DEFAULT 0, `QuestKillMonster6` int(10) unsigned NOT NULL DEFAULT 0, `MovementFlags1` int(11) NOT NULL DEFAULT 0, `MovementFlags2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_condition_locale` -- DROP TABLE IF EXISTS `player_condition_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_condition_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `FailureDescription_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `power_display` -- DROP TABLE IF EXISTS `power_display`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `power_display` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `GlobalStringBaseTag` text DEFAULT NULL, `ActualType` tinyint(3) unsigned NOT NULL DEFAULT 0, `Red` tinyint(3) unsigned NOT NULL DEFAULT 0, `Green` tinyint(3) unsigned NOT NULL DEFAULT 0, `Blue` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `power_type` -- DROP TABLE IF EXISTS `power_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `power_type` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `NameGlobalStringTag` text DEFAULT NULL, `CostGlobalStringTag` text DEFAULT NULL, `PowerTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `MinPower` tinyint(4) NOT NULL DEFAULT 0, `MaxBasePower` smallint(6) NOT NULL DEFAULT 0, `CenterPower` tinyint(4) NOT NULL DEFAULT 0, `DefaultPower` tinyint(4) NOT NULL DEFAULT 0, `DisplayModifier` tinyint(4) NOT NULL DEFAULT 0, `RegenInterruptTimeMS` smallint(6) NOT NULL DEFAULT 0, `RegenPeace` float NOT NULL DEFAULT 0, `RegenCombat` float NOT NULL DEFAULT 0, `Flags` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `prestige_level_info` -- DROP TABLE IF EXISTS `prestige_level_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prestige_level_info` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `PrestigeLevel` int(11) NOT NULL DEFAULT 0, `BadgeTextureFileDataID` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `AwardedAchievementID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `prestige_level_info_locale` -- DROP TABLE IF EXISTS `prestige_level_info_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prestige_level_info_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_difficulty` -- DROP TABLE IF EXISTS `pvp_difficulty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_difficulty` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RangeIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MapID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_item` -- DROP TABLE IF EXISTS `pvp_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_item` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `ItemLevelDelta` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_talent` -- DROP TABLE IF EXISTS `pvp_talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_talent` ( `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpecID` int(11) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `OverridesSpellID` int(11) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `ActionBarSpellID` int(11) NOT NULL DEFAULT 0, `PvpTalentCategoryID` int(11) NOT NULL DEFAULT 0, `LevelRequired` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_talent_category` -- DROP TABLE IF EXISTS `pvp_talent_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_talent_category` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `TalentSlotMask` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_talent_locale` -- DROP TABLE IF EXISTS `pvp_talent_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_talent_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pvp_talent_slot_unlock` -- DROP TABLE IF EXISTS `pvp_talent_slot_unlock`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pvp_talent_slot_unlock` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Slot` tinyint(4) NOT NULL DEFAULT 0, `LevelRequired` int(11) NOT NULL DEFAULT 0, `DeathKnightLevelRequired` int(11) NOT NULL DEFAULT 0, `DemonHunterLevelRequired` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_faction_reward` -- DROP TABLE IF EXISTS `quest_faction_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_faction_reward` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty1` smallint(6) NOT NULL DEFAULT 0, `Difficulty2` smallint(6) NOT NULL DEFAULT 0, `Difficulty3` smallint(6) NOT NULL DEFAULT 0, `Difficulty4` smallint(6) NOT NULL DEFAULT 0, `Difficulty5` smallint(6) NOT NULL DEFAULT 0, `Difficulty6` smallint(6) NOT NULL DEFAULT 0, `Difficulty7` smallint(6) NOT NULL DEFAULT 0, `Difficulty8` smallint(6) NOT NULL DEFAULT 0, `Difficulty9` smallint(6) NOT NULL DEFAULT 0, `Difficulty10` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_money_reward` -- DROP TABLE IF EXISTS `quest_money_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_money_reward` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty1` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty2` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty3` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty4` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty5` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty6` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty7` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty8` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty9` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty10` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_package_item` -- DROP TABLE IF EXISTS `quest_package_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_package_item` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PackageID` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `ItemQuantity` int(10) unsigned NOT NULL DEFAULT 0, `DisplayType` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_sort` -- DROP TABLE IF EXISTS `quest_sort`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_sort` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SortName` text DEFAULT NULL, `UiOrderIndex` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_sort_locale` -- DROP TABLE IF EXISTS `quest_sort_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_sort_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `SortName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_v2` -- DROP TABLE IF EXISTS `quest_v2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_v2` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `UniqueBitFlag` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_xp` -- DROP TABLE IF EXISTS `quest_xp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_xp` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Difficulty1` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty2` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty3` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty4` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty5` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty6` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty7` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty8` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty9` smallint(5) unsigned NOT NULL DEFAULT 0, `Difficulty10` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `rand_prop_points` -- DROP TABLE IF EXISTS `rand_prop_points`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rand_prop_points` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DamageReplaceStat` int(11) NOT NULL DEFAULT 0, `DamageSecondary` int(11) NOT NULL DEFAULT 0, `Epic1` int(10) unsigned NOT NULL DEFAULT 0, `Epic2` int(10) unsigned NOT NULL DEFAULT 0, `Epic3` int(10) unsigned NOT NULL DEFAULT 0, `Epic4` int(10) unsigned NOT NULL DEFAULT 0, `Epic5` int(10) unsigned NOT NULL DEFAULT 0, `Superior1` int(10) unsigned NOT NULL DEFAULT 0, `Superior2` int(10) unsigned NOT NULL DEFAULT 0, `Superior3` int(10) unsigned NOT NULL DEFAULT 0, `Superior4` int(10) unsigned NOT NULL DEFAULT 0, `Superior5` int(10) unsigned NOT NULL DEFAULT 0, `Good1` int(10) unsigned NOT NULL DEFAULT 0, `Good2` int(10) unsigned NOT NULL DEFAULT 0, `Good3` int(10) unsigned NOT NULL DEFAULT 0, `Good4` int(10) unsigned NOT NULL DEFAULT 0, `Good5` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reward_pack` -- DROP TABLE IF EXISTS `reward_pack`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reward_pack` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `CharTitleID` int(11) NOT NULL DEFAULT 0, `Money` int(10) unsigned NOT NULL DEFAULT 0, `ArtifactXPDifficulty` tinyint(4) NOT NULL DEFAULT 0, `ArtifactXPMultiplier` float NOT NULL DEFAULT 0, `ArtifactXPCategoryID` tinyint(3) unsigned NOT NULL DEFAULT 0, `TreasurePickerID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reward_pack_x_currency_type` -- DROP TABLE IF EXISTS `reward_pack_x_currency_type`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reward_pack_x_currency_type` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `CurrencyTypeID` int(10) unsigned NOT NULL DEFAULT 0, `Quantity` int(11) NOT NULL DEFAULT 0, `RewardPackID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reward_pack_x_item` -- DROP TABLE IF EXISTS `reward_pack_x_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reward_pack_x_item` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `ItemQuantity` int(11) NOT NULL DEFAULT 0, `RewardPackID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ruleset_item_upgrade` -- DROP TABLE IF EXISTS `ruleset_item_upgrade`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ruleset_item_upgrade` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `ItemUpgradeID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scaling_stat_distribution` -- DROP TABLE IF EXISTS `scaling_stat_distribution`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scaling_stat_distribution` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PlayerLevelToItemLevelCurveID` smallint(5) unsigned NOT NULL DEFAULT 0, `MinLevel` int(11) NOT NULL DEFAULT 0, `MaxLevel` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scenario` -- DROP TABLE IF EXISTS `scenario`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scenario` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT 0, `Type` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiTextureKitID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scenario_locale` -- DROP TABLE IF EXISTS `scenario_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scenario_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scenario_step` -- DROP TABLE IF EXISTS `scenario_step`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scenario_step` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Description` text DEFAULT NULL, `Title` text DEFAULT NULL, `ScenarioID` smallint(5) unsigned NOT NULL DEFAULT 0, `Criteriatreeid` int(10) unsigned NOT NULL DEFAULT 0, `RewardQuestID` smallint(5) unsigned NOT NULL DEFAULT 0, `RelatedStep` int(11) NOT NULL DEFAULT 0, `Supersedes` smallint(5) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VisibilityPlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `WidgetSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scenario_step_locale` -- DROP TABLE IF EXISTS `scenario_step_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scenario_step_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `Title_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scene_script` -- DROP TABLE IF EXISTS `scene_script`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scene_script` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `FirstSceneScriptID` smallint(5) unsigned NOT NULL DEFAULT 0, `NextSceneScriptID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scene_script_global_text` -- DROP TABLE IF EXISTS `scene_script_global_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scene_script_global_text` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Script` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scene_script_package` -- DROP TABLE IF EXISTS `scene_script_package`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scene_script_package` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scene_script_text` -- DROP TABLE IF EXISTS `scene_script_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scene_script_text` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Script` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_line` -- DROP TABLE IF EXISTS `skill_line`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_line` ( `DisplayName` text DEFAULT NULL, `AlternateVerb` text DEFAULT NULL, `Description` text DEFAULT NULL, `HordeDisplayName` text DEFAULT NULL, `OverrideSourceInfoDisplayName` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `CategoryID` tinyint(4) NOT NULL DEFAULT 0, `SpellIconFileID` int(11) NOT NULL DEFAULT 0, `CanLink` tinyint(4) NOT NULL DEFAULT 0, `ParentSkillLineID` int(10) unsigned NOT NULL DEFAULT 0, `ParentTierIndex` int(11) NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `SpellBookSpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_line_ability` -- DROP TABLE IF EXISTS `skill_line_ability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_line_ability` ( `RaceMask` bigint(20) NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `SkillLine` smallint(6) NOT NULL DEFAULT 0, `Spell` int(11) NOT NULL DEFAULT 0, `MinSkillLineRank` smallint(6) NOT NULL DEFAULT 0, `ClassMask` int(11) NOT NULL DEFAULT 0, `SupercedesSpell` int(11) NOT NULL DEFAULT 0, `AcquireMethod` tinyint(4) NOT NULL DEFAULT 0, `TrivialSkillLineRankHigh` smallint(6) NOT NULL DEFAULT 0, `TrivialSkillLineRankLow` smallint(6) NOT NULL DEFAULT 0, `Flags` tinyint(4) NOT NULL DEFAULT 0, `NumSkillUps` tinyint(4) NOT NULL DEFAULT 0, `UniqueBit` smallint(6) NOT NULL DEFAULT 0, `TradeSkillCategoryID` smallint(6) NOT NULL DEFAULT 0, `SkillupSkillLineID` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_line_locale` -- DROP TABLE IF EXISTS `skill_line_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_line_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `DisplayName_lang` text DEFAULT NULL, `AlternateVerb_lang` text DEFAULT NULL, `Description_lang` text DEFAULT NULL, `HordeDisplayName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_race_class_info` -- DROP TABLE IF EXISTS `skill_race_class_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_race_class_info` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RaceMask` bigint(20) NOT NULL DEFAULT 0, `SkillID` smallint(6) NOT NULL DEFAULT 0, `ClassMask` int(11) NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `Availability` tinyint(4) NOT NULL DEFAULT 0, `MinLevel` tinyint(4) NOT NULL DEFAULT 0, `SkillTierID` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `sound_kit` -- DROP TABLE IF EXISTS `sound_kit`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sound_kit` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SoundType` int(11) NOT NULL DEFAULT 0, `VolumeFloat` float NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `MinDistance` float NOT NULL DEFAULT 0, `DistanceCutoff` float NOT NULL DEFAULT 0, `EAXDef` tinyint(3) unsigned NOT NULL DEFAULT 0, `SoundKitAdvancedID` int(10) unsigned NOT NULL DEFAULT 0, `VolumeVariationPlus` float NOT NULL DEFAULT 0, `VolumeVariationMinus` float NOT NULL DEFAULT 0, `PitchVariationPlus` float NOT NULL DEFAULT 0, `PitchVariationMinus` float NOT NULL DEFAULT 0, `DialogType` tinyint(4) NOT NULL DEFAULT 0, `PitchAdjust` float NOT NULL DEFAULT 0, `BusOverwriteID` smallint(5) unsigned NOT NULL DEFAULT 0, `MaxInstances` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `specialization_spells` -- DROP TABLE IF EXISTS `specialization_spells`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `specialization_spells` ( `Description` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpecID` smallint(5) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `OverridesSpellID` int(11) NOT NULL DEFAULT 0, `DisplayOrder` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `specialization_spells_locale` -- DROP TABLE IF EXISTS `specialization_spells_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `specialization_spells_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_aura_options` -- DROP TABLE IF EXISTS `spell_aura_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_aura_options` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `CumulativeAura` smallint(5) unsigned NOT NULL DEFAULT 0, `ProcCategoryRecovery` int(11) NOT NULL DEFAULT 0, `ProcChance` tinyint(3) unsigned NOT NULL DEFAULT 0, `ProcCharges` int(11) NOT NULL DEFAULT 0, `SpellProcsPerMinuteID` smallint(5) unsigned NOT NULL DEFAULT 0, `ProcTypeMask1` int(11) NOT NULL DEFAULT 0, `ProcTypeMask2` int(11) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_aura_restrictions` -- DROP TABLE IF EXISTS `spell_aura_restrictions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_aura_restrictions` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `CasterAuraState` tinyint(3) unsigned NOT NULL DEFAULT 0, `TargetAuraState` tinyint(3) unsigned NOT NULL DEFAULT 0, `ExcludeCasterAuraState` tinyint(3) unsigned NOT NULL DEFAULT 0, `ExcludeTargetAuraState` tinyint(3) unsigned NOT NULL DEFAULT 0, `CasterAuraSpell` int(11) NOT NULL DEFAULT 0, `TargetAuraSpell` int(11) NOT NULL DEFAULT 0, `ExcludeCasterAuraSpell` int(11) NOT NULL DEFAULT 0, `ExcludeTargetAuraSpell` int(11) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_cast_times` -- DROP TABLE IF EXISTS `spell_cast_times`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_cast_times` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Base` int(11) NOT NULL DEFAULT 0, `PerLevel` smallint(6) NOT NULL DEFAULT 0, `Minimum` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_casting_requirements` -- DROP TABLE IF EXISTS `spell_casting_requirements`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_casting_requirements` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `FacingCasterFlags` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinFactionID` smallint(5) unsigned NOT NULL DEFAULT 0, `MinReputation` tinyint(4) NOT NULL DEFAULT 0, `RequiredAreasID` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredAuraVision` tinyint(3) unsigned NOT NULL DEFAULT 0, `RequiresSpellFocus` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_categories` -- DROP TABLE IF EXISTS `spell_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_categories` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Category` smallint(6) NOT NULL DEFAULT 0, `DefenseType` tinyint(4) NOT NULL DEFAULT 0, `DispelType` tinyint(4) NOT NULL DEFAULT 0, `Mechanic` tinyint(4) NOT NULL DEFAULT 0, `PreventionType` tinyint(4) NOT NULL DEFAULT 0, `StartRecoveryCategory` smallint(6) NOT NULL DEFAULT 0, `ChargeCategory` smallint(6) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_category` -- DROP TABLE IF EXISTS `spell_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_category` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Flags` tinyint(4) NOT NULL DEFAULT 0, `UsesPerWeek` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxCharges` tinyint(4) NOT NULL DEFAULT 0, `ChargeRecoveryTime` int(11) NOT NULL DEFAULT 0, `TypeMask` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_category_locale` -- DROP TABLE IF EXISTS `spell_category_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_category_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_class_options` -- DROP TABLE IF EXISTS `spell_class_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_class_options` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `ModalNextSpell` int(10) unsigned NOT NULL DEFAULT 0, `SpellClassSet` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellClassMask1` int(11) NOT NULL DEFAULT 0, `SpellClassMask2` int(11) NOT NULL DEFAULT 0, `SpellClassMask3` int(11) NOT NULL DEFAULT 0, `SpellClassMask4` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_cooldowns` -- DROP TABLE IF EXISTS `spell_cooldowns`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_cooldowns` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `CategoryRecoveryTime` int(11) NOT NULL DEFAULT 0, `RecoveryTime` int(11) NOT NULL DEFAULT 0, `StartRecoveryTime` int(11) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_duration` -- DROP TABLE IF EXISTS `spell_duration`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_duration` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Duration` int(11) NOT NULL DEFAULT 0, `DurationPerLevel` int(10) unsigned NOT NULL DEFAULT 0, `MaxDuration` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_effect` -- DROP TABLE IF EXISTS `spell_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_effect` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` int(11) NOT NULL DEFAULT 0, `EffectIndex` int(11) NOT NULL DEFAULT 0, `Effect` int(10) unsigned NOT NULL DEFAULT 0, `EffectAmplitude` float NOT NULL DEFAULT 0, `EffectAttributes` int(11) NOT NULL DEFAULT 0, `EffectAura` smallint(6) NOT NULL DEFAULT 0, `EffectAuraPeriod` int(11) NOT NULL DEFAULT 0, `EffectBonusCoefficient` float NOT NULL DEFAULT 0, `EffectChainAmplitude` float NOT NULL DEFAULT 0, `EffectChainTargets` int(11) NOT NULL DEFAULT 0, `EffectItemType` int(11) NOT NULL DEFAULT 0, `EffectMechanic` int(11) NOT NULL DEFAULT 0, `EffectPointsPerResource` float NOT NULL DEFAULT 0, `EffectPosFacing` float NOT NULL DEFAULT 0, `EffectRealPointsPerLevel` float NOT NULL DEFAULT 0, `EffectTriggerSpell` int(11) NOT NULL DEFAULT 0, `BonusCoefficientFromAP` float NOT NULL DEFAULT 0, `PvpMultiplier` float NOT NULL DEFAULT 0, `Coefficient` float NOT NULL DEFAULT 0, `Variance` float NOT NULL DEFAULT 0, `ResourceCoefficient` float NOT NULL DEFAULT 0, `GroupSizeBasePointsCoefficient` float NOT NULL DEFAULT 0, `EffectBasePoints` float NOT NULL DEFAULT 0, `EffectMiscValue1` int(11) NOT NULL DEFAULT 0, `EffectMiscValue2` int(11) NOT NULL DEFAULT 0, `EffectRadiusIndex1` int(10) unsigned NOT NULL DEFAULT 0, `EffectRadiusIndex2` int(10) unsigned NOT NULL DEFAULT 0, `EffectSpellClassMask1` int(11) NOT NULL DEFAULT 0, `EffectSpellClassMask2` int(11) NOT NULL DEFAULT 0, `EffectSpellClassMask3` int(11) NOT NULL DEFAULT 0, `EffectSpellClassMask4` int(11) NOT NULL DEFAULT 0, `ImplicitTarget1` smallint(6) NOT NULL DEFAULT 0, `ImplicitTarget2` smallint(6) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_equipped_items` -- DROP TABLE IF EXISTS `spell_equipped_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_equipped_items` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `EquippedItemClass` tinyint(4) NOT NULL DEFAULT 0, `EquippedItemInvTypes` int(11) NOT NULL DEFAULT 0, `EquippedItemSubclass` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_focus_object` -- DROP TABLE IF EXISTS `spell_focus_object`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_focus_object` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_focus_object_locale` -- DROP TABLE IF EXISTS `spell_focus_object_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_focus_object_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_interrupts` -- DROP TABLE IF EXISTS `spell_interrupts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_interrupts` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `InterruptFlags` smallint(6) NOT NULL DEFAULT 0, `AuraInterruptFlags1` int(11) NOT NULL DEFAULT 0, `AuraInterruptFlags2` int(11) NOT NULL DEFAULT 0, `ChannelInterruptFlags1` int(11) NOT NULL DEFAULT 0, `ChannelInterruptFlags2` int(11) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_item_enchantment` -- DROP TABLE IF EXISTS `spell_item_enchantment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_item_enchantment` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `HordeName` text DEFAULT NULL, `EffectArg1` int(10) unsigned NOT NULL DEFAULT 0, `EffectArg2` int(10) unsigned NOT NULL DEFAULT 0, `EffectArg3` int(10) unsigned NOT NULL DEFAULT 0, `EffectScalingPoints1` float NOT NULL DEFAULT 0, `EffectScalingPoints2` float NOT NULL DEFAULT 0, `EffectScalingPoints3` float NOT NULL DEFAULT 0, `TransmogPlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `TransmogCost` int(10) unsigned NOT NULL DEFAULT 0, `IconFileDataID` int(10) unsigned NOT NULL DEFAULT 0, `EffectPointsMin1` smallint(6) NOT NULL DEFAULT 0, `EffectPointsMin2` smallint(6) NOT NULL DEFAULT 0, `EffectPointsMin3` smallint(6) NOT NULL DEFAULT 0, `ItemVisual` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredSkillID` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT 0, `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT 0, `Charges` tinyint(3) unsigned NOT NULL DEFAULT 0, `Effect1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Effect2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Effect3` tinyint(3) unsigned NOT NULL DEFAULT 0, `ScalingClass` tinyint(4) NOT NULL DEFAULT 0, `ScalingClassRestricted` tinyint(4) NOT NULL DEFAULT 0, `ConditionID` tinyint(3) unsigned NOT NULL DEFAULT 0, `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_item_enchantment_condition` -- DROP TABLE IF EXISTS `spell_item_enchantment_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_item_enchantment_condition` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `LtOperandType1` tinyint(3) unsigned NOT NULL DEFAULT 0, `LtOperandType2` tinyint(3) unsigned NOT NULL DEFAULT 0, `LtOperandType3` tinyint(3) unsigned NOT NULL DEFAULT 0, `LtOperandType4` tinyint(3) unsigned NOT NULL DEFAULT 0, `LtOperandType5` tinyint(3) unsigned NOT NULL DEFAULT 0, `LtOperand1` int(10) unsigned NOT NULL DEFAULT 0, `LtOperand2` int(10) unsigned NOT NULL DEFAULT 0, `LtOperand3` int(10) unsigned NOT NULL DEFAULT 0, `LtOperand4` int(10) unsigned NOT NULL DEFAULT 0, `LtOperand5` int(10) unsigned NOT NULL DEFAULT 0, `Operator1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Operator2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Operator3` tinyint(3) unsigned NOT NULL DEFAULT 0, `Operator4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Operator5` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperandType1` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperandType2` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperandType3` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperandType4` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperandType5` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperand1` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperand2` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperand3` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperand4` tinyint(3) unsigned NOT NULL DEFAULT 0, `RtOperand5` tinyint(3) unsigned NOT NULL DEFAULT 0, `Logic1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Logic2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Logic3` tinyint(3) unsigned NOT NULL DEFAULT 0, `Logic4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Logic5` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_item_enchantment_locale` -- DROP TABLE IF EXISTS `spell_item_enchantment_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_item_enchantment_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `HordeName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_learn_spell` -- DROP TABLE IF EXISTS `spell_learn_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_learn_spell` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `LearnSpellID` int(11) NOT NULL DEFAULT 0, `OverridesSpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_levels` -- DROP TABLE IF EXISTS `spell_levels`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_levels` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `BaseLevel` smallint(6) NOT NULL DEFAULT 0, `MaxLevel` smallint(6) NOT NULL DEFAULT 0, `SpellLevel` smallint(6) NOT NULL DEFAULT 0, `MaxPassiveAuraLevel` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_misc` -- DROP TABLE IF EXISTS `spell_misc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_misc` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `CastingTimeIndex` smallint(5) unsigned NOT NULL DEFAULT 0, `DurationIndex` smallint(5) unsigned NOT NULL DEFAULT 0, `RangeIndex` smallint(5) unsigned NOT NULL DEFAULT 0, `SchoolMask` tinyint(3) unsigned NOT NULL DEFAULT 0, `Speed` float NOT NULL DEFAULT 0, `LaunchDelay` float NOT NULL DEFAULT 0, `MinDuration` float NOT NULL DEFAULT 0, `SpellIconFileDataID` int(11) NOT NULL DEFAULT 0, `ActiveIconFileDataID` int(11) NOT NULL DEFAULT 0, `ContentTuningID` int(11) NOT NULL DEFAULT 0, `Attributes1` int(11) NOT NULL DEFAULT 0, `Attributes2` int(11) NOT NULL DEFAULT 0, `Attributes3` int(11) NOT NULL DEFAULT 0, `Attributes4` int(11) NOT NULL DEFAULT 0, `Attributes5` int(11) NOT NULL DEFAULT 0, `Attributes6` int(11) NOT NULL DEFAULT 0, `Attributes7` int(11) NOT NULL DEFAULT 0, `Attributes8` int(11) NOT NULL DEFAULT 0, `Attributes9` int(11) NOT NULL DEFAULT 0, `Attributes10` int(11) NOT NULL DEFAULT 0, `Attributes11` int(11) NOT NULL DEFAULT 0, `Attributes12` int(11) NOT NULL DEFAULT 0, `Attributes13` int(11) NOT NULL DEFAULT 0, `Attributes14` int(11) NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_name` -- DROP TABLE IF EXISTS `spell_name`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_name` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_name_locale` -- DROP TABLE IF EXISTS `spell_name_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_name_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_power` -- DROP TABLE IF EXISTS `spell_power`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_power` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `ManaCost` int(11) NOT NULL DEFAULT 0, `ManaCostPerLevel` int(11) NOT NULL DEFAULT 0, `ManaPerSecond` int(11) NOT NULL DEFAULT 0, `PowerDisplayID` int(10) unsigned NOT NULL DEFAULT 0, `AltPowerBarID` int(11) NOT NULL DEFAULT 0, `PowerCostPct` float NOT NULL DEFAULT 0, `PowerCostMaxPct` float NOT NULL DEFAULT 0, `PowerPctPerSecond` float NOT NULL DEFAULT 0, `PowerType` tinyint(4) NOT NULL DEFAULT 0, `RequiredAuraSpellID` int(11) NOT NULL DEFAULT 0, `OptionalCost` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_power_difficulty` -- DROP TABLE IF EXISTS `spell_power_difficulty`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_power_difficulty` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_procs_per_minute` -- DROP TABLE IF EXISTS `spell_procs_per_minute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_procs_per_minute` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `BaseProcRate` float NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_procs_per_minute_mod` -- DROP TABLE IF EXISTS `spell_procs_per_minute_mod`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_procs_per_minute_mod` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Type` tinyint(3) unsigned NOT NULL DEFAULT 0, `Param` smallint(6) NOT NULL DEFAULT 0, `Coeff` float NOT NULL DEFAULT 0, `SpellProcsPerMinuteID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_radius` -- DROP TABLE IF EXISTS `spell_radius`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_radius` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Radius` float NOT NULL DEFAULT 0, `RadiusPerLevel` float NOT NULL DEFAULT 0, `RadiusMin` float NOT NULL DEFAULT 0, `RadiusMax` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_range` -- DROP TABLE IF EXISTS `spell_range`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_range` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DisplayName` text DEFAULT NULL, `DisplayNameShort` text DEFAULT NULL, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `RangeMin1` float NOT NULL DEFAULT 0, `RangeMin2` float NOT NULL DEFAULT 0, `RangeMax1` float NOT NULL DEFAULT 0, `RangeMax2` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_range_locale` -- DROP TABLE IF EXISTS `spell_range_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_range_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `DisplayName_lang` text DEFAULT NULL, `DisplayNameShort_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_reagents` -- DROP TABLE IF EXISTS `spell_reagents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_reagents` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `Reagent1` int(11) NOT NULL DEFAULT 0, `Reagent2` int(11) NOT NULL DEFAULT 0, `Reagent3` int(11) NOT NULL DEFAULT 0, `Reagent4` int(11) NOT NULL DEFAULT 0, `Reagent5` int(11) NOT NULL DEFAULT 0, `Reagent6` int(11) NOT NULL DEFAULT 0, `Reagent7` int(11) NOT NULL DEFAULT 0, `Reagent8` int(11) NOT NULL DEFAULT 0, `ReagentCount1` smallint(6) NOT NULL DEFAULT 0, `ReagentCount2` smallint(6) NOT NULL DEFAULT 0, `ReagentCount3` smallint(6) NOT NULL DEFAULT 0, `ReagentCount4` smallint(6) NOT NULL DEFAULT 0, `ReagentCount5` smallint(6) NOT NULL DEFAULT 0, `ReagentCount6` smallint(6) NOT NULL DEFAULT 0, `ReagentCount7` smallint(6) NOT NULL DEFAULT 0, `ReagentCount8` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_scaling` -- DROP TABLE IF EXISTS `spell_scaling`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_scaling` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `Class` int(11) NOT NULL DEFAULT 0, `MinScalingLevel` int(10) unsigned NOT NULL DEFAULT 0, `MaxScalingLevel` int(10) unsigned NOT NULL DEFAULT 0, `ScalesFromItemLevel` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_shapeshift` -- DROP TABLE IF EXISTS `spell_shapeshift`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_shapeshift` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `StanceBarOrder` tinyint(4) NOT NULL DEFAULT 0, `ShapeshiftExclude1` int(11) NOT NULL DEFAULT 0, `ShapeshiftExclude2` int(11) NOT NULL DEFAULT 0, `ShapeshiftMask1` int(11) NOT NULL DEFAULT 0, `ShapeshiftMask2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_shapeshift_form` -- DROP TABLE IF EXISTS `spell_shapeshift_form`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_shapeshift_form` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `CreatureType` tinyint(4) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `AttackIconFileID` int(11) NOT NULL DEFAULT 0, `BonusActionBar` tinyint(4) NOT NULL DEFAULT 0, `CombatRoundTime` smallint(6) NOT NULL DEFAULT 0, `DamageVariance` float NOT NULL DEFAULT 0, `MountTypeID` smallint(5) unsigned NOT NULL DEFAULT 0, `CreatureDisplayID1` int(10) unsigned NOT NULL DEFAULT 0, `CreatureDisplayID2` int(10) unsigned NOT NULL DEFAULT 0, `CreatureDisplayID3` int(10) unsigned NOT NULL DEFAULT 0, `CreatureDisplayID4` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID1` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID2` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID3` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID4` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID5` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID6` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID7` int(10) unsigned NOT NULL DEFAULT 0, `PresetSpellID8` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_shapeshift_form_locale` -- DROP TABLE IF EXISTS `spell_shapeshift_form_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_shapeshift_form_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_target_restrictions` -- DROP TABLE IF EXISTS `spell_target_restrictions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_target_restrictions` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `ConeDegrees` float NOT NULL DEFAULT 0, `MaxTargets` tinyint(3) unsigned NOT NULL DEFAULT 0, `MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT 0, `TargetCreatureType` smallint(6) NOT NULL DEFAULT 0, `Targets` int(11) NOT NULL DEFAULT 0, `Width` float NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_totems` -- DROP TABLE IF EXISTS `spell_totems`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_totems` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `RequiredTotemCategoryID1` smallint(5) unsigned NOT NULL DEFAULT 0, `RequiredTotemCategoryID2` smallint(5) unsigned NOT NULL DEFAULT 0, `Totem1` int(11) NOT NULL DEFAULT 0, `Totem2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_x_spell_visual` -- DROP TABLE IF EXISTS `spell_x_spell_visual`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_x_spell_visual` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellVisualID` int(10) unsigned NOT NULL DEFAULT 0, `Probability` float NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `Priority` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpellIconFileID` int(11) NOT NULL DEFAULT 0, `ActiveIconFileID` int(11) NOT NULL DEFAULT 0, `ViewerUnitConditionID` smallint(5) unsigned NOT NULL DEFAULT 0, `ViewerPlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `CasterUnitConditionID` smallint(5) unsigned NOT NULL DEFAULT 0, `CasterPlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `SpellID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `summon_properties` -- DROP TABLE IF EXISTS `summon_properties`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `summon_properties` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Control` int(11) NOT NULL DEFAULT 0, `Faction` int(11) NOT NULL DEFAULT 0, `Title` int(11) NOT NULL DEFAULT 0, `Slot` int(11) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `tact_key` -- DROP TABLE IF EXISTS `tact_key`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tact_key` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Key1` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key2` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key3` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key4` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key5` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key6` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key7` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key8` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key9` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key10` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key11` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key12` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key13` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key14` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key15` tinyint(3) unsigned NOT NULL DEFAULT 0, `Key16` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `talent` -- DROP TABLE IF EXISTS `talent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `talent` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Description` text DEFAULT NULL, `TierID` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `ColumnIndex` tinyint(3) unsigned NOT NULL DEFAULT 0, `ClassID` tinyint(3) unsigned NOT NULL DEFAULT 0, `SpecID` smallint(5) unsigned NOT NULL DEFAULT 0, `SpellID` int(10) unsigned NOT NULL DEFAULT 0, `OverridesSpellID` int(10) unsigned NOT NULL DEFAULT 0, `CategoryMask1` tinyint(3) unsigned NOT NULL DEFAULT 0, `CategoryMask2` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `talent_locale` -- DROP TABLE IF EXISTS `talent_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `talent_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Description_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `taxi_nodes` -- DROP TABLE IF EXISTS `taxi_nodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `taxi_nodes` ( `Name` text DEFAULT NULL, `PosX` float NOT NULL DEFAULT 0, `PosY` float NOT NULL DEFAULT 0, `PosZ` float NOT NULL DEFAULT 0, `MapOffsetX` float NOT NULL DEFAULT 0, `MapOffsetY` float NOT NULL DEFAULT 0, `FlightMapOffsetX` float NOT NULL DEFAULT 0, `FlightMapOffsetY` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ContinentID` smallint(5) unsigned NOT NULL DEFAULT 0, `ConditionID` int(11) NOT NULL DEFAULT 0, `CharacterBitNumber` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `UiTextureKitID` int(11) NOT NULL DEFAULT 0, `MinimapAtlasMemberID` int(11) NOT NULL DEFAULT 0, `Facing` float NOT NULL DEFAULT 0, `SpecialIconConditionID` int(10) unsigned NOT NULL DEFAULT 0, `VisibilityConditionID` int(10) unsigned NOT NULL DEFAULT 0, `MountCreatureID1` int(11) NOT NULL DEFAULT 0, `MountCreatureID2` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `taxi_nodes_locale` -- DROP TABLE IF EXISTS `taxi_nodes_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `taxi_nodes_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `taxi_path` -- DROP TABLE IF EXISTS `taxi_path`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `taxi_path` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `FromTaxiNode` smallint(5) unsigned NOT NULL DEFAULT 0, `ToTaxiNode` smallint(5) unsigned NOT NULL DEFAULT 0, `Cost` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `taxi_path_node` -- DROP TABLE IF EXISTS `taxi_path_node`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `taxi_path_node` ( `LocX` float NOT NULL DEFAULT 0, `LocY` float NOT NULL DEFAULT 0, `LocZ` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `PathID` smallint(5) unsigned NOT NULL DEFAULT 0, `NodeIndex` int(11) NOT NULL DEFAULT 0, `ContinentID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `Delay` int(10) unsigned NOT NULL DEFAULT 0, `ArrivalEventID` int(11) NOT NULL DEFAULT 0, `DepartureEventID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `totem_category` -- DROP TABLE IF EXISTS `totem_category`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `totem_category` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `TotemCategoryType` tinyint(3) unsigned NOT NULL DEFAULT 0, `TotemCategoryMask` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `totem_category_locale` -- DROP TABLE IF EXISTS `totem_category_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `totem_category_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `toy` -- DROP TABLE IF EXISTS `toy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `toy` ( `SourceText` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ItemID` int(11) NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `SourceTypeEnum` tinyint(4) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `toy_locale` -- DROP TABLE IF EXISTS `toy_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `toy_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `SourceText_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transmog_holiday` -- DROP TABLE IF EXISTS `transmog_holiday`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmog_holiday` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `RequiredTransmogHoliday` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transmog_set` -- DROP TABLE IF EXISTS `transmog_set`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmog_set` ( `Name` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ClassMask` int(11) NOT NULL DEFAULT 0, `TrackingQuestID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `TransmogSetGroupID` int(10) unsigned NOT NULL DEFAULT 0, `ItemNameDescriptionID` int(11) NOT NULL DEFAULT 0, `ParentTransmogSetID` smallint(5) unsigned NOT NULL DEFAULT 0, `Unknown810` tinyint(3) unsigned NOT NULL DEFAULT 0, `ExpansionID` tinyint(3) unsigned NOT NULL DEFAULT 0, `PatchID` int(11) NOT NULL DEFAULT 0, `UiOrder` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transmog_set_group` -- DROP TABLE IF EXISTS `transmog_set_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmog_set_group` ( `Name` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transmog_set_group_locale` -- DROP TABLE IF EXISTS `transmog_set_group_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmog_set_group_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transmog_set_item` -- DROP TABLE IF EXISTS `transmog_set_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmog_set_item` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `TransmogSetID` int(10) unsigned NOT NULL DEFAULT 0, `ItemModifiedAppearanceID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transmog_set_locale` -- DROP TABLE IF EXISTS `transmog_set_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transmog_set_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transport_animation` -- DROP TABLE IF EXISTS `transport_animation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transport_animation` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PosX` float NOT NULL DEFAULT 0, `PosY` float NOT NULL DEFAULT 0, `PosZ` float NOT NULL DEFAULT 0, `SequenceID` tinyint(3) unsigned NOT NULL DEFAULT 0, `TimeIndex` int(10) unsigned NOT NULL DEFAULT 0, `TransportID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transport_rotation` -- DROP TABLE IF EXISTS `transport_rotation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transport_rotation` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Rot1` float NOT NULL DEFAULT 0, `Rot2` float NOT NULL DEFAULT 0, `Rot3` float NOT NULL DEFAULT 0, `Rot4` float NOT NULL DEFAULT 0, `TimeIndex` int(10) unsigned NOT NULL DEFAULT 0, `GameObjectsID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ui_map` -- DROP TABLE IF EXISTS `ui_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ui_map` ( `Name` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ParentUiMapID` int(11) NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `System` int(11) NOT NULL DEFAULT 0, `Type` int(11) NOT NULL DEFAULT 0, `LevelRangeMin` int(10) unsigned NOT NULL DEFAULT 0, `LevelRangeMax` int(10) unsigned NOT NULL DEFAULT 0, `BountySetID` int(11) NOT NULL DEFAULT 0, `BountyDisplayLocation` int(10) unsigned NOT NULL DEFAULT 0, `VisibilityPlayerConditionID` int(11) NOT NULL DEFAULT 0, `HelpTextPosition` tinyint(4) NOT NULL DEFAULT 0, `BkgAtlasID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ui_map_assignment` -- DROP TABLE IF EXISTS `ui_map_assignment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ui_map_assignment` ( `UiMinX` float NOT NULL DEFAULT 0, `UiMinY` float NOT NULL DEFAULT 0, `UiMaxX` float NOT NULL DEFAULT 0, `UiMaxY` float NOT NULL DEFAULT 0, `Region1X` float NOT NULL DEFAULT 0, `Region1Y` float NOT NULL DEFAULT 0, `Region1Z` float NOT NULL DEFAULT 0, `Region2X` float NOT NULL DEFAULT 0, `Region2Y` float NOT NULL DEFAULT 0, `Region2Z` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `UiMapID` int(11) NOT NULL DEFAULT 0, `OrderIndex` int(11) NOT NULL DEFAULT 0, `MapID` int(11) NOT NULL DEFAULT 0, `AreaID` int(11) NOT NULL DEFAULT 0, `WmoDoodadPlacementID` int(11) NOT NULL DEFAULT 0, `WmoGroupID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ui_map_link` -- DROP TABLE IF EXISTS `ui_map_link`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ui_map_link` ( `UiMinX` float NOT NULL DEFAULT 0, `UiMinY` float NOT NULL DEFAULT 0, `UiMaxX` float NOT NULL DEFAULT 0, `UiMaxY` float NOT NULL DEFAULT 0, `ID` int(10) unsigned NOT NULL DEFAULT 0, `ParentUiMapID` int(11) NOT NULL DEFAULT 0, `OrderIndex` int(11) NOT NULL DEFAULT 0, `ChildUiMapID` int(11) NOT NULL DEFAULT 0, `OverrideHighlightFileDataID` int(11) NOT NULL DEFAULT 0, `OverrideHighlightAtlasID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ui_map_locale` -- DROP TABLE IF EXISTS `ui_map_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ui_map_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `ui_map_x_map_art` -- DROP TABLE IF EXISTS `ui_map_x_map_art`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ui_map_x_map_art` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `PhaseID` int(11) NOT NULL DEFAULT 0, `UiMapArtID` int(11) NOT NULL DEFAULT 0, `UiMapID` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `unit_power_bar` -- DROP TABLE IF EXISTS `unit_power_bar`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `unit_power_bar` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Name` text DEFAULT NULL, `Cost` text DEFAULT NULL, `OutOfError` text DEFAULT NULL, `ToolTip` text DEFAULT NULL, `MinPower` int(10) unsigned NOT NULL DEFAULT 0, `MaxPower` int(10) unsigned NOT NULL DEFAULT 0, `StartPower` smallint(5) unsigned NOT NULL DEFAULT 0, `CenterPower` tinyint(3) unsigned NOT NULL DEFAULT 0, `RegenerationPeace` float NOT NULL DEFAULT 0, `RegenerationCombat` float NOT NULL DEFAULT 0, `BarType` tinyint(3) unsigned NOT NULL DEFAULT 0, `Flags` smallint(5) unsigned NOT NULL DEFAULT 0, `StartInset` float NOT NULL DEFAULT 0, `EndInset` float NOT NULL DEFAULT 0, `FileDataID1` int(11) NOT NULL DEFAULT 0, `FileDataID2` int(11) NOT NULL DEFAULT 0, `FileDataID3` int(11) NOT NULL DEFAULT 0, `FileDataID4` int(11) NOT NULL DEFAULT 0, `FileDataID5` int(11) NOT NULL DEFAULT 0, `FileDataID6` int(11) NOT NULL DEFAULT 0, `Color1` int(11) NOT NULL DEFAULT 0, `Color2` int(11) NOT NULL DEFAULT 0, `Color3` int(11) NOT NULL DEFAULT 0, `Color4` int(11) NOT NULL DEFAULT 0, `Color5` int(11) NOT NULL DEFAULT 0, `Color6` int(11) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `unit_power_bar_locale` -- DROP TABLE IF EXISTS `unit_power_bar_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `unit_power_bar_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `Name_lang` text DEFAULT NULL, `Cost_lang` text DEFAULT NULL, `OutOfError_lang` text DEFAULT NULL, `ToolTip_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `updates` -- DROP TABLE IF EXISTS `updates`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `updates` ( `name` varchar(200) NOT NULL COMMENT 'filename with extension of the update.', `hash` char(40) DEFAULT '' COMMENT 'sha1 hash of the sql file.', `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if an update is released or archived.', `timestamp` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'timestamp when the query was applied.', `speed` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'time the query takes to apply in ms.', PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of all applied updates in this database.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `updates_include` -- DROP TABLE IF EXISTS `updates_include`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `updates_include` ( `path` varchar(200) NOT NULL COMMENT 'directory to include. $ means relative to the source directory.', `state` enum('RELEASED','ARCHIVED') NOT NULL DEFAULT 'RELEASED' COMMENT 'defines if the directory contains released or archived updates.', PRIMARY KEY (`path`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='List of directories where we want to include sql updates.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle` -- DROP TABLE IF EXISTS `vehicle`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `FlagsB` tinyint(3) unsigned NOT NULL DEFAULT 0, `TurnSpeed` float NOT NULL DEFAULT 0, `PitchSpeed` float NOT NULL DEFAULT 0, `PitchMin` float NOT NULL DEFAULT 0, `PitchMax` float NOT NULL DEFAULT 0, `MouseLookOffsetPitch` float NOT NULL DEFAULT 0, `CameraFadeDistScalarMin` float NOT NULL DEFAULT 0, `CameraFadeDistScalarMax` float NOT NULL DEFAULT 0, `CameraPitchOffset` float NOT NULL DEFAULT 0, `FacingLimitRight` float NOT NULL DEFAULT 0, `FacingLimitLeft` float NOT NULL DEFAULT 0, `CameraYawOffset` float NOT NULL DEFAULT 0, `UiLocomotionType` tinyint(3) unsigned NOT NULL DEFAULT 0, `VehicleUIIndicatorID` smallint(5) unsigned NOT NULL DEFAULT 0, `MissileTargetingID` int(11) NOT NULL DEFAULT 0, `SeatID1` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID2` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID3` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID4` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID5` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID6` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID7` smallint(5) unsigned NOT NULL DEFAULT 0, `SeatID8` smallint(5) unsigned NOT NULL DEFAULT 0, `PowerDisplayID1` smallint(5) unsigned NOT NULL DEFAULT 0, `PowerDisplayID2` smallint(5) unsigned NOT NULL DEFAULT 0, `PowerDisplayID3` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle_seat` -- DROP TABLE IF EXISTS `vehicle_seat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle_seat` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `AttachmentOffsetX` float NOT NULL DEFAULT 0, `AttachmentOffsetY` float NOT NULL DEFAULT 0, `AttachmentOffsetZ` float NOT NULL DEFAULT 0, `CameraOffsetX` float NOT NULL DEFAULT 0, `CameraOffsetY` float NOT NULL DEFAULT 0, `CameraOffsetZ` float NOT NULL DEFAULT 0, `Flags` int(11) NOT NULL DEFAULT 0, `FlagsB` int(11) NOT NULL DEFAULT 0, `FlagsC` int(11) NOT NULL DEFAULT 0, `AttachmentID` tinyint(4) NOT NULL DEFAULT 0, `EnterPreDelay` float NOT NULL DEFAULT 0, `EnterSpeed` float NOT NULL DEFAULT 0, `EnterGravity` float NOT NULL DEFAULT 0, `EnterMinDuration` float NOT NULL DEFAULT 0, `EnterMaxDuration` float NOT NULL DEFAULT 0, `EnterMinArcHeight` float NOT NULL DEFAULT 0, `EnterMaxArcHeight` float NOT NULL DEFAULT 0, `EnterAnimStart` int(11) NOT NULL DEFAULT 0, `EnterAnimLoop` int(11) NOT NULL DEFAULT 0, `RideAnimStart` int(11) NOT NULL DEFAULT 0, `RideAnimLoop` int(11) NOT NULL DEFAULT 0, `RideUpperAnimStart` int(11) NOT NULL DEFAULT 0, `RideUpperAnimLoop` int(11) NOT NULL DEFAULT 0, `ExitPreDelay` float NOT NULL DEFAULT 0, `ExitSpeed` float NOT NULL DEFAULT 0, `ExitGravity` float NOT NULL DEFAULT 0, `ExitMinDuration` float NOT NULL DEFAULT 0, `ExitMaxDuration` float NOT NULL DEFAULT 0, `ExitMinArcHeight` float NOT NULL DEFAULT 0, `ExitMaxArcHeight` float NOT NULL DEFAULT 0, `ExitAnimStart` int(11) NOT NULL DEFAULT 0, `ExitAnimLoop` int(11) NOT NULL DEFAULT 0, `ExitAnimEnd` int(11) NOT NULL DEFAULT 0, `VehicleEnterAnim` smallint(6) NOT NULL DEFAULT 0, `VehicleEnterAnimBone` tinyint(4) NOT NULL DEFAULT 0, `VehicleExitAnim` smallint(6) NOT NULL DEFAULT 0, `VehicleExitAnimBone` tinyint(4) NOT NULL DEFAULT 0, `VehicleRideAnimLoop` smallint(6) NOT NULL DEFAULT 0, `VehicleRideAnimLoopBone` tinyint(4) NOT NULL DEFAULT 0, `PassengerAttachmentID` tinyint(4) NOT NULL DEFAULT 0, `PassengerYaw` float NOT NULL DEFAULT 0, `PassengerPitch` float NOT NULL DEFAULT 0, `PassengerRoll` float NOT NULL DEFAULT 0, `VehicleEnterAnimDelay` float NOT NULL DEFAULT 0, `VehicleExitAnimDelay` float NOT NULL DEFAULT 0, `VehicleAbilityDisplay` tinyint(4) NOT NULL DEFAULT 0, `EnterUISoundID` int(10) unsigned NOT NULL DEFAULT 0, `ExitUISoundID` int(10) unsigned NOT NULL DEFAULT 0, `UiSkinFileDataID` int(11) NOT NULL DEFAULT 0, `CameraEnteringDelay` float NOT NULL DEFAULT 0, `CameraEnteringDuration` float NOT NULL DEFAULT 0, `CameraExitingDelay` float NOT NULL DEFAULT 0, `CameraExitingDuration` float NOT NULL DEFAULT 0, `CameraPosChaseRate` float NOT NULL DEFAULT 0, `CameraFacingChaseRate` float NOT NULL DEFAULT 0, `CameraEnteringZoom` float NOT NULL DEFAULT 0, `CameraSeatZoomMin` float NOT NULL DEFAULT 0, `CameraSeatZoomMax` float NOT NULL DEFAULT 0, `EnterAnimKitID` smallint(6) NOT NULL DEFAULT 0, `RideAnimKitID` smallint(6) NOT NULL DEFAULT 0, `ExitAnimKitID` smallint(6) NOT NULL DEFAULT 0, `VehicleEnterAnimKitID` smallint(6) NOT NULL DEFAULT 0, `VehicleRideAnimKitID` smallint(6) NOT NULL DEFAULT 0, `VehicleExitAnimKitID` smallint(6) NOT NULL DEFAULT 0, `CameraModeID` smallint(6) NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wmo_area_table` -- DROP TABLE IF EXISTS `wmo_area_table`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wmo_area_table` ( `AreaName` text DEFAULT NULL, `ID` int(10) unsigned NOT NULL DEFAULT 0, `WmoID` smallint(5) unsigned NOT NULL DEFAULT 0, `NameSetID` tinyint(3) unsigned NOT NULL DEFAULT 0, `WmoGroupID` int(11) NOT NULL DEFAULT 0, `SoundProviderPref` tinyint(3) unsigned NOT NULL DEFAULT 0, `SoundProviderPrefUnderwater` tinyint(3) unsigned NOT NULL DEFAULT 0, `AmbienceID` smallint(5) unsigned NOT NULL DEFAULT 0, `UwAmbience` smallint(5) unsigned NOT NULL DEFAULT 0, `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT 0, `UwZoneMusic` int(10) unsigned NOT NULL DEFAULT 0, `IntroSound` smallint(5) unsigned NOT NULL DEFAULT 0, `UwIntroSound` smallint(5) unsigned NOT NULL DEFAULT 0, `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT 0, `Flags` tinyint(3) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `wmo_area_table_locale` -- DROP TABLE IF EXISTS `wmo_area_table_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `wmo_area_table_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `AreaName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `world_effect` -- DROP TABLE IF EXISTS `world_effect`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `world_effect` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `QuestFeedbackEffectID` int(10) unsigned NOT NULL DEFAULT 0, `WhenToDisplay` tinyint(3) unsigned NOT NULL DEFAULT 0, `TargetType` tinyint(4) NOT NULL DEFAULT 0, `TargetAsset` int(11) NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `CombatConditionID` smallint(5) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `world_map_overlay` -- DROP TABLE IF EXISTS `world_map_overlay`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `world_map_overlay` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `UiMapArtID` int(10) unsigned NOT NULL DEFAULT 0, `TextureWidth` smallint(5) unsigned NOT NULL DEFAULT 0, `TextureHeight` smallint(5) unsigned NOT NULL DEFAULT 0, `OffsetX` int(11) NOT NULL DEFAULT 0, `OffsetY` int(11) NOT NULL DEFAULT 0, `HitRectTop` int(11) NOT NULL DEFAULT 0, `HitRectBottom` int(11) NOT NULL DEFAULT 0, `HitRectLeft` int(11) NOT NULL DEFAULT 0, `HitRectRight` int(11) NOT NULL DEFAULT 0, `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT 0, `Flags` int(10) unsigned NOT NULL DEFAULT 0, `AreaID1` int(10) unsigned NOT NULL DEFAULT 0, `AreaID2` int(10) unsigned NOT NULL DEFAULT 0, `AreaID3` int(10) unsigned NOT NULL DEFAULT 0, `AreaID4` int(10) unsigned NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `world_safe_locs` -- DROP TABLE IF EXISTS `world_safe_locs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `world_safe_locs` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `AreaName` text DEFAULT NULL, `LocX` float NOT NULL DEFAULT 0, `LocY` float NOT NULL DEFAULT 0, `LocZ` float NOT NULL DEFAULT 0, `MapID` smallint(5) unsigned NOT NULL DEFAULT 0, `Facing` float NOT NULL DEFAULT 0, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `world_safe_locs_locale` -- DROP TABLE IF EXISTS `world_safe_locs_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `world_safe_locs_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT 0, `locale` varchar(4) NOT NULL, `AreaName_lang` text DEFAULT NULL, `VerifiedBuild` smallint(6) NOT NULL DEFAULT 0, PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-07-15 16:01:18