· 8 years ago · Jan 22, 2018, 03:46 PM
1/*
2SQLyog Enterprise - MySQL GUI v5.02
3Host - 5.1.41 : Database - cataproject
4*********************************************************************
5Server version : 5.1.41
6*/
7
8
9/*Table structure for table `quest_template` */
10
11DROP TABLE IF EXISTS `quest_template`;
12
13CREATE TABLE `quest_template` (
14 `entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
15 `Method` tinyint(3) unsigned NOT NULL DEFAULT '2',
16 `ZoneOrSort` smallint(6) NOT NULL DEFAULT '0',
17 `SkillOrClassMask` mediumint(8) NOT NULL DEFAULT '0',
18 `MinLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
19 `MaxLevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
20 `QuestLevel` smallint(3) NOT NULL DEFAULT '1',
21 `Type` smallint(5) unsigned NOT NULL DEFAULT '0',
22 `RequiredRaces` int(15) unsigned NOT NULL DEFAULT '0',
23 `RequiredSkillValue` smallint(5) unsigned NOT NULL DEFAULT '0',
24 `RepObjectiveFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
25 `RepObjectiveValue` mediumint(9) NOT NULL DEFAULT '0',
26 `RepObjectiveFaction2` smallint(5) unsigned NOT NULL DEFAULT '0',
27 `RepObjectiveValue2` mediumint(9) NOT NULL DEFAULT '0',
28 `RequiredMinRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
29 `RequiredMinRepValue` mediumint(9) NOT NULL DEFAULT '0',
30 `RequiredMaxRepFaction` smallint(5) unsigned NOT NULL DEFAULT '0',
31 `RequiredMaxRepValue` mediumint(9) NOT NULL DEFAULT '0',
32 `SuggestedPlayers` tinyint(3) unsigned NOT NULL DEFAULT '0',
33 `LimitTime` int(10) unsigned NOT NULL DEFAULT '0',
34 `QuestFlags` int(10) unsigned NOT NULL DEFAULT '0',
35 `SpecialFlags` tinyint(3) unsigned NOT NULL DEFAULT '0',
36 `CharTitleId` tinyint(3) unsigned NOT NULL DEFAULT '0',
37 `PlayersSlain` tinyint(3) unsigned NOT NULL DEFAULT '0',
38 `BonusTalents` tinyint(3) unsigned NOT NULL DEFAULT '0',
39 `RewardArenaPoints` smallint(5) unsigned NOT NULL DEFAULT '0',
40 `PrevQuestId` mediumint(9) NOT NULL DEFAULT '0',
41 `NextQuestId` mediumint(9) NOT NULL DEFAULT '0',
42 `ExclusiveGroup` mediumint(9) NOT NULL DEFAULT '0',
43 `NextQuestInChain` mediumint(8) unsigned NOT NULL DEFAULT '0',
44 `RewXPId` tinyint(2) unsigned NOT NULL DEFAULT '0',
45 `SrcItemId` mediumint(8) unsigned NOT NULL DEFAULT '0',
46 `SrcItemCount` tinyint(3) unsigned NOT NULL DEFAULT '0',
47 `SrcSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
48 `Title` text,
49 `Details` text,
50 `Objectives` text,
51 `OfferRewardText` text,
52 `RequestItemsText` text,
53 `EndText` text,
54 `CompletedText` text,
55 `ObjectiveText1` text,
56 `ObjectiveText2` text,
57 `ObjectiveText3` text,
58 `ObjectiveText4` text,
59 `ReqItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
60 `ReqItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
61 `ReqItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
62 `ReqItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
63 `ReqItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0',
64 `ReqItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0',
65 `ReqItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
66 `ReqItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
67 `ReqItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
68 `ReqItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
69 `ReqItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0',
70 `ReqItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0',
71 `ReqSourceId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
72 `ReqSourceId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
73 `ReqSourceId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
74 `ReqSourceId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
75 `ReqSourceCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
76 `ReqSourceCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
77 `ReqSourceCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
78 `ReqSourceCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
79 `ReqCreatureOrGOId1` mediumint(9) NOT NULL DEFAULT '0',
80 `ReqCreatureOrGOId2` mediumint(9) NOT NULL DEFAULT '0',
81 `ReqCreatureOrGOId3` mediumint(9) NOT NULL DEFAULT '0',
82 `ReqCreatureOrGOId4` mediumint(9) NOT NULL DEFAULT '0',
83 `ReqCreatureOrGOCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
84 `ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
85 `ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
86 `ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
87 `ReqSpellCast1` mediumint(8) unsigned NOT NULL DEFAULT '0',
88 `ReqSpellCast2` mediumint(8) unsigned NOT NULL DEFAULT '0',
89 `ReqSpellCast3` mediumint(8) unsigned NOT NULL DEFAULT '0',
90 `ReqSpellCast4` mediumint(8) unsigned NOT NULL DEFAULT '0',
91 `RewChoiceItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
92 `RewChoiceItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
93 `RewChoiceItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
94 `RewChoiceItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
95 `RewChoiceItemId5` mediumint(8) unsigned NOT NULL DEFAULT '0',
96 `RewChoiceItemId6` mediumint(8) unsigned NOT NULL DEFAULT '0',
97 `RewChoiceItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
98 `RewChoiceItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
99 `RewChoiceItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
100 `RewChoiceItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
101 `RewChoiceItemCount5` smallint(5) unsigned NOT NULL DEFAULT '0',
102 `RewChoiceItemCount6` smallint(5) unsigned NOT NULL DEFAULT '0',
103 `RewItemId1` mediumint(8) unsigned NOT NULL DEFAULT '0',
104 `RewItemId2` mediumint(8) unsigned NOT NULL DEFAULT '0',
105 `RewItemId3` mediumint(8) unsigned NOT NULL DEFAULT '0',
106 `RewItemId4` mediumint(8) unsigned NOT NULL DEFAULT '0',
107 `RewItemCount1` smallint(5) unsigned NOT NULL DEFAULT '0',
108 `RewItemCount2` smallint(5) unsigned NOT NULL DEFAULT '0',
109 `RewItemCount3` smallint(5) unsigned NOT NULL DEFAULT '0',
110 `RewItemCount4` smallint(5) unsigned NOT NULL DEFAULT '0',
111 `RewRepFaction1` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
112 `RewRepFaction2` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
113 `RewRepFaction3` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
114 `RewRepFaction4` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
115 `RewRepFaction5` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'faction id from Faction.dbc in this case',
116 `RewRepValueId1` mediumint(6) NOT NULL DEFAULT '0',
117 `RewRepValueId2` mediumint(6) NOT NULL DEFAULT '0',
118 `RewRepValueId3` mediumint(6) NOT NULL DEFAULT '0',
119 `RewRepValueId4` mediumint(6) NOT NULL DEFAULT '0',
120 `RewRepValueId5` mediumint(6) NOT NULL DEFAULT '0',
121 `RewRepValue1` int(10) NOT NULL DEFAULT '0',
122 `RewRepValue2` int(10) NOT NULL DEFAULT '0',
123 `RewRepValue3` int(10) NOT NULL DEFAULT '0',
124 `RewRepValue4` int(10) NOT NULL DEFAULT '0',
125 `RewRepValue5` int(10) NOT NULL DEFAULT '0',
126 `RewHonorAddition` int(10) NOT NULL DEFAULT '0',
127 `RewHonorMultiplier` float NOT NULL DEFAULT '1',
128 `unk0` tinyint(2) unsigned NOT NULL DEFAULT '0',
129 `RewOrReqMoney` int(11) NOT NULL DEFAULT '0',
130 `RewMoneyMaxLevel` int(10) unsigned NOT NULL DEFAULT '0',
131 `RewSpell` mediumint(8) unsigned NOT NULL DEFAULT '0',
132 `RewSpellCast` int(11) NOT NULL DEFAULT '0',
133 `RewMailTemplateId` mediumint(8) unsigned NOT NULL DEFAULT '0',
134 `RewMailDelaySecs` int(11) unsigned NOT NULL DEFAULT '0',
135 `PointMapId` smallint(5) unsigned NOT NULL DEFAULT '0',
136 `PointX` float NOT NULL DEFAULT '0',
137 `PointY` float NOT NULL DEFAULT '0',
138 `PointOpt` mediumint(8) unsigned NOT NULL DEFAULT '0',
139 `DetailsEmote1` smallint(5) unsigned NOT NULL DEFAULT '0',
140 `DetailsEmote2` smallint(5) unsigned NOT NULL DEFAULT '0',
141 `DetailsEmote3` smallint(5) unsigned NOT NULL DEFAULT '0',
142 `DetailsEmote4` smallint(5) unsigned NOT NULL DEFAULT '0',
143 `DetailsEmoteDelay1` int(11) unsigned NOT NULL DEFAULT '0',
144 `DetailsEmoteDelay2` int(11) unsigned NOT NULL DEFAULT '0',
145 `DetailsEmoteDelay3` int(11) unsigned NOT NULL DEFAULT '0',
146 `DetailsEmoteDelay4` int(11) unsigned NOT NULL DEFAULT '0',
147 `IncompleteEmote` smallint(5) unsigned NOT NULL DEFAULT '0',
148 `CompleteEmote` smallint(5) unsigned NOT NULL DEFAULT '0',
149 `OfferRewardEmote1` smallint(5) unsigned NOT NULL DEFAULT '0',
150 `OfferRewardEmote2` smallint(5) unsigned NOT NULL DEFAULT '0',
151 `OfferRewardEmote3` smallint(5) unsigned NOT NULL DEFAULT '0',
152 `OfferRewardEmote4` smallint(5) unsigned NOT NULL DEFAULT '0',
153 `OfferRewardEmoteDelay1` int(11) unsigned NOT NULL DEFAULT '0',
154 `OfferRewardEmoteDelay2` int(11) unsigned NOT NULL DEFAULT '0',
155 `OfferRewardEmoteDelay3` int(11) unsigned NOT NULL DEFAULT '0',
156 `OfferRewardEmoteDelay4` int(11) unsigned NOT NULL DEFAULT '0',
157 `RewSkillLineId` int(11) unsigned NOT NULL DEFAULT '0',
158 `RewSkillPoints` int(11) unsigned NOT NULL DEFAULT '0',
159 `RewRepMask` int(11) unsigned NOT NULL DEFAULT '0',
160 `QuestGiverPortrait` int(11) unsigned NOT NULL DEFAULT '0',
161 `QuestTurnInPortrait` int(11) unsigned NOT NULL DEFAULT '0',
162 `RewCurrencyId1` int(11) unsigned NOT NULL DEFAULT '0',
163 `RewCurrencyCount1` int(11) unsigned NOT NULL DEFAULT '0',
164 `RewCurrencyId2` int(11) unsigned NOT NULL DEFAULT '0',
165 `RewCurrencyCount2` int(11) unsigned NOT NULL DEFAULT '0',
166 `RewCurrencyId3` int(11) unsigned NOT NULL DEFAULT '0',
167 `RewCurrencyCount3` int(11) unsigned NOT NULL DEFAULT '0',
168 `RewCurrencyId4` int(11) unsigned NOT NULL DEFAULT '0',
169 `RewCurrencyCount4` int(11) unsigned NOT NULL DEFAULT '0',
170 `ReqCurrencyId1` int(11) unsigned NOT NULL DEFAULT '0',
171 `ReqCurrencyCount1` int(11) unsigned NOT NULL DEFAULT '0',
172 `ReqCurrencyId2` int(11) unsigned NOT NULL DEFAULT '0',
173 `ReqCurrencyCount2` int(11) unsigned NOT NULL DEFAULT '0',
174 `ReqCurrencyId3` int(11) unsigned NOT NULL DEFAULT '0',
175 `ReqCurrencyCount3` int(11) unsigned NOT NULL DEFAULT '0',
176 `ReqCurrencyId4` int(11) unsigned NOT NULL DEFAULT '0',
177 `ReqCurrencyCount4` int(11) unsigned NOT NULL DEFAULT '0',
178 `QuestGiverPortraitText` text,
179 `QuestGiverPortraitUnk` text,
180 `QuestTurnInPortraitText` text,
181 `QuestTurnInPortraitUnk` text,
182 `SoundAccept` int(11) unsigned NOT NULL DEFAULT '0',
183 `SoundTurnIn` int(11) unsigned NOT NULL DEFAULT '0',
184 `RequiredSpell` int(11) unsigned NOT NULL DEFAULT '0',
185 `StartScript` mediumint(8) unsigned NOT NULL DEFAULT '0',
186 `CompleteScript` mediumint(8) unsigned NOT NULL DEFAULT '0',
187 `WDBVerified` smallint(5) DEFAULT '1',
188 PRIMARY KEY (`entry`)
189) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';