database.sql

-- phpMyAdmin SQL Dump
-- version 3.4.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. Mrz 2017 um 11:17
-- Server Version: 5.6.34
-- PHP-Version: 5.6.30-he.0

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 */;

--
-- Datenbank: `guild.gerritalex.de`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_api`
--

CREATE TABLE IF NOT EXISTS `ovw_api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `wow_key` varchar(32) COLLATE latin1_german2_ci NOT NULL,
  `wlogs_key` varchar(32) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=2 ;


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_classes`
--

CREATE TABLE IF NOT EXISTS `ovw_classes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` text COLLATE latin1_german2_ci NOT NULL,
  `color` varchar(25) COLLATE latin1_german2_ci NOT NULL,
  `colorhex` varchar(7) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=13 ;

--
-- Daten für Tabelle `ovw_classes`
--

INSERT INTO `ovw_classes` (`id`, `class`, `color`, `colorhex`) VALUES
(1, 'Warrior', 'rgba(199, 156, 110, 0.6)', '#C79C6E'),
(2, 'Paladin', 'rgba(245, 140, 186, 0.6)', '#F58CBA'),
(3, 'Hunter', 'rgba(102, 160, 77, 0.6)', '#ABD473'),
(4, 'Rogue', 'rgba(255, 245, 105, 0.6)', '#FFF569'),
(5, 'Priest', 'rgba(255, 255, 255, 0.6)', '#FFFFFF'),
(6, 'Death Knight', 'rgba(196, 31, 59, 0.6)', '#C41F3B'),
(7, 'Shaman', 'rgba(0, 112, 222, 0.6)', '#0070DE'),
(8, 'Mage', 'rgba(105, 204, 240, 0.6)', '#69CCF0'),
(9, 'Warlock', 'rgba(148, 130, 201, 0.6)', '#9482C9'),
(10, 'Monk', 'rgba(0, 255, 150, 0.6)', '#00FF96'),
(11, 'Druid', 'rgba(255, 125, 10, 0.6)', '#FF7D0A'),
(12, 'Demon Hunter', 'rgba(163, 48, 201, 0.6)', '#A330C9');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_dungeons`
--

CREATE TABLE IF NOT EXISTS `ovw_dungeons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text COLLATE latin1_german2_ci NOT NULL,
  `short` text COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=14 ;

--
-- Daten für Tabelle `ovw_dungeons`
--

INSERT INTO `ovw_dungeons` (`id`, `name`, `short`) VALUES
(1, 'Black Rook Hold', 'brh'),
(2, 'Cathedral of Eternal Night', 'cen'),
(3, 'Court of Stars', 'cos'),
(4, 'Darkheart Thicket', 'dht'),
(5, 'Eye of Azshara', 'eoa'),
(6, 'Halls of Valor', 'hov'),
(7, 'Lower Karazhan', 'lkz'),
(8, 'Maw of Souls', 'mos'),
(9, 'Neltharion''s Lair', 'nel'),
(10, 'The Arcway', 'arc'),
(12, 'Upper Karazhan', 'ukz'),
(13, 'Vault of the Wardens', 'votw'),
(11, 'The Violet Hold', 'vh');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_enchants`
--

CREATE TABLE IF NOT EXISTS `ovw_enchants` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `enchant_id` smallint(6) NOT NULL,
  `wowhead_id` mediumint(6) NOT NULL,
  `name` varchar(50) COLLATE latin1_german2_ci NOT NULL,
  `slot` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=34 ;

--
-- Daten für Tabelle `ovw_enchants`
--

INSERT INTO `ovw_enchants` (`id`, `enchant_id`, `wowhead_id`, `name`, `slot`) VALUES
(1, 5437, 128551, 'Enchant Neck - Mark of the Claw', 2),
(2, 5439, 128553, 'Enchant Neck - Mark of the Hidden Satyr', 2),
(3, 5883, 140219, 'Boon of the Bloodhunter', 3),
(4, 5889, 141908, 'Enchant Neck - Mark of the Heavy Hide', 2),
(5, 5890, 141909, 'Enchant Neck - Mark of the Trained Soldier', 2),
(6, 5891, 141910, 'Enchant Neck - Mark of the Ancient Priestess', 2),
(7, 5431, 128545, 'Enchant Cloak - Word of Strength', 4),
(8, 5432, 128546, 'Enchant Cloak - Word of Agility', 4),
(9, 5433, 128547, 'Enchant Cloak - Word of Intellect', 4),
(10, 5434, 128548, 'Enchant Cloak - Binding of Strength', 4),
(11, 5435, 128549, 'Enchant Cloak - Binding of Agility', 4),
(12, 5436, 128550, 'Enchant Cloak - Binding of Intellect', 4),
(13, 5423, 128537, 'Enchant Ring - Word of Critical Strike', 11),
(14, 5424, 128538, 'Enchant Ring - Word of Haste', 11),
(15, 5425, 128539, 'Enchant Ring - Word of Mastery', 11),
(16, 5426, 128540, 'Enchant Ring - Word of Versatility', 11),
(17, 5427, 128541, 'Enchant Ring - Binding of Critical Strike', 11),
(18, 5428, 128542, 'Enchant Ring - Binding of Haste', 11),
(19, 5429, 128543, 'Enchant Ring - Binding of Mastery', 11),
(20, 5430, 128544, 'Enchant Ring - Binding of Versatility', 11),
(21, 5442, 140214, 'Boon of the Harvester', 3),
(22, 5882, 140218, 'Boon of the Manaseeker', 3),
(23, 5440, 128554, 'Boon of the Scavenger', 3),
(24, 5441, 140213, 'Boon of the Gemfinder', 3),
(25, 5443, 140215, 'Boon of the Butcher', 3),
(26, 5881, 140217, 'Boon of the Salvager', 3),
(27, 5899, 144328, 'Boon of the Builder', 3),
(28, 5438, 128552, 'Enchant Neck - Mark of the Distant Army', 2),
(29, 5895, 144304, 'Enchant Neck - Mark of the Master', 2),
(30, 5896, 144305, 'Enchant Neck - Mark of Versatile', 2),
(31, 5897, 144306, 'Enchant Neck - Mark of the Quick', 2),
(32, 5898, 144307, 'Enchant Neck - Mark of the Deadly', 2),
(33, 5888, 141861, 'Boon of the Nether', 3);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_eq`
--

CREATE TABLE IF NOT EXISTS `ovw_eq` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `m2_5` float NOT NULL,
  `m5_10` float NOT NULL,
  `m10_15` float NOT NULL,
  `m15p` float NOT NULL,
  `en_lfr` float NOT NULL,
  `en_n` float NOT NULL,
  `en_hc` float NOT NULL,
  `en_m` float NOT NULL,
  `tov_lfr` float NOT NULL,
  `tov_n` float NOT NULL,
  `tov_hc` float NOT NULL,
  `tov_m` float NOT NULL,
  `nh_lfr` float NOT NULL,
  `nh_n` float NOT NULL,
  `nh_hc` float NOT NULL,
  `nh_m` float NOT NULL,
  `tos_lfr` float NOT NULL,
  `tos_n` float NOT NULL,
  `tos_hc` float NOT NULL,
  `tos_m` float NOT NULL,
  `itemlevel` float NOT NULL,
  `m0` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `ovw_eq`
--

INSERT INTO `ovw_eq` (`id`, `m2_5`, `m5_10`, `m10_15`, `m15p`, `en_lfr`, `en_n`, `en_hc`, `en_m`, `tov_lfr`, `tov_n`, `tov_hc`, `tov_m`, `nh_lfr`, `nh_n`, `nh_hc`, `nh_m`, `tos_lfr`, `tos_n`, `tos_hc`, `tos_m`, `itemlevel`, `m0`) VALUES
(1, 8.70666, 9.12, 9.54, 9.94666, 4.2857, 8.5714, 17.1429, 42.8571, 10, 20, 40, 100, 3, 6, 12, 30, 3.3333, 6.6666, 13.3333, 33.3333, 51.7467, 8.29333);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_equip`
--

CREATE TABLE IF NOT EXISTS `ovw_equip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `slot` varchar(9) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=15 ;

--
-- Daten für Tabelle `ovw_equip`
--

INSERT INTO `ovw_equip` (`id`, `slot`) VALUES
(1, 'head'),
(2, 'neck'),
(3, 'shoulders'),
(4, 'back'),
(5, 'chest'),
(6, 'wrists'),
(7, 'hands'),
(8, 'waist'),
(9, 'legs'),
(10, 'feet'),
(11, 'finger1'),
(12, 'finger2'),
(13, 'trinket1'),
(14, 'trinket2');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_gems`
--

CREATE TABLE IF NOT EXISTS `ovw_gems` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gem_id` int(11) NOT NULL,
  `name` varchar(32) COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=12 ;

--
-- Daten für Tabelle `ovw_gems`
--

INSERT INTO `ovw_gems` (`id`, `gem_id`, `name`) VALUES
(1, 130218, 'Masterful Queen''s Opal'),
(2, 130221, 'Versatile Maelstrom Sapphire'),
(3, 130220, 'Quick Dawnlight'),
(4, 130216, 'Quick Azsunite'),
(5, 130246, 'Saber''s Eye of Strength'),
(6, 130222, 'Masterful Shadowruby'),
(7, 130219, 'Deadly Eye of Prophecy'),
(8, 130248, 'Saber''s Eye of Intellect'),
(9, 130247, 'Saber''s Eye of Agility'),
(10, 130215, 'Deadly Deep Amber'),
(11, 130217, 'Versatile Skystone');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_guilds`
--

CREATE TABLE IF NOT EXISTS `ovw_guilds` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild_name` varchar(24) CHARACTER SET utf8 NOT NULL,
  `region` text COLLATE latin1_german2_ci NOT NULL,
  `realm` smallint(4) NOT NULL,
  `shortlink` varchar(32) COLLATE latin1_german2_ci NOT NULL,
  `registered` int(10) NOT NULL,
  `password` varchar(32) COLLATE latin1_german2_ci NOT NULL,
  `last_login` int(10) NOT NULL,
  `tracked_chars` smallint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=12 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_legendaries`
--

CREATE TABLE IF NOT EXISTS `ovw_legendaries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE latin1_german2_ci NOT NULL,
  `item_id` int(6) NOT NULL,
  `class` varchar(19) COLLATE latin1_german2_ci NOT NULL,
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `item_id` (`item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=200 ;

--
-- Daten für Tabelle `ovw_legendaries`
--

