1 DROP TABLE IF EXISTS `spell_learn_skill`;
2 CREATE TABLE `spell_learn_skill` (
3 `entry` smallint(6) unsigned NOT NULL default '0',
4 `SkillID` smallint(6) NOT NULL default '0',
5 `Value` int(11) default '0',
6 `MaxValue` int(11) default '0',
8 UNIQUE KEY spell_skill(`entry`,`SkillID`)
9 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
11 INSERT INTO `spell_learn_skill` VALUES
12 /*================== Armor ============*/
13 /*Cloth */( 9078,415, 1, 1),
14 /*Leather */( 9077,414, 1, 1),
15 /*Mail */( 8737,413, 1, 1),
16 /*Plate Mail */( 750,293, 1, 1),
17 /*Shield */( 9116,433, 1, 1),
18 /*================== Melee Weapons ====*/
19 /*Axes */( 196, 44, 1, 0),
20 /*Two-Handed Axes */( 197,172, 1, 0),
21 /*Staves */( 227,136, 1, 0),
22 /*Maces */( 198, 54, 1, 0),
23 /*Two-Handed Maces */( 199,160, 1, 0),
24 /*Swords */( 201, 43, 1, 0),
25 /*Two-Handed Swords*/( 202, 55, 1, 0),
26 /*Daggers */( 1180,173, 1, 0),
27 /*Fist Weapons */(15590,473, 1, 0),
28 /*Polearms */( 200,229, 1, 0),
29 /*Spears (Polearms)*/( 3386,229, 1, 0),
30 /*================== Range Weapons ====*/
31 /*Bows */( 264, 45, 1, 0),
32 /*Crossbows */( 5011,226, 1, 0),
33 /*Guns */( 266, 46, 1, 0),
34 /*Thrown */( 2567,176, 1, 0),
35 /*Wands */( 5009,228, 1, 0),
36 /*================== Others ===========*/
37 /*Poisons */( 2842, 40, 1, 0),
38 /*Min riding */(33388,762, 75, 75),
39 /*Mid riding */(33391,762,150,150),
40 /*Pick Lock(Rogue) */( 1804,633, 1, 0),
41 /*================== Languages ========*/
55 /*================== Generic Skills ===*/
56 /*Defense */( 204, 95, 1, 0),
57 /*Unarmed */( 203,162, 1, 0);