rendered paste body
-- Table "quest_template" DDL
CREATE TABLE `quest_template` (
`entry` mediumint(8) unsigned NOT NULL default '0',
`ZoneOrSort` smallint(6) NOT NULL default '0',
`MinLevel` tinyint(3) unsigned NOT NULL default '0',
`QuestLevel` tinyint(3) unsigned NOT NULL default '0',
`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',
`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` smallint(5) unsigned NOT NULL default '0',
`SpecialFlags` tinyint(3) 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',
`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,
`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',
`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',
`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',
`ReqSourceRef1` tinyint(3) unsigned NOT NULL default '0',
`ReqSourceRef2` tinyint(3) unsigned NOT NULL default '0',
`ReqSourceRef3` tinyint(3) unsigned NOT NULL default '0',
`ReqSourceRef4` tinyint(3) 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',
`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',
`RewOrReqMoney` int(11) NOT NULL default '0',
`RewMoneyMaxLevel` int(10) unsigned NOT NULL default '0',
`RewSpell` mediumint(8) 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',
`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',
`StartScript` mediumint(8) unsigned NOT NULL default '0',
`CompleteScript` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';