Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
12/12/2014 - Current dump of my wow professions_enchanting table. Allows you to associate the effectid to the spellid/itemid/slot/enchant name.
-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 12, 2014 at 07:20 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.15
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
-- --------------------------------------------------------
--
-- Table structure for table `professions_enchanting`
--
CREATE TABLE IF NOT EXISTS `professions_enchanting` (
`effectid` int(10) NOT NULL,
`spellid` int(10) NOT NULL,
`itemid` int(10) NOT NULL,
`slot` varchar(40) DEFAULT NULL,
`enchant` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `professions_enchanting`
--
INSERT INTO `professions_enchanting` (`effectid`, `spellid`, `itemid`, `slot`, `enchant`) VALUES
(4720, 7418, 38679, 'Bracer', 'Minor Health'),
(41, 7420, 38766, 'Chest', 'Minor Health'),
(44, 7426, 38767, 'Chest', 'Minor Absorption'),
(924, 7428, 38768, 'Bracer', 'Minor Dodge'),
(24, 7443, 38769, 'Chest', 'Minor Mana'),
(4721, 7457, 38771, 'Bracer', 'Minor Stamina'),
(4723, 7745, 38772, '2H Weapon', 'Minor Impact'),
(242, 7748, 38773, 'Chest', 'Lesser Health'),
(243, 7766, 38774, 'Bracer', 'Minor Spirit'),
(783, 7771, 38775, 'Cloak', 'Minor Protection'),
(246, 7776, 38776, 'Chest', 'Lesser Mana'),
(4725, 7779, 38777, 'Bracer', 'Minor Agility'),
(248, 7782, 38778, 'Bracer', 'Minor Strength'),
(249, 7786, 38779, 'Weapon', 'Minor Beastslayer'),
(250, 7788, 38780, 'Weapon', 'Minor Striking'),
(723, 7793, 38781, '2H Weapon', 'Lesser Intellect'),
(254, 7857, 38782, 'Chest', 'Health'),
(4727, 7859, 38783, 'Bracer', 'Lesser Spirit'),
(66, 7863, 38785, 'Boots', 'Minor Stamina'),
(247, 7867, 38786, 'Boots', 'Minor Agility'),
(4722, 13378, 38787, 'Shield', 'Minor Stamina'),
(255, 13380, 38788, '2H Weapon', 'Lesser Spirit'),
(4724, 13419, 38789, 'Cloak', 'Minor Agility'),
(744, 13421, 38790, 'Cloak', 'Lesser Protection'),
(4733, 13464, 38791, 'Shield', 'Lesser Protection'),
(4728, 13485, 38792, 'Shield', 'Lesser Spirit'),
(4730, 13501, 38793, 'Bracer', 'Lesser Stamina'),
(241, 13503, 38794, 'Weapon', 'Lesser Striking'),
(943, 13529, 38796, '2H Weapon', 'Lesser Impact'),
(823, 13536, 38797, 'Bracer', 'Lesser Strength'),
(63, 13538, 38798, 'Chest', 'Lesser Absorption'),
(843, 13607, 38799, 'Chest', 'Mana'),
(844, 13612, 38800, 'Gloves', 'Mining'),
(845, 13617, 38801, 'Gloves', 'Herbalism'),
(2603, 13620, 38802, 'Gloves', 'Fishing'),
(4729, 13622, 38803, 'Bracer', 'Lesser Intellect'),
(847, 13626, 38804, 'Chest', 'Minor Stats'),
(4731, 13631, 38805, 'Shield', 'Lesser Stamina'),
(848, 13635, 38806, 'Cloak', 'Defense'),
(849, 13637, 38807, 'Boots', 'Lesser Agility'),
(850, 13640, 38808, 'Chest', 'Greater Health'),
(4735, 13642, 38809, 'Bracer', 'Spirit'),
(724, 13644, 38810, 'Boots', 'Lesser Stamina'),
(925, 13646, 38811, 'Bracer', 'Lesser Dodge'),
(4737, 13648, 38812, 'Bracer', 'Stamina'),
(853, 13653, 38813, 'Weapon', 'Lesser Beastslayer'),
(854, 13655, 38814, 'Weapon', 'Lesser Elemental Slayer'),
(4736, 13659, 38816, 'Shield', 'Spirit'),
(856, 13661, 38817, 'Bracer', 'Strength'),
(857, 13663, 38818, 'Chest', 'Greater Mana'),
(4726, 13687, 38819, 'Boots', 'Lesser Spirit'),
(863, 13689, 38820, 'Shield', 'Lesser Parry'),
(4745, 13693, 38821, 'Weapon', 'Striking'),
(1897, 13695, 38822, '2H Weapon', 'Impact'),
(865, 13698, 38823, 'Gloves', 'Skinning'),
(866, 13700, 38824, 'Chest', 'Lesser Stats'),
(884, 13746, 38825, 'Cloak', 'Greater Defense'),
(4740, 13815, 38827, 'Gloves', 'Agility'),
(4738, 13817, 38828, 'Shield', 'Stamina'),
(905, 13822, 38829, 'Bracer', 'Intellect'),
(852, 13836, 38830, 'Boots', 'Stamina'),
(906, 13841, 38831, 'Gloves', 'Advanced Mining'),
(907, 13846, 38832, 'Bracer', 'Greater Spirit'),
(908, 13858, 38833, 'Chest', 'Superior Health'),
(909, 13868, 38834, 'Gloves', 'Advanced Herbalism'),
(4734, 13882, 38835, 'Cloak', 'Lesser Agility'),
(4739, 13887, 38836, 'Gloves', 'Strength'),
(911, 13890, 38837, 'Boots', 'Minor Speed'),
(803, 13898, 38838, 'Weapon', 'Fiery Weapon'),
(4741, 13905, 38839, 'Shield', 'Greater Spirit'),
(912, 13915, 38840, 'Weapon', 'Demonslaying'),
(913, 13917, 38841, 'Chest', 'Superior Mana'),
(923, 13931, 38842, 'Bracer', 'Dodge'),
(904, 13935, 38844, 'Boots', 'Agility'),
(963, 13937, 38845, '2H Weapon', 'Greater Impact'),
(927, 13939, 38846, 'Bracer', 'Greater Strength'),
(928, 13941, 38847, 'Chest', 'Stats'),
(805, 13943, 38848, 'Weapon', 'Greater Striking'),
(4743, 13945, 38849, 'Bracer', 'Greater Stamina'),
(930, 13947, 38850, 'Gloves', 'Riding Skill'),
(931, 13948, 38851, 'Gloves', 'Minor Haste'),
(1883, 20008, 38852, 'Bracer', 'Greater Intellect'),
(1884, 20009, 38853, 'Bracer', 'Superior Spirit'),
(1885, 20010, 38854, 'Bracer', 'Superior Strength'),
(1886, 20011, 38855, 'Bracer', 'Superior Stamina'),
(1887, 20012, 38856, 'Gloves', 'Greater Agility'),
(4742, 20013, 38857, 'Gloves', 'Greater Strength'),
(1889, 20015, 38859, 'Cloak', 'Superior Defense'),
(1890, 20016, 38860, 'Shield', 'Vitality'),
(4744, 20017, 38861, 'Shield', 'Greater Stamina'),
(929, 20020, 38862, 'Boots', 'Greater Stamina'),
(1887, 20023, 38863, 'Boots', 'Greater Agility'),
(851, 20024, 38864, 'Boots', 'Spirit'),
(1891, 20025, 38865, 'Chest', 'Greater Stats'),
(1892, 20026, 38866, 'Chest', 'Major Health'),
(1893, 20028, 38867, 'Chest', 'Major Mana'),
(1894, 20029, 38868, 'Weapon', 'Icy Chill'),
(1896, 20030, 38869, '2H Weapon', 'Superior Impact'),
(1897, 20031, 38870, 'Weapon', 'Superior Striking'),
(1898, 20032, 38871, 'Weapon', 'Lifestealing'),
(1899, 20033, 38872, 'Weapon', 'Unholy Weapon'),
(1900, 20034, 38873, 'Weapon', 'Crusader'),
(1903, 20035, 38874, '2H Weapon', 'Major Spirit'),
(1904, 20036, 38875, '2H Weapon', 'Major Intellect'),
(2443, 21931, 38876, 'Weapon', 'Winter''s Might'),
(2504, 22749, 38877, 'Weapon', 'Spellpower'),
(2505, 22750, 38878, 'Weapon', 'Healing Power'),
(2563, 23799, 38879, 'Weapon', 'Strength'),
(2564, 23800, 38880, 'Weapon', 'Agility'),
(2565, 23801, 38881, 'Bracer', 'Mana Regeneration'),
(2650, 23802, 38882, 'Bracer', 'Healing Power'),
(2567, 23803, 38883, 'Weapon', 'Mighty Spirit'),
(2568, 23804, 38884, 'Weapon', 'Mighty Intellect'),
(2613, 25072, 38885, 'Gloves', 'Threat'),
(2614, 25073, 38886, 'Gloves', 'Shadow Power'),
(2615, 25074, 38887, 'Gloves', 'Frost Power'),
(2616, 25078, 38888, 'Gloves', 'Fire Power'),
(2617, 25079, 38889, 'Gloves', 'Healing Power'),
(2564, 25080, 38890, 'Gloves', 'Superior Agility'),
(910, 25083, 38893, 'Cloak', 'Stealth'),
(2621, 25084, 38894, 'Cloak', 'Subtlety'),
(2622, 25086, 38895, 'Cloak', 'Dodge'),
(2646, 27837, 38896, '2H Weapon', 'Agility'),
(2647, 27899, 38897, 'Bracer', 'Brawn'),
(1891, 27905, 38898, 'Bracer', 'Stats'),
(2648, 27906, 38899, 'Bracer', 'Greater Dodge'),
(5183, 27911, 38900, 'Bracer', 'Superior Healing'),
(2679, 27913, 38901, 'Bracer', 'Restore Mana Prime'),
(2649, 27914, 38902, 'Bracer', 'Fortitude'),
(5184, 27917, 38903, 'Bracer', 'Spellpower'),
(2653, 27944, 38904, 'Shield', 'Lesser Dodge'),
(2654, 27945, 38905, 'Shield', 'Intellect'),
(2655, 27946, 38906, 'Shield', 'Parry'),
(2656, 27948, 38908, 'Boots', 'Vitality'),
(2649, 27950, 38909, 'Boots', 'Fortitude'),
(2657, 27951, 37603, 'Boots', 'Dexterity'),
(2658, 27954, 38910, 'Boots', 'Surefooted'),
(2659, 27957, 38911, 'Chest', 'Exceptional Health'),
(3233, 27958, 38912, 'Chest', 'Exceptional Mana'),
(2661, 27960, 38913, 'Chest', 'Exceptional Stats'),
(2662, 27961, 38914, 'Cloak', 'Major Armor'),
(4746, 27967, 38917, 'Weapon', 'Major Striking'),
(2666, 27968, 38918, 'Weapon', 'Major Intellect'),
(2667, 27971, 38919, '2H Weapon', 'Savagery'),
(2668, 27972, 38920, 'Weapon', 'Potency'),
(2669, 27975, 38921, 'Weapon', 'Major Spellpower'),
(2670, 27977, 38922, '2H Weapon', 'Major Agility'),
(2671, 27981, 38923, 'Weapon', 'Sunfire'),
(2672, 27982, 38924, 'Weapon', 'Soulfrost'),
(2673, 27984, 38925, 'Weapon', 'Mongoose'),
(2674, 28003, 38926, 'Weapon', 'Spellsurge'),
(2675, 28004, 38927, 'Weapon', 'Battlemaster'),
(5237, 33990, 38928, 'Chest', 'Major Spirit'),
(3150, 33991, 38929, 'Chest', 'Restore Mana Prime'),
(2933, 33992, 38930, 'Chest', 'Major Resilience'),
(2934, 33993, 38931, 'Gloves', 'Blasting'),
(2935, 33994, 38932, 'Gloves', 'Precise Strikes'),
(5250, 33995, 38933, 'Gloves', 'Major Strength'),
(5255, 33996, 38934, 'Gloves', 'Assault'),
(2937, 33997, 38935, 'Gloves', 'Major Spellpower'),
(2322, 33999, 38936, 'Gloves', 'Major Healing'),
(369, 34001, 38937, 'Bracer', 'Major Intellect'),
(5257, 34002, 38938, 'Bracer', 'Lesser Assault'),
(2938, 34003, 38939, 'Cloak', 'PvP Power'),
(5258, 34004, 38940, 'Cloak', 'Greater Agility'),
(2939, 34007, 38943, 'Boots', 'Cat''s Swiftness'),
(2940, 34008, 38944, 'Boots', 'Boar''s Speed'),
(1071, 34009, 38945, 'Shield', 'Major Stamina'),
(3846, 34010, 38946, 'Weapon', 'Major Healing'),
(3222, 42620, 38947, 'Weapon', 'Greater Agility'),
(3225, 42974, 38948, 'Weapon', 'Executioner'),
(3229, 44383, 38949, 'Shield', 'Resilience'),
(3231, 44484, 38951, 'Gloves', 'Haste'),
(3234, 44488, 38953, 'Gloves', 'Precision'),
(1952, 44489, 38954, 'Shield', 'Dodge'),
(3236, 44492, 38955, 'Chest', 'Mighty Health'),
(4747, 44500, 38959, 'Cloak', 'Superior Agility'),
(3238, 44506, 38960, 'Gloves', 'Gatherer'),
(1147, 44508, 38961, 'Boots', 'Greater Spirit'),
(2381, 44509, 38962, 'Chest', 'Greater Mana Restoration'),
(3844, 44510, 38963, 'Weapon', 'Exceptional Spirit'),
(3829, 44513, 38964, 'Gloves', 'Greater Assault'),
(3239, 44524, 38965, 'Weapon', 'Icebreaker'),
(1075, 44528, 38966, 'Boots', 'Greater Fortitude'),
(5259, 44529, 38967, 'Gloves', 'Major Agility'),
(1119, 44555, 38968, 'Bracer', 'Exceptional Intellect'),
(3845, 44575, 44815, 'Bracer', 'Greater Assault'),
(3241, 44576, 38972, 'Weapon', 'Lifeward'),
(3243, 44582, 38973, 'Cloak', 'Minor Power'),
(3244, 44584, 38974, 'Boots', 'Greater Vitality'),
(3245, 44588, 38975, 'Chest', 'Exceptional Resilience'),
(4748, 44589, 38976, 'Boots', 'Superior Agility'),
(1951, 44591, 38978, 'Cloak', 'Superior Dodge'),
(3246, 44592, 38979, 'Gloves', 'Exceptional Spellpower'),
(1147, 44593, 38980, 'Bracer', 'Major Spirit'),
(3247, 44595, 38981, '2H Weapon', 'Scourgebane'),
(3231, 44598, 38984, 'Bracer', 'Haste'),
(2661, 44616, 38987, 'Bracer', 'Greater Stats'),
(3251, 44621, 38988, 'Weapon', 'Giant Slayer'),
(3252, 44623, 38989, 'Chest', 'Super Stats'),
(3253, 44625, 38990, 'Gloves', 'Armsman'),
(3830, 44629, 38991, 'Weapon', 'Exceptional Spellpower'),
(3828, 44630, 38992, '2H Weapon', 'Greater Savagery'),
(3256, 44631, 38993, 'Cloak', 'Shadow Armor'),
(1103, 44633, 38995, 'Weapon', 'Exceptional Agility'),
(2326, 44635, 38997, 'Bracer', 'Greater Spellpower'),
(3273, 46578, 38998, 'Weapon', 'Deathfrost'),
(5260, 46594, 38999, 'Chest', 'Dodge'),
(2648, 47051, 39000, 'Cloak', 'Greater Dodge'),
(3294, 47672, 39001, 'Cloak', 'Mighty Stamina'),
(1953, 47766, 39002, 'Chest', 'Greater Dodge'),
(3831, 47898, 39003, 'Cloak', 'Greater Speed'),
(3296, 47899, 39004, 'Cloak', 'Wisdom'),
(3297, 47900, 39005, 'Chest', 'Super Health'),
(3232, 47901, 39006, 'Boots', 'Tuskarr''s Vitality'),
(3788, 59619, 44497, 'Weapon', 'Accuracy'),
(3789, 59621, 44493, 'Weapon', 'Berserking'),
(3790, 59625, 43987, 'Weapon', 'Black Magic'),
(3824, 60606, 44449, 'Boots', 'Assault'),
(3825, 60609, 44456, 'Cloak', 'Speed'),
(1600, 60616, 38971, 'Bracer', 'Assault'),
(1606, 60621, 44453, 'Weapon', 'Greater Potency'),
(3826, 60623, 38986, 'Boots', 'Icewalker'),
(1128, 60653, 44455, 'Shield', 'Greater Intellect'),
(1099, 60663, 44457, 'Cloak', 'Major Agility'),
(1603, 60668, 44458, 'Gloves', 'Crusher'),
(3827, 60691, 44463, '2H Weapon', 'Massacre'),
(3832, 60692, 44465, 'Chest', 'Powerful Stats'),
(3833, 60707, 44466, 'Weapon', 'Superior Potency'),
(3834, 60714, 44467, 'Weapon', 'Mighty Spellpower'),
(1597, 60763, 44469, 'Boots', 'Greater Assault'),
(2332, 60767, 44470, 'Bracer', 'Superior Spellpower'),
(3850, 62256, 44947, 'Bracer', 'Major Stamina'),
(3854, 62948, 45056, 'Staff', 'Greater Spellpower'),
(3855, 62959, 45060, 'Staff', 'Spellpower'),
(3858, 63746, 45628, 'Boots', 'Lesser Accuracy'),
(3869, 64441, 46026, 'Weapon', 'Blade Ward'),
(3870, 64579, 46098, 'Weapon', 'Blood Draining'),
(4732, 71692, 50816, 'Gloves', 'Angler'),
(4061, 74132, 52687, 'Gloves', 'Mastery'),
(4062, 74189, 52743, 'Boots', 'Earthen Vitality'),
(4063, 74191, 52744, 'Chest', 'Mighty Stats'),
(4064, 74192, 52745, 'Cloak', 'Lesser Power'),
(4065, 74193, 52746, 'Bracer', 'Speed'),
(4066, 74195, 52747, 'Weapon', 'Mending'),
(4067, 74197, 52748, 'Weapon', 'Avalanche'),
(4068, 74198, 52749, 'Gloves', 'Haste'),
(4069, 74199, 52750, 'Boots', 'Haste'),
(4070, 74200, 52751, 'Chest', 'Stamina'),
(4071, 74201, 52752, 'Bracer', 'Critical Strike'),
(4072, 74202, 52753, 'Cloak', 'Intellect'),
(4073, 74207, 52754, 'Shield', 'Protection'),
(4074, 74211, 52755, 'Weapon', 'Elemental Slayer'),
(4075, 74212, 52756, 'Gloves', 'Exceptional Strength'),
(4076, 74213, 52757, 'Boots', 'Major Agility'),
(4077, 74214, 52758, 'Chest', 'Mighty Resilience'),
(4082, 74220, 52759, 'Gloves', 'Greater Haste'),
(4083, 74223, 52760, 'Weapon', 'Hurricane'),
(4084, 74225, 52761, 'Weapon', 'Heartsong'),
(4085, 74226, 52762, 'Shield', 'Mastery'),
(4086, 74229, 52763, 'Bracer', 'Superior Dodge'),
(4087, 74230, 52764, 'Cloak', 'Critical Strike'),
(4088, 74231, 52765, 'Chest', 'Exceptional Spirit'),
(4089, 74232, 52766, 'Bracer', 'Precision'),
(4090, 74234, 52767, 'Cloak', 'Protection'),
(4091, 74235, 52768, 'Off-Hand', 'Superior Intellect'),
(4092, 74236, 52769, 'Boots', 'Precision'),
(4093, 74237, 52770, 'Bracer', 'Exceptional Spirit'),
(4094, 74238, 52771, 'Boots', 'Mastery'),
(4095, 74239, 52772, 'Bracer', 'Greater Haste'),
(4096, 74240, 52773, 'Cloak', 'Greater Intellect'),
(4097, 74242, 52774, 'Weapon', 'Power Torrent'),
(4098, 74244, 52775, 'Weapon', 'Windwalk'),
(4099, 74246, 52776, 'Weapon', 'Landslide'),
(4100, 74247, 52777, 'Cloak', 'Greater Critical Strike'),
(4101, 74248, 52778, 'Bracer', 'Greater Critical Strike'),
(4102, 74250, 52779, 'Chest', 'Peerless Stats'),
(4103, 74251, 52780, 'Chest', 'Greater Stamina'),
(4105, 74252, 52781, 'Boots', 'Assassin''s Step'),
(4104, 74253, 52782, 'Boots', 'Lavawalker'),
(4106, 74254, 52783, 'Gloves', 'Mighty Strength'),
(4107, 74255, 52784, 'Gloves', 'Greater Mastery'),
(4108, 74256, 52785, 'Bracer', 'Greater Speed'),
(4227, 95471, 68134, '2H Weapon', 'Mighty Agility'),
(4256, 96261, 68785, 'Bracer', 'Major Strength'),
(4257, 96262, 68786, 'Bracer', 'Mighty Intellect'),
(4258, 96264, 68784, 'Bracer', 'Agility'),
(4411, 104338, 74700, 'Bracer', 'Mastery'),
(4412, 104385, 74701, 'Bracer', 'Major Dodge'),
(4414, 104389, 74703, 'Bracer', 'Super Intellect'),
(4415, 104390, 74704, 'Bracer', 'Exceptional Strength'),
(4416, 104391, 74705, 'Bracer', 'Greater Agility'),
(4417, 104392, 74706, 'Chest', 'Super Resilience'),
(4418, 104393, 74707, 'Chest', 'Mighty Spirit'),
(4419, 104395, 74708, 'Chest', 'Glorious Stats'),
(4420, 104397, 74709, 'Chest', 'Superior Stamina'),
(4421, 104398, 74710, 'Cloak', 'Accuracy'),
(4422, 104401, 74711, 'Cloak', 'Greater Protection'),
(4423, 104403, 74712, 'Cloak', 'Superior Intellect'),
(4424, 104404, 74713, 'Cloak', 'Superior Critical Strike'),
(4426, 104407, 74715, 'Boots', 'Greater Haste'),
(4427, 104408, 74716, 'Boots', 'Greater Precision'),
(4428, 104409, 74717, 'Boots', 'Blurred Speed'),
(4429, 104414, 74718, 'Boots', 'Pandaren''s Step'),
(4430, 104416, 74719, 'Gloves', 'Greater Haste'),
(4431, 104417, 74720, 'Gloves', 'Superior Haste'),
(4432, 104419, 74721, 'Gloves', 'Super Strength'),
(4433, 104420, 74722, 'Gloves', 'Superior Mastery'),
(4441, 104425, 74723, 'Weapon', 'Windsong'),
(4442, 104427, 74724, 'Weapon', 'Jade Spirit'),
(4443, 104430, 74725, 'Weapon', 'Elemental Force'),
(4444, 104434, 74726, 'Weapon', 'Dancing Steel'),
(4445, 104440, 74727, 'Weapon', 'Colossus'),
(4446, 104442, 74728, 'Weapon', 'River''s Song'),
(4434, 104445, 74729, 'Off-Hand', 'Major Intellect'),
(4993, 130758, 89737, 'Shield', 'Greater Parry'),
(5285, 158877, 110631, 'Cloak', 'Breath of Critical Strike'),
(5298, 158878, 110632, 'Cloak', 'Breath of Haste'),
(5300, 158879, 110633, 'Cloak', 'Breath of Mastery'),
(5302, 158880, 110634, 'Cloak', 'Breath of Multistrike'),
(5304, 158881, 110635, 'Cloak', 'Breath of Versatility'),
(5310, 158884, 110652, 'Cloak', 'Gift of Critical Strike'),
(5311, 158885, 110653, 'Cloak', 'Gift of Haste'),
(5312, 158886, 110654, 'Cloak', 'Gift of Mastery'),
(5313, 158887, 110655, 'Cloak', 'Gift of Multistrike'),
(5314, 158889, 110656, 'Cloak', 'Gift of Versatility'),
(5285, 158892, 110624, 'Neck', 'Breath of Critical Strike'),
(5292, 158893, 110625, 'Neck', 'Breath of Haste'),
(5293, 158894, 110626, 'Neck', 'Breath of Mastery'),
(5294, 158895, 110627, 'Neck', 'Breath of Multistrike'),
(5295, 158896, 110628, 'Neck', 'Breath of Versatility'),
(5317, 158899, 110645, 'Neck', 'Gift of Critical Strike'),
(5318, 158900, 110646, 'Neck', 'Gift of Haste'),
(5319, 158901, 110647, 'Neck', 'Gift of Mastery'),
(5320, 158902, 110648, 'Neck', 'Gift of Multistrike'),
(5321, 158903, 110649, 'Neck', 'Gift of Versatility'),
(5284, 158907, 110617, 'Ring', 'Breath of Critical Strike'),
(5297, 158908, 110618, 'Ring', 'Breath of Haste'),
(5299, 158909, 110619, 'Ring', 'Breath of Mastery'),
(5301, 158910, 110620, 'Ring', 'Breath of Multistrike'),
(5303, 158911, 110621, 'Ring', 'Breath of Versatility'),
(5324, 158914, 110638, 'Ring', 'Gift of Critical Strike'),
(5325, 158915, 110639, 'Ring', 'Gift of Haste'),
(5326, 158916, 110640, 'Ring', 'Gift of Mastery'),
(5327, 158917, 110641, 'Ring', 'Gift of Multistrike'),
(5328, 158918, 110642, 'Ring', 'Gift of Versatility'),
(5330, 159235, 110682, 'Weapon', 'Mark of the Thunderlord'),
(5331, 159236, 112093, 'Weapon', 'Mark of the Shattered Hand'),
(5337, 159671, 112164, 'Weapon', 'Mark of Warsong'),
(5334, 159672, 112165, 'Weapon', 'Mark of the Frostwolf'),
(5335, 159673, 112115, 'Weapon', 'Mark of Shadowmoon'),
(5336, 159674, 112160, 'Weapon', 'Mark of Blackrock'),
(5384, 173323, 118015, 'Weapon', 'Mark of Bleeding Hollow');
--
-- Indexes for table `professions_enchanting`
--
ALTER TABLE `professions_enchanting`
ADD PRIMARY KEY (`spellid`);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.