CREATE TABLE `quest_template` (
   `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Method` tinyint(3) unsigned NOT NULL DEFAULT '2',
   `ZoneOrSort` smallint(6) NOT NULL DEFAULT '0',
   `SkillOrClassMask` mediumint(8) NOT NULL DEFAULT '0',
   `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `QuestLevel` smallint(3) NOT NULL DEFAULT '1',
   `Type` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredRaces` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredSkillValue` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RepObjectiveFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RepObjectiveValue` mediumint(9) NOT NULL DEFAULT '0',
   `RepObjectiveFaction2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT '0',
   `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredMinRepValue` mediumint(9) NOT NULL DEFAULT '0',
   `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RequiredMaxRepValue` mediumint(9) NOT NULL DEFAULT '0',
   `SuggestedPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `LimitTime` int(10) unsigned NOT NULL DEFAULT '0',
   `QuestFlags` int(10) unsigned NOT NULL DEFAULT '0',
   `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `CharTitleId` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `PlayersSlain` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `BonusTalents` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `RewardArenaPoints` smallint(5) unsigned NOT NULL DEFAULT '0',
   `PrevQuestId` mediumint(9) NOT NULL DEFAULT '0',
   `NextQuestId` mediumint(9) NOT NULL DEFAULT '0',
   `ExclusiveGroup` mediumint(9) NOT NULL DEFAULT '0',
   `NextQuestInChain` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewXPId` tinyint(2) unsigned NOT NULL DEFAULT '0',
   `SrcItemId` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `SrcItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
   `SrcSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `Title` text,
   `Details` text,
   `Objectives` text,
   `OfferRewardText` text,
   `RequestItemsText` text,
   `EndText` text,
   `CompletedText` text,
   `ObjectiveText1` text,
   `ObjectiveText2` text,
   `ObjectiveText3` text,
   `ObjectiveText4` text,
   `ReqItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqSourceId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSourceId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSourceId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSourceId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSourceCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqSourceCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqSourceCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqSourceCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqCreatureOrGOId1` mediumint(9) NOT NULL DEFAULT '0',
   `ReqCreatureOrGOId2` mediumint(9) NOT NULL DEFAULT '0',
   `ReqCreatureOrGOId3` mediumint(9) NOT NULL DEFAULT '0',
   `ReqCreatureOrGOId4` mediumint(9) NOT NULL DEFAULT '0',
   `ReqCreatureOrGOCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ReqSpellCast1` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSpellCast2` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSpellCast3` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `ReqSpellCast4` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewChoiceItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
   `RewRepFaction1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
   `RewRepFaction2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
   `RewRepFaction3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
   `RewRepFaction4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
   `RewRepFaction5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
   `RewRepValueId1` mediumint(6) NOT NULL DEFAULT '0',
   `RewRepValueId2` mediumint(6) NOT NULL DEFAULT '0',
   `RewRepValueId3` mediumint(6) NOT NULL DEFAULT '0',
   `RewRepValueId4` mediumint(6) NOT NULL DEFAULT '0',
   `RewRepValueId5` mediumint(6) NOT NULL DEFAULT '0',
   `RewRepValue1` mediumint(9) NOT NULL DEFAULT '0',
   `RewRepValue2` mediumint(9) NOT NULL DEFAULT '0',
   `RewRepValue3` mediumint(9) NOT NULL DEFAULT '0',
   `RewRepValue4` mediumint(9) NOT NULL DEFAULT '0',
   `RewRepValue5` mediumint(9) NOT NULL DEFAULT '0',
   `RewHonorAddition` int(10) NOT NULL DEFAULT '0',
   `RewHonorMultiplier` float NOT NULL DEFAULT '1',
   `unk0` tinyint(2) unsigned NOT NULL DEFAULT '0',
   `RewOrReqMoney` int(11) NOT NULL DEFAULT '0',
   `RewMoneyMaxLevel` int(10) unsigned NOT NULL DEFAULT '0',
   `RewSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewSpellCast` int(11) NOT NULL DEFAULT '0',
   `RewMailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `RewMailDelaySecs` int(11) unsigned NOT NULL DEFAULT '0',
   `PointMapId` smallint(5) unsigned NOT NULL DEFAULT '0',
   `PointX` float NOT NULL DEFAULT '0',
   `PointY` float NOT NULL DEFAULT '0',
   `PointOpt` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `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(11) unsigned NOT NULL DEFAULT '0',
   `DetailsEmoteDelay2` int(11) unsigned NOT NULL DEFAULT '0',
   `DetailsEmoteDelay3` int(11) unsigned NOT NULL DEFAULT '0',
   `DetailsEmoteDelay4` int(11) unsigned NOT NULL DEFAULT '0',
   `IncompleteEmote` smallint(5) unsigned NOT NULL DEFAULT '0',
   `CompleteEmote` 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(11) unsigned NOT NULL DEFAULT '0',
   `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL DEFAULT '0',
   `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL DEFAULT '0',
   `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL DEFAULT '0',
   `StartScript` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `CompleteScript` mediumint(8) unsigned NOT NULL DEFAULT '0',
   `WDBVerified` smallint(5) DEFAULT '1',
   PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';