INSERT INTO `ovw_legendaries` (`id`, `name`, `item_id`, `class`) VALUES
(2, 'Shackles of Bryndaor', 132365, '6'),
(3, 'Koltira''s Newfound Will', 132366, '6'),
(4, 'Service of Gorefiend', 132367, '6'),
(5, 'Acherus Drapes', 132376, '6'),
(6, 'Draugr, Girdle of the Everlasting King', 132441, '6'),
(7, 'Aggramar''s Stride', 132443, '6, 2, 1'),
(8, 'Prydaz, Xavaric''s Magnum Opus', 132444, '0'),
(9, 'The Instructor''s Fourth Lesson', 132448, '6'),
(10, 'Sephuz''s Secret', 132452, '0'),
(11, 'Rattlegore Bone Legplates', 132453, '6'),
(12, 'Toravon''s Whiteout Bindings', 132458, '6'),
(13, 'Perseverance of the Ebon Martyr', 132459, '6'),
(14, 'Lana''thel''s Lament', 133974, '6'),
(15, 'Uvanimor, the Unbeautiful', 137037, '6'),
(16, 'Tak''theritrix''s Shoulderpads', 137075, '6'),
(17, 'Seal of Necrofantasia', 137223, '6'),
(18, 'Archimonde''s Hatred Reborn', 144249, '1, 2, 6, 10, 11, 12'),
(19, 'Velen''s Future Sight', 144258, '2, 5, 7, 10, 11'),
(20, 'Kil''jaeden''s Burning Wish', 144259, '0'),
(21, 'Death March', 144280, '6'),
(22, 'Skullflower''s Haemostasis', 144281, '6'),
(23, 'Consort''s Cold Core', 144293, '6'),
(24, 'Cinidaria, the Symbiote', 133976, '12, 11, 10, 4'),
(25, 'Achor, the Eternal Hunger', 137014, '12'),
(26, 'Loramus Thalipedes'' Sacrifice', 137022, '12'),
(27, 'Anger of the Half-Giants', 137038, '12'),
(28, 'Raddon''s Cascading Eyes', 137061, '12'),
(29, 'Cloak of Fel Flames', 137066, '12'),
(30, 'Runemaster''s Pauldrons', 137071, '12'),
(31, 'Mo''arg Bionic Stabilizers', 137090, '12'),
(32, 'The Defiler''s Lost Vambraces', 137091, '12'),
(33, 'Fragment of the Betrayer''s Prison', 138854, '12'),
(34, 'Kirel Narak', 138949, '12'),
(35, 'Delusions of Grandeur', 144279, '12'),
(36, 'Spirit of the Darkness Flame', 144292, '12'),
(37, 'Ekowraith, Creator of Worlds', 137015, '11'),
(38, 'Promise of Elune, the Moon Goddess', 137023, '11'),
(39, 'Ailuro Pouncers', 137024, '11'),
(40, 'Skysec''s Hold', 137025, '11'),
(41, 'Essence of Infusion', 137026, '11'),
(42, 'Impeccable Fel Essence', 137039, '11'),
(43, 'Chatoyant Signet', 137040, '11'),
(44, 'Dual Determination', 137041, '11'),
(45, 'Tearstone of Elune', 137042, '11'),
(46, 'Luffa Wrappings', 137056, '11'),
(47, 'The Emerald Dreamcatcher', 137062, '11'),
(48, 'Elize''s Everlasting Encasement', 137067, '11'),
(49, 'Aman''Thul''s Wisdom', 137072, '11'),
(50, 'The Dark Titan''s Advice', 137078, '11'),
(51, 'Oneth''s Intuition', 137092, '11'),
(52, 'The Wildshaper''s Clutch', 137094, '11'),
(53, 'Edraith, Bonds of Aglaya', 137095, '11'),
(54, 'X''oni''s Caress', 144242, '11'),
(55, 'Lady and the Child', 144295, '11'),
(56, 'Fiery Red Maimers', 144354, '11'),
(57, 'Oakheart''s Puny Quods', 144432, '11'),
(58, 'Roots of Shaladrassil', 132466, '7, 3'),
(59, 'Ullr''s Feather Snowshoes', 137033, '3'),
(60, 'Nesingwary''s Trapping Treads', 137034, '3'),
(61, 'Frizzo''s Fingertrap', 137043, '3'),
(62, 'Zevrim''s Hunger', 137055, '3'),
(63, 'The Shadow Hunter''s Voodoo Mask', 137064, '3'),
(64, 'Roar of the Seven Lions', 137080, '3'),
(65, 'War Belt of the Sentinel Army', 137081, '3'),
(66, 'Helbrine, Rope of the Mist Marauder', 137082, '3'),
(67, 'Call of the Wild', 137101, '3'),
(68, 'Qa''pla, Eredun War Order', 137227, '3'),
(69, 'The Apex Predator''s Claw', 137382, '3'),
(70, 'Magnetized Blasting Cap Launcher', 141353, '3'),
(71, 'MKII Gyroscopic Stabilizer', 144303, '3'),
(72, 'The Mantle of Command', 144326, '3'),
(73, 'Butcher''s Bone Apron', 144361, '3'),
(74, 'Marquee Bindings of the Sun King', 132406, '8'),
(75, 'Shard of the Exodar', 132410, '8'),
(76, 'Lady Vashj''s Grasp', 132411, '8'),
(77, 'Rhonin''s Assaulting Armwraps', 132413, '8'),
(78, 'Cord of Infinity', 132442, '8'),
(79, 'Mystic Kilt of the Rune Master', 132451, '8'),
(80, 'Koralon''s Burning Touch', 132454, '8'),
(81, 'Norgannon''s Foresight', 132455, '8, 5, 9'),
(82, 'Darckli''s Dragonfire Diadem', 132863, '8'),
(83, 'Zann''esu Journey', 133970, '8'),
(84, 'Belo''vir''s Final Stand', 133977, '8'),
(85, 'Magtheridon''s Banished Bracers', 138140, '8'),
(86, 'Ice Time', 144260, '8'),
(87, 'Gravity Spiral', 144274, '8'),
(88, 'Pyrotex Ignition Cloth', 144355, '8'),
(89, 'Sal''salabim''s Lost Tunic', 137016, '10'),
(90, 'Cenedril, Reflector of Hatred', 137019, '10'),
(91, 'Firestone Walkers', 137027, '10'),
(92, 'Ei''thas, Lunar Glides of Eramas', 137028, '10'),
(93, 'Katsuo''s Eclipse', 137029, '10'),
(94, 'Jewel of the Lost Abbey', 137044, '10'),
(95, 'Eye of Collidus the Warp-Watcher', 137045, '10'),
(96, 'Hidden Master''s Forbidden Touch', 137057, '10'),
(97, 'Fundamental Observation', 137063, '10'),
(98, 'Leggings of The Black Flame', 137068, '10'),
(99, 'Unison Spaulders', 137073, '10'),
(100, 'Gai Plin''s Soothing Sash', 137079, '10'),
(101, 'Petrichor Lagniappe', 137096, '10'),
(102, 'Drinking Horn Cover', 137097, '10'),
(103, 'March of the Legion', 137220, '10'),
(104, 'Ovyd''s Winter Wrap', 138879, '10'),
(105, 'The Emperor''s Capacitor', 144239, '10'),
(106, 'Anvil-Hardened Wristwraps', 144277, '10'),
(107, 'Shelter of Rin', 144340, '10'),
(108, 'Breastplate of the Golden Val''kyr', 137017, '2'),
(109, 'Whisper of the Nathrezim', 137020, '2'),
(110, 'Ilterendi, Crown Jewel of Silvermoon', 137046, '2'),
(111, 'Heathcliff''s Immortality', 137047, '2'),
(112, 'Liadrin''s Fury Unleashed', 137048, '2'),
(113, 'Tyr''s Hand of Faith', 137059, '2'),
(114, 'Justice Gaze', 137065, '2'),
(115, 'Tyelca, Ferren Marcus''s Stature', 137070, '2'),
(116, 'Obsidian Stone Spaulders', 137076, '2'),
(117, 'Chain of Thrayn', 137086, '2'),
(118, 'Uther''s Guard', 137105, '2'),
(119, 'Aegisjalmur, the Armguards of Awe', 140846, '2'),
(120, 'Maraad''s Dying Breath', 144273, '2'),
(121, 'Saruan''s Resolve', 144275, '2'),
(122, 'Ashes to Dust', 144358, '2'),
(123, 'Anund''s Seared Shackles', 132409, '5'),
(124, 'Skjoldr, Sanctuary of Ivagont', 132436, '5'),
(125, 'Mother Shahraz''s Seduction', 132437, '5'),
(126, 'Al''maiesh, the Cord of Hope', 132445, '5'),
(127, 'Entrancing Trousers of An''juna', 132447, '5'),
(128, 'Phyrix''s Embrace', 132449, '5'),
(129, 'Muze''s Unwavering Will', 132450, '5'),
(130, 'Xalan the Feared''s Clench', 132461, '5'),
(131, 'Estel, Dejahna''s Inspiration', 132861, '5'),
(132, 'Mangaza''s Madness', 132864, '5'),
(133, 'Cord of Maiev, Priestess of the Moon', 133800, '5'),
(134, 'Zenk''aram, Iridi''s Anadem', 133971, '5'),
(135, 'The Twins'' Painful Touch', 133973, '5'),
(136, 'X''anshi, Shroud of Archbishop Benedictus', 137109, '5'),
(137, 'N''ero, Band of Promises', 137276, '5'),
(138, 'Kam Xi''raff', 144244, '5'),
(139, 'Rammal''s Ulterior Motive', 144247, '5'),
(140, 'Zeks Exterminatus', 144438, '5'),
(141, 'The Dreadlord''s Deceit', 137021, '4'),
(142, 'Duskwalker''s Footpads', 137030, '4'),
(143, 'Thraxi''s Tricksy Treads', 137031, '4'),
(144, 'Shadow Satyr''s Walk', 137032, '4'),
(145, 'Insignia of Ravenholdt', 137049, '4'),
(146, 'Will of Valeera', 137069, '4'),
(147, 'Zoldyck Family Training Shackles', 137098, '4'),
(148, 'Greenskin''s Waterlogged Wristcuffs', 137099, '4'),
(149, 'Denial of the Half-Giants', 137100, '4'),
(150, 'Shivarran Symmetry', 141321, '4'),
(151, 'Mantle of the Master Assassin', 144236, '4'),
(152, 'The Deceiver''s Blood Pact', 137035, '7'),
(153, 'Elemental Rebalancers', 137036, '7'),
(154, 'Eye of the Twisting Nether', 137050, '7'),
(155, 'Focuser of Jonat, the Elder', 137051, '7'),
(156, 'Praetorian''s Tidecallers', 137058, '7'),
(157, 'Echoes of the Great Sundering', 137074, '7'),
(158, 'Pristine Proto-Scale Girdle', 137083, '7'),
(159, 'Akainu''s Absolute Justice', 137084, '7'),
(160, 'Intact Nazjatar Molting', 137085, '7'),
(161, 'Al''Akir''s Acrimony', 137102, '7'),
(162, 'Storm Tempests', 137103, '7'),
(163, 'Nobundo''s Redemption', 137104, '7'),
(164, 'Emalon''s Charged Core', 137616, '7'),
(165, 'Spiritual Journey', 138117, '7'),
(166, 'Uncertain Reminder', 143732, '7'),
(167, 'Pillars of the Dark Portal', 132357, '9'),
(168, 'Wilfred''s Sigil of Superior Summoning', 132369, '9'),
(169, 'Kazzak''s Final Curse', 132374, '9'),
(170, 'Odr, Shawl of the Ymirjar', 132375, '9'),
(171, 'Sacrolash''s Dark Strike', 132378, '9'),
(172, 'Sin''dorei Spite', 132379, '9'),
(173, 'Streten''s Sleepless Shackles', 132381, '9'),
(174, 'Recurrent Ritual', 132393, '9'),
(175, 'Hood of Eternal Disdain', 132394, '9'),
(176, 'Magistrike Restraints', 132407, '9'),
(177, 'Feretory of Souls', 132456, '9'),
(178, 'Power Cord of Lethtendris', 132457, '9'),
(179, 'Alythess''s Pyrogenics', 132460, '9'),
(180, 'Reap and Sow', 144364, '9'),
(181, 'Lessons of Space-Time', 144369, '9'),
(182, 'Wakener''s Loyalty', 144385, '9'),
(183, 'Destiny Driver', 137018, '1'),
(184, 'Ayala''s Stone Heart', 137052, '1'),
(185, 'Kazzalax, Fujieda''s Fury', 137053, '1'),
(186, 'The Walls Fell', 137054, '1'),
(187, 'Archavon''s Heavy Hand', 137060, '1'),
(188, 'Weight of the Earth', 137077, '1'),
(189, 'Naj''entus''s Vertebrae', 137087, '1'),
(190, 'Ceann-Ar Charger', 137088, '1'),
(191, 'Thundergod''s Vigor', 137089, '1'),
(192, 'Mannoroth''s Bloodletting Manacles', 137107, '1'),
(193, 'Kakushan''s Stormscale Gauntlets', 137108, '1'),
(194, 'Timeless Stratagem', 143728, '1'),
(195, 'Kargath''s Sacrificed Hands\n', 138489, '1'),
(196, 'Celumbra, the Night''s Dichotomy', 146666, '5, 8, 9'),
(197, 'Rethu''s Incessant Courage', 146667, '1, 2, 6'),
(198, 'Vigilance Perch', 146668, '3, 7'),
(199, 'The Sentinel''s Eternal Refuge', 146669, '4, 10, 11, 12');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_raids`
--

CREATE TABLE IF NOT EXISTS `ovw_raids` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text COLLATE latin1_german2_ci NOT NULL,
  `short` text COLLATE latin1_german2_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=5 ;

--
-- Daten für Tabelle `ovw_raids`
--

INSERT INTO `ovw_raids` (`id`, `name`, `short`) VALUES
(1, 'Emerald Nightmare', 'en'),
(2, 'Trial of Valor', 'tov'),
(3, 'The Nighthold', 'nh'),
(4, 'Tomb of Sargeras', 'tos');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_realms`
--

