Weapon/Armor Skills

/*  CREATED BY: Parranoia
 *  ID     RACE
 *-------------------
 *  1   |  Human
 *  2   |  Orc
 *  3   |  Dwarf
 *  4   |  Night Elf
 *  5   |  Undead
 *  6   |  Tauren
 *  7   |  Gnome
 *  8   |  Troll
 *  10  |  Blood Elf
 *  11  |  Draenei
 */


DELETE FROM `playercreateinfo_spell` WHERE `Note` IN('Polearms', 'Swords', 'Daggers', 'Two-Handed Axes', 'One-Handed Axes', 'Two-Handed Swords', 'Two-Handed Maces', 'Maces', 'Thrown', 'Throw', 'Bows', 'Guns', 'Axes', 'Polearms', 'Fist Weapons', 'Crossbows', 'Mail Armor', 'Plate Armor', 'Staves', 'Dual-Wield');

-- Warrior Spells
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 1, 201,'Swords'),
(0, 1, 1180,'Daggers'),
(0, 1, 197,'Two-Handed Axes'),
(0, 1, 199,'Two-Handed Maces'),
(0, 1, 202,'Two-Handed Swords'),
(0, 1, 198,'Maces'),
(0, 1, 196,'Axes'),
(0, 1, 200,'Polearms'),
(0, 1, 2567,'Thrown'),
(0, 1, 2764,'Throw'),
(0, 1, 264,'Bows'),
(0, 1, 266,'Guns'),
(0, 1, 5011,'Crossbows'),
(0, 1, 15590,'Fist Weapons'),
(0, 1, 227,'Staves'),
(0, 1, 674, 'Dual-Wield'),
(0, 1, 750, 'Plate Armor');

-- Paladin Spells
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 2, 200,'Polearms'),
(0, 2, 198,'Maces'),
(0, 2, 201,'Swords'),
(0, 2, 202,'Two-Handed Swords'),
(0, 2, 197,'Two-Handed Axes'),
(0, 2, 199,'Two-Handed Maces'),
(0, 2, 196,'Axes'),
(0, 2, 750, 'Plate Armor');

-- Hunter Spells
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 3, 200,'Polearms'),
(0, 3, 196, 'One-Handed Axes'),
(0, 3, 674, 'Dual-Wield'),
(0, 3, 15590, 'Fist Weapons'),
(0, 3, 2767, 'Thrown'),
(0, 3, 2764, 'Throw'),
(0, 3, 264,'Bows'),
(0, 3, 266,'Guns'),
(0, 3, 5011,'Crossbows'),
(0, 3, 201,'Swords'),
(0, 3, 227,'Staves'),
(0, 3, 202,'Two-Handed Swords'),
(0, 3, 197,'Two-Handed Axes'),
(0, 3, 1180,'Daggers'),
(0, 3, 8737, 'Mail Armor');

-- Rogue Spells
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 4, 1180,'Daggers'),
(0, 4, 2567,'Thrown'),
(0, 4, 2764,'Throw'),
(0, 4, 201,'Swords'),
(0, 4, 198,'Maces'),
(0, 4, 196,'Axes'),
(0, 4, 264,'Bows'),
(0, 4, 266,'Guns'),
(0, 4, 5011,'Crossbows'),
(0, 4, 15590,'Fist Weapons');

-- Priest
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 5, 1180,'Daggers'),
(0, 5, 198,'Maces'),
(0, 5, 227,'Staves');

-- Death Knight
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 6, 199,'Two-Handed Maces'),
(0, 6, 198,'One-Handed Maces');

-- Shaman
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 7, 1180, 'Daggers'),
(0, 7, 227,'Staves'),
(0, 7, 198,'Maces'),
(0, 7, 199,'Two-Handed Maces'),
(0, 7, 196,'Axes'),
(0, 7, 197,'Two-Handed Axes'),
(0, 7, 15590,'Fist Weapons'),
(0, 7, 8737, 'Mail Armor');

-- Mage Spells
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 8, 1180,'Daggers'),
(0, 8, 201,'Swords'),
(0, 8, 227,'Staves');

-- Warlock
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 9, 1180,'Daggers'),
(0, 9, 201,'Swords'),
(0, 9, 227,'Staves');

-- Druid
INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES
(0, 11, 198,'Maces'),
(0, 11, 199,'Two-Handed Maces'),
(0, 11, 227,'Staves'),
(0, 11, 200,'Polearms');