· 8 years ago · Jun 08, 2018, 03:04 PM
1DROP TABLE IF EXISTS `quest_template`;
2CREATE TABLE `quest_template` (
3 `Id` mediumint(8) unsigned NOT NULL default '0',
4 `Method` tinyint(3) unsigned NOT NULL default '2',
5 `Level` smallint(3) NOT NULL default '1',
6 `MinLevel` tinyint(3) unsigned NOT NULL default '0',
7 `MaxLevel` tinyint(3) unsigned NOT NULL default '0',
8 `ZoneOrSort` smallint(6) NOT NULL default '0',
9 `Type` smallint(5) unsigned NOT NULL default '0',
10 `SuggestedPlayers` tinyint(3) unsigned NOT NULL default '0',
11 `LimitTime` int(10) unsigned NOT NULL default '0',
12 `RequiredClasses` smallint(5) unsigned NOT NULL default '0',
13 `RequiredRaces` smallint(5) unsigned NOT NULL default '0',
14 `RequiredSkillId` smallint(5) unsigned NOT NULL default '0',
15 `RequiredSkillPoints` smallint(5) unsigned NOT NULL default '0',
16 `RequiredFactionId1` smallint(5) unsigned NOT NULL default '0',
17 `RequiredFactionId2` smallint(5) unsigned NOT NULL default '0',
18 `RequiredFactionValue1` mediumint(9) NOT NULL default '0',
19 `RequiredFactionValue2` mediumint(9) NOT NULL default '0',
20 `RequiredMinRepFaction` smallint(5) unsigned NOT NULL default '0',
21 `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL default '0',
22 `RequiredMinRepValue` mediumint(9) NOT NULL default '0',
23 `RequiredMaxRepValue` mediumint(9) NOT NULL default '0',
24 `PrevQuestId` mediumint(9) NOT NULL default '0',
25 `NextQuestId` mediumint(9) NOT NULL default '0',
26 `ExclusiveGroup` mediumint(9) NOT NULL default '0',
27 `NextQuestIdChain` mediumint(8) unsigned NOT NULL default '0',
28 `RewardXPId` tinyint(2) unsigned NOT NULL default '0',
29 `RewardOrRequiredMoney` int(11) NOT NULL default '0',
30 `RewardMoneyMaxLevel` int(10) unsigned NOT NULL default '0',
31 `RewardSpell` mediumint(8) unsigned NOT NULL default '0',
32 `RewardSpellCast` int(11) NOT NULL default '0',
33 `RewardHonor` int(10) NOT NULL default '0',
34 `RewardHonorMultiplier` float NOT NULL default '1',
35 `RewardMailTemplateId` mediumint(8) unsigned NOT NULL default '0',
36 `RewardMailDelay` int(11) unsigned NOT NULL default '0',
37 `SourceItemId` mediumint(8) unsigned NOT NULL default '0',
38 `SourceItemCount` tinyint(3) unsigned NOT NULL default '0',
39 `SourceSpellId` mediumint(8) unsigned NOT NULL default '0',
40 `Flags` int(10) unsigned NOT NULL default '0',
41 `SpecialFlags` tinyint(3) unsigned NOT NULL default '0',
42 `RewardTitleId` tinyint(3) unsigned NOT NULL default '0',
43 `RequiredPlayerKills` tinyint(3) unsigned NOT NULL default '0',
44 `RewardTalents` tinyint(3) unsigned NOT NULL default '0',
45 `RewardArenaPoints` smallint(5) unsigned NOT NULL default '0',
46 `RewardItemId1` mediumint(8) unsigned NOT NULL default '0',
47 `RewardItemId2` mediumint(8) unsigned NOT NULL default '0',
48 `RewardItemId3` mediumint(8) unsigned NOT NULL default '0',
49 `RewardItemId4` mediumint(8) unsigned NOT NULL default '0',
50 `RewardItemCount1` smallint(5) unsigned NOT NULL default '0',
51 `RewardItemCount2` smallint(5) unsigned NOT NULL default '0',
52 `RewardItemCount3` smallint(5) unsigned NOT NULL default '0',
53 `RewardItemCount4` smallint(5) unsigned NOT NULL default '0',
54 `RewardChoiceItemId1` mediumint(8) unsigned NOT NULL default '0',
55 `RewardChoiceItemId2` mediumint(8) unsigned NOT NULL default '0',
56 `RewardChoiceItemId3` mediumint(8) unsigned NOT NULL default '0',
57 `RewardChoiceItemId4` mediumint(8) unsigned NOT NULL default '0',
58 `RewardChoiceItemId5` mediumint(8) unsigned NOT NULL default '0',
59 `RewardChoiceItemId6` mediumint(8) unsigned NOT NULL default '0',
60 `RewardChoiceItemCount1` smallint(5) unsigned NOT NULL default '0',
61 `RewardChoiceItemCount2` smallint(5) unsigned NOT NULL default '0',
62 `RewardChoiceItemCount3` smallint(5) unsigned NOT NULL default '0',
63 `RewardChoiceItemCount4` smallint(5) unsigned NOT NULL default '0',
64 `RewardChoiceItemCount5` smallint(5) unsigned NOT NULL default '0',
65 `RewardChoiceItemCount6` smallint(5) unsigned NOT NULL default '0',
66 `RewardFactionId1` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
67 `RewardFactionId2` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
68 `RewardFactionId3` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
69 `RewardFactionId4` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
70 `RewardFactionId5` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
71 `RewardFactionValueId1` mediumint(6) NOT NULL default '0',
72 `RewardFactionValueId2` mediumint(6) NOT NULL default '0',
73 `RewardFactionValueId3` mediumint(6) NOT NULL default '0',
74 `RewardFactionValueId4` mediumint(6) NOT NULL default '0',
75 `RewardFactionValueId5` mediumint(6) NOT NULL default '0',
76 `RewardFactionValueIdOverride1` mediumint(9) NOT NULL default '0',
77 `RewardFactionValueIdOverride2` mediumint(9) NOT NULL default '0',
78 `RewardFactionValueIdOverride3` mediumint(9) NOT NULL default '0',
79 `RewardFactionValueIdOverride4` mediumint(9) NOT NULL default '0',
80 `RewardFactionValueIdOverride5` mediumint(9) NOT NULL default '0',
81 `PointMapId` smallint(5) unsigned NOT NULL default '0',
82 `PointX` float NOT NULL default '0',
83 `PointY` float NOT NULL default '0',
84 `PointOption` mediumint(8) unsigned NOT NULL default '0',
85 `Title` text,
86 `Objectives` text,
87 `Details` text,
88 `EndText` text,
89 `OfferRewardText` text,
90 `RequestItemsText` text,
91 `CompletedText` text,
92 `RequiredNpcOrGo1` mediumint(9) NOT NULL default '0',
93 `RequiredNpcOrGo2` mediumint(9) NOT NULL default '0',
94 `RequiredNpcOrGo3` mediumint(9) NOT NULL default '0',
95 `RequiredNpcOrGo4` mediumint(9) NOT NULL default '0',
96 `RequiredNpcOrGoCount1` smallint(5) unsigned NOT NULL default '0',
97 `RequiredNpcOrGoCount2` smallint(5) unsigned NOT NULL default '0',
98 `RequiredNpcOrGoCount3` smallint(5) unsigned NOT NULL default '0',
99 `RequiredNpcOrGoCount4` smallint(5) unsigned NOT NULL default '0',
100 `RequiredSourceItemId1` mediumint(8) unsigned NOT NULL default '0',
101 `RequiredSourceItemId2` mediumint(8) unsigned NOT NULL default '0',
102 `RequiredSourceItemId3` mediumint(8) unsigned NOT NULL default '0',
103 `RequiredSourceItemId4` mediumint(8) unsigned NOT NULL default '0',
104 `RequiredSourceItemCount1` smallint(5) unsigned NOT NULL default '0',
105 `RequiredSourceItemCount2` smallint(5) unsigned NOT NULL default '0',
106 `RequiredSourceItemCount3` smallint(5) unsigned NOT NULL default '0',
107 `RequiredSourceItemCount4` smallint(5) unsigned NOT NULL default '0',
108 `RequiredItemId1` mediumint(8) unsigned NOT NULL default '0',
109 `RequiredItemId2` mediumint(8) unsigned NOT NULL default '0',
110 `RequiredItemId3` mediumint(8) unsigned NOT NULL default '0',
111 `RequiredItemId4` mediumint(8) unsigned NOT NULL default '0',
112 `RequiredItemId5` mediumint(8) unsigned NOT NULL default '0',
113 `RequiredItemId6` mediumint(8) unsigned NOT NULL default '0',
114 `RequiredItemCount1` smallint(5) unsigned NOT NULL default '0',
115 `RequiredItemCount2` smallint(5) unsigned NOT NULL default '0',
116 `RequiredItemCount3` smallint(5) unsigned NOT NULL default '0',
117 `RequiredItemCount4` smallint(5) unsigned NOT NULL default '0',
118 `RequiredItemCount5` smallint(5) unsigned NOT NULL default '0',
119 `RequiredItemCount6` smallint(5) unsigned NOT NULL default '0',
120 `RequiredSpellCast1` mediumint(8) unsigned NOT NULL default '0',
121 `RequiredSpellCast2` mediumint(8) unsigned NOT NULL default '0',
122 `RequiredSpellCast3` mediumint(8) unsigned NOT NULL default '0',
123 `RequiredSpellCast4` mediumint(8) unsigned NOT NULL default '0',
124 `Unknown0` tinyint(2) unsigned NOT NULL default '0',
125 `ObjectiveText1` text,
126 `ObjectiveText2` text,
127 `ObjectiveText3` text,
128 `ObjectiveText4` text,
129 `DetailsEmote1` smallint(5) unsigned NOT NULL default '0',
130 `DetailsEmote2` smallint(5) unsigned NOT NULL default '0',
131 `DetailsEmote3` smallint(5) unsigned NOT NULL default '0',
132 `DetailsEmote4` smallint(5) unsigned NOT NULL default '0',
133 `DetailsEmoteDelay1` int(11) unsigned NOT NULL default '0',
134 `DetailsEmoteDelay2` int(11) unsigned NOT NULL default '0',
135 `DetailsEmoteDelay3` int(11) unsigned NOT NULL default '0',
136 `DetailsEmoteDelay4` int(11) unsigned NOT NULL default '0',
137 `EmoteOnIncomplete` smallint(5) unsigned NOT NULL default '0',
138 `EmoteOnComplete` smallint(5) unsigned NOT NULL default '0',
139 `OfferRewardEmote1` smallint(5) unsigned NOT NULL default '0',
140 `OfferRewardEmote2` smallint(5) unsigned NOT NULL default '0',
141 `OfferRewardEmote3` smallint(5) unsigned NOT NULL default '0',
142 `OfferRewardEmote4` smallint(5) unsigned NOT NULL default '0',
143 `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL default '0',
144 `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL default '0',
145 `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL default '0',
146 `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL default '0',
147 `StartScript` mediumint(8) unsigned NOT NULL default '0',
148 `CompleteScript` mediumint(8) unsigned NOT NULL default '0',
149 `WDBVerified` smallint(5) default '1',
150 PRIMARY KEY (`Id`)
151) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';