-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Apr 21, 2019 at 03:53 PM
-- Server version: 5.7.25
-- PHP Version: 7.1.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

INSERT INTO `position_rankings` (`id`, `description_id`, `location`, `next_rank_id`, `next_rank_location`, `level`) VALUES
(1, 41, 'Baybay', NULL, NULL, 'FIRST'),
(2, 40, 'Baybay', NULL, NULL, 'FIRST'),
(3, 39, 'Baybay', 33, 'Baybay', 'FIRST'),
(4, 91, 'Baybay', NULL, NULL, 'FIRST'),
(5, 138, 'Baybay', NULL, NULL, 'FIRST'),
(6, 37, 'Baybay', 27, 'Baybay', 'FIRST'),
(7, 35, 'Baybay', 18, 'Baybay', 'FIRST'),
(8, 36, 'Baybay', 25, 'Baybay', 'FIRST'),
(9, 99, 'Baybay', NULL, NULL, 'FIRST'),
(10, 140, 'Baybay', NULL, NULL, 'FIRST'),
(11, 93, 'Baybay', NULL, NULL, 'FIRST'),
(12, 27, 'Baybay', 21, 'Baybay', 'FIRST'),
(13, 33, 'Baybay', NULL, NULL, 'FIRST'),
(14, 30, 'Baybay', 23, 'Baybay', 'FIRST'),
(15, 87, 'Baybay', 12, 'Baybay', 'FIRST'),
(16, 87, 'Baybay', 14, 'Baybay', 'FIRST'),
(17, 146, 'Baybay', 145, 'Baybay', 'FIRST'),
(18, 117, 'Baybay', 116, 'Baybay', 'FIRST'),
(19, 66, 'Baybay', 65, 'Baybay', 'FIRST'),
(20, 26, 'Baybay', NULL, NULL, 'FIRST'),
(21, 23, 'Baybay', 10, 'Baybay', 'FIRST'),
(22, 21, 'Baybay', 8, 'Baybay', 'FIRST'),
(23, 17, 'Baybay', 7, 'Baybay', 'FIRST'),
(24, 16, 'Baybay', NULL, NULL, 'FIRST'),
(25, 152, 'Baybay', 151, 'Baybay', 'FIRST'),
(26, 65, 'Baybay', 115, 'Baybay', 'FIRST'),
(27, 118, 'Baybay', NULL, NULL, 'FIRST'),
(28, 25, 'Baybay', NULL, NULL, 'FIRST'),
(29, 19, 'Baybay', NULL, NULL, 'FIRST'),
(30, 18, 'Baybay', NULL, NULL, 'FIRST'),
(31, 13, 'Baybay', NULL, NULL, 'FIRST'),
(32, 24, 'Baybay', NULL, NULL, 'FIRST'),
(33, 107, 'Baybay', 106, 'Baybay', 'FIRST'),
(34, 125, 'Baybay', NULL, NULL, 'FIRST'),
(35, 145, 'Baybay', 144, 'Baybay', 'FIRST'),
(36, 15, 'Baybay', NULL, NULL, 'FIRST'),
(37, 12, 'Baybay', NULL, NULL, 'FIRST'),
(38, 14, 'Baybay', NULL, NULL, 'FIRST'),
(39, 115, 'Baybay', NULL, NULL, 'FIRST'),
(40, 7, 'Baybay', NULL, NULL, 'FIRST'),
(41, 98, 'Baybay', 97, 'Baybay', 'FIRST'),
(42, 100, 'Baybay', NULL, NULL, 'FIRST'),
(43, 6, 'Baybay', 4, 'Baybay', 'FIRST'),
(44, 88, 'Baybay', NULL, NULL, 'FIRST'),
(45, 106, 'Baybay', NULL, NULL, 'FIRST'),
(46, 151, 'Baybay', NULL, NULL, 'FIRST'),
(47, 10, 'Baybay', 5, 'Baybay', 'FIRST'),
(48, 5, 'Baybay', NULL, NULL, 'FIRST'),
(49, 4, 'Cebu', NULL, NULL, 'FIRST'),
(50, 144, 'Baybay', NULL, NULL, 'FIRST'),
(51, 3, 'Baybay', 2, 'Baybay', 'FIRST'),
(52, 108, 'Baybay', 101, 'Baybay', 'FIRST'),
(53, 101, 'Baybay', NULL, NULL, 'FIRST'),
(54, 97, 'Baybay', NULL, NULL, 'FIRST'),
(55, 2, 'Baybay', 1, 'Baybay', 'FIRST'),
(56, 1, 'Baybay', NULL, NULL, 'FIRST'),
(57, 78, 'Baybay', NULL, NULL, 'SECOND'),
(58, 82, 'Baybay', 120, 'Baybay', 'SECOND'),
(59, 55, 'Baybay', 64, 'Baybay', 'SECOND'),
(60, 55, 'Baybay', 57, 'Baybay', 'SECOND'),
(61, 77, 'Baybay', NULL, NULL, 'SECOND'),
(62, 56, 'Baybay', 51, 'Baybay', 'SECOND'),
(63, 64, 'Baybay', NULL, NULL, 'SECOND'),
(64, 85, 'Baybay', NULL, NULL, 'SECOND'),
(65, 136, 'Baybay', 135, 'Baybay', 'SECOND'),
(66, 96, 'Baybay', NULL, NULL, 'SECOND'),
(67, 96, 'Baybay', 95, 'Baybay', 'SECOND'),
(68, 79, 'Baybay', 80, 'Baybay', 'SECOND'),
(69, 52, 'Baybay', 50, 'Baybay', 'SECOND'),
(70, 148, 'Baybay', NULL, NULL, 'SECOND'),
(71, 135, 'Baybay', 134, 'Baybay', 'SECOND'),
(72, 90, 'Baybay', NULL, NULL, 'SECOND'),
(73, 123, 'Baybay', 122, 'Baybay', 'SECOND'),
(74, 92, 'Baybay', 160, 'Baybay', 'SECOND'),
(75, 62, 'Baybay', NULL, NULL, 'SECOND'),
(76, 95, 'Baybay', NULL, NULL, 'SECOND'),
(77, 102, 'Baybay', 105, 'Baybay', 'SECOND'),
(78, 80, 'Baybay', NULL, NULL, 'SECOND'),
(79, 143, 'Baybay', 142, 'Baybay', 'SECOND'),
(80, 50, 'Baybay', NULL, NULL, 'SECOND'),
(81, 122, 'Baybay', NULL, NULL, 'SECOND'),
(82, 119, 'Baybay', NULL, NULL, 'SECOND'),
(83, 121, 'Baybay', NULL, NULL, 'SECOND'),
(84, 84, 'Baybay', 83, 'Baybay', 'SECOND'),
(85, 134, 'Baybay', 137, 'Baybay', 'SECOND'),
(86, 83, 'Baybay', NULL, NULL, 'SECOND'),
(87, 105, 'Baybay', 104, 'Baybay', 'SECOND'),
(88, 142, 'Baybay', 140, 'Baybay', 'SECOND'),
(89, 109, 'Baybay', 45, 'Baybay', 'SECOND'),
(90, 103, 'Baybay', NULL, NULL, 'SECOND');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `position_rankings`
--
ALTER TABLE `position_rankings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `position_rankings_description_id_next_rank_id_unique` (`description_id`,`next_rank_id`),
  ADD KEY `position_rankings_next_rank_id_foreign` (`next_rank_id`);