CREATE TABLE IF NOT EXISTS `ovw_realms` (
  `id` smallint(5) unsigned NOT NULL,
  `region` enum('US','EU','CN','TW','KR') COLLATE utf8_unicode_ci NOT NULL,
  `short` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `realmset` (`region`,`short`),
  UNIQUE KEY `region` (`region`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `ovw_realms`
--

INSERT INTO `ovw_realms` (`id`, `region`, `short`, `name`) VALUES
(0, 'EU', 'Ревущий-фьорд', 'Ревущий фьорд'),
(1, 'US', 'aegwynn', 'Aegwynn'),
(2, 'US', 'aerie-peak', 'Aerie Peak'),
(3, 'US', 'agamaggan', 'Agamaggan'),
(4, 'US', 'aggramar', 'Aggramar'),
(5, 'US', 'akama', 'Akama'),
(6, 'US', 'alexstrasza', 'Alexstrasza'),
(7, 'US', 'alleria', 'Alleria'),
(8, 'US', 'altar-of-storms', 'Altar of Storms'),
(9, 'US', 'alterac-mountains', 'Alterac Mountains'),
(10, 'US', 'amanthul', 'Aman''Thul'),
(11, 'US', 'andorhal', 'Andorhal'),
(12, 'US', 'anetheron', 'Anetheron'),
(13, 'US', 'antonidas', 'Antonidas'),
(14, 'US', 'anubarak', 'Anub''arak'),
(15, 'US', 'arathor', 'Arathor'),
(16, 'US', 'archimonde', 'Archimonde'),
(17, 'US', 'area-52', 'Area 52'),
(18, 'US', 'argent-dawn', 'Argent Dawn'),
(19, 'US', 'arthas', 'Arthas'),
(20, 'US', 'arygos', 'Arygos'),
(21, 'US', 'auchindoun', 'Auchindoun'),
(22, 'US', 'azgalor', 'Azgalor'),
(23, 'US', 'azjolnerub', 'Azjol-Nerub'),
(24, 'US', 'azralon', 'Azralon'),
(25, 'US', 'azshara', 'Azshara'),
(26, 'US', 'azuremyst', 'Azuremyst'),
(27, 'US', 'baelgun', 'Baelgun'),
(28, 'US', 'balnazzar', 'Balnazzar'),
(29, 'US', 'barthilas', 'Barthilas'),
(30, 'US', 'black-dragonflight', 'Black Dragonflight'),
(31, 'US', 'blackhand', 'Blackhand'),
(32, 'US', 'blackrock', 'Blackrock'),
(33, 'US', 'blackwater-raiders', 'Blackwater Raiders'),
(34, 'US', 'blackwing-lair', 'Blackwing Lair'),
(35, 'US', 'blades-edge', 'Blade''s Edge'),
(36, 'US', 'bladefist', 'Bladefist'),
(37, 'US', 'bleeding-hollow', 'Bleeding Hollow'),
(38, 'US', 'blood-furnace', 'Blood Furnace'),
(39, 'US', 'bloodhoof', 'Bloodhoof'),
(40, 'US', 'bloodscalp', 'Bloodscalp'),
(41, 'US', 'bonechewer', 'Bonechewer'),
(42, 'US', 'borean-tundra', 'Borean Tundra'),
(43, 'US', 'boulderfist', 'Boulderfist'),
(44, 'US', 'bronzebeard', 'Bronzebeard'),
(45, 'US', 'burning-blade', 'Burning Blade'),
(46, 'US', 'burning-legion', 'Burning Legion'),
(47, 'US', 'caelestrasz', 'Caelestrasz'),
(48, 'US', 'cairne', 'Cairne'),
(49, 'US', 'cenarion-circle', 'Cenarion Circle'),
(50, 'US', 'cenarius', 'Cenarius'),
(51, 'US', 'chogall', 'Cho''gall'),
(52, 'US', 'chromaggus', 'Chromaggus'),
(53, 'US', 'coilfang', 'Coilfang'),
(54, 'US', 'crushridge', 'Crushridge'),
(55, 'US', 'daggerspine', 'Daggerspine'),
(56, 'US', 'dalaran', 'Dalaran'),
(57, 'US', 'dalvengyr', 'Dalvengyr'),
(58, 'US', 'dark-iron', 'Dark Iron'),
(59, 'US', 'darkspear', 'Darkspear'),
(60, 'US', 'darrowmere', 'Darrowmere'),
(61, 'US', 'dathremar', 'Dath''Remar'),
(62, 'US', 'dawnbringer', 'Dawnbringer'),
(63, 'US', 'deathwing', 'Deathwing'),
(64, 'US', 'demon-soul', 'Demon Soul'),
(65, 'US', 'dentarg', 'Dentarg'),
(66, 'US', 'destromath', 'Destromath'),
(67, 'US', 'dethecus', 'Dethecus'),
(68, 'US', 'detheroc', 'Detheroc'),
(69, 'US', 'doomhammer', 'Doomhammer'),
(70, 'US', 'draenor', 'Draenor'),
(71, 'US', 'dragonblight', 'Dragonblight'),
(72, 'US', 'dragonmaw', 'Dragonmaw'),
(73, 'US', 'draktharon', 'Drak''Tharon'),
(74, 'US', 'drakthul', 'Drak''thul'),
(75, 'US', 'draka', 'Draka'),
(76, 'US', 'drakkari', 'Drakkari'),
(77, 'US', 'dreadmaul', 'Dreadmaul'),
(78, 'US', 'drenden', 'Drenden'),
(79, 'US', 'dunemaul', 'Dunemaul'),
(80, 'US', 'durotan', 'Durotan'),
(81, 'US', 'duskwood', 'Duskwood'),
(82, 'US', 'earthen-ring', 'Earthen Ring'),
(83, 'US', 'echo-isles', 'Echo Isles'),
(84, 'US', 'eitrigg', 'Eitrigg'),
(85, 'US', 'eldrethalas', 'Eldre''Thalas'),
(86, 'US', 'elune', 'Elune'),
(87, 'US', 'emerald-dream', 'Emerald Dream'),
(88, 'US', 'eonar', 'Eonar'),
(89, 'US', 'eredar', 'Eredar'),
(90, 'US', 'executus', 'Executus'),
(91, 'US', 'exodar', 'Exodar'),
(92, 'US', 'farstriders', 'Farstriders'),
(93, 'US', 'feathermoon', 'Feathermoon'),
(94, 'US', 'fenris', 'Fenris'),
(95, 'US', 'firetree', 'Firetree'),
(96, 'US', 'fizzcrank', 'Fizzcrank'),
(97, 'US', 'frostmane', 'Frostmane'),
(98, 'US', 'frostmourne', 'Frostmourne'),
(99, 'US', 'frostwolf', 'Frostwolf'),
(100, 'US', 'galakrond', 'Galakrond'),
(101, 'US', 'gallywix', 'Gallywix'),
(102, 'US', 'garithos', 'Garithos'),
(103, 'US', 'garona', 'Garona'),
(104, 'US', 'garrosh', 'Garrosh'),
(105, 'US', 'ghostlands', 'Ghostlands'),
(106, 'US', 'gilneas', 'Gilneas'),
(107, 'US', 'gnomeregan', 'Gnomeregan'),
(108, 'US', 'goldrinn', 'Goldrinn'),
(109, 'US', 'gorefiend', 'Gorefiend'),
(110, 'US', 'gorgonnash', 'Gorgonnash'),
(111, 'US', 'greymane', 'Greymane'),
(112, 'US', 'grizzly-hills', 'Grizzly Hills'),
(113, 'US', 'guldan', 'Gul''dan'),
(114, 'US', 'gundrak', 'Gundrak'),
(115, 'US', 'gurubashi', 'Gurubashi'),
(116, 'US', 'hakkar', 'Hakkar'),
(117, 'US', 'haomarush', 'Haomarush'),
(118, 'US', 'hellscream', 'Hellscream'),
(119, 'US', 'hydraxis', 'Hydraxis'),
(120, 'US', 'hyjal', 'Hyjal'),
(121, 'US', 'icecrown', 'Icecrown'),
(122, 'US', 'illidan', 'Illidan'),
(123, 'US', 'jaedenar', 'Jaedenar'),
(124, 'US', 'jubeithos', 'Jubei''Thos'),
(125, 'US', 'kaelthas', 'Kael''thas'),
(126, 'US', 'kalecgos', 'Kalecgos'),
(127, 'US', 'kargath', 'Kargath'),
(128, 'US', 'kelthuzad', 'Kel''Thuzad'),
(129, 'US', 'khadgar', 'Khadgar'),
(130, 'US', 'khaz-modan', 'Khaz Modan'),
(131, 'US', 'khazgoroth', 'Khaz''goroth'),
(132, 'US', 'kiljaeden', 'Kil''jaeden'),
(133, 'US', 'kilrogg', 'Kilrogg'),
(134, 'US', 'kirin-tor', 'Kirin Tor'),
(135, 'US', 'korgath', 'Korgath'),
(136, 'US', 'korialstrasz', 'Korialstrasz'),
(137, 'US', 'kul-tiras', 'Kul Tiras'),
(138, 'US', 'laughing-skull', 'Laughing Skull'),
(139, 'US', 'lethon', 'Lethon'),
(140, 'US', 'lightbringer', 'Lightbringer'),
(141, 'US', 'lightnings-blade', 'Lightning''s Blade'),
(142, 'US', 'lightninghoof', 'Lightninghoof'),
(143, 'US', 'llane', 'Llane'),
(144, 'US', 'lothar', 'Lothar'),
(145, 'US', 'madoran', 'Madoran'),
(146, 'US', 'maelstrom', 'Maelstrom'),
(147, 'US', 'magtheridon', 'Magtheridon'),
(148, 'US', 'maiev', 'Maiev'),
(149, 'US', 'malganis', 'Mal''Ganis'),
(150, 'US', 'malfurion', 'Malfurion'),
(151, 'US', 'malorne', 'Malorne'),
(152, 'US', 'malygos', 'Malygos'),
(153, 'US', 'mannoroth', 'Mannoroth'),
(154, 'US', 'medivh', 'Medivh'),
(155, 'US', 'misha', 'Misha'),
(156, 'US', 'moknathal', 'Mok''Nathal'),
(157, 'US', 'moon-guard', 'Moon Guard'),
(158, 'US', 'moonrunner', 'Moonrunner'),
(159, 'US', 'mugthol', 'Mug''thol'),
(160, 'US', 'muradin', 'Muradin'),
(161, 'US', 'nagrand', 'Nagrand'),
(162, 'US', 'nathrezim', 'Nathrezim'),
(163, 'US', 'nazgrel', 'Nazgrel'),
(164, 'US', 'nazjatar', 'Nazjatar'),
(165, 'US', 'nemesis', 'Nemesis'),
(166, 'US', 'nerzhul', 'Ner''zhul'),
(167, 'US', 'nesingwary', 'Nesingwary'),
(168, 'US', 'nordrassil', 'Nordrassil'),
(169, 'US', 'norgannon', 'Norgannon'),
(170, 'US', 'onyxia', 'Onyxia'),
(171, 'US', 'perenolde', 'Perenolde'),
(172, 'US', 'proudmoore', 'Proudmoore'),
(173, 'US', 'quelthalas', 'Quel''Thalas'),
(174, 'US', 'queldorei', 'Quel''dorei'),
(175, 'US', 'ragnaros', 'Ragnaros'),
(176, 'US', 'ravencrest', 'Ravencrest'),
(177, 'US', 'ravenholdt', 'Ravenholdt'),
(178, 'US', 'rexxar', 'Rexxar'),
(179, 'US', 'rivendare', 'Rivendare'),
(180, 'US', 'runetotem', 'Runetotem'),
(181, 'US', 'sargeras', 'Sargeras'),
(182, 'US', 'saurfang', 'Saurfang'),
(183, 'US', 'scarlet-crusade', 'Scarlet Crusade'),
(184, 'US', 'scilla', 'Scilla'),
(185, 'US', 'senjin', 'Sen''jin'),
(186, 'US', 'sentinels', 'Sentinels'),
(187, 'US', 'shadow-council', 'Shadow Council'),
(188, 'US', 'shadowmoon', 'Shadowmoon'),
(189, 'US', 'shadowsong', 'Shadowsong'),
(190, 'US', 'shandris', 'Shandris'),
(191, 'US', 'shattered-halls', 'Shattered Halls'),
(192, 'US', 'shattered-hand', 'Shattered Hand'),
(193, 'US', 'shuhalo', 'Shu''halo'),
(194, 'US', 'silver-hand', 'Silver Hand'),
(195, 'US', 'silvermoon', 'Silvermoon'),
(196, 'US', 'sisters-of-elune', 'Sisters of Elune'),
(197, 'US', 'skullcrusher', 'Skullcrusher'),
(198, 'US', 'skywall', 'Skywall'),
(199, 'US', 'smolderthorn', 'Smolderthorn'),
(200, 'US', 'spinebreaker', 'Spinebreaker'),
(201, 'US', 'spirestone', 'Spirestone'),
(202, 'US', 'staghelm', 'Staghelm'),
(203, 'US', 'steamwheedle-cartel', 'Steamwheedle Cartel'),
(204, 'US', 'stonemaul', 'Stonemaul'),
(205, 'US', 'stormrage', 'Stormrage'),
(206, 'US', 'stormreaver', 'Stormreaver'),
(207, 'US', 'stormscale', 'Stormscale'),
(208, 'US', 'suramar', 'Suramar'),
(209, 'US', 'tanaris', 'Tanaris'),
(210, 'US', 'terenas', 'Terenas'),
(211, 'US', 'terokkar', 'Terokkar'),
(212, 'US', 'thaurissan', 'Thaurissan'),
(213, 'US', 'the-forgotten-coast', 'The Forgotten Coast'),
(214, 'US', 'the-scryers', 'The Scryers'),
(215, 'US', 'the-underbog', 'The Underbog'),
(216, 'US', 'the-venture-co', 'The Venture Co'),
(217, 'US', 'thorium-brotherhood', 'Thorium Brotherhood'),
(218, 'US', 'thrall', 'Thrall'),
(219, 'US', 'thunderhorn', 'Thunderhorn'),
(220, 'US', 'thunderlord', 'Thunderlord'),
(221, 'US', 'tichondrius', 'Tichondrius'),
(222, 'US', 'tol-barad', 'Tol Barad'),
(223, 'US', 'tortheldrin', 'Tortheldrin'),
(224, 'US', 'trollbane', 'Trollbane'),
(225, 'US', 'turalyon', 'Turalyon'),
(226, 'US', 'twisting-nether', 'Twisting Nether'),
(227, 'US', 'uldaman', 'Uldaman'),
(228, 'US', 'uldum', 'Uldum'),
(229, 'US', 'undermine', 'Undermine'),
(230, 'US', 'ursin', 'Ursin'),
(231, 'US', 'uther', 'Uther'),
(232, 'US', 'vashj', 'Vashj'),
(233, 'US', 'veknilash', 'Vek''nilash'),
(234, 'US', 'velen', 'Velen'),
(235, 'US', 'warsong', 'Warsong'),
(236, 'US', 'whisperwind', 'Whisperwind'),
(237, 'US', 'wildhammer', 'Wildhammer'),
(238, 'US', 'windrunner', 'Windrunner'),
(239, 'US', 'winterhoof', 'Winterhoof'),
(240, 'US', 'wyrmrest-accord', 'Wyrmrest Accord'),
(241, 'US', 'xavius', 'Xavius'),
(242, 'US', 'ysera', 'Ysera'),
(243, 'US', 'ysondre', 'Ysondre'),
(244, 'US', 'zangarmarsh', 'Zangarmarsh'),
(245, 'US', 'zuljin', 'Zul''jin'),
(246, 'US', 'zuluhed', 'Zuluhed'),
(247, 'EU', 'aegwynn', 'Aegwynn'),
(248, 'EU', 'aerie-peak', 'Aerie Peak'),
(249, 'EU', 'agamaggan', 'Agamaggan'),
(250, 'EU', 'aggra-portugues', 'Aggra (Português)'),
(251, 'EU', 'aggramar', 'Aggramar'),
(252, 'EU', 'ahnqiraj', 'Ahn''Qiraj'),
(253, 'EU', 'alakir', 'Al''Akir'),
(254, 'EU', 'alexstrasza', 'Alexstrasza'),
(255, 'EU', 'alleria', 'Alleria'),
(256, 'EU', 'alonsus', 'Alonsus'),
(257, 'EU', 'amanthul', 'Aman''Thul'),
(258, 'EU', 'ambossar', 'Ambossar'),
(259, 'EU', 'anachronos', 'Anachronos'),
(260, 'EU', 'anetheron', 'Anetheron'),
(261, 'EU', 'antonidas', 'Antonidas'),
(262, 'EU', 'anubarak', 'Anub''arak'),
(263, 'EU', 'arakarahm', 'Arak-arahm'),
(264, 'EU', 'arathi', 'Arathi'),
(265, 'EU', 'arathor', 'Arathor'),
(266, 'EU', 'archimonde', 'Archimonde'),
(267, 'EU', 'area-52', 'Area 52'),
(268, 'EU', 'argent-dawn', 'Argent Dawn'),
(269, 'EU', 'arthas', 'Arthas'),
(270, 'EU', 'arygos', 'Arygos'),
(271, 'EU', 'ashenvale', 'Ashenvale'),
(272, 'EU', 'aszune', 'Aszune'),
(273, 'EU', 'auchindoun', 'Auchindoun'),
(274, 'EU', 'azjolnerub', 'Azjol-Nerub'),
(275, 'EU', 'azshara', 'Azshara'),
(276, 'EU', 'azuregos', 'Azuregos'),
(277, 'EU', 'azuremyst', 'Azuremyst'),
(278, 'EU', 'baelgun', 'Baelgun'),
(279, 'EU', 'balnazzar', 'Balnazzar'),
(280, 'EU', 'blackhand', 'Blackhand'),
(281, 'EU', 'blackmoore', 'Blackmoore'),
(282, 'EU', 'blackrock', 'Blackrock'),
(283, 'EU', 'blackscar', 'Blackscar'),
(284, 'EU', 'blades-edge', 'Blade''s Edge'),
(285, 'EU', 'bladefist', 'Bladefist'),
(286, 'EU', 'bloodfeather', 'Bloodfeather'),
(287, 'EU', 'bloodhoof', 'Bloodhoof'),
(288, 'EU', 'bloodscalp', 'Bloodscalp'),
(289, 'EU', 'blutkessel', 'Blutkessel'),
(290, 'EU', 'booty-bay', 'Booty Bay'),
(291, 'EU', 'borean-tundra', 'Borean Tundra'),
(292, 'EU', 'boulderfist', 'Boulderfist'),
(293, 'EU', 'bronze-dragonflight', 'Bronze Dragonflight'),
(294, 'EU', 'bronzebeard', 'Bronzebeard'),
(295, 'EU', 'burning-blade', 'Burning Blade'),
(296, 'EU', 'burning-steppes', 'Burning Steppes'),
(297, 'EU', 'cthun', 'C''Thun'),
(298, 'EU', 'chamber-of-aspects', 'Chamber of Aspects'),
(299, 'EU', 'chants-eternels', 'Chants éternels'),
(300, 'EU', 'chogall', 'Cho''gall'),
(301, 'EU', 'chromaggus', 'Chromaggus'),
(302, 'EU', 'colinas-pardas', 'Colinas Pardas'),
(303, 'EU', 'confrerie-du-thorium', 'Confrérie du Thorium'),
(304, 'EU', 'conseil-des-ombres', 'Conseil des Ombres'),
(305, 'EU', 'crushridge', 'Crushridge'),
(306, 'EU', 'culte-de-la-rive-noire', 'Culte de la Rive noire'),
(307, 'EU', 'daggerspine', 'Daggerspine'),
(308, 'EU', 'dalaran', 'Dalaran'),
(309, 'EU', 'dalvengyr', 'Dalvengyr'),
(310, 'EU', 'darkmoon-faire', 'Darkmoon Faire'),
(311, 'EU', 'darksorrow', 'Darksorrow'),
(312, 'EU', 'darkspear', 'Darkspear'),
(313, 'EU', 'das-konsortium', 'Das Konsortium'),
(314, 'EU', 'das-syndikat', 'Das Syndikat'),
(315, 'EU', 'deathguard', 'Deathguard'),
(316, 'EU', 'deathweaver', 'Deathweaver'),
(317, 'EU', 'deathwing', 'Deathwing'),
(318, 'EU', 'deepholm', 'Deepholm'),
(319, 'EU', 'defias-brotherhood', 'Defias Brotherhood'),
(320, 'EU', 'dentarg', 'Dentarg'),
(321, 'EU', 'der-mithrilorden', 'Der Mithrilorden'),
(322, 'EU', 'der-rat-von-dalaran', 'Der Rat von Dalaran'),
(323, 'EU', 'der-abyssische-rat', 'Der abyssische Rat'),
(324, 'EU', 'destromath', 'Destromath'),
(325, 'EU', 'dethecus', 'Dethecus'),
(326, 'EU', 'die-aldor', 'Die Aldor'),
(327, 'EU', 'die-arguswacht', 'Die Arguswacht'),
(328, 'EU', 'die-nachtwache', 'Die Nachtwache'),
(329, 'EU', 'die-silberne-hand', 'Die Silberne Hand'),
(330, 'EU', 'die-todeskrallen', 'Die Todeskrallen'),
(331, 'EU', 'die-ewige-wacht', 'Die ewige Wacht'),
(332, 'EU', 'doomhammer', 'Doomhammer'),
(333, 'EU', 'draenor', 'Draenor'),
(334, 'EU', 'dragonblight', 'Dragonblight'),
(335, 'EU', 'dragonmaw', 'Dragonmaw'),
(336, 'EU', 'drakthul', 'Drak''thul'),
(337, 'EU', 'drekthar', 'Drek''Thar'),
(338, 'EU', 'dun-modr', 'Dun Modr'),
(339, 'EU', 'dun-morogh', 'Dun Morogh'),
(340, 'EU', 'dunemaul', 'Dunemaul'),
(341, 'EU', 'durotan', 'Durotan'),
(342, 'EU', 'earthen-ring', 'Earthen Ring'),
(343, 'EU', 'echsenkessel', 'Echsenkessel'),
(344, 'EU', 'eitrigg', 'Eitrigg'),
(345, 'EU', 'eldrethalas', 'Eldre''Thalas'),
(346, 'EU', 'elune', 'Elune'),
(347, 'EU', 'emerald-dream', 'Emerald Dream'),
(348, 'EU', 'emeriss', 'Emeriss'),
(349, 'EU', 'eonar', 'Eonar'),
(350, 'EU', 'eredar', 'Eredar'),
(351, 'EU', 'eversong', 'Eversong'),
(352, 'EU', 'executus', 'Executus'),
(353, 'EU', 'exodar', 'Exodar'),
(354, 'EU', 'festung-der-sturme', 'Festung der Stürme'),
(355, 'EU', 'fordragon', 'Fordragon'),
(356, 'EU', 'forscherliga', 'Forscherliga'),
(357, 'EU', 'frostmane', 'Frostmane'),
(358, 'EU', 'frostmourne', 'Frostmourne'),
(359, 'EU', 'frostwhisper', 'Frostwhisper'),
(360, 'EU', 'frostwolf', 'Frostwolf'),
(361, 'EU', 'galakrond', 'Galakrond'),
(362, 'EU', 'garona', 'Garona'),
(363, 'EU', 'garrosh', 'Garrosh'),
(364, 'EU', 'genjuros', 'Genjuros'),
(365, 'EU', 'ghostlands', 'Ghostlands'),
(366, 'EU', 'gilneas', 'Gilneas'),
(367, 'EU', 'goldrinn', 'Goldrinn'),
(368, 'EU', 'gordunni', 'Gordunni'),
(369, 'EU', 'gorgonnash', 'Gorgonnash'),
(370, 'EU', 'greymane', 'Greymane'),
(371, 'EU', 'grim-batol', 'Grim Batol'),
(372, 'EU', 'grom', 'Grom'),
(373, 'EU', 'guldan', 'Gul''dan'),
(374, 'EU', 'hakkar', 'Hakkar'),
(375, 'EU', 'haomarush', 'Haomarush'),
(376, 'EU', 'hellfire', 'Hellfire'),
(377, 'EU', 'hellscream', 'Hellscream'),
(378, 'EU', 'howling-fjord', 'Howling Fjord'),
(379, 'EU', 'hyjal', 'Hyjal'),
(380, 'EU', 'illidan', 'Illidan'),
(381, 'EU', 'jaedenar', 'Jaedenar'),
(382, 'EU', 'kaelthas', 'Kael''thas'),
(383, 'EU', 'karazhan', 'Karazhan'),
(384, 'EU', 'kargath', 'Kargath'),
(385, 'EU', 'kazzak', 'Kazzak'),
(386, 'EU', 'kelthuzad', 'Kel''Thuzad'),
(387, 'EU', 'khadgar', 'Khadgar'),
(388, 'EU', 'khaz-modan', 'Khaz Modan'),
(389, 'EU', 'khazgoroth', 'Khaz''goroth'),
(390, 'EU', 'kiljaeden', 'Kil''jaeden'),
(391, 'EU', 'kilrogg', 'Kilrogg'),
(392, 'EU', 'kirin-tor', 'Kirin Tor'),
(393, 'EU', 'korgall', 'Kor''gall'),
(394, 'EU', 'kragjin', 'Krag''jin'),
(395, 'EU', 'krasus', 'Krasus'),
(396, 'EU', 'kul-tiras', 'Kul Tiras'),
(397, 'EU', 'kult-der-verdammten', 'Kult der Verdammten'),
(398, 'EU', 'la-croisade-ecarlate', 'La Croisade écarlate'),
(399, 'EU', 'laughing-skull', 'Laughing Skull'),
(400, 'EU', 'les-clairvoyants', 'Les Clairvoyants'),
(401, 'EU', 'les-sentinelles', 'Les Sentinelles'),
(402, 'EU', 'lich-king', 'Lich King'),
(403, 'EU', 'lightbringer', 'Lightbringer'),
(404, 'EU', 'lightnings-blade', 'Lightning''s Blade'),
(405, 'EU', 'lordaeron', 'Lordaeron'),
(406, 'EU', 'los-errantes', 'Los Errantes'),
(407, 'EU', 'lothar', 'Lothar'),
(408, 'EU', 'madmortem', 'Madmortem'),
(409, 'EU', 'magtheridon', 'Magtheridon'),
(410, 'EU', 'malganis', 'Mal''Ganis'),
(411, 'EU', 'malfurion', 'Malfurion'),
(412, 'EU', 'malorne', 'Malorne'),
(413, 'EU', 'malygos', 'Malygos'),
(414, 'EU', 'mannoroth', 'Mannoroth'),
(415, 'EU', 'marecage-de-zangar', 'Marécage de Zangar'),
(416, 'EU', 'mazrigos', 'Mazrigos'),
(417, 'EU', 'medivh', 'Medivh'),
(418, 'EU', 'minahonda', 'Minahonda'),
(419, 'EU', 'moonglade', 'Moonglade'),
(420, 'EU', 'mugthol', 'Mug''thol'),
(421, 'EU', 'nagrand', 'Nagrand'),
(422, 'EU', 'nathrezim', 'Nathrezim'),
(423, 'EU', 'naxxramas', 'Naxxramas'),
(424, 'EU', 'nazjatar', 'Nazjatar'),
(425, 'EU', 'nefarian', 'Nefarian'),
(426, 'EU', 'nemesis', 'Nemesis'),
(427, 'EU', 'neptulon', 'Neptulon'),
(428, 'EU', 'nerzhul', 'Ner''zhul'),
(429, 'EU', 'nerathor', 'Nera''thor'),
(430, 'EU', 'nethersturm', 'Nethersturm'),
(431, 'EU', 'nordrassil', 'Nordrassil'),
(432, 'EU', 'norgannon', 'Norgannon'),
(433, 'EU', 'nozdormu', 'Nozdormu'),
(434, 'EU', 'onyxia', 'Onyxia'),
(435, 'EU', 'outland', 'Outland'),
(436, 'EU', 'perenolde', 'Perenolde'),
(437, 'EU', 'pozzo-delleternita', 'Pozzo dell''Eternità'),
(438, 'EU', 'proudmoore', 'Proudmoore'),
(439, 'EU', 'quelthalas', 'Quel''Thalas'),
(440, 'EU', 'ragnaros', 'Ragnaros'),
(441, 'EU', 'rajaxx', 'Rajaxx'),
(442, 'EU', 'rashgarroth', 'Rashgarroth'),
(443, 'EU', 'ravencrest', 'Ravencrest'),
(444, 'EU', 'ravenholdt', 'Ravenholdt'),
(445, 'EU', 'razuvious', 'Razuvious'),
(446, 'EU', 'rexxar', 'Rexxar'),
(447, 'EU', 'runetotem', 'Runetotem'),
(448, 'EU', 'sanguino', 'Sanguino'),
(449, 'EU', 'sargeras', 'Sargeras'),
(450, 'EU', 'saurfang', 'Saurfang'),
(451, 'EU', 'scarshield-legion', 'Scarshield Legion'),
(452, 'EU', 'senjin', 'Sen''jin'),
(453, 'EU', 'shadowsong', 'Shadowsong'),
(454, 'EU', 'shattered-halls', 'Shattered Halls'),
(455, 'EU', 'shattered-hand', 'Shattered Hand'),
(456, 'EU', 'shattrath', 'Shattrath'),
(457, 'EU', 'shendralar', 'Shen''dralar'),
(458, 'EU', 'silvermoon', 'Silvermoon'),
(459, 'EU', 'sinstralis', 'Sinstralis'),
(460, 'EU', 'skullcrusher', 'Skullcrusher'),
(461, 'EU', 'soulflayer', 'Soulflayer'),
(462, 'EU', 'spinebreaker', 'Spinebreaker'),
(463, 'EU', 'sporeggar', 'Sporeggar'),
(464, 'EU', 'steamwheedle-cartel', 'Steamwheedle Cartel'),
(465, 'EU', 'stormrage', 'Stormrage'),
(466, 'EU', 'stormreaver', 'Stormreaver'),
(467, 'EU', 'stormscale', 'Stormscale'),
(468, 'EU', 'sunstrider', 'Sunstrider'),
(469, 'EU', 'sylvanas', 'Sylvanas'),
(470, 'EU', 'taerar', 'Taerar'),
(471, 'EU', 'talnivarr', 'Talnivarr'),
(472, 'EU', 'tarren-mill', 'Tarren Mill'),
(473, 'EU', 'teldrassil', 'Teldrassil'),
(474, 'EU', 'temple-noir', 'Temple noir'),
(475, 'EU', 'terenas', 'Terenas'),
(476, 'EU', 'terokkar', 'Terokkar'),
(477, 'EU', 'terrordar', 'Terrordar'),
(478, 'EU', 'the-maelstrom', 'The Maelstrom'),
(479, 'EU', 'the-shatar', 'The Sha''tar'),
(480, 'EU', 'the-venture-co', 'The Venture Co'),
(481, 'EU', 'theradras', 'Theradras'),
(482, 'EU', 'thermaplugg', 'Thermaplugg'),
(483, 'EU', 'thrall', 'Thrall'),
(484, 'EU', 'throkferoth', 'Throk''Feroth'),
(485, 'EU', 'thunderhorn', 'Thunderhorn'),
(486, 'EU', 'tichondrius', 'Tichondrius'),
(487, 'EU', 'tirion', 'Tirion'),
(488, 'EU', 'todeswache', 'Todeswache'),
(489, 'EU', 'trollbane', 'Trollbane'),
(490, 'EU', 'turalyon', 'Turalyon'),
(491, 'EU', 'twilights-hammer', 'Twilight''s Hammer'),
(492, 'EU', 'twisting-nether', 'Twisting Nether'),
(493, 'EU', 'tyrande', 'Tyrande'),
(494, 'EU', 'uldaman', 'Uldaman'),
(495, 'EU', 'ulduar', 'Ulduar'),
(496, 'EU', 'uldum', 'Uldum'),
(497, 'EU', 'ungoro', 'Un''Goro'),
(498, 'EU', 'varimathras', 'Varimathras'),
(499, 'EU', 'vashj', 'Vashj'),
(500, 'EU', 'veklor', 'Vek''lor'),
(501, 'EU', 'veknilash', 'Vek''nilash'),
(502, 'EU', 'voljin', 'Vol''jin'),
(503, 'EU', 'wildhammer', 'Wildhammer'),
(504, 'EU', 'wrathbringer', 'Wrathbringer'),
(505, 'EU', 'xavius', 'Xavius'),
(506, 'EU', 'ysera', 'Ysera'),
(507, 'EU', 'ysondre', 'Ysondre'),
(508, 'EU', 'zenedar', 'Zenedar'),
(509, 'EU', 'zirkel-des-cenarius', 'Zirkel des Cenarius'),
(510, 'EU', 'zuljin', 'Zul''jin'),
(511, 'EU', 'zuluhed', 'Zuluhed'),
(512, 'US', 'anvilmar', 'Anvilmar'),
(514, 'US', 'blackmoore', 'Blackmoore'),
(526, 'US', 'naxxramas', 'Naxxramas'),
(527, 'US', 'theradras', 'Theradras'),
(528, 'US', 'ulduar', 'Ulduar'),
(529, 'EU', 'arena-pass', 'Arena Pass'),
(530, 'EU', 'arena-pass-1', 'Arena Pass 1'),
(531, 'EU', 'burning-legion', 'Burning Legion'),
(532, 'EU', 'caduta-dei-draghi', 'Caduta dei Draghi'),
(533, 'EU', 'cerchio-del-sangue', 'Cerchio del Sangue'),
(534, 'EU', 'euskal-encounter', 'Euskal Encounter'),
(536, 'EU', 'gnomeregan', 'Gnomeregan'),
(537, 'EU', 'grizzlyhugel', 'Grizzlyhügel'),
(557, 'EU', 'menethil', 'Menethil'),
(558, 'EU', 'molten-core', 'Molten Core'),
(559, 'EU', 'muradin', 'Muradin'),
(560, 'EU', 'schwarznarbe', 'Schwarznarbe'),
(561, 'EU', 'stonemaul', 'Stonemaul'),
(562, 'EU', 'suramar', 'Suramar'),
(563, 'EU', 'winterhuf', 'Winterhuf'),
(565, 'CN', '万色星辰', '万色星辰'),
(566, 'CN', '世界之树', '世界之树'),
(567, 'CN', '丹莫德', '丹莫德'),
(568, 'CN', '主宰之剑', '主宰之剑'),
(569, 'CN', '丽丽（四川）', '丽丽（四川）'),
(570, 'CN', '亚雷戈斯', '亚雷戈斯'),
(571, 'CN', '亡语者', '亡语者'),
(572, 'CN', '伊兰尼库斯', '伊兰尼库斯'),
(573, 'CN', '伊利丹', '伊利丹'),
(574, 'CN', '伊森利恩', '伊森利恩'),
(575, 'CN', '伊森德雷', '伊森德雷'),
(576, 'CN', '伊瑟拉', '伊瑟拉'),
(577, 'CN', '伊莫塔尔', '伊莫塔尔'),
(578, 'CN', '伊萨里奥斯', '伊萨里奥斯'),
(579, 'CN', '元素之力', '元素之力'),
(580, 'CN', '克尔苏加德', '克尔苏加德'),
(581, 'CN', '克洛玛古斯', '克洛玛古斯'),
(582, 'CN', '克苏恩', '克苏恩'),
(583, 'CN', '军团要塞', '军团要塞'),
(584, 'CN', '冬拥湖', '冬拥湖'),
(585, 'CN', '冬泉谷', '冬泉谷'),
(586, 'CN', '冰川之拳', '冰川之拳'),
(587, 'CN', '冰霜之刃', '冰霜之刃'),
(588, 'CN', '冰风岗', '冰风岗'),
(589, 'CN', '凤凰之神', '凤凰之神'),
(590, 'CN', '凯尔萨斯', '凯尔萨斯'),
(591, 'CN', '凯恩血蹄', '凯恩血蹄'),
(592, 'CN', '利刃之拳', '利刃之拳'),
(593, 'CN', '刺骨利刃', '刺骨利刃'),
(594, 'CN', '加兹鲁维', '加兹鲁维'),
(595, 'CN', '加基森', '加基森'),
(596, 'CN', '加尔', '加尔'),
(597, 'CN', '加里索斯', '加里索斯'),
(598, 'CN', '勇士岛', '勇士岛'),
(599, 'CN', '千针石林', '千针石林'),
(600, 'CN', '卡德加', '卡德加'),
(601, 'CN', '卡德罗斯', '卡德罗斯'),
(602, 'CN', '卡扎克', '卡扎克'),
(603, 'CN', '卡拉赞', '卡拉赞'),
(604, 'CN', '卡珊德拉', '卡珊德拉'),
(605, 'CN', '厄祖玛特', '厄祖玛特'),
(606, 'CN', '古加尔', '古加尔'),
(607, 'CN', '古尔丹', '古尔丹'),
(608, 'CN', '古拉巴什', '古拉巴什'),
(609, 'CN', '古达克', '古达克'),
(610, 'CN', '哈兰', '哈兰'),
(611, 'CN', '哈卡', '哈卡'),
(612, 'CN', '嚎风峡湾', '嚎风峡湾'),
(613, 'CN', '回音山', '回音山'),
(614, 'CN', '国王之谷', '国王之谷'),
(615, 'CN', '图拉扬', '图拉扬'),
(616, 'CN', '圣火神殿', '圣火神殿'),
(617, 'CN', '地狱之石', '地狱之石'),
(618, 'CN', '地狱咆哮', '地狱咆哮'),
(619, 'CN', '埃克索图斯', '埃克索图斯'),
(620, 'CN', '埃加洛尔', '埃加洛尔'),
(621, 'CN', '埃基尔松', '埃基尔松'),
(622, 'CN', '埃德萨拉', '埃德萨拉'),
(623, 'CN', '埃苏雷格', '埃苏雷格'),
(624, 'CN', '埃雷达尔', '埃雷达尔'),
(625, 'CN', '基尔加丹', '基尔加丹'),
(626, 'CN', '基尔罗格', '基尔罗格'),
(627, 'CN', '塔纳利斯', '塔纳利斯'),
(628, 'CN', '塞拉摩', '塞拉摩'),
(629, 'CN', '塞拉赞恩', '塞拉赞恩'),
(630, 'CN', '塞泰克', '塞泰克'),
(631, 'CN', '塞纳里奥', '塞纳里奥'),
(632, 'CN', '壁炉谷', '壁炉谷'),
(633, 'CN', '夏维安', '夏维安'),
(634, 'CN', '外域', '外域'),
(635, 'CN', '大地之怒', '大地之怒'),
(636, 'CN', '大漩涡', '大漩涡'),
(637, 'CN', '天空之墙', '天空之墙'),
(638, 'CN', '天谴之门', '天谴之门'),
(639, 'CN', '太阳之井', '太阳之井'),
(640, 'CN', '夺灵者', '夺灵者'),
(641, 'CN', '奈法利安', '奈法利安'),
(642, 'CN', '奈萨里奥', '奈萨里奥'),
(643, 'CN', '奎尔丹纳斯', '奎尔丹纳斯'),
(644, 'CN', '奎尔萨拉斯', '奎尔萨拉斯'),
(645, 'CN', '奥妮克希亚', '奥妮克希亚'),
(646, 'CN', '奥尔加隆', '奥尔加隆'),
(647, 'CN', '奥拉基尔', '奥拉基尔'),
(648, 'CN', '奥斯里安', '奥斯里安'),
(649, 'CN', '奥杜尔', '奥杜尔'),
(650, 'CN', '奥特兰克', '奥特兰克'),
(651, 'CN', '奥蕾莉亚', '奥蕾莉亚'),
(652, 'CN', '奥达曼', '奥达曼'),
(653, 'CN', '守护之剑', '守护之剑'),
(654, 'CN', '安东尼达斯', '安东尼达斯'),
(655, 'CN', '安其拉', '安其拉'),
(656, 'CN', '安加萨', '安加萨'),
(657, 'CN', '安威玛尔', '安威玛尔'),
(658, 'CN', '安戈洛', '安戈洛'),
(659, 'CN', '安格博达', '安格博达'),
(660, 'CN', '安纳塞隆', '安纳塞隆'),
(661, 'CN', '安苏', '安苏'),
(662, 'CN', '密林游侠', '密林游侠'),
(663, 'CN', '寒冰皇冠', '寒冰皇冠'),
(664, 'CN', '尘风峡谷', '尘风峡谷'),
(665, 'CN', '屠魔山谷', '屠魔山谷'),
(666, 'CN', '山丘之王', '山丘之王'),
(667, 'CN', '巨龙之吼', '巨龙之吼'),
(668, 'CN', '巫妖之王', '巫妖之王'),
(669, 'CN', '巴尔古恩', '巴尔古恩'),
(670, 'CN', '巴瑟拉斯', '巴瑟拉斯'),
(671, 'CN', '巴纳扎尔', '巴纳扎尔'),
(672, 'CN', '布兰卡德', '布兰卡德'),
(673, 'CN', '布莱克摩', '布莱克摩'),
(674, 'CN', '布莱恩', '布莱恩'),
(675, 'CN', '布鲁塔卢斯', '布鲁塔卢斯'),
(676, 'CN', '希尔瓦娜斯', '希尔瓦娜斯'),
(677, 'CN', '希雷诺斯', '希雷诺斯'),
(678, 'CN', '幽暗沼泽', '幽暗沼泽'),
(679, 'CN', '库尔提拉斯', '库尔提拉斯'),
(680, 'CN', '库德兰', '库德兰'),
(681, 'CN', '弗塞雷迦', '弗塞雷迦'),
(682, 'CN', '影之哀伤', '影之哀伤'),
(683, 'CN', '影牙要塞', '影牙要塞'),
(684, 'CN', '德拉诺', '德拉诺'),
(685, 'CN', '恐怖图腾', '恐怖图腾'),
(686, 'CN', '恶魔之翼', '恶魔之翼'),
(687, 'CN', '恶魔之魂', '恶魔之魂'),
(688, 'CN', '戈古纳斯', '戈古纳斯'),
(689, 'CN', '戈提克', '戈提克'),
(690, 'CN', '战歌', '战歌'),
(691, 'CN', '扎拉赞恩', '扎拉赞恩'),
(692, 'CN', '托塞德林', '托塞德林'),
(693, 'CN', '托尔巴拉德', '托尔巴拉德'),
(694, 'CN', '拉文凯斯', '拉文凯斯'),
(695, 'CN', '拉文霍德', '拉文霍德'),
(696, 'CN', '拉格纳洛斯', '拉格纳洛斯'),
(697, 'CN', '拉贾克斯', '拉贾克斯'),
(698, 'CN', '提尔之手', '提尔之手'),
(699, 'CN', '提瑞斯法', '提瑞斯法'),
(700, 'CN', '摩摩尔', '摩摩尔'),
(701, 'CN', '斩魔者', '斩魔者'),
(702, 'CN', '斯坦索姆', '斯坦索姆'),
(703, 'CN', '无尽之海', '无尽之海'),
(704, 'CN', '无底海渊', '无底海渊'),
(705, 'CN', '日落沼泽', '日落沼泽'),
(706, 'CN', '时光之穴', '时光之穴'),
(707, 'CN', '普瑞斯托', '普瑞斯托'),
(708, 'CN', '普罗德摩', '普罗德摩'),
(709, 'CN', '晴日峰（江苏）', '晴日峰（江苏）'),
(710, 'CN', '暗影之月', '暗影之月'),
(711, 'CN', '暗影裂口', '暗影裂口'),
(712, 'CN', '暗影议会', '暗影议会'),
(713, 'CN', '暗影迷宫', '暗影迷宫'),
(714, 'CN', '暮色森林', '暮色森林'),
(715, 'CN', '暴风祭坛', '暴风祭坛'),
(716, 'CN', '月光林地', '月光林地'),
(717, 'CN', '月神殿', '月神殿'),
(718, 'CN', '末日祷告祭坛', '末日祷告祭坛'),
(719, 'CN', '末日行者', '末日行者'),
(720, 'CN', '朵丹尼尔', '朵丹尼尔'),
(721, 'CN', '杜隆坦', '杜隆坦'),
(722, 'CN', '格瑞姆巴托', '格瑞姆巴托'),
(723, 'CN', '格雷迈恩', '格雷迈恩'),
(724, 'CN', '格鲁尔', '格鲁尔'),
(725, 'CN', '桑德兰', '桑德兰'),
(726, 'CN', '梅尔加尼', '梅尔加尼'),
(727, 'CN', '梦境之树', '梦境之树'),
(728, 'CN', '森金', '森金'),
(729, 'CN', '死亡之翼', '死亡之翼'),
(730, 'CN', '死亡熔炉', '死亡熔炉'),
(731, 'CN', '毁灭之锤', '毁灭之锤'),
(732, 'CN', '永夜港', '永夜港'),
(733, 'CN', '永恒之井', '永恒之井'),
(734, 'CN', '沃金', '沃金'),
(735, 'CN', '沙怒', '沙怒'),
(736, 'CN', '法拉希姆', '法拉希姆'),
(737, 'CN', '泰兰德', '泰兰德'),
(738, 'CN', '泰拉尔', '泰拉尔'),
(739, 'CN', '洛丹伦', '洛丹伦'),
(740, 'CN', '洛肯', '洛肯'),
(741, 'CN', '洛萨', '洛萨'),
(742, 'CN', '海克泰尔', '海克泰尔'),
(743, 'CN', '海加尔', '海加尔'),
(744, 'CN', '海达希亚', '海达希亚'),
(745, 'CN', '深渊之喉', '深渊之喉'),
(746, 'CN', '深渊之巢', '深渊之巢'),
(747, 'CN', '激流之傲', '激流之傲'),
(748, 'CN', '激流堡', '激流堡'),
(749, 'CN', '火喉', '火喉'),
(750, 'CN', '火烟之谷', '火烟之谷'),
(751, 'CN', '火焰之树', '火焰之树'),
(752, 'CN', '火羽山', '火羽山'),
(753, 'CN', '灰谷', '灰谷'),
(754, 'CN', '烈焰峰', '烈焰峰'),
(755, 'CN', '烈焰荆棘', '烈焰荆棘'),
(756, 'CN', '熊猫酒仙', '熊猫酒仙'),
(757, 'CN', '熔火之心', '熔火之心'),
(758, 'CN', '熵魔', '熵魔'),
(759, 'CN', '燃烧之刃', '燃烧之刃'),
(760, 'CN', '燃烧军团', '燃烧军团'),
(761, 'CN', '燃烧平原', '燃烧平原'),
(762, 'CN', '爱斯特纳', '爱斯特纳'),
(763, 'CN', '狂热之刃', '狂热之刃'),
(764, 'CN', '狂风峭壁', '狂风峭壁'),
(765, 'CN', '玛多兰', '玛多兰'),
(766, 'CN', '玛法里奥', '玛法里奥'),
(767, 'CN', '玛洛加尔', '玛洛加尔'),
(768, 'CN', '玛瑟里顿', '玛瑟里顿'),
(769, 'CN', '玛诺洛斯', '玛诺洛斯'),
(770, 'CN', '玛里苟斯', '玛里苟斯'),
(771, 'CN', '瑞文戴尔', '瑞文戴尔'),
(772, 'CN', '瑟莱德丝', '瑟莱德丝'),
(773, 'CN', '瓦丝琪', '瓦丝琪'),
(774, 'CN', '瓦拉斯塔兹', '瓦拉斯塔兹'),
(775, 'CN', '瓦拉纳', '瓦拉纳'),
(776, 'CN', '瓦里玛萨斯', '瓦里玛萨斯'),
(777, 'CN', '甜水绿洲', '甜水绿洲'),
(778, 'CN', '生态船', '生态船'),
(779, 'CN', '白银之手', '白银之手'),
(780, 'CN', '白骨荒野', '白骨荒野'),
(781, 'CN', '盖斯', '盖斯'),
(782, 'CN', '石爪峰', '石爪峰'),
(783, 'CN', '石锤', '石锤'),
(784, 'CN', '破碎岭', '破碎岭'),
(785, 'CN', '祖尔金', '祖尔金'),
(786, 'CN', '祖达克', '祖达克'),
(787, 'CN', '祖阿曼', '祖阿曼'),
(788, 'CN', '神圣之歌', '神圣之歌'),
(789, 'CN', '穆戈尔', '穆戈尔'),
(790, 'CN', '符文图腾', '符文图腾'),
(791, 'CN', '米奈希尔', '米奈希尔'),
(792, 'CN', '索拉丁', '索拉丁'),
(793, 'CN', '索瑞森', '索瑞森'),
(794, 'CN', '红云台地', '红云台地'),
(795, 'CN', '红龙军团', '红龙军团'),
(796, 'CN', '红龙女王', '红龙女王'),
(797, 'CN', '纳克萨玛斯', '纳克萨玛斯'),
(798, 'CN', '纳沙塔尔', '纳沙塔尔'),
(799, 'CN', '织亡者', '织亡者'),
(800, 'CN', '罗宁', '罗宁'),
(801, 'CN', '羽月', '羽月'),
(802, 'CN', '翡翠梦境', '翡翠梦境'),
(803, 'CN', '耐奥祖', '耐奥祖'),
(804, 'CN', '耐普图隆', '耐普图隆'),
(805, 'CN', '耳语海岸', '耳语海岸'),
(806, 'CN', '能源舰', '能源舰'),
(807, 'CN', '自由之风', '自由之风'),
(808, 'CN', '艾森娜', '艾森娜'),
(809, 'CN', '艾欧纳尔', '艾欧纳尔'),
(810, 'CN', '艾维娜', '艾维娜'),
(811, 'CN', '艾苏恩', '艾苏恩'),
(812, 'CN', '艾莫莉丝', '艾莫莉丝'),
(813, 'CN', '艾萨拉', '艾萨拉'),
(814, 'CN', '艾露恩', '艾露恩'),
(815, 'CN', '芬里斯', '芬里斯'),
(816, 'CN', '苏塔恩', '苏塔恩'),
(817, 'CN', '范克里夫', '范克里夫'),
(818, 'CN', '范达尔鹿盔', '范达尔鹿盔'),
(819, 'CN', '荆棘谷', '荆棘谷'),
(820, 'CN', '莱索恩', '莱索恩'),
(821, 'CN', '菲拉斯', '菲拉斯'),
(822, 'CN', '菲米丝', '菲米丝'),
(823, 'CN', '萨尔', '萨尔'),
(824, 'CN', '萨格拉斯', '萨格拉斯'),
(825, 'CN', '萨洛拉丝', '萨洛拉丝'),
(826, 'CN', '萨菲隆', '萨菲隆'),
(827, 'CN', '蓝龙军团', '蓝龙军团'),
(828, 'CN', '藏宝海湾', '藏宝海湾'),
(829, 'CN', '蜘蛛王国', '蜘蛛王国'),
(830, 'CN', '血吼', '血吼'),
(831, 'CN', '血牙魔王', '血牙魔王'),
(832, 'CN', '血环', '血环'),
(833, 'CN', '血羽', '血羽'),
(834, 'CN', '血色十字军', '血色十字军'),
(835, 'CN', '血顶', '血顶'),
(836, 'CN', '试炼之环', '试炼之环'),
(837, 'CN', '诺兹多姆', '诺兹多姆'),
(838, 'CN', '诺森德', '诺森德'),
(839, 'CN', '诺莫瑞根', '诺莫瑞根'),
(840, 'CN', '贫瘠之地', '贫瘠之地'),
(841, 'CN', '踏梦者', '踏梦者'),
(842, 'CN', '轻风之语', '轻风之语'),
(843, 'CN', '辛达苟萨', '辛达苟萨'),
(844, 'CN', '达克萨隆', '达克萨隆'),
(845, 'CN', '达基萨斯', '达基萨斯'),
(846, 'CN', '达尔坎', '达尔坎'),
(847, 'CN', '达文格尔', '达文格尔'),
(848, 'CN', '达斯雷玛', '达斯雷玛'),
(849, 'CN', '达纳斯', '达纳斯'),
(850, 'CN', '达隆米尔', '达隆米尔'),
(851, 'CN', '迅捷微风', '迅捷微风'),
(852, 'CN', '远古海滩', '远古海滩'),
(853, 'CN', '迦拉克隆', '迦拉克隆'),
(854, 'CN', '迦玛兰', '迦玛兰'),
(855, 'CN', '迦罗娜', '迦罗娜'),
(856, 'CN', '迦顿', '迦顿'),
(857, 'CN', '迪托马斯', '迪托马斯'),
(858, 'CN', '迪瑟洛克', '迪瑟洛克'),
(859, 'CN', '逐日者', '逐日者'),
(860, 'CN', '通灵学院', '通灵学院'),
(861, 'CN', '遗忘海岸', '遗忘海岸'),
(862, 'CN', '金度', '金度'),
(863, 'CN', '金色平原', '金色平原'),
(864, 'CN', '铜龙军团', '铜龙军团'),
(865, 'CN', '银月', '银月'),
(866, 'CN', '银松森林', '银松森林'),
(867, 'CN', '闪电之刃', '闪电之刃'),
(868, 'CN', '阿克蒙德', '阿克蒙德'),
(869, 'CN', '阿努巴拉克', '阿努巴拉克'),
(870, 'CN', '阿卡玛', '阿卡玛'),
(871, 'CN', '阿古斯', '阿古斯'),
(872, 'CN', '阿尔萨斯', '阿尔萨斯'),
(873, 'CN', '阿扎达斯', '阿扎达斯'),
(874, 'CN', '阿拉希', '阿拉希'),
(875, 'CN', '阿拉索', '阿拉索'),
(876, 'CN', '阿斯塔洛', '阿斯塔洛'),
(877, 'CN', '阿曼尼', '阿曼尼'),
(878, 'CN', '阿格拉玛', '阿格拉玛'),
(879, 'CN', '阿比迪斯', '阿比迪斯'),
(880, 'CN', '阿纳克洛斯', '阿纳克洛斯'),
(881, 'CN', '阿迦玛甘', '阿迦玛甘'),
(882, 'CN', '雏龙之翼', '雏龙之翼'),
(883, 'CN', '雷克萨', '雷克萨'),
(884, 'CN', '雷斧堡垒', '雷斧堡垒'),
(885, 'CN', '雷霆之怒', '雷霆之怒'),
(886, 'CN', '雷霆之王', '雷霆之王'),
(887, 'CN', '雷霆号角', '雷霆号角'),
(888, 'CN', '霍格', '霍格'),
(889, 'CN', '霜之哀伤', '霜之哀伤'),
(890, 'CN', '霜狼', '霜狼'),
(891, 'CN', '风暴之怒', '风暴之怒'),
(892, 'CN', '风暴之眼', '风暴之眼'),
(893, 'CN', '风暴之鳞', '风暴之鳞'),
(894, 'CN', '风暴峭壁', '风暴峭壁'),
(895, 'CN', '风行者', '风行者'),
(896, 'CN', '鬼雾峰', '鬼雾峰'),
(897, 'CN', '鲜血熔炉', '鲜血熔炉'),
(898, 'CN', '鹰巢山', '鹰巢山'),
(899, 'CN', '麦姆', '麦姆'),
(900, 'CN', '麦维影歌', '麦维影歌'),
(901, 'CN', '麦迪文', '麦迪文'),
(902, 'CN', '黄金之路', '黄金之路'),
(903, 'CN', '黑手军团', '黑手军团'),
(904, 'CN', '黑暗之矛', '黑暗之矛'),
(905, 'CN', '黑暗之门', '黑暗之门'),
(906, 'CN', '黑暗虚空', '黑暗虚空'),
(907, 'CN', '黑暗魅影', '黑暗魅影'),
(908, 'CN', '黑石尖塔', '黑石尖塔'),
(909, 'CN', '黑翼之巢', '黑翼之巢'),
(910, 'CN', '黑铁', '黑铁'),
(911, 'CN', '黑锋哨站', '黑锋哨站'),
(912, 'CN', '黑龙军团', '黑龙军团'),
(913, 'CN', '龙骨平原', '龙骨平原'),
(914, 'CN', '埃霍恩', '埃霍恩'),
(915, 'CN', '奥金顿', '奥金顿'),
(916, 'CN', '刀塔', '刀塔'),
(917, 'CN', '兰娜瑟尔', '兰娜瑟尔'),
(918, 'CN', '罗曼斯', '罗曼斯'),
(919, 'CN', '斯克提斯', '斯克提斯'),
(920, 'CN', '塔伦米尔', '塔伦米尔'),
(921, 'CN', '双子峰', '双子峰'),
(922, 'CN', '冬寒', '冬寒'),
(923, 'TW', 'world-tree', '世界之樹'),
(924, 'TW', 'arygos', '亞雷戈斯'),
(925, 'TW', 'frostmane', '冰霜之刺'),
(926, 'TW', 'chillwind-point', '冰風崗哨'),
(927, 'TW', 'hellscream', '地獄吼'),
(928, 'TW', 'Nightsong', '夜空之歌'),
(929, 'TW', 'skywall', '天空之牆'),
(930, 'TW', 'icecrown', '寒冰皇冠'),
(931, 'TW', 'spirestone', '尖石'),
(932, 'TW', 'demon-fall-canyon', '屠魔山谷'),
(933, 'TW', 'dragonmaw', '巨龍之喉'),
(934, 'TW', 'wrathbringer', '憤怒使者'),
(935, 'TW', 'sundown-marsh', '日落沼澤'),
(936, 'TW', 'shadowmoon', '暗影之月'),
(937, 'TW', 'crystalpine-stinger', '水晶之刺'),
(938, 'TW', 'zealot-blade', '狂熱之刃'),
(939, 'TW', 'queldorei', '眾星之子'),
(940, 'TW', 'menethil', '米奈希爾'),
(941, 'TW', 'lights-hope', '聖光之願'),
(942, 'TW', 'bleeding-hollow', '血之谷'),
(943, 'TW', 'whisperwind', '語風'),
(944, 'TW', 'silverwing-hold', '銀翼要塞'),
(945, 'TW', 'arthas', '阿薩斯'),
(946, 'TW', 'order-of-the-cloud-serpent', '雲蛟衛'),
(947, 'TW', 'stormscale', '雷鱗'),
(949, 'KR', 'deathwing', '데스윙'),
(950, 'KR', 'durotan', '듀로탄'),
(951, 'KR', 'burning-legion', '불타는 군단'),
(952, 'KR', 'cenarius', '세나리우스'),
(953, 'KR', 'azshara', '아즈샤라'),
(954, 'KR', 'windrunner', '윈드러너'),
(955, 'KR', 'zuljin', '줄진'),
(956, 'KR', 'hyjal', '하이잘'),
(957, 'KR', 'hellscream', '헬스크림'),
(958, 'KR', 'alexstrasza', '알렉스트라자'),
(959, 'KR', 'dalaran', '달라란'),
(960, 'KR', 'garona', '가로나'),
(961, 'KR', 'guldan', '굴단'),
(962, 'KR', 'malfurion', '말퓨리온'),
(963, 'KR', 'norgannon', '노르간논'),
(964, 'KR', 'rexxar', '렉사르'),
(965, 'KR', 'illidan', '스톰레이지'),
(966, 'KR', 'wildhammer', '와일드해머'),
(1001, 'EU', 'Гордунни', 'Гордунни'),
(1002, 'EU', 'Свежеватель-Душ', 'Свежеватель Душ'),
(1003, 'EU', 'Ясеневый-лес', 'Ясеневый лес'),
(1004, 'EU', 'Разувий', 'Разувий'),
(1005, 'EU', 'Черный-Шрам', 'Черный Шрам'),
(1006, 'EU', 'Дракономор', 'Дракономор'),
(1007, 'EU', 'Страж-смерти', 'Страж смерти'),
(1008, 'EU', 'Азурегос', 'Азурегос'),
(1009, 'EU', 'Борейская-тундра', 'Борейская-тундра'),
(1010, 'EU', 'Вечная-Песня', 'Вечная Песня'),
(1011, 'EU', 'Пиратская-Бухта', 'Пиратская Бухта'),
(1012, 'EU', 'Голдринн', 'Голдринн'),
(1013, 'EU', 'Король-лич', 'Король-лич'),
(1014, 'EU', 'Гром', 'Гром'),
(1015, 'EU', 'Галакронд', 'Галакронд');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_talents`
--

CREATE TABLE IF NOT EXISTS `ovw_talents` (
  `id` int(11) NOT NULL,
  `class` smallint(2) NOT NULL,
  `t0_1` mediumint(6) NOT NULL,
  `t0_2` mediumint(6) NOT NULL,
  `t0_3` mediumint(6) NOT NULL,
  `t1_1` mediumint(6) NOT NULL,
  `t1_2` mediumint(6) NOT NULL,
  `t1_3` mediumint(6) NOT NULL,
  `t2_1` mediumint(6) NOT NULL,
  `t2_2` mediumint(6) NOT NULL,
  `t2_3` mediumint(6) NOT NULL,
  `t3_1` mediumint(6) NOT NULL,
  `t3_2` mediumint(6) NOT NULL,
  `t3_3` mediumint(6) NOT NULL,
  `t4_1` mediumint(6) NOT NULL,
  `t4_2` mediumint(6) NOT NULL,
  `t4_3` mediumint(6) NOT NULL,
  `t5_1` mediumint(6) NOT NULL,
  `t5_2` mediumint(6) NOT NULL,
  `t5_3` mediumint(6) NOT NULL,
  `t6_1` mediumint(6) NOT NULL,
  `t6_2` mediumint(6) NOT NULL,
  `t6_3` mediumint(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci;

--
-- Daten für Tabelle `ovw_talents`
--

INSERT INTO `ovw_talents` (`id`, `class`, `t0_1`, `t0_2`, `t0_3`, `t1_1`, `t1_2`, `t1_3`, `t2_1`, `t2_2`, `t2_3`, `t3_1`, `t3_2`, `t3_3`, `t4_1`, `t4_2`, `t4_3`, `t5_1`, `t5_2`, `t5_3`, `t6_1`, `t6_2`, `t6_3`) VALUES
(1, 1, 202297, 7384, 202161, 46968, 107570, 103827, 202316, 772, 107574, 29838, 202163, 197690, 215550, 202593, 207982, 227266, 215538, 202612, 152278, 203179, 152277),
(2, 1, 215556, 202296, 215568, 46968, 107570, 103827, 215569, 206320, 107574, 202224, 202163, 208154, 206315, 215571, 202922, 12292, 206313, 215573, 46924, 202751, 118000),
(3, 1, 46968, 107570, 103828, 202168, 205484, 223657, 202288, 202560, 107574, 223662, 202163, 203201, 236279, 202561, 202095, 202572, 202603, 202743, 152278, 203177, 228920),
(4, 2, 223306, 114158, 196926, 230332, 114154, 214202, 198054, 20066, 115750, 183425, 183416, 183415, 197646, 105809, 114165, 196923, 53376, 183778, 156910, 197446, 200025),
(5, 2, 152261, 204019, 203785, 203776, 204035, 204023, 198054, 20066, 115750, 204018, 230332, 203797, 213652, 204139, 204077, 204150, 204054, 183778, 204074, 152262, 203791),
(6, 2, 198038, 213757, 205228, 203316, 217020, 218178, 234299, 20066, 115750, 202271, 231832, 198034, 215661, 205191, 210191, 213313, 230332, 183778, 223817, 231895, 210220),
(7, 3, 204308, 194397, 193532, 199530, 217200, 53209, 109215, 199523, 199921, 199528, 194306, 130392, 109248, 19386, 19577, 131894, 120360, 194386, 201430, 199532, 191384),
(8, 3, 155228, 193533, 53238, 194595, 194599, 199527, 109215, 199523, 199921, 212431, 206817, 234588, 109248, 19386, 199483, 131894, 120360, 194386, 214579, 198670, 199522),
(9, 3, 204315, 200163, 201082, 206505, 201075, 201078, 109215, 781, 199921, 194277, 236698, 162488, 191241, 200108, 199483, 212436, 194855, 87935, 194407, 199543, 191384),
(10, 4, 196864, 193640, 16511, 14062, 108208, 108209, 193531, 114015, 14983, 108211, 79008, 31230, 196861, 131511, 154904, 200802, 193539, 200806, 152152, 137619, 152150),
(11, 4, 196937, 200733, 196938, 195457, 196924, 196922, 193531, 114015, 14983, 193546, 79008, 31230, 199743, 131511, 108216, 185767, 193539, 51690, 5171, 137619, 152150),
(12, 4, 31223, 193537, 200758, 14062, 108208, 108209, 193531, 114015, 14983, 200759, 79008, 31230, 196951, 131511, 200778, 196979, 193539, 206237, 196976, 137619, 152150),
(13, 5, 200347, 193134, 214621, 121536, 64129, 193063, 204263, 196704, 205367, 129250, 197045, 123040, 197419, 10060, 109142, 152118, 110744, 120517, 204197, 200309, 204065),
(14, 5, 200128, 200153, 193155, 121536, 214121, 235189, 204263, 200199, 196707, 196985, 200209, 64901, 109186, 32546, 197034, 197031, 110744, 120517, 200183, 193157, 204883),
(15, 5, 109142, 193195, 205351, 193173, 64129, 193063, 205369, 196704, 205367, 199849, 199853, 205371, 199855, 155271, 162452, 10060, 238558, 200174, 193225, 205385, 193223),
(16, 6, 195679, 221536, 206931, 194662, 212744, 211078, 219786, 221699, 205727, 206940, 205723, 219809, 206970, 206960, 219779, 206967, 194679, 206974, 194844, 206977, 114556),
(17, 6, 207057, 194878, 207061, 207060, 194909, 57330, 207126, 207127, 207142, 207161, 207167, 207170, 207188, 207200, 212765, 207230, 207104, 194912, 207256, 152279, 194913),
(18, 6, 194916, 207264, 207269, 207317, 194917, 194918, 207289, 207305, 207311, 207313, 108194, 207316, 207321, 207319, 212763, 198943, 207346, 207272, 207349, 152280, 130736),
(19, 7, 201909, 170374, 210643, 192063, 108281, 192077, 192058, 51485, 196932, 201707, 192087, 16166, 192235, 117013, 117014, 192222, 192249, 108283, 114050, 210689, 210714),
(20, 7, 201898, 201900, 201897, 215864, 196884, 192077, 192058, 51485, 196932, 192106, 192087, 210853, 192234, 210727, 210731, 192246, 197211, 197214, 114051, 197992, 188089),
(21, 7, 200071, 73685, 200072, 192063, 192088, 192077, 192058, 51485, 196932, 197464, 108281, 200074, 207399, 198838, 207401, 197467, 157153, 108283, 114052, 197995, 157154),
(22, 8, 205022, 236628, 205035, 212653, 236457, 235463, 55342, 116011, 1463, 157980, 205032, 205028, 235711, 113724, 205036, 114923, 157976, 205039, 155147, 234302, 153626),
(23, 8, 205020, 205023, 205026, 212653, 157981, 235365, 55342, 116011, 1463, 235870, 205029, 205033, 236058, 113724, 205036, 44457, 157976, 205037, 155148, 198929, 153561),
(24, 8, 205021, 205024, 205027, 212653, 108839, 235297, 55342, 116011, 1463, 157997, 205030, 56377, 235224, 113724, 205036, 112948, 157976, 205038, 155148, 199786, 153595),
(25, 9, 48181, 196102, 235155, 196105, 196103, 235157, 48018, 6789, 5484, 63106, 196226, 196098, 219272, 111400, 108416, 152107, 108501, 108503, 205178, 205279, 215941),
(26, 9, 196269, 205191, 205145, 196270, 196272, 196277, 48018, 6789, 30283, 196283, 196605, 196098, 219272, 111400, 108416, 152107, 108501, 171975, 205180, 157695, 215941),
(27, 9, 196406, 205184, 17877, 205148, 196412, 235157, 48018, 6789, 30283, 152108, 196408, 196098, 219272, 111400, 108416, 152107, 108501, 108503, 196410, 196447, 215941),
(28, 10, 123986, 196607, 115098, 115008, 116841, 115173, 196721, 115399, 196719, 116844, 115315, 119381, 122281, 237076, 122278, 116847, 132578, 196730, 196738, 196736, 196737),
(29, 10, 123986, 124081, 197945, 115008, 116841, 115173, 197915, 210802, 197900, 116844, 198898, 119381, 122281, 122783, 122278, 196725, 198664, 115313, 197908, 197895, 210804),
(30, 10, 123986, 196607, 115098, 115008, 116841, 115173, 115288, 115396, 121817, 116844, 115315, 119381, 122281, 122783, 122278, 116847, 123904, 196740, 196743, 152175, 152173),
(31, 11, 205636, 202425, 202345, 108238, 102280, 102401, 202157, 197491, 197492, 5211, 102359, 132469, 114107, 102560, 202347, 202342, 202359, 202360, 202770, 202354, 202430),
(32, 11, 202021, 202022, 155580, 108238, 102280, 102401, 197488, 217615, 197492, 5211, 102359, 132469, 158476, 102543, 52610, 202031, 202032, 202060, 236068, 155672, 202028),
(33, 11, 203953, 155835, 203962, 204012, 236748, 102401, 197488, 202155, 197492, 5211, 102359, 132469, 158477, 102558, 203964, 203974, 155578, 203965, 204053, 204066, 80313),
(34, 11, 200383, 102351, 207383, 108238, 102280, 102401, 197632, 197490, 197491, 5211, 102359, 132469, 158478, 33891, 200390, 207385, 197073, 155675, 155577, 197061, 197721),
(35, 12, 192939, 232893, 203550, 203551, 203555, 206478, 206475, 206416, 206473, 196555, 205411, 204909, 206476, 211881, 206491, 203556, 206477, 193897, 211048, 211053, 213410),
(36, 12, 207550, 207548, 209400, 207697, 227174, 207739, 232893, 227322, 211881, 218612, 209795, 217996, 207666, 202138, 209281, 212084, 203753, 218679, 209258, 236189, 227225);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ovw_weapons`
--

CREATE TABLE IF NOT EXISTS `ovw_weapons` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` tinyint(2) NOT NULL,
  `spec` text COLLATE latin1_german2_ci NOT NULL,
  `weapon_id` int(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=37 ;

--
-- Daten für Tabelle `ovw_weapons`
--

INSERT INTO `ovw_weapons` (`id`, `class`, `spec`, `weapon_id`) VALUES
(1, 1, 'Fury', 128908),
(2, 1, 'Arms', 128910),
(3, 1, 'Protection', 128289),
(4, 2, 'Holy', 128823),
(5, 2, 'Protection', 128866),
(6, 2, 'Retribution', 120978),
(7, 3, 'Beast Mastery', 128861),
(8, 3, 'Marksmanship', 128826),
(9, 3, 'Survival', 128808),
(10, 4, 'Assassination', 128870),
(11, 4, 'Outlaw', 128872),
(12, 4, 'Subtlety', 128476),
(13, 5, 'Discipline', 128868),
(14, 5, 'Holy', 128825),
(15, 5, 'Shadow', 128827),
(16, 6, 'Blood', 128402),
(17, 6, 'Frost', 128292),
(18, 6, 'Unholy', 128403),
(19, 7, 'Elemental', 128935),
(20, 7, 'Enhancement', 128819),
(21, 7, 'Restoration', 128911),
(22, 8, 'Arcane', 127857),
(23, 8, 'Fire', 128820),
(24, 8, 'Frost', 128862),
(25, 9, 'Affliction', 128942),
(26, 9, 'Demonology', 128943),
(27, 9, 'Destruction', 128941),
(28, 10, 'Brewmaster', 128938),
(29, 10, 'Mistweaver', 128937),
(30, 10, 'Windwalker', 128940),
(31, 11, 'Balance', 128858),
(32, 11, 'Feral', 128860),
(33, 11, 'Guardian', 128821),
(34, 11, 'Restoration', 128306),
(35, 12, 'Havoc', 127829),
(36, 12, 'Vengeance', 128832);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;