-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               5.5.41 - MySQL Community Server (GPL)
-- Server OS:                    Win64
-- HeidiSQL Version:             9.1.0.4867
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for world
CREATE DATABASE IF NOT EXISTS `world` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `world`;


-- Dumping structure for table world.playercreateinfo_spell_custom
CREATE TABLE IF NOT EXISTS `playercreateinfo_spell_custom` (
  `racemask` int(10) unsigned NOT NULL DEFAULT '0',
  `classmask` int(10) unsigned NOT NULL DEFAULT '0',
  `Spell` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `Note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`racemask`,`classmask`,`Spell`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping data for table world.playercreateinfo_spell_custom: 440 rows
/*!40000 ALTER TABLE `playercreateinfo_spell_custom` DISABLE KEYS */;
INSERT INTO `playercreateinfo_spell_custom` (`racemask`, `classmask`, `Spell`, `Note`) VALUES
	(0, 1, 196, 'One-Handed Axes'),
	(0, 8, 196, 'One-Handed Axes'),
	(0, 1, 198, 'One-Handed Maces'),
	(0, 8, 198, 'One-Handed Maces'),
	(0, 2, 198, 'One-Handed Maces'),
	(0, 64, 198, 'One-Handed Maces'),
	(0, 1024, 198, 'One-Handed Maces'),
	(0, 16, 198, 'One-Handed Maces'),
	(0, 16, 1180, 'Daggers'),
	(0, 8, 266, 'Guns'),
	(0, 1, 266, 'Guns'),
	(0, 1024, 1180, 'Daggers'),
	(0, 256, 1180, 'Daggers'),
	(0, 128, 1180, 'Daggers'),
	(0, 64, 1180, 'Daggers'),
	(0, 8, 1180, 'Daggers'),
	(0, 4, 1180, 'Daggers'),
	(0, 1, 1180, 'Daggers'),
	(0, 8, 5011, 'Crossbows'),
	(0, 1, 5011, 'Crossbows'),
	(0, 8, 3018, 'Shoot'),
	(0, 1, 3018, 'Shoot'),
	(0, 8, 264, 'Bows'),
	(0, 1, 264, 'Bows'),
	(0, 2, 1044, 'HoF'),
	(0, 2, 7294, 'Retri aura'),
	(0, 2, 62124, 'Hand of Reckoning'),
	(0, 2, 25780, 'Rightious Fury'),
	(0, 2, 31789, 'Righteous defense'),
	(0, 2, 19742, 'Blessing of Wisdom'),
	(0, 2, 53408, 'Judgement of the Wisdom'),
	(0, 2, 19834, 'Blessing of Might 2'),
	(0, 2, 647, 'Holy Light 3'),
	(0, 1024, 2637, 'Hibernate'),
	(0, 1024, 16857, 'Faerie Fire Feral'),
	(0, 1024, 770, 'Faerie Fire'),
	(0, 1024, 783, 'Travel Form'),
	(0, 1024, 779, 'Swipe'),
	(0, 1024, 1066, 'Aquatic Form'),
	(0, 1024, 8946, 'Cure Poison'),
	(0, 1024, 5211, 'Bash'),
	(0, 1024, 8938, 'Regrowth'),
	(0, 1024, 5229, 'Enrage'),
	(0, 1024, 6795, 'Growl'),
	(0, 1024, 5487, 'Bear Form'),
	(0, 1024, 16810, 'Nature Grasp'),
	(0, 1024, 1062, 'Roots'),
	(0, 1024, 782, 'Throns'),
	(0, 1024, 1430, 'Rejuvenation'),
	(0, 1024, 8925, 'Moonfire'),
	(0, 1024, 5187, 'HT'),
	(0, 1024, 5178, 'Warth'),
	(0, 64, 526, 'Cure Toxcins'),
	(0, 64, 2008, 'Ress Shaman'),
	(0, 64, 8143, 'Tremor'),
	(0, 64, 8154, 'Stone Skin Totem'),
	(0, 64, 3599, 'Searing Totem'),
	(0, 64, 2645, 'Ghost Wolf'),
	(0, 64, 57994, 'Wind Shear'),
	(0, 64, 370, 'Purge'),
	(0, 64, 1535, 'Fire Nova'),
	(0, 256, 5676, 'Searing Pain'),
	(0, 256, 1455, 'Drain Life'),
	(0, 256, 693, 'SS'),
	(0, 256, 5697, 'Uneinding breath'),
	(0, 256, 697, 'Summon Voidwalker'),
	(0, 256, 755, 'Health Funnel'),
	(0, 128, 2120, 'Flame strike'),
	(0, 128, 1008, 'Amplify Magic'),
	(0, 128, 604, 'Dampen Magic'),
	(0, 128, 475, 'Remove curse'),
	(0, 128, 130, 'Slow Fall'),
	(0, 128, 1449, 'Arcane Explosion'),
	(0, 8, 8647, 'Expose Armor'),
	(0, 8, 703, 'Garrote'),
	(0, 8, 8676, 'Ambush'),
	(0, 8, 1966, 'Feint'),
	(0, 8, 1766, 'Kick'),
	(0, 8, 674, 'Dual Wield'),
	(0, 16, 8122, 'Psychic Scream'),
	(0, 16, 528, 'Cure Disease'),
	(0, 16, 2054, 'Heal'),
	(0, 16, 527, 'Dispel Magic'),
	(0, 16, 588, 'Inner Fire'),
	(0, 4, 982, 'Revive Pet'),
	(0, 4, 1002, 'Eyes of the Beast'),
	(0, 4, 2974, 'Wingclip'),
	(0, 4, 13795, 'Immolation Trap'),
	(0, 4, 1495, 'Mongoose Bite'),
	(0, 4, 883, 'Call Pet'),
	(0, 4, 2643, 'Multi-shot'),
	(0, 4, 20736, 'Distracting shot'),
	(0, 512, 883, 'Call pet'),
	(0, 4, 1513, 'Scare Beast'),
	(0, 4, 2641, 'Dismiss Pet'),
	(0, 4, 6197, 'Eagle Eye'),
	(0, 4, 6991, 'Feed Pet'),
	(0, 4, 136, 'Mend Pet'),
	(0, 4, 19884, 'Track Undead'),
	(512, 0, 822, 'Magic resist'),
	(512, 8, 25046, 'Arcane Torrent Rogue'),
	(0, 4, 5118, 'Aspect of the Cheetah'),
	(0, 1, 676, NULL),
	(0, 1, 7386, 'Sunder Armor'),
	(0, 1, 355, 'Taunt'),
	(0, 1, 1160, 'Demoralizing Shout'),
	(0, 1, 6572, 'Revenge'),
	(0, 1, 694, 'Mocking Blow'),
	(0, 1, 2565, 'Shield Block'),
	(0, 1, 72, 'Shield Bash'),
	(1024, 2, 59542, 'Gift of the naaru (pala)'),
	(32, 0, 20550, 'Endurance'),
	(32, 0, 20549, 'War Stomp'),
	(0, 1, 71, 'Defensive Stance'),
	(0, 64, 8042, NULL),
	(0, 64, 332, NULL),
	(0, 64, 8017, NULL),
	(0, 64, 529, NULL),
	(0, 64, 8050, NULL),
	(0, 64, 8075, NULL),
	(0, 64, 5730, NULL),
	(0, 64, 324, NULL),
	(0, 64, 8018, NULL),
	(0, 64, 8044, NULL),
	(0, 64, 8024, NULL),
	(0, 64, 2484, NULL),
	(0, 8, 921, NULL),
	(0, 8, 1776, NULL),
	(0, 8, 1784, NULL),
	(0, 8, 53, NULL),
	(0, 8, 1757, NULL),
	(0, 8, 6760, NULL),
	(0, 1, 7384, 'Overpower'),
	(0, 8, 5277, NULL),
	(0, 8, 2983, NULL),
	(0, 8, 5171, NULL),
	(0, 8, 6770, NULL),
	(0, 4, 1494, NULL),
	(0, 4, 1978, NULL),
	(0, 4, 13163, NULL),
	(0, 4, 1130, NULL),
	(0, 4, 3044, NULL),
	(0, 4, 3127, NULL),
	(0, 4, 19883, NULL),
	(0, 4, 13549, NULL),
	(0, 4, 13165, NULL),
	(0, 4, 5116, NULL),
	(0, 4, 14260, NULL),
	(0, 16, 2052, NULL),
	(0, 256, 75445, 'Demonic Immolate'),
	(0, 64, 75461, 'Flame Shock Passive'),
	(0, 32, 56816, 'Rune Strike'),
	(1541, 2, 60091, 'Judgement Anti-Parry/Dodge Passive'),
	(0, 1, 3127, NULL),
	(0, 1, 772, NULL),
	(0, 1, 100, NULL),
	(0, 1, 6673, NULL),
	(0, 1, 6343, NULL),
	(0, 1, 34428, NULL),
	(0, 2, 3127, NULL),
	(0, 2, 633, NULL),
	(0, 2, 1022, NULL),
	(0, 1, 1715, NULL),
	(0, 1, 284, NULL),
	(0, 2, 465, NULL),
	(0, 2, 639, NULL),
	(0, 2, 10290, NULL),
	(0, 4, 5011, 'Crossbows'),
	(0, 2, 1152, NULL),
	(1024, 247, 29932, 'Language Draenei'),
	(0, 1, 2687, NULL),
	(0, 1, 6546, NULL),
	(0, 2, 498, 'Divine Protection'),
	(0, 1024, 8921, NULL),
	(0, 1024, 5177, NULL),
	(0, 2, 20271, 'Judgement of light'),
	(0, 1024, 774, NULL),
	(512, 446, 813, 'Language Thalassian'),
	(0, 1024, 99, NULL),
	(0, 1024, 5186, NULL),
	(0, 1024, 339, NULL),
	(0, 1024, 16689, NULL),
	(0, 1024, 1058, NULL),
	(0, 1024, 467, NULL),
	(0, 1024, 5232, NULL),
	(128, 253, 7341, 'Language Troll'),
	(0, 1024, 8924, NULL),
	(0, 128, 122, NULL),
	(0, 128, 118, NULL),
	(0, 128, 7300, NULL),
	(64, 425, 7340, 'Language Gnomish'),
	(0, 128, 587, NULL),
	(0, 128, 143, NULL),
	(0, 128, 116, NULL),
	(0, 128, 1459, NULL),
	(32, 1125, 670, 'Language Taurahe'),
	(0, 128, 5504, NULL),
	(0, 128, 2136, NULL),
	(16, 441, 17737, 'Language Gutterspeak'),
	(0, 128, 205, NULL),
	(0, 128, 5143, NULL),
	(0, 128, 5505, NULL),
	(40, 1024, 5185, 'Healing Touch'),
	(40, 1024, 5176, 'Wrath'),
	(0, 256, 1120, NULL),
	(0, 256, 6201, NULL),
	(0, 256, 980, NULL),
	(0, 256, 696, NULL),
	(8, 1085, 671, 'Language Darnassian'),
	(0, 4, 266, 'Guns'),
	(0, 256, 5782, NULL),
	(0, 256, 707, NULL),
	(0, 16, 2053, NULL),
	(0, 16, 586, NULL),
	(0, 16, 139, NULL),
	(4, 63, 672, 'Language Dwarven'),
	(0, 256, 1454, NULL),
	(0, 256, 695, NULL),
	(0, 64, 27763, 'Totem'),
	(0, 8, 2589, 'Backstab'),
	(0, 1, 5242, 'Battle Shout'),
	(0, 16, 594, NULL),
	(1710, 4, 34082, 'Advantaged State (DND)'),
	(1710, 4, 24949, 'Defensive State 2 (DND)'),
	(0, 16, 2006, NULL),
	(1710, 4, 13358, 'Defensive State (DND)'),
	(0, 4, 14261, 'Raptor Strike'),
	(0, 4, 264, 'Bows'),
	(1710, 4, 75, 'Auto Shot'),
	(0, 256, 688, NULL),
	(0, 256, 348, NULL),
	(0, 256, 172, NULL),
	(0, 256, 702, NULL),
	(690, 0, 669, 'Language Orcish'),
	(0, 1024, 1126, NULL),
	(0, 256, 687, 'Demon Skin'),
	(0, 256, 705, 'Shadow Bolt'),
	(0, 1488, 227, 'Staves'),
	(1745, 128, 168, 'Frost Armor'),
	(0, 128, 3140, 'Fireball'),
	(0, 32, 61455, 'Runic Focus'),
	(0, 32, 59921, 'Frost Fever'),
	(0, 32, 59879, 'Blood Plague'),
	(0, 32, 52665, 'Sigil'),
	(0, 32, 49576, 'Death Grip'),
	(0, 32, 49410, 'Forceful Deflection'),
	(0, 32, 48266, 'Blood Presence'),
	(0, 32, 47541, 'Death Coil'),
	(0, 32, 45903, 'Offensive State (DND)'),
	(0, 32, 45902, 'Blood Strike'),
	(0, 32, 45477, 'Icy Touch'),
	(0, 32, 45462, 'Plague Strike'),
	(0, 32, 33391, 'Journeyman Riding'),
	(0, 32, 18630, 'Heavy Runecloth Bandage'),
	(0, 32, 18629, 'Runecloth Bandage'),
	(0, 32, 10846, 'First Aid'),
	(0, 32, 10841, 'Heavy Mageweave Bandage'),
	(0, 32, 10840, 'Mageweave Bandage'),
	(0, 32, 7934, 'Anti-Venom'),
	(0, 32, 7929, 'Heavy Silk Bandage'),
	(0, 32, 7928, 'Silk Bandage'),
	(0, 32, 3278, 'Heavy Wool Bandage'),
	(0, 32, 3277, 'Wool Bandage'),
	(0, 32, 3276, 'Heavy Linen Bandage'),
	(0, 32, 3275, 'Linen Bandage'),
	(0, 32, 3127, 'Parry'),
	(0, 32, 750, 'Plate Mail'),
	(0, 35, 202, 'Two-Handed Swords'),
	(0, 32, 200, 'Polearms'),
	(0, 37, 197, 'Two-Handed Axes'),
	(0, 400, 5009, 'Shoot'),
	(0, 400, 5019, 'Wand Skill'),
	(1693, 16, 2050, 'Lesser Heal'),
	(1693, 16, 598, 'Smite'),
	(735, 8, 21184, 'Rogue Passive (DND)'),
	(735, 8, 16092, 'Defensive State (DND)'),
	(0, 9, 2764, 'Throw'),
	(0, 9, 2567, 'Thrown'),
	(0, 8, 1758, 'Sinister Strike'),
	(0, 8, 6761, 'Eviscerate'),
	(735, 1293, 1180, 'Daggers'),
	(1541, 2, 27762, 'Libram'),
	(1541, 2, 21084, 'Seal of Righteousness'),
	(1541, 2, 635, 'Holy Light'),
	(0, 3, 199, 'Two-Handed Maces'),
	(2, 0, 0, NULL),
	(0, 0, 61437, 'Opening'),
	(1, 443, 59752, 'Every Man for Himself'),
	(0, 16, 8092, NULL),
	(0, 0, 45927, 'Summon Friend'),
	(1279, 1, 32215, 'Victorious State'),
	(0, 0, 22810, 'Opening - No Text'),
	(0, 0, 22027, 'Remove Insignia'),
	(0, 0, 21652, 'Closing'),
	(0, 0, 21651, 'Opening'),
	(0, 16, 589, NULL),
	(0, 16, 1243, NULL),
	(0, 16, 17, NULL),
	(0, 16, 591, NULL),
	(0, 0, 9125, 'Generic'),
	(0, 67, 9116, 'Shield'),
	(0, 0, 9078, 'Cloth'),
	(0, 1135, 9077, 'Leather'),
	(0, 35, 8737, 'Mail'),
	(0, 0, 8386, 'Attacking'),
	(0, 0, 7355, 'Stuck'),
	(0, 0, 7267, 'Grovel'),
	(0, 0, 7266, 'Duel'),
	(0, 0, 6603, 'Attack'),
	(0, 0, 6478, 'Opening'),
	(0, 0, 6477, 'Opening'),
	(0, 0, 6247, 'Opening'),
	(0, 0, 6246, 'Closing'),
	(0, 0, 6233, 'Closing'),
	(1279, 1, 5301, 'Defensive State (DND)'),
	(0, 0, 3365, 'Opening'),
	(0, 0, 3050, 'Detect'),
	(0, 0, 2479, 'Honorless Target'),
	(1279, 1, 2457, 'Battle Stance'),
	(0, 0, 2382, 'Generic'),
	(0, 0, 1843, 'Disarm'),
	(1101, 0, 668, 'Language Common'),
	(0, 0, 522, 'SPELLDEFENSE (DND)'),
	(0, 0, 204, 'Defense'),
	(0, 0, 203, 'Unarmed'),
	(0, 39, 201, 'One-Handed Swords'),
	(0, 1107, 198, 'One-Handed Maces'),
	(0, 37, 196, 'One-Handed Axes'),
	(0, 67, 107, 'Block'),
	(0, 0, 81, 'Dodge'),
	(0, 1, 285, 'Heroic Strike'),
	(0, 2, 196, 'One-Handed Axes'),
	(0, 4, 196, 'One-Handed Axes'),
	(0, 64, 196, 'One-Handed Axes'),
	(0, 8, 2567, 'Thrown'),
	(0, 1, 2567, 'Thrown'),
	(0, 8, 2764, 'Throw'),
	(0, 1, 2764, 'Throw'),
	(0, 1, 227, 'Staves'),
	(0, 4, 227, 'Staves'),
	(0, 256, 227, 'Staves'),
	(0, 128, 227, 'Staves'),
	(0, 16, 227, 'Staves'),
	(0, 64, 227, 'Staves'),
	(0, 1024, 227, 'Staves'),
	(0, 1, 201, 'One-Handed Swords'),
	(0, 2, 201, 'One-Handed Swords'),
	(0, 4, 201, 'One-Handed Swords'),
	(0, 8, 201, 'One-Handed Swords'),
	(0, 128, 201, 'One-Handed Swords'),
	(0, 256, 201, 'One-Handed Swords'),
	(0, 1, 197, 'Two-Handed Axes'),
	(0, 2, 197, 'Two-Handed Axes'),
	(0, 4, 197, 'Two-Handed Axes'),
	(0, 64, 197, 'Two-Handed Axes'),
	(0, 1, 199, 'Two-Handed Maces'),
	(0, 2, 199, 'Two-Handed Maces'),
	(0, 64, 199, 'Two-Handed Maces'),
	(0, 1024, 199, 'Two-Handed Maces'),
	(0, 1, 202, 'Two-Handed Swords'),
	(0, 2, 202, 'Two-Handed Swords'),
	(0, 4, 202, 'Two-Handed Swords'),
	(0, 16, 5019, 'Wands'),
	(0, 128, 5019, 'Wands'),
	(0, 256, 5019, 'Wands'),
	(1, 0, 20864, 'Mace specialistation'),
	(1, 0, 58985, 'Perception'),
	(1, 0, 20597, 'Sword Specialisation'),
	(1, 0, 20598, 'The Human Spirit'),
	(4, 0, 20594, 'Stoneform'),
	(4, 0, 20864, 'Mace Specialisation'),
	(4, 0, 20595, 'Gun Special'),
	(4, 0, 20596, 'Frost Resist'),
	(16, 0, 20577, 'Cannibalize'),
	(16, 0, 20579, 'Shadow Resist'),
	(16, 0, 5227, 'Underwater Breathing'),
	(16, 0, 7744, 'Will of the Forsaken'),
	(64, 0, 20592, 'Arcane Resist'),
	(64, 0, 20593, 'Engineering Specialization'),
	(64, 0, 20589, 'Escape Artist'),
	(2, 0, 20574, 'Axes Specialization'),
	(128, 0, 26297, 'Berserking'),
	(8, 0, 58984, 'Shadowmeld'),
	(2, 64, 33697, 'Blood Fury'),
	(2, 0, 20575, 'Command'),
	(2, 0, 20573, 'Hardiness'),
	(128, 0, 20557, 'Beast Slaying'),
	(128, 0, 26290, 'Bow Special'),
	(128, 0, 58943, 'Vodo Shuffle'),
	(128, 0, 20555, 'Regen'),
	(128, 0, 20558, 'Throwing Special'),
	(8, 0, 21009, 'Elusiveness'),
	(8, 0, 20551, 'Nature Resist'),
	(8, 0, 20582, 'Quickness'),
	(8, 0, 20585, 'Wisp Spirit'),
	(1024, 4, 59543, 'Gift of the naaru (hunter)'),
	(0, 256, 6222, 'Corruption'),
	(0, 256, 1014, 'Cruse of Agony'),
	(0, 256, 1108, 'Curse of Weakness'),
	(0, 128, 1460, 'Arcane Intellect'),
	(0, 128, 5144, 'Arcane Missles'),
	(0, 128, 597, 'Conjure Food'),
	(0, 128, 2137, 'Fire Blast'),
	(0, 128, 837, 'Frostbolt'),
	(0, 16, 1244, 'Power Word: Fortitude'),
	(0, 16, 600, 'Power Word: Shield'),
	(0, 16, 6074, 'Renew'),
	(0, 16, 8102, 'Mind Blast'),
	(0, 16, 970, 'Shadow Word: Pain'),
	(0, 64, 8045, 'Earth Shock'),
	(0, 64, 8052, 'Flame Shock'),
	(0, 64, 548, 'Lightning Bolt'),
	(0, 64, 8027, 'Flametongue Weapon'),
	(0, 64, 8019, 'Rockbiter Weapon'),
	(0, 64, 325, 'Lightning Shield'),
	(0, 64, 913, 'Healing Wave'),
	(0, 64, 6390, 'Stoneclaw Totem'),
	(0, 1, 8198, 'Thunder Clap'),
	(0, 4, 13550, 'Serpent Sting'),
	(0, 4, 14281, 'Arcane Shot'),
	(0, 4, 14318, 'Aspect of the Hawk'),
	(0, 256, 689, 'Drain life R1'),
	(0, 4, 3018, 'Shoot'),
	(0, 4, 2764, 'Throw'),
	(0, 8, 3127, 'Parry'),
	(0, 2, 853, 'Hammer of Justice'),
	(512, 2, 28730, 'Arcane Torrent Caster'),
	(512, 4, 28730, 'Arcane Torrent Caster'),
	(512, 16, 28730, 'Arcane Torrent Caster'),
	(512, 128, 28730, 'Arcane Torrent Caster'),
	(512, 256, 28730, 'Arcane Torrent Caster'),
	(1024, 1, 28880, 'Gift of the naaru (warr)'),
	(0, 1024, 6808, 'Maul'),
	(0, 1024, 50769, 'Revive'),
	(0, 2, 7328, 'Redemption'),
	(1024, 64, 59547, 'Gift of the naaru (shaman)'),
	(1024, 16, 59544, 'Gift of the naaru (priest)'),
	(1024, 128, 59548, 'Gift of the naaru (mage)'),
	(2, 384, 33702, 'Blood Fury'),
	(2, 13, 20572, 'Blood Fury');
/*!40000 ALTER TABLE `playercreateinfo_spell_custom` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;