DROP TABLE IF EXISTS `skill_extra_item_template`; CREATE TABLE `skill_extra_item_template` ( `spellId` int(11) unsigned NOT NULL default '0' COMMENT 'SpellId of the item creation spell', `requiredSpecialization` int(11) unsigned NOT NULL default '0' COMMENT 'Specialization spell id', `additionalCreateChance` float NOT NULL default '0' COMMENT 'chance to create add', `additionalMaxNum` int(11) unsigned NOT NULL default '0' COMMENT 'max num of adds', PRIMARY KEY (`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System'; insert into `skill_extra_item_template`(`spellId`,`requiredSpecialization`,`additionalCreateChance`,`additionalMaxNum`) values (26751,26798,100,1),(36686,26801,100,1),(31373,26797,100,1),(32765,28672,16,4),(29688,28672,16,4),(32766,28672,16,4),(17559,28672,16,4),(17187,28672,16,4),(17566,28672,16,4),(17561,28672,16,4),(17560,28672,16,4),(11479,28672,16,4),(17565,28672,16,4),(11480,28672,16,4),(28566,28672,16,4),(28585,28672,16,4),(28567,28672,16,4),(28568,28672,16,4),(28583,28672,16,4),(28584,28672,16,4),(28582,28672,16,4),(28580,28672,16,4),(28569,28672,16,4),(28581,28672,16,4),(17563,28672,16,4),(17562,28672,16,4),(17564,28672,16,4),(25146,28672,16,4),(42736,28677,14,4),(28578,28677,14,4),(28590,28677,14,4),(28587,28677,14,4),(28588,28677,14,4),(28591,28677,14,4),(28589,28677,14,4),(28570,28677,14,4),(28558,28677,14,4),(28557,28677,14,4),(28556,28677,14,4),(38960,28677,14,4),(39639,28677,14,4),(28553,28677,14,4),(28552,28677,14,4),(39637,28677,14,4),(39638,28677,14,4),(28549,28677,14,4),(33741,28677,14,4),(28545,28677,14,4),(39636,28677,14,4),(28543,28677,14,4),(28544,28677,14,4),(33740,28677,14,4),(17638,28677,14,4),(17636,28677,14,4),(17634,28677,14,4),(17637,28677,14,4),(17635,28677,14,4),(33738,28677,14,4),(24368,28677,14,4),(17573,28677,14,4),(17571,28677,14,4),(17557,28677,14,4),(24365,28677,14,4),(17555,28677,14,4),(17554,28677,14,4),(11477,28677,14,4),(11478,28677,14,4),(26277,28677,14,4),(11476,28677,14,4),(11472,28677,14,4),(11468,28677,14,4),(11467,28677,14,4),(11466,28677,14,4),(11461,28677,14,4),(11465,28677,14,4),(11460,28677,14,4),(22808,28677,14,4),(12609,28677,14,4),(3453,28677,14,4),(11450,28677,14,4),(21923,28677,14,4),(11449,28677,14,4),(3451,28677,14,4),(3450,28677,14,4),(3188,28677,14,4),(7845,28677,14,4),(2333,28677,14,4),(3177,28677,14,4),(3176,28677,14,4),(8240,28677,14,4),(7179,28677,14,4),(3171,28677,14,4),(3230,28677,14,4),(2334,28677,14,4),(3170,28677,14,4),(2329,28677,14,4),(7183,28677,14,4),(28579,28675,14,4),(38961,28675,14,4),(28575,28675,14,4),(28571,28675,14,4),(28572,28675,14,4),(28577,28675,14,4),(28573,28675,14,4),(28576,28675,14,4),(28586,28675,14,4),(28565,28675,14,4),(28564,28675,14,4),(28563,28675,14,4),(28562,28675,14,4),(38962,28675,14,4),(28555,28675,14,4),(28554,28675,14,4),(45061,28675,14,4),(28550,28675,14,4),(28546,28675,14,4),(33733,28675,14,4),(22732,28675,14,4),(33732,28675,14,4),(17580,28675,14,4),(17577,28675,14,4),(17574,28675,14,4),(17575,28675,14,4),(17576,28675,14,4),(17578,28675,14,4),(24367,28675,14,4),(17572,28675,14,4),(11452,28675,14,4),(17570,28675,14,4),(24366,28675,14,4),(17552,28675,14,4),(3175,28675,14,4),(11464,28675,14,4),(15833,28675,14,4),(11458,28675,14,4),(4942,28675,14,4),(11457,28675,14,4),(11453,28675,14,4),(11448,28675,14,4),(7258,28675,14,4),(7259,28675,14,4),(6618,28675,14,4),(7257,28675,14,4),(3448,28675,14,4),(3452,28675,14,4),(7181,28675,14,4),(6624,28675,14,4),(7256,28675,14,4),(3173,28675,14,4),(3174,28675,14,4),(3447,28675,14,4),(3172,28675,14,4),(7255,28675,14,4),(7841,28675,14,4),(6617,28675,14,4),(2335,28675,14,4),(2337,28675,14,4),(4508,28675,14,4),(2332,28675,14,4),(2331,28675,14,4);