-- MySQL dump 10.13 Distrib 5.6.9-rc, for Win64 (x86_64) -- -- Host: localhost Database: world -- ------------------------------------------------------ -- Server version 5.6.9-rc /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `access_requirement` -- DROP TABLE IF EXISTS `access_requirement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `access_requirement` ( `mapId` mediumint(8) unsigned NOT NULL, `difficulty` tinyint(3) unsigned NOT NULL DEFAULT '0', `level_min` tinyint(3) unsigned NOT NULL DEFAULT '0', `level_max` tinyint(3) unsigned NOT NULL DEFAULT '0', `item_level` smallint(5) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `item2` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_done_A` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_done_H` mediumint(8) unsigned NOT NULL DEFAULT '0', `completed_achievement` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_failed_text` text, `comment` text, PRIMARY KEY (`mapId`,`difficulty`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Access Requirements'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_criteria_data` -- DROP TABLE IF EXISTS `achievement_criteria_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_criteria_data` ( `criteria_id` mediumint(8) NOT NULL, `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `value1` mediumint(8) unsigned NOT NULL DEFAULT '0', `value2` mediumint(8) unsigned NOT NULL DEFAULT '0', `ScriptName` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`criteria_id`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Achievment system'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_dbc` -- DROP TABLE IF EXISTS `achievement_dbc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_dbc` ( `ID` int(10) unsigned NOT NULL, `requiredFaction` int(11) NOT NULL DEFAULT '-1', `mapID` int(11) NOT NULL DEFAULT '-1', `points` int(10) unsigned NOT NULL DEFAULT '0', `flags` int(10) unsigned NOT NULL DEFAULT '0', `count` int(10) unsigned NOT NULL DEFAULT '0', `refAchievement` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `achievement_reward` -- DROP TABLE IF EXISTS `achievement_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `achievement_reward` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `title_A` mediumint(8) unsigned NOT NULL DEFAULT '0', `title_H` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `sender` mediumint(8) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) DEFAULT NULL, `text` text, `mailTemplate` mediumint(8) unsigned DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `areatrigger_involvedrelation` -- DROP TABLE IF EXISTS `areatrigger_involvedrelation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `areatrigger_involvedrelation` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `areatrigger_scripts` -- DROP TABLE IF EXISTS `areatrigger_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `areatrigger_scripts` ( `entry` mediumint(8) NOT NULL, `ScriptName` char(64) NOT NULL, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `areatrigger_tavern` -- DROP TABLE IF EXISTS `areatrigger_tavern`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `areatrigger_tavern` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `name` text, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `areatrigger_teleport` -- DROP TABLE IF EXISTS `areatrigger_teleport`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `areatrigger_teleport` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `name` text, `target_map` smallint(5) unsigned NOT NULL DEFAULT '0', `target_position_x` float NOT NULL DEFAULT '0', `target_position_y` float NOT NULL DEFAULT '0', `target_position_z` float NOT NULL DEFAULT '0', `target_orientation` float NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`id`), FULLTEXT KEY `name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battleground_template` -- DROP TABLE IF EXISTS `battleground_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battleground_template` ( `id` mediumint(8) unsigned NOT NULL, `MinPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0', `MaxPlayersPerTeam` smallint(5) unsigned NOT NULL DEFAULT '0', `MinLvl` tinyint(3) unsigned NOT NULL DEFAULT '0', `MaxLvl` tinyint(3) unsigned NOT NULL DEFAULT '0', `AllianceStartLoc` mediumint(8) unsigned NOT NULL, `AllianceStartO` float NOT NULL, `HordeStartLoc` mediumint(8) unsigned NOT NULL, `HordeStartO` float NOT NULL, `StartMaxDist` float NOT NULL DEFAULT '0', `Weight` tinyint(3) unsigned NOT NULL DEFAULT '1', `ScriptName` char(64) NOT NULL DEFAULT '', `Comment` char(32) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `battlemaster_entry` -- DROP TABLE IF EXISTS `battlemaster_entry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `battlemaster_entry` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of a creature', `bg_template` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Battleground template id', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `broadcast_text` -- DROP TABLE IF EXISTS `broadcast_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `broadcast_text` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `Language` mediumint(8) unsigned NOT NULL DEFAULT '0', `MaleText` longtext, `FemaleText` longtext, `EmoteID0` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteID1` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteID2` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteDelay0` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteDelay1` mediumint(8) unsigned NOT NULL DEFAULT '0', `EmoteDelay2` mediumint(8) unsigned NOT NULL DEFAULT '0', `SoundId` mediumint(8) unsigned NOT NULL DEFAULT '0', `Unk1` mediumint(8) unsigned NOT NULL DEFAULT '0', `Unk2` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `command` -- DROP TABLE IF EXISTS `command`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `command` ( `name` varchar(50) NOT NULL DEFAULT '', `permission` smallint(5) unsigned NOT NULL DEFAULT '0', `help` longtext, PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `conditions` -- DROP TABLE IF EXISTS `conditions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conditions` ( `SourceTypeOrReferenceId` mediumint(8) NOT NULL DEFAULT '0', `SourceGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', `SourceEntry` mediumint(8) NOT NULL DEFAULT '0', `SourceId` int(11) NOT NULL DEFAULT '0', `ElseGroup` mediumint(8) unsigned NOT NULL DEFAULT '0', `ConditionTypeOrReference` mediumint(8) NOT NULL DEFAULT '0', `ConditionTarget` tinyint(3) unsigned NOT NULL DEFAULT '0', `ConditionValue1` mediumint(8) unsigned NOT NULL DEFAULT '0', `ConditionValue2` mediumint(8) unsigned NOT NULL DEFAULT '0', `ConditionValue3` mediumint(8) unsigned NOT NULL DEFAULT '0', `NegativeCondition` tinyint(3) unsigned NOT NULL DEFAULT '0', `ErrorType` mediumint(8) unsigned NOT NULL DEFAULT '0', `ErrorTextId` mediumint(8) unsigned NOT NULL DEFAULT '0', `ScriptName` char(64) NOT NULL DEFAULT '', `Comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Condition System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature` -- DROP TABLE IF EXISTS `creature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature` ( `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1', `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', `equipment_id` tinyint(3) NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `spawntimesecs` int(10) unsigned NOT NULL DEFAULT '120', `spawndist` float NOT NULL DEFAULT '0', `currentwaypoint` mediumint(8) unsigned NOT NULL DEFAULT '0', `curhealth` int(10) unsigned NOT NULL DEFAULT '1', `curmana` int(10) unsigned NOT NULL DEFAULT '0', `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', `npcflag` int(10) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`guid`), KEY `idx_map` (`map`), KEY `idx_id` (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1022682 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_addon` -- DROP TABLE IF EXISTS `creature_addon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_addon` ( `guid` int(10) unsigned NOT NULL DEFAULT '0', `path_id` int(10) unsigned NOT NULL DEFAULT '0', `mount` mediumint(8) unsigned NOT NULL DEFAULT '0', `bytes1` int(10) unsigned NOT NULL DEFAULT '0', `bytes2` int(10) unsigned NOT NULL DEFAULT '0', `emote` int(10) unsigned NOT NULL DEFAULT '0', `auras` text, PRIMARY KEY (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_classlevelstats` -- DROP TABLE IF EXISTS `creature_classlevelstats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_classlevelstats` ( `level` tinyint(3) unsigned NOT NULL, `class` tinyint(3) unsigned NOT NULL, `basehp0` smallint(5) unsigned NOT NULL DEFAULT '1', `basehp1` smallint(5) unsigned NOT NULL DEFAULT '1', `basehp2` smallint(5) unsigned NOT NULL DEFAULT '1', `basemana` smallint(5) unsigned NOT NULL DEFAULT '0', `basearmor` smallint(5) unsigned NOT NULL DEFAULT '1', `attackpower` smallint(5) unsigned NOT NULL DEFAULT '0', `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0', `damage_base` float NOT NULL DEFAULT '0', `damage_exp1` float NOT NULL DEFAULT '0', `damage_exp2` float NOT NULL DEFAULT '0', `comment` text, PRIMARY KEY (`level`,`class`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_equip_template` -- DROP TABLE IF EXISTS `creature_equip_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_equip_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `id` tinyint(3) unsigned NOT NULL DEFAULT '0', `itemEntry1` mediumint(8) unsigned NOT NULL DEFAULT '0', `itemEntry2` mediumint(8) unsigned NOT NULL DEFAULT '0', `itemEntry3` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_formations` -- DROP TABLE IF EXISTS `creature_formations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_formations` ( `leaderGUID` int(10) unsigned NOT NULL, `memberGUID` int(10) unsigned NOT NULL, `dist` float unsigned NOT NULL, `angle` float unsigned NOT NULL, `groupAI` int(10) unsigned NOT NULL, `point_1` smallint(5) unsigned NOT NULL DEFAULT '0', `point_2` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`memberGUID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_loot_template` -- DROP TABLE IF EXISTS `creature_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_model_info` -- DROP TABLE IF EXISTS `creature_model_info`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_model_info` ( `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', `bounding_radius` float NOT NULL DEFAULT '0', `combat_reach` float NOT NULL DEFAULT '0', `gender` tinyint(3) unsigned NOT NULL DEFAULT '2', `modelid_other_gender` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`modelid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Model related info)'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_onkill_reputation` -- DROP TABLE IF EXISTS `creature_onkill_reputation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_onkill_reputation` ( `creature_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature Identifier', `RewOnKillRepFaction1` smallint(6) NOT NULL DEFAULT '0', `RewOnKillRepFaction2` smallint(6) NOT NULL DEFAULT '0', `MaxStanding1` tinyint(4) NOT NULL DEFAULT '0', `IsTeamAward1` tinyint(4) NOT NULL DEFAULT '0', `RewOnKillRepValue1` mediumint(8) NOT NULL DEFAULT '0', `MaxStanding2` tinyint(4) NOT NULL DEFAULT '0', `IsTeamAward2` tinyint(4) NOT NULL DEFAULT '0', `RewOnKillRepValue2` mediumint(9) NOT NULL DEFAULT '0', `TeamDependent` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`creature_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_questender` -- DROP TABLE IF EXISTS `creature_questender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_questender` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_queststarter` -- DROP TABLE IF EXISTS `creature_queststarter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_queststarter` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_summon_groups` -- DROP TABLE IF EXISTS `creature_summon_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_summon_groups` ( `summonerId` mediumint(8) unsigned NOT NULL DEFAULT '0', `summonerType` tinyint(3) unsigned NOT NULL DEFAULT '0', `groupId` tinyint(3) unsigned NOT NULL DEFAULT '0', `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `summonType` tinyint(3) unsigned NOT NULL DEFAULT '0', `summonTime` int(10) unsigned NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_template` -- DROP TABLE IF EXISTS `creature_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `difficulty_entry_1` mediumint(8) unsigned NOT NULL DEFAULT '0', `difficulty_entry_2` mediumint(8) unsigned NOT NULL DEFAULT '0', `difficulty_entry_3` mediumint(8) unsigned NOT NULL DEFAULT '0', `KillCredit1` int(10) unsigned NOT NULL DEFAULT '0', `KillCredit2` int(10) unsigned NOT NULL DEFAULT '0', `modelid1` mediumint(8) unsigned NOT NULL DEFAULT '0', `modelid2` mediumint(8) unsigned NOT NULL DEFAULT '0', `modelid3` mediumint(8) unsigned NOT NULL DEFAULT '0', `modelid4` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` char(100) NOT NULL DEFAULT '0', `subname` char(100) DEFAULT NULL, `IconName` char(100) DEFAULT NULL, `gossip_menu_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `minlevel` tinyint(3) unsigned NOT NULL DEFAULT '1', `maxlevel` tinyint(3) unsigned NOT NULL DEFAULT '1', `exp` smallint(6) NOT NULL DEFAULT '0', `faction` smallint(5) unsigned NOT NULL DEFAULT '0', `npcflag` int(10) unsigned NOT NULL DEFAULT '0', `speed_walk` float NOT NULL DEFAULT '1' COMMENT 'Result of 2.5/2.5, most common value', `speed_run` float NOT NULL DEFAULT '1.14286' COMMENT 'Result of 8.0/7.0, most common value', `scale` float NOT NULL DEFAULT '1', `rank` tinyint(3) unsigned NOT NULL DEFAULT '0', `mindmg` float NOT NULL DEFAULT '0', `maxdmg` float NOT NULL DEFAULT '0', `dmgschool` tinyint(4) NOT NULL DEFAULT '0', `attackpower` int(10) unsigned NOT NULL DEFAULT '0', `dmg_multiplier` float NOT NULL DEFAULT '1', `baseattacktime` int(10) unsigned NOT NULL DEFAULT '0', `rangeattacktime` int(10) unsigned NOT NULL DEFAULT '0', `unit_class` tinyint(3) unsigned NOT NULL DEFAULT '0', `unit_flags` int(10) unsigned NOT NULL DEFAULT '0', `unit_flags2` int(10) unsigned NOT NULL DEFAULT '0', `dynamicflags` int(10) unsigned NOT NULL DEFAULT '0', `family` tinyint(4) NOT NULL DEFAULT '0', `trainer_type` tinyint(4) NOT NULL DEFAULT '0', `trainer_spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `trainer_class` tinyint(3) unsigned NOT NULL DEFAULT '0', `trainer_race` tinyint(3) unsigned NOT NULL DEFAULT '0', `minrangedmg` float NOT NULL DEFAULT '0', `maxrangedmg` float NOT NULL DEFAULT '0', `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `type_flags` int(10) unsigned NOT NULL DEFAULT '0', `lootid` mediumint(8) unsigned NOT NULL DEFAULT '0', `pickpocketloot` mediumint(8) unsigned NOT NULL DEFAULT '0', `skinloot` mediumint(8) unsigned NOT NULL DEFAULT '0', `resistance1` smallint(6) NOT NULL DEFAULT '0', `resistance2` smallint(6) NOT NULL DEFAULT '0', `resistance3` smallint(6) NOT NULL DEFAULT '0', `resistance4` smallint(6) NOT NULL DEFAULT '0', `resistance5` smallint(6) NOT NULL DEFAULT '0', `resistance6` smallint(6) NOT NULL DEFAULT '0', `spell1` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell2` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell3` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell4` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell5` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell6` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell7` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell8` mediumint(8) unsigned NOT NULL DEFAULT '0', `PetSpellDataId` mediumint(8) unsigned NOT NULL DEFAULT '0', `VehicleId` mediumint(8) unsigned NOT NULL DEFAULT '0', `mingold` mediumint(8) unsigned NOT NULL DEFAULT '0', `maxgold` mediumint(8) unsigned NOT NULL DEFAULT '0', `AIName` char(64) NOT NULL DEFAULT '', `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0', `InhabitType` tinyint(3) unsigned NOT NULL DEFAULT '3', `HoverHeight` float NOT NULL DEFAULT '1', `Health_mod` float NOT NULL DEFAULT '1', `Mana_mod` float NOT NULL DEFAULT '1', `Armor_mod` float NOT NULL DEFAULT '1', `RacialLeader` tinyint(3) unsigned NOT NULL DEFAULT '0', `questItem1` int(10) unsigned NOT NULL DEFAULT '0', `questItem2` int(10) unsigned NOT NULL DEFAULT '0', `questItem3` int(10) unsigned NOT NULL DEFAULT '0', `questItem4` int(10) unsigned NOT NULL DEFAULT '0', `questItem5` int(10) unsigned NOT NULL DEFAULT '0', `questItem6` int(10) unsigned NOT NULL DEFAULT '0', `movementId` int(11) unsigned NOT NULL DEFAULT '0', `RegenHealth` tinyint(3) unsigned NOT NULL DEFAULT '1', `mechanic_immune_mask` int(10) unsigned NOT NULL DEFAULT '0', `flags_extra` int(10) unsigned NOT NULL DEFAULT '0', `ScriptName` char(64) NOT NULL DEFAULT '', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`), KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_template_addon` -- DROP TABLE IF EXISTS `creature_template_addon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_template_addon` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `path_id` int(10) unsigned NOT NULL DEFAULT '0', `mount` mediumint(8) unsigned NOT NULL DEFAULT '0', `bytes1` int(10) unsigned NOT NULL DEFAULT '0', `bytes2` int(10) unsigned NOT NULL DEFAULT '0', `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', `auras` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `creature_text` -- DROP TABLE IF EXISTS `creature_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `creature_text` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `id` tinyint(3) unsigned NOT NULL DEFAULT '0', `text` longtext, `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `language` tinyint(3) unsigned NOT NULL DEFAULT '0', `probability` float NOT NULL DEFAULT '0', `emote` mediumint(8) unsigned NOT NULL DEFAULT '0', `duration` mediumint(8) unsigned NOT NULL DEFAULT '0', `sound` mediumint(8) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT '', `BroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`groupid`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `db_script_string` -- DROP TABLE IF EXISTS `db_script_string`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `db_script_string` ( `entry` int(10) unsigned NOT NULL DEFAULT '0', `content_default` text NOT NULL, `content_loc1` text, `content_loc2` text, `content_loc3` text, `content_loc4` text, `content_loc5` text, `content_loc6` text, `content_loc7` text, `content_loc8` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `disables` -- DROP TABLE IF EXISTS `disables`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `disables` ( `sourceType` int(10) unsigned NOT NULL, `entry` int(10) unsigned NOT NULL, `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `params_0` varchar(255) NOT NULL DEFAULT '', `params_1` varchar(255) NOT NULL DEFAULT '', `comment` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`sourceType`,`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `disenchant_loot_template` -- DROP TABLE IF EXISTS `disenchant_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `disenchant_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Recommended id selection: item_level*100 + item_quality', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(9) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `event_scripts` -- DROP TABLE IF EXISTS `event_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `event_scripts` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `delay` int(10) unsigned NOT NULL DEFAULT '0', `command` mediumint(8) unsigned NOT NULL DEFAULT '0', `datalong` mediumint(8) unsigned NOT NULL DEFAULT '0', `datalong2` int(10) unsigned NOT NULL DEFAULT '0', `dataint` int(11) NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `exploration_basexp` -- DROP TABLE IF EXISTS `exploration_basexp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `exploration_basexp` ( `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `basexp` mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (`level`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `fishing_loot_template` -- DROP TABLE IF EXISTS `fishing_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `fishing_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event` -- DROP TABLE IF EXISTS `game_event`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `start_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before', `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler', `occurence` bigint(20) unsigned NOT NULL DEFAULT '5184000' COMMENT 'Delay in minutes between occurences of the event', `length` bigint(20) unsigned NOT NULL DEFAULT '2592000' COMMENT 'Length in minutes of the event', `holiday` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Client side holiday id', `description` varchar(255) DEFAULT NULL COMMENT 'Description of the event displayed in console', `world_event` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '0 if normal event, 1 if world event', `announce` tinyint(3) unsigned DEFAULT '2' COMMENT '0 dont announce, 1 announce, 2 value from config', PRIMARY KEY (`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_arena_seasons` -- DROP TABLE IF EXISTS `game_event_arena_seasons`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_arena_seasons` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `season` tinyint(3) unsigned NOT NULL COMMENT 'Arena season number', UNIQUE KEY `season` (`season`,`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_battleground_holiday` -- DROP TABLE IF EXISTS `game_event_battleground_holiday`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_battleground_holiday` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `bgflag` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_condition` -- DROP TABLE IF EXISTS `game_event_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_condition` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `condition_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `req_num` float DEFAULT '0', `max_world_state_field` smallint(5) unsigned NOT NULL DEFAULT '0', `done_world_state_field` smallint(5) unsigned NOT NULL DEFAULT '0', `description` varchar(25) NOT NULL DEFAULT '', PRIMARY KEY (`eventEntry`,`condition_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_creature` -- DROP TABLE IF EXISTS `game_event_creature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_creature` ( `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', `guid` int(10) unsigned NOT NULL, PRIMARY KEY (`guid`,`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_creature_quest` -- DROP TABLE IF EXISTS `game_event_creature_quest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_creature_quest` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event.', `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_gameobject` -- DROP TABLE IF EXISTS `game_event_gameobject`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_gameobject` ( `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', `guid` int(10) unsigned NOT NULL, PRIMARY KEY (`guid`,`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_gameobject_quest` -- DROP TABLE IF EXISTS `game_event_gameobject_quest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_gameobject_quest` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`quest`,`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_model_equip` -- DROP TABLE IF EXISTS `game_event_model_equip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_model_equip` ( `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event.', `guid` int(10) unsigned NOT NULL DEFAULT '0', `modelid` mediumint(8) unsigned NOT NULL DEFAULT '0', `equipment_id` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_npc_vendor` -- DROP TABLE IF EXISTS `game_event_npc_vendor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_npc_vendor` ( `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event.', `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', `slot` smallint(6) NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `maxcount` mediumint(8) unsigned NOT NULL DEFAULT '0', `incrtime` mediumint(8) unsigned NOT NULL DEFAULT '0', `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`item`), KEY `slot` (`slot`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_npcflag` -- DROP TABLE IF EXISTS `game_event_npcflag`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_npcflag` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', `npcflag` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`eventEntry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_pool` -- DROP TABLE IF EXISTS `game_event_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_pool` ( `eventEntry` tinyint(4) NOT NULL COMMENT 'Entry of the game event. Put negative entry to remove during event.', `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Id of the pool', PRIMARY KEY (`pool_entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_prerequisite` -- DROP TABLE IF EXISTS `game_event_prerequisite`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_prerequisite` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event', `prerequisite_event` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`eventEntry`,`prerequisite_event`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_quest_condition` -- DROP TABLE IF EXISTS `game_event_quest_condition`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_quest_condition` ( `eventEntry` tinyint(3) unsigned NOT NULL COMMENT 'Entry of the game event.', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0', `condition_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `num` float DEFAULT '0', PRIMARY KEY (`quest`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_event_seasonal_questrelation` -- DROP TABLE IF EXISTS `game_event_seasonal_questrelation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_event_seasonal_questrelation` ( `questId` int(10) unsigned NOT NULL COMMENT 'Quest Identifier', `eventEntry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Entry of the game event', PRIMARY KEY (`questId`,`eventEntry`), KEY `idx_quest` (`questId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Player System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_graveyard_zone` -- DROP TABLE IF EXISTS `game_graveyard_zone`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_graveyard_zone` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `ghost_zone` mediumint(8) unsigned NOT NULL DEFAULT '0', `faction` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`ghost_zone`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_tele` -- DROP TABLE IF EXISTS `game_tele`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_tele` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `map` smallint(5) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=1424 DEFAULT CHARSET=utf8 COMMENT='Tele Command'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `game_weather` -- DROP TABLE IF EXISTS `game_weather`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `game_weather` ( `zone` mediumint(8) unsigned NOT NULL DEFAULT '0', `spring_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `spring_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `spring_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `summer_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `summer_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `summer_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `fall_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `fall_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `fall_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `winter_rain_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `winter_snow_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `winter_storm_chance` tinyint(3) unsigned NOT NULL DEFAULT '25', `ScriptName` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`zone`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobject` -- DROP TABLE IF EXISTS `gameobject`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject` ( `guid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Global Unique Identifier', `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Gameobject Identifier', `map` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Map Identifier', `spawnMask` tinyint(3) unsigned NOT NULL DEFAULT '1', `phaseMask` int(10) unsigned NOT NULL DEFAULT '1', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `rotation0` float NOT NULL DEFAULT '0', `rotation1` float NOT NULL DEFAULT '0', `rotation2` float NOT NULL DEFAULT '0', `rotation3` float NOT NULL DEFAULT '0', `spawntimesecs` int(11) NOT NULL DEFAULT '0', `animprogress` tinyint(3) unsigned NOT NULL DEFAULT '0', `state` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=MyISAM AUTO_INCREMENT=255094 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobject_loot_template` -- DROP TABLE IF EXISTS `gameobject_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobject_questender` -- DROP TABLE IF EXISTS `gameobject_questender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject_questender` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobject_queststarter` -- DROP TABLE IF EXISTS `gameobject_queststarter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject_queststarter` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier', PRIMARY KEY (`id`,`quest`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gameobject_template` -- DROP TABLE IF EXISTS `gameobject_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gameobject_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `displayId` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` varchar(100) NOT NULL DEFAULT '', `IconName` varchar(100) NOT NULL DEFAULT '', `castBarCaption` varchar(100) NOT NULL DEFAULT '', `unk1` varchar(100) NOT NULL DEFAULT '', `faction` smallint(5) unsigned NOT NULL DEFAULT '0', `flags` int(10) unsigned NOT NULL DEFAULT '0', `size` float NOT NULL DEFAULT '1', `questItem1` int(11) unsigned NOT NULL DEFAULT '0', `questItem2` int(11) unsigned NOT NULL DEFAULT '0', `questItem3` int(11) unsigned NOT NULL DEFAULT '0', `questItem4` int(11) unsigned NOT NULL DEFAULT '0', `questItem5` int(11) unsigned NOT NULL DEFAULT '0', `questItem6` int(11) unsigned NOT NULL DEFAULT '0', `data0` int(10) unsigned NOT NULL DEFAULT '0', `data1` int(11) NOT NULL DEFAULT '-1', `data2` int(10) unsigned NOT NULL DEFAULT '0', `data3` int(10) unsigned NOT NULL DEFAULT '0', `data4` int(10) unsigned NOT NULL DEFAULT '0', `data5` int(10) unsigned NOT NULL DEFAULT '0', `data6` int(11) NOT NULL DEFAULT '-1', `data7` int(10) unsigned NOT NULL DEFAULT '0', `data8` int(10) unsigned NOT NULL DEFAULT '0', `data9` int(10) unsigned NOT NULL DEFAULT '0', `data10` int(10) unsigned NOT NULL DEFAULT '0', `data11` int(10) unsigned NOT NULL DEFAULT '0', `data12` int(10) unsigned NOT NULL DEFAULT '0', `data13` int(10) unsigned NOT NULL DEFAULT '0', `data14` int(10) unsigned NOT NULL DEFAULT '0', `data15` int(10) unsigned NOT NULL DEFAULT '0', `data16` int(10) unsigned NOT NULL DEFAULT '0', `data17` int(10) unsigned NOT NULL DEFAULT '0', `data18` int(10) unsigned NOT NULL DEFAULT '0', `data19` int(10) unsigned NOT NULL DEFAULT '0', `data20` int(10) unsigned NOT NULL DEFAULT '0', `data21` int(10) unsigned NOT NULL DEFAULT '0', `data22` int(10) unsigned NOT NULL DEFAULT '0', `data23` int(10) unsigned NOT NULL DEFAULT '0', `AIName` char(64) NOT NULL DEFAULT '', `ScriptName` varchar(64) NOT NULL DEFAULT '', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`), KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gossip_menu` -- DROP TABLE IF EXISTS `gossip_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gossip_menu` ( `entry` smallint(5) unsigned NOT NULL DEFAULT '0', `text_id` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`text_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `gossip_menu_option` -- DROP TABLE IF EXISTS `gossip_menu_option`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gossip_menu_option` ( `menu_id` smallint(5) unsigned NOT NULL DEFAULT '0', `id` smallint(5) unsigned NOT NULL DEFAULT '0', `option_icon` mediumint(8) unsigned NOT NULL DEFAULT '0', `option_text` text, `OptionBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', `option_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `npc_option_npcflag` int(10) unsigned NOT NULL DEFAULT '0', `action_menu_id` int(10) unsigned NOT NULL DEFAULT '0', `action_poi_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `box_coded` tinyint(3) unsigned NOT NULL DEFAULT '0', `box_money` int(10) unsigned NOT NULL DEFAULT '0', `box_text` text, `BoxBroadcastTextID` mediumint(6) NOT NULL DEFAULT '0', PRIMARY KEY (`menu_id`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `instance_encounters` -- DROP TABLE IF EXISTS `instance_encounters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `instance_encounters` ( `entry` int(10) unsigned NOT NULL COMMENT 'Unique entry from DungeonEncounter.dbc', `creditType` tinyint(3) unsigned NOT NULL DEFAULT '0', `creditEntry` int(10) unsigned NOT NULL DEFAULT '0', `lastEncounterDungeon` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'If not 0, LfgDungeon.dbc entry for the instance it is last encounter in', `comment` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `instance_template` -- DROP TABLE IF EXISTS `instance_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `instance_template` ( `map` smallint(5) unsigned NOT NULL, `parent` smallint(5) unsigned NOT NULL, `script` varchar(128) NOT NULL DEFAULT '', `allowMount` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`map`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_enchantment_template` -- DROP TABLE IF EXISTS `item_enchantment_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_enchantment_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `ench` mediumint(8) unsigned NOT NULL DEFAULT '0', `chance` float unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`ench`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_loot_template` -- DROP TABLE IF EXISTS `item_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_set_names` -- DROP TABLE IF EXISTS `item_set_names`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_set_names` ( `entry` mediumint(8) unsigned NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `item_template` -- DROP TABLE IF EXISTS `item_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `item_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `class` tinyint(3) unsigned NOT NULL DEFAULT '0', `subclass` tinyint(3) unsigned NOT NULL DEFAULT '0', `SoundOverrideSubclass` tinyint(3) NOT NULL DEFAULT '-1', `name` varchar(255) NOT NULL DEFAULT '', `displayid` mediumint(8) unsigned NOT NULL DEFAULT '0', `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0', `Flags` int(10) unsigned NOT NULL DEFAULT '0', `FlagsExtra` int(10) unsigned NOT NULL DEFAULT '0', `BuyCount` tinyint(3) unsigned NOT NULL DEFAULT '1', `BuyPrice` bigint(20) NOT NULL DEFAULT '0', `SellPrice` int(10) unsigned NOT NULL DEFAULT '0', `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0', `AllowableClass` int(11) NOT NULL DEFAULT '-1', `AllowableRace` int(11) NOT NULL DEFAULT '-1', `ItemLevel` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `RequiredSkill` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSkillRank` smallint(5) unsigned NOT NULL DEFAULT '0', `requiredspell` mediumint(8) unsigned NOT NULL DEFAULT '0', `requiredhonorrank` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredCityRank` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredReputationFaction` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredReputationRank` smallint(5) unsigned NOT NULL DEFAULT '0', `maxcount` int(11) NOT NULL DEFAULT '0', `stackable` int(11) DEFAULT '1', `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT '0', `StatsCount` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_type1` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value1` smallint(6) NOT NULL DEFAULT '0', `stat_type2` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value2` smallint(6) NOT NULL DEFAULT '0', `stat_type3` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value3` smallint(6) NOT NULL DEFAULT '0', `stat_type4` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value4` smallint(6) NOT NULL DEFAULT '0', `stat_type5` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value5` smallint(6) NOT NULL DEFAULT '0', `stat_type6` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value6` smallint(6) NOT NULL DEFAULT '0', `stat_type7` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value7` smallint(6) NOT NULL DEFAULT '0', `stat_type8` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value8` smallint(6) NOT NULL DEFAULT '0', `stat_type9` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value9` smallint(6) NOT NULL DEFAULT '0', `stat_type10` tinyint(3) unsigned NOT NULL DEFAULT '0', `stat_value10` smallint(6) NOT NULL DEFAULT '0', `ScalingStatDistribution` smallint(6) NOT NULL DEFAULT '0', `ScalingStatValue` int(10) unsigned NOT NULL DEFAULT '0', `dmg_min1` float NOT NULL DEFAULT '0', `dmg_max1` float NOT NULL DEFAULT '0', `dmg_type1` tinyint(3) unsigned NOT NULL DEFAULT '0', `dmg_min2` float NOT NULL DEFAULT '0', `dmg_max2` float NOT NULL DEFAULT '0', `dmg_type2` tinyint(3) unsigned NOT NULL DEFAULT '0', `armor` smallint(5) unsigned NOT NULL DEFAULT '0', `holy_res` tinyint(3) unsigned NOT NULL DEFAULT '0', `fire_res` tinyint(3) unsigned NOT NULL DEFAULT '0', `nature_res` tinyint(3) unsigned NOT NULL DEFAULT '0', `frost_res` tinyint(3) unsigned NOT NULL DEFAULT '0', `shadow_res` tinyint(3) unsigned NOT NULL DEFAULT '0', `arcane_res` tinyint(3) unsigned NOT NULL DEFAULT '0', `delay` smallint(5) unsigned NOT NULL DEFAULT '1000', `ammo_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `RangedModRange` float NOT NULL DEFAULT '0', `spellid_1` mediumint(8) NOT NULL DEFAULT '0', `spelltrigger_1` tinyint(3) unsigned NOT NULL DEFAULT '0', `spellcharges_1` smallint(6) NOT NULL DEFAULT '0', `spellppmRate_1` float NOT NULL DEFAULT '0', `spellcooldown_1` int(11) NOT NULL DEFAULT '-1', `spellcategory_1` smallint(5) unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_1` int(11) NOT NULL DEFAULT '-1', `spellid_2` mediumint(8) NOT NULL DEFAULT '0', `spelltrigger_2` tinyint(3) unsigned NOT NULL DEFAULT '0', `spellcharges_2` smallint(6) NOT NULL DEFAULT '0', `spellppmRate_2` float NOT NULL DEFAULT '0', `spellcooldown_2` int(11) NOT NULL DEFAULT '-1', `spellcategory_2` smallint(5) unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_2` int(11) NOT NULL DEFAULT '-1', `spellid_3` mediumint(8) NOT NULL DEFAULT '0', `spelltrigger_3` tinyint(3) unsigned NOT NULL DEFAULT '0', `spellcharges_3` smallint(6) NOT NULL DEFAULT '0', `spellppmRate_3` float NOT NULL DEFAULT '0', `spellcooldown_3` int(11) NOT NULL DEFAULT '-1', `spellcategory_3` smallint(5) unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_3` int(11) NOT NULL DEFAULT '-1', `spellid_4` mediumint(8) NOT NULL DEFAULT '0', `spelltrigger_4` tinyint(3) unsigned NOT NULL DEFAULT '0', `spellcharges_4` smallint(6) NOT NULL DEFAULT '0', `spellppmRate_4` float NOT NULL DEFAULT '0', `spellcooldown_4` int(11) NOT NULL DEFAULT '-1', `spellcategory_4` smallint(5) unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_4` int(11) NOT NULL DEFAULT '-1', `spellid_5` mediumint(8) NOT NULL DEFAULT '0', `spelltrigger_5` tinyint(3) unsigned NOT NULL DEFAULT '0', `spellcharges_5` smallint(6) NOT NULL DEFAULT '0', `spellppmRate_5` float NOT NULL DEFAULT '0', `spellcooldown_5` int(11) NOT NULL DEFAULT '-1', `spellcategory_5` smallint(5) unsigned NOT NULL DEFAULT '0', `spellcategorycooldown_5` int(11) NOT NULL DEFAULT '-1', `bonding` tinyint(3) unsigned NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL DEFAULT '', `PageText` mediumint(8) unsigned NOT NULL DEFAULT '0', `LanguageID` tinyint(3) unsigned NOT NULL DEFAULT '0', `PageMaterial` tinyint(3) unsigned NOT NULL DEFAULT '0', `startquest` mediumint(8) unsigned NOT NULL DEFAULT '0', `lockid` mediumint(8) unsigned NOT NULL DEFAULT '0', `Material` tinyint(4) NOT NULL DEFAULT '0', `sheath` tinyint(3) unsigned NOT NULL DEFAULT '0', `RandomProperty` mediumint(8) NOT NULL DEFAULT '0', `RandomSuffix` mediumint(8) unsigned NOT NULL DEFAULT '0', `block` mediumint(8) unsigned NOT NULL DEFAULT '0', `itemset` mediumint(8) unsigned NOT NULL DEFAULT '0', `MaxDurability` smallint(5) unsigned NOT NULL DEFAULT '0', `area` mediumint(8) unsigned NOT NULL DEFAULT '0', `Map` smallint(6) NOT NULL DEFAULT '0', `BagFamily` mediumint(8) NOT NULL DEFAULT '0', `TotemCategory` mediumint(8) NOT NULL DEFAULT '0', `socketColor_1` tinyint(4) NOT NULL DEFAULT '0', `socketContent_1` mediumint(8) NOT NULL DEFAULT '0', `socketColor_2` tinyint(4) NOT NULL DEFAULT '0', `socketContent_2` mediumint(8) NOT NULL DEFAULT '0', `socketColor_3` tinyint(4) NOT NULL DEFAULT '0', `socketContent_3` mediumint(8) NOT NULL DEFAULT '0', `socketBonus` mediumint(8) NOT NULL DEFAULT '0', `GemProperties` mediumint(8) NOT NULL DEFAULT '0', `RequiredDisenchantSkill` smallint(6) NOT NULL DEFAULT '-1', `ArmorDamageModifier` float NOT NULL DEFAULT '0', `duration` int(10) unsigned NOT NULL DEFAULT '0', `ItemLimitCategory` smallint(6) NOT NULL DEFAULT '0', `HolidayId` int(11) unsigned NOT NULL DEFAULT '0', `ScriptName` varchar(64) NOT NULL DEFAULT '', `DisenchantID` mediumint(8) unsigned NOT NULL DEFAULT '0', `FoodType` tinyint(3) unsigned NOT NULL DEFAULT '0', `minMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0', `maxMoneyLoot` int(10) unsigned NOT NULL DEFAULT '0', `flagsCustom` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`), KEY `idx_name` (`name`), KEY `items_index` (`class`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lfg_dungeon_rewards` -- DROP TABLE IF EXISTS `lfg_dungeon_rewards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lfg_dungeon_rewards` ( `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Dungeon entry from dbc', `maxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Max level at which this reward is rewarded', `firstQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for first dungeon this day', `otherQuestId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest id with rewards for Nth dungeon this day', PRIMARY KEY (`dungeonId`,`maxLevel`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `lfg_entrances` -- DROP TABLE IF EXISTS `lfg_entrances`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `lfg_entrances` ( `dungeonId` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Unique id from LFGDungeons.dbc', `name` varchar(255) CHARACTER SET latin1 DEFAULT NULL, `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`dungeonId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `linked_respawn` -- DROP TABLE IF EXISTS `linked_respawn`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `linked_respawn` ( `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature', `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature', `linkType` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`guid`,`linkType`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_achievement_reward` -- DROP TABLE IF EXISTS `locales_achievement_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_achievement_reward` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `subject_loc1` varchar(100) NOT NULL DEFAULT '', `subject_loc2` varchar(100) NOT NULL DEFAULT '', `subject_loc3` varchar(100) NOT NULL DEFAULT '', `subject_loc4` varchar(100) NOT NULL DEFAULT '', `subject_loc5` varchar(100) NOT NULL DEFAULT '', `subject_loc6` varchar(100) NOT NULL DEFAULT '', `subject_loc7` varchar(100) NOT NULL DEFAULT '', `subject_loc8` varchar(100) NOT NULL DEFAULT '', `text_loc1` text, `text_loc2` text, `text_loc3` text, `text_loc4` text, `text_loc5` text, `text_loc6` text, `text_loc7` text, `text_loc8` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_broadcast_text` -- DROP TABLE IF EXISTS `locales_broadcast_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_broadcast_text` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `MaleText_loc1` longtext, `MaleText_loc2` longtext, `MaleText_loc3` longtext, `MaleText_loc4` longtext, `MaleText_loc5` longtext, `MaleText_loc6` longtext, `MaleText_loc7` longtext, `MaleText_loc8` longtext, `FemaleText_loc1` longtext, `FemaleText_loc2` longtext, `FemaleText_loc3` longtext, `FemaleText_loc4` longtext, `FemaleText_loc5` longtext, `FemaleText_loc6` longtext, `FemaleText_loc7` longtext, `FemaleText_loc8` longtext, `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_creature` -- DROP TABLE IF EXISTS `locales_creature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_creature` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `name_loc1` varchar(100) NOT NULL DEFAULT '', `name_loc2` varchar(100) NOT NULL DEFAULT '', `name_loc3` varchar(100) NOT NULL DEFAULT '', `name_loc4` varchar(100) NOT NULL DEFAULT '', `name_loc5` varchar(100) NOT NULL DEFAULT '', `name_loc6` varchar(100) NOT NULL DEFAULT '', `name_loc7` varchar(100) NOT NULL DEFAULT '', `name_loc8` varchar(100) NOT NULL DEFAULT '', `subname_loc1` varchar(100) DEFAULT NULL, `subname_loc2` varchar(100) DEFAULT NULL, `subname_loc3` varchar(100) DEFAULT NULL, `subname_loc4` varchar(100) DEFAULT NULL, `subname_loc5` varchar(100) DEFAULT NULL, `subname_loc6` varchar(100) DEFAULT NULL, `subname_loc7` varchar(100) DEFAULT NULL, `subname_loc8` varchar(100) DEFAULT NULL, `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_creature_text` -- DROP TABLE IF EXISTS `locales_creature_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_creature_text` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `id` tinyint(3) unsigned NOT NULL DEFAULT '0', `text_loc1` text, `text_loc2` text, `text_loc3` text, `text_loc4` text, `text_loc5` text, `text_loc6` text, `text_loc7` text, `text_loc8` text, PRIMARY KEY (`entry`,`groupid`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_gameobject` -- DROP TABLE IF EXISTS `locales_gameobject`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_gameobject` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `name_loc1` varchar(100) NOT NULL DEFAULT '', `name_loc2` varchar(100) NOT NULL DEFAULT '', `name_loc3` varchar(100) NOT NULL DEFAULT '', `name_loc4` varchar(100) NOT NULL DEFAULT '', `name_loc5` varchar(100) NOT NULL DEFAULT '', `name_loc6` varchar(100) NOT NULL DEFAULT '', `name_loc7` varchar(100) NOT NULL DEFAULT '', `name_loc8` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc1` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc2` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc3` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc4` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc5` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc6` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc7` varchar(100) NOT NULL DEFAULT '', `castbarcaption_loc8` varchar(100) NOT NULL DEFAULT '', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_gossip_menu_option` -- DROP TABLE IF EXISTS `locales_gossip_menu_option`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_gossip_menu_option` ( `menu_id` smallint(6) unsigned NOT NULL DEFAULT '0', `id` smallint(6) unsigned NOT NULL DEFAULT '0', `option_text_loc1` text, `option_text_loc2` text, `option_text_loc3` text, `option_text_loc4` text, `option_text_loc5` text, `option_text_loc6` text, `option_text_loc7` text, `option_text_loc8` text, `box_text_loc1` text, `box_text_loc2` text, `box_text_loc3` text, `box_text_loc4` text, `box_text_loc5` text, `box_text_loc6` text, `box_text_loc7` text, `box_text_loc8` text, PRIMARY KEY (`menu_id`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_item` -- DROP TABLE IF EXISTS `locales_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_item` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `name_loc1` varchar(100) NOT NULL DEFAULT '', `name_loc2` varchar(100) NOT NULL DEFAULT '', `name_loc3` varchar(100) NOT NULL DEFAULT '', `name_loc4` varchar(100) NOT NULL DEFAULT '', `name_loc5` varchar(100) NOT NULL DEFAULT '', `name_loc6` varchar(100) NOT NULL DEFAULT '', `name_loc7` varchar(100) NOT NULL DEFAULT '', `name_loc8` varchar(100) NOT NULL DEFAULT '', `description_loc1` varchar(255) DEFAULT NULL, `description_loc2` varchar(255) DEFAULT NULL, `description_loc3` varchar(255) DEFAULT NULL, `description_loc4` varchar(255) DEFAULT NULL, `description_loc5` varchar(255) DEFAULT NULL, `description_loc6` varchar(255) DEFAULT NULL, `description_loc7` varchar(255) DEFAULT NULL, `description_loc8` varchar(255) DEFAULT NULL, `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_item_set_names` -- DROP TABLE IF EXISTS `locales_item_set_names`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_item_set_names` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `name_loc1` varchar(100) NOT NULL DEFAULT '', `name_loc2` varchar(100) NOT NULL DEFAULT '', `name_loc3` varchar(100) NOT NULL DEFAULT '', `name_loc4` varchar(100) NOT NULL DEFAULT '', `name_loc5` varchar(100) NOT NULL DEFAULT '', `name_loc6` varchar(100) NOT NULL DEFAULT '', `name_loc7` varchar(100) NOT NULL DEFAULT '', `name_loc8` varchar(100) NOT NULL DEFAULT '', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_npc_text` -- DROP TABLE IF EXISTS `locales_npc_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_npc_text` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `Text0_0_loc1` longtext, `Text0_0_loc2` longtext, `Text0_0_loc3` longtext, `Text0_0_loc4` longtext, `Text0_0_loc5` longtext, `Text0_0_loc6` longtext, `Text0_0_loc7` longtext, `Text0_0_loc8` longtext, `Text0_1_loc1` longtext, `Text0_1_loc2` longtext, `Text0_1_loc3` longtext, `Text0_1_loc4` longtext, `Text0_1_loc5` longtext, `Text0_1_loc6` longtext, `Text0_1_loc7` longtext, `Text0_1_loc8` longtext, `Text1_0_loc1` longtext, `Text1_0_loc2` longtext, `Text1_0_loc3` longtext, `Text1_0_loc4` longtext, `Text1_0_loc5` longtext, `Text1_0_loc6` longtext, `Text1_0_loc7` longtext, `Text1_0_loc8` longtext, `Text1_1_loc1` longtext, `Text1_1_loc2` longtext, `Text1_1_loc3` longtext, `Text1_1_loc4` longtext, `Text1_1_loc5` longtext, `Text1_1_loc6` longtext, `Text1_1_loc7` longtext, `Text1_1_loc8` longtext, `Text2_0_loc1` longtext, `Text2_0_loc2` longtext, `Text2_0_loc3` longtext, `Text2_0_loc4` longtext, `Text2_0_loc5` longtext, `Text2_0_loc6` longtext, `Text2_0_loc7` longtext, `Text2_0_loc8` longtext, `Text2_1_loc1` longtext, `Text2_1_loc2` longtext, `Text2_1_loc3` longtext, `Text2_1_loc4` longtext, `Text2_1_loc5` longtext, `Text2_1_loc6` longtext, `Text2_1_loc7` longtext, `Text2_1_loc8` longtext, `Text3_0_loc1` longtext, `Text3_0_loc2` longtext, `Text3_0_loc3` longtext, `Text3_0_loc4` longtext, `Text3_0_loc5` longtext, `Text3_0_loc6` longtext, `Text3_0_loc7` longtext, `Text3_0_loc8` longtext, `Text3_1_loc1` longtext, `Text3_1_loc2` longtext, `Text3_1_loc3` longtext, `Text3_1_loc4` longtext, `Text3_1_loc5` longtext, `Text3_1_loc6` longtext, `Text3_1_loc7` longtext, `Text3_1_loc8` longtext, `Text4_0_loc1` longtext, `Text4_0_loc2` longtext, `Text4_0_loc3` longtext, `Text4_0_loc4` longtext, `Text4_0_loc5` longtext, `Text4_0_loc6` longtext, `Text4_0_loc7` longtext, `Text4_0_loc8` longtext, `Text4_1_loc1` longtext, `Text4_1_loc2` longtext, `Text4_1_loc3` longtext, `Text4_1_loc4` longtext, `Text4_1_loc5` longtext, `Text4_1_loc6` longtext, `Text4_1_loc7` longtext, `Text4_1_loc8` longtext, `Text5_0_loc1` longtext, `Text5_0_loc2` longtext, `Text5_0_loc3` longtext, `Text5_0_loc4` longtext, `Text5_0_loc5` longtext, `Text5_0_loc6` longtext, `Text5_0_loc7` longtext, `Text5_0_loc8` longtext, `Text5_1_loc1` longtext, `Text5_1_loc2` longtext, `Text5_1_loc3` longtext, `Text5_1_loc4` longtext, `Text5_1_loc5` longtext, `Text5_1_loc6` longtext, `Text5_1_loc7` longtext, `Text5_1_loc8` longtext, `Text6_0_loc1` longtext, `Text6_0_loc2` longtext, `Text6_0_loc3` longtext, `Text6_0_loc4` longtext, `Text6_0_loc5` longtext, `Text6_0_loc6` longtext, `Text6_0_loc7` longtext, `Text6_0_loc8` longtext, `Text6_1_loc1` longtext, `Text6_1_loc2` longtext, `Text6_1_loc3` longtext, `Text6_1_loc4` longtext, `Text6_1_loc5` longtext, `Text6_1_loc6` longtext, `Text6_1_loc7` longtext, `Text6_1_loc8` longtext, `Text7_0_loc1` longtext, `Text7_0_loc2` longtext, `Text7_0_loc3` longtext, `Text7_0_loc4` longtext, `Text7_0_loc5` longtext, `Text7_0_loc6` longtext, `Text7_0_loc7` longtext, `Text7_0_loc8` longtext, `Text7_1_loc1` longtext, `Text7_1_loc2` longtext, `Text7_1_loc3` longtext, `Text7_1_loc4` longtext, `Text7_1_loc5` longtext, `Text7_1_loc6` longtext, `Text7_1_loc7` longtext, `Text7_1_loc8` longtext, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_page_text` -- DROP TABLE IF EXISTS `locales_page_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_page_text` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `Text_loc1` longtext, `Text_loc2` longtext, `Text_loc3` longtext, `Text_loc4` longtext, `Text_loc5` longtext, `Text_loc6` longtext, `Text_loc7` longtext, `Text_loc8` longtext, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_points_of_interest` -- DROP TABLE IF EXISTS `locales_points_of_interest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_points_of_interest` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `icon_name_loc1` text, `icon_name_loc2` text, `icon_name_loc3` text, `icon_name_loc4` text, `icon_name_loc5` text, `icon_name_loc6` text, `icon_name_loc7` text, `icon_name_loc8` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `locales_quest` -- DROP TABLE IF EXISTS `locales_quest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `locales_quest` ( `Id` mediumint(8) unsigned NOT NULL DEFAULT '0', `Title_loc1` text, `Title_loc2` text, `Title_loc3` text, `Title_loc4` text, `Title_loc5` text, `Title_loc6` text, `Title_loc7` text, `Title_loc8` text, `Details_loc1` text, `Details_loc2` text, `Details_loc3` text, `Details_loc4` text, `Details_loc5` text, `Details_loc6` text, `Details_loc7` text, `Details_loc8` text, `Objectives_loc1` text, `Objectives_loc2` text, `Objectives_loc3` text, `Objectives_loc4` text, `Objectives_loc5` text, `Objectives_loc6` text, `Objectives_loc7` text, `Objectives_loc8` text, `OfferRewardText_loc1` text, `OfferRewardText_loc2` text, `OfferRewardText_loc3` text, `OfferRewardText_loc4` text, `OfferRewardText_loc5` text, `OfferRewardText_loc6` text, `OfferRewardText_loc7` text, `OfferRewardText_loc8` text, `RequestItemsText_loc1` text, `RequestItemsText_loc2` text, `RequestItemsText_loc3` text, `RequestItemsText_loc4` text, `RequestItemsText_loc5` text, `RequestItemsText_loc6` text, `RequestItemsText_loc7` text, `RequestItemsText_loc8` text, `EndText_loc1` text, `EndText_loc2` text, `EndText_loc3` text, `EndText_loc4` text, `EndText_loc5` text, `EndText_loc6` text, `EndText_loc7` text, `EndText_loc8` text, `CompletedText_loc1` text, `CompletedText_loc2` text, `CompletedText_loc3` text, `CompletedText_loc4` text, `CompletedText_loc5` text, `CompletedText_loc6` text, `CompletedText_loc7` text, `CompletedText_loc8` text, `ObjectiveText1_loc1` text, `ObjectiveText1_loc2` text, `ObjectiveText1_loc3` text, `ObjectiveText1_loc4` text, `ObjectiveText1_loc5` text, `ObjectiveText1_loc6` text, `ObjectiveText1_loc7` text, `ObjectiveText1_loc8` text, `ObjectiveText2_loc1` text, `ObjectiveText2_loc2` text, `ObjectiveText2_loc3` text, `ObjectiveText2_loc4` text, `ObjectiveText2_loc5` text, `ObjectiveText2_loc6` text, `ObjectiveText2_loc7` text, `ObjectiveText2_loc8` text, `ObjectiveText3_loc1` text, `ObjectiveText3_loc2` text, `ObjectiveText3_loc3` text, `ObjectiveText3_loc4` text, `ObjectiveText3_loc5` text, `ObjectiveText3_loc6` text, `ObjectiveText3_loc7` text, `ObjectiveText3_loc8` text, `ObjectiveText4_loc1` text, `ObjectiveText4_loc2` text, `ObjectiveText4_loc3` text, `ObjectiveText4_loc4` text, `ObjectiveText4_loc5` text, `ObjectiveText4_loc6` text, `ObjectiveText4_loc7` text, `ObjectiveText4_loc8` text, `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mail_level_reward` -- DROP TABLE IF EXISTS `mail_level_reward`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mail_level_reward` ( `level` tinyint(3) unsigned NOT NULL DEFAULT '0', `raceMask` mediumint(8) unsigned NOT NULL DEFAULT '0', `mailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0', `senderEntry` mediumint(8) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`level`,`raceMask`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Mail System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `mail_loot_template` -- DROP TABLE IF EXISTS `mail_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mail_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `milling_loot_template` -- DROP TABLE IF EXISTS `milling_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `milling_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `npc_spellclick_spells` -- DROP TABLE IF EXISTS `npc_spellclick_spells`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_spellclick_spells` ( `npc_entry` int(10) unsigned NOT NULL COMMENT 'reference to creature_template', `spell_id` int(10) unsigned NOT NULL COMMENT 'spell which should be casted ', `cast_flags` tinyint(3) unsigned NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit', `user_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'relation with summoner: 0-no 1-friendly 2-raid 3-party player can click', PRIMARY KEY (`npc_entry`,`spell_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `npc_text` -- DROP TABLE IF EXISTS `npc_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_text` ( `ID` mediumint(8) unsigned NOT NULL DEFAULT '0', `text0_0` longtext, `text0_1` longtext, `BroadcastTextID0` mediumint(6) NOT NULL DEFAULT '0', `lang0` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob0` float NOT NULL DEFAULT '0', `em0_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em0_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em0_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em0_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em0_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em0_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text1_0` longtext, `text1_1` longtext, `BroadcastTextID1` mediumint(6) NOT NULL DEFAULT '0', `lang1` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob1` float NOT NULL DEFAULT '0', `em1_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em1_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em1_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em1_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em1_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em1_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text2_0` longtext, `text2_1` longtext, `BroadcastTextID2` mediumint(6) NOT NULL DEFAULT '0', `lang2` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob2` float NOT NULL DEFAULT '0', `em2_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em2_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em2_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em2_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em2_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em2_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text3_0` longtext, `text3_1` longtext, `BroadcastTextID3` mediumint(6) NOT NULL DEFAULT '0', `lang3` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob3` float NOT NULL DEFAULT '0', `em3_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em3_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em3_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em3_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em3_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em3_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text4_0` longtext, `text4_1` longtext, `BroadcastTextID4` mediumint(6) NOT NULL DEFAULT '0', `lang4` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob4` float NOT NULL DEFAULT '0', `em4_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em4_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em4_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em4_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em4_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em4_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text5_0` longtext, `text5_1` longtext, `BroadcastTextID5` mediumint(6) NOT NULL DEFAULT '0', `lang5` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob5` float NOT NULL DEFAULT '0', `em5_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em5_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em5_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em5_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em5_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em5_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text6_0` longtext, `text6_1` longtext, `BroadcastTextID6` mediumint(6) NOT NULL DEFAULT '0', `lang6` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob6` float NOT NULL DEFAULT '0', `em6_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em6_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em6_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em6_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em6_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em6_5` smallint(5) unsigned NOT NULL DEFAULT '0', `text7_0` longtext, `text7_1` longtext, `BroadcastTextID7` mediumint(6) NOT NULL DEFAULT '0', `lang7` tinyint(3) unsigned NOT NULL DEFAULT '0', `prob7` float NOT NULL DEFAULT '0', `em7_0` smallint(5) unsigned NOT NULL DEFAULT '0', `em7_1` smallint(5) unsigned NOT NULL DEFAULT '0', `em7_2` smallint(5) unsigned NOT NULL DEFAULT '0', `em7_3` smallint(5) unsigned NOT NULL DEFAULT '0', `em7_4` smallint(5) unsigned NOT NULL DEFAULT '0', `em7_5` smallint(5) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `npc_trainer` -- DROP TABLE IF EXISTS `npc_trainer`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_trainer` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `spell` mediumint(8) NOT NULL DEFAULT '0', `spellcost` int(10) unsigned NOT NULL DEFAULT '0', `reqskill` smallint(5) unsigned NOT NULL DEFAULT '0', `reqskillvalue` smallint(5) unsigned NOT NULL DEFAULT '0', `reqlevel` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`,`spell`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `npc_vendor` -- DROP TABLE IF EXISTS `npc_vendor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `npc_vendor` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `slot` smallint(6) NOT NULL DEFAULT '0', `item` mediumint(8) NOT NULL DEFAULT '0', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '0', `incrtime` int(10) unsigned NOT NULL DEFAULT '0', `ExtendedCost` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`,`item`,`ExtendedCost`), KEY `slot` (`slot`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `outdoorpvp_template` -- DROP TABLE IF EXISTS `outdoorpvp_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `outdoorpvp_template` ( `TypeId` tinyint(3) unsigned NOT NULL, `ScriptName` char(64) NOT NULL DEFAULT '', `comment` text, PRIMARY KEY (`TypeId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='OutdoorPvP Templates'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `page_text` -- DROP TABLE IF EXISTS `page_text`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `page_text` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `text` longtext NOT NULL, `next_page` mediumint(8) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pet_levelstats` -- DROP TABLE IF EXISTS `pet_levelstats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pet_levelstats` ( `creature_entry` mediumint(8) unsigned NOT NULL, `level` tinyint(3) unsigned NOT NULL, `hp` smallint(5) unsigned NOT NULL, `mana` smallint(5) unsigned NOT NULL, `armor` int(10) unsigned NOT NULL DEFAULT '0', `str` smallint(5) unsigned NOT NULL, `agi` smallint(5) unsigned NOT NULL, `sta` smallint(5) unsigned NOT NULL, `inte` smallint(5) unsigned NOT NULL, `spi` smallint(5) unsigned NOT NULL, PRIMARY KEY (`creature_entry`,`level`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pet_name_generation` -- DROP TABLE IF EXISTS `pet_name_generation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pet_name_generation` ( `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `word` tinytext NOT NULL, `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `half` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pickpocketing_loot_template` -- DROP TABLE IF EXISTS `pickpocketing_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pickpocketing_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_classlevelstats` -- DROP TABLE IF EXISTS `player_classlevelstats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_classlevelstats` ( `class` tinyint(3) unsigned NOT NULL, `level` tinyint(3) unsigned NOT NULL, `basehp` smallint(5) unsigned NOT NULL, `basemana` smallint(5) unsigned NOT NULL, PRIMARY KEY (`class`,`level`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_factionchange_achievement` -- DROP TABLE IF EXISTS `player_factionchange_achievement`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_factionchange_achievement` ( `alliance_id` int(10) unsigned NOT NULL, `horde_id` int(10) unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_factionchange_items` -- DROP TABLE IF EXISTS `player_factionchange_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_factionchange_items` ( `race_A` int(10) unsigned NOT NULL, `alliance_id` int(10) unsigned NOT NULL, `commentA` text, `race_H` int(10) unsigned NOT NULL, `horde_id` int(10) unsigned NOT NULL, `commentH` text, PRIMARY KEY (`alliance_id`,`horde_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_factionchange_quests` -- DROP TABLE IF EXISTS `player_factionchange_quests`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_factionchange_quests` ( `alliance_id` int(10) unsigned NOT NULL, `horde_id` int(10) unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`), UNIQUE KEY `alliance_uniq` (`alliance_id`), UNIQUE KEY `horde_uniq` (`horde_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_factionchange_reputations` -- DROP TABLE IF EXISTS `player_factionchange_reputations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_factionchange_reputations` ( `alliance_id` int(10) unsigned NOT NULL, `horde_id` int(10) unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_factionchange_spells` -- DROP TABLE IF EXISTS `player_factionchange_spells`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_factionchange_spells` ( `alliance_id` int(10) unsigned NOT NULL, `horde_id` int(10) unsigned NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_factionchange_titles` -- DROP TABLE IF EXISTS `player_factionchange_titles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_factionchange_titles` ( `alliance_id` int(8) NOT NULL, `horde_id` int(8) NOT NULL, PRIMARY KEY (`alliance_id`,`horde_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_levelstats` -- DROP TABLE IF EXISTS `player_levelstats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_levelstats` ( `race` tinyint(3) unsigned NOT NULL, `class` tinyint(3) unsigned NOT NULL, `level` tinyint(3) unsigned NOT NULL, `str` tinyint(3) unsigned NOT NULL, `agi` tinyint(3) unsigned NOT NULL, `sta` tinyint(3) unsigned NOT NULL, `inte` tinyint(3) unsigned NOT NULL, `spi` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`race`,`class`,`level`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `player_xp_for_level` -- DROP TABLE IF EXISTS `player_xp_for_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `player_xp_for_level` ( `lvl` tinyint(3) unsigned NOT NULL, `xp_for_next_level` int(10) unsigned NOT NULL, PRIMARY KEY (`lvl`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `playercreateinfo` -- DROP TABLE IF EXISTS `playercreateinfo`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playercreateinfo` ( `race` tinyint(3) unsigned NOT NULL DEFAULT '0', `class` tinyint(3) unsigned NOT NULL DEFAULT '0', `map` smallint(5) unsigned NOT NULL DEFAULT '0', `zone` mediumint(8) unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', PRIMARY KEY (`race`,`class`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `playercreateinfo_action` -- DROP TABLE IF EXISTS `playercreateinfo_action`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playercreateinfo_action` ( `race` tinyint(3) unsigned NOT NULL DEFAULT '0', `class` tinyint(3) unsigned NOT NULL DEFAULT '0', `button` smallint(5) unsigned NOT NULL DEFAULT '0', `action` int(10) unsigned NOT NULL DEFAULT '0', `type` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`race`,`class`,`button`), KEY `playercreateinfo_race_class_index` (`race`,`class`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `playercreateinfo_item` -- DROP TABLE IF EXISTS `playercreateinfo_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playercreateinfo_item` ( `race` tinyint(3) unsigned NOT NULL DEFAULT '0', `class` tinyint(3) unsigned NOT NULL DEFAULT '0', `itemid` mediumint(8) unsigned NOT NULL DEFAULT '0', `amount` tinyint(4) NOT NULL DEFAULT '1', PRIMARY KEY (`race`,`class`,`itemid`), KEY `playercreateinfo_race_class_index` (`race`,`class`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `playercreateinfo_skills` -- DROP TABLE IF EXISTS `playercreateinfo_skills`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playercreateinfo_skills` ( `raceMask` int(10) unsigned NOT NULL, `classMask` int(10) unsigned NOT NULL, `skill` smallint(5) unsigned NOT NULL, `rank` smallint(5) unsigned NOT NULL DEFAULT '0', `comment` varchar(255) DEFAULT NULL, PRIMARY KEY (`raceMask`,`classMask`,`skill`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `playercreateinfo_spell_custom` -- DROP TABLE IF EXISTS `playercreateinfo_spell_custom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `playercreateinfo_spell_custom` ( `racemask` int(10) unsigned NOT NULL DEFAULT '0', `classmask` int(10) unsigned NOT NULL DEFAULT '0', `Spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `Note` varchar(255) DEFAULT NULL, PRIMARY KEY (`racemask`,`classmask`,`Spell`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `points_of_interest` -- DROP TABLE IF EXISTS `points_of_interest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `points_of_interest` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `icon` mediumint(8) unsigned NOT NULL DEFAULT '0', `flags` mediumint(8) unsigned NOT NULL DEFAULT '0', `data` mediumint(8) unsigned NOT NULL DEFAULT '0', `icon_name` text NOT NULL, `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pool_creature` -- DROP TABLE IF EXISTS `pool_creature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool_creature` ( `guid` int(10) unsigned NOT NULL DEFAULT '0', `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `chance` float unsigned NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_guid` (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pool_gameobject` -- DROP TABLE IF EXISTS `pool_gameobject`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool_gameobject` ( `guid` int(10) unsigned NOT NULL DEFAULT '0', `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `chance` float unsigned NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`guid`), KEY `idx_guid` (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pool_pool` -- DROP TABLE IF EXISTS `pool_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool_pool` ( `pool_id` mediumint(8) unsigned NOT NULL DEFAULT '0', `mother_pool` mediumint(8) unsigned NOT NULL DEFAULT '0', `chance` float NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`pool_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pool_quest` -- DROP TABLE IF EXISTS `pool_quest`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool_quest` ( `entry` int(10) unsigned NOT NULL DEFAULT '0', `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`entry`), KEY `idx_guid` (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `pool_template` -- DROP TABLE IF EXISTS `pool_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Pool entry', `max_limit` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Max number of objects (0) is no limit', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `prospecting_loot_template` -- DROP TABLE IF EXISTS `prospecting_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `prospecting_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_poi` -- DROP TABLE IF EXISTS `quest_poi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_poi` ( `questId` int(10) unsigned NOT NULL DEFAULT '0', `id` int(10) unsigned NOT NULL DEFAULT '0', `objIndex` int(11) NOT NULL DEFAULT '0', `mapid` int(10) unsigned NOT NULL DEFAULT '0', `WorldMapAreaId` int(10) unsigned NOT NULL DEFAULT '0', `FloorId` int(10) unsigned NOT NULL DEFAULT '0', `unk3` int(10) unsigned NOT NULL DEFAULT '0', `unk4` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`questId`,`id`), KEY `idx` (`questId`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_poi_points` -- DROP TABLE IF EXISTS `quest_poi_points`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_poi_points` ( `questId` int(10) unsigned NOT NULL DEFAULT '0', `id` int(10) unsigned NOT NULL DEFAULT '0', `idx` int(10) unsigned NOT NULL DEFAULT '0', `x` int(11) NOT NULL DEFAULT '0', `y` int(11) NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`questId`,`id`,`idx`), KEY `questId_id` (`questId`,`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `quest_template` -- DROP TABLE IF EXISTS `quest_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `quest_template` ( `Id` mediumint(8) unsigned NOT NULL DEFAULT '0', `Method` tinyint(3) unsigned NOT NULL DEFAULT '2', `Level` smallint(3) NOT NULL DEFAULT '1', `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0', `ZoneOrSort` smallint(6) NOT NULL DEFAULT '0', `Type` smallint(5) unsigned NOT NULL DEFAULT '0', `SuggestedPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0', `LimitTime` int(10) unsigned NOT NULL DEFAULT '0', `RequiredClasses` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredRaces` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSkillId` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSkillPoints` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredFactionId1` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredFactionId2` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredFactionValue1` mediumint(8) NOT NULL DEFAULT '0', `RequiredFactionValue2` mediumint(8) NOT NULL DEFAULT '0', `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredMinRepValue` mediumint(8) NOT NULL DEFAULT '0', `RequiredMaxRepValue` mediumint(8) NOT NULL DEFAULT '0', `PrevQuestId` mediumint(8) NOT NULL DEFAULT '0', `NextQuestId` mediumint(8) NOT NULL DEFAULT '0', `ExclusiveGroup` mediumint(8) NOT NULL DEFAULT '0', `NextQuestIdChain` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardXPId` tinyint(3) unsigned NOT NULL DEFAULT '0', `RewardOrRequiredMoney` int(11) NOT NULL DEFAULT '0', `RewardMoneyMaxLevel` int(10) unsigned NOT NULL DEFAULT '0', `RewardSpell` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardSpellCast` int(11) NOT NULL DEFAULT '0', `RewardHonor` int(11) NOT NULL DEFAULT '0', `RewardHonorMultiplier` float NOT NULL DEFAULT '1', `RewardMailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardMailDelay` int(11) unsigned NOT NULL DEFAULT '0', `SourceItemId` mediumint(8) unsigned NOT NULL DEFAULT '0', `SourceItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0', `SourceSpellId` mediumint(8) unsigned NOT NULL DEFAULT '0', `Flags` int(10) unsigned NOT NULL DEFAULT '0', `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', `RewardTitleId` tinyint(3) unsigned NOT NULL DEFAULT '0', `RequiredPlayerKills` tinyint(3) unsigned NOT NULL DEFAULT '0', `RewardTalents` tinyint(3) unsigned NOT NULL DEFAULT '0', `RewardArenaPoints` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardChoiceItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0', `RewardFactionId1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', `RewardFactionId2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', `RewardFactionId3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', `RewardFactionId4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', `RewardFactionId5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case', `RewardFactionValueId1` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueId2` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueId3` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueId4` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueId5` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueIdOverride1` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueIdOverride2` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueIdOverride3` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueIdOverride4` mediumint(8) NOT NULL DEFAULT '0', `RewardFactionValueIdOverride5` mediumint(8) NOT NULL DEFAULT '0', `PointMapId` smallint(5) unsigned NOT NULL DEFAULT '0', `PointX` float NOT NULL DEFAULT '0', `PointY` float NOT NULL DEFAULT '0', `PointOption` mediumint(8) unsigned NOT NULL DEFAULT '0', `Title` text, `Objectives` text, `Details` text, `EndText` text, `OfferRewardText` text, `RequestItemsText` text, `CompletedText` text, `RequiredNpcOrGo1` mediumint(8) NOT NULL DEFAULT '0', `RequiredNpcOrGo2` mediumint(8) NOT NULL DEFAULT '0', `RequiredNpcOrGo3` mediumint(8) NOT NULL DEFAULT '0', `RequiredNpcOrGo4` mediumint(8) NOT NULL DEFAULT '0', `RequiredNpcOrGoCount1` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredNpcOrGoCount2` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredNpcOrGoCount3` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredNpcOrGoCount4` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredSourceItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0', `RequiredItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0', `RequiredItemId6` mediumint(8) 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', `RequiredItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0', `Unknown0` tinyint(3) unsigned NOT NULL DEFAULT '0', `ObjectiveText1` text, `ObjectiveText2` text, `ObjectiveText3` text, `ObjectiveText4` text, `DetailsEmote1` smallint(5) unsigned NOT NULL DEFAULT '0', `DetailsEmote2` smallint(5) unsigned NOT NULL DEFAULT '0', `DetailsEmote3` smallint(5) unsigned NOT NULL DEFAULT '0', `DetailsEmote4` smallint(5) unsigned NOT NULL DEFAULT '0', `DetailsEmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0', `DetailsEmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0', `DetailsEmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0', `DetailsEmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0', `EmoteOnIncomplete` smallint(5) unsigned NOT NULL DEFAULT '0', `EmoteOnComplete` smallint(5) unsigned NOT NULL DEFAULT '0', `OfferRewardEmote1` smallint(5) unsigned NOT NULL DEFAULT '0', `OfferRewardEmote2` smallint(5) unsigned NOT NULL DEFAULT '0', `OfferRewardEmote3` smallint(5) unsigned NOT NULL DEFAULT '0', `OfferRewardEmote4` smallint(5) unsigned NOT NULL DEFAULT '0', `OfferRewardEmoteDelay1` int(10) unsigned NOT NULL DEFAULT '0', `OfferRewardEmoteDelay2` int(10) unsigned NOT NULL DEFAULT '0', `OfferRewardEmoteDelay3` int(10) unsigned NOT NULL DEFAULT '0', `OfferRewardEmoteDelay4` int(10) unsigned NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reference_loot_template` -- DROP TABLE IF EXISTS `reference_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reference_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reputation_reward_rate` -- DROP TABLE IF EXISTS `reputation_reward_rate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reputation_reward_rate` ( `faction` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_rate` float NOT NULL DEFAULT '1', `quest_daily_rate` float NOT NULL DEFAULT '1', `quest_weekly_rate` float NOT NULL DEFAULT '1', `quest_monthly_rate` float NOT NULL DEFAULT '1', `quest_repeatable_rate` float NOT NULL DEFAULT '1', `creature_rate` float NOT NULL DEFAULT '1', `spell_rate` float NOT NULL DEFAULT '1', PRIMARY KEY (`faction`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `reputation_spillover_template` -- DROP TABLE IF EXISTS `reputation_spillover_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `reputation_spillover_template` ( `faction` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction entry', `faction1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction to give spillover for', `rate_1` float NOT NULL DEFAULT '0' COMMENT 'the given rep points * rate', `rank_1` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'max rank,above this will not give any spillover', `faction2` smallint(5) unsigned NOT NULL DEFAULT '0', `rate_2` float NOT NULL DEFAULT '0', `rank_2` tinyint(3) unsigned NOT NULL DEFAULT '0', `faction3` smallint(5) unsigned NOT NULL DEFAULT '0', `rate_3` float NOT NULL DEFAULT '0', `rank_3` tinyint(3) unsigned NOT NULL DEFAULT '0', `faction4` smallint(5) unsigned NOT NULL DEFAULT '0', `rate_4` float NOT NULL DEFAULT '0', `rank_4` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`faction`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Reputation spillover reputation gain'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `script_waypoint` -- DROP TABLE IF EXISTS `script_waypoint`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `script_waypoint` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'creature_template entry', `pointid` mediumint(8) unsigned NOT NULL DEFAULT '0', `location_x` float NOT NULL DEFAULT '0', `location_y` float NOT NULL DEFAULT '0', `location_z` float NOT NULL DEFAULT '0', `waittime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'waittime in millisecs', `point_comment` text, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_discovery_template` -- DROP TABLE IF EXISTS `skill_discovery_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_discovery_template` ( `spellId` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the discoverable spell', `reqSpell` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell requirement', `reqSkillValue` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'skill points requirement', `chance` float NOT NULL DEFAULT '0' COMMENT 'chance to discover', PRIMARY KEY (`spellId`,`reqSpell`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Discovery System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_extra_item_template` -- DROP TABLE IF EXISTS `skill_extra_item_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_extra_item_template` ( `spellId` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellId of the item creation spell', `requiredSpecialization` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Specialization spell id', `additionalCreateChance` float NOT NULL DEFAULT '0' COMMENT 'chance to create add', `additionalMaxNum` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'max num of adds', PRIMARY KEY (`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skill_fishing_base_level` -- DROP TABLE IF EXISTS `skill_fishing_base_level`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skill_fishing_base_level` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Area identifier', `skill` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Base skill level requirement', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Fishing system'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `skinning_loot_template` -- DROP TABLE IF EXISTS `skinning_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `skinning_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `smart_scripts` -- DROP TABLE IF EXISTS `smart_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `smart_scripts` ( `entryorguid` int(11) NOT NULL, `source_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `id` smallint(5) unsigned NOT NULL DEFAULT '0', `link` smallint(5) unsigned NOT NULL DEFAULT '0', `event_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `event_phase_mask` tinyint(3) unsigned NOT NULL DEFAULT '0', `event_chance` tinyint(3) unsigned NOT NULL DEFAULT '100', `event_flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `event_param1` int(10) unsigned NOT NULL DEFAULT '0', `event_param2` int(10) unsigned NOT NULL DEFAULT '0', `event_param3` int(10) unsigned NOT NULL DEFAULT '0', `event_param4` int(10) unsigned NOT NULL DEFAULT '0', `action_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `action_param1` int(10) unsigned NOT NULL DEFAULT '0', `action_param2` int(10) unsigned NOT NULL DEFAULT '0', `action_param3` int(10) unsigned NOT NULL DEFAULT '0', `action_param4` int(10) unsigned NOT NULL DEFAULT '0', `action_param5` int(10) unsigned NOT NULL DEFAULT '0', `action_param6` int(10) unsigned NOT NULL DEFAULT '0', `target_type` tinyint(3) unsigned NOT NULL DEFAULT '0', `target_param1` int(10) unsigned NOT NULL DEFAULT '0', `target_param2` int(10) unsigned NOT NULL DEFAULT '0', `target_param3` int(10) unsigned NOT NULL DEFAULT '0', `target_x` float NOT NULL DEFAULT '0', `target_y` float NOT NULL DEFAULT '0', `target_z` float NOT NULL DEFAULT '0', `target_o` float NOT NULL DEFAULT '0', `comment` text NOT NULL COMMENT 'Event Comment', PRIMARY KEY (`entryorguid`,`source_type`,`id`,`link`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_area` -- DROP TABLE IF EXISTS `spell_area`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_area` ( `spell` mediumint(8) unsigned NOT NULL DEFAULT '0', `area` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_start` mediumint(8) unsigned NOT NULL DEFAULT '0', `quest_end` mediumint(8) unsigned NOT NULL DEFAULT '0', `aura_spell` mediumint(8) NOT NULL DEFAULT '0', `racemask` mediumint(8) unsigned NOT NULL DEFAULT '0', `gender` tinyint(3) unsigned NOT NULL DEFAULT '2', `autocast` tinyint(3) unsigned NOT NULL DEFAULT '0', `quest_start_status` int(11) NOT NULL DEFAULT '64', `quest_end_status` int(11) NOT NULL DEFAULT '11', PRIMARY KEY (`spell`,`area`,`quest_start`,`aura_spell`,`racemask`,`gender`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_bonus_data` -- DROP TABLE IF EXISTS `spell_bonus_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_bonus_data` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `direct_bonus` float NOT NULL DEFAULT '0', `dot_bonus` float NOT NULL DEFAULT '0', `ap_bonus` float NOT NULL DEFAULT '0', `ap_dot_bonus` float NOT NULL DEFAULT '0', `comments` varchar(255) DEFAULT NULL, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_custom_attr` -- DROP TABLE IF EXISTS `spell_custom_attr`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_custom_attr` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'spell id', `attributes` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'SpellCustomAttributes', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SpellInfo custom attributes'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_dbc` -- DROP TABLE IF EXISTS `spell_dbc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_dbc` ( `Id` int(10) unsigned NOT NULL, `Dispel` int(10) unsigned NOT NULL DEFAULT '0', `Mechanic` int(10) unsigned NOT NULL DEFAULT '0', `Attributes` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx2` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx3` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx4` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx5` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx6` int(10) unsigned NOT NULL DEFAULT '0', `AttributesEx7` int(10) unsigned NOT NULL DEFAULT '0', `Stances` int(10) unsigned NOT NULL DEFAULT '0', `StancesNot` int(10) unsigned NOT NULL DEFAULT '0', `Targets` int(10) unsigned NOT NULL DEFAULT '0', `CastingTimeIndex` int(10) unsigned NOT NULL DEFAULT '1', `AuraInterruptFlags` int(10) unsigned NOT NULL DEFAULT '0', `ProcFlags` int(10) unsigned NOT NULL DEFAULT '0', `ProcChance` int(10) unsigned NOT NULL DEFAULT '0', `ProcCharges` int(10) unsigned NOT NULL DEFAULT '0', `MaxLevel` int(10) unsigned NOT NULL DEFAULT '0', `BaseLevel` int(10) unsigned NOT NULL DEFAULT '0', `SpellLevel` int(10) unsigned NOT NULL DEFAULT '0', `DurationIndex` int(10) unsigned NOT NULL DEFAULT '0', `RangeIndex` int(10) unsigned NOT NULL DEFAULT '1', `StackAmount` int(10) unsigned NOT NULL DEFAULT '0', `EquippedItemClass` int(11) NOT NULL DEFAULT '-1', `EquippedItemSubClassMask` int(11) NOT NULL DEFAULT '0', `EquippedItemInventoryTypeMask` int(11) NOT NULL DEFAULT '0', `Effect1` int(10) unsigned NOT NULL DEFAULT '0', `Effect2` int(10) unsigned NOT NULL DEFAULT '0', `Effect3` int(10) unsigned NOT NULL DEFAULT '0', `EffectDieSides1` int(11) NOT NULL DEFAULT '0', `EffectDieSides2` int(11) NOT NULL DEFAULT '0', `EffectDieSides3` int(11) NOT NULL DEFAULT '0', `EffectRealPointsPerLevel1` float NOT NULL DEFAULT '0', `EffectRealPointsPerLevel2` float NOT NULL DEFAULT '0', `EffectRealPointsPerLevel3` float NOT NULL DEFAULT '0', `EffectBasePoints1` int(11) NOT NULL DEFAULT '0', `EffectBasePoints2` int(11) NOT NULL DEFAULT '0', `EffectBasePoints3` int(11) NOT NULL DEFAULT '0', `EffectMechanic1` int(10) unsigned NOT NULL DEFAULT '0', `EffectMechanic2` int(10) unsigned NOT NULL DEFAULT '0', `EffectMechanic3` int(10) unsigned NOT NULL DEFAULT '0', `EffectImplicitTargetA1` int(10) unsigned NOT NULL DEFAULT '0', `EffectImplicitTargetA2` int(10) unsigned NOT NULL DEFAULT '0', `EffectImplicitTargetA3` int(10) unsigned NOT NULL DEFAULT '0', `EffectImplicitTargetB1` int(10) unsigned NOT NULL DEFAULT '0', `EffectImplicitTargetB2` int(10) unsigned NOT NULL DEFAULT '0', `EffectImplicitTargetB3` int(10) unsigned NOT NULL DEFAULT '0', `EffectRadiusIndex1` int(10) unsigned NOT NULL DEFAULT '0', `EffectRadiusIndex2` int(10) unsigned NOT NULL DEFAULT '0', `EffectRadiusIndex3` int(10) unsigned NOT NULL DEFAULT '0', `EffectApplyAuraName1` int(10) unsigned NOT NULL DEFAULT '0', `EffectApplyAuraName2` int(10) unsigned NOT NULL DEFAULT '0', `EffectApplyAuraName3` int(10) unsigned NOT NULL DEFAULT '0', `EffectAmplitude1` int(11) NOT NULL DEFAULT '0', `EffectAmplitude2` int(11) NOT NULL DEFAULT '0', `EffectAmplitude3` int(11) NOT NULL DEFAULT '0', `EffectMultipleValue1` float NOT NULL DEFAULT '0', `EffectMultipleValue2` float NOT NULL DEFAULT '0', `EffectMultipleValue3` float NOT NULL DEFAULT '0', `EffectMiscValue1` int(11) NOT NULL DEFAULT '0', `EffectMiscValue2` int(11) NOT NULL DEFAULT '0', `EffectMiscValue3` int(11) NOT NULL DEFAULT '0', `EffectMiscValueB1` int(11) NOT NULL DEFAULT '0', `EffectMiscValueB2` int(11) NOT NULL DEFAULT '0', `EffectMiscValueB3` int(11) NOT NULL DEFAULT '0', `EffectTriggerSpell1` int(10) unsigned NOT NULL DEFAULT '0', `EffectTriggerSpell2` int(10) unsigned NOT NULL DEFAULT '0', `EffectTriggerSpell3` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskA1` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskA2` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskA3` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskB1` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskB2` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskB3` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC1` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC2` int(10) unsigned NOT NULL DEFAULT '0', `EffectSpellClassMaskC3` int(10) unsigned NOT NULL DEFAULT '0', `MaxTargetLevel` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyName` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyFlags1` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyFlags2` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyFlags3` int(10) unsigned NOT NULL DEFAULT '0', `MaxAffectedTargets` int(10) unsigned NOT NULL DEFAULT '0', `DmgClass` int(10) unsigned NOT NULL DEFAULT '0', `PreventionType` int(10) unsigned NOT NULL DEFAULT '0', `DmgMultiplier1` float NOT NULL DEFAULT '0', `DmgMultiplier2` float NOT NULL DEFAULT '0', `DmgMultiplier3` float NOT NULL DEFAULT '0', `AreaGroupId` int(11) NOT NULL DEFAULT '0', `SchoolMask` int(10) unsigned NOT NULL DEFAULT '0', `Comment` text NOT NULL, PRIMARY KEY (`Id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom spell.dbc entries'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_enchant_proc_data` -- DROP TABLE IF EXISTS `spell_enchant_proc_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_enchant_proc_data` ( `entry` int(10) unsigned NOT NULL, `customChance` int(10) unsigned NOT NULL DEFAULT '0', `PPMChance` float unsigned NOT NULL DEFAULT '0', `procEx` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Spell enchant proc data'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_group` -- DROP TABLE IF EXISTS `spell_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_group` ( `id` int(10) unsigned NOT NULL DEFAULT '0', `spell_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`spell_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_group_stack_rules` -- DROP TABLE IF EXISTS `spell_group_stack_rules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_group_stack_rules` ( `group_id` int(11) unsigned NOT NULL DEFAULT '0', `stack_rule` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_learn_spell` -- DROP TABLE IF EXISTS `spell_learn_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_learn_spell` ( `entry` smallint(5) unsigned NOT NULL DEFAULT '0', `SpellID` smallint(5) unsigned NOT NULL DEFAULT '0', `Active` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`SpellID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_linked_spell` -- DROP TABLE IF EXISTS `spell_linked_spell`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_linked_spell` ( `spell_trigger` mediumint(8) NOT NULL, `spell_effect` mediumint(8) NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', `comment` text NOT NULL, UNIQUE KEY `trigger_effect_type` (`spell_trigger`,`spell_effect`,`type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_loot_template` -- DROP TABLE IF EXISTS `spell_loot_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_loot_template` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `item` mediumint(8) unsigned NOT NULL DEFAULT '0', `ChanceOrQuestChance` float NOT NULL DEFAULT '100', `lootmode` smallint(5) unsigned NOT NULL DEFAULT '1', `groupid` tinyint(3) unsigned NOT NULL DEFAULT '0', `mincountOrRef` mediumint(8) NOT NULL DEFAULT '1', `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`entry`,`item`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_pet_auras` -- DROP TABLE IF EXISTS `spell_pet_auras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_pet_auras` ( `spell` mediumint(8) unsigned NOT NULL COMMENT 'dummy spell id', `effectId` tinyint(3) unsigned NOT NULL DEFAULT '0', `pet` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'pet id; 0 = all', `aura` mediumint(8) unsigned NOT NULL COMMENT 'pet aura id', PRIMARY KEY (`spell`,`effectId`,`pet`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_proc` -- DROP TABLE IF EXISTS `spell_proc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_proc` ( `spellId` mediumint(8) NOT NULL DEFAULT '0', `schoolMask` tinyint(4) NOT NULL DEFAULT '0', `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', `typeMask` int(10) unsigned NOT NULL DEFAULT '0', `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', `spellPhaseMask` int(11) NOT NULL DEFAULT '0', `hitMask` int(11) NOT NULL DEFAULT '0', `attributesMask` int(10) unsigned NOT NULL DEFAULT '0', `ratePerMinute` float NOT NULL DEFAULT '0', `chance` float NOT NULL DEFAULT '0', `cooldown` float unsigned NOT NULL DEFAULT '0', `charges` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_proc_event` -- DROP TABLE IF EXISTS `spell_proc_event`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_proc_event` ( `entry` mediumint(8) NOT NULL DEFAULT '0', `SchoolMask` tinyint(4) NOT NULL DEFAULT '0', `SpellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', `SpellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', `SpellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', `procFlags` int(10) unsigned NOT NULL DEFAULT '0', `procEx` int(10) unsigned NOT NULL DEFAULT '0', `ppmRate` float NOT NULL DEFAULT '0', `CustomChance` float NOT NULL DEFAULT '0', `Cooldown` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_ranks` -- DROP TABLE IF EXISTS `spell_ranks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_ranks` ( `first_spell_id` int(10) unsigned NOT NULL DEFAULT '0', `spell_id` int(10) unsigned NOT NULL DEFAULT '0', `rank` tinyint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`first_spell_id`,`rank`), UNIQUE KEY `spell_id` (`spell_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Rank Data'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_required` -- DROP TABLE IF EXISTS `spell_required`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_required` ( `spell_id` mediumint(8) NOT NULL DEFAULT '0', `req_spell` mediumint(8) NOT NULL DEFAULT '0', PRIMARY KEY (`spell_id`,`req_spell`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_script_names` -- DROP TABLE IF EXISTS `spell_script_names`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_script_names` ( `spell_id` int(11) NOT NULL, `ScriptName` char(64) NOT NULL, UNIQUE KEY `spell_id` (`spell_id`,`ScriptName`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_scripts` -- DROP TABLE IF EXISTS `spell_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_scripts` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0', `effIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', `delay` int(10) unsigned NOT NULL DEFAULT '0', `command` mediumint(8) unsigned NOT NULL DEFAULT '0', `datalong` mediumint(8) unsigned NOT NULL DEFAULT '0', `datalong2` int(10) unsigned NOT NULL DEFAULT '0', `dataint` int(11) NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_target_position` -- DROP TABLE IF EXISTS `spell_target_position`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_target_position` ( `id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier', `effIndex` tinyint(3) unsigned NOT NULL DEFAULT '0', `target_map` smallint(5) unsigned NOT NULL DEFAULT '0', `target_position_x` float NOT NULL DEFAULT '0', `target_position_y` float NOT NULL DEFAULT '0', `target_position_z` float NOT NULL DEFAULT '0', `target_orientation` float NOT NULL DEFAULT '0', `VerifiedBuild` smallint(5) DEFAULT '0', PRIMARY KEY (`id`,`effIndex`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spell_threat` -- DROP TABLE IF EXISTS `spell_threat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spell_threat` ( `entry` mediumint(8) unsigned NOT NULL, `flatMod` int(11) DEFAULT NULL, `pctMod` float NOT NULL DEFAULT '1' COMMENT 'threat multiplier for damage/healing', `apPctMod` float NOT NULL DEFAULT '0' COMMENT 'additional threat bonus from attack power', PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `spelldifficulty_dbc` -- DROP TABLE IF EXISTS `spelldifficulty_dbc`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `spelldifficulty_dbc` ( `id` int(11) unsigned NOT NULL DEFAULT '0', `spellid0` int(11) unsigned NOT NULL DEFAULT '0', `spellid1` int(11) unsigned NOT NULL DEFAULT '0', `spellid2` int(11) unsigned NOT NULL DEFAULT '0', `spellid3` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `transports` -- DROP TABLE IF EXISTS `transports`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `transports` ( `guid` int(10) unsigned NOT NULL AUTO_INCREMENT, `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `name` text, `ScriptName` char(64) NOT NULL DEFAULT '', PRIMARY KEY (`guid`), UNIQUE KEY `idx_entry` (`entry`) ) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `trinity_string` -- DROP TABLE IF EXISTS `trinity_string`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `trinity_string` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `content_default` text NOT NULL, `content_loc1` text, `content_loc2` text, `content_loc3` text, `content_loc4` text, `content_loc5` text, `content_loc6` text, `content_loc7` text, `content_loc8` text, PRIMARY KEY (`entry`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle_accessory` -- DROP TABLE IF EXISTS `vehicle_accessory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle_accessory` ( `guid` mediumint(8) unsigned NOT NULL DEFAULT '0', `accessory_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `seat_id` tinyint(4) NOT NULL DEFAULT '0', `minion` tinyint(3) unsigned NOT NULL DEFAULT '0', `description` text NOT NULL, `summontype` tinyint(3) unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int(10) unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`guid`,`seat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `vehicle_template_accessory` -- DROP TABLE IF EXISTS `vehicle_template_accessory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vehicle_template_accessory` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `accessory_entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `seat_id` tinyint(4) NOT NULL DEFAULT '0', `minion` tinyint(3) unsigned NOT NULL DEFAULT '0', `description` text NOT NULL, `summontype` tinyint(3) unsigned NOT NULL DEFAULT '6' COMMENT 'see enum TempSummonType', `summontimer` int(10) unsigned NOT NULL DEFAULT '30000' COMMENT 'timer, only relevant for certain summontypes', PRIMARY KEY (`entry`,`seat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `version` -- DROP TABLE IF EXISTS `version`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `version` ( `core_version` varchar(120) NOT NULL DEFAULT '' COMMENT 'Core revision dumped at startup.', `core_revision` varchar(120) DEFAULT NULL, `db_version` varchar(120) DEFAULT NULL COMMENT 'Version of world DB.', `cache_id` int(11) DEFAULT '0', PRIMARY KEY (`core_version`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Version Notes'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `warden_checks` -- DROP TABLE IF EXISTS `warden_checks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `warden_checks` ( `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `type` tinyint(3) unsigned DEFAULT NULL, `data` varchar(48) DEFAULT NULL, `str` varchar(20) DEFAULT NULL, `address` int(10) unsigned DEFAULT NULL, `length` tinyint(3) unsigned DEFAULT NULL, `result` varchar(24) DEFAULT NULL, `comment` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=787 DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `waypoint_data` -- DROP TABLE IF EXISTS `waypoint_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `waypoint_data` ( `id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Creature GUID', `point` mediumint(8) unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `orientation` float NOT NULL DEFAULT '0', `delay` int(10) unsigned NOT NULL DEFAULT '0', `move_flag` tinyint(4) NOT NULL DEFAULT '0', `action` int(11) NOT NULL DEFAULT '0', `action_chance` smallint(6) NOT NULL DEFAULT '100', `wpguid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`,`point`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `waypoint_scripts` -- DROP TABLE IF EXISTS `waypoint_scripts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `waypoint_scripts` ( `id` int(11) unsigned NOT NULL DEFAULT '0', `delay` int(11) unsigned NOT NULL DEFAULT '0', `command` int(11) unsigned NOT NULL DEFAULT '0', `datalong` int(11) unsigned NOT NULL DEFAULT '0', `datalong2` int(11) unsigned NOT NULL DEFAULT '0', `dataint` int(11) unsigned NOT NULL DEFAULT '0', `x` float NOT NULL DEFAULT '0', `y` float NOT NULL DEFAULT '0', `z` float NOT NULL DEFAULT '0', `o` float NOT NULL DEFAULT '0', `guid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`guid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `waypoints` -- DROP TABLE IF EXISTS `waypoints`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `waypoints` ( `entry` mediumint(8) unsigned NOT NULL DEFAULT '0', `pointid` mediumint(8) unsigned NOT NULL DEFAULT '0', `position_x` float NOT NULL DEFAULT '0', `position_y` float NOT NULL DEFAULT '0', `position_z` float NOT NULL DEFAULT '0', `point_comment` text, PRIMARY KEY (`entry`,`pointid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature waypoints'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping routines for database 'world' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2014-07-28 22:43:25