· 8 years ago · May 12, 2018, 08:00 PM
1DROP TABLE IF EXISTS `game_event_seasonal_questrelation`;
2CREATE TABLE `game_event_seasonal_questrelation` (
3 `quest` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier',
4 `event` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Quest Identifier',
5 PRIMARY KEY (`quest`,`event`),
6 KEY `idx_quest` (`quest`)
7) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Player System';
8
9INSERT INTO `game_event_seasonal_questrelation` (`quest`,`event`) VALUES
10 (1657, 12),
11 (1658, 12),
12 (6961, 2),
13 (6962, 2),
14 (6963, 2),
15 (6964, 2),
16 (6983, 3),
17 (6984, 3),
18 (7021, 2),
19 (7022, 2),
20 (7023, 2),
21 (7024, 2),
22 (7025, 2),
23 (7042, 2),
24 (7043, 2),
25 (7045, 2),
26 (7061, 2),
27 (7062, 2),
28 (7063, 2),
29 (8149, 11),
30 (8150, 11),
31 (8311, 12),
32 (8312, 12),
33 (8322, 12),
34 (8353, 12),
35 (8354, 12),
36 (8355, 12),
37 (8356, 12),
38 (8357, 12),
39 (8358, 12),
40 (8359, 12),
41 (8360, 12),
42 (8373, 12),
43 (8409, 12),
44 (8744, 52),
45 (8746, 2),
46 (8762, 2),
47 (8763, 2),
48 (8767, 52),
49 (8768, 52),
50 (8769, 52),
51 (8788, 52),
52 (8799, 2),
53 (8803, 52),
54 (8827, 2),
55 (8828, 2),
56 (8860, 6),
57 (8861, 6),
58 (8868, 7),
59 (8897, 8),
60 (8898, 8),
61 (8899, 8),
62 (8900, 8),
63 (8901, 8),
64 (8902, 8),
65 (8903, 8),
66 (8904, 8),
67 (8971, -1),
68 (8972, -1),
69 (8973, -1),
70 (8974, -1),
71 (8975, -1),
72 (8976, -1),
73 (8979, 8),
74 (8980, 8),
75 (8981, 8),
76 (8982, 8),
77 (8983, 8),
78 (8984, 8),
79 (8993, 8),
80 (9024, 8),
81 (9025, 8),
82 (9026, 8),
83 (9027, 8),
84 (9028, 8),
85 (11131, 12),
86 (11135, 12),
87 (11219, 12),
88 (11220, 12),
89 (11242, 12),
90 (11356, 12),
91 (11357, 12),
92 (11360, 12),
93 (11361, 12),
94 (11392, 12),
95 (11401, 12),
96 (11403, 12),
97 (11404, 12),
98 (11405, 12),
99 (11435, 12),
100 (11439, 12),
101 (11440, 12),
102 (11449, 12),
103 (11450, 12),
104 (11528, 52),
105 (11558, 8),
106 (11580, 1),
107 (11581, 1),
108 (11583, 1),
109 (11584, 1),
110 (11696, 1),
111 (11732, 1),
112 (11734, 1),
113 (11735, 1),
114 (11736, 1),
115 (11737, 1),
116 (11738, 1),
117 (11739, 1),
118 (11740, 1),
119 (11741, 1),
120 (11742, 1),
121 (11743, 1),
122 (11744, 1),
123 (11745, 1),
124 (11746, 1),
125 (11747, 1),
126 (11748, 1),
127 (11749, 1),
128 (11750, 1),
129 (11751, 1),
130 (11752, 1),
131 (11753, 1),
132 (11754, 1),
133 (11755, 1),
134 (11756, 1),
135 (11757, 1),
136 (11758, 1),
137 (11759, 1),
138 (11760, 1),
139 (11761, 1),
140 (11762, 1),
141 (11763, 1),
142 (11764, 1),
143 (11765, 1),
144 (11766, 1),
145 (11767, 1),
146 (11768, 1),
147 (11769, 1),
148 (11770, 1),
149 (11771, 1),
150 (11772, 1),
151 (11773, 1),
152 (11774, 1),
153 (11775, 1),
154 (11776, 1),
155 (11777, 1),
156 (11778, 1),
157 (11779, 1),
158 (11780, 1),
159 (11781, 1),
160 (11782, 1),
161 (11783, 1),
162 (11784, 1),
163 (11785, 1),
164 (11786, 1),
165 (11787, 1),
166 (11799, 1),
167 (11800, 1),
168 (11801, 1),
169 (11802, 1),
170 (11803, 1),
171 (11804, 1),
172 (11805, 1),
173 (11806, 1),
174 (11807, 1),
175 (11808, 1),
176 (11809, 1),
177 (11810, 1),
178 (11811, 1),
179 (11812, 1),
180 (11813, 1),
181 (11814, 1),
182 (11815, 1),
183 (11816, 1),
184 (11817, 1),
185 (11818, 1),
186 (11819, 1),
187 (11820, 1),
188 (11821, 1),
189 (11822, 1),
190 (11823, 1),
191 (11824, 1),
192 (11825, 1),
193 (11826, 1),
194 (11827, 1),
195 (11828, 1),
196 (11829, 1),
197 (11830, 1),
198 (11831, 1),
199 (11832, 1),
200 (11833, 1),
201 (11834, 1),
202 (11835, 1),
203 (11836, 1),
204 (11837, 1),
205 (11838, 1),
206 (11839, 1),
207 (11840, 1),
208 (11841, 1),
209 (11842, 1),
210 (11843, 1),
211 (11844, 1),
212 (11845, 1),
213 (11846, 1),
214 (11847, 1),
215 (11848, 1),
216 (11849, 1),
217 (11850, 1),
218 (11851, 1),
219 (11852, 1),
220 (11853, 1),
221 (11854, 1),
222 (11855, 1),
223 (11856, 1),
224 (11857, 1),
225 (11858, 1),
226 (11859, 1),
227 (11860, 1),
228 (11861, 1),
229 (11862, 1),
230 (11863, 1),
231 (11937, 1),
232 (11976, 1),
233 (12133, 12),
234 (12135, 12),
235 (12139, 12),
236 (12155, 12),
237 (12286, -1),
238 (12313, 24),
239 (12331, 12),
240 (12332, 12),
241 (12333, 12),
242 (12334, 12),
243 (12335, 12),
244 (12336, 12),
245 (12337, 12),
246 (12338, 12),
247 (12339, 12),
248 (12340, 12),
249 (12341, 12),
250 (12342, 12),
251 (12343, 12),
252 (12344, 12),
253 (12345, 12),
254 (12346, 12),
255 (12347, 12),
256 (12348, 12),
257 (12349, 12),
258 (12350, 12),
259 (12351, 12),
260 (12352, 12),
261 (12353, 12),
262 (12354, 12),
263 (12355, 12),
264 (12356, 12),
265 (12357, 12),
266 (12358, 12),
267 (12359, 12),
268 (12360, 12),
269 (12361, 12),
270 (12362, 12),
271 (12363, 12),
272 (12364, 12),
273 (12365, 12),
274 (12366, 12),
275 (12367, 12),
276 (12368, 12),
277 (12369, 12),
278 (12370, 12),
279 (12371, 12),
280 (12373, 12),
281 (12374, 12),
282 (12375, 12),
283 (12376, 12),
284 (12377, 12),
285 (12378, 12),
286 (12379, 12),
287 (12380, 12),
288 (12381, 12),
289 (12382, 12),
290 (12383, 12),
291 (12384, 12),
292 (12385, 12),
293 (12386, 12),
294 (12387, 12),
295 (12388, 12),
296 (12389, 12),
297 (12390, 12),
298 (12391, 12),
299 (12392, 12),
300 (12393, 12),
301 (12394, 12),
302 (12395, 12),
303 (12396, 12),
304 (12397, 12),
305 (12398, 12),
306 (12399, 12),
307 (12400, 12),
308 (12401, 12),
309 (12402, 12),
310 (12403, 12),
311 (12404, 12),
312 (12405, 12),
313 (12406, 12),
314 (12407, 12),
315 (12408, 12),
316 (12409, 12),
317 (12410, 12),
318 (12940, 12),
319 (12941, 12),
320 (12944, 12),
321 (12945, 12),
322 (12946, 12),
323 (12947, 12),
324 (12950, 12),
325 (13203, 52),
326 (13433, 12),
327 (13434, 12),
328 (13435, 12),
329 (13436, 12),
330 (13437, 12),
331 (13438, 12),
332 (13439, 12),
333 (13440, 12),
334 (13441, 12),
335 (13442, 12),
336 (13443, 12),
337 (13444, 12),
338 (13445, 12),
339 (13446, 12),
340 (13447, 12),
341 (13448, 12),
342 (13449, 12),
343 (13450, 12),
344 (13451, 12),
345 (13452, 12),
346 (13453, 12),
347 (13454, 12),
348 (13455, 12),
349 (13456, 12),
350 (13457, 12),
351 (13458, 12),
352 (13459, 12),
353 (13460, 12),
354 (13461, 12),
355 (13462, 12),
356 (13463, 12),
357 (13464, 12),
358 (13465, 12),
359 (13466, 12),
360 (13467, 12),
361 (13468, 12),
362 (13469, 12),
363 (13470, 12),
364 (13471, 12),
365 (13472, 12),
366 (13473, 12),
367 (13474, 12),
368 (13485, 1),
369 (13486, 1),
370 (13487, 1),
371 (13488, 1),
372 (13489, 1),
373 (13490, 1),
374 (13491, 1),
375 (13492, 1),
376 (13493, 1),
377 (13494, 1),
378 (13495, 1),
379 (13496, 1),
380 (13497, 1),
381 (13498, 1),
382 (13499, 1),
383 (13500, 1),
384 (13501, 12),
385 (13548, 12),
386 (13966, 52);