Starting skills

DELETE FROM `playercreateinfo_spell_custom` 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_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 1, 201,'Swords'),
(0, 1, 173,'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_custom` (`racemask`, `classmask`, `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_custom` (`racemask`, `classmask`, `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, 173,'Daggers'),
(0, 3, 1579, 'Tame-Beast'),
(0, 3, 53270, 'Beast Mastery'),
(0, 3, 8737, 'Mail Armor');

-- Rogue Spells
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 4, 173,'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, 674, 'Dual-Wield'),
(0, 4, 15590,'Fist Weapons');

-- Priest
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 5, 173,'Daggers'),
(0, 5, 198,'Maces'),
(0, 5, 227,'Staves');

-- Death Knight
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 6, 199,'Two-Handed Maces'),
(0, 6, 201,'Swords'),
(0, 6, 197,'Two-Handed Axes'),
(0, 6, 202,'Two-Handed Swords'),
(0, 6, 196,'Axes'),
(0, 6, 200,'Polearms'),
(0, 6, 198,'One-Handed Maces');

-- Shaman
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 7, 173, '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, 674, 'Dual-Wield'),
(0, 7, 8737, 'Mail Armor');

-- Mage Spells
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 8, 173,'Daggers'),
(0, 8, 201,'Swords'),
(0, 8, 227,'Staves');

-- Warlock
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 9, 173,'Daggers'),
(0, 9, 201,'Swords'),
(0, 9, 227,'Staves');

-- Druid
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 11, 198,'Maces'),
(0, 11, 227,'Staves'),
(0, 11, 674, 'Dual-Wield'),
(0, 11, 197,'Two-Handed Axes'),
(0, 11, 199,'Two-Handed Maces'),
(0, 11, 202,'Two-Handed Swords'),
(0, 11, 200,'Polearms');
-- ALL Flying&Riding
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
(0, 0, 34091,'Artisan Riding'),
(0, 0, 54197,'Cold Weather Flying');