sql/updates/0.7/3310_spell_learn_spell.sql

   1 DROP TABLE IF EXISTS `spell_learn_spell`;
   2 CREATE TABLE `spell_learn_spell` (
   3   `entry` smallint(6) unsigned NOT NULL default '0',
   4   `SpellID` smallint(6) unsigned NOT NULL default '0',
   5   `IfNoSpell` smallint(6) unsigned NOT NULL default '0',
   6   PRIMARY KEY (`entry`,`SpellID`)
   7 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
   8
   9 INSERT INTO `spell_learn_spell` VALUES
  10 /*SKILL_ENGINERING*/
  11 (4036,3918,0),
  12 (4036,3919,0),
  13 (4036,3920,0),
  14 /*SKILL_TAILORING*/
  15 (3908,2387,0),
  16 (3908,2963,0),
  17 /*SKILL_ENCHANTING*/
  18 (7411,7418,0),
  19 (7411,7421,0),
  20 (7411,13262,0),
  21 /*SKILL_ALCHEMY*/
  22 (2259,2329,0),
  23 (2259,7183,0),
  24 (2259,2330,0),
  25 /*SKILL_BLACKSMITHING*/
  26 (2018,2663,0),
  27 (2018,12260,0),
  28 (2018,2660,0),
  29 (2018,3115,0),
  30 /*SKILL_LEATHERWORKING*/
  31 (2108,2152,0),
  32 (2108,9058,0),
  33 (2108,9059,0),
  34 (2108,2149,0),
  35 (2108,7126,0),
  36 (2108,2881,0),
  37 /*SKILL_COOKING*/
  38 (2550,818,0),
  39 (2550,2540,0),
  40 (2550,2538,0),
  41 (2550,8604,0),
  42 /*SKILL_FIRST_AID*/
  43 (3273,3275,0),
  44 /*SKILL_FISHING*/
  45 (7620,7738,0),
  46 /*SKILL_MINING*/
  47 (2575,2580,0),
  48 (2575,2656,0),
  49 (2575,2657,0),
  50 /*SKILL_HERBALISM*/
  51 (2366,2383,0),
  52 /*SKILL_BOWS*/
  53 (264,2480,75),
  54 /*SKILL_GUNS*/
  55 (266,7918,75),
  56 /*SKILL_CROSSBOWS*/
  57 (5011,7919,75),
  58 /*SKILL_THROWN*/
  59 (2567,2764,0),
  60 /*SKILL_POISONS*/
  61 (2842,8681,0);