2852 rows in this table. Schema below.
Name | Type | Null | Key | Default |
---|---|---|---|---|
entry | mediumint(8) unsigned | NO | PRI | 0 |
Method | tinyint(3) unsigned | NO | 2 | |
ZoneOrSort | smallint(6) | NO | 0 | |
MinLevel | tinyint(3) unsigned | NO | 0 | |
MaxLevel | tinyint(3) unsigned | NO | 0 | |
QuestLevel | tinyint(3) unsigned | NO | 0 | |
Type | smallint(5) unsigned | NO | 0 | |
RequiredClasses | smallint(5) unsigned | NO | 0 | |
RequiredRaces | smallint(5) unsigned | NO | 0 | |
RequiredSkill | smallint(5) unsigned | NO | 0 | |
RequiredSkillValue | smallint(5) unsigned | NO | 0 | |
RequiredCondition | mediumint(8) unsigned | NO | 0 | |
RepObjectiveFaction | smallint(5) unsigned | NO | 0 | |
RepObjectiveValue | mediumint(9) | NO | 0 | |
RequiredMinRepFaction | smallint(5) unsigned | NO | 0 | |
RequiredMinRepValue | mediumint(9) | NO | 0 | |
RequiredMaxRepFaction | smallint(5) unsigned | NO | 0 | |
RequiredMaxRepValue | mediumint(9) | NO | 0 | |
SuggestedPlayers | tinyint(3) unsigned | NO | 0 | |
LimitTime | int(10) unsigned | NO | 0 | |
QuestFlags | smallint(5) unsigned | NO | 0 | |
SpecialFlags | tinyint(3) unsigned | NO | 0 | |
PrevQuestId | mediumint(9) | NO | 0 | |
NextQuestId | mediumint(9) | NO | 0 | |
ExclusiveGroup | mediumint(9) | NO | 0 | |
NextQuestInChain | mediumint(8) unsigned | NO | 0 | |
SrcItemId | mediumint(8) unsigned | NO | 0 | |
SrcItemCount | tinyint(3) unsigned | NO | 0 | |
SrcSpell | mediumint(8) unsigned | NO | 0 | |
Title | text | YES | NULL | |
Details | text | YES | NULL | |
Objectives | text | YES | NULL | |
OfferRewardText | text | YES | NULL | |
RequestItemsText | text | YES | NULL | |
EndText | text | YES | NULL | |
ObjectiveText1 | text | YES | NULL | |
ObjectiveText2 | text | YES | NULL | |
ObjectiveText3 | text | YES | NULL | |
ObjectiveText4 | text | YES | NULL | |
ReqItemId1 | mediumint(8) unsigned | NO | 0 | |
ReqItemId2 | mediumint(8) unsigned | NO | 0 | |
ReqItemId3 | mediumint(8) unsigned | NO | 0 | |
ReqItemId4 | mediumint(8) unsigned | NO | 0 | |
ReqItemCount1 | smallint(5) unsigned | NO | 0 | |
ReqItemCount2 | smallint(5) unsigned | NO | 0 | |
ReqItemCount3 | smallint(5) unsigned | NO | 0 | |
ReqItemCount4 | smallint(5) unsigned | NO | 0 | |
ReqSourceId1 | mediumint(8) unsigned | NO | 0 | |
ReqSourceId2 | mediumint(8) unsigned | NO | 0 | |
ReqSourceId3 | mediumint(8) unsigned | NO | 0 | |
ReqSourceId4 | mediumint(8) unsigned | NO | 0 | |
ReqSourceCount1 | mediumint(8) unsigned | NO | 0 | |
ReqSourceCount2 | mediumint(8) unsigned | NO | 0 | |
ReqSourceCount3 | mediumint(8) unsigned | NO | 0 | |
ReqSourceCount4 | mediumint(8) unsigned | NO | 0 | |
ReqCreatureOrGOId1 | mediumint(9) | NO | 0 | |
ReqCreatureOrGOId2 | mediumint(9) | NO | 0 | |
ReqCreatureOrGOId3 | mediumint(9) | NO | 0 | |
ReqCreatureOrGOId4 | mediumint(9) | NO | 0 | |
ReqCreatureOrGOCount1 | smallint(5) unsigned | NO | 0 | |
ReqCreatureOrGOCount2 | smallint(5) unsigned | NO | 0 | |
ReqCreatureOrGOCount3 | smallint(5) unsigned | NO | 0 | |
ReqCreatureOrGOCount4 | smallint(5) unsigned | NO | 0 | |
ReqSpellCast1 | mediumint(8) unsigned | NO | 0 | |
ReqSpellCast2 | mediumint(8) unsigned | NO | 0 | |
ReqSpellCast3 | mediumint(8) unsigned | NO | 0 | |
ReqSpellCast4 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemId1 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemId2 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemId3 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemId4 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemId5 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemId6 | mediumint(8) unsigned | NO | 0 | |
RewChoiceItemCount1 | smallint(5) unsigned | NO | 0 | |
RewChoiceItemCount2 | smallint(5) unsigned | NO | 0 | |
RewChoiceItemCount3 | smallint(5) unsigned | NO | 0 | |
RewChoiceItemCount4 | smallint(5) unsigned | NO | 0 | |
RewChoiceItemCount5 | smallint(5) unsigned | NO | 0 | |
RewChoiceItemCount6 | smallint(5) unsigned | NO | 0 | |
RewItemId1 | mediumint(8) unsigned | NO | 0 | |
RewItemId2 | mediumint(8) unsigned | NO | 0 | |
RewItemId3 | mediumint(8) unsigned | NO | 0 | |
RewItemId4 | mediumint(8) unsigned | NO | 0 | |
RewItemCount1 | smallint(5) unsigned | NO | 0 | |
RewItemCount2 | smallint(5) unsigned | NO | 0 | |
RewItemCount3 | smallint(5) unsigned | NO | 0 | |
RewItemCount4 | smallint(5) unsigned | NO | 0 | |
RewRepFaction1 | smallint(5) unsigned | NO | 0 | |
RewRepFaction2 | smallint(5) unsigned | NO | 0 | |
RewRepFaction3 | smallint(5) unsigned | NO | 0 | |
RewRepFaction4 | smallint(5) unsigned | NO | 0 | |
RewRepFaction5 | smallint(5) unsigned | NO | 0 | |
RewRepValue1 | mediumint(9) | NO | 0 | |
RewRepValue2 | mediumint(9) | NO | 0 | |
RewRepValue3 | mediumint(9) | NO | 0 | |
RewRepValue4 | mediumint(9) | NO | 0 | |
RewRepValue5 | mediumint(9) | NO | 0 | |
RewXP | mediumint(9) unsigned | NO | 0 | |
RewOrReqMoney | int(11) | NO | 0 | |
RewSpell | mediumint(8) unsigned | NO | 0 | |
RewSpellCast | mediumint(8) unsigned | NO | 0 | |
RewMailTemplateId | mediumint(8) | NO | 0 | |
RewMailDelaySecs | int(11) unsigned | NO | 0 | |
RewMailMoney | int(10) unsigned | NO | 0 | |
PointMapId | smallint(5) unsigned | NO | 0 | |
PointX | float | NO | 0 | |
PointY | float | NO | 0 | |
PointOpt | mediumint(8) unsigned | NO | 0 | |
DetailsEmote1 | smallint(5) unsigned | NO | 0 | |
DetailsEmote2 | smallint(5) unsigned | NO | 0 | |
DetailsEmote3 | smallint(5) unsigned | NO | 0 | |
DetailsEmote4 | smallint(5) unsigned | NO | 0 | |
DetailsEmoteDelay1 | int(11) unsigned | NO | 0 | |
DetailsEmoteDelay2 | int(11) unsigned | NO | 0 | |
DetailsEmoteDelay3 | int(11) unsigned | NO | 0 | |
DetailsEmoteDelay4 | int(11) unsigned | NO | 0 | |
IncompleteEmote | smallint(5) unsigned | NO | 0 | |
CompleteEmote | smallint(5) unsigned | NO | 0 | |
OfferRewardEmote1 | smallint(5) unsigned | NO | 0 | |
OfferRewardEmote2 | smallint(5) unsigned | NO | 0 | |
OfferRewardEmote3 | smallint(5) unsigned | NO | 0 | |
OfferRewardEmote4 | smallint(5) unsigned | NO | 0 | |
OfferRewardEmoteDelay1 | int(11) unsigned | NO | 0 | |
OfferRewardEmoteDelay2 | int(11) unsigned | NO | 0 | |
OfferRewardEmoteDelay3 | int(11) unsigned | NO | 0 | |
OfferRewardEmoteDelay4 | int(11) unsigned | NO | 0 | |
StartScript | mediumint(8) unsigned | NO | 0 | |
CompleteScript | mediumint(8) unsigned | NO | 0 | |
ignored | tinyint(1) unsigned | NO | 0 | |
parse_timestamp | date | NO | '2004-12-04' |