diff options
Diffstat (limited to 'sql/base/dev/hotfixes_database.sql')
| -rw-r--r-- | sql/base/dev/hotfixes_database.sql | 4422 |
1 files changed, 3675 insertions, 747 deletions
diff --git a/sql/base/dev/hotfixes_database.sql b/sql/base/dev/hotfixes_database.sql index 2e9d18d05ed..fd6ddee9266 100644 --- a/sql/base/dev/hotfixes_database.sql +++ b/sql/base/dev/hotfixes_database.sql @@ -1,8 +1,8 @@ --- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) +-- MySQL dump 10.16 Distrib 10.1.6-MariaDB, for Win64 (AMD64) -- --- Host: localhost Database: hotfixes +-- Host: localhost Database: hotfixes6 -- ------------------------------------------------------ --- Server version 5.6.9-rc +-- Server version 5.7.14-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -23,21 +23,21 @@ DROP TABLE IF EXISTS `achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Faction` int(11) NOT NULL DEFAULT '0', - `MapID` int(11) NOT NULL DEFAULT '0', - `Supercedes` int(10) unsigned NOT NULL DEFAULT '0', `Title` text, `Description` text, - `Category` int(10) unsigned NOT NULL DEFAULT '0', - `Points` int(10) unsigned NOT NULL DEFAULT '0', - `UIOrder` int(10) unsigned NOT NULL DEFAULT '0', `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `IconID` int(10) unsigned NOT NULL DEFAULT '0', `Reward` text, - `MinimumCriteria` int(10) unsigned NOT NULL DEFAULT '0', - `SharesCriteria` int(10) unsigned NOT NULL DEFAULT '0', - `CriteriaTree` int(10) unsigned NOT NULL DEFAULT '0', + `MapID` smallint(6) NOT NULL DEFAULT '0', + `Supercedes` smallint(5) unsigned NOT NULL DEFAULT '0', + `Category` smallint(5) unsigned NOT NULL DEFAULT '0', + `UIOrder` smallint(5) unsigned NOT NULL DEFAULT '0', + `IconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SharesCriteria` smallint(5) unsigned NOT NULL DEFAULT '0', + `CriteriaTree` smallint(5) unsigned NOT NULL DEFAULT '0', + `Faction` tinyint(4) NOT NULL DEFAULT '0', + `Points` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinimumCriteria` tinyint(3) unsigned 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; @@ -62,6 +62,23 @@ CREATE TABLE `achievement_locale` ( /*!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 `area_group_member` -- @@ -70,8 +87,8 @@ DROP TABLE IF EXISTS `area_group_member`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `area_group_member` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `AreaGroupID` int(10) unsigned NOT NULL DEFAULT '0', - `AreaID` int(10) unsigned NOT NULL DEFAULT '0', + `AreaGroupID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -124,6 +141,328 @@ CREATE TABLE `area_poi_state` ( /*!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', + `Flags1` int(10) unsigned NOT NULL DEFAULT '0', + `Flags2` int(10) unsigned NOT NULL DEFAULT '0', + `ZoneName` text, + `AmbientMultiplier` float NOT NULL DEFAULT '0', + `AreaName` text, + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ParentAreaID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AreaBit` smallint(6) NOT NULL DEFAULT '0', + `AmbienceID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0', + `IntroSound` smallint(5) unsigned 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', + `UWZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0', + `UWAmbience` smallint(5) unsigned NOT NULL DEFAULT '0', + `PvPCombatWorldStateID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SoundProviderPref` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundProviderPrefUnderwater` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ExplorationLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FactionGroupMask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MountFlags` tinyint(3) unsigned 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', + `UWIntroSound` 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 `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, + `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', + `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', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseGroupID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ShapeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AreaTriggerActionSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ShapeType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flag` tinyint(3) unsigned 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 `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', + `Modifier1` float NOT NULL DEFAULT '0', + `Modifier2` float NOT NULL DEFAULT '0', + `Modifier3` float NOT NULL DEFAULT '0', + `Modifier4` float NOT NULL DEFAULT '0', + `Modifier5` 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` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `BarConnectedColor` int(10) unsigned NOT NULL DEFAULT '0', + `BarDisconnectedColor` int(10) unsigned NOT NULL DEFAULT '0', + `TitleColor` int(10) unsigned NOT NULL DEFAULT '0', + `ClassUiTextureKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SpecID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ArtifactCategoryID` 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 `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, + `SwatchColor` int(10) unsigned NOT NULL DEFAULT '0', + `ModelDesaturation` float NOT NULL DEFAULT '0', + `ModelAlpha` float NOT NULL DEFAULT '0', + `ShapeshiftDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `ArtifactAppearanceSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Unknown` smallint(5) unsigned NOT NULL DEFAULT '0', + `DisplayIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AppearanceModID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ModifiesShapeshiftFormDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemAppearanceID` int(10) unsigned NOT NULL DEFAULT '0', + `AltItemAppearanceID` 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, + `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, + `Name2` text, + `UiCameraID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AltHandUICameraID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DisplayIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AttachmentPoint` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned 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 `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, + `Name2_lang` text, + `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', + `ArtifactKnowledgeCurrencyID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ArtifactKnowledgeMultiplierCurveID` 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_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, + `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` ( + `PosX` float NOT NULL DEFAULT '0', + `PosY` float NOT NULL DEFAULT '0', + `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RelicType` 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 `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', + `FromArtifactPowerID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ToArtifactPowerID` 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_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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `Value` float NOT NULL DEFAULT '0', + `ArtifactPowerID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Unknown` smallint(5) unsigned NOT NULL DEFAULT '0', + `Rank` 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_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', + `Exp1` int(10) unsigned NOT NULL DEFAULT '0', + `Exp2` int(10) unsigned NOT NULL DEFAULT '0', + `Exp3` int(10) unsigned NOT NULL DEFAULT '0', + `Exp4` int(10) unsigned NOT NULL DEFAULT '0', + `Exp5` int(10) unsigned NOT NULL DEFAULT '0', + `Exp6` int(10) unsigned NOT NULL DEFAULT '0', + `Exp7` int(10) unsigned NOT NULL DEFAULT '0', + `Exp8` int(10) unsigned NOT NULL DEFAULT '0', + `Exp9` int(10) unsigned NOT NULL DEFAULT '0', + `Exp10` 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 `auction_house` -- @@ -132,10 +471,10 @@ DROP TABLE IF EXISTS `auction_house`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auction_house` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `FactionID` int(10) unsigned NOT NULL DEFAULT '0', - `DepositRate` int(10) unsigned NOT NULL DEFAULT '0', - `ConsignmentRate` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, + `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; @@ -158,6 +497,38 @@ CREATE TABLE `auction_house_locale` ( /*!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, + `Version` text, + `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` -- @@ -165,14 +536,14 @@ 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` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Type` int(10) unsigned NOT NULL DEFAULT '0', `DisplayName` text, `Description` text, `CostModifier` float NOT NULL DEFAULT '0', - `Race` int(10) unsigned NOT NULL DEFAULT '0', - `Sex` int(10) unsigned NOT NULL DEFAULT '0', - `Data` int(10) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned 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', + `ID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -204,8 +575,8 @@ DROP TABLE IF EXISTS `battle_pet_breed_quality`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_breed_quality` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Quality` int(10) unsigned NOT NULL DEFAULT '0', `Modifier` float NOT NULL DEFAULT '0', + `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -220,9 +591,9 @@ DROP TABLE IF EXISTS `battle_pet_breed_state`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_breed_state` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `BreedID` int(10) unsigned NOT NULL DEFAULT '0', - `State` int(10) unsigned NOT NULL DEFAULT '0', - `Value` int(11) NOT NULL DEFAULT '0', + `Value` smallint(6) NOT NULL DEFAULT '0', + `BreedID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `State` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -236,15 +607,15 @@ 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` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', `CreatureID` int(10) unsigned NOT NULL DEFAULT '0', `IconFileID` int(10) unsigned NOT NULL DEFAULT '0', `SummonSpellID` int(10) unsigned NOT NULL DEFAULT '0', - `PetType` int(11) NOT NULL DEFAULT '0', - `Source` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `SourceText` text, `Description` text, + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `PetType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Source` tinyint(4) 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; @@ -260,8 +631,8 @@ DROP TABLE IF EXISTS `battle_pet_species_locale`; CREATE TABLE `battle_pet_species_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, - `SourceText` text, - `Description` text, + `SourceText_lang` text, + `Description_lang` text, `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -276,15 +647,76 @@ DROP TABLE IF EXISTS `battle_pet_species_state`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battle_pet_species_state` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `SpeciesID` int(10) unsigned NOT NULL DEFAULT '0', - `State` int(10) unsigned NOT NULL DEFAULT '0', `Value` int(11) NOT NULL DEFAULT '0', + `SpeciesID` smallint(5) unsigned NOT NULL DEFAULT '0', + `State` 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 `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, + `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `GameType` text, + `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', + `HolidayWorldState` smallint(5) unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `InstanceType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GroupsAllowed` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxGroupSize` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RatedPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxPlayers` 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 `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, + `GameType_lang` text, + `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` -- @@ -293,19 +725,21 @@ DROP TABLE IF EXISTS `broadcast_text`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `broadcast_text` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Language` int(11) NOT NULL DEFAULT '0', `MaleText` text, `FemaleText` text, - `EmoteID1` int(10) unsigned NOT NULL DEFAULT '0', - `EmoteID2` int(10) unsigned NOT NULL DEFAULT '0', - `EmoteID3` int(10) unsigned NOT NULL DEFAULT '0', - `EmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0', - `EmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0', - `EmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0', - `SoundID` int(10) unsigned NOT NULL DEFAULT '0', - `UnkEmoteID` int(10) unsigned NOT NULL DEFAULT '0', - `Type` int(10) unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint(5) 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', + `UnkEmoteID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Language` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundID1` int(10) unsigned NOT NULL DEFAULT '0', + `SoundID2` 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 */; @@ -328,6 +762,29 @@ CREATE TABLE `broadcast_text_locale` ( /*!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', + `TextureFileDataID1` int(10) unsigned NOT NULL DEFAULT '0', + `TextureFileDataID2` int(10) unsigned NOT NULL DEFAULT '0', + `TextureFileDataID3` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `Race` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Gender` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GenType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Color` 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_start_outfit` -- @@ -336,10 +793,6 @@ DROP TABLE IF EXISTS `char_start_outfit`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `char_start_outfit` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `RaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `ClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `GenderID` tinyint(3) unsigned NOT NULL DEFAULT '0', - `OutfitID` 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', @@ -365,13 +818,137 @@ CREATE TABLE `char_start_outfit` ( `ItemID23` int(11) NOT NULL DEFAULT '0', `ItemID24` int(11) NOT NULL DEFAULT '0', `PetDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `PetFamilyID` int(10) unsigned NOT NULL DEFAULT '0', + `RaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GenderID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OutfitID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PetFamilyID` 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', + `NameMale` text, + `NameFemale` text, + `MaskID` 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 `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, + `NameMale_lang` text, + `NameFemale_lang` text, + `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 `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', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Shortcut` text, + `FactionGroup` 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_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, + `Shortcut_lang` text, + `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` ( + `PetNameToken` text, + `Name` text, + `NameFemale` text, + `NameMale` text, + `Filename` text, + `CreateScreenFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `SelectScreenFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `LowResScreenFileDataID` 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', + `PowerType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SpellClassSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AttackPowerPerStrength` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AttackPowerPerAgility` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RangedAttackPowerPerAgility` tinyint(3) unsigned NOT NULL DEFAULT '0', + `IconFileDataID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unk1` tinyint(3) unsigned 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 `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, + `NameFemale_lang` text, + `NameMale_lang` text, + `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` -- @@ -380,14 +957,134 @@ DROP TABLE IF EXISTS `chr_classes_x_power_types`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chr_classes_x_power_types` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `ClassID` int(10) unsigned NOT NULL DEFAULT '0', - `PowerType` int(10) unsigned NOT NULL DEFAULT '0', + `ClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PowerType` 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` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `ClientPrefix` text, + `ClientFileString` text, + `Name` text, + `NameFemale` text, + `NameMale` text, + `FacialHairCustomization1` text, + `FacialHairCustomization2` text, + `HairCustomization` text, + `CreateScreenFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `SelectScreenFileDataID` int(10) unsigned 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(10) unsigned NOT NULL DEFAULT '0', + `FactionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ExplorationSoundID` smallint(5) unsigned NOT NULL DEFAULT '0', + `MaleDisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `FemaleDisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ResSicknessSpellID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SplashSoundID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CinematicSequenceID` smallint(5) unsigned NOT NULL DEFAULT '0', + `UAMaleCreatureSoundDataID` smallint(5) unsigned NOT NULL DEFAULT '0', + `UAFemaleCreatureSoundDataID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BaseLanguage` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CreatureType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `TeamID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RaceRelated` tinyint(3) unsigned NOT NULL DEFAULT '0', + `UnalteredVisualRaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CharComponentTextureLayoutID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DefaultClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `NeutralRaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemAppearanceFrameRaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CharComponentTexLayoutHiResID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HighResMaleDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `HighResFemaleDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `Unk1` int(10) unsigned NOT NULL DEFAULT '0', + `Unk2` int(10) unsigned NOT NULL DEFAULT '0', + `Unk3` 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 `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, + `NameFemale_lang` text, + `NameMale_lang` text, + `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` ( + `MasterySpellID1` int(10) unsigned NOT NULL DEFAULT '0', + `MasterySpellID2` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Name2` text, + `Description` text, + `BackgroundFile` text, + `SpellIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PetTalentType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Role` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PrimaryStatOrder` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `AnimReplacementSetID` 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 `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, + `Name2_lang` text, + `Description_lang` text, + `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_upgrade_bucket` -- @@ -445,15 +1142,15 @@ DROP TABLE IF EXISTS `cinematic_sequences`; /*!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` int(10) unsigned NOT NULL DEFAULT '0', - `Camera2` int(10) unsigned NOT NULL DEFAULT '0', - `Camera3` int(10) unsigned NOT NULL DEFAULT '0', - `Camera4` int(10) unsigned NOT NULL DEFAULT '0', - `Camera5` int(10) unsigned NOT NULL DEFAULT '0', - `Camera6` int(10) unsigned NOT NULL DEFAULT '0', - `Camera7` int(10) unsigned NOT NULL DEFAULT '0', - `Camera8` int(10) unsigned NOT NULL DEFAULT '0', + `SoundID` smallint(5) 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; @@ -468,7 +1165,6 @@ DROP TABLE IF EXISTS `creature`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Type` 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', @@ -485,8 +1181,10 @@ CREATE TABLE `creature` ( `FemaleName` text NOT NULL, `SubName` text NOT NULL, `FemaleSubName` text NOT NULL, - `Rank` mediumint(8) unsigned NOT NULL DEFAULT '0', - `InhabitType` mediumint(8) unsigned NOT NULL DEFAULT '0', + `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; @@ -502,15 +1200,17 @@ DROP TABLE IF EXISTS `creature_difficulty`; CREATE TABLE `creature_difficulty` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `CreatureID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `FactionID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Expansion` mediumint(8) NOT NULL DEFAULT '0', - `MinLevel` mediumint(8) NOT NULL DEFAULT '0', - `MaxLevel` mediumint(8) 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; @@ -525,52 +1225,152 @@ DROP TABLE IF EXISTS `creature_display_info`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_display_info` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `ModelID` int(10) unsigned NOT NULL DEFAULT '0', - `SoundID` int(10) unsigned NOT NULL DEFAULT '0', `ExtendedDisplayInfoID` int(10) unsigned NOT NULL DEFAULT '0', `CreatureModelScale` float NOT NULL DEFAULT '0', - `Unknown620` float NOT NULL DEFAULT '0', - `CreatureModelAlpha` int(10) unsigned NOT NULL DEFAULT '0', - `TextureVariation1` text, - `TextureVariation2` text, - `TextureVariation3` text, + `PlayerModelScale` float NOT NULL DEFAULT '0', + `TextureVariation1` int(10) unsigned NOT NULL DEFAULT '0', + `TextureVariation2` int(10) unsigned NOT NULL DEFAULT '0', + `TextureVariation3` int(10) unsigned NOT NULL DEFAULT '0', `PortraitTextureName` text, `PortraitCreatureDisplayInfoID` int(10) unsigned NOT NULL DEFAULT '0', - `SizeClass` int(10) unsigned NOT NULL DEFAULT '0', - `BloodID` int(10) unsigned NOT NULL DEFAULT '0', - `NPCSoundID` int(10) unsigned NOT NULL DEFAULT '0', - `ParticleColorID` int(10) unsigned NOT NULL DEFAULT '0', `CreatureGeosetData` int(10) unsigned NOT NULL DEFAULT '0', - `ObjectEffectPackageID` int(10) unsigned NOT NULL DEFAULT '0', - `AnimReplacementSetID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `Gender` int(11) NOT NULL DEFAULT '0', `StateSpellVisualKitID` int(10) unsigned NOT NULL DEFAULT '0', + `InstanceOtherPlayerPetScale` float NOT NULL DEFAULT '0', + `ModelID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SoundID` smallint(5) unsigned NOT NULL DEFAULT '0', + `NPCSoundID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ParticleColorID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ObjectEffectPackageID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AnimReplacementSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureModelAlpha` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SizeClass` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BloodID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Gender` tinyint(4) NOT NULL DEFAULT '0', + `Unk700` 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 `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', + `FileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `HDFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `DisplayRaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DisplaySexID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DisplayClassID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SkinID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FaceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HairStyleID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HairColorID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FacialHairID` tinyint(3) unsigned 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', + `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_display_info_locale` +-- Table structure for table `creature_family` -- -DROP TABLE IF EXISTS `creature_display_info_locale`; +DROP TABLE IF EXISTS `creature_family`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `creature_display_info_locale` ( +CREATE TABLE `creature_family` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `MinScale` float NOT NULL DEFAULT '0', + `MaxScale` float NOT NULL DEFAULT '0', + `Name` text, + `IconFile` text, + `SkillLine1` smallint(5) unsigned NOT NULL DEFAULT '0', + `SkillLine2` smallint(5) unsigned NOT NULL DEFAULT '0', + `PetFoodMask` smallint(5) unsigned NOT NULL DEFAULT '0', + `MinScaleLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxScaleLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PetTalentType` 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_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, - `TextureVariation_lang1` text, - `TextureVariation_lang2` text, - `TextureVariation_lang3` text, - `PortraitTextureName_lang` text, + `Name_lang` text, `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', + `ModelScale` float NOT NULL DEFAULT '0', + `FootprintTextureLength` float NOT NULL DEFAULT '0', + `FootprintTextureWidth` float NOT NULL DEFAULT '0', + `FootprintParticleScale` float NOT NULL DEFAULT '0', + `CollisionWidth` float NOT NULL DEFAULT '0', + `CollisionHeight` float NOT NULL DEFAULT '0', + `MountHeight` float NOT NULL DEFAULT '0', + `GeoBoxMin1` float NOT NULL DEFAULT '0', + `GeoBoxMin2` float NOT NULL DEFAULT '0', + `GeoBoxMin3` float NOT NULL DEFAULT '0', + `GeoBoxMax1` float NOT NULL DEFAULT '0', + `GeoBoxMax2` float NOT NULL DEFAULT '0', + `GeoBoxMax3` float NOT NULL DEFAULT '0', + `WorldEffectScale` float NOT NULL DEFAULT '0', + `AttachedEffectScale` float NOT NULL DEFAULT '0', + `MissileCollisionRadius` float NOT NULL DEFAULT '0', + `MissileCollisionPush` float NOT NULL DEFAULT '0', + `MissileCollisionRaise` 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', + `HoverHeight` float NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `FileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `SizeClass` int(10) unsigned NOT NULL DEFAULT '0', + `BloodID` int(10) unsigned NOT NULL DEFAULT '0', + `FootprintTextureID` int(10) unsigned NOT NULL DEFAULT '0', + `FoleyMaterialID` int(10) unsigned NOT NULL DEFAULT '0', + `FootstepEffectID` int(10) unsigned NOT NULL DEFAULT '0', + `DeathThudEffectID` int(10) unsigned NOT NULL DEFAULT '0', + `FootstepShakeSize` int(10) unsigned NOT NULL DEFAULT '0', + `DeathThudShakeSize` int(10) unsigned NOT NULL DEFAULT '0', + `SoundID` int(10) unsigned NOT NULL DEFAULT '0', + `CreatureGeosetDataID` 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 `creature_type` -- @@ -580,7 +1380,7 @@ DROP TABLE IF EXISTS `creature_type`; CREATE TABLE `creature_type` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `Flags` int(10) 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; @@ -611,17 +1411,17 @@ DROP TABLE IF EXISTS `criteria`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `criteria` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Type` int(10) unsigned NOT NULL DEFAULT '0', `Asset` int(10) unsigned NOT NULL DEFAULT '0', - `StartEvent` int(10) unsigned NOT NULL DEFAULT '0', `StartAsset` int(10) unsigned NOT NULL DEFAULT '0', - `StartTimer` int(10) unsigned NOT NULL DEFAULT '0', - `FailEvent` int(10) unsigned NOT NULL DEFAULT '0', `FailAsset` int(10) unsigned NOT NULL DEFAULT '0', - `ModifierTreeId` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `EligibilityWorldStateID` int(10) unsigned NOT NULL DEFAULT '0', - `EligibilityWorldStateValue` int(10) unsigned NOT NULL DEFAULT '0', + `StartTimer` smallint(5) unsigned NOT NULL DEFAULT '0', + `ModifierTreeId` smallint(5) unsigned NOT NULL DEFAULT '0', + `EligibilityWorldStateID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StartEvent` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FailEvent` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `EligibilityWorldStateValue` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -637,12 +1437,12 @@ DROP TABLE IF EXISTS `criteria_tree`; CREATE TABLE `criteria_tree` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `CriteriaID` int(10) unsigned NOT NULL DEFAULT '0', - `Amount` bigint(20) unsigned NOT NULL DEFAULT '0', - `Operator` int(10) unsigned NOT NULL DEFAULT '0', - `Parent` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Amount` int(10) unsigned NOT NULL DEFAULT '0', `Description` text, - `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', + `Parent` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `Operator` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OrderIndex` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -673,17 +1473,17 @@ DROP TABLE IF EXISTS `currency_types`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `currency_types` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `CategoryID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, `InventoryIcon1` text, `InventoryIcon2` text, - `SpellWeight` int(10) unsigned NOT NULL DEFAULT '0', - `SpellCategory` int(10) 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` int(10) unsigned NOT NULL DEFAULT '0', `Description` text, + `CategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SpellCategory` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SpellWeight` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -700,8 +1500,6 @@ CREATE TABLE `currency_types_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, `Name_lang` text, - `InventoryIcon1_lang` text, - `InventoryIcon2_lang` text, `Description_lang` text, `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) @@ -709,6 +1507,22 @@ CREATE TABLE `currency_types_locale` ( /*!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', + `Unused` 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` -- @@ -717,10 +1531,10 @@ DROP TABLE IF EXISTS `curve_point`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `curve_point` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `CurveID` int(10) unsigned NOT NULL DEFAULT '0', - `Index` int(10) unsigned NOT NULL DEFAULT '0', `X` float NOT NULL DEFAULT '0', `Y` float NOT NULL DEFAULT '0', + `CurveID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Index` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -735,29 +1549,152 @@ DROP TABLE IF EXISTS `destructible_model_data`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `destructible_model_data` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `StateDamagedDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `StateDamagedImpactEffectDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateDamagedAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateDamagedNameSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateDestroyedDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `StateDestroyedDestructionDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateDestroyedImpactEffectDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateDestroyedAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateDestroyedNameSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateRebuildingDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `StateRebuildingDestructionDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateRebuildingImpactEffectDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateRebuildingAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateRebuildingNameSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateSmokeDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `StateSmokeInitDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateSmokeAmbientDoodadSet` int(10) unsigned NOT NULL DEFAULT '0', - `StateSmokeNameSet` int(10) unsigned NOT NULL DEFAULT '0', - `EjectDirection` int(10) unsigned NOT NULL DEFAULT '0', - `RepairGroundFx` int(10) unsigned NOT NULL DEFAULT '0', - `DoNotHighlight` int(10) unsigned NOT NULL DEFAULT '0', - `HealEffect` int(10) unsigned NOT NULL DEFAULT '0', - `HealEffectSpeed` int(10) unsigned NOT NULL DEFAULT '0', + `StateDamagedDisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `StateDestroyedDisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `StateRebuildingDisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `StateSmokeDisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `HealEffectSpeed` smallint(5) unsigned NOT NULL DEFAULT '0', + `StateDamagedImpactEffectDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateDamagedAmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateDamagedNameSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateDestroyedDestructionDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateDestroyedImpactEffectDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateDestroyedAmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateDestroyedNameSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateRebuildingDestructionDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateRebuildingImpactEffectDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateRebuildingAmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateRebuildingNameSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateSmokeInitDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateSmokeAmbientDoodadSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `StateSmokeNameSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `EjectDirection` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DoNotHighlight` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HealEffect` 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 `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, + `FallbackDifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `InstanceType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OldEnumValue` tinyint(4) NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ToggleDifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GroupSizeHealthCurveID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GroupSizeDmgCurveID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GroupSizeSpellPointsCurveID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemBonusTreeModID` 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 `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, + `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` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `CreatureDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SpellIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Bit` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OrderIndex` 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, + `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; @@ -779,39 +1716,193 @@ CREATE TABLE `durability_quality` ( /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `game_tables` +-- Table structure for table `emotes` -- -DROP TABLE IF EXISTS `game_tables`; +DROP TABLE IF EXISTS `emotes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `game_tables` ( +CREATE TABLE `emotes` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Name` text NOT NULL, - `NumRows` int(10) unsigned NOT NULL DEFAULT '0', - `NumColumns` int(10) unsigned NOT NULL DEFAULT '0', - `VerifiedBuild` smallint(5) NOT NULL, + `EmoteSlashCommand` text, + `SpellVisualKitID` int(10) unsigned NOT NULL DEFAULT '0', + `EmoteFlags` int(10) unsigned NOT NULL DEFAULT '0', + `AnimID` smallint(5) unsigned NOT NULL DEFAULT '0', + `EmoteSpecProc` tinyint(3) unsigned NOT NULL DEFAULT '0', + `EmoteSpecProcParam` int(10) unsigned NOT NULL DEFAULT '0', + `EmoteSoundID` int(10) unsigned NOT NULL DEFAULT '0', + `ClassMask` int(11) NOT NULL DEFAULT '0', + `RaceMask` int(11) NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; +) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- --- Table structure for table `game_tables_locale` +-- Table structure for table `emotes_text` -- -DROP TABLE IF EXISTS `game_tables_locale`; +DROP TABLE IF EXISTS `emotes_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `game_tables_locale` ( +CREATE TABLE `emotes_text` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `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_locale` +-- + +DROP TABLE IF EXISTS `emotes_text_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `emotes_text_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, - `Name_lang` text NOT NULL, + `Name_lang` text, `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 `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', + `EmotesTextId` smallint(5) unsigned NOT NULL DEFAULT '0', + `RaceId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SexId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ClassId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundId` 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 `faction` +-- + +DROP TABLE IF EXISTS `faction`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `faction` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationRaceMask1` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationRaceMask2` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationRaceMask3` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationRaceMask4` int(10) 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', + `ParentFactionModIn` float NOT NULL DEFAULT '0', + `ParentFactionModOut` float NOT NULL DEFAULT '0', + `Name` text, + `Description` text, + `ReputationMax1` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationMax2` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationMax3` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationMax4` int(10) unsigned NOT NULL DEFAULT '0', + `ReputationIndex` smallint(6) NOT NULL DEFAULT '0', + `ReputationClassMask1` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReputationClassMask2` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReputationClassMask3` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReputationClassMask4` smallint(5) unsigned 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', + `ParentFactionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ParentFactionCapIn` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ParentFactionCapOut` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Expansion` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FriendshipRepID` 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, + `Description_lang` text, + `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', + `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', + `Friends1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Friends2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Friends3` smallint(5) unsigned NOT NULL DEFAULT '0', + `Friends4` smallint(5) unsigned NOT NULL DEFAULT '0', + `Mask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FriendMask` tinyint(3) unsigned NOT NULL DEFAULT '0', + `EnemyMask` 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 `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', + `FileDataID` 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', + `OverrideLootEffectScale` float NOT NULL DEFAULT '0', + `OverrideNameScale` float NOT NULL DEFAULT '0', + `ObjectEffectPackageID` 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 `gameobjects` -- @@ -819,9 +1910,6 @@ DROP TABLE IF EXISTS `gameobjects`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobjects` ( - `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `MapID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `DisplayID` mediumint(8) unsigned NOT NULL DEFAULT '0', `PositionX` float NOT NULL DEFAULT '0', `PositionY` float NOT NULL DEFAULT '0', `PositionZ` float NOT NULL DEFAULT '0', @@ -830,20 +1918,23 @@ CREATE TABLE `gameobjects` ( `RotationZ` float NOT NULL DEFAULT '0', `RotationW` float NOT NULL DEFAULT '0', `Size` float NOT NULL DEFAULT '0', - `PhaseUseFlags` mediumint(8) unsigned NOT NULL DEFAULT '0', - `PhaseID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `PhaseGroupID` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Type` mediumint(8) unsigned NOT NULL DEFAULT '0', - `Data0` int(10) NOT NULL DEFAULT '0', - `Data1` int(10) NOT NULL DEFAULT '0', - `Data2` int(10) NOT NULL DEFAULT '0', - `Data3` int(10) NOT NULL DEFAULT '0', - `Data4` int(10) NOT NULL DEFAULT '0', - `Data5` int(10) NOT NULL DEFAULT '0', - `Data6` int(10) NOT NULL DEFAULT '0', - `Data7` int(10) NOT NULL DEFAULT '0', - `Name` text NOT NULL, - `VerifiedBuild` smallint(5) NOT NULL DEFAULT '0', + `Data1` int(11) NOT NULL DEFAULT '0', + `Data2` int(11) NOT NULL DEFAULT '0', + `Data3` int(11) NOT NULL DEFAULT '0', + `Data4` int(11) NOT NULL DEFAULT '0', + `Data5` int(11) NOT NULL DEFAULT '0', + `Data6` int(11) NOT NULL DEFAULT '0', + `Data7` int(11) NOT NULL DEFAULT '0', + `Data8` int(11) NOT NULL DEFAULT '0', + `Name` text, + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DisplayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseGroupID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned 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 */; @@ -872,14 +1963,14 @@ DROP TABLE IF EXISTS `garr_ability`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_ability` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, `Description` text, `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', - `OtherFactionGarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrAbilityCategoryID` int(10) unsigned NOT NULL DEFAULT '0', - `FollowerTypeID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `OtherFactionGarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT '0', + `GarrAbilityCategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FollowerTypeID` tinyint(3) unsigned 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; @@ -913,27 +2004,28 @@ CREATE TABLE `garr_building` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `HordeGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', `AllianceGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', - `Unknown` int(10) unsigned NOT NULL DEFAULT '0', - `Type` int(10) unsigned NOT NULL DEFAULT '0', - `Level` int(10) unsigned NOT NULL DEFAULT '0', `NameAlliance` text, `NameHorde` text, `Description` text, `Tooltip` text, - `BuildDuration` int(10) unsigned NOT NULL DEFAULT '0', - `CostCurrencyID` int(10) unsigned NOT NULL DEFAULT '0', - `CostCurrencyAmount` int(11) NOT NULL DEFAULT '0', - `HordeTexPrefixKitID` int(10) unsigned NOT NULL DEFAULT '0', - `AllianceTexPrefixKitID` int(10) unsigned NOT NULL DEFAULT '0', `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', - `BonusAmount` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `AllianceActivationScenePackageID` int(10) unsigned NOT NULL DEFAULT '0', - `HordeActivationScenePackageID` int(10) unsigned NOT NULL DEFAULT '0', - `MaxShipments` int(10) unsigned NOT NULL DEFAULT '0', - `FollowerRequiredGarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0', - `FollowerGarrAbilityEffectID` int(10) unsigned NOT NULL DEFAULT '0', - `CostMoney` int(11) NOT NULL DEFAULT '0', + `CostCurrencyID` smallint(5) unsigned NOT NULL DEFAULT '0', + `HordeTexPrefixKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllianceTexPrefixKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllianceActivationScenePackageID` smallint(5) unsigned NOT NULL DEFAULT '0', + `HordeActivationScenePackageID` smallint(5) unsigned NOT NULL DEFAULT '0', + `FollowerRequiredGarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT '0', + `FollowerGarrAbilityEffectID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CostMoney` smallint(6) NOT NULL DEFAULT '0', + `Unknown` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxShipments` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BuildDuration` int(11) NOT NULL DEFAULT '0', + `CostCurrencyAmount` int(11) NOT NULL DEFAULT '0', + `BonusAmount` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -966,12 +2058,12 @@ 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` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrBuildingID` int(10) unsigned NOT NULL DEFAULT '0', - `UiTextureAtlasMemberID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrSiteLevelPlotInstID` int(10) unsigned NOT NULL DEFAULT '0', `LandmarkOffsetX` float NOT NULL DEFAULT '0', `LandmarkOffsetY` float NOT NULL DEFAULT '0', + `UiTextureAtlasMemberID` smallint(5) unsigned NOT NULL DEFAULT '0', + `GarrSiteLevelPlotInstID` smallint(5) unsigned NOT NULL DEFAULT '0', + `GarrBuildingID` tinyint(3) unsigned 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; @@ -985,12 +2077,14 @@ 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` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', `NameMale` text, `NameFemale` text, `NameGenderless` text, - `ClassAtlasID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrFollItemSetID` int(10) unsigned NOT NULL DEFAULT '0', + `ClassAtlasID` smallint(5) unsigned NOT NULL DEFAULT '0', + `GarrFollItemSetID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Limit` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned 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; @@ -1022,30 +2116,37 @@ DROP TABLE IF EXISTS `garr_follower`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_follower` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `FollowerTypeID` int(10) unsigned NOT NULL DEFAULT '0', `HordeCreatureID` int(10) unsigned NOT NULL DEFAULT '0', `AllianceCreatureID` int(10) unsigned NOT NULL DEFAULT '0', - `HordeUiAnimRaceInfoID` int(10) unsigned NOT NULL DEFAULT '0', - `AllianceUiAnimRaceInfoID` int(10) unsigned NOT NULL DEFAULT '0', - `Quality` int(10) unsigned NOT NULL DEFAULT '0', - `HordeGarrClassSpecID` int(10) unsigned NOT NULL DEFAULT '0', - `AllianceGarrClassSpecID` int(10) unsigned NOT NULL DEFAULT '0', - `HordeGarrFollItemSetID` int(10) unsigned NOT NULL DEFAULT '0', - `AllianceGarrFollItemSetID` int(10) unsigned NOT NULL DEFAULT '0', - `Level` int(10) unsigned NOT NULL DEFAULT '0', - `ItemLevelWeapon` int(10) unsigned NOT NULL DEFAULT '0', - `ItemLevelArmor` int(10) unsigned NOT NULL DEFAULT '0', - `Unknown1` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `HordeSourceText` text, `AllianceSourceText` text, - `Unknown2` int(11) NOT NULL DEFAULT '0', - `Unknown3` int(11) NOT NULL DEFAULT '0', `HordePortraitIconID` int(10) unsigned NOT NULL DEFAULT '0', `AlliancePortraitIconID` int(10) unsigned NOT NULL DEFAULT '0', - `HordeListPortraitTextureKitID` int(10) unsigned NOT NULL DEFAULT '0', - `AllianceListPortraitTextureKitID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeAddedBroadcastTextID` int(10) unsigned NOT NULL DEFAULT '0', + `AllianceAddedBroadcastTextID` int(10) unsigned NOT NULL DEFAULT '0', + `HordeGarrFollItemSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllianceGarrFollItemSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemLevelWeapon` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemLevelArmor` smallint(5) unsigned NOT NULL DEFAULT '0', + `HordeListPortraitTextureKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllianceListPortraitTextureKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `FollowerTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HordeUiAnimRaceInfoID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AllianceUiAnimRaceInfoID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HordeGarrClassSpecID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AllianceGarrClassSpecID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unknown1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unknown2` tinyint(4) NOT NULL DEFAULT '0', + `Unknown3` tinyint(4) NOT NULL DEFAULT '0', + `GarrTypeID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxDurability` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HordeFlavorTextGarrStringID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AllianceFlavorTextGarrStringID` tinyint(3) unsigned 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; @@ -1077,9 +2178,9 @@ DROP TABLE IF EXISTS `garr_follower_x_ability`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_follower_x_ability` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrFollowerID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrAbilityID` int(10) unsigned NOT NULL DEFAULT '0', - `FactionIndex` int(10) unsigned NOT NULL DEFAULT '0', + `GarrFollowerID` smallint(5) unsigned NOT NULL DEFAULT '0', + `GarrAbilityID` smallint(5) unsigned NOT NULL DEFAULT '0', + `FactionIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1094,14 +2195,14 @@ DROP TABLE IF EXISTS `garr_plot`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_plot` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrPlotUICategoryID` int(10) unsigned NOT NULL DEFAULT '0', - `PlotType` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `MinCount` int(10) unsigned NOT NULL DEFAULT '0', - `MaxCount` int(10) unsigned NOT NULL DEFAULT '0', `AllianceConstructionGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', `HordeConstructionGameObjectID` int(10) unsigned NOT NULL DEFAULT '0', + `GarrPlotUICategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PlotType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinCount` int(10) unsigned NOT NULL DEFAULT '0', + `MaxCount` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1116,8 +2217,8 @@ DROP TABLE IF EXISTS `garr_plot_building`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_plot_building` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrPlotID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrBuildingID` 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; @@ -1132,8 +2233,8 @@ DROP TABLE IF EXISTS `garr_plot_instance`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_plot_instance` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrPlotID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, + `GarrPlotID` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1180,16 +2281,16 @@ DROP TABLE IF EXISTS `garr_site_level`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_site_level` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Level` int(10) unsigned NOT NULL DEFAULT '0', - `MapID` int(10) unsigned NOT NULL DEFAULT '0', - `SiteID` int(10) unsigned NOT NULL DEFAULT '0', - `UITextureKitID` int(10) unsigned NOT NULL DEFAULT '0', `TownHallX` float NOT NULL DEFAULT '0', `TownHallY` float NOT NULL DEFAULT '0', - `MovieID` int(10) unsigned NOT NULL DEFAULT '0', - `Level2` int(10) unsigned NOT NULL DEFAULT '0', - `UpgradeResourceCost` int(10) unsigned NOT NULL DEFAULT '0', - `UpgradeMoneyCost` int(10) unsigned NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SiteID` smallint(5) unsigned NOT NULL DEFAULT '0', + `UpgradeResourceCost` smallint(5) unsigned NOT NULL DEFAULT '0', + `UpgradeMoneyCost` smallint(5) unsigned NOT NULL DEFAULT '0', + `Level` tinyint(3) unsigned NOT NULL DEFAULT '0', + `UITextureKitID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MovieID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Level2` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1204,27 +2305,129 @@ DROP TABLE IF EXISTS `garr_site_level_plot_inst`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `garr_site_level_plot_inst` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrSiteLevelID` int(10) unsigned NOT NULL DEFAULT '0', - `GarrPlotInstanceID` int(10) unsigned NOT NULL DEFAULT '0', `LandmarkX` float NOT NULL DEFAULT '0', `LandmarkY` float NOT NULL DEFAULT '0', - `Unknown` int(10) unsigned NOT NULL DEFAULT '0', + `GarrSiteLevelID` smallint(5) unsigned NOT NULL DEFAULT '0', + `GarrPlotInstanceID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unknown` 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 `glyph_slot` +-- Table structure for table `gem_properties` -- -DROP TABLE IF EXISTS `glyph_slot`; +DROP TABLE IF EXISTS `gem_properties`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `glyph_slot` ( +CREATE TABLE `gem_properties` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Type` int(10) unsigned NOT NULL DEFAULT '0', - `Tooltip` int(10) unsigned NOT NULL DEFAULT '0', + `EnchantID` smallint(5) unsigned 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(10) 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 `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', + `SpellIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GlyphExclusiveCategoryID` 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 `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', + `GlyphPropertiesID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ChrSpecializationID` 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', + `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 `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', + `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 `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', + `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; @@ -1239,7 +2442,6 @@ DROP TABLE IF EXISTS `guild_perk_spells`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `guild_perk_spells` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `GuildLevel` int(10) unsigned NOT NULL DEFAULT '0', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) @@ -1254,18 +2456,18 @@ DROP TABLE IF EXISTS `heirloom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `heirloom` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', `ItemID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `SourceText` text, - `Source` int(10) unsigned NOT NULL DEFAULT '0', `OldItem1` int(10) unsigned NOT NULL DEFAULT '0', `OldItem2` int(10) unsigned NOT NULL DEFAULT '0', `NextDifficultyItemID` int(10) unsigned NOT NULL DEFAULT '0', `UpgradeItemID1` int(10) unsigned NOT NULL DEFAULT '0', `UpgradeItemID2` int(10) unsigned NOT NULL DEFAULT '0', - `ItemBonusListID1` int(10) unsigned NOT NULL DEFAULT '0', - `ItemBonusListID2` int(10) unsigned NOT NULL DEFAULT '0', + `ItemBonusListID1` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemBonusListID2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Source` tinyint(3) unsigned 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; @@ -1296,16 +2498,6 @@ DROP TABLE IF EXISTS `holidays`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `holidays` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Duration1` int(10) unsigned NOT NULL DEFAULT '0', - `Duration2` int(10) unsigned NOT NULL DEFAULT '0', - `Duration3` int(10) unsigned NOT NULL DEFAULT '0', - `Duration4` int(10) unsigned NOT NULL DEFAULT '0', - `Duration5` int(10) unsigned NOT NULL DEFAULT '0', - `Duration6` int(10) unsigned NOT NULL DEFAULT '0', - `Duration7` int(10) unsigned NOT NULL DEFAULT '0', - `Duration8` int(10) unsigned NOT NULL DEFAULT '0', - `Duration9` int(10) unsigned NOT NULL DEFAULT '0', - `Duration10` int(10) 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', @@ -1322,46 +2514,40 @@ CREATE TABLE `holidays` ( `Date14` int(10) unsigned NOT NULL DEFAULT '0', `Date15` int(10) unsigned NOT NULL DEFAULT '0', `Date16` int(10) unsigned NOT NULL DEFAULT '0', - `Region` int(10) unsigned NOT NULL DEFAULT '0', - `Looping` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags1` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags2` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags3` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags4` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags5` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags6` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags7` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags8` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags9` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFlags10` int(10) unsigned NOT NULL DEFAULT '0', - `HolidayNameID` int(10) unsigned NOT NULL DEFAULT '0', - `HolidayDescriptionID` int(10) unsigned NOT NULL DEFAULT '0', `TextureFilename` text, - `Priority` int(10) unsigned NOT NULL DEFAULT '0', - `CalendarFilterType` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) 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', + `Region` smallint(5) unsigned NOT NULL DEFAULT '0', + `Looping` tinyint(3) 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', + `HolidayNameID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `HolidayDescriptionID` tinyint(3) 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', `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 `holidays_locale` --- - -DROP TABLE IF EXISTS `holidays_locale`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `holidays_locale` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `locale` varchar(4) NOT NULL, - `TextureFilename_lang` text, - `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 `hotfix_data` -- @@ -1449,14 +2635,14 @@ DROP TABLE IF EXISTS `item`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Class` int(10) unsigned NOT NULL DEFAULT '0', - `SubClass` int(10) unsigned NOT NULL DEFAULT '0', - `SoundOverrideSubclass` int(11) NOT NULL DEFAULT '0', - `Material` int(11) NOT NULL DEFAULT '0', - `InventoryType` int(10) unsigned NOT NULL DEFAULT '0', - `Sheath` int(10) unsigned NOT NULL DEFAULT '0', `FileDataID` int(10) unsigned NOT NULL DEFAULT '0', - `GroupSoundsID` int(10) unsigned NOT NULL DEFAULT '0', + `Class` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SubClass` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundOverrideSubclass` tinyint(4) NOT NULL DEFAULT '0', + `Material` tinyint(4) NOT NULL DEFAULT '0', + `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Sheath` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GroupSoundsID` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1473,12 +2659,108 @@ CREATE TABLE `item_appearance` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `DisplayID` int(10) unsigned NOT NULL DEFAULT '0', `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `UIOrder` int(10) unsigned NOT NULL DEFAULT '0', + `ObjectComponentSlot` 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_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', + `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_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', + `Value1` float NOT NULL DEFAULT '0', + `Value2` float NOT NULL DEFAULT '0', + `Value3` float NOT NULL DEFAULT '0', + `Value4` 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_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, `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, + `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` -- @@ -1487,11 +2769,26 @@ DROP TABLE IF EXISTS `item_bonus`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bonus` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `BonusListID` int(10) unsigned NOT NULL DEFAULT '0', - `Type` int(10) unsigned NOT NULL DEFAULT '0', `Value1` int(11) NOT NULL DEFAULT '0', `Value2` int(11) NOT NULL DEFAULT '0', - `Index` int(10) unsigned NOT NULL DEFAULT '0', + `BonusListID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Index` 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` ( + `Delta` 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; @@ -1506,10 +2803,27 @@ DROP TABLE IF EXISTS `item_bonus_tree_node`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_bonus_tree_node` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `BonusTreeID` int(10) unsigned NOT NULL DEFAULT '0', - `BonusTreeModID` int(10) unsigned NOT NULL DEFAULT '0', - `SubTreeID` int(10) unsigned NOT NULL DEFAULT '0', - `BonusListID` int(10) unsigned NOT NULL DEFAULT '0', + `BonusTreeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SubTreeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BonusListID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BonusTreeModID` 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_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', + `ItemID` int(10) unsigned NOT NULL DEFAULT '0', + `AltItemID` int(10) unsigned NOT NULL DEFAULT '0', + `AltEquipmentSlot` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1524,9 +2838,9 @@ DROP TABLE IF EXISTS `item_class`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_class` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `PriceMod` float NOT NULL DEFAULT '0', `Name` text, + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1559,8 +2873,117 @@ CREATE TABLE `item_currency_cost` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `ItemId` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', - PRIMARY KEY (`ID`), - UNIQUE KEY `idx_itemId` (`ItemId`) + 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', + `DPS1` float NOT NULL DEFAULT '0', + `DPS2` float NOT NULL DEFAULT '0', + `DPS3` float NOT NULL DEFAULT '0', + `DPS4` float NOT NULL DEFAULT '0', + `DPS5` float NOT NULL DEFAULT '0', + `DPS6` float NOT NULL DEFAULT '0', + `DPS7` 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_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', + `DPS1` float NOT NULL DEFAULT '0', + `DPS2` float NOT NULL DEFAULT '0', + `DPS3` float NOT NULL DEFAULT '0', + `DPS4` float NOT NULL DEFAULT '0', + `DPS5` float NOT NULL DEFAULT '0', + `DPS6` float NOT NULL DEFAULT '0', + `DPS7` 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_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', + `DPS1` float NOT NULL DEFAULT '0', + `DPS2` float NOT NULL DEFAULT '0', + `DPS3` float NOT NULL DEFAULT '0', + `DPS4` float NOT NULL DEFAULT '0', + `DPS5` float NOT NULL DEFAULT '0', + `DPS6` float NOT NULL DEFAULT '0', + `DPS7` 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_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', + `DPS1` float NOT NULL DEFAULT '0', + `DPS2` float NOT NULL DEFAULT '0', + `DPS3` float NOT NULL DEFAULT '0', + `DPS4` float NOT NULL DEFAULT '0', + `DPS5` float NOT NULL DEFAULT '0', + `DPS6` float NOT NULL DEFAULT '0', + `DPS7` 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_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', + `DPS1` float NOT NULL DEFAULT '0', + `DPS2` float NOT NULL DEFAULT '0', + `DPS3` float NOT NULL DEFAULT '0', + `DPS4` float NOT NULL DEFAULT '0', + `DPS5` float NOT NULL DEFAULT '0', + `DPS6` float NOT NULL DEFAULT '0', + `DPS7` 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 */; @@ -1573,12 +2996,12 @@ DROP TABLE IF EXISTS `item_disenchant_loot`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_disenchant_loot` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `ItemClass` int(10) unsigned NOT NULL DEFAULT '0', - `ItemSubClass` int(11) NOT NULL DEFAULT '0', - `ItemQuality` int(10) unsigned NOT NULL DEFAULT '0', - `MinItemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `MaxItemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredDisenchantSkill` int(10) unsigned NOT NULL DEFAULT '0', + `MinItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `MaxItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredDisenchantSkill` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemClass` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemSubClass` tinyint(4) NOT NULL DEFAULT '0', + `ItemQuality` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1594,14 +3017,14 @@ DROP TABLE IF EXISTS `item_effect`; CREATE TABLE `item_effect` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `ItemID` int(10) unsigned NOT NULL DEFAULT '0', - `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', - `Trigger` int(10) unsigned NOT NULL DEFAULT '0', - `Charges` int(10) unsigned NOT NULL DEFAULT '0', `Cooldown` int(11) NOT NULL DEFAULT '0', - `Category` int(10) unsigned NOT NULL DEFAULT '0', `CategoryCooldown` int(11) NOT NULL DEFAULT '0', - `ChrSpecializationID` int(10) unsigned NOT NULL DEFAULT '0', + `Charges` smallint(6) NOT NULL DEFAULT '0', + `Category` smallint(5) unsigned NOT NULL DEFAULT '0', + `ChrSpecializationID` smallint(5) unsigned NOT NULL DEFAULT '0', + `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Trigger` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1616,34 +3039,32 @@ DROP TABLE IF EXISTS `item_extended_cost`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_extended_cost` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredArenaSlot` int(10) unsigned NOT NULL DEFAULT '0', `RequiredItem1` int(10) unsigned NOT NULL DEFAULT '0', `RequiredItem2` int(10) unsigned NOT NULL DEFAULT '0', `RequiredItem3` int(10) unsigned NOT NULL DEFAULT '0', `RequiredItem4` int(10) unsigned NOT NULL DEFAULT '0', `RequiredItem5` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredItemCount1` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredItemCount2` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredItemCount3` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredItemCount4` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredItemCount5` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredPersonalArenaRating` int(10) unsigned NOT NULL DEFAULT '0', - `ItemPurchaseGroup` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredCurrency1` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredCurrency2` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredCurrency3` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredCurrency4` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredCurrency5` int(10) unsigned NOT NULL DEFAULT '0', `RequiredCurrencyCount1` int(10) unsigned NOT NULL DEFAULT '0', `RequiredCurrencyCount2` int(10) unsigned NOT NULL DEFAULT '0', `RequiredCurrencyCount3` int(10) unsigned NOT NULL DEFAULT '0', `RequiredCurrencyCount4` int(10) unsigned NOT NULL DEFAULT '0', `RequiredCurrencyCount5` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredFactionId` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredFactionStanding` int(10) unsigned NOT NULL DEFAULT '0', - `RequirementFlags` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredAchievement` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredMoney` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredPersonalArenaRating` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredCurrency1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredCurrency2` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredCurrency3` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredCurrency4` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredCurrency5` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredArenaSlot` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredFactionId` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredFactionStanding` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequirementFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredAchievement` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1659,8 +3080,8 @@ DROP TABLE IF EXISTS `item_limit_category`; CREATE TABLE `item_limit_category` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `Quantity` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `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; @@ -1690,12 +3111,12 @@ 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(10) unsigned NOT NULL DEFAULT '0', - `AppearanceModID` int(10) unsigned NOT NULL DEFAULT '0', - `AppearanceID` int(10) unsigned NOT NULL DEFAULT '0', - `IconFileDataID` int(10) unsigned NOT NULL DEFAULT '0', - `Index` int(10) unsigned NOT NULL DEFAULT '0', + `AppearanceID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AppearanceModID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Index` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SourceType` tinyint(3) unsigned 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; @@ -1710,9 +3131,9 @@ DROP TABLE IF EXISTS `item_price_base`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_price_base` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `ItemLevel` int(10) unsigned NOT NULL DEFAULT '0', `ArmorFactor` float NOT NULL DEFAULT '0', `WeaponFactor` 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; @@ -1727,13 +3148,12 @@ DROP TABLE IF EXISTS `item_random_properties`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_random_properties` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `InternalName` text, - `Enchantment1` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment2` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment3` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment4` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment5` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, + `Enchantment1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment3` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment4` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment5` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1749,7 +3169,6 @@ DROP TABLE IF EXISTS `item_random_properties_locale`; CREATE TABLE `item_random_properties_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, - `InternalName_lang` text, `Name_lang` text, `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) @@ -1766,17 +3185,16 @@ DROP TABLE IF EXISTS `item_random_suffix`; CREATE TABLE `item_random_suffix` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `InternalName` text, - `Enchantment1` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment2` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment3` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment4` int(10) unsigned NOT NULL DEFAULT '0', - `Enchantment5` int(10) unsigned NOT NULL DEFAULT '0', - `AllocationPct1` int(10) unsigned NOT NULL DEFAULT '0', - `AllocationPct2` int(10) unsigned NOT NULL DEFAULT '0', - `AllocationPct3` int(10) unsigned NOT NULL DEFAULT '0', - `AllocationPct4` int(10) unsigned NOT NULL DEFAULT '0', - `AllocationPct5` int(10) unsigned NOT NULL DEFAULT '0', + `Enchantment1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment3` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment4` smallint(5) unsigned NOT NULL DEFAULT '0', + `Enchantment5` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllocationPct1` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllocationPct2` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllocationPct3` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllocationPct4` smallint(5) unsigned NOT NULL DEFAULT '0', + `AllocationPct5` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1793,13 +3211,126 @@ CREATE TABLE `item_random_suffix_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, `Name_lang` text, - `InternalName_lang` text, `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_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` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `Flags1` int(10) unsigned NOT NULL DEFAULT '0', + `Flags2` int(10) unsigned NOT NULL DEFAULT '0', + `Flags3` int(10) unsigned NOT NULL DEFAULT '0', + `AllowableRace` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredSpell` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredExpansion` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredReputationRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AllowableClass` 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, + `Name_lang` text, + `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, + `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', + `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkill` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` 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, + `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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemSetID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ChrSpecID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Threshold` 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` -- @@ -1808,50 +3339,18 @@ DROP TABLE IF EXISTS `item_sparse`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_sparse` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Quality` int(10) 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', `Unk1` float NOT NULL DEFAULT '0', `Unk2` float NOT NULL DEFAULT '0', - `BuyCount` int(10) unsigned NOT NULL DEFAULT '0', `BuyPrice` int(10) unsigned NOT NULL DEFAULT '0', `SellPrice` int(10) unsigned NOT NULL DEFAULT '0', - `InventoryType` int(10) unsigned NOT NULL DEFAULT '0', `AllowableClass` int(11) NOT NULL DEFAULT '0', `AllowableRace` int(11) NOT NULL DEFAULT '0', - `ItemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredLevel` int(11) NOT NULL DEFAULT '0', - `RequiredSkill` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredSkillRank` int(10) unsigned NOT NULL DEFAULT '0', `RequiredSpell` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredHonorRank` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredCityRank` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredReputationFaction` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredReputationRank` int(10) unsigned NOT NULL DEFAULT '0', `MaxCount` int(10) unsigned NOT NULL DEFAULT '0', `Stackable` int(10) unsigned NOT NULL DEFAULT '0', - `ContainerSlots` int(10) unsigned NOT NULL DEFAULT '0', - `ItemStatType1` int(11) NOT NULL DEFAULT '0', - `ItemStatType2` int(11) NOT NULL DEFAULT '0', - `ItemStatType3` int(11) NOT NULL DEFAULT '0', - `ItemStatType4` int(11) NOT NULL DEFAULT '0', - `ItemStatType5` int(11) NOT NULL DEFAULT '0', - `ItemStatType6` int(11) NOT NULL DEFAULT '0', - `ItemStatType7` int(11) NOT NULL DEFAULT '0', - `ItemStatType8` int(11) NOT NULL DEFAULT '0', - `ItemStatType9` int(11) NOT NULL DEFAULT '0', - `ItemStatType10` int(11) NOT NULL DEFAULT '0', - `ItemStatValue1` int(11) NOT NULL DEFAULT '0', - `ItemStatValue2` int(11) NOT NULL DEFAULT '0', - `ItemStatValue3` int(11) NOT NULL DEFAULT '0', - `ItemStatValue4` int(11) NOT NULL DEFAULT '0', - `ItemStatValue5` int(11) NOT NULL DEFAULT '0', - `ItemStatValue6` int(11) NOT NULL DEFAULT '0', - `ItemStatValue7` int(11) NOT NULL DEFAULT '0', - `ItemStatValue8` int(11) NOT NULL DEFAULT '0', - `ItemStatValue9` int(11) NOT NULL DEFAULT '0', - `ItemStatValue10` int(11) NOT NULL DEFAULT '0', `ItemStatAllocation1` int(11) NOT NULL DEFAULT '0', `ItemStatAllocation2` int(11) NOT NULL DEFAULT '0', `ItemStatAllocation3` int(11) NOT NULL DEFAULT '0', @@ -1872,43 +3371,77 @@ CREATE TABLE `item_sparse` ( `ItemStatSocketCostMultiplier8` float NOT NULL DEFAULT '0', `ItemStatSocketCostMultiplier9` float NOT NULL DEFAULT '0', `ItemStatSocketCostMultiplier10` float NOT NULL DEFAULT '0', - `ScalingStatDistribution` int(10) unsigned NOT NULL DEFAULT '0', - `DamageType` int(10) unsigned NOT NULL DEFAULT '0', - `Delay` int(10) unsigned NOT NULL DEFAULT '0', `RangedModRange` float NOT NULL DEFAULT '0', - `Bonding` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, `Name2` text, `Name3` text, `Name4` text, `Description` text, - `PageText` int(10) unsigned NOT NULL DEFAULT '0', - `LanguageID` int(10) unsigned NOT NULL DEFAULT '0', - `PageMaterial` int(10) unsigned NOT NULL DEFAULT '0', - `StartQuest` int(10) unsigned NOT NULL DEFAULT '0', - `LockID` int(10) unsigned NOT NULL DEFAULT '0', - `Material` int(11) NOT NULL DEFAULT '0', - `Sheath` int(10) unsigned NOT NULL DEFAULT '0', - `RandomProperty` int(10) unsigned NOT NULL DEFAULT '0', - `RandomSuffix` int(10) unsigned NOT NULL DEFAULT '0', - `ItemSet` int(10) unsigned NOT NULL DEFAULT '0', - `Area` int(10) unsigned NOT NULL DEFAULT '0', - `Map` int(10) unsigned NOT NULL DEFAULT '0', `BagFamily` int(10) unsigned NOT NULL DEFAULT '0', - `TotemCategory` int(10) unsigned NOT NULL DEFAULT '0', - `SocketColor1` int(10) unsigned NOT NULL DEFAULT '0', - `SocketColor2` int(10) unsigned NOT NULL DEFAULT '0', - `SocketColor3` int(10) unsigned NOT NULL DEFAULT '0', - `SocketBonus` int(10) unsigned NOT NULL DEFAULT '0', - `GemProperties` int(10) unsigned NOT NULL DEFAULT '0', `ArmorDamageModifier` float NOT NULL DEFAULT '0', `Duration` int(10) unsigned NOT NULL DEFAULT '0', - `ItemLimitCategory` int(10) unsigned NOT NULL DEFAULT '0', - `HolidayID` int(10) unsigned NOT NULL DEFAULT '0', `StatScalingFactor` float NOT NULL DEFAULT '0', - `CurrencySubstitutionID` int(10) unsigned NOT NULL DEFAULT '0', - `CurrencySubstitutionCount` int(10) unsigned NOT NULL DEFAULT '0', - `ItemNameDescriptionID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemStatValue1` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue2` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue3` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue4` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue5` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue6` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue7` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue8` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue9` smallint(6) NOT NULL DEFAULT '0', + `ItemStatValue10` smallint(6) NOT NULL DEFAULT '0', + `ScalingStatDistribution` smallint(5) unsigned NOT NULL DEFAULT '0', + `Delay` smallint(5) unsigned NOT NULL DEFAULT '0', + `PageText` smallint(5) unsigned NOT NULL DEFAULT '0', + `StartQuest` smallint(5) unsigned NOT NULL DEFAULT '0', + `LockID` smallint(5) unsigned NOT NULL DEFAULT '0', + `RandomProperty` smallint(5) unsigned NOT NULL DEFAULT '0', + `RandomSuffix` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemSet` smallint(5) unsigned NOT NULL DEFAULT '0', + `Area` smallint(5) unsigned NOT NULL DEFAULT '0', + `Map` smallint(5) unsigned NOT NULL DEFAULT '0', + `SocketBonus` smallint(5) unsigned NOT NULL DEFAULT '0', + `GemProperties` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemLimitCategory` smallint(5) unsigned NOT NULL DEFAULT '0', + `HolidayID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemNameDescriptionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT '0', + `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredLevel` tinyint(4) NOT NULL DEFAULT '0', + `RequiredHonorRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredCityRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredReputationRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemStatType1` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType2` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType3` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType4` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType5` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType6` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType7` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType8` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType9` tinyint(4) NOT NULL DEFAULT '0', + `ItemStatType10` tinyint(4) NOT NULL DEFAULT '0', + `DamageType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Bonding` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PageMaterial` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Material` tinyint(4) NOT NULL DEFAULT '0', + `Sheath` tinyint(3) unsigned NOT NULL DEFAULT '0', + `TotemCategory` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SocketColor1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SocketColor2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SocketColor3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CurrencySubstitutionID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CurrencySubstitutionCount` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ArtifactID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredExpansion` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1943,12 +3476,12 @@ DROP TABLE IF EXISTS `item_spec`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_spec` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `MinLevel` int(10) unsigned NOT NULL DEFAULT '0', - `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', - `ItemType` int(10) unsigned NOT NULL DEFAULT '0', - `PrimaryStat` int(10) unsigned NOT NULL DEFAULT '0', - `SecondaryStat` int(10) unsigned NOT NULL DEFAULT '0', - `SpecID` int(10) unsigned NOT NULL DEFAULT '0', + `SpecID` smallint(5) 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', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -1964,22 +3497,28 @@ DROP TABLE IF EXISTS `item_spec_override`; CREATE TABLE `item_spec_override` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `ItemID` int(10) unsigned NOT NULL DEFAULT '0', - `SpecID` int(10) unsigned NOT NULL DEFAULT '0', + `SpecID` 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_to_battle_pet_species` +-- Table structure for table `item_upgrade` -- -DROP TABLE IF EXISTS `item_to_battle_pet_species`; +DROP TABLE IF EXISTS `item_upgrade`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `item_to_battle_pet_species` ( +CREATE TABLE `item_upgrade` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `BattlePetSpeciesID` int(10) unsigned NOT NULL DEFAULT '0' + `CurrencyCost` int(10) unsigned NOT NULL DEFAULT '0', + `PrevItemUpgradeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CurrencyID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemUpgradePathID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemLevelBonus` 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 */; @@ -1993,7 +3532,7 @@ DROP TABLE IF EXISTS `item_x_bonus_tree`; CREATE TABLE `item_x_bonus_tree` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `ItemID` int(10) unsigned NOT NULL DEFAULT '0', - `BonusTreeID` int(10) unsigned NOT NULL DEFAULT '0', + `BonusTreeID` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2007,7 +3546,7 @@ DROP TABLE IF EXISTS `key_chain`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `key_chain` ( - `Id` int(10) unsigned NOT NULL DEFAULT '0', + `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', @@ -2041,7 +3580,222 @@ CREATE TABLE `key_chain` ( `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`) + 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` ( + `Name` text, + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `TextureFilename` text, + `Description` text, + `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `TargetLevelMax` smallint(5) unsigned NOT NULL DEFAULT '0', + `MapID` smallint(6) NOT NULL DEFAULT '0', + `RandomID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ScenarioID` smallint(5) unsigned NOT NULL DEFAULT '0', + `LastBossJournalEncounterID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BonusReputationAmount` smallint(5) unsigned NOT NULL DEFAULT '0', + `MentorItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `TargetLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `TargetLevelMin` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Faction` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Expansion` tinyint(3) unsigned NOT NULL DEFAULT '0', + `OrderIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `GroupID` tinyint(3) 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', + `SubType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MentorCharLevel` tinyint(3) unsigned 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 `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, + `Description_lang` text, + `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', + `PosX` float NOT NULL DEFAULT '0', + `PosY` float NOT NULL DEFAULT '0', + `PosZ` float NOT NULL DEFAULT '0', + `FalloffStart` float NOT NULL DEFAULT '0', + `FalloffEnd` float NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned 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, + `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', + `ParticleScale` float NOT NULL DEFAULT '0', + `Texture1` text, + `Texture2` text, + `Texture3` text, + `Texture4` text, + `Texture5` text, + `Texture6` text, + `Color1` int(10) unsigned NOT NULL DEFAULT '0', + `Color2` int(10) unsigned 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', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `LightID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned 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', + `DepthTexCount1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DepthTexCount2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DepthTexCount3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DepthTexCount4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DepthTexCount5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DepthTexCount6` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundID` 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 `liquid_type_locale` +-- + +DROP TABLE IF EXISTS `liquid_type_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `liquid_type_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `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 `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(10) unsigned NOT NULL DEFAULT '0', + `Index2` int(10) unsigned NOT NULL DEFAULT '0', + `Index3` int(10) unsigned NOT NULL DEFAULT '0', + `Index4` int(10) unsigned NOT NULL DEFAULT '0', + `Index5` int(10) unsigned NOT NULL DEFAULT '0', + `Index6` int(10) unsigned NOT NULL DEFAULT '0', + `Index7` int(10) unsigned NOT NULL DEFAULT '0', + `Index8` int(10) unsigned 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 */; @@ -2077,6 +3831,97 @@ CREATE TABLE `mail_template_locale` ( /*!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, + `Flags1` int(10) unsigned NOT NULL DEFAULT '0', + `Flags2` int(10) unsigned NOT NULL DEFAULT '0', + `MinimapIconScale` float NOT NULL DEFAULT '0', + `CorpsePosX` float NOT NULL DEFAULT '0', + `CorpsePosY` float NOT NULL DEFAULT '0', + `MapName` text, + `MapDescription0` text, + `MapDescription1` text, + `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT '0', + `LoadingScreenID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CorpseMapID` smallint(6) NOT NULL DEFAULT '0', + `TimeOfDayOverride` smallint(5) unsigned NOT NULL DEFAULT '0', + `ParentMapID` smallint(6) NOT NULL DEFAULT '0', + `CosmeticParentMapID` smallint(6) NOT NULL DEFAULT '0', + `WindSettingsID` smallint(5) unsigned NOT NULL DEFAULT '0', + `InstanceType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `unk5` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ExpansionID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `TimeOffset` 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 `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, + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RaidDurationType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LockID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemBonusTreeModID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Context` 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 `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, + `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, + `MapDescription0_lang` text, + `MapDescription1_lang` text, + `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` -- @@ -2085,12 +3930,13 @@ DROP TABLE IF EXISTS `modifier_tree`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `modifier_tree` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Type` int(10) unsigned NOT NULL DEFAULT '0', `Asset1` int(10) unsigned NOT NULL DEFAULT '0', `Asset2` int(10) unsigned NOT NULL DEFAULT '0', - `Operator` int(10) unsigned NOT NULL DEFAULT '0', - `Amount` int(10) unsigned NOT NULL DEFAULT '0', - `Parent` int(10) unsigned NOT NULL DEFAULT '0', + `Parent` smallint(5) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unk700` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Operator` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Amount` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2104,18 +3950,19 @@ DROP TABLE IF EXISTS `mount`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount` ( - `Id` int(10) unsigned NOT NULL DEFAULT '0', - `MountTypeId` int(10) unsigned NOT NULL DEFAULT '0', + `SpellId` int(10) unsigned NOT NULL DEFAULT '0', `DisplayId` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, `Description` text, `SourceDescription` text, - `Source` int(10) unsigned NOT NULL DEFAULT '0', - `SpellId` int(10) unsigned NOT NULL DEFAULT '0', - `PlayerConditionId` int(10) unsigned NOT NULL DEFAULT '0', + `CameraPivotMultiplier` float NOT NULL DEFAULT '0', + `MountTypeId` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `PlayerConditionId` smallint(5) unsigned NOT NULL DEFAULT '0', + `Source` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', - PRIMARY KEY (`Id`) + PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2127,14 +3974,14 @@ 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` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredRidingSkill` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredArea` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredAura` int(10) unsigned NOT NULL DEFAULT '0', `RequiredSpell` int(10) unsigned NOT NULL DEFAULT '0', `SpeedModSpell` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredMap` int(11) NOT NULL DEFAULT '0', + `RequiredRidingSkill` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredArea` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredMap` smallint(6) NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredAura` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2148,13 +3995,13 @@ 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', + `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, `Name_lang` text, `Description_lang` text, `SourceDescription_lang` text, `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', - PRIMARY KEY (`Id`,`locale`) + PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2167,9 +4014,27 @@ DROP TABLE IF EXISTS `mount_type_x_capability`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mount_type_x_capability` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `MountTypeID` int(10) unsigned NOT NULL DEFAULT '0', - `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', - `MountCapabilityID` 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 `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', + `AudioFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `SubtitleFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `Volume` tinyint(3) unsigned NOT NULL DEFAULT '0', + `KeyID` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2185,8 +4050,8 @@ DROP TABLE IF EXISTS `name_gen`; CREATE TABLE `name_gen` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `Race` int(10) unsigned NOT NULL DEFAULT '0', - `Sex` int(10) unsigned NOT NULL DEFAULT '0', + `Race` 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; @@ -2218,7 +4083,7 @@ DROP TABLE IF EXISTS `names_profanity`; CREATE TABLE `names_profanity` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `Language` int(10) NOT NULL DEFAULT '0', + `Language` tinyint(4) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2249,7 +4114,7 @@ DROP TABLE IF EXISTS `names_reserved_locale`; CREATE TABLE `names_reserved_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `LocaleMask` int(10) unsigned NOT NULL DEFAULT '0', + `LocaleMask` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2274,24 +4139,39 @@ CREATE TABLE `override_spell_data` ( `SpellID8` int(10) unsigned NOT NULL DEFAULT '0', `SpellID9` int(10) unsigned NOT NULL DEFAULT '0', `SpellID10` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `PlayerActionbarFileDataID` int(10) 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 `phase_group` +-- Table structure for table `phase` -- -DROP TABLE IF EXISTS `phase_group`; +DROP TABLE IF EXISTS `phase`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `phase_group` ( +CREATE TABLE `phase` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `PhaseID` int(10) unsigned NOT NULL DEFAULT '0', - `PhaseGroupID` 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; @@ -2306,63 +4186,122 @@ DROP TABLE IF EXISTS `player_condition`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_condition` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', - `MinLevel` int(10) unsigned NOT NULL DEFAULT '0', - `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', `RaceMask` int(10) unsigned NOT NULL DEFAULT '0', - `ClassMask` int(10) unsigned NOT NULL DEFAULT '0', - `Gender` int(11) NOT NULL DEFAULT '0', - `NativeGender` int(11) NOT NULL DEFAULT '0', - `SkillID1` int(10) unsigned NOT NULL DEFAULT '0', - `SkillID2` int(10) unsigned NOT NULL DEFAULT '0', - `SkillID3` int(10) unsigned NOT NULL DEFAULT '0', - `SkillID4` int(10) unsigned NOT NULL DEFAULT '0', - `MinSkill1` int(11) NOT NULL DEFAULT '0', - `MinSkill2` int(11) NOT NULL DEFAULT '0', - `MinSkill3` int(11) NOT NULL DEFAULT '0', - `MinSkill4` int(11) NOT NULL DEFAULT '0', - `MaxSkill1` int(11) NOT NULL DEFAULT '0', - `MaxSkill2` int(11) NOT NULL DEFAULT '0', - `MaxSkill3` int(11) NOT NULL DEFAULT '0', - `MaxSkill4` int(11) NOT NULL DEFAULT '0', `SkillLogic` int(10) unsigned NOT NULL DEFAULT '0', - `LanguageID` int(10) unsigned NOT NULL DEFAULT '0', - `MinLanguage` int(10) unsigned NOT NULL DEFAULT '0', - `MaxLanguage` int(10) 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', - `MaxFactionID` int(10) unsigned NOT NULL DEFAULT '0', - `MinReputation1` int(10) unsigned NOT NULL DEFAULT '0', - `MinReputation2` int(10) unsigned NOT NULL DEFAULT '0', - `MinReputation3` int(10) unsigned NOT NULL DEFAULT '0', - `MaxReputation` int(10) unsigned NOT NULL DEFAULT '0', `ReputationLogic` int(10) unsigned NOT NULL DEFAULT '0', - `Unknown1` int(10) unsigned NOT NULL DEFAULT '0', - `MinPVPRank` int(10) unsigned NOT NULL DEFAULT '0', - `MaxPVPRank` int(10) unsigned NOT NULL DEFAULT '0', - `PvpMedal` int(10) unsigned NOT NULL DEFAULT '0', `PrevQuestLogic` int(10) unsigned NOT NULL DEFAULT '0', - `PrevQuestID1` int(10) unsigned NOT NULL DEFAULT '0', - `PrevQuestID2` int(10) unsigned NOT NULL DEFAULT '0', - `PrevQuestID3` int(10) unsigned NOT NULL DEFAULT '0', - `PrevQuestID4` int(10) unsigned NOT NULL DEFAULT '0', `CurrQuestLogic` int(10) unsigned NOT NULL DEFAULT '0', - `CurrQuestID1` int(10) unsigned NOT NULL DEFAULT '0', - `CurrQuestID2` int(10) unsigned NOT NULL DEFAULT '0', - `CurrQuestID3` int(10) unsigned NOT NULL DEFAULT '0', - `CurrQuestID4` int(10) unsigned NOT NULL DEFAULT '0', `CurrentCompletedQuestLogic` int(10) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID1` int(10) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID2` int(10) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID3` int(10) unsigned NOT NULL DEFAULT '0', - `CurrentCompletedQuestID4` int(10) unsigned NOT NULL DEFAULT '0', `SpellLogic` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLogic` int(10) unsigned NOT NULL DEFAULT '0', + `Time1` int(10) unsigned NOT NULL DEFAULT '0', + `Time2` int(10) unsigned NOT NULL DEFAULT '0', + `AuraSpellLogic` int(10) unsigned NOT NULL DEFAULT '0', + `AuraSpellID1` int(10) unsigned NOT NULL DEFAULT '0', + `AuraSpellID2` int(10) unsigned NOT NULL DEFAULT '0', + `AuraSpellID3` int(10) unsigned NOT NULL DEFAULT '0', + `AuraSpellID4` int(10) unsigned NOT NULL DEFAULT '0', + `AchievementLogic` int(10) unsigned NOT NULL DEFAULT '0', + `AreaLogic` int(10) unsigned NOT NULL DEFAULT '0', + `QuestKillLogic` int(10) unsigned NOT NULL DEFAULT '0', + `FailureDescription` text, + `MinLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `MaxLevel` smallint(5) 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(6) NOT NULL DEFAULT '0', + `MinSkill2` smallint(6) NOT NULL DEFAULT '0', + `MinSkill3` smallint(6) NOT NULL DEFAULT '0', + `MinSkill4` smallint(6) NOT NULL DEFAULT '0', + `MaxSkill1` smallint(6) NOT NULL DEFAULT '0', + `MaxSkill2` smallint(6) NOT NULL DEFAULT '0', + `MaxSkill3` smallint(6) NOT NULL DEFAULT '0', + `MaxSkill4` smallint(6) NOT NULL DEFAULT '0', + `MaxFactionID` smallint(5) 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', + `Explored1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Explored2` smallint(5) unsigned NOT NULL DEFAULT '0', + `WorldStateExpressionID` smallint(5) 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', + `QuestKillID` smallint(5) unsigned NOT NULL DEFAULT '0', + `PhaseID` smallint(5) unsigned NOT NULL DEFAULT '0', + `MinAvgEquippedItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `MaxAvgEquippedItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `ModifierTreeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Gender` tinyint(4) NOT NULL DEFAULT '0', + `NativeGender` tinyint(4) NOT NULL DEFAULT '0', + `MinLanguage` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxLanguage` tinyint(3) 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', + `MaxReputation` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unknown1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinPVPRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxPVPRank` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PvpMedal` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ItemFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AuraCount1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AuraCount2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AuraCount3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `AuraCount4` tinyint(3) 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', + `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', + `CurrencyCount1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CurrencyCount2` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CurrencyCount3` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CurrencyCount4` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinExpansionLevel` tinyint(4) NOT NULL DEFAULT '0', + `MaxExpansionLevel` tinyint(4) NOT NULL DEFAULT '0', + `MinExpansionTier` tinyint(4) NOT NULL DEFAULT '0', + `MaxExpansionTier` tinyint(4) NOT NULL DEFAULT '0', + `MinGuildLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxGuildLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PhaseUseFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ChrSpecializationIndex` tinyint(4) NOT NULL DEFAULT '0', + `ChrSpecializationRole` tinyint(4) NOT NULL DEFAULT '0', + `PowerType` tinyint(4) NOT NULL DEFAULT '0', + `PowerTypeComp` tinyint(4) NOT NULL DEFAULT '0', + `PowerTypeValue` tinyint(4) NOT NULL DEFAULT '0', + `ClassMask` int(11) NOT NULL DEFAULT '0', + `LanguageID` int(10) 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', `SpellID1` int(10) unsigned NOT NULL DEFAULT '0', `SpellID2` int(10) unsigned NOT NULL DEFAULT '0', `SpellID3` int(10) unsigned NOT NULL DEFAULT '0', `SpellID4` int(10) unsigned NOT NULL DEFAULT '0', - `ItemLogic` int(10) 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', @@ -2371,77 +4310,27 @@ CREATE TABLE `player_condition` ( `ItemCount2` int(10) unsigned NOT NULL DEFAULT '0', `ItemCount3` int(10) unsigned NOT NULL DEFAULT '0', `ItemCount4` int(10) unsigned NOT NULL DEFAULT '0', - `ItemFlags` int(10) unsigned NOT NULL DEFAULT '0', - `Explored1` int(10) unsigned NOT NULL DEFAULT '0', - `Explored2` int(10) unsigned NOT NULL DEFAULT '0', - `Time1` int(10) unsigned NOT NULL DEFAULT '0', - `Time2` int(10) unsigned NOT NULL DEFAULT '0', - `AuraSpellLogic` int(10) unsigned NOT NULL DEFAULT '0', - `AuraSpellID1` int(10) unsigned NOT NULL DEFAULT '0', - `AuraSpellID2` int(10) unsigned NOT NULL DEFAULT '0', - `AuraSpellID3` int(10) unsigned NOT NULL DEFAULT '0', - `AuraSpellID4` int(10) unsigned NOT NULL DEFAULT '0', - `WorldStateExpressionID` int(10) unsigned NOT NULL DEFAULT '0', - `WeatherID` int(10) unsigned NOT NULL DEFAULT '0', - `PartyStatus` int(10) unsigned NOT NULL DEFAULT '0', - `LifetimeMaxPVPRank` int(10) unsigned NOT NULL DEFAULT '0', - `AchievementLogic` int(10) unsigned NOT NULL DEFAULT '0', - `Achievement1` int(10) unsigned NOT NULL DEFAULT '0', - `Achievement2` int(10) unsigned NOT NULL DEFAULT '0', - `Achievement3` int(10) unsigned NOT NULL DEFAULT '0', - `Achievement4` int(10) unsigned NOT NULL DEFAULT '0', `LfgLogic` int(10) unsigned NOT NULL DEFAULT '0', - `LfgStatus1` int(10) unsigned NOT NULL DEFAULT '0', - `LfgStatus2` int(10) unsigned NOT NULL DEFAULT '0', - `LfgStatus3` int(10) unsigned NOT NULL DEFAULT '0', - `LfgStatus4` int(10) unsigned NOT NULL DEFAULT '0', - `LfgCompare1` int(10) unsigned NOT NULL DEFAULT '0', - `LfgCompare2` int(10) unsigned NOT NULL DEFAULT '0', - `LfgCompare3` int(10) unsigned NOT NULL DEFAULT '0', - `LfgCompare4` int(10) 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', - `AreaLogic` 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', `CurrencyLogic` 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', - `QuestKillID` int(10) unsigned NOT NULL DEFAULT '0', - `QuestKillLogic` 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', - `MinExpansionLevel` int(11) NOT NULL DEFAULT '0', - `MaxExpansionLevel` int(11) NOT NULL DEFAULT '0', - `MinExpansionTier` int(11) NOT NULL DEFAULT '0', - `MaxExpansionTier` int(11) NOT NULL DEFAULT '0', - `MinGuildLevel` int(10) unsigned NOT NULL DEFAULT '0', - `MaxGuildLevel` int(10) unsigned NOT NULL DEFAULT '0', - `PhaseUseFlags` int(10) unsigned NOT NULL DEFAULT '0', - `PhaseID` int(10) unsigned NOT NULL DEFAULT '0', + `QuestKillMonster5` int(10) unsigned NOT NULL DEFAULT '0', + `QuestKillMonster6` int(10) unsigned NOT NULL DEFAULT '0', `PhaseGroupID` int(10) unsigned NOT NULL DEFAULT '0', `MinAvgItemLevel` int(10) unsigned NOT NULL DEFAULT '0', `MaxAvgItemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `MinAvgEquippedItemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `MaxAvgEquippedItemLevel` int(10) unsigned NOT NULL DEFAULT '0', - `ChrSpecializationIndex` int(11) NOT NULL DEFAULT '0', - `ChrSpecializationRole` int(11) NOT NULL DEFAULT '0', - `FailureDescription` text, - `PowerType` int(11) NOT NULL DEFAULT '0', - `PowerTypeComp` int(11) NOT NULL DEFAULT '0', - `PowerTypeValue` int(11) NOT NULL DEFAULT '0', + `Unknown7001` int(11) NOT NULL DEFAULT '0', + `Unknown7002` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2464,6 +4353,93 @@ CREATE TABLE `player_condition_locale` ( /*!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, + `PowerType` 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', + `PowerTypeToken` text, + `PowerCostToken` text, + `RegenerationPeace` float NOT NULL DEFAULT '0', + `RegenerationCombat` float NOT NULL DEFAULT '0', + `MaxPower` smallint(6) NOT NULL DEFAULT '0', + `RegenerationDelay` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `PowerTypeEnum` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RegenerationMin` tinyint(4) NOT NULL DEFAULT '0', + `RegenerationCenter` tinyint(4) NOT NULL DEFAULT '0', + `RegenerationMax` tinyint(4) NOT NULL DEFAULT '0', + `UIModifier` 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_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', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BracketID` 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 `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', + `QuestRewFactionValue1` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue2` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue3` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue4` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue5` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue6` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue7` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue8` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue9` smallint(6) NOT NULL DEFAULT '0', + `QuestRewFactionValue10` 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` -- @@ -2471,7 +4447,7 @@ 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` ( - `Level` int(10) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', `Money1` int(10) unsigned NOT NULL DEFAULT '0', `Money2` int(10) unsigned NOT NULL DEFAULT '0', `Money3` int(10) unsigned NOT NULL DEFAULT '0', @@ -2483,7 +4459,7 @@ CREATE TABLE `quest_money_reward` ( `Money9` int(10) unsigned NOT NULL DEFAULT '0', `Money10` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', - PRIMARY KEY (`Level`) + PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2496,10 +4472,10 @@ DROP TABLE IF EXISTS `quest_package_item`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_package_item` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `QuestPackageID` int(10) unsigned NOT NULL DEFAULT '0', `ItemID` int(10) unsigned NOT NULL DEFAULT '0', - `ItemCount` int(10) unsigned NOT NULL DEFAULT '0', - `FilterType` int(10) unsigned NOT NULL DEFAULT '0', + `QuestPackageID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0', + `FilterType` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2515,6 +4491,7 @@ DROP TABLE IF EXISTS `quest_sort`; CREATE TABLE `quest_sort` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `SortName` text, + `SortOrder` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2545,7 +4522,7 @@ DROP TABLE IF EXISTS `quest_v2`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_v2` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `UniqueBitFlag` 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; @@ -2560,16 +4537,61 @@ DROP TABLE IF EXISTS `quest_xp`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_xp` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Exp1` int(10) unsigned NOT NULL DEFAULT '0', - `Exp2` int(10) unsigned NOT NULL DEFAULT '0', - `Exp3` int(10) unsigned NOT NULL DEFAULT '0', - `Exp4` int(10) unsigned NOT NULL DEFAULT '0', - `Exp5` int(10) unsigned NOT NULL DEFAULT '0', - `Exp6` int(10) unsigned NOT NULL DEFAULT '0', - `Exp7` int(10) unsigned NOT NULL DEFAULT '0', - `Exp8` int(10) unsigned NOT NULL DEFAULT '0', - `Exp9` int(10) unsigned NOT NULL DEFAULT '0', - `Exp10` int(10) unsigned NOT NULL DEFAULT '0', + `Exp1` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp2` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp3` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp4` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp5` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp6` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp7` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp8` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp9` smallint(5) unsigned NOT NULL DEFAULT '0', + `Exp10` 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', + `EpicPropertiesPoints1` int(10) unsigned NOT NULL DEFAULT '0', + `EpicPropertiesPoints2` int(10) unsigned NOT NULL DEFAULT '0', + `EpicPropertiesPoints3` int(10) unsigned NOT NULL DEFAULT '0', + `EpicPropertiesPoints4` int(10) unsigned NOT NULL DEFAULT '0', + `EpicPropertiesPoints5` int(10) unsigned NOT NULL DEFAULT '0', + `RarePropertiesPoints1` int(10) unsigned NOT NULL DEFAULT '0', + `RarePropertiesPoints2` int(10) unsigned NOT NULL DEFAULT '0', + `RarePropertiesPoints3` int(10) unsigned NOT NULL DEFAULT '0', + `RarePropertiesPoints4` int(10) unsigned NOT NULL DEFAULT '0', + `RarePropertiesPoints5` int(10) unsigned NOT NULL DEFAULT '0', + `UncommonPropertiesPoints1` int(10) unsigned NOT NULL DEFAULT '0', + `UncommonPropertiesPoints2` int(10) unsigned NOT NULL DEFAULT '0', + `UncommonPropertiesPoints3` int(10) unsigned NOT NULL DEFAULT '0', + `UncommonPropertiesPoints4` int(10) unsigned NOT NULL DEFAULT '0', + `UncommonPropertiesPoints5` 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 `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(10) unsigned 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; @@ -2584,91 +4606,173 @@ DROP TABLE IF EXISTS `scaling_stat_distribution`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scaling_stat_distribution` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevelCurveID` smallint(5) unsigned NOT NULL DEFAULT '0', `MinLevel` int(10) unsigned NOT NULL DEFAULT '0', `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', - `ItemLevelCurveID` 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 `sound_entries` +-- Table structure for table `scene_script` -- -DROP TABLE IF EXISTS `sound_entries`; +DROP TABLE IF EXISTS `scene_script`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `sound_entries` ( +CREATE TABLE `scene_script` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `SoundType` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `FileDataID1` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID2` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID3` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID4` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID5` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID6` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID7` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID8` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID9` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID10` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID11` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID12` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID13` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID14` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID15` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID16` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID17` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID18` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID19` int(10) unsigned NOT NULL DEFAULT '0', - `FileDataID20` int(10) unsigned NOT NULL DEFAULT '0', - `Freq1` int(10) unsigned NOT NULL DEFAULT '0', - `Freq2` int(10) unsigned NOT NULL DEFAULT '0', - `Freq3` int(10) unsigned NOT NULL DEFAULT '0', - `Freq4` int(10) unsigned NOT NULL DEFAULT '0', - `Freq5` int(10) unsigned NOT NULL DEFAULT '0', - `Freq6` int(10) unsigned NOT NULL DEFAULT '0', - `Freq7` int(10) unsigned NOT NULL DEFAULT '0', - `Freq8` int(10) unsigned NOT NULL DEFAULT '0', - `Freq9` int(10) unsigned NOT NULL DEFAULT '0', - `Freq10` int(10) unsigned NOT NULL DEFAULT '0', - `Freq11` int(10) unsigned NOT NULL DEFAULT '0', - `Freq12` int(10) unsigned NOT NULL DEFAULT '0', - `Freq13` int(10) unsigned NOT NULL DEFAULT '0', - `Freq14` int(10) unsigned NOT NULL DEFAULT '0', - `Freq15` int(10) unsigned NOT NULL DEFAULT '0', - `Freq16` int(10) unsigned NOT NULL DEFAULT '0', - `Freq17` int(10) unsigned NOT NULL DEFAULT '0', - `Freq18` int(10) unsigned NOT NULL DEFAULT '0', - `Freq19` int(10) unsigned NOT NULL DEFAULT '0', - `Freq20` int(10) unsigned NOT NULL DEFAULT '0', + `Script` text, + `PrevScriptId` smallint(5) unsigned NOT NULL DEFAULT '0', + `NextScriptId` 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_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, + `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` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `DisplayName` text, + `Description` text, + `AlternateVerb` text, + `SpellIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `CategoryID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CanLink` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ParentSkillLineID` 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 `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` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `RaceMask` int(10) unsigned NOT NULL DEFAULT '0', + `SupercedesSpell` int(10) unsigned NOT NULL DEFAULT '0', + `Unknown703` int(10) unsigned NOT NULL DEFAULT '0', + `SkillLine` smallint(5) unsigned NOT NULL DEFAULT '0', + `MinSkillLineRank` smallint(5) unsigned NOT NULL DEFAULT '0', + `TrivialSkillLineRankHigh` smallint(5) unsigned NOT NULL DEFAULT '0', + `TrivialSkillLineRankLow` smallint(5) unsigned NOT NULL DEFAULT '0', + `UniqueBit` smallint(5) unsigned NOT NULL DEFAULT '0', + `TradeSkillCategoryID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AcquireMethod` tinyint(3) unsigned NOT NULL DEFAULT '0', + `NumSkillUps` tinyint(3) 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 `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, + `Description_lang` text, + `AlternateVerb_lang` text, + `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` int(11) NOT NULL DEFAULT '0', + `SkillID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `SkillTierID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Availability` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinLevel` tinyint(3) 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 `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` ( + `Name` text, `VolumeFloat` float NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `MinDistance` float NOT NULL DEFAULT '0', `DistanceCutoff` float NOT NULL DEFAULT '0', - `EAXDef` int(10) unsigned NOT NULL DEFAULT '0', - `SoundEntriesAdvancedID` 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', `PitchAdjust` float NOT NULL DEFAULT '0', - `DialogType` int(10) unsigned NOT NULL DEFAULT '0', - `BusOverwriteID` int(10) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `SoundEntriesAdvancedID` smallint(5) unsigned NOT NULL DEFAULT '0', + `BusOverwriteID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SoundType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `EAXDef` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DialogType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Unk700` tinyint(3) unsigned 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 `sound_entries_locale` +-- Table structure for table `sound_kit_locale` -- -DROP TABLE IF EXISTS `sound_entries_locale`; +DROP TABLE IF EXISTS `sound_kit_locale`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `sound_entries_locale` ( +CREATE TABLE `sound_kit_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, `Name_lang` text, @@ -2685,12 +4789,12 @@ DROP TABLE IF EXISTS `specialization_spells`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `specialization_spells` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `SpecID` int(10) unsigned NOT NULL DEFAULT '0', - `OrderIndex` int(10) unsigned NOT NULL DEFAULT '0', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `OverridesSpellID` int(10) unsigned NOT NULL DEFAULT '0', `Description` text, + `SpecID` smallint(5) unsigned NOT NULL DEFAULT '0', + `OrderIndex` tinyint(3) unsigned 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; @@ -2713,6 +4817,48 @@ CREATE TABLE `specialization_spells_locale` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spell` +-- + +DROP TABLE IF EXISTS `spell`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell` ( + `Name` text, + `NameSubtext` text, + `Description` text, + `AuraDescription` text, + `MiscID` int(10) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `DescriptionVariablesID` 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_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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `ProcCharges` int(10) unsigned NOT NULL DEFAULT '0', + `ProcTypeMask` int(10) unsigned NOT NULL DEFAULT '0', + `ProcCategoryRecovery` int(10) unsigned NOT NULL DEFAULT '0', + `CumulativeAura` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ProcChance` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SpellProcsPerMinuteID` 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_aura_restrictions` -- @@ -2721,14 +4867,16 @@ DROP TABLE IF EXISTS `spell_aura_restrictions`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_aura_restrictions` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `CasterAuraState` int(10) unsigned NOT NULL DEFAULT '0', - `TargetAuraState` int(10) unsigned NOT NULL DEFAULT '0', - `ExcludeCasterAuraState` int(10) unsigned NOT NULL DEFAULT '0', - `ExcludeTargetAuraState` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `CasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', `TargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', `ExcludeCasterAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', `ExcludeTargetAuraSpell` int(10) unsigned NOT NULL DEFAULT '0', + `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', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2744,8 +4892,8 @@ DROP TABLE IF EXISTS `spell_cast_times`; CREATE TABLE `spell_cast_times` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `CastTime` int(11) NOT NULL DEFAULT '0', - `CastTimePerLevel` int(11) NOT NULL DEFAULT '0', `MinCastTime` int(11) NOT NULL DEFAULT '0', + `CastTimePerLevel` smallint(6) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2760,18 +4908,78 @@ DROP TABLE IF EXISTS `spell_casting_requirements`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_casting_requirements` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `FacingCasterFlags` int(10) unsigned NOT NULL DEFAULT '0', - `MinFactionID` int(10) unsigned NOT NULL DEFAULT '0', - `MinReputation` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredAreasID` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredAuraVision` int(10) unsigned NOT NULL DEFAULT '0', - `RequiresSpellFocus` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `MinFactionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredAreasID` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiresSpellFocus` smallint(5) unsigned NOT NULL DEFAULT '0', + `FacingCasterFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinReputation` tinyint(3) unsigned NOT NULL DEFAULT '0', + `RequiredAuraVision` 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_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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `Category` smallint(5) unsigned NOT NULL DEFAULT '0', + `StartRecoveryCategory` smallint(5) unsigned NOT NULL DEFAULT '0', + `ChargeCategory` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DefenseType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `DispelType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Mechanic` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PreventionType` 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_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, + `ChargeRecoveryTime` int(11) NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `UsesPerWeek` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxCharges` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ChargeCategoryType` 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_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, + `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` -- @@ -2780,12 +4988,32 @@ DROP TABLE IF EXISTS `spell_class_options`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_class_options` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `ModalNextSpell` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `SpellClassMask1` int(10) unsigned NOT NULL DEFAULT '0', `SpellClassMask2` int(10) unsigned NOT NULL DEFAULT '0', `SpellClassMask3` int(10) unsigned NOT NULL DEFAULT '0', `SpellClassMask4` int(10) unsigned NOT NULL DEFAULT '0', - `SpellClassSet` int(10) unsigned NOT NULL DEFAULT '0', + `SpellClassSet` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ModalNextSpell` 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_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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `CategoryRecoveryTime` int(10) unsigned NOT NULL DEFAULT '0', + `RecoveryTime` int(10) unsigned NOT NULL DEFAULT '0', + `StartRecoveryTime` int(10) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2800,9 +5028,53 @@ DROP TABLE IF EXISTS `spell_duration`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_duration` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Duration1` int(11) NOT NULL DEFAULT '0', - `Duration2` int(11) NOT NULL DEFAULT '0', - `Duration3` int(11) NOT NULL DEFAULT '0', + `Duration` int(11) NOT NULL DEFAULT '0', + `MaxDuration` int(11) NOT NULL DEFAULT '0', + `DurationPerLevel` 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_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` ( + `EffectAmplitude` float NOT NULL DEFAULT '0', + `EffectBonusCoefficient` float NOT NULL DEFAULT '0', + `EffectChainAmplitude` float NOT NULL DEFAULT '0', + `EffectPointsPerResource` float NOT NULL DEFAULT '0', + `EffectRealPointsPerLevel` float NOT NULL DEFAULT '0', + `EffectSpellClassMask1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMask2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMask3` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellClassMask4` int(10) unsigned NOT NULL DEFAULT '0', + `EffectPosFacing` float NOT NULL DEFAULT '0', + `BonusCoefficientFromAP` float NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `DifficultyID` int(10) unsigned NOT NULL DEFAULT '0', + `Effect` int(10) unsigned NOT NULL DEFAULT '0', + `EffectAura` int(10) unsigned NOT NULL DEFAULT '0', + `EffectAuraPeriod` int(10) unsigned NOT NULL DEFAULT '0', + `EffectBasePoints` int(11) NOT NULL DEFAULT '0', + `EffectChainTargets` int(10) unsigned NOT NULL DEFAULT '0', + `EffectDieSides` int(11) NOT NULL DEFAULT '0', + `EffectItemType` int(10) unsigned NOT NULL DEFAULT '0', + `EffectMechanic` int(10) unsigned NOT NULL DEFAULT '0', + `EffectMiscValue` int(11) NOT NULL DEFAULT '0', + `EffectMiscValueB` int(11) NOT NULL DEFAULT '0', + `EffectRadiusIndex` int(10) unsigned NOT NULL DEFAULT '0', + `EffectRadiusMaxIndex` int(10) unsigned NOT NULL DEFAULT '0', + `EffectTriggerSpell` int(10) unsigned NOT NULL DEFAULT '0', + `ImplicitTarget1` int(10) unsigned NOT NULL DEFAULT '0', + `ImplicitTarget2` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `EffectIndex` int(10) unsigned NOT NULL DEFAULT '0', + `EffectAttributes` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2825,6 +5097,135 @@ CREATE TABLE `spell_effect_group_size` ( /*!40101 SET character_set_client = @saved_cs_client */; -- +-- Table structure for table `spell_effect_scaling` +-- + +DROP TABLE IF EXISTS `spell_effect_scaling`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_effect_scaling` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `Coefficient` float NOT NULL DEFAULT '0', + `Variance` float NOT NULL DEFAULT '0', + `ResourceCoefficient` float NOT NULL DEFAULT '0', + `SpellEffectID` 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_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(10) unsigned NOT NULL DEFAULT '0', + `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0', + `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0', + `EquippedItemClass` 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 `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, + `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, + `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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `AuraInterruptFlags1` int(10) unsigned NOT NULL DEFAULT '0', + `AuraInterruptFlags2` int(10) unsigned NOT NULL DEFAULT '0', + `ChannelInterruptFlags1` int(10) unsigned NOT NULL DEFAULT '0', + `ChannelInterruptFlags2` int(10) unsigned NOT NULL DEFAULT '0', + `InterruptFlags` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` 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` +-- + +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', + `EffectSpellID1` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellID2` int(10) unsigned NOT NULL DEFAULT '0', + `EffectSpellID3` int(10) unsigned NOT NULL DEFAULT '0', + `Name` text, + `EffectScalingPoints1` float NOT NULL DEFAULT '0', + `EffectScalingPoints2` float NOT NULL DEFAULT '0', + `EffectScalingPoints3` float NOT NULL DEFAULT '0', + `TransmogCost` int(10) unsigned NOT NULL DEFAULT '0', + `TextureFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `EffectPointsMin1` smallint(5) unsigned NOT NULL DEFAULT '0', + `EffectPointsMin2` smallint(5) unsigned NOT NULL DEFAULT '0', + `EffectPointsMin3` smallint(5) unsigned 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', + `ConditionID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ScalingClass` tinyint(4) NOT NULL DEFAULT '0', + `ScalingClassRestricted` tinyint(4) 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 `spell_item_enchantment_condition` -- @@ -2838,11 +5239,6 @@ CREATE TABLE `spell_item_enchantment_condition` ( `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', @@ -2853,22 +5249,43 @@ CREATE TABLE `spell_item_enchantment_condition` ( `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` int(10) unsigned NOT NULL DEFAULT '0', - `RTOperand2` int(10) unsigned NOT NULL DEFAULT '0', - `RTOperand3` int(10) unsigned NOT NULL DEFAULT '0', - `RTOperand4` int(10) unsigned NOT NULL DEFAULT '0', - `RTOperand5` int(10) 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', + `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', `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, + `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` -- @@ -2886,6 +5303,45 @@ CREATE TABLE `spell_learn_spell` ( /*!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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `BaseLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `MaxLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `SpellLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxUsableLevel` 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_locale` +-- + +DROP TABLE IF EXISTS `spell_locale`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `spell_locale` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `locale` varchar(4) NOT NULL, + `Name_lang` text, + `NameSubtext_lang` text, + `Description_lang` text, + `AuraDescription_lang` text, + `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_misc` -- @@ -2908,14 +5364,14 @@ CREATE TABLE `spell_misc` ( `AttributesExK` int(10) unsigned NOT NULL DEFAULT '0', `AttributesExL` int(10) unsigned NOT NULL DEFAULT '0', `AttributesExM` int(10) unsigned NOT NULL DEFAULT '0', - `CastingTimeIndex` int(10) unsigned NOT NULL DEFAULT '0', - `DurationIndex` int(10) unsigned NOT NULL DEFAULT '0', - `RangeIndex` int(10) unsigned NOT NULL DEFAULT '0', `Speed` float NOT NULL DEFAULT '0', - `SpellIconID` int(10) unsigned NOT NULL DEFAULT '0', - `ActiveIconID` int(10) unsigned NOT NULL DEFAULT '0', - `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0', `MultistrikeSpeedMod` float 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', + `SpellIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ActiveIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `SchoolMask` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2929,20 +5385,20 @@ 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', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', - `PowerIndex` int(10) unsigned NOT NULL DEFAULT '0', - `PowerType` int(10) unsigned NOT NULL DEFAULT '0', `ManaCost` int(10) unsigned NOT NULL DEFAULT '0', - `ManaCostPerLevel` int(10) unsigned NOT NULL DEFAULT '0', - `ManaCostPerSecond` int(10) unsigned NOT NULL DEFAULT '0', - `ManaCostAdditional` int(10) unsigned NOT NULL DEFAULT '0', - `PowerDisplayID` int(10) unsigned NOT NULL DEFAULT '0', - `UnitPowerBarID` int(10) unsigned NOT NULL DEFAULT '0', `ManaCostPercentage` float NOT NULL DEFAULT '0', `ManaCostPercentagePerSecond` float NOT NULL DEFAULT '0', `RequiredAura` int(10) unsigned NOT NULL DEFAULT '0', `HealthCostPercentage` float NOT NULL DEFAULT '0', + `PowerIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PowerType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ManaCostPerLevel` int(11) NOT NULL DEFAULT '0', + `ManaCostPerSecond` int(11) NOT NULL DEFAULT '0', + `ManaCostAdditional` int(10) unsigned NOT NULL DEFAULT '0', + `PowerDisplayID` int(10) unsigned NOT NULL DEFAULT '0', + `UnitPowerBarID` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -2956,11 +5412,45 @@ 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` ( - `SpellPowerID` int(10) unsigned NOT NULL DEFAULT '0', - `DifficultyID` int(10) unsigned NOT NULL DEFAULT '0', - `PowerIndex` int(10) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `PowerIndex` tinyint(3) unsigned 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 `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', + `Coeff` float NOT NULL DEFAULT '0', + `Param` smallint(5) unsigned NOT NULL DEFAULT '0', + `Type` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SpellProcsPerMinuteID` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', - PRIMARY KEY (`SpellPowerID`) + PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; @@ -2995,9 +5485,9 @@ CREATE TABLE `spell_range` ( `MinRangeFriend` float NOT NULL DEFAULT '0', `MaxRangeHostile` float NOT NULL DEFAULT '0', `MaxRangeFriend` float NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `DisplayName` text, `DisplayNameShort` text, + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3029,6 +5519,7 @@ DROP TABLE IF EXISTS `spell_reagents`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_reagents` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned 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', @@ -3037,35 +5528,125 @@ CREATE TABLE `spell_reagents` ( `Reagent6` int(11) NOT NULL DEFAULT '0', `Reagent7` int(11) NOT NULL DEFAULT '0', `Reagent8` int(11) NOT NULL DEFAULT '0', - `ReagentCount1` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount2` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount3` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount4` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount5` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount6` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount7` int(10) unsigned NOT NULL DEFAULT '0', - `ReagentCount8` int(10) unsigned NOT NULL DEFAULT '0', - `CurrencyID` int(10) unsigned NOT NULL DEFAULT '0', - `CurrencyCount` int(10) unsigned NOT NULL DEFAULT '0', + `ReagentCount1` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount2` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount3` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount4` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount5` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount6` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount7` smallint(5) unsigned NOT NULL DEFAULT '0', + `ReagentCount8` 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_rune_cost` +-- Table structure for table `spell_scaling` -- -DROP TABLE IF EXISTS `spell_rune_cost`; +DROP TABLE IF EXISTS `spell_scaling`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; -CREATE TABLE `spell_rune_cost` ( +CREATE TABLE `spell_scaling` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `Blood` int(10) unsigned NOT NULL DEFAULT '0', - `Unholy` int(10) unsigned NOT NULL DEFAULT '0', - `Frost` int(10) unsigned NOT NULL DEFAULT '0', - `Chromatic` int(10) unsigned NOT NULL DEFAULT '0', - `RunicPower` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `ScalesFromItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', + `ScalingClass` int(11) NOT NULL DEFAULT '0', + `MinScalingLevel` int(10) unsigned NOT NULL DEFAULT '0', + `MaxScalingLevel` 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` +-- + +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(10) unsigned NOT NULL DEFAULT '0', + `ShapeshiftExclude1` int(10) unsigned NOT NULL DEFAULT '0', + `ShapeshiftExclude2` int(10) unsigned NOT NULL DEFAULT '0', + `ShapeshiftMask1` int(10) unsigned NOT NULL DEFAULT '0', + `ShapeshiftMask2` int(10) unsigned NOT NULL DEFAULT '0', + `StanceBarOrder` 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_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, + `WeaponDamageVariance` float NOT NULL DEFAULT '0', + `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `AttackIconID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CombatRoundTime` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureDisplayID1` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureDisplayID2` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureDisplayID3` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureDisplayID4` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID1` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID2` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID3` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID4` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID5` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID6` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID7` smallint(5) unsigned NOT NULL DEFAULT '0', + `PresetSpellID8` smallint(5) unsigned NOT NULL DEFAULT '0', + `MountTypeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CreatureType` tinyint(4) NOT NULL DEFAULT '0', + `BonusActionBar` 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_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, + `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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `ConeAngle` float NOT NULL DEFAULT '0', + `Width` float NOT NULL DEFAULT '0', + `Targets` int(10) unsigned NOT NULL DEFAULT '0', + `TargetCreatureType` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxAffectedTargets` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3080,10 +5661,11 @@ DROP TABLE IF EXISTS `spell_totems`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_totems` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredTotemCategoryID1` int(10) unsigned NOT NULL DEFAULT '0', - `RequiredTotemCategoryID2` int(10) unsigned NOT NULL DEFAULT '0', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', `Totem1` int(10) unsigned NOT NULL DEFAULT '0', `Totem2` int(10) unsigned NOT NULL DEFAULT '0', + `RequiredTotemCategoryID1` smallint(5) unsigned NOT NULL DEFAULT '0', + `RequiredTotemCategoryID2` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3097,20 +5679,109 @@ 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', `SpellID` int(10) unsigned NOT NULL DEFAULT '0', - `DifficultyID` int(10) unsigned NOT NULL DEFAULT '0', - `SpellVisualID1` int(10) unsigned NOT NULL DEFAULT '0', - `SpellVisualID2` int(10) unsigned NOT NULL DEFAULT '0', `Unk620` float NOT NULL DEFAULT '0', - `PlayerConditionID` int(10) unsigned NOT NULL DEFAULT '0', + `SpellVisualID1` smallint(5) unsigned NOT NULL DEFAULT '0', + `SpellVisualID2` smallint(5) unsigned NOT NULL DEFAULT '0', + `PlayerConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DifficultyID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned 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 `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', `Flags` int(10) unsigned NOT NULL DEFAULT '0', + `Category` int(10) unsigned NOT NULL DEFAULT '0', + `Faction` int(10) unsigned NOT NULL DEFAULT '0', + `Type` int(11) NOT NULL DEFAULT '0', + `Slot` 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', + `SpellID` int(10) unsigned NOT NULL DEFAULT '0', + `OverridesSpellID` int(10) unsigned NOT NULL DEFAULT '0', + `Description` text, + `SpecID` smallint(5) unsigned NOT NULL DEFAULT '0', + `TierID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ColumnIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CategoryMask1` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CategoryMask2` tinyint(3) unsigned 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 `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, + `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` -- @@ -3118,19 +5789,19 @@ DROP TABLE IF EXISTS `taxi_nodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `taxi_nodes` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `MapID` 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', `Name` text, `MountCreatureID1` int(10) unsigned NOT NULL DEFAULT '0', `MountCreatureID2` int(10) unsigned NOT NULL DEFAULT '0', - `ConditionID` int(10) unsigned NOT NULL DEFAULT '0', - `LearnableIndex` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `MapOffsetX` float NOT NULL DEFAULT '0', `MapOffsetY` float NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ConditionID` smallint(5) unsigned NOT NULL DEFAULT '0', + `LearnableIndex` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned 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; @@ -3160,9 +5831,9 @@ DROP TABLE IF EXISTS `taxi_path`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `taxi_path` ( + `From` smallint(5) unsigned NOT NULL DEFAULT '0', + `To` smallint(5) unsigned NOT NULL DEFAULT '0', `ID` int(10) unsigned NOT NULL DEFAULT '0', - `From` int(10) unsigned NOT NULL DEFAULT '0', - `To` 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`) @@ -3177,17 +5848,17 @@ 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` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', - `PathID` int(10) unsigned NOT NULL DEFAULT '0', - `NodeIndex` int(10) unsigned NOT NULL DEFAULT '0', - `MapID` int(10) unsigned NOT NULL DEFAULT '0', `LocX` float NOT NULL DEFAULT '0', `LocY` float NOT NULL DEFAULT '0', `LocZ` float NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Delay` int(10) unsigned NOT NULL DEFAULT '0', - `ArrivalEventID` int(10) unsigned NOT NULL DEFAULT '0', - `DepartureEventID` int(10) unsigned NOT NULL DEFAULT '0', + `PathID` smallint(5) unsigned NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ArrivalEventID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DepartureEventID` smallint(5) unsigned NOT NULL DEFAULT '0', + `NodeIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned 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; @@ -3203,8 +5874,8 @@ DROP TABLE IF EXISTS `totem_category`; CREATE TABLE `totem_category` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, - `CategoryType` int(10) unsigned NOT NULL DEFAULT '0', `CategoryMask` int(10) unsigned NOT NULL DEFAULT '0', + `CategoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3234,11 +5905,11 @@ DROP TABLE IF EXISTS `toy`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `toy` ( - `ID` int(10) unsigned NOT NULL DEFAULT '0', `ItemID` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Description` text, - `CategoryFilter` int(10) NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `CategoryFilter` tinyint(3) unsigned 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; @@ -3254,7 +5925,7 @@ DROP TABLE IF EXISTS `toy_locale`; CREATE TABLE `toy_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, - `Description_lang` text NOT NULL, + `Description_lang` text, `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3274,7 +5945,7 @@ CREATE TABLE `transport_animation` ( `PosX` float NOT NULL DEFAULT '0', `PosY` float NOT NULL DEFAULT '0', `PosZ` float NOT NULL DEFAULT '0', - `SequenceID` int(10) unsigned NOT NULL DEFAULT '0', + `SequenceID` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3309,13 +5980,8 @@ DROP TABLE IF EXISTS `unit_power_bar`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `unit_power_bar` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', - `MinPower` int(10) unsigned NOT NULL DEFAULT '0', - `MaxPower` int(10) unsigned NOT NULL DEFAULT '0', - `StartPower` int(10) unsigned NOT NULL DEFAULT '0', - `CenterPower` int(10) unsigned NOT NULL DEFAULT '0', `RegenerationPeace` float NOT NULL DEFAULT '0', `RegenerationCombat` float NOT NULL DEFAULT '0', - `BarType` int(10) unsigned NOT NULL DEFAULT '0', `FileDataID1` int(10) unsigned NOT NULL DEFAULT '0', `FileDataID2` int(10) unsigned NOT NULL DEFAULT '0', `FileDataID3` int(10) unsigned NOT NULL DEFAULT '0', @@ -3328,13 +5994,18 @@ CREATE TABLE `unit_power_bar` ( `Color4` int(10) unsigned NOT NULL DEFAULT '0', `Color5` int(10) unsigned NOT NULL DEFAULT '0', `Color6` int(10) unsigned NOT NULL DEFAULT '0', - `Flags` int(10) unsigned NOT NULL DEFAULT '0', `Name` text, `Cost` text, `OutOfError` text, `ToolTip` text, `StartInset` float NOT NULL DEFAULT '0', `EndInset` float NOT NULL DEFAULT '0', + `StartPower` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `CenterPower` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BarType` tinyint(3) unsigned NOT NULL DEFAULT '0', + `MinPower` int(10) unsigned NOT NULL DEFAULT '0', + `MaxPower` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3391,6 +6062,213 @@ CREATE TABLE `updates_include` ( /*!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(10) 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', + `MsslTrgtTurnLingering` float NOT NULL DEFAULT '0', + `MsslTrgtPitchLingering` float NOT NULL DEFAULT '0', + `MsslTrgtMouseLingering` float NOT NULL DEFAULT '0', + `MsslTrgtEndOpacity` float NOT NULL DEFAULT '0', + `MsslTrgtArcSpeed` float NOT NULL DEFAULT '0', + `MsslTrgtArcRepeat` float NOT NULL DEFAULT '0', + `MsslTrgtArcWidth` float NOT NULL DEFAULT '0', + `MsslTrgtImpactRadius1` float NOT NULL DEFAULT '0', + `MsslTrgtImpactRadius2` float NOT NULL DEFAULT '0', + `MsslTrgtArcTexture` text, + `MsslTrgtImpactTexture` text, + `MsslTrgtImpactModel1` text, + `MsslTrgtImpactModel2` text, + `CameraYawOffset` float NOT NULL DEFAULT '0', + `MsslTrgtImpactTexRadius` float 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', + `VehicleUIIndicatorID` 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', + `FlagsB` tinyint(3) unsigned NOT NULL DEFAULT '0', + `UILocomotionType` 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 `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', + `Flags1` int(10) unsigned NOT NULL DEFAULT '0', + `Flags2` int(10) unsigned NOT NULL DEFAULT '0', + `Flags3` 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', + `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', + `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', + `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', + `CameraEnteringDelay` float NOT NULL DEFAULT '0', + `CameraEnteringDuration` float NOT NULL DEFAULT '0', + `CameraExitingDelay` float NOT NULL DEFAULT '0', + `CameraExitingDuration` float NOT NULL DEFAULT '0', + `CameraOffsetX` float NOT NULL DEFAULT '0', + `CameraOffsetY` float NOT NULL DEFAULT '0', + `CameraOffsetZ` 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', + `UISkinFileDataID` int(10) unsigned NOT NULL DEFAULT '0', + `EnterAnimStart` smallint(6) NOT NULL DEFAULT '0', + `EnterAnimLoop` smallint(6) NOT NULL DEFAULT '0', + `RideAnimStart` smallint(6) NOT NULL DEFAULT '0', + `RideAnimLoop` smallint(6) NOT NULL DEFAULT '0', + `RideUpperAnimStart` smallint(6) NOT NULL DEFAULT '0', + `RideUpperAnimLoop` smallint(6) NOT NULL DEFAULT '0', + `ExitAnimStart` smallint(6) NOT NULL DEFAULT '0', + `ExitAnimLoop` smallint(6) NOT NULL DEFAULT '0', + `ExitAnimEnd` smallint(6) NOT NULL DEFAULT '0', + `VehicleEnterAnim` smallint(6) NOT NULL DEFAULT '0', + `VehicleExitAnim` smallint(6) NOT NULL DEFAULT '0', + `VehicleRideAnimLoop` smallint(6) NOT NULL DEFAULT '0', + `EnterAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `RideAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ExitAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `VehicleEnterAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `VehicleRideAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `VehicleExitAnimKitID` smallint(5) unsigned NOT NULL DEFAULT '0', + `CameraModeID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AttachmentID` tinyint(4) NOT NULL DEFAULT '0', + `PassengerAttachmentID` tinyint(4) NOT NULL DEFAULT '0', + `VehicleEnterAnimBone` tinyint(4) NOT NULL DEFAULT '0', + `VehicleExitAnimBone` tinyint(4) NOT NULL DEFAULT '0', + `VehicleRideAnimLoopBone` tinyint(4) NOT NULL DEFAULT '0', + `VehicleAbilityDisplay` tinyint(3) unsigned NOT NULL DEFAULT '0', + `EnterUISoundID` int(10) unsigned NOT NULL DEFAULT '0', + `ExitUISoundID` 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 `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` ( + `WMOGroupID` int(11) NOT NULL DEFAULT '0', + `AreaName` text, + `WMOID` smallint(6) NOT NULL DEFAULT '0', + `AmbienceID` smallint(5) unsigned NOT NULL DEFAULT '0', + `ZoneMusic` smallint(5) unsigned NOT NULL DEFAULT '0', + `IntroSound` smallint(5) unsigned NOT NULL DEFAULT '0', + `AreaTableID` smallint(5) unsigned NOT NULL DEFAULT '0', + `UWIntroSound` smallint(5) unsigned NOT NULL DEFAULT '0', + `UWAmbience` smallint(5) unsigned NOT NULL DEFAULT '0', + `NameSet` tinyint(4) NOT NULL DEFAULT '0', + `SoundProviderPref` tinyint(3) unsigned NOT NULL DEFAULT '0', + `SoundProviderPrefUnderwater` tinyint(3) unsigned NOT NULL DEFAULT '0', + `Flags` tinyint(3) unsigned NOT NULL DEFAULT '0', + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `UWZoneMusic` 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 `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, + `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_map_area` +-- + +DROP TABLE IF EXISTS `world_map_area`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `world_map_area` ( + `AreaName` text, + `LocLeft` float NOT NULL DEFAULT '0', + `LocRight` float NOT NULL DEFAULT '0', + `LocTop` float NOT NULL DEFAULT '0', + `LocBottom` float NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0', + `DisplayMapID` smallint(6) NOT NULL DEFAULT '0', + `DefaultDungeonFloor` smallint(6) NOT NULL DEFAULT '0', + `ParentWorldMapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `Flags` smallint(5) unsigned NOT NULL DEFAULT '0', + `LevelRangeMin` tinyint(3) unsigned NOT NULL DEFAULT '0', + `LevelRangeMax` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BountySetID` tinyint(3) unsigned NOT NULL DEFAULT '0', + `BountyBoardLocation` tinyint(3) unsigned NOT NULL DEFAULT '0', + `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 `world_map_overlay` -- @@ -3399,37 +6277,87 @@ DROP TABLE IF EXISTS `world_map_overlay`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `world_map_overlay` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', + `TextureName` text, + `TextureWidth` smallint(5) unsigned NOT NULL DEFAULT '0', + `TextureHeight` smallint(5) unsigned NOT NULL DEFAULT '0', `MapAreaID` 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', - `TextureName` text, - `TextureWidth` int(10) unsigned NOT NULL DEFAULT '0', - `TextureHeight` int(10) unsigned NOT NULL DEFAULT '0', - `OffsetX` int(10) unsigned NOT NULL DEFAULT '0', - `OffsetY` int(10) unsigned NOT NULL DEFAULT '0', - `HitRectTop` int(10) unsigned NOT NULL DEFAULT '0', - `HitRectLeft` int(10) unsigned NOT NULL DEFAULT '0', - `HitRectBottom` int(10) unsigned NOT NULL DEFAULT '0', - `HitRectRight` int(10) 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', + `HitRectLeft` int(11) NOT NULL DEFAULT '0', + `HitRectBottom` 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', + `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_transforms` +-- + +DROP TABLE IF EXISTS `world_map_transforms`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `world_map_transforms` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RegionMinX` float NOT NULL DEFAULT '0', + `RegionMinY` float NOT NULL DEFAULT '0', + `RegionMinZ` float NOT NULL DEFAULT '0', + `RegionMaxX` float NOT NULL DEFAULT '0', + `RegionMaxY` float NOT NULL DEFAULT '0', + `RegionMaxZ` float NOT NULL DEFAULT '0', + `RegionOffsetX` float NOT NULL DEFAULT '0', + `RegionOffsetY` float NOT NULL DEFAULT '0', + `RegionScale` float NOT NULL DEFAULT '0', + `MapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `AreaID` smallint(5) unsigned NOT NULL DEFAULT '0', + `NewMapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `NewDungeonMapID` smallint(5) unsigned NOT NULL DEFAULT '0', + `NewAreaID` 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 `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', + `LocX` float NOT NULL DEFAULT '0', + `LocY` float NOT NULL DEFAULT '0', + `LocZ` float NOT NULL DEFAULT '0', + `Facing` float NOT NULL DEFAULT '0', + `AreaName` text, + `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 `world_map_overlay_locale` +-- Table structure for table `world_safe_locs_locale` -- -DROP TABLE IF EXISTS `world_map_overlay_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_map_overlay_locale` ( +CREATE TABLE `world_safe_locs_locale` ( `ID` int(10) unsigned NOT NULL DEFAULT '0', `locale` varchar(4) NOT NULL, - `TextureName_lang` text, + `AreaName_lang` text, `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`ID`,`locale`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -3444,4 +6372,4 @@ CREATE TABLE `world_map_overlay_locale` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2016-04-11 2:02:49 +-- Dump completed on 2016-10-16 17:35:49 |