/*
    Due to significant power progression differences after level 60 and level 70, 
    this will modify PvP brackets to place players at these levels into lower brackets, 
    rather than grouping them with higher level players with much higher progression
*/

DROP TABLE IF EXISTS `pvpdifficulty_dbc`;
CREATE TABLE IF NOT EXISTS `pvpdifficulty_dbc` (
  `ID` int NOT NULL DEFAULT '0',
  `MapID` int NOT NULL DEFAULT '0',
  `RangeIndex` int NOT NULL DEFAULT '0',
  `MinLevel` int NOT NULL DEFAULT '0',
  `MaxLevel` int NOT NULL DEFAULT '0',
  `Difficulty` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO `pvpdifficulty_dbc` (`ID`, `MapID`, `RangeIndex`, `MinLevel`, `MaxLevel`, `Difficulty`) VALUES
(1,   30,  0, 51, 60, 0), -- Alterac Valley
(2,   30,  1, 61, 70, 1),
(3,   30,  2, 71, 79, 2),
(4,   30,  3, 80, 85, 3),
(5,  489,  0, 10, 19, 0), -- Warsong Gulch
(6,  489,  1, 20, 29, 0),
(7,  489,  2, 30, 39, 0),
(8,  489,  3, 40, 49, 0),
(9,  489,  4, 50, 60, 0),
(10, 489,  5, 61, 70, 0),
(11, 489,  6, 71, 79, 0),
(12, 489,  7, 80, 85, 0),
(13, 529,  0, 20, 29, 0), -- Arathi Basin
(14, 529,  1, 30, 39, 0),
(15, 529,  2, 40, 49, 0),
(16, 529,  3, 50, 60, 0),
(17, 529,  4, 61, 70, 0),
(18, 529,  5, 71, 79, 0),
(19, 529,  6, 80, 85, 0),
(20, 559,  0, 10, 14, 0), -- Nagrand Arena
(21, 559,  1, 15, 19, 0),
(22, 559,  2, 20, 24, 0),
(23, 559,  3, 25, 29, 0),
(24, 559,  4, 30, 34, 0),
(25, 559,  5, 35, 39, 0),
(26, 559,  6, 40, 44, 0),
(27, 559,  7, 45, 49, 0),
(28, 559,  8, 50, 54, 0),
(29, 559,  9, 55, 60, 0),
(30, 559, 10, 61, 64, 0),
(31, 559, 11, 65, 70, 0),
(32, 559, 12, 71, 74, 0),
(33, 559, 13, 75, 79, 0),
(34, 559, 14, 80, 84, 0),
(35, 559, 15, 85, 89, 0),
(36, 562,  0, 10, 14, 0), -- Blade's Edge Arena
(37, 562,  1, 15, 19, 0),
(38, 562,  2, 20, 24, 0),
(39, 562,  3, 25, 29, 0),
(40, 562,  4, 30, 34, 0),
(41, 562,  5, 35, 39, 0),
(42, 562,  6, 40, 44, 0),
(43, 562,  7, 45, 49, 0),
(44, 562,  8, 50, 54, 0),
(45, 562,  9, 55, 60, 0),
(46, 562, 10, 61, 64, 0),
(47, 562, 11, 65, 70, 0),
(48, 562, 12, 71, 74, 0),
(49, 562, 13, 75, 79, 0),
(50, 562, 14, 80, 84, 0),
(51, 562, 15, 85, 89, 0),
(52, 566,  0, 61, 70, 0), -- Eye of the Storm
(53, 566,  1, 71, 79, 0),
(54, 566,  2, 80, 85, 0),
(55, 572,  0, 10, 14, 0), -- Ruins of Lordaeron
(56, 572,  1, 15, 19, 0),
(57, 572,  2, 20, 24, 0),
(58, 572,  3, 25, 29, 0),
(59, 572,  4, 30, 34, 0),
(60, 572,  5, 35, 39, 0),
(61, 572,  6, 40, 44, 0),
(62, 572,  7, 45, 49, 0),
(63, 572,  8, 50, 54, 0),
(64, 572,  9, 55, 60, 0),
(65, 572, 10, 61, 64, 0),
(66, 572, 11, 65, 70, 0),
(67, 572, 12, 71, 74, 0),
(68, 572, 13, 75, 79, 0),
(69, 572, 14, 80, 84, 0),
(70, 572, 15, 85, 89, 0),
(71, 607,  0, 71, 79, 0), -- Strand of the Ancients
(72, 607,  1, 80, 84, 1),
(73, 607,  2, 85, 85, 2),
(74, 617,  0, 10, 14, 0), -- Dalaran Sewers
(75, 617,  1, 15, 19, 0),
(76, 617,  2, 20, 24, 0),
(77, 617,  3, 25, 29, 0),
(78, 617,  4, 30, 34, 0),
(79, 617,  5, 35, 39, 0),
(80, 617,  6, 40, 44, 0),
(81, 617,  7, 45, 49, 0),
(82, 617,  8, 50, 54, 0),
(83, 617,  9, 55, 60, 0),
(84, 617, 10, 61, 64, 0),
(85, 617, 11, 65, 70, 0),
(86, 617, 12, 70, 74, 0),
(87, 617, 13, 75, 79, 0),
(88, 617, 14, 80, 84, 0),
(89, 617, 15, 85, 89, 0),
(90, 618,  0, 10, 14, 0), -- The Ring of Valor
(91, 618,  1, 15, 19, 0),
(92, 618,  2, 20, 24, 0),
(93, 618,  3, 25, 29, 0),
(94, 618,  4, 30, 34, 0),
(95, 618,  5, 35, 39, 0),
(96, 618,  6, 40, 44, 0),
(97, 618,  7, 45, 49, 0),
(98, 618,  8, 50, 54, 0),
(99, 618,  9, 55, 60, 0),
(100, 618, 10, 61, 64, 0),
(101, 618, 11, 65, 70, 0),
(102, 618, 12, 71, 74, 0),
(103, 618, 13, 75, 79, 0),
(104, 618, 14, 80, 84, 0),
(105, 618, 15, 85, 89, 0),
(106, 628,  0, 71, 79, 0), -- Isle of Conquest
(107, 628,  1, 80, 84, 1),
(108, 628,  2, 85, 89, 2);