DROP TABLE IF EXISTS `quest_template`;

CREATE TABLE `quest_template` (
  `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Method` tinyint(3) UNSIGNED NOT NULL DEFAULT '2',
  `Level` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '1',
  `PackageID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `MinLevel` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `QuestSortID` SMALLINT(6) NOT NULL DEFAULT '0',
  `QuestInfoID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
  `SuggestedGroupNum` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `RewardNextQuest` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `RewardXPDifficulty` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `Float10` FLOAT NOT NULL DEFAULT '1',
  `RewardMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardMoneyDifficulty` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Float13` FLOAT NOT NULL DEFAULT '1',
  `RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardDisplaySpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardHonor` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardKillHonor` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `StartItem` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `FlagsEx` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardItem0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardAmount0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDrop0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDropQuantity0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardItem1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardAmount1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDrop1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDropQuantity1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardItem2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardAmount2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDrop2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDropQuantity2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardItem3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardAmount3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDrop3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ItemDropQuantity3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemID0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemQuantity0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemDisplayID0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemID1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemQuantity1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemDisplayID1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemID2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemQuantity2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemDisplayID2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemID3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemQuantity3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemDisplayID3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemID4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemQuantity4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemDisplayID4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemID5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemQuantity5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardChoiceItemDisplayID5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `POIContinent` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `POIx` FLOAT NOT NULL DEFAULT '0',
  `POIy` FLOAT NOT NULL DEFAULT '0',
  `POIPriority` INT(11) NOT NULL DEFAULT '0',
  `RewardTitle` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardTalents` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardArenaPoints` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardSkillLineID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardNumSkillUps` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `PortraitGiver` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `PortraitTurnIn` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionID0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionValue0` INT(11) NOT NULL DEFAULT '0',
  `RewardFactionOverride0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionID1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionValue1` INT(11) NOT NULL DEFAULT '0',
  `RewardFactionOverride1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionID2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionValue2` INT(11) NOT NULL DEFAULT '0',
  `RewardFactionOverride2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionID3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionValue3` INT(11) NOT NULL DEFAULT '0',
  `RewardFactionOverride3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardFactionFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardCurrencyID0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardCurrencyQuantity0` INT(11) NOT NULL DEFAULT '0',
  `RewardCurrencyID1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardCurrencyQuantity1` INT(11) NOT NULL DEFAULT '0',
  `RewardCurrencyID2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardCurrencyQuantity2` INT(11) NOT NULL DEFAULT '0',
  `RewardCurrencyID3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RewardCurrencyQuantity3` INT(11) NOT NULL DEFAULT '0',
  `AcceptedSoundKitID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `CompleteSoundKitID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AreaGroupID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TimeAllowed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Int2950` INT(11) NOT NULL DEFAULT '-1',
  `LogTitle` text,
  `LogDescription` text,
  `QuestDescription` text,
  `AreaDescription` text,
  `PortraitGiverText` text,
  `PortraitGiverName` text,
  `PortraitTurnInText` text,
  `PortraitTurnInName` text,
  `QuestCompletionLog` text,
  `VerifiedBuild` SMALLINT(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';