yAQUv2Cp

1
2-- ----------------------------
3-- Table structure for `shop`
4-- ----------------------------
5DROP TABLE IF EXISTS `shop`;
6CREATE TABLE `shop` (
7  `vnum` int(11) NOT NULL DEFAULT '0',
8  `name` varchar(32) CHARACTER SET latin2 NOT NULL DEFAULT 'Noname',
9  `npc_vnum` smallint(6) NOT NULL DEFAULT '0',
10  PRIMARY KEY (`vnum`)
11) ENGINE=MyISAM DEFAULT CHARSET=latin1;
12
13-- ----------------------------
14-- Records of shop
15-- ----------------------------
16INSERT INTO `shop` VALUES ('1', '9001', '9001');
17INSERT INTO `shop` VALUES ('2', '9009', '9009');
18INSERT INTO `shop` VALUES ('3', '9003', '9003');
19INSERT INTO `shop` VALUES ('4', '9002', '9002');
20INSERT INTO `shop` VALUES ('5', '9007', '9007');
21INSERT INTO `shop` VALUES ('6', '9008', '9008');
22INSERT INTO `shop` VALUES ('1001', 'all_sword', '0');
23INSERT INTO `shop` VALUES ('1002', 'all_dualhand_sword', '0');
24INSERT INTO `shop` VALUES ('1003', 'all_bow', '0');
25INSERT INTO `shop` VALUES ('1004', 'all_twohand_sword', '0');
26INSERT INTO `shop` VALUES ('1005', 'all_bell', '0');
27INSERT INTO `shop` VALUES ('1006', 'all_fan', '0');
28INSERT INTO `shop` VALUES ('1007', 'all_warrior_armour', '0');
29INSERT INTO `shop` VALUES ('1008', 'all_assassin_armour', '0');
30INSERT INTO `shop` VALUES ('1009', 'all_sura_armour', '0');
31INSERT INTO `shop` VALUES ('1010', 'all_shaman_armour', '0');
32INSERT INTO `shop` VALUES ('1011', 'all_warrior_helmet', '0');
33INSERT INTO `shop` VALUES ('1012', 'all_assassin_helmet', '0');
34INSERT INTO `shop` VALUES ('1013', 'all_sura_helmet', '0');
35INSERT INTO `shop` VALUES ('1014', 'all_shaman_helmet', '0');
36INSERT INTO `shop` VALUES ('1015', 'all_shield', '0');
37INSERT INTO `shop` VALUES ('1016', 'all_bracelet', '0');
38INSERT INTO `shop` VALUES ('1017', 'all_shoe', '0');
39INSERT INTO `shop` VALUES ('1018', 'all_necklace', '0');
40INSERT INTO `shop` VALUES ('1019', 'all_ring', '0');
41INSERT INTO `shop` VALUES ('7', 'gold_bar_shop', '9005');
42INSERT INTO `shop` VALUES ('8', 'firework_shop', '9004');
43INSERT INTO `shop` VALUES ('9', '?? ???', '20042');
44INSERT INTO `shop` VALUES ('10', 'pick_shop', '20015');
45INSERT INTO `shop` VALUES ('11', '??????', '20349');
46
47-- ----------------------------
48-- Table structure for `shop_cost`
49-- ----------------------------
50DROP TABLE IF EXISTS `shop_cost`;
51CREATE TABLE `shop_cost` (
52  `id` int(255) NOT NULL AUTO_INCREMENT,
53  `time` int(255) NOT NULL DEFAULT '0',
54  `time_type` enum('day','hour','normal_shop') NOT NULL DEFAULT 'day',
55  `cost` int(255) NOT NULL DEFAULT '0',
56  PRIMARY KEY (`id`)
57) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
58
59-- ----------------------------
60-- Records of shop_cost
61-- ----------------------------
62INSERT INTO `shop_cost` VALUES ('5', '0', 'normal_shop', '5000000');
63INSERT INTO `shop_cost` VALUES ('6', '1', 'hour', '100000');
64INSERT INTO `shop_cost` VALUES ('7', '2', 'hour', '500000');
65INSERT INTO `shop_cost` VALUES ('8', '3', 'hour', '1000000');
66INSERT INTO `shop_cost` VALUES ('9', '1', 'day', '1500000');
67INSERT INTO `shop_cost` VALUES ('10', '2', 'day', '2000000');
68INSERT INTO `shop_cost` VALUES ('11', '3', 'day', '2500000');
69
70-- ----------------------------
71-- Table structure for `shop_item`
72-- ----------------------------
73DROP TABLE IF EXISTS `shop_item`;
74CREATE TABLE `shop_item` (
75  `shop_vnum` int(11) NOT NULL DEFAULT '0',
76  `item_vnum` int(11) NOT NULL DEFAULT '0',
77  `count` tinyint(4) unsigned NOT NULL DEFAULT '1',
78  UNIQUE KEY `vnum_unique` (`shop_vnum`,`item_vnum`,`count`)
79) ENGINE=MyISAM DEFAULT CHARSET=latin1;
80
81-- ----------------------------
82-- Records of shop_item
83-- ----------------------------
84INSERT INTO `shop_item` VALUES ('1', '20', '1');
85INSERT INTO `shop_item` VALUES ('1', '40', '1');
86INSERT INTO `shop_item` VALUES ('1', '60', '1');
87INSERT INTO `shop_item` VALUES ('1', '80', '1');
88INSERT INTO `shop_item` VALUES ('1', '1040', '1');
89INSERT INTO `shop_item` VALUES ('1', '2010', '1');
90INSERT INTO `shop_item` VALUES ('1', '2030', '1');
91INSERT INTO `shop_item` VALUES ('1', '2050', '1');
92INSERT INTO `shop_item` VALUES ('1', '2070', '1');
93INSERT INTO `shop_item` VALUES ('1', '3010', '1');
94INSERT INTO `shop_item` VALUES ('1', '3030', '1');
95INSERT INTO `shop_item` VALUES ('1', '3050', '1');
96INSERT INTO `shop_item` VALUES ('1', '3070', '1');
97INSERT INTO `shop_item` VALUES ('1', '4000', '1');
98INSERT INTO `shop_item` VALUES ('1', '4010', '1');
99INSERT INTO `shop_item` VALUES ('1', '4020', '1');
100INSERT INTO `shop_item` VALUES ('1', '5010', '1');
101INSERT INTO `shop_item` VALUES ('1', '5030', '1');
102INSERT INTO `shop_item` VALUES ('1', '7010', '1');
103INSERT INTO `shop_item` VALUES ('1', '7030', '1');
104INSERT INTO `shop_item` VALUES ('1', '7050', '1');
105INSERT INTO `shop_item` VALUES ('1', '8000', '100');
106INSERT INTO `shop_item` VALUES ('1', '8000', '200');
107INSERT INTO `shop_item` VALUES ('2', '27400', '1');
108INSERT INTO `shop_item` VALUES ('2', '27600', '1');
109INSERT INTO `shop_item` VALUES ('2', '27610', '1');
110INSERT INTO `shop_item` VALUES ('2', '27800', '5');
111INSERT INTO `shop_item` VALUES ('2', '27800', '50');
112INSERT INTO `shop_item` VALUES ('2', '27801', '5');
113INSERT INTO `shop_item` VALUES ('2', '27801', '50');
114INSERT INTO `shop_item` VALUES ('3', '14000', '1');
115INSERT INTO `shop_item` VALUES ('3', '15000', '1');
116INSERT INTO `shop_item` VALUES ('3', '16000', '1');
117INSERT INTO `shop_item` VALUES ('3', '17000', '1');
118INSERT INTO `shop_item` VALUES ('3', '27001', '5');
119INSERT INTO `shop_item` VALUES ('3', '27001', '20');
120INSERT INTO `shop_item` VALUES ('3', '27001', '200');
121INSERT INTO `shop_item` VALUES ('3', '27002', '5');
122INSERT INTO `shop_item` VALUES ('3', '27002', '20');
123INSERT INTO `shop_item` VALUES ('3', '27002', '200');
124INSERT INTO `shop_item` VALUES ('3', '27003', '5');
125INSERT INTO `shop_item` VALUES ('3', '27003', '20');
126INSERT INTO `shop_item` VALUES ('3', '27003', '200');
127INSERT INTO `shop_item` VALUES ('3', '27004', '5');
128INSERT INTO `shop_item` VALUES ('3', '27004', '20');
129INSERT INTO `shop_item` VALUES ('3', '27004', '200');
130INSERT INTO `shop_item` VALUES ('3', '27005', '5');
131INSERT INTO `shop_item` VALUES ('3', '27005', '20');
132INSERT INTO `shop_item` VALUES ('3', '27005', '200');
133INSERT INTO `shop_item` VALUES ('3', '27006', '5');
134INSERT INTO `shop_item` VALUES ('3', '27006', '20');
135INSERT INTO `shop_item` VALUES ('3', '27006', '200');
136INSERT INTO `shop_item` VALUES ('3', '50200', '1');
137INSERT INTO `shop_item` VALUES ('3', '50901', '10');
138INSERT INTO `shop_item` VALUES ('4', '11200', '1');
139INSERT INTO `shop_item` VALUES ('4', '11220', '1');
140INSERT INTO `shop_item` VALUES ('4', '11230', '1');
141INSERT INTO `shop_item` VALUES ('4', '11400', '1');
142INSERT INTO `shop_item` VALUES ('4', '11420', '1');
143INSERT INTO `shop_item` VALUES ('4', '11430', '1');
144INSERT INTO `shop_item` VALUES ('4', '11600', '1');
145INSERT INTO `shop_item` VALUES ('4', '11620', '1');
146INSERT INTO `shop_item` VALUES ('4', '11630', '1');
147INSERT INTO `shop_item` VALUES ('4', '11800', '1');
148INSERT INTO `shop_item` VALUES ('4', '11820', '1');
149INSERT INTO `shop_item` VALUES ('4', '11830', '1');
150INSERT INTO `shop_item` VALUES ('4', '12200', '1');
151INSERT INTO `shop_item` VALUES ('4', '12340', '1');
152INSERT INTO `shop_item` VALUES ('4', '12480', '1');
153INSERT INTO `shop_item` VALUES ('4', '12620', '1');
154INSERT INTO `shop_item` VALUES ('4', '13000', '1');
155INSERT INTO `shop_item` VALUES ('5', '3100', '1');
156INSERT INTO `shop_item` VALUES ('5', '5020', '1');
157INSERT INTO `shop_item` VALUES ('5', '5030', '1');
158INSERT INTO `shop_item` VALUES ('5', '5040', '1');
159INSERT INTO `shop_item` VALUES ('5', '5050', '1');
160INSERT INTO `shop_item` VALUES ('5', '5070', '1');
161INSERT INTO `shop_item` VALUES ('5', '5080', '1');
162INSERT INTO `shop_item` VALUES ('5', '7020', '1');
163INSERT INTO `shop_item` VALUES ('5', '7050', '1');
164INSERT INTO `shop_item` VALUES ('5', '7060', '1');
165INSERT INTO `shop_item` VALUES ('5', '7090', '1');
166INSERT INTO `shop_item` VALUES ('5', '7100', '1');
167INSERT INTO `shop_item` VALUES ('6', '14000', '1');
168INSERT INTO `shop_item` VALUES ('6', '14020', '1');
169INSERT INTO `shop_item` VALUES ('6', '14040', '1');
170INSERT INTO `shop_item` VALUES ('6', '14060', '1');
171INSERT INTO `shop_item` VALUES ('6', '14080', '1');
172INSERT INTO `shop_item` VALUES ('6', '14140', '1');
173INSERT INTO `shop_item` VALUES ('6', '15000', '1');
174INSERT INTO `shop_item` VALUES ('6', '15020', '1');
175INSERT INTO `shop_item` VALUES ('6', '15040', '1');
176INSERT INTO `shop_item` VALUES ('6', '15060', '1');
177INSERT INTO `shop_item` VALUES ('6', '15080', '1');
178INSERT INTO `shop_item` VALUES ('6', '15160', '1');
179INSERT INTO `shop_item` VALUES ('6', '16000', '1');
180INSERT INTO `shop_item` VALUES ('6', '16020', '1');
181INSERT INTO `shop_item` VALUES ('6', '16040', '1');
182INSERT INTO `shop_item` VALUES ('6', '16060', '1');
183INSERT INTO `shop_item` VALUES ('6', '16080', '1');
184INSERT INTO `shop_item` VALUES ('6', '16180', '1');
185INSERT INTO `shop_item` VALUES ('6', '17000', '1');
186INSERT INTO `shop_item` VALUES ('6', '17020', '1');
187INSERT INTO `shop_item` VALUES ('6', '17040', '1');
188INSERT INTO `shop_item` VALUES ('6', '17060', '1');
189INSERT INTO `shop_item` VALUES ('6', '17080', '1');
190INSERT INTO `shop_item` VALUES ('6', '17180', '1');
191INSERT INTO `shop_item` VALUES ('7', '80003', '1');
192INSERT INTO `shop_item` VALUES ('7', '80004', '1');
193INSERT INTO `shop_item` VALUES ('7', '80005', '1');
194INSERT INTO `shop_item` VALUES ('7', '80006', '1');
195INSERT INTO `shop_item` VALUES ('7', '80007', '1');
196INSERT INTO `shop_item` VALUES ('8', '50100', '100');
197INSERT INTO `shop_item` VALUES ('8', '50101', '100');
198INSERT INTO `shop_item` VALUES ('8', '50102', '100');
199INSERT INTO `shop_item` VALUES ('8', '50103', '100');
200INSERT INTO `shop_item` VALUES ('8', '50104', '100');
201INSERT INTO `shop_item` VALUES ('8', '50105', '100');
202INSERT INTO `shop_item` VALUES ('9', '11901', '1');
203INSERT INTO `shop_item` VALUES ('9', '11902', '1');
204INSERT INTO `shop_item` VALUES ('9', '11903', '1');
205INSERT INTO `shop_item` VALUES ('9', '11904', '1');
206INSERT INTO `shop_item` VALUES ('9', '50201', '1');
207INSERT INTO `shop_item` VALUES ('9', '50202', '1');
208INSERT INTO `shop_item` VALUES ('9', '70024', '1');
209INSERT INTO `shop_item` VALUES ('9', '70035', '1');
210INSERT INTO `shop_item` VALUES ('10', '29101', '1');
211INSERT INTO `shop_item` VALUES ('11', '50054', '1');
212INSERT INTO `shop_item` VALUES ('11', '50055', '1');
213INSERT INTO `shop_item` VALUES ('11', '50056', '1');
214INSERT INTO `shop_item` VALUES ('1001', '10', '1');
215INSERT INTO `shop_item` VALUES ('1001', '20', '1');
216INSERT INTO `shop_item` VALUES ('1001', '30', '1');
217INSERT INTO `shop_item` VALUES ('1001', '40', '1');
218INSERT INTO `shop_item` VALUES ('1001', '50', '1');
219INSERT INTO `shop_item` VALUES ('1001', '60', '1');
220INSERT INTO `shop_item` VALUES ('1001', '70', '1');
221INSERT INTO `shop_item` VALUES ('1001', '80', '1');
222INSERT INTO `shop_item` VALUES ('1001', '90', '1');
223INSERT INTO `shop_item` VALUES ('1001', '100', '1');
224INSERT INTO `shop_item` VALUES ('1001', '110', '1');
225INSERT INTO `shop_item` VALUES ('1001', '120', '1');
226INSERT INTO `shop_item` VALUES ('1001', '130', '1');
227INSERT INTO `shop_item` VALUES ('1002', '1000', '1');
228INSERT INTO `shop_item` VALUES ('1002', '1010', '1');
229INSERT INTO `shop_item` VALUES ('1002', '1020', '1');
230INSERT INTO `shop_item` VALUES ('1002', '1030', '1');
231INSERT INTO `shop_item` VALUES ('1002', '1040', '1');
232INSERT INTO `shop_item` VALUES ('1002', '1050', '1');
233INSERT INTO `shop_item` VALUES ('1002', '1060', '1');
234INSERT INTO `shop_item` VALUES ('1002', '1070', '1');
235INSERT INTO `shop_item` VALUES ('1002', '1080', '1');
236INSERT INTO `shop_item` VALUES ('1002', '1090', '1');
237INSERT INTO `shop_item` VALUES ('1002', '4000', '1');
238INSERT INTO `shop_item` VALUES ('1002', '4010', '1');
239INSERT INTO `shop_item` VALUES ('1002', '4020', '1');
240INSERT INTO `shop_item` VALUES ('1003', '2000', '1');
241INSERT INTO `shop_item` VALUES ('1003', '2010', '1');
242INSERT INTO `shop_item` VALUES ('1003', '2020', '1');
243INSERT INTO `shop_item` VALUES ('1003', '2030', '1');
244INSERT INTO `shop_item` VALUES ('1003', '2040', '1');
245INSERT INTO `shop_item` VALUES ('1003', '2050', '1');
246INSERT INTO `shop_item` VALUES ('1003', '2060', '1');
247INSERT INTO `shop_item` VALUES ('1003', '2070', '1');
248INSERT INTO `shop_item` VALUES ('1003', '2080', '1');
249INSERT INTO `shop_item` VALUES ('1003', '2090', '1');
250INSERT INTO `shop_item` VALUES ('1003', '2100', '1');
251INSERT INTO `shop_item` VALUES ('1003', '2110', '1');
252INSERT INTO `shop_item` VALUES ('1003', '2120', '1');
253INSERT INTO `shop_item` VALUES ('1003', '8000', '50');
254INSERT INTO `shop_item` VALUES ('1003', '8000', '200');
255INSERT INTO `shop_item` VALUES ('1004', '3000', '1');
256INSERT INTO `shop_item` VALUES ('1004', '3010', '1');
257INSERT INTO `shop_item` VALUES ('1004', '3020', '1');
258INSERT INTO `shop_item` VALUES ('1004', '3030', '1');
259INSERT INTO `shop_item` VALUES ('1004', '3040', '1');
260INSERT INTO `shop_item` VALUES ('1004', '3050', '1');
261INSERT INTO `shop_item` VALUES ('1004', '3060', '1');
262INSERT INTO `shop_item` VALUES ('1004', '3070', '1');
263INSERT INTO `shop_item` VALUES ('1004', '3080', '1');
264INSERT INTO `shop_item` VALUES ('1004', '3090', '1');
265INSERT INTO `shop_item` VALUES ('1004', '3100', '1');
266INSERT INTO `shop_item` VALUES ('1004', '3110', '1');
267INSERT INTO `shop_item` VALUES ('1004', '3120', '1');
268INSERT INTO `shop_item` VALUES ('1005', '5000', '1');
269INSERT INTO `shop_item` VALUES ('1005', '5010', '1');
270INSERT INTO `shop_item` VALUES ('1005', '5020', '1');
271INSERT INTO `shop_item` VALUES ('1005', '5030', '1');
272INSERT INTO `shop_item` VALUES ('1005', '5040', '1');
273INSERT INTO `shop_item` VALUES ('1005', '5050', '1');
274INSERT INTO `shop_item` VALUES ('1005', '5060', '1');
275INSERT INTO `shop_item` VALUES ('1005', '5070', '1');
276INSERT INTO `shop_item` VALUES ('1005', '5080', '1');
277INSERT INTO `shop_item` VALUES ('1006', '7000', '1');
278INSERT INTO `shop_item` VALUES ('1006', '7010', '1');
279INSERT INTO `shop_item` VALUES ('1006', '7020', '1');
280INSERT INTO `shop_item` VALUES ('1006', '7030', '1');
281INSERT INTO `shop_item` VALUES ('1006', '7040', '1');
282INSERT INTO `shop_item` VALUES ('1006', '7050', '1');
283INSERT INTO `shop_item` VALUES ('1006', '7060', '1');
284INSERT INTO `shop_item` VALUES ('1006', '7070', '1');
285INSERT INTO `shop_item` VALUES ('1006', '7080', '1');
286INSERT INTO `shop_item` VALUES ('1006', '7090', '1');
287INSERT INTO `shop_item` VALUES ('1006', '7100', '1');
288INSERT INTO `shop_item` VALUES ('1006', '7110', '1');
289INSERT INTO `shop_item` VALUES ('1006', '7120', '1');
290INSERT INTO `shop_item` VALUES ('1007', '11200', '1');
291INSERT INTO `shop_item` VALUES ('1007', '11210', '1');
292INSERT INTO `shop_item` VALUES ('1007', '11220', '1');
293INSERT INTO `shop_item` VALUES ('1007', '11230', '1');
294INSERT INTO `shop_item` VALUES ('1007', '11240', '1');
295INSERT INTO `shop_item` VALUES ('1007', '11250', '1');
296INSERT INTO `shop_item` VALUES ('1007', '11260', '1');
297INSERT INTO `shop_item` VALUES ('1008', '11400', '1');
298INSERT INTO `shop_item` VALUES ('1008', '11410', '1');
299INSERT INTO `shop_item` VALUES ('1008', '11420', '1');
300INSERT INTO `shop_item` VALUES ('1008', '11430', '1');
301INSERT INTO `shop_item` VALUES ('1008', '11440', '1');
302INSERT INTO `shop_item` VALUES ('1008', '11450', '1');
303INSERT INTO `shop_item` VALUES ('1008', '11460', '1');
304INSERT INTO `shop_item` VALUES ('1009', '11600', '1');
305INSERT INTO `shop_item` VALUES ('1009', '11610', '1');
306INSERT INTO `shop_item` VALUES ('1009', '11620', '1');
307INSERT INTO `shop_item` VALUES ('1009', '11630', '1');
308INSERT INTO `shop_item` VALUES ('1009', '11640', '1');
309INSERT INTO `shop_item` VALUES ('1009', '11650', '1');
310INSERT INTO `shop_item` VALUES ('1009', '11660', '1');
311INSERT INTO `shop_item` VALUES ('1010', '11800', '1');
312INSERT INTO `shop_item` VALUES ('1010', '11810', '1');
313INSERT INTO `shop_item` VALUES ('1010', '11820', '1');
314INSERT INTO `shop_item` VALUES ('1010', '11830', '1');
315INSERT INTO `shop_item` VALUES ('1010', '11840', '1');
316INSERT INTO `shop_item` VALUES ('1010', '11850', '1');
317INSERT INTO `shop_item` VALUES ('1010', '11860', '1');
318INSERT INTO `shop_item` VALUES ('1011', '12200', '1');
319INSERT INTO `shop_item` VALUES ('1011', '12220', '1');
320INSERT INTO `shop_item` VALUES ('1011', '12240', '1');
321INSERT INTO `shop_item` VALUES ('1012', '12340', '1');
322INSERT INTO `shop_item` VALUES ('1012', '12360', '1');
323INSERT INTO `shop_item` VALUES ('1012', '12380', '1');
324INSERT INTO `shop_item` VALUES ('1013', '12480', '1');
325INSERT INTO `shop_item` VALUES ('1013', '12500', '1');
326INSERT INTO `shop_item` VALUES ('1013', '12520', '1');
327INSERT INTO `shop_item` VALUES ('1014', '12620', '1');
328INSERT INTO `shop_item` VALUES ('1014', '12640', '1');
329INSERT INTO `shop_item` VALUES ('1014', '12660', '1');
330INSERT INTO `shop_item` VALUES ('1015', '13000', '1');
331INSERT INTO `shop_item` VALUES ('1015', '13040', '1');
332INSERT INTO `shop_item` VALUES ('1016', '14000', '1');
333INSERT INTO `shop_item` VALUES ('1016', '14020', '1');
334INSERT INTO `shop_item` VALUES ('1016', '14040', '1');
335INSERT INTO `shop_item` VALUES ('1016', '14060', '1');
336INSERT INTO `shop_item` VALUES ('1016', '14080', '1');
337INSERT INTO `shop_item` VALUES ('1016', '14100', '1');
338INSERT INTO `shop_item` VALUES ('1016', '14120', '1');
339INSERT INTO `shop_item` VALUES ('1016', '14140', '1');
340INSERT INTO `shop_item` VALUES ('1016', '14160', '1');
341INSERT INTO `shop_item` VALUES ('1016', '14180', '1');
342INSERT INTO `shop_item` VALUES ('1016', '14200', '1');
343INSERT INTO `shop_item` VALUES ('1017', '15000', '1');
344INSERT INTO `shop_item` VALUES ('1017', '15020', '1');
345INSERT INTO `shop_item` VALUES ('1017', '15040', '1');
346INSERT INTO `shop_item` VALUES ('1017', '15060', '1');
347INSERT INTO `shop_item` VALUES ('1017', '15080', '1');
348INSERT INTO `shop_item` VALUES ('1017', '15100', '1');
349INSERT INTO `shop_item` VALUES ('1017', '15120', '1');
350INSERT INTO `shop_item` VALUES ('1017', '15140', '1');
351INSERT INTO `shop_item` VALUES ('1017', '15160', '1');
352INSERT INTO `shop_item` VALUES ('1017', '15180', '1');
353INSERT INTO `shop_item` VALUES ('1017', '15200', '1');
354INSERT INTO `shop_item` VALUES ('1017', '15220', '1');
355INSERT INTO `shop_item` VALUES ('1018', '16000', '1');
356INSERT INTO `shop_item` VALUES ('1018', '16020', '1');
357INSERT INTO `shop_item` VALUES ('1018', '16040', '1');
358INSERT INTO `shop_item` VALUES ('1018', '16060', '1');
359INSERT INTO `shop_item` VALUES ('1018', '16080', '1');
360INSERT INTO `shop_item` VALUES ('1018', '16100', '1');
361INSERT INTO `shop_item` VALUES ('1018', '16120', '1');
362INSERT INTO `shop_item` VALUES ('1018', '16140', '1');
363INSERT INTO `shop_item` VALUES ('1018', '16160', '1');
364INSERT INTO `shop_item` VALUES ('1018', '16180', '1');
365INSERT INTO `shop_item` VALUES ('1018', '16200', '1');
366INSERT INTO `shop_item` VALUES ('1019', '17000', '1');
367INSERT INTO `shop_item` VALUES ('1019', '17020', '1');
368INSERT INTO `shop_item` VALUES ('1019', '17040', '1');
369INSERT INTO `shop_item` VALUES ('1019', '17060', '1');
370INSERT INTO `shop_item` VALUES ('1019', '17080', '1');
371INSERT INTO `shop_item` VALUES ('1019', '17100', '1');
372INSERT INTO `shop_item` VALUES ('1019', '17120', '1');
373INSERT INTO `shop_item` VALUES ('1019', '17140', '1');
374INSERT INTO `shop_item` VALUES ('1019', '17160', '1');
375INSERT INTO `shop_item` VALUES ('1019', '17180', '1');
376INSERT INTO `shop_item` VALUES ('1019', '17200', '1');
377
378-- ----------------------------
379-- Table structure for `shop_limit`
380-- ----------------------------
381DROP TABLE IF EXISTS `shop_limit`;
382CREATE TABLE `shop_limit` (
383  `channel` int(2) DEFAULT NULL,
384  `map_index` int(11) DEFAULT NULL,
385  `shop_limit` varchar(255) DEFAULT NULL
386) ENGINE=MyISAM DEFAULT CHARSET=utf8;
387
388-- ----------------------------
389-- Records of shop_limit
390-- ----------------------------
391
392-- ----------------------------
393-- Table structure for `skill_proto`
394-- ----------------------------
395DROP TABLE IF EXISTS `skill_proto`;
396CREATE TABLE `skill_proto` (
397  `dwVnum` int(11) NOT NULL DEFAULT '0',
398  `szName` varbinary(32) NOT NULL DEFAULT '',
399  `bType` tinyint(4) NOT NULL DEFAULT '0',
400  `bLevelStep` tinyint(4) NOT NULL DEFAULT '0',
401  `bMaxLevel` tinyint(4) NOT NULL DEFAULT '0',
402  `bLevelLimit` tinyint(3) unsigned NOT NULL DEFAULT '0',
403  `szPointOn` varchar(100) NOT NULL DEFAULT '0',
404  `szPointPoly` varchar(100) NOT NULL DEFAULT '',
405  `szSPCostPoly` varchar(100) NOT NULL DEFAULT '',
406  `szDurationPoly` varchar(100) NOT NULL DEFAULT '',
407  `szDurationSPCostPoly` varchar(100) NOT NULL DEFAULT '',
408  `szCooldownPoly` varchar(100) NOT NULL DEFAULT '',
409  `szMasterBonusPoly` varchar(100) NOT NULL DEFAULT '',
410  `szAttackGradePoly` varchar(100) NOT NULL DEFAULT '',
411  `setFlag` set('ATTACK','USE_MELEE_DAMAGE','COMPUTE_ATTGRADE','SELFONLY','USE_MAGIC_DAMAGE','USE_HP_AS_COST','COMPUTE_MAGIC_DAMAGE','SPLASH','GIVE_PENALTY','USE_ARROW_DAMAGE','PENETRATE','IGNORE_TARGET_RATING','ATTACK_SLOW','ATTACK_STUN','HP_ABSORB','SP_ABSORB','ATTACK_FIRE_CONT','REMOVE_BAD_AFFECT','REMOVE_GOOD_AFFECT','CRUSH','ATTACK_POISON','TOGGLE','DISABLE_BY_POINT_UP','CRUSH_LONG') DEFAULT NULL,
412  `setAffectFlag` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD','MUYEONG','REVIVE_INVISIBLE','FIRE','GICHEON','JEUNGRYEOK') NOT NULL DEFAULT 'YMIR',
413  `szPointOn2` varchar(100) NOT NULL DEFAULT 'NONE',
414  `szPointPoly2` varchar(100) NOT NULL DEFAULT '',
415  `szDurationPoly2` varchar(100) NOT NULL DEFAULT '',
416  `setAffectFlag2` enum('YMIR','INVISIBILITY','SPAWN','POISON','SLOW','STUN','DUNGEON_READY','FORCE_VISIBLE','BUILDING_CONSTRUCTION_SMALL','BUILDING_CONSTRUCTION_LARGE','BUILDING_UPGRADE','MOV_SPEED_POTION','ATT_SPEED_POTION','FISH_MIDE','JEONGWIHON','GEOMGYEONG','CHEONGEUN','GYEONGGONG','EUNHYUNG','GWIGUM','TERROR','JUMAGAP','HOSIN','BOHO','KWAESOK','MANASHIELD') NOT NULL DEFAULT 'YMIR',
417  `szPointOn3` varchar(100) NOT NULL DEFAULT 'NONE',
418  `szPointPoly3` varchar(100) NOT NULL DEFAULT '',
419  `szDurationPoly3` varchar(100) NOT NULL DEFAULT '',
420  `szGrandMasterAddSPCostPoly` varchar(100) NOT NULL DEFAULT '',
421  `prerequisiteSkillVnum` int(11) NOT NULL DEFAULT '0',
422  `prerequisiteSkillLevel` int(11) NOT NULL DEFAULT '0',
423  `eSkillType` enum('NORMAL','MELEE','RANGE','MAGIC') NOT NULL DEFAULT 'NORMAL',
424  `iMaxHit` tinyint(4) NOT NULL DEFAULT '0',
425  `szSplashAroundDamageAdjustPoly` varchar(100) NOT NULL DEFAULT '1',
426  `dwTargetRange` int(11) NOT NULL DEFAULT '1000',
427  `dwSplashRange` int(10) unsigned NOT NULL DEFAULT '0',
428  PRIMARY KEY (`dwVnum`)
429) ENGINE=MyISAM DEFAULT CHARSET=latin1;