CREATE TABLE `quest_template` (
`ID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`QuestType` TINYINT(3) UNSIGNED NOT NULL DEFAULT '2',
`QuestLevel` SMALLINT(3) NOT NULL DEFAULT '1',
`MinLevel` TINYINT(3) 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',
`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',
`RewardNextQuest` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardXPDifficulty` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardMoney` INT(11) NOT NULL DEFAULT '0',
`RewardBonusMoney` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RewardDisplaySpell` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardSpell` INT(11) NOT NULL DEFAULT '0',
`RewardHonor` INT(11) NOT NULL DEFAULT '0',
`RewardKillHonor` FLOAT NOT NULL DEFAULT '0',
`StartItem` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`Flags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`RequiredPlayerKills` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardItem4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardAmount4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`ItemDrop4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`ItemDropQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID2` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID3` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID4` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID5` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemID6` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardChoiceItemQuantity6` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIContinent` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`POIx` FLOAT NOT NULL DEFAULT '0',
`POIy` FLOAT NOT NULL DEFAULT '0',
`POIPriority` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
`RewardTitle` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardTalents` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
`RewardArenaPoints` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`RewardFactionID1` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride1` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID2` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride2` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID3` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride3` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID4` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride4` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionID5` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
`RewardFactionValue5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`RewardFactionOverride5` MEDIUMINT(8) NOT NULL DEFAULT '0',
`TimeAllowed` INT(10) UNSIGNED NOT NULL DEFAULT '0',
`AllowableRaces` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
`LogTitle` TEXT NULL,
`LogDescription` TEXT NULL,
`QuestDescription` TEXT NULL,
`AreaDescription` TEXT NULL,
`QuestCompletionLog` TEXT NULL,
`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',
`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 NULL,
`ObjectiveText2` TEXT NULL,
`ObjectiveText3` TEXT NULL,
`ObjectiveText4` TEXT NULL,
`VerifiedBuild` SMALLINT(5) NULL DEFAULT '0',
PRIMARY KEY (`ID`)
)
COMMENT='Quest System'
COLLATE='utf8_general_ci'
ENGINE=MyISAM
;