-- https://www.phpmyadmin.net/
--

START TRANSACTION;



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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `province_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `province_id`, `slug`, `is_active`) VALUES
(1, 1, 'airdrie-1', 1),
(2, 1, 'brooks-1', 1),
(3, 1, 'calgary-1', 1),
(4, 1, 'camrose-1', 1),
(5, 1, 'chestermere-1', 1),
(6, 1, 'cold-lake-1', 1),
(7, 1, 'edmonton-1', 1),
(8, 1, 'fort-saskatchewan-1', 1),
(9, 1, 'grande-prairie-1', 1),
(10, 1, 'lacombe-1', 1),
(11, 1, 'leduc-1', 1),
(12, 1, 'lethbridge-1', 1),
(13, 1, 'lloydminster-1', 1),
(14, 1, 'medicine-hat-1', 1),
(15, 1, 'red-deer-1', 1),
(16, 1, 'spruce-grove-1', 1),
(17, 1, 'st-albert-1', 1),
(18, 1, 'wetaskiwin-1', 1),
(19, 2, 'abbotsford-2', 1),
(20, 2, 'armstrong-2', 1),
(21, 2, 'burnaby-2', 1),
(22, 2, 'campbell-river-2', 1),
(23, 2, 'castlegar-2', 1),
(24, 2, 'chilliwack-2', 1),
(25, 2, 'colwood-2', 1),
(26, 2, 'coquitlam-2', 1),
(27, 2, 'courtenay-2', 1),
(28, 2, 'cranbrook-2', 1),
(29, 2, 'dawson-creek-2', 1),
(30, 2, 'delta-2', 1),
(31, 2, 'duncan-2', 1),
(32, 2, 'enderby-2', 1),
(33, 2, 'fernie-2', 1),
(34, 2, 'fort-st-john-2', 1),
(35, 2, 'grand-forks-2', 1),
(36, 2, 'greenwood-2', 1),
(37, 2, 'kamloops-2', 1),
(38, 2, 'kelowna-2', 1),
(39, 2, 'kimberley-2', 1),
(40, 2, 'langford-2', 1),
(41, 2, 'langley-2', 1),
(42, 2, 'maple-ridge-2', 1),
(43, 2, 'merritt-2', 1),
(44, 2, 'nanaimo-2', 1),
(45, 2, 'nelson-2', 1),
(46, 2, 'new-westminster-2', 1),
(47, 2, 'north-vancouver-2', 1),
(48, 2, 'parksville-2', 1),
(49, 2, 'penticton-2', 1),
(50, 2, 'pitt-meadows-2', 1),
(51, 2, 'port-alberni-2', 1),
(52, 2, 'port-coquitlam-2', 1),
(53, 2, 'port-moody-2', 1),
(54, 2, 'powell-river-2', 1),
(55, 2, 'prince-george-2', 1),
(56, 2, 'prince-rupert-2', 1),
(57, 2, 'quesnel-2', 1),
(58, 2, 'revelstoke-2', 1),
(59, 2, 'richmond-2', 1),
(60, 2, 'rossland-2', 1),
(61, 2, 'salmon-arm-2', 1),
(62, 2, 'surrey-2', 1),
(63, 2, 'terrace-2', 1),
(64, 2, 'trail-2', 1),
(65, 2, 'vancouver-2', 1),
(66, 2, 'vernon-2', 1),
(67, 2, 'victoria-2', 1),
(68, 2, 'west-kelowna-2', 1),
(69, 2, 'white-rock-2', 1),
(70, 2, 'williams-lake-2', 1),
(71, 3, 'brandon-3', 1),
(72, 3, 'dauphin-3', 1),
(73, 3, 'flin-flon-3', 1),
(74, 3, 'morden-3', 1),
(75, 3, 'portage-la-prairie-3', 1),
(76, 3, 'selkirk-3', 1),
(77, 3, 'steinbach-3', 1),
(78, 3, 'thompson-3', 1),
(79, 3, 'winkler-3', 1),
(80, 3, 'winnipeg-3', 1),
(81, 4, 'bathurst-4', 1),
(82, 4, 'campbellton-4', 1),
(83, 4, 'dieppe-4', 1),
(84, 4, 'edmundston-4', 1),
(85, 4, 'fredericton-4', 1),
(86, 4, 'miramichi-4', 1),
(87, 4, 'moncton-4', 1),
(88, 4, 'saint-john-4', 1),
(89, 5, 'corner-brook-5', 1),
(90, 5, 'mount-pearl-5', 1),
(91, 5, 'st-johns-5', 1),
(92, 6, 'halifax-6', 1),
(93, 6, 'sydney-6', 1),
(94, 7, 'barrie-7', 1),
(95, 7, 'belleville-7', 1),
(96, 7, 'brampton-7', 1),
(97, 7, 'brant-7', 1),
(98, 7, 'brantford-7', 1),
(99, 7, 'brockville-7', 1),
(100, 7, 'burlington-7', 1),
(101, 7, 'cambridge-7', 1),
(102, 7, 'clarence-rockland-7', 1),
(103, 7, 'cornwall-7', 1),
(104, 7, 'dryden-7', 1),
(105, 7, 'elliot-lake-7', 1),
(106, 7, 'greater-sudbury-7', 1),
(107, 7, 'guelph-7', 1),
(108, 7, 'haldimand-county-7', 1),
(109, 7, 'hamilton-7', 1),
(110, 7, 'kawartha-lakes-7', 1),
(111, 7, 'kenora-7', 1),
(112, 7, 'kingston-7', 1),
(113, 7, 'kitchener-7', 1),
(114, 7, 'london-7', 1),
(115, 7, 'markham-7', 1),
(116, 7, 'mississauga-7', 1),
(117, 7, 'niagara-falls-7', 1),
(118, 7, 'norfolk-county-7', 1),
(119, 7, 'north-bay-7', 1),
(120, 7, 'orillia-7', 1),
(121, 7, 'oshawa-7', 1),
(122, 7, 'ottawa-7', 1),
(123, 7, 'owen-sound-7', 1),
(124, 7, 'pembroke-7', 1),
(125, 7, 'peterborough-7', 1),
(126, 7, 'pickering-7', 1),
(127, 7, 'port-colborne-7', 1),
(128, 7, 'prince-edward-county-7', 1),
(129, 7, 'quinte-west-7', 1),
(130, 7, 'sarnia-7', 1),
(131, 7, 'sault-ste-marie-7', 1),
(132, 7, 'st-catharines-7', 1),
(133, 7, 'st-thomas-7', 1),
(134, 7, 'stratford-7', 1),
(135, 7, 'temiskaming-shores-7', 1),
(136, 7, 'thorold-7', 1),
(137, 7, 'thunder-bay-7', 1),
(138, 7, 'timmins-7', 1),
(139, 7, 'toronto-7', 1),
(140, 7, 'vaughan-7', 1),
(141, 7, 'waterloo-7', 1),
(142, 7, 'welland-7', 1),
(143, 7, 'windsor-7', 1),
(144, 7, 'woodstock-7', 1),
(145, 8, 'charlottetown-8', 1),
(146, 8, 'summerside-8', 1),
(147, 9, 'gatineau-9', 1),
(148, 9, 'laval-9', 1),
(149, 9, 'longueuil-9', 1),
(150, 9, 'montreal-9', 1),
(151, 9, 'quebec-city-9', 1),
(152, 9, 'saguenay-9', 1),
(153, 9, 'sherbrooke-9', 1),
(154, 9, 'terrebonne-9', 1),
(155, 9, 'trois-rivieres-9', 1),
(156, 10, 'lloydminster-10', 1),
(157, 10, 'martensville-10', 1),
(158, 10, 'meadow-lake-10', 1),
(159, 10, 'melfort-10', 1),
(160, 10, 'melville-10', 1),
(161, 10, 'moose-jaw-10', 1),
(162, 10, 'north-battleford-10', 1),
(163, 10, 'prince-albert-10', 1),
(164, 10, 'regina-10', 1),
(165, 10, 'saskatoon-10', 1),
(166, 10, 'swift-current-10', 1),
(167, 10, 'warman-10', 1),
(168, 10, 'weyburn-10', 1),
(169, 10, 'yorkton-10', 1),
(170, 11, 'yellowknife-11', 1),
(171, 12, 'iqaluit-12', 1),
(172, 13, 'whitehorse-13', 1);

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

--
-- Table structure for table `city_translations`
--

CREATE TABLE `city_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `city_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `city_translations`
--

INSERT INTO `city_translations` (`id`, `city_id`, `language_id`, `name`, `is_active`) VALUES
(1, 1, 1, 'Airdrie', 1),
(2, 1, 2, 'Airdrie', 1),
(3, 2, 1, 'Brooks', 1),
(4, 2, 2, 'Brooks', 1),
(5, 3, 1, 'Calgary', 1),
(6, 3, 2, 'Calgary', 1),
(7, 4, 1, 'Camrose', 1),
(8, 4, 2, 'Camrose', 1),
(9, 5, 1, 'Chestermere', 1),
(10, 5, 2, 'Chestermere', 1),
(11, 6, 1, 'Cold Lake', 1),
(12, 6, 2, 'Cold Lake', 1),
(13, 7, 1, 'Edmonton', 1),
(14, 7, 2, 'Edmonton', 1),
(15, 8, 1, 'Fort Saskatchewan', 1),
(16, 8, 2, 'Fort Saskatchewan', 1),
(17, 9, 1, 'Grande Prairie', 1),
(18, 9, 2, 'Grande Prairie', 1),
(19, 10, 1, 'Lacombe', 1),
(20, 10, 2, 'Lacombe', 1),
(21, 11, 1, 'Leduc', 1),
(22, 11, 2, 'Leduc', 1),
(23, 12, 1, 'Lethbridge', 1),
(24, 12, 2, 'Lethbridge', 1),
(25, 13, 1, 'Lloydminster', 1),
(26, 13, 2, 'Lloydminster', 1),
(27, 14, 1, 'Medicine Hat', 1),
(28, 14, 2, 'Medicine Hat', 1),
(29, 15, 1, 'Red Deer', 1),
(30, 15, 2, 'Red Deer', 1),
(31, 16, 1, 'Spruce Grove', 1),
(32, 16, 2, 'Spruce Grove', 1),
(33, 17, 1, 'St. Albert', 1),
(34, 17, 2, 'St. Albert', 1),
(35, 18, 1, 'Wetaskiwin', 1),
(36, 18, 2, 'Wetaskiwin', 1),
(37, 19, 1, 'Abbotsford', 1),
(38, 19, 2, 'Abbotsford', 1),
(39, 20, 1, 'Armstrong', 1),
(40, 20, 2, 'Armstrong', 1),
(41, 21, 1, 'Burnaby', 1),
(42, 21, 2, 'Burnaby', 1),
(43, 22, 1, 'Campbell River', 1),
(44, 22, 2, 'Campbell River', 1),
(45, 23, 1, 'Castlegar', 1),
(46, 23, 2, 'Castlegar', 1),
(47, 24, 1, 'Chilliwack', 1),
(48, 24, 2, 'Chilliwack', 1),
(49, 25, 1, 'Colwood', 1),
(50, 25, 2, 'Colwood', 1),
(51, 26, 1, 'Coquitlam', 1),
(52, 26, 2, 'Coquitlam', 1),
(53, 27, 1, 'Courtenay', 1),
(54, 27, 2, 'Courtenay', 1),
(55, 28, 1, 'Cranbrook', 1),
(56, 28, 2, 'Cranbrook', 1),
(57, 29, 1, 'Dawson Creek', 1),
(58, 29, 2, 'Dawson Creek', 1),
(59, 30, 1, 'Delta', 1),
(60, 30, 2, 'Delta', 1),
(61, 31, 1, 'Duncan', 1),
(62, 31, 2, 'Duncan', 1),
(63, 32, 1, 'Enderby', 1),
(64, 32, 2, 'Enderby', 1),
(65, 33, 1, 'Fernie', 1),
(66, 33, 2, 'Fernie', 1),
(67, 34, 1, 'Fort St. John', 1),
(68, 34, 2, 'Fort St. John', 1),
(69, 35, 1, 'Grand Forks', 1),
(70, 35, 2, 'Grand Forks', 1),
(71, 36, 1, 'Greenwood', 1),
(72, 36, 2, 'Greenwood', 1),
(73, 37, 1, 'Kamloops', 1),
(74, 37, 2, 'Kamloops', 1),
(75, 38, 1, 'Kelowna', 1),
(76, 38, 2, 'Kelowna', 1),
(77, 39, 1, 'Kimberley', 1),
(78, 39, 2, 'Kimberley', 1),
(79, 40, 1, 'Langford', 1),
(80, 40, 2, 'Langford', 1),
(81, 41, 1, 'Langley', 1),
(82, 41, 2, 'Langley', 1),
(83, 42, 1, 'Maple Ridge', 1),
(84, 42, 2, 'Maple Ridge', 1),
(85, 43, 1, 'Merritt', 1),
(86, 43, 2, 'Merritt', 1),
(87, 44, 1, 'Nanaimo', 1),
(88, 44, 2, 'Nanaimo', 1),
(89, 45, 1, 'Nelson', 1),
(90, 45, 2, 'Nelson', 1),
(91, 46, 1, 'New Westminster', 1),
(92, 46, 2, 'New Westminster', 1),
(93, 47, 1, 'North Vancouver', 1),
(94, 47, 2, 'North Vancouver', 1),
(95, 48, 1, 'Parksville', 1),
(96, 48, 2, 'Parksville', 1),
(97, 49, 1, 'Penticton', 1),
(98, 49, 2, 'Penticton', 1),
(99, 50, 1, 'Pitt Meadows', 1),
(100, 50, 2, 'Pitt Meadows', 1),
(101, 51, 1, 'Port Alberni', 1),
(102, 51, 2, 'Port Alberni', 1),
(103, 52, 1, 'Port Coquitlam', 1),
(104, 52, 2, 'Port Coquitlam', 1),
(105, 53, 1, 'Port Moody', 1),
(106, 53, 2, 'Port Moody', 1),
(107, 54, 1, 'Powell River', 1),
(108, 54, 2, 'Powell River', 1),
(109, 55, 1, 'Prince George', 1),
(110, 55, 2, 'Prince George', 1),
(111, 56, 1, 'Prince Rupert', 1),
(112, 56, 2, 'Prince Rupert', 1),
(113, 57, 1, 'Quesnel', 1),
(114, 57, 2, 'Quesnel', 1),
(115, 58, 1, 'Revelstoke', 1),
(116, 58, 2, 'Revelstoke', 1),
(117, 59, 1, 'Richmond', 1),
(118, 59, 2, 'Richmond', 1),
(119, 60, 1, 'Rossland', 1),
(120, 60, 2, 'Rossland', 1),
(121, 61, 1, 'Salmon Arm', 1),
(122, 61, 2, 'Salmon Arm', 1),
(123, 62, 1, 'Surrey', 1),
(124, 62, 2, 'Surrey', 1),
(125, 63, 1, 'Terrace', 1),
(126, 63, 2, 'Terrace', 1),
(127, 64, 1, 'Trail', 1),
(128, 64, 2, 'Trail', 1),
(129, 65, 1, 'Vancouver', 1),
(130, 65, 2, 'Vancouver', 1),
(131, 66, 1, 'Vernon', 1),
(132, 66, 2, 'Vernon', 1),
(133, 67, 1, 'Victoria', 1),
(134, 67, 2, 'Victoria', 1),
(135, 68, 1, 'West Kelowna', 1),
(136, 68, 2, 'West Kelowna', 1),
(137, 69, 1, 'White Rock', 1),
(138, 69, 2, 'White Rock', 1),
(139, 70, 1, 'Williams Lake', 1),
(140, 70, 2, 'Williams Lake', 1),
(141, 71, 1, 'Brandon', 1),
(142, 71, 2, 'Brandon', 1),
(143, 72, 1, 'Dauphin', 1),
(144, 72, 2, 'Dauphin', 1),
(145, 73, 1, 'Flin Flon', 1),
(146, 73, 2, 'Flin Flon', 1),
(147, 74, 1, 'Morden', 1),
(148, 74, 2, 'Morden', 1),
(149, 75, 1, 'Portage la Prairie', 1),
(150, 75, 2, 'Portage la Prairie', 1),
(151, 76, 1, 'Selkirk', 1),
(152, 76, 2, 'Selkirk', 1),
(153, 77, 1, 'Steinbach', 1),
(154, 77, 2, 'Steinbach', 1),
(155, 78, 1, 'Thompson', 1),
(156, 78, 2, 'Thompson', 1),
(157, 79, 1, 'Winkler', 1),
(158, 79, 2, 'Winkler', 1),
(159, 80, 1, 'Winnipeg', 1),
(160, 80, 2, 'Winnipeg', 1),
(161, 81, 1, 'Bathurst', 1),
(162, 81, 2, 'Bathurst', 1),
(163, 82, 1, 'Campbellton', 1),
(164, 82, 2, 'Campbellton', 1),
(165, 83, 1, 'Dieppe', 1),
(166, 83, 2, 'Dieppe', 1),
(167, 84, 1, 'Edmundston', 1),
(168, 84, 2, 'Edmundston', 1),
(169, 85, 1, 'Fredericton', 1),
(170, 85, 2, 'Fredericton', 1),
(171, 86, 1, 'Miramichi', 1),
(172, 86, 2, 'Miramichi', 1),
(173, 87, 1, 'Moncton', 1),
(174, 87, 2, 'Moncton', 1),
(175, 88, 1, 'Saint John', 1),
(176, 88, 2, 'Saint John', 1),
(177, 89, 1, 'Corner Brook', 1),
(178, 89, 2, 'Corner Brook', 1),
(179, 90, 1, 'Mount Pearl', 1),
(180, 90, 2, 'Mount Pearl', 1),
(181, 91, 1, 'St. John’s', 1),
(182, 91, 2, 'St. John’s', 1),
(183, 92, 1, 'Halifax', 1),
(184, 92, 2, 'Halifax', 1),
(185, 93, 1, 'Sydney', 1),
(186, 93, 2, 'Sydney', 1),
(187, 94, 1, 'Barrie', 1),
(188, 94, 2, 'Barrie', 1),
(189, 95, 1, 'Belleville', 1),
(190, 95, 2, 'Belleville', 1),
(191, 96, 1, 'Brampton', 1),
(192, 96, 2, 'Brampton', 1),
(193, 97, 1, 'Brant', 1),
(194, 97, 2, 'Brant', 1),
(195, 98, 1, 'Brantford', 1),
(196, 98, 2, 'Brantford', 1),
(197, 99, 1, 'Brockville', 1),
(198, 99, 2, 'Brockville', 1),
(199, 100, 1, 'Burlington', 1),
(200, 100, 2, 'Burlington', 1),
(201, 101, 1, 'Cambridge', 1),
(202, 101, 2, 'Cambridge', 1),
(203, 102, 1, 'Clarence-Rockland', 1),
(204, 102, 2, 'Clarence-Rockland', 1),
(205, 103, 1, 'Cornwall', 1),
(206, 103, 2, 'Cornwall', 1),
(207, 104, 1, 'Dryden', 1),
(208, 104, 2, 'Dryden', 1),
(209, 105, 1, 'Elliot Lake', 1),
(210, 105, 2, 'Elliot Lake', 1),
(211, 106, 1, 'Greater Sudbury', 1),
(212, 106, 2, 'Greater Sudbury', 1),
(213, 107, 1, 'Guelph', 1),
(214, 107, 2, 'Guelph', 1),
(215, 108, 1, 'Haldimand County', 1),
(216, 108, 2, 'Haldimand County', 1),
(217, 109, 1, 'Hamilton', 1),
(218, 109, 2, 'Hamilton', 1),
(219, 110, 1, 'Kawartha Lakes', 1),
(220, 110, 2, 'Kawartha Lakes', 1),
(221, 111, 1, 'Kenora', 1),
(222, 111, 2, 'Kenora', 1),
(223, 112, 1, 'Kingston', 1),
(224, 112, 2, 'Kingston', 1),
(225, 113, 1, 'Kitchener', 1),
(226, 113, 2, 'Kitchener', 1),
(227, 114, 1, 'London', 1),
(228, 114, 2, 'London', 1),
(229, 115, 1, 'Markham', 1),
(230, 115, 2, 'Markham', 1),
(231, 116, 1, 'Mississauga', 1),
(232, 116, 2, 'Mississauga', 1),
(233, 117, 1, 'Niagara Falls', 1),
(234, 117, 2, 'Niagara Falls', 1),
(235, 118, 1, 'Norfolk County', 1),
(236, 118, 2, 'Norfolk County', 1),
(237, 119, 1, 'North Bay', 1),
(238, 119, 2, 'North Bay', 1),
(239, 120, 1, 'Orillia', 1),
(240, 120, 2, 'Orillia', 1),
(241, 121, 1, 'Oshawa', 1),
(242, 121, 2, 'Oshawa', 1),
(243, 122, 1, 'Ottawa', 1),
(244, 122, 2, 'Ottawa', 1),
(245, 123, 1, 'Owen Sound', 1),
(246, 123, 2, 'Owen Sound', 1),
(247, 124, 1, 'Pembroke', 1),
(248, 124, 2, 'Pembroke', 1),
(249, 125, 1, 'Peterborough', 1),
(250, 125, 2, 'Peterborough', 1),
(251, 126, 1, 'Pickering', 1),
(252, 126, 2, 'Pickering', 1),
(253, 127, 1, 'Port Colborne', 1),
(254, 127, 2, 'Port Colborne', 1),
(255, 128, 1, 'Prince Edward County', 1),
(256, 128, 2, 'Prince Edward County', 1),
(257, 129, 1, 'Quinte West', 1),
(258, 129, 2, 'Quinte West', 1),
(259, 130, 1, 'Sarnia', 1),
(260, 130, 2, 'Sarnia', 1),
(261, 131, 1, 'Sault Ste. Marie', 1),
(262, 131, 2, 'Sault Ste. Marie', 1),
(263, 132, 1, 'St. Catharines', 1),
(264, 132, 2, 'St. Catharines', 1),
(265, 133, 1, 'St. Thomas', 1),
(266, 133, 2, 'St. Thomas', 1),
(267, 134, 1, 'Stratford', 1),
(268, 134, 2, 'Stratford', 1),
(269, 135, 1, 'Temiskaming Shores', 1),
(270, 135, 2, 'Temiskaming Shores', 1),
(271, 136, 1, 'Thorold', 1),
(272, 136, 2, 'Thorold', 1),
(273, 137, 1, 'Thunder Bay', 1),
(274, 137, 2, 'Thunder Bay', 1),
(275, 138, 1, 'Timmins', 1),
(276, 138, 2, 'Timmins', 1),
(277, 139, 1, 'Toronto', 1),
(278, 139, 2, 'Toronto', 1),
(279, 140, 1, 'Vaughan', 1),
(280, 140, 2, 'Vaughan', 1),
(281, 141, 1, 'Waterloo', 1),
(282, 141, 2, 'Waterloo', 1),
(283, 142, 1, 'Welland', 1),
(284, 142, 2, 'Welland', 1),
(285, 143, 1, 'Windsor', 1),
(286, 143, 2, 'Windsor', 1),
(287, 144, 1, 'Woodstock', 1),
(288, 144, 2, 'Woodstock', 1),
(289, 145, 1, 'Charlottetown', 1),
(290, 145, 2, 'Charlottetown', 1),
(291, 146, 1, 'Summerside', 1),
(292, 146, 2, 'Summerside', 1),
(293, 147, 1, 'Gatineau', 1),
(294, 147, 2, 'Gatineau', 1),
(295, 148, 1, 'Laval', 1),
(296, 148, 2, 'Laval', 1),
(297, 149, 1, 'Longueuil', 1),
(298, 149, 2, 'Longueuil', 1),
(299, 150, 1, 'Montreal', 1),
(300, 150, 2, 'Montreal', 1),
(301, 151, 1, 'Quebec City', 1),
(302, 151, 2, 'Quebec City', 1),
(303, 152, 1, 'Saguenay', 1),
(304, 152, 2, 'Saguenay', 1),
(305, 153, 1, 'Sherbrooke', 1),
(306, 153, 2, 'Sherbrooke', 1),
(307, 154, 1, 'Terrebonne', 1),
(308, 154, 2, 'Terrebonne', 1),
(309, 155, 1, 'Trois-Rivières', 1),
(310, 155, 2, 'Trois-Rivières', 1),
(311, 156, 1, 'Lloydminster', 1),
(312, 156, 2, 'Lloydminster', 1),
(313, 157, 1, 'Martensville', 1),
(314, 157, 2, 'Martensville', 1),
(315, 158, 1, 'Meadow Lake', 1),
(316, 158, 2, 'Meadow Lake', 1),
(317, 159, 1, 'Melfort', 1),
(318, 159, 2, 'Melfort', 1),
(319, 160, 1, 'Melville', 1),
(320, 160, 2, 'Melville', 1),
(321, 161, 1, 'Moose Jaw', 1),
(322, 161, 2, 'Moose Jaw', 1),
(323, 162, 1, 'North Battleford', 1),
(324, 162, 2, 'North Battleford', 1),
(325, 163, 1, 'Prince Albert', 1),
(326, 163, 2, 'Prince Albert', 1),
(327, 164, 1, 'Regina', 1),
(328, 164, 2, 'Regina', 1),
(329, 165, 1, 'Saskatoon', 1),
(330, 165, 2, 'Saskatoon', 1),
(331, 166, 1, 'Swift Current', 1),
(332, 166, 2, 'Swift Current', 1),
(333, 167, 1, 'Warman', 1),
(334, 167, 2, 'Warman', 1),
(335, 168, 1, 'Weyburn', 1),
(336, 168, 2, 'Weyburn', 1),
(337, 169, 1, 'Yorkton', 1),
(338, 169, 2, 'Yorkton', 1),
(339, 170, 1, 'Yellowknife', 1),
(340, 170, 2, 'Yellowknife', 1),
(341, 171, 1, 'Iqaluit', 1),
(342, 171, 2, 'Iqaluit', 1),
(343, 172, 1, 'Whitehorse', 1),
(344, 172, 2, 'Whitehorse', 1);

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

--
-- Table structure for table `companies`
--

CREATE TABLE `companies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `min_cost` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `companies`
--

INSERT INTO `companies` (`id`, `slug`, `logo`, `url`, `min_cost`, `is_active`) VALUES
(1, 'jf', 'seeder/companies/jf.png', 'https://www.jfgroup.ca/', 25, 1),
(2, 'allianz ', 'seeder/companies/allianz.png', 'https://www.allianz.com/en.html', 20, 1),
(3, 'manulife', 'seeder/companies/manulife.png', 'https://www.manulife.com/', 0, 1),
(4, '21st-century', 'seeder/companies/21st.png', 'https://www.21st.com/', 25, 1);

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

--
-- Table structure for table `company_translations`
--

CREATE TABLE `company_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `company_translations`
--

INSERT INTO `company_translations` (`id`, `company_id`, `language_id`, `name`, `description`, `is_active`) VALUES
(1, 1, 1, 'JF Visitor to Canada', 'The best price in the market, less than 1,300 Canadian dollars, you can submit claims online, and receive the claim payment through bank transfer in about two weeks. Berkley\'s competitive products have basically the same regulations and prices.', 1),
(2, 1, 2, 'JF Visitor to Canada', '市场价格最优，CAD$1300以下可网络递交理赔，两周左右，通过转账收到理赔款，Berkley竞争性产品，条例价格基本一样', 1),
(3, 2, 1, 'Allianz Visitor to Canada', 'Convenient claims settlement and favorable prices', 1),
(4, 2, 2, 'Allianz Visitor to Canada', '理赔便捷，价格优惠', 1),
(5, 3, 1, 'Manulife Visitor to Canada', 'MANULIFE Insurance Company\'s products have a higher price advantage for people aged 80-85. The cost of each medical visit is less than the deductible amount and needs to be borne by the patient (deductible is not recommended).', 1),
(6, 3, 2, 'Manulife Visitor to Canada', 'MANULIFE保险公司旗下产品，在80-85岁有较高的价格优势，每次就医花销低于垫底费的额度需自己承担（不建议选垫底费）', 1),
(7, 4, 1, '21st Century Visitor to Canada', 'Enhanced is the price that covers stable old diseases, and standard is the price that does not cover old diseases. There is no price that does not cover old diseases for people under 55 years old.', 1),
(8, 4, 2, '21st Century Visitor to Canada', 'Ehanced计划是保稳定旧病的价格，Standard计划是不保旧病的价格，55岁以下没有不保旧病的价格。', 1);

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `prefix` smallint(5) UNSIGNED NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `slug`, `prefix`, `is_active`) VALUES
(1, 'canada', 1, 1);

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

--
-- Table structure for table `country_translations`
--

CREATE TABLE `country_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country_translations`
--

INSERT INTO `country_translations` (`id`, `country_id`, `language_id`, `name`, `is_active`) VALUES
(1, 1, 1, 'Canada', 1),
(2, 1, 2, '加拿大', 1);

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

--
-- Table structure for table `deductibles`
--

CREATE TABLE `deductibles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `amount` bigint(20) UNSIGNED NOT NULL,
  `discount` tinyint(4) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deductibles`
--

INSERT INTO `deductibles` (`id`, `company_id`, `slug`, `amount`, `discount`, `is_active`) VALUES
(1, 1, 'jf-0', 0, 0, 1),
(2, 1, 'jf-100', 100, 5, 1),
(3, 1, 'jf-500', 500, 15, 1),
(4, 1, 'jf-1000', 1000, 20, 1),
(5, 1, 'jf-3000', 3000, 30, 1),
(6, 2, 'allianz-0', 0, 0, 1),
(7, 2, 'allianz-500', 500, 15, 1),
(8, 3, 'manulife-0', 0, -5, 1),
(9, 3, 'manulife-75', 75, 0, 1),
(10, 3, 'manulife-500', 500, 15, 1),
(11, 3, 'manulife-1000', 1000, 0, 1),
(12, 3, 'manulife-2500', 2500, 25, 1),
(13, 3, 'manulife-5000', 5000, 35, 1),
(14, 4, '21st-century-0', 0, 0, 1),
(15, 4, '21st-century-100', 100, 5, 1),
(16, 4, '21st-century-250', 250, 10, 1),
(17, 4, '21st-century-500', 500, 15, 1),
(18, 4, '21st-century-1000', 1000, 20, 1),
(19, 4, '21st-century-5000', 5000, 35, 1),
(20, 4, '21st-century-10000', 10000, 40, 1);

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

--
-- Table structure for table `deductible_translations`
--

CREATE TABLE `deductible_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `deductible_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `amount` varchar(255) NOT NULL,
  `discount` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `deductible_translations`
--

INSERT INTO `deductible_translations` (`id`, `deductible_id`, `language_id`, `amount`, `discount`, `is_active`) VALUES
(1, 1, 1, '$0 Deductible', '0% Discount', 1),
(2, 1, 2, '0 美元免赔额', '0% 折扣', 1),
(3, 2, 1, '$100 Deductible', '5% Discount', 1),
(4, 2, 2, '100 美元免赔额', '5% 折扣', 1),
(5, 3, 1, '$500 Deductible', '15% Discount', 1),
(6, 3, 2, '500 美元免赔额', '15% 折扣', 1),
(7, 4, 1, '$1,000 Deductible', '20% Discount', 1),
(8, 4, 2, '1,000 美元免赔额', '20% 折扣', 1),
(9, 5, 1, '$3,000 Deductible', '30% Discount', 1),
(10, 5, 2, '3,000 美元免赔额', '30% 折扣', 1),
(11, 6, 1, '$0 Deductible', '0% Discount', 1),
(12, 6, 2, '0 美元免赔额', '0% 折扣', 1),
(13, 7, 1, '$500 Deductible', '15% Discount', 1),
(14, 7, 2, '500 美元免赔额', '15% 折扣', 1),
(15, 8, 1, '$0 Deductible', '5% increase in premiums', 1),
(16, 8, 2, '0 美元免赔额', '保费增加5%', 1),
(17, 9, 1, '$75 Deductible', '0% Discount', 1),
(18, 9, 2, '75 美元免赔额', '0% 折扣', 1),
(19, 10, 1, '$500 Deductible', '15% Discount', 1),
(20, 10, 2, '500 美元免赔额', '15% 折扣', 1),
(21, 11, 1, '$1,000 Deductible *Vanishing deductible', '20% Discount', 1),
(22, 11, 2, '1,000 美元免赔额 *消失免赔额', '20% 折扣', 1),
(23, 12, 1, '$2,500 Deductible*', '25% Discount', 1),
(24, 12, 2, '2,500 美元免赔额', '25% 折扣', 1),
(25, 13, 1, '$5,000 Deductible', '35% Discount', 1),
(26, 13, 2, '5,000 美元免赔额', '35% 折扣', 1),
(27, 14, 1, '$0 Deductible', '0% Discount', 1),
(28, 14, 2, '0 美元免赔额', '0% 折扣', 1),
(29, 15, 1, '$100 Deductible', '5% Discount', 1),
(30, 15, 2, '100 美元免赔额', '5% 折扣', 1),
(31, 16, 1, '$250 Deductible', '10% Discount', 1),
(32, 16, 2, '250 美元免赔额', '10% 折扣', 1),
(33, 17, 1, '$500 Deductible', '15% Discount', 1),
(34, 17, 2, '500 美元免赔额', '15% 折扣', 1),
(35, 18, 1, '$1,000 Deductible', '20% Discount', 1),
(36, 18, 2, '1,000 美元免赔额', '20% 折扣', 1),
(37, 19, 1, '$5,000 Deductible', '35% Discount', 1),
(38, 19, 2, '5,000 美元免赔额', '35% 折扣', 1),
(39, 20, 1, '$10,000 Deductible', '40% Discount', 1),
(40, 20, 2, '10,000 美元免赔额', '40% 折扣', 1);

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` char(2) NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `code`, `name`, `is_active`) VALUES
(1, 'en', 'English', 1),
(2, 'zh', '中文', 1);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2025_06_14_182912_create_languages_table', 1),
(2, '2025_06_14_183024_create_admins_table', 1),
(3, '2025_06_14_183122_create_agents_table', 1),
(4, '2025_06_14_183152_create_sessions_table', 1),
(5, '2025_06_14_185906_create_companies_table', 1),
(6, '2025_06_14_190022_create_company_translations_table', 1),
(7, '2025_06_14_190515_create_plans_table', 1),
(8, '2025_06_14_190923_create_plan_translations_table', 1),
(9, '2025_06_14_191347_create_prices_table', 1),
(10, '2025_06_14_191821_create_deductibles_table', 1),
(11, '2025_06_14_191941_create_deductible_translations_table', 1),
(12, '2025_06_14_192155_create_countries_table', 1),
(13, '2025_06_14_192306_create_country_translations_table', 1),
(14, '2025_06_14_192337_create_provinces_table', 1),
(15, '2025_06_14_192414_create_province_translations_table', 1),
(16, '2025_06_14_192500_create_cities_table', 1),
(17, '2025_06_14_192546_create_city_translations_table', 1),
(18, '2025_06_14_192723_create_inquiries_table', 1),
(19, '2025_06_14_193410_create_people_table', 1),
(20, '2025_08_12_084052_create_contents_table', 1);

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

--
-- Table structure for table `people`
--

CREATE TABLE `people` (
  `id` char(26) NOT NULL,
  `inquiry_id` char(26) NOT NULL,
  `deductible_id` bigint(20) UNSIGNED NOT NULL,
  `price_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `born_at` datetime NOT NULL,
  `is_male` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `people`
--

INSERT INTO `people` (`id`, `inquiry_id`, `deductible_id`, `price_id`, `first_name`, `last_name`, `born_at`, `is_male`) VALUES
('01K6K6FA7G58Z8A76274KNFM09', '01k6k6fa7agf7n8vs94g7sp91z', 5, 17, 'Pencilixel', 'Solutions', '1986-08-16 00:00:00', 1),
('01K6K76M0KHR2Q6Q2GXK7YDDZH', '01k6k76m0hybn44cc7w2ea22xd', 7, 313, 'Pencilixel', 'Solutions', '1982-08-16 00:00:00', 1),
('01K6K76M0MSZY5A0Y8XZC0K2Q0', '01k6k76m0hybn44cc7w2ea22xd', 7, 289, 'Mufang', 'Cai', '2005-09-03 00:00:00', 0),
('01K6K76M0MSZY5A0Y8XZC0K2Q1', '01k6k76m0hybn44cc7w2ea22xd', 7, 289, 'dasgdash', 'DBzd', '2014-08-30 00:00:00', 1);

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

--
-- Table structure for table `plans`
--

CREATE TABLE `plans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `company_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `sort` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plans`
--

INSERT INTO `plans` (`id`, `company_id`, `slug`, `sort`, `is_active`) VALUES
(1, 1, 'jf-smc', 1, 1),
(2, 1, 'jf-non-smc', 2, 1),
(3, 2, 'allianz-smc', 1, 1),
(4, 2, 'allianz-non-smc', 2, 1),
(5, 3, 'manulife-smc', 1, 1),
(6, 3, 'manulife-non-smc', 2, 1),
(7, 4, '21st-century-basic', 1, 1),
(8, 4, '21st-century-standard', 2, 1),
(9, 4, '21st-century-enhanced', 3, 1);

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

--
-- Table structure for table `plan_translations`
--

CREATE TABLE `plan_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `plan_translations`
--

INSERT INTO `plan_translations` (`id`, `plan_id`, `language_id`, `name`, `description`, `is_active`) VALUES
(1, 1, 1, 'SMC', 'With stable pre-existing conditions coverage option', 1),
(2, 1, 2, '保慢性病', '保慢性病', 1),
(3, 2, 1, 'NON-SMC', 'Without stable pre-existing conditions coverage option', 1),
(4, 2, 2, '不保慢性病', '不保慢性病', 1),
(5, 3, 1, 'SMC', 'With stable pre-existing conditions coverage option', 1),
(6, 3, 2, '保慢性病', '保慢性病', 1),
(7, 4, 1, 'NON-SMC', 'Without stable pre-existing conditions coverage option', 1),
(8, 4, 2, '不保慢性病', '不保慢性病', 1),
(9, 5, 1, 'SMC', 'With stable pre-existing conditions coverage option', 1),
(10, 5, 2, '保慢性病', '保慢性病', 1),
(11, 6, 1, 'NON-SMC', 'Without stable pre-existing conditions coverage option', 1),
(12, 6, 2, '不保慢性病', '不保慢性病', 1),
(13, 7, 1, 'Basic', 'Basic', 1),
(14, 7, 2, 'Basic', 'Basic', 1),
(15, 8, 1, 'Standard', 'Standard', 1),
(16, 8, 2, 'Standard', 'Standard', 1),
(17, 9, 1, 'Enhanced', 'Enhanced', 1),
(18, 9, 2, 'Enhanced', 'Enhanced', 1);

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

--
-- Table structure for table `prices`
--

CREATE TABLE `prices` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `plan_id` bigint(20) UNSIGNED NOT NULL,
  `age_from` smallint(5) UNSIGNED NOT NULL,
  `age_to` smallint(5) UNSIGNED DEFAULT NULL,
  `insurance_cover` int(10) UNSIGNED NOT NULL,
  `daily_cost` double UNSIGNED DEFAULT NULL,
  `is_entry` tinyint(1) NOT NULL DEFAULT 1,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `prices`
--

INSERT INTO `prices` (`id`, `plan_id`, `age_from`, `age_to`, `insurance_cover`, `daily_cost`, `is_entry`, `is_active`) VALUES
(1, 1, 0, 25, 10000, 1.79, 1, 1),
(2, 1, 0, 25, 10000, 1.79, 0, 1),
(3, 1, 0, 25, 15000, 2.14, 1, 1),
(4, 1, 0, 25, 15000, 2.14, 0, 1),
(5, 1, 0, 25, 25000, 2.38, 1, 1),
(6, 1, 0, 25, 25000, 2.38, 0, 1),
(7, 1, 0, 25, 50000, 2.61, 1, 1),
(8, 1, 0, 25, 50000, 2.61, 0, 1),
(9, 1, 0, 25, 100000, 3.77, 1, 1),
(10, 1, 0, 25, 100000, 3.77, 0, 1),
(11, 1, 0, 25, 150000, 4.52, 1, 1),
(12, 1, 0, 25, 150000, 4.52, 0, 1),
(13, 1, 0, 25, 200000, 5.65, 1, 1),
(14, 1, 0, 25, 200000, 5.65, 0, 1),
(15, 1, 0, 25, 300000, 6.55, 1, 1),
(16, 1, 0, 25, 300000, 6.55, 0, 1),
(17, 1, 26, 40, 10000, 1.95, 1, 1),
(18, 1, 26, 40, 10000, 1.95, 0, 1),
(19, 1, 26, 40, 15000, 2.33, 1, 1),
(20, 1, 26, 40, 15000, 2.33, 0, 1),
(21, 1, 26, 40, 25000, 2.61, 1, 1),
(22, 1, 26, 40, 25000, 2.61, 0, 1),
(23, 1, 26, 40, 50000, 2.88, 1, 1),
(24, 1, 26, 40, 50000, 2.88, 0, 1),
(25, 1, 26, 40, 100000, 4.22, 1, 1),
(26, 1, 26, 40, 100000, 4.22, 0, 1),
(27, 1, 26, 40, 150000, 4.89, 1, 1),
(28, 1, 26, 40, 150000, 4.89, 0, 1),
(29, 1, 26, 40, 200000, 6.12, 1, 1),
(30, 1, 26, 40, 200000, 6.12, 0, 1),
(31, 1, 26, 40, 300000, 7.1, 1, 1),
(32, 1, 26, 40, 300000, 7.1, 0, 1),
(33, 1, 41, 60, 10000, 2.25, 1, 1),
(34, 1, 41, 60, 10000, 2.25, 0, 1),
(35, 1, 41, 60, 15000, 2.68, 1, 1),
(36, 1, 41, 60, 15000, 2.68, 0, 1),
(37, 1, 41, 60, 25000, 3, 1, 1),
(38, 1, 41, 60, 25000, 3, 0, 1),
(39, 1, 41, 60, 50000, 3.27, 1, 1),
(40, 1, 41, 60, 50000, 3.27, 0, 1),
(41, 1, 41, 60, 100000, 4.41, 1, 1),
(42, 1, 41, 60, 100000, 4.41, 0, 1),
(43, 1, 41, 60, 150000, 4.94, 1, 1),
(44, 1, 41, 60, 150000, 4.94, 0, 1),
(45, 1, 41, 60, 200000, 7.55, 1, 1),
(46, 1, 41, 60, 200000, 7.55, 0, 1),
(47, 1, 41, 60, 300000, 8.76, 1, 1),
(48, 1, 41, 60, 300000, 8.76, 0, 1),
(49, 1, 61, 64, 10000, 2.56, 1, 1),
(50, 1, 61, 64, 10000, 2.56, 0, 1),
(51, 1, 61, 64, 15000, 3.27, 1, 1),
(52, 1, 61, 64, 15000, 3.27, 0, 1),
(53, 1, 61, 64, 25000, 3.92, 1, 1),
(54, 1, 61, 64, 25000, 3.92, 0, 1),
(55, 1, 61, 64, 50000, 4.22, 1, 1),
(56, 1, 61, 64, 50000, 4.22, 0, 1),
(57, 1, 61, 64, 100000, 4.94, 1, 1),
(58, 1, 61, 64, 100000, 4.94, 0, 1),
(59, 1, 61, 64, 150000, 5.78, 1, 1),
(60, 1, 61, 64, 150000, 5.78, 0, 1),
(61, 1, 61, 64, 200000, 8.33, 1, 1),
(62, 1, 61, 64, 200000, 8.33, 0, 1),
(63, 1, 61, 64, 300000, 9.65, 1, 1),
(64, 1, 61, 64, 300000, 9.65, 0, 1),
(65, 1, 65, 69, 10000, 3.15, 1, 1),
(66, 1, 65, 69, 10000, 3.15, 0, 1),
(67, 1, 65, 69, 15000, 4.11, 1, 1),
(68, 1, 65, 69, 15000, 4.11, 0, 1),
(69, 1, 65, 69, 25000, 4.96, 1, 1),
(70, 1, 65, 69, 25000, 4.96, 0, 1),
(71, 1, 65, 69, 50000, 5.04, 1, 1),
(72, 1, 65, 69, 50000, 5.04, 0, 1),
(73, 1, 65, 69, 100000, 6.24, 1, 1),
(74, 1, 65, 69, 100000, 6.24, 0, 1),
(75, 1, 65, 69, 150000, 7.77, 1, 1),
(76, 1, 65, 69, 150000, 7.77, 0, 1),
(77, 1, 65, 69, 200000, 9.71, 1, 1),
(78, 1, 65, 69, 200000, 9.71, 0, 1),
(79, 1, 65, 69, 300000, 11.27, 1, 1),
(80, 1, 65, 69, 300000, 11.27, 0, 1),
(81, 1, 70, 74, 10000, 5.09, 1, 1),
(82, 1, 70, 74, 10000, 5.09, 0, 1),
(83, 1, 70, 74, 15000, 6.64, 1, 1),
(84, 1, 70, 74, 15000, 6.64, 0, 1),
(85, 1, 70, 74, 25000, 7.98, 1, 1),
(86, 1, 70, 74, 25000, 7.98, 0, 1),
(87, 1, 70, 74, 50000, 8.77, 1, 1),
(88, 1, 70, 74, 50000, 8.77, 0, 1),
(89, 1, 70, 74, 100000, 9.77, 1, 1),
(90, 1, 70, 74, 100000, 9.77, 0, 1),
(91, 1, 70, 74, 150000, 12.78, 1, 1),
(92, 1, 70, 74, 150000, 12.78, 0, 1),
(93, 1, 70, 74, 200000, 15.97, 1, 1),
(94, 1, 70, 74, 200000, 15.97, 0, 1),
(95, 1, 70, 74, 300000, 18.38, 1, 1),
(96, 1, 70, 74, 300000, 18.38, 0, 1),
(97, 1, 75, 79, 10000, 6.09, 1, 1),
(98, 1, 75, 79, 10000, 6.09, 0, 1),
(99, 1, 75, 79, 15000, 7.92, 1, 1),
(100, 1, 75, 79, 15000, 7.92, 0, 1),
(101, 1, 75, 79, 25000, 9.41, 1, 1),
(102, 1, 75, 79, 25000, 9.41, 0, 1),
(103, 1, 75, 79, 50000, 9.98, 1, 1),
(104, 1, 75, 79, 50000, 9.98, 0, 1),
(105, 1, 75, 79, 100000, 12.17, 1, 1),
(106, 1, 75, 79, 100000, 12.17, 0, 1),
(107, 1, 75, 79, 150000, 14.49, 1, 1),
(108, 1, 75, 79, 150000, 14.49, 0, 1),
(109, 1, 75, 79, 200000, 18.91, 1, 1),
(110, 1, 75, 79, 200000, 18.91, 0, 1),
(111, 1, 75, 79, 300000, 21, 1, 1),
(112, 1, 75, 79, 300000, 21, 0, 1),
(113, 1, 80, 85, 10000, 9.98, 1, 1),
(114, 1, 80, 85, 10000, 9.98, 0, 1),
(115, 1, 80, 85, 15000, NULL, 1, 0),
(116, 1, 80, 85, 15000, NULL, 0, 0),
(117, 1, 80, 85, 25000, 13.65, 1, 1),
(118, 1, 80, 85, 25000, 13.65, 0, 1),
(119, 1, 80, 85, 50000, 16.3, 1, 1),
(120, 1, 80, 85, 50000, 16.3, 0, 1),
(121, 1, 80, 85, 100000, 19.95, 1, 1),
(122, 1, 80, 85, 100000, 19.95, 0, 1),
(123, 1, 80, 85, 150000, NULL, 1, 0),
(124, 1, 80, 85, 150000, NULL, 0, 0),
(125, 1, 80, 85, 200000, NULL, 1, 0),
(126, 1, 80, 85, 200000, NULL, 0, 0),
(127, 1, 80, 85, 300000, NULL, 1, 0),
(128, 1, 80, 85, 300000, NULL, 0, 0),
(129, 1, 86, NULL, 10000, NULL, 1, 0),
(130, 1, 86, NULL, 10000, NULL, 0, 0),
(131, 1, 86, NULL, 15000, NULL, 1, 0),
(132, 1, 86, NULL, 15000, NULL, 0, 0),
(133, 1, 86, NULL, 25000, NULL, 1, 0),
(134, 1, 86, NULL, 25000, NULL, 0, 0),
(135, 1, 86, NULL, 50000, NULL, 1, 0),
(136, 1, 86, NULL, 50000, NULL, 0, 0),
(137, 1, 86, NULL, 100000, NULL, 1, 0),
(138, 1, 86, NULL, 100000, NULL, 0, 0),
(139, 1, 86, NULL, 150000, NULL, 1, 0),
(140, 1, 86, NULL, 150000, NULL, 0, 0),
(141, 1, 86, NULL, 200000, NULL, 1, 0),
(142, 1, 86, NULL, 200000, NULL, 0, 0),
(143, 1, 86, NULL, 300000, NULL, 1, 0),
(144, 1, 86, NULL, 300000, NULL, 0, 0),
(145, 2, 0, 25, 10000, 1.14, 1, 1),
(146, 2, 0, 25, 10000, 1.14, 0, 1),
(147, 2, 0, 25, 15000, 1.43, 1, 1),
(148, 2, 0, 25, 15000, 1.43, 0, 1),
(149, 2, 0, 25, 25000, 1.55, 1, 1),
(150, 2, 0, 25, 25000, 1.55, 0, 1),
(151, 2, 0, 25, 50000, 1.7, 1, 1),
(152, 2, 0, 25, 50000, 1.7, 0, 1),
(153, 2, 0, 25, 100000, 2.28, 1, 1),
(154, 2, 0, 25, 100000, 2.28, 0, 1),
(155, 2, 0, 25, 150000, 2.72, 1, 1),
(156, 2, 0, 25, 150000, 2.72, 0, 1),
(157, 2, 0, 25, 200000, 3.4, 1, 1),
(158, 2, 0, 25, 200000, 3.4, 0, 1),
(159, 2, 0, 25, 300000, 4.41, 1, 1),
(160, 2, 0, 25, 300000, 4.41, 0, 1),
(161, 2, 26, 40, 10000, 1.28, 1, 1),
(162, 2, 26, 40, 10000, 1.28, 0, 1),
(163, 2, 26, 40, 15000, 1.55, 1, 1),
(164, 2, 26, 40, 15000, 1.55, 0, 1),
(165, 2, 26, 40, 25000, 1.7, 1, 1),
(166, 2, 26, 40, 25000, 1.7, 0, 1),
(167, 2, 26, 40, 50000, 1.85, 1, 1),
(168, 2, 26, 40, 50000, 1.85, 0, 1),
(169, 2, 26, 40, 100000, 2.65, 1, 1),
(170, 2, 26, 40, 100000, 2.65, 0, 1),
(171, 2, 26, 40, 150000, 3.09, 1, 1),
(172, 2, 26, 40, 150000, 3.09, 0, 1),
(173, 2, 26, 40, 200000, 3.85, 1, 1),
(174, 2, 26, 40, 200000, 3.85, 0, 1),
(175, 2, 26, 40, 300000, 4.78, 1, 1),
(176, 2, 26, 40, 300000, 4.78, 0, 1),
(177, 2, 41, 60, 10000, 1.43, 1, 1),
(178, 2, 41, 60, 10000, 1.43, 0, 1),
(179, 2, 41, 60, 15000, 1.79, 1, 1),
(180, 2, 41, 60, 15000, 1.79, 0, 1),
(181, 2, 41, 60, 25000, 1.99, 1, 1),
(182, 2, 41, 60, 25000, 1.99, 0, 1),
(183, 2, 41, 60, 50000, 2.28, 1, 1),
(184, 2, 41, 60, 50000, 2.28, 0, 1),
(185, 2, 41, 60, 100000, 3.38, 1, 1),
(186, 2, 41, 60, 100000, 3.38, 0, 1),
(187, 2, 41, 60, 150000, 4.05, 1, 1),
(188, 2, 41, 60, 150000, 4.05, 0, 1),
(189, 2, 41, 60, 200000, 6.11, 1, 1),
(190, 2, 41, 60, 200000, 6.11, 0, 1),
(191, 2, 41, 60, 300000, 6.07, 1, 1),
(192, 2, 41, 60, 300000, 6.07, 0, 1),
(193, 2, 61, 64, 10000, 1.84, 1, 1),
(194, 2, 61, 64, 10000, 1.84, 0, 1),
(195, 2, 61, 64, 15000, 2.18, 1, 1),
(196, 2, 61, 64, 15000, 2.18, 0, 1),
(197, 2, 61, 64, 25000, 2.75, 1, 1),
(198, 2, 61, 64, 25000, 2.75, 0, 1),
(199, 2, 61, 64, 50000, 3.31, 1, 1),
(200, 2, 61, 64, 50000, 3.31, 0, 1),
(201, 2, 61, 64, 100000, 3.97, 1, 1),
(202, 2, 61, 64, 100000, 3.97, 0, 1),
(203, 2, 61, 64, 150000, 4.7, 1, 1),
(204, 2, 61, 64, 150000, 4.7, 0, 1),
(205, 2, 61, 64, 200000, 6.75, 1, 1),
(206, 2, 61, 64, 200000, 6.75, 0, 1),
(207, 2, 61, 64, 300000, 6.76, 1, 1),
(208, 2, 61, 64, 300000, 6.76, 0, 1),
(209, 2, 65, 69, 10000, 2.1, 1, 1),
(210, 2, 65, 69, 10000, 2.1, 0, 1),
(211, 2, 65, 69, 15000, 2.74, 1, 1),
(212, 2, 65, 69, 15000, 2.74, 0, 1),
(213, 2, 65, 69, 25000, 3.09, 1, 1),
(214, 2, 65, 69, 25000, 3.09, 0, 1),
(215, 2, 65, 69, 50000, 3.68, 1, 1),
(216, 2, 65, 69, 50000, 3.68, 0, 1),
(217, 2, 65, 69, 100000, 5.08, 1, 1),
(218, 2, 65, 69, 100000, 5.08, 0, 1),
(219, 2, 65, 69, 150000, 5.45, 1, 1),
(220, 2, 65, 69, 150000, 5.45, 0, 1),
(221, 2, 65, 69, 200000, 7.4, 1, 1),
(222, 2, 65, 69, 200000, 7.4, 0, 1),
(223, 2, 65, 69, 300000, 8.02, 1, 1),
(224, 2, 65, 69, 300000, 8.02, 0, 1),
(225, 2, 70, 74, 10000, 3.31, 1, 1),
(226, 2, 70, 74, 10000, 3.31, 0, 1),
(227, 2, 70, 74, 15000, 4.39, 1, 1),
(228, 2, 70, 74, 15000, 4.39, 0, 1),
(229, 2, 70, 74, 25000, 4.3, 1, 1),
(230, 2, 70, 74, 25000, 4.3, 0, 1),
(231, 2, 70, 74, 50000, 6.16, 1, 1),
(232, 2, 70, 74, 50000, 6.16, 0, 1),
(233, 2, 70, 74, 100000, 6.99, 1, 1),
(234, 2, 70, 74, 100000, 6.99, 0, 1),
(235, 2, 70, 74, 150000, 9, 1, 1),
(236, 2, 70, 74, 150000, 9, 0, 1),
(237, 2, 70, 74, 200000, 12.5, 1, 1),
(238, 2, 70, 74, 200000, 12.5, 0, 1),
(239, 2, 70, 74, 300000, 12.96, 1, 1),
(240, 2, 70, 74, 300000, 12.96, 0, 1),
(241, 2, 75, 79, 10000, 4.05, 1, 1),
(242, 2, 75, 79, 10000, 4.05, 0, 1),
(243, 2, 75, 79, 15000, 5.26, 1, 1),
(244, 2, 75, 79, 15000, 5.26, 0, 1),
(245, 2, 75, 79, 25000, 5.08, 1, 1),
(246, 2, 75, 79, 25000, 5.08, 0, 1),
(247, 2, 75, 79, 50000, 7.16, 1, 1),
(248, 2, 75, 79, 50000, 7.16, 0, 1),
(249, 2, 75, 79, 100000, 8.76, 1, 1),
(250, 2, 75, 79, 100000, 8.76, 0, 1),
(251, 2, 75, 79, 150000, 10.25, 1, 1),
(252, 2, 75, 79, 150000, 10.25, 0, 1),
(253, 2, 75, 79, 200000, 13.58, 1, 1),
(254, 2, 75, 79, 200000, 13.58, 0, 1),
(255, 2, 75, 79, 300000, 14.98, 1, 1),
(256, 2, 75, 79, 300000, 14.98, 0, 1),
(257, 2, 80, 85, 10000, 5.93, 1, 1),
(258, 2, 80, 85, 10000, 5.93, 0, 1),
(259, 2, 80, 85, 15000, 7.64, 1, 1),
(260, 2, 80, 85, 15000, 7.64, 0, 1),
(261, 2, 80, 85, 25000, 9.35, 1, 1),
(262, 2, 80, 85, 25000, 9.35, 0, 1),
(263, 2, 80, 85, 50000, 10, 1, 1),
(264, 2, 80, 85, 50000, 10, 0, 1),
(265, 2, 80, 85, 100000, 13.94, 1, 1),
(266, 2, 80, 85, 100000, 13.94, 0, 1),
(267, 2, 80, 85, 150000, 15.5, 1, 1),
(268, 2, 80, 85, 150000, 15.5, 0, 1),
(269, 2, 80, 85, 200000, 18.85, 1, 1),
(270, 2, 80, 85, 200000, 18.85, 0, 1),
(271, 2, 80, 85, 300000, NULL, 1, 0),
(272, 2, 80, 85, 300000, NULL, 0, 0),
(273, 2, 86, NULL, 10000, 9.13, 1, 1),
(274, 2, 86, NULL, 10000, 9.13, 0, 1),
(275, 2, 86, NULL, 15000, 12, 1, 1),
(276, 2, 86, NULL, 15000, 12, 0, 1),
(277, 2, 86, NULL, 25000, 14.3, 1, 1),
(278, 2, 86, NULL, 25000, 14.3, 0, 1),
(279, 2, 86, NULL, 50000, 16.4, 1, 1),
(280, 2, 86, NULL, 50000, 16.4, 0, 1),
(281, 2, 86, NULL, 100000, 22.3, 1, 1),
(282, 2, 86, NULL, 100000, 22.3, 0, 1),
(283, 2, 86, NULL, 150000, NULL, 1, 0),
(284, 2, 86, NULL, 150000, NULL, 0, 0),
(285, 2, 86, NULL, 200000, NULL, 1, 0),
(286, 2, 86, NULL, 200000, NULL, 0, 0),
(287, 2, 86, NULL, 300000, NULL, 1, 0),
(288, 2, 86, NULL, 300000, NULL, 0, 0),
(289, 3, 0, 25, 25000, 2.34, 1, 1),
(290, 3, 0, 25, 25000, 2.34, 0, 1),
(291, 3, 0, 25, 50000, 2.69, 1, 1),
(292, 3, 0, 25, 50000, 2.69, 0, 1),
(293, 3, 0, 25, 100000, 3.41, 1, 1),
(294, 3, 0, 25, 100000, 3.41, 0, 1),
(295, 3, 0, 25, 500000, 7.73, 1, 1),
(296, 3, 0, 25, 500000, 7.73, 0, 1),
(297, 3, 26, 34, 25000, 2.52, 1, 1),
(298, 3, 26, 34, 25000, 2.52, 0, 1),
(299, 3, 26, 34, 50000, 2.87, 1, 1),
(300, 3, 26, 34, 50000, 2.87, 0, 1),
(301, 3, 26, 34, 100000, 3.76, 1, 1),
(302, 3, 26, 34, 100000, 3.76, 0, 1),
(303, 3, 26, 34, 500000, 8.49, 1, 1),
(304, 3, 26, 34, 500000, 8.49, 0, 1),
(305, 3, 35, 39, 25000, 2.69, 1, 1),
(306, 3, 35, 39, 25000, 2.69, 0, 1),
(307, 3, 35, 39, 50000, 3, 1, 1),
(308, 3, 35, 39, 50000, 3, 0, 1),
(309, 3, 35, 39, 100000, 3.9, 1, 1),
(310, 3, 35, 39, 100000, 3.9, 0, 1),
(311, 3, 35, 39, 500000, 9.08, 1, 1),
(312, 3, 35, 39, 500000, 9.08, 0, 1),
(313, 3, 40, 54, 25000, 3.01, 1, 1),
(314, 3, 40, 54, 25000, 3.01, 0, 1),
(315, 3, 40, 54, 50000, 3.41, 1, 1),
(316, 3, 40, 54, 50000, 3.41, 0, 1),
(317, 3, 40, 54, 100000, 4.97, 1, 1),
(318, 3, 40, 54, 100000, 4.97, 0, 1),
(319, 3, 40, 54, 500000, 11.15, 1, 1),
(320, 3, 40, 54, 500000, 11.15, 0, 1),
(321, 3, 55, 59, 25000, 3.72, 1, 1),
(322, 3, 55, 59, 25000, 3.72, 0, 1),
(323, 3, 55, 59, 50000, 4.19, 1, 1),
(324, 3, 55, 59, 50000, 4.19, 0, 1),
(325, 3, 55, 59, 100000, 6.05, 1, 1),
(326, 3, 55, 59, 100000, 6.05, 0, 1),
(327, 3, 55, 59, 500000, 11.71, 1, 1),
(328, 3, 55, 59, 500000, 11.71, 0, 1),
(329, 3, 60, 64, 25000, 4.92, 1, 1),
(330, 3, 60, 64, 25000, 4.92, 0, 1),
(331, 3, 60, 64, 50000, 5.77, 1, 1),
(332, 3, 60, 64, 50000, 5.77, 0, 1),
(333, 3, 60, 64, 100000, 7.14, 1, 1),
(334, 3, 60, 64, 100000, 7.14, 0, 1),
(335, 3, 60, 64, 500000, 13.21, 1, 1),
(336, 3, 60, 64, 500000, 13.21, 0, 1),
(337, 3, 65, 69, 25000, 7.07, 1, 1),
(338, 3, 65, 69, 25000, 7.07, 0, 1),
(339, 3, 65, 69, 50000, 8.84, 1, 1),
(340, 3, 65, 69, 50000, 8.84, 0, 1),
(341, 3, 65, 69, 100000, 10.71, 1, 1),
(342, 3, 65, 69, 100000, 10.71, 0, 1),
(343, 3, 65, 69, 500000, 15.69, 1, 1),
(344, 3, 65, 69, 500000, 15.69, 0, 1),
(345, 3, 70, 74, 25000, 8.42, 1, 1),
(346, 3, 70, 74, 25000, 8.42, 0, 1),
(347, 3, 70, 74, 50000, 10, 1, 1),
(348, 3, 70, 74, 50000, 10, 0, 1),
(349, 3, 70, 74, 100000, 12.56, 1, 1),
(350, 3, 70, 74, 100000, 12.56, 0, 1),
(351, 3, 70, 74, 500000, 24.61, 1, 1),
(352, 3, 70, 74, 500000, 24.61, 0, 1),
(353, 3, 75, 79, 25000, 12.46, 1, 1),
(354, 3, 75, 79, 25000, 12.46, 0, 1),
(355, 3, 75, 79, 50000, 14.8, 1, 1),
(356, 3, 75, 79, 50000, 14.8, 0, 1),
(357, 3, 75, 79, 100000, 18.59, 1, 1),
(358, 3, 75, 79, 100000, 18.59, 0, 1),
(359, 3, 75, 79, 500000, 36.42, 1, 1),
(360, 3, 75, 79, 500000, 36.42, 0, 1),
(361, 3, 80, 84, 25000, 22.6, 1, 1),
(362, 3, 80, 84, 25000, 22.6, 0, 1),
(363, 3, 80, 84, 50000, 28.64, 1, 1),
(364, 3, 80, 84, 50000, 28.64, 0, 1),
(365, 3, 80, 84, 100000, 36.24, 1, 1),
(366, 3, 80, 84, 100000, 36.24, 0, 1),
(367, 3, 80, 84, 500000, 68.72, 1, 1),
(368, 3, 80, 84, 500000, 68.72, 0, 1),
(369, 3, 85, 89, 25000, 63.72, 1, 1),
(370, 3, 85, 89, 25000, 63.72, 0, 1),
(371, 3, 85, 89, 50000, 80.79, 1, 1),
(372, 3, 85, 89, 50000, 80.79, 0, 1),
(373, 3, 85, 89, 100000, 102.21, 1, 1),
(374, 3, 85, 89, 100000, 102.21, 0, 1),
(375, 3, 85, 89, 500000, 226.92, 1, 1),
(376, 3, 85, 89, 500000, 226.92, 0, 1),
(377, 4, 0, 25, 25000, NULL, 1, 0),
(378, 4, 0, 25, 25000, NULL, 0, 0),
(379, 4, 0, 25, 50000, NULL, 1, 0),
(380, 4, 0, 25, 50000, NULL, 0, 0),
(381, 4, 0, 25, 100000, NULL, 1, 0),
(382, 4, 0, 25, 100000, NULL, 0, 0),
(383, 4, 0, 25, 500000, NULL, 1, 0),
(384, 4, 0, 25, 500000, NULL, 0, 0),
(385, 4, 26, 34, 25000, NULL, 1, 0),
(386, 4, 26, 34, 25000, NULL, 0, 0),
(387, 4, 26, 34, 50000, NULL, 1, 0),
(388, 4, 26, 34, 50000, NULL, 0, 0),
(389, 4, 26, 34, 100000, NULL, 1, 0),
(390, 4, 26, 34, 100000, NULL, 0, 0),
(391, 4, 26, 34, 500000, NULL, 1, 0),
(392, 4, 26, 34, 500000, NULL, 0, 0),
(393, 4, 35, 39, 25000, NULL, 1, 0),
(394, 4, 35, 39, 25000, NULL, 0, 0),
(395, 4, 35, 39, 50000, NULL, 1, 0),
(396, 4, 35, 39, 50000, NULL, 0, 0),
(397, 4, 35, 39, 100000, NULL, 1, 0),
(398, 4, 35, 39, 100000, NULL, 0, 0),
(399, 4, 35, 39, 500000, NULL, 1, 0),
(400, 4, 35, 39, 500000, NULL, 0, 0),
(401, 4, 40, 54, 25000, NULL, 1, 0),
(402, 4, 40, 54, 25000, NULL, 0, 0),
(403, 4, 40, 54, 50000, NULL, 1, 0),
(404, 4, 40, 54, 50000, NULL, 0, 0),
(405, 4, 40, 54, 100000, NULL, 1, 0),
(406, 4, 40, 54, 100000, NULL, 0, 0),
(407, 4, 40, 54, 500000, NULL, 1, 0),
(408, 4, 40, 54, 500000, NULL, 0, 0),
(409, 4, 55, 59, 25000, NULL, 1, 0),
(410, 4, 55, 59, 25000, NULL, 0, 0),
(411, 4, 55, 59, 50000, NULL, 1, 0),
(412, 4, 55, 59, 50000, NULL, 0, 0),
(413, 4, 55, 59, 100000, NULL, 1, 0),
(414, 4, 55, 59, 100000, NULL, 0, 0),
(415, 4, 55, 59, 500000, NULL, 1, 0),
(416, 4, 55, 59, 500000, NULL, 0, 0),
(417, 4, 60, 64, 25000, NULL, 1, 0),
(418, 4, 60, 64, 25000, NULL, 0, 0),
(419, 4, 60, 64, 50000, NULL, 1, 0),
(420, 4, 60, 64, 50000, NULL, 0, 0),
(421, 4, 60, 64, 100000, NULL, 1, 0),
(422, 4, 60, 64, 100000, NULL, 0, 0),
(423, 4, 60, 64, 500000, NULL, 1, 0),
(424, 4, 60, 64, 500000, NULL, 0, 0),
(425, 4, 65, 69, 25000, NULL, 1, 0),
(426, 4, 65, 69, 25000, NULL, 0, 0),
(427, 4, 65, 69, 50000, NULL, 1, 0),
(428, 4, 65, 69, 50000, NULL, 0, 0),
(429, 4, 65, 69, 100000, NULL, 1, 0),
(430, 4, 65, 69, 100000, NULL, 0, 0),
(431, 4, 65, 69, 500000, NULL, 1, 0),
(432, 4, 65, 69, 500000, NULL, 0, 0),
(433, 4, 70, 74, 25000, NULL, 1, 0),
(434, 4, 70, 74, 25000, NULL, 0, 0),
(435, 4, 70, 74, 50000, NULL, 1, 0),
(436, 4, 70, 74, 50000, NULL, 0, 0),
(437, 4, 70, 74, 100000, NULL, 1, 0),
(438, 4, 70, 74, 100000, NULL, 0, 0),
(439, 4, 70, 74, 500000, NULL, 1, 0),
(440, 4, 70, 74, 500000, NULL, 0, 0),
(441, 4, 75, 79, 25000, NULL, 1, 0),
(442, 4, 75, 79, 25000, NULL, 0, 0),
(443, 4, 75, 79, 50000, NULL, 1, 0),
(444, 4, 75, 79, 50000, NULL, 0, 0),
(445, 4, 75, 79, 100000, NULL, 1, 0),
(446, 4, 75, 79, 100000, NULL, 0, 0),
(447, 4, 75, 79, 500000, NULL, 1, 0),
(448, 4, 75, 79, 500000, NULL, 0, 0),
(449, 4, 80, 84, 25000, NULL, 1, 0),
(450, 4, 80, 84, 25000, NULL, 0, 0),
(451, 4, 80, 84, 50000, NULL, 1, 0),
(452, 4, 80, 84, 50000, NULL, 0, 0),
(453, 4, 80, 84, 100000, NULL, 1, 0),
(454, 4, 80, 84, 100000, NULL, 0, 0),
(455, 4, 80, 84, 500000, NULL, 1, 0),
(456, 4, 80, 84, 500000, NULL, 0, 0),
(457, 4, 85, 89, 25000, NULL, 1, 0),
(458, 4, 85, 89, 25000, NULL, 0, 0),
(459, 4, 85, 89, 50000, NULL, 1, 0),
(460, 4, 85, 89, 50000, NULL, 0, 0),
(461, 4, 85, 89, 100000, NULL, 1, 0),
(462, 4, 85, 89, 100000, NULL, 0, 0),
(463, 4, 85, 89, 500000, NULL, 1, 0),
(464, 4, 85, 89, 500000, NULL, 0, 0),
(465, 5, 0, 25, 15000, 2.43, 1, 1),
(466, 5, 0, 25, 15000, 2.43, 0, 1),
(467, 5, 0, 25, 25000, 2.51, 1, 1),
(468, 5, 0, 25, 25000, 2.51, 0, 1),
(469, 5, 0, 25, 50000, 2.97, 1, 1),
(470, 5, 0, 25, 50000, 2.97, 0, 1),
(471, 5, 0, 25, 100000, 3.69, 1, 1),
(472, 5, 0, 25, 100000, 3.69, 0, 1),
(473, 5, 0, 25, 150000, 5.08, 1, 1),
(474, 5, 0, 25, 150000, 5.08, 0, 1),
(475, 5, 26, 34, 15000, 2.48, 1, 1),
(476, 5, 26, 34, 15000, 2.48, 0, 1),
(477, 5, 26, 34, 25000, 2.68, 1, 1),
(478, 5, 26, 34, 25000, 2.68, 0, 1),
(479, 5, 26, 34, 50000, 3.1, 1, 1),
(480, 5, 26, 34, 50000, 3.1, 0, 1),
(481, 5, 26, 34, 100000, 3.98, 1, 1),
(482, 5, 26, 34, 100000, 3.98, 0, 1),
(483, 5, 26, 34, 150000, 5.42, 1, 1),
(484, 5, 26, 34, 150000, 5.42, 0, 1),
(485, 5, 35, 39, 15000, 2.59, 1, 1),
(486, 5, 35, 39, 15000, 2.59, 0, 1),
(487, 5, 35, 39, 25000, 2.83, 1, 1),
(488, 5, 35, 39, 25000, 2.83, 0, 1),
(489, 5, 35, 39, 50000, 3.25, 1, 1),
(490, 5, 35, 39, 50000, 3.25, 0, 1),
(491, 5, 35, 39, 100000, 4.17, 1, 1),
(492, 5, 35, 39, 100000, 4.17, 0, 1),
(493, 5, 35, 39, 150000, 6.28, 1, 1),
(494, 5, 35, 39, 150000, 6.28, 0, 1),
(495, 5, 40, 54, 15000, 2.97, 1, 1),
(496, 5, 40, 54, 15000, 2.97, 0, 1),
(497, 5, 40, 54, 25000, 3.25, 1, 1),
(498, 5, 40, 54, 25000, 3.25, 0, 1),
(499, 5, 40, 54, 50000, 3.59, 1, 1),
(500, 5, 40, 54, 50000, 3.59, 0, 1),
(501, 5, 40, 54, 100000, 5.24, 1, 1),
(502, 5, 40, 54, 100000, 5.24, 0, 1),
(503, 5, 40, 54, 150000, 7.34, 1, 1),
(504, 5, 40, 54, 150000, 7.34, 0, 1),
(505, 5, 55, 59, 15000, 3.36, 1, 1),
(506, 5, 55, 59, 15000, 3.36, 0, 1),
(507, 5, 55, 59, 25000, 3.41, 1, 1),
(508, 5, 55, 59, 25000, 3.41, 0, 1),
(509, 5, 55, 59, 50000, 4.05, 1, 1),
(510, 5, 55, 59, 50000, 4.05, 0, 1),
(511, 5, 55, 59, 100000, 5.65, 1, 1),
(512, 5, 55, 59, 100000, 5.65, 0, 1),
(513, 5, 55, 59, 150000, 7.85, 1, 1),
(514, 5, 55, 59, 150000, 7.85, 0, 1),
(515, 5, 60, 64, 15000, 3.85, 1, 1),
(516, 5, 60, 64, 15000, 3.85, 0, 1),
(517, 5, 60, 64, 25000, 4.29, 1, 1),
(518, 5, 60, 64, 25000, 4.29, 0, 1),
(519, 5, 60, 64, 50000, 5.03, 1, 1),
(520, 5, 60, 64, 50000, 5.03, 0, 1),
(521, 5, 60, 64, 100000, 6.6, 1, 1),
(522, 5, 60, 64, 100000, 6.6, 0, 1),
(523, 5, 60, 64, 150000, 8.38, 1, 1),
(524, 5, 60, 64, 150000, 8.38, 0, 1),
(525, 5, 65, 69, 15000, 4.35, 1, 1),
(526, 5, 65, 69, 15000, 4.35, 0, 1),
(527, 5, 65, 69, 25000, 5.24, 1, 1),
(528, 5, 65, 69, 25000, 5.24, 0, 1),
(529, 5, 65, 69, 50000, 5.76, 1, 1),
(530, 5, 65, 69, 50000, 5.76, 0, 1),
(531, 5, 65, 69, 100000, 7.5, 1, 1),
(532, 5, 65, 69, 100000, 7.5, 0, 1),
(533, 5, 65, 69, 150000, 10.47, 1, 1),
(534, 5, 65, 69, 150000, 10.47, 0, 1),
(535, 5, 70, 74, 15000, 6.16, 1, 1),
(536, 5, 70, 74, 15000, 6.16, 0, 1),
(537, 5, 70, 74, 25000, 7.34, 1, 1),
(538, 5, 70, 74, 25000, 7.34, 0, 1),
(539, 5, 70, 74, 50000, 8.69, 1, 1),
(540, 5, 70, 74, 50000, 8.69, 0, 1),
(541, 5, 70, 74, 100000, 10.91, 1, 1),
(542, 5, 70, 74, 100000, 10.91, 0, 1),
(543, 5, 70, 74, 150000, NULL, 1, 0),
(544, 5, 70, 74, 150000, NULL, 0, 0),
(545, 5, 75, 79, 15000, 7.34, 1, 1),
(546, 5, 75, 79, 15000, 7.34, 0, 1),
(547, 5, 75, 79, 25000, 9.32, 1, 1),
(548, 5, 75, 79, 25000, 9.32, 0, 1),
(549, 5, 75, 79, 50000, 11.15, 1, 1),
(550, 5, 75, 79, 50000, 11.15, 0, 1),
(551, 5, 75, 79, 100000, 14.16, 1, 1),
(552, 5, 75, 79, 100000, 14.16, 0, 1),
(553, 5, 75, 79, 150000, NULL, 1, 0),
(554, 5, 75, 79, 150000, NULL, 0, 0),
(555, 5, 80, 85, 15000, 9.85, 1, 1),
(556, 5, 80, 85, 15000, 9.85, 0, 1),
(557, 5, 80, 85, 25000, 11.62, 1, 1),
(558, 5, 80, 85, 25000, 11.62, 0, 1),
(559, 5, 80, 85, 50000, 12.57, 1, 1),
(560, 5, 80, 85, 50000, 12.57, 0, 1),
(561, 5, 80, 85, 100000, 14.41, 1, 1),
(562, 5, 80, 85, 100000, 14.41, 0, 1),
(563, 5, 80, 85, 150000, NULL, 1, 0),
(564, 5, 80, 85, 150000, NULL, 0, 0),
(565, 6, 0, 25, 15000, 2.21, 1, 1),
(566, 6, 0, 25, 15000, 2.21, 0, 1),
(567, 6, 0, 25, 25000, 2.28, 1, 1),
(568, 6, 0, 25, 25000, 2.28, 0, 1),
(569, 6, 0, 25, 50000, 2.63, 1, 1),
(570, 6, 0, 25, 50000, 2.63, 0, 1),
(571, 6, 0, 25, 100000, 3.35, 1, 1),
(572, 6, 0, 25, 100000, 3.35, 0, 1),
(573, 6, 0, 25, 150000, 4.62, 1, 1),
(574, 6, 0, 25, 150000, 4.62, 0, 1),
(575, 6, 26, 34, 15000, 2.25, 1, 1),
(576, 6, 26, 34, 15000, 2.25, 0, 1),
(577, 6, 26, 34, 25000, 2.44, 1, 1),
(578, 6, 26, 34, 25000, 2.44, 0, 1),
(579, 6, 26, 34, 50000, 2.82, 1, 1),
(580, 6, 26, 34, 50000, 2.82, 0, 1),
(581, 6, 26, 34, 100000, 3.62, 1, 1),
(582, 6, 26, 34, 100000, 3.62, 0, 1),
(583, 6, 26, 34, 150000, 4.93, 1, 1),
(584, 6, 26, 34, 150000, 4.93, 0, 1),
(585, 6, 35, 39, 15000, 2.35, 1, 1),
(586, 6, 35, 39, 15000, 2.35, 0, 1),
(587, 6, 35, 39, 25000, 2.57, 1, 1),
(588, 6, 35, 39, 25000, 2.57, 0, 1),
(589, 6, 35, 39, 50000, 2.95, 1, 1),
(590, 6, 35, 39, 50000, 2.95, 0, 1),
(591, 6, 35, 39, 100000, 3.79, 1, 1),
(592, 6, 35, 39, 100000, 3.79, 0, 1),
(593, 6, 35, 39, 150000, 5.71, 1, 1),
(594, 6, 35, 39, 150000, 5.71, 0, 1),
(595, 6, 40, 54, 15000, 2.7, 1, 1),
(596, 6, 40, 54, 15000, 2.7, 0, 1),
(597, 6, 40, 54, 25000, 2.95, 1, 1),
(598, 6, 40, 54, 25000, 2.95, 0, 1),
(599, 6, 40, 54, 50000, 3.26, 1, 1),
(600, 6, 40, 54, 50000, 3.26, 0, 1),
(601, 6, 40, 54, 100000, 4.76, 1, 1),
(602, 6, 40, 54, 100000, 4.76, 0, 1),
(603, 6, 40, 54, 150000, 6.67, 1, 1),
(604, 6, 40, 54, 150000, 6.67, 0, 1),
(605, 6, 55, 59, 15000, 3.05, 1, 1),
(606, 6, 55, 59, 15000, 3.05, 0, 1),
(607, 6, 55, 59, 25000, 3.1, 1, 1),
(608, 6, 55, 59, 25000, 3.1, 0, 1),
(609, 6, 55, 59, 50000, 3.68, 1, 1),
(610, 6, 55, 59, 50000, 3.68, 0, 1),
(611, 6, 55, 59, 100000, 5.14, 1, 1),
(612, 6, 55, 59, 100000, 5.14, 0, 1),
(613, 6, 55, 59, 150000, 7.14, 1, 1),
(614, 6, 55, 59, 150000, 7.14, 0, 1),
(615, 6, 60, 64, 15000, 3.5, 1, 1),
(616, 6, 60, 64, 15000, 3.5, 0, 1),
(617, 6, 60, 64, 25000, 3.9, 1, 1),
(618, 6, 60, 64, 25000, 3.9, 0, 1),
(619, 6, 60, 64, 50000, 4.57, 1, 1),
(620, 6, 60, 64, 50000, 4.57, 0, 1),
(621, 6, 60, 64, 100000, 6, 1, 1),
(622, 6, 60, 64, 100000, 6, 0, 1),
(623, 6, 60, 64, 150000, 7.62, 1, 1),
(624, 6, 60, 64, 150000, 7.62, 0, 1),
(625, 6, 65, 69, 15000, 3.95, 1, 1),
(626, 6, 65, 69, 15000, 3.95, 0, 1),
(627, 6, 65, 69, 25000, 4.76, 1, 1),
(628, 6, 65, 69, 25000, 4.76, 0, 1),
(629, 6, 65, 69, 50000, 5.24, 1, 1),
(630, 6, 65, 69, 50000, 5.24, 0, 1),
(631, 6, 65, 69, 100000, 6.82, 1, 1),
(632, 6, 65, 69, 100000, 6.82, 0, 1),
(633, 6, 65, 69, 150000, 9.52, 1, 1),
(634, 6, 65, 69, 150000, 9.52, 0, 1),
(635, 6, 70, 74, 15000, 5.6, 1, 1),
(636, 6, 70, 74, 15000, 5.6, 0, 1),
(637, 6, 70, 74, 25000, 6.67, 1, 1),
(638, 6, 70, 74, 25000, 6.67, 0, 1),
(639, 6, 70, 74, 50000, 7.9, 1, 1),
(640, 6, 70, 74, 50000, 7.9, 0, 1),
(641, 6, 70, 74, 100000, 9.92, 1, 1),
(642, 6, 70, 74, 100000, 9.92, 0, 1),
(643, 6, 70, 74, 150000, NULL, 1, 0),
(644, 6, 70, 74, 150000, NULL, 0, 0),
(645, 6, 75, 79, 15000, 6.67, 1, 1),
(646, 6, 75, 79, 15000, 6.67, 0, 1),
(647, 6, 75, 79, 25000, 8.47, 1, 1),
(648, 6, 75, 79, 25000, 8.47, 0, 1),
(649, 6, 75, 79, 50000, 10.14, 1, 1),
(650, 6, 75, 79, 50000, 10.14, 0, 1),
(651, 6, 75, 79, 100000, 12.87, 1, 1),
(652, 6, 75, 79, 100000, 12.87, 0, 1),
(653, 6, 75, 79, 150000, NULL, 1, 0),
(654, 6, 75, 79, 150000, NULL, 0, 0),
(655, 6, 80, 85, 15000, 8.95, 1, 1),
(656, 6, 80, 85, 15000, 8.95, 0, 1),
(657, 6, 80, 85, 25000, 10.56, 1, 1),
(658, 6, 80, 85, 25000, 10.56, 0, 1),
(659, 6, 80, 85, 50000, 11.43, 1, 1),
(660, 6, 80, 85, 50000, 11.43, 0, 1),
(661, 6, 80, 85, 100000, 13.1, 1, 1),
(662, 6, 80, 85, 100000, 13.1, 0, 1),
(663, 6, 80, 85, 150000, NULL, 1, 0),
(664, 6, 80, 85, 150000, NULL, 0, 0),
(665, 9, 0, 25, 15000, 2.58, 1, 1),
(666, 9, 0, 25, 15000, 2.58, 0, 1),
(667, 9, 0, 25, 25000, 2.75, 1, 1),
(668, 9, 0, 25, 25000, 2.75, 0, 1),
(669, 9, 0, 25, 50000, 3.09, 1, 1),
(670, 9, 0, 25, 50000, 3.09, 0, 1),
(671, 9, 0, 25, 100000, 4.13, 1, 1),
(672, 9, 0, 25, 100000, 4.13, 0, 1),
(673, 9, 0, 25, 150000, 4.83, 1, 1),
(674, 9, 0, 25, 150000, 4.83, 0, 1),
(675, 9, 0, 25, 200000, 6.26, 1, 1),
(676, 9, 0, 25, 200000, 6.26, 0, 1),
(677, 9, 26, 34, 15000, 2.79, 1, 1),
(678, 9, 26, 34, 15000, 2.79, 0, 1),
(679, 9, 26, 34, 25000, 2.98, 1, 1),
(680, 9, 26, 34, 25000, 2.98, 0, 1),
(681, 9, 26, 34, 50000, 3.35, 1, 1),
(682, 9, 26, 34, 50000, 3.35, 0, 1),
(683, 9, 26, 34, 100000, 4.43, 1, 1),
(684, 9, 26, 34, 100000, 4.43, 0, 1),
(685, 9, 26, 34, 150000, 5.39, 1, 1),
(686, 9, 26, 34, 150000, 5.39, 0, 1),
(687, 9, 26, 34, 200000, 6.94, 1, 1),
(688, 9, 26, 34, 200000, 6.94, 0, 1),
(689, 9, 35, 39, 15000, 2.91, 1, 1),
(690, 9, 35, 39, 15000, 2.91, 0, 1),
(691, 9, 35, 39, 25000, 3.03, 1, 1),
(692, 9, 35, 39, 25000, 3.03, 0, 1),
(693, 9, 35, 39, 50000, 3.37, 1, 1),
(694, 9, 35, 39, 50000, 3.37, 0, 1),
(695, 9, 35, 39, 100000, 4.72, 1, 1),
(696, 9, 35, 39, 100000, 4.72, 0, 1),
(697, 9, 35, 39, 150000, 5.62, 1, 1),
(698, 9, 35, 39, 150000, 5.62, 0, 1),
(699, 9, 35, 39, 200000, 7.1, 1, 1),
(700, 9, 35, 39, 200000, 7.1, 0, 1),
(701, 9, 40, 54, 15000, 3.09, 1, 1),
(702, 9, 40, 54, 15000, 3.09, 0, 1),
(703, 9, 40, 54, 25000, 3.52, 1, 1),
(704, 9, 40, 54, 25000, 3.52, 0, 1),
(705, 9, 40, 54, 50000, 4.01, 1, 1),
(706, 9, 40, 54, 50000, 4.01, 0, 1),
(707, 9, 40, 54, 100000, 5.78, 1, 1),
(708, 9, 40, 54, 100000, 5.78, 0, 1),
(709, 9, 40, 54, 150000, 6.91, 1, 1),
(710, 9, 40, 54, 150000, 6.91, 0, 1),
(711, 9, 40, 54, 200000, 8.62, 1, 1),
(712, 9, 40, 54, 200000, 8.62, 0, 1),
(713, 9, 55, 59, 15000, 3.47, 1, 1),
(714, 9, 55, 59, 15000, 3.47, 0, 1),
(715, 9, 55, 59, 25000, 3.7, 1, 1),
(716, 9, 55, 59, 25000, 3.7, 0, 1),
(717, 9, 55, 59, 50000, 4.3, 1, 1),
(718, 9, 55, 59, 50000, 4.3, 0, 1),
(719, 9, 55, 59, 100000, 6.3, 1, 1),
(720, 9, 55, 59, 100000, 6.3, 0, 1),
(721, 9, 55, 59, 150000, 7.57, 1, 1),
(722, 9, 55, 59, 150000, 7.57, 0, 1),
(723, 9, 55, 59, 200000, 9.19, 1, 1),
(724, 9, 55, 59, 200000, 9.19, 0, 1),
(725, 9, 60, 64, 15000, 4.35, 1, 1),
(726, 9, 60, 64, 15000, 4.35, 0, 1),
(727, 9, 60, 64, 25000, 4.8, 1, 1),
(728, 9, 60, 64, 25000, 4.8, 0, 1),
(729, 9, 60, 64, 50000, 5.84, 1, 1),
(730, 9, 60, 64, 50000, 5.84, 0, 1),
(731, 9, 60, 64, 100000, 7.51, 1, 1),
(732, 9, 60, 64, 100000, 7.51, 0, 1),
(733, 9, 60, 64, 150000, 8.9, 1, 1),
(734, 9, 60, 64, 150000, 8.9, 0, 1),
(735, 9, 60, 64, 200000, 9.94, 1, 1),
(736, 9, 60, 64, 200000, 9.94, 0, 1),
(737, 9, 65, 69, 15000, 5.08, 1, 1),
(738, 9, 65, 69, 15000, 5.08, 0, 1),
(739, 9, 65, 69, 25000, 5.66, 1, 1),
(740, 9, 65, 69, 25000, 5.66, 0, 1),
(741, 9, 65, 69, 50000, 6.67, 1, 1),
(742, 9, 65, 69, 50000, 6.67, 0, 1),
(743, 9, 65, 69, 100000, 8.93, 1, 1),
(744, 9, 65, 69, 100000, 8.93, 0, 1),
(745, 9, 65, 69, 150000, 10.28, 1, 1),
(746, 9, 65, 69, 150000, 10.28, 0, 1),
(747, 9, 65, 69, 200000, 11.77, 1, 1),
(748, 9, 65, 69, 200000, 11.77, 0, 1),
(749, 9, 70, 74, 15000, 7.51, 1, 1),
(750, 9, 70, 74, 15000, 7.51, 0, 1),
(751, 9, 70, 74, 25000, 8.32, 1, 1),
(752, 9, 70, 74, 25000, 8.32, 0, 1),
(753, 9, 70, 74, 50000, 10.2, 1, 1),
(754, 9, 70, 74, 50000, 10.2, 0, 1),
(755, 9, 70, 74, 100000, 12.83, 1, 1),
(756, 9, 70, 74, 100000, 12.83, 0, 1),
(757, 9, 70, 74, 150000, 14.33, 1, 1),
(758, 9, 70, 74, 150000, 14.33, 0, 1),
(759, 9, 70, 74, 200000, 19.01, 1, 1),
(760, 9, 70, 74, 200000, 19.01, 0, 1),
(761, 9, 75, 79, 15000, 8.9, 1, 1),
(762, 9, 75, 79, 15000, 8.9, 0, 1),
(763, 9, 75, 79, 25000, 10.17, 1, 1),
(764, 9, 75, 79, 25000, 10.17, 0, 1),
(765, 9, 75, 79, 50000, 13.39, 1, 1),
(766, 9, 75, 79, 50000, 13.39, 0, 1),
(767, 9, 75, 79, 100000, 15.95, 1, 1),
(768, 9, 75, 79, 100000, 15.95, 0, 1),
(769, 9, 75, 79, 150000, 17.7, 1, 1),
(770, 9, 75, 79, 150000, 17.7, 0, 1),
(771, 9, 75, 79, 200000, 21.6, 1, 1),
(772, 9, 75, 79, 200000, 21.6, 0, 1),
(773, 9, 80, 85, 15000, 13.29, 1, 1),
(774, 9, 80, 85, 15000, 13.29, 0, 1),
(775, 9, 80, 85, 25000, 15.53, 1, 1),
(776, 9, 80, 85, 25000, 15.53, 0, 1),
(777, 9, 80, 85, 50000, 18.27, 1, 1),
(778, 9, 80, 85, 50000, 18.27, 0, 1),
(779, 9, 80, 85, 100000, 21.42, 1, 1),
(780, 9, 80, 85, 100000, 21.42, 0, 1),
(781, 9, 80, 85, 150000, 27.65, 1, 1),
(782, 9, 80, 85, 150000, 27.65, 0, 1),
(783, 9, 80, 85, 200000, 34.78, 1, 1),
(784, 9, 80, 85, 200000, 34.78, 0, 1),
(785, 9, 86, NULL, 15000, NULL, 1, 0),
(786, 9, 86, NULL, 15000, NULL, 0, 0),
(787, 9, 86, NULL, 25000, NULL, 1, 0),
(788, 9, 86, NULL, 25000, NULL, 0, 0),
(789, 9, 86, NULL, 50000, NULL, 1, 0),
(790, 9, 86, NULL, 50000, NULL, 0, 0),
(791, 9, 86, NULL, 100000, NULL, 1, 0),
(792, 9, 86, NULL, 100000, NULL, 0, 0),
(793, 9, 86, NULL, 150000, NULL, 1, 0),
(794, 9, 86, NULL, 150000, NULL, 0, 0),
(795, 9, 86, NULL, 200000, NULL, 1, 0),
(796, 9, 86, NULL, 200000, NULL, 0, 0),
(797, 7, 0, 25, 15000, 1.53, 1, 1),
(798, 7, 0, 25, 15000, 1.53, 0, 1),
(799, 7, 0, 25, 25000, 1.63, 1, 1),
(800, 7, 0, 25, 25000, 1.63, 0, 1),
(801, 7, 0, 25, 50000, 1.79, 1, 1),
(802, 7, 0, 25, 50000, 1.79, 0, 1),
(803, 7, 0, 25, 100000, 2.41, 1, 1),
(804, 7, 0, 25, 100000, 2.41, 0, 1),
(805, 7, 0, 25, 150000, 2.88, 1, 1),
(806, 7, 0, 25, 150000, 2.88, 0, 1),
(807, 7, 0, 25, 200000, 3.73, 1, 1),
(808, 7, 0, 25, 200000, 3.73, 0, 1),
(809, 7, 26, 34, 15000, 1.79, 1, 1),
(810, 7, 26, 34, 15000, 1.79, 0, 1),
(811, 7, 26, 34, 25000, 1.91, 1, 1),
(812, 7, 26, 34, 25000, 1.91, 0, 1),
(813, 7, 26, 34, 50000, 2.08, 1, 1),
(814, 7, 26, 34, 50000, 2.08, 0, 1),
(815, 7, 26, 34, 100000, 2.97, 1, 1),
(816, 7, 26, 34, 100000, 2.97, 0, 1),
(817, 7, 26, 34, 150000, 3.67, 1, 1),
(818, 7, 26, 34, 150000, 3.67, 0, 1),
(819, 7, 26, 34, 200000, 4.72, 1, 1),
(820, 7, 26, 34, 200000, 4.72, 0, 1),
(821, 7, 35, 39, 15000, 1.83, 1, 1),
(822, 7, 35, 39, 15000, 1.83, 0, 1),
(823, 7, 35, 39, 25000, 1.95, 1, 1),
(824, 7, 35, 39, 25000, 1.95, 0, 1),
(825, 7, 35, 39, 50000, 2.13, 1, 1),
(826, 7, 35, 39, 50000, 2.13, 0, 1),
(827, 7, 35, 39, 100000, 3.03, 1, 1),
(828, 7, 35, 39, 100000, 3.03, 0, 1),
(829, 7, 35, 39, 150000, 3.77, 1, 1),
(830, 7, 35, 39, 150000, 3.77, 0, 1),
(831, 7, 35, 39, 200000, 4.84, 1, 1),
(832, 7, 35, 39, 200000, 4.84, 0, 1),
(833, 7, 40, 54, 15000, 2.01, 1, 1),
(834, 7, 40, 54, 15000, 2.01, 0, 1),
(835, 7, 40, 54, 25000, 2.29, 1, 1),
(836, 7, 40, 54, 25000, 2.29, 0, 1),
(837, 7, 40, 54, 50000, 2.63, 1, 1),
(838, 7, 40, 54, 50000, 2.63, 0, 1),
(839, 7, 40, 54, 100000, 3.74, 1, 1),
(840, 7, 40, 54, 100000, 3.74, 0, 1),
(841, 7, 40, 54, 150000, 4.63, 1, 1),
(842, 7, 40, 54, 150000, 4.63, 0, 1),
(843, 7, 40, 54, 200000, 5.21, 1, 1),
(844, 7, 40, 54, 200000, 5.21, 0, 1),
(845, 7, 55, 59, 15000, 2.04, 1, 1),
(846, 7, 55, 59, 15000, 2.04, 0, 1),
(847, 7, 55, 59, 25000, 2.29, 1, 1),
(848, 7, 55, 59, 25000, 2.29, 0, 1),
(849, 7, 55, 59, 50000, 2.63, 1, 1),
(850, 7, 55, 59, 50000, 2.63, 0, 1),
(851, 7, 55, 59, 100000, 3.74, 1, 1),
(852, 7, 55, 59, 100000, 3.74, 0, 1),
(853, 7, 55, 59, 150000, 4.68, 1, 1),
(854, 7, 55, 59, 150000, 4.68, 0, 1),
(855, 7, 55, 59, 200000, 5.31, 1, 1),
(856, 7, 55, 59, 200000, 5.31, 0, 1),
(857, 7, 60, 64, 15000, 2.36, 1, 1),
(858, 7, 60, 64, 15000, 2.36, 0, 1),
(859, 7, 60, 64, 25000, 2.91, 1, 1),
(860, 7, 60, 64, 25000, 2.91, 0, 1),
(861, 7, 60, 64, 50000, 3.5, 1, 1),
(862, 7, 60, 64, 50000, 3.5, 0, 1),
(863, 7, 60, 64, 100000, 4.18, 1, 1),
(864, 7, 60, 64, 100000, 4.18, 0, 1),
(865, 7, 60, 64, 150000, 5.2, 1, 1),
(866, 7, 60, 64, 150000, 5.2, 0, 1),
(867, 7, 60, 64, 200000, 5.54, 1, 1),
(868, 7, 60, 64, 200000, 5.54, 0, 1),
(869, 7, 65, 69, 15000, 2.69, 1, 1),
(870, 7, 65, 69, 15000, 2.69, 0, 1),
(871, 7, 65, 69, 25000, 3.26, 1, 1),
(872, 7, 65, 69, 25000, 3.26, 0, 1),
(873, 7, 65, 69, 50000, 3.88, 1, 1),
(874, 7, 65, 69, 50000, 3.88, 0, 1),
(875, 7, 65, 69, 100000, 5.36, 1, 1),
(876, 7, 65, 69, 100000, 5.36, 0, 1),
(877, 7, 65, 69, 150000, 6.02, 1, 1),
(878, 7, 65, 69, 150000, 6.02, 0, 1),
(879, 7, 65, 69, 200000, 6.54, 1, 1),
(880, 7, 65, 69, 200000, 6.54, 0, 1),
(881, 7, 70, 74, 15000, 4.23, 1, 1),
(882, 7, 70, 74, 15000, 4.23, 0, 1),
(883, 7, 70, 74, 25000, 4.54, 1, 1),
(884, 7, 70, 74, 25000, 4.54, 0, 1),
(885, 7, 70, 74, 50000, 6.5, 1, 1),
(886, 7, 70, 74, 50000, 6.5, 0, 1),
(887, 7, 70, 74, 100000, 7.37, 1, 1),
(888, 7, 70, 74, 100000, 7.37, 0, 1),
(889, 7, 70, 74, 150000, 9.04, 1, 1),
(890, 7, 70, 74, 150000, 9.04, 0, 1),
(891, 7, 70, 74, 200000, 10.84, 1, 1),
(892, 7, 70, 74, 200000, 10.84, 0, 1),
(893, 7, 75, 79, 15000, 5.2, 1, 1),
(894, 7, 75, 79, 15000, 5.2, 0, 1),
(895, 7, 75, 79, 25000, 5.36, 1, 1),
(896, 7, 75, 79, 25000, 5.36, 0, 1),
(897, 7, 75, 79, 50000, 7.55, 1, 1),
(898, 7, 75, 79, 50000, 7.55, 0, 1),
(899, 7, 75, 79, 100000, 9.14, 1, 1),
(900, 7, 75, 79, 100000, 9.14, 0, 1),
(901, 7, 75, 79, 150000, 10.34, 1, 1),
(902, 7, 75, 79, 150000, 10.34, 0, 1),
(903, 7, 75, 79, 200000, 11.53, 1, 1),
(904, 7, 75, 79, 200000, 11.53, 0, 1),
(905, 7, 80, 85, 15000, 7.6, 1, 1),
(906, 7, 80, 85, 15000, 7.6, 0, 1),
(907, 7, 80, 85, 25000, 8.78, 1, 1),
(908, 7, 80, 85, 25000, 8.78, 0, 1),
(909, 7, 80, 85, 50000, 9.46, 1, 1),
(910, 7, 80, 85, 50000, 9.46, 0, 1),
(911, 7, 80, 85, 100000, 14.05, 1, 1),
(912, 7, 80, 85, 100000, 14.05, 0, 1),
(913, 7, 80, 85, 150000, 18.14, 1, 1),
(914, 7, 80, 85, 150000, 18.14, 0, 1),
(915, 7, 80, 85, 200000, 23.96, 1, 1),
(916, 7, 80, 85, 200000, 23.96, 0, 1),
(917, 7, 86, NULL, 15000, 12.21, 1, 1),
(918, 7, 86, NULL, 15000, 12.21, 0, 1),
(919, 7, 86, NULL, 25000, 15.26, 1, 1),
(920, 7, 86, NULL, 25000, 15.26, 0, 1),
(921, 7, 86, NULL, 50000, 22.14, 1, 1),
(922, 7, 86, NULL, 50000, 22.14, 0, 1),
(923, 7, 86, NULL, 100000, 23.78, 1, 1),
(924, 7, 86, NULL, 100000, 23.78, 0, 1),
(925, 7, 86, NULL, 150000, NULL, 1, 0),
(926, 7, 86, NULL, 150000, NULL, 0, 0),
(927, 7, 86, NULL, 200000, NULL, 1, 0),
(928, 7, 86, NULL, 200000, NULL, 0, 0),
(929, 8, 0, 25, 15000, 1.87, 1, 1),
(930, 8, 0, 25, 15000, 1.87, 0, 1),
(931, 8, 0, 25, 25000, 1.99, 1, 1),
(932, 8, 0, 25, 25000, 1.99, 0, 1),
(933, 8, 0, 25, 50000, 2.19, 1, 1),
(934, 8, 0, 25, 50000, 2.19, 0, 1),
(935, 8, 0, 25, 100000, 2.94, 1, 1),
(936, 8, 0, 25, 100000, 2.94, 0, 1),
(937, 8, 0, 25, 150000, 3.51, 1, 1),
(938, 8, 0, 25, 150000, 3.51, 0, 1),
(939, 8, 0, 25, 200000, 4.54, 1, 1),
(940, 8, 0, 25, 200000, 4.54, 0, 1),
(941, 8, 26, 34, 15000, 2.18, 1, 1),
(942, 8, 26, 34, 15000, 2.18, 0, 1),
(943, 8, 26, 34, 25000, 2.33, 1, 1),
(944, 8, 26, 34, 25000, 2.33, 0, 1),
(945, 8, 26, 34, 50000, 2.54, 1, 1),
(946, 8, 26, 34, 50000, 2.54, 0, 1),
(947, 8, 26, 34, 100000, 3.36, 1, 1),
(948, 8, 26, 34, 100000, 3.36, 0, 1),
(949, 8, 26, 34, 150000, 4.48, 1, 1),
(950, 8, 26, 34, 150000, 4.48, 0, 1),
(951, 8, 26, 34, 200000, 5.75, 1, 1),
(952, 8, 26, 34, 200000, 5.75, 0, 1),
(953, 8, 35, 39, 15000, 2.24, 1, 1),
(954, 8, 35, 39, 15000, 2.24, 0, 1),
(955, 8, 35, 39, 25000, 2.38, 1, 1),
(956, 8, 35, 39, 25000, 2.38, 0, 1),
(957, 8, 35, 39, 50000, 2.6, 1, 1),
(958, 8, 35, 39, 50000, 2.6, 0, 1),
(959, 8, 35, 39, 100000, 3.7, 1, 1),
(960, 8, 35, 39, 100000, 3.7, 0, 1),
(961, 8, 35, 39, 150000, 4.6, 1, 1),
(962, 8, 35, 39, 150000, 4.6, 0, 1),
(963, 8, 35, 39, 200000, 5.9, 1, 1),
(964, 8, 35, 39, 200000, 5.9, 0, 1),
(965, 8, 40, 54, 15000, 2.45, 1, 1),
(966, 8, 40, 54, 15000, 2.45, 0, 1),
(967, 8, 40, 54, 25000, 2.8, 1, 1),
(968, 8, 40, 54, 25000, 2.8, 0, 1),
(969, 8, 40, 54, 50000, 3.21, 1, 1),
(970, 8, 40, 54, 50000, 3.21, 0, 1),
(971, 8, 40, 54, 100000, 4.56, 1, 1),
(972, 8, 40, 54, 100000, 4.56, 0, 1),
(973, 8, 40, 54, 150000, 5.65, 1, 1),
(974, 8, 40, 54, 150000, 5.65, 0, 1),
(975, 8, 40, 54, 200000, 6.35, 1, 1),
(976, 8, 40, 54, 200000, 6.35, 0, 1),
(977, 8, 55, 59, 15000, 2.48, 1, 1),
(978, 8, 55, 59, 15000, 2.48, 0, 1),
(979, 8, 55, 59, 25000, 2.8, 1, 1),
(980, 8, 55, 59, 25000, 2.8, 0, 1),
(981, 8, 55, 59, 50000, 3.21, 1, 1),
(982, 8, 55, 59, 50000, 3.21, 0, 1),
(983, 8, 55, 59, 100000, 4.56, 1, 1),
(984, 8, 55, 59, 100000, 4.56, 0, 1),
(985, 8, 55, 59, 150000, 5.71, 1, 1),
(986, 8, 55, 59, 150000, 5.71, 0, 1),
(987, 8, 55, 59, 200000, 6.48, 1, 1),
(988, 8, 55, 59, 200000, 6.48, 0, 1),
(989, 8, 60, 64, 15000, 2.88, 1, 1),
(990, 8, 60, 64, 15000, 2.88, 0, 1),
(991, 8, 60, 64, 25000, 3.55, 1, 1),
(992, 8, 60, 64, 25000, 3.55, 0, 1),
(993, 8, 60, 64, 50000, 4.27, 1, 1),
(994, 8, 60, 64, 50000, 4.27, 0, 1),
(995, 8, 60, 64, 100000, 5.1, 1, 1),
(996, 8, 60, 64, 100000, 5.1, 0, 1),
(997, 8, 60, 64, 150000, 6.34, 1, 1),
(998, 8, 60, 64, 150000, 6.34, 0, 1),
(999, 8, 60, 64, 200000, 6.76, 1, 1),
(1000, 8, 60, 64, 200000, 6.76, 0, 1),
(1001, 8, 65, 69, 15000, 3.27, 1, 1),
(1002, 8, 65, 69, 15000, 3.27, 0, 1),
(1003, 8, 65, 69, 25000, 3.97, 1, 1),
(1004, 8, 65, 69, 25000, 3.97, 0, 1),
(1005, 8, 65, 69, 50000, 4.74, 1, 1),
(1006, 8, 65, 69, 50000, 4.74, 0, 1),
(1007, 8, 65, 69, 100000, 6.53, 1, 1),
(1008, 8, 65, 69, 100000, 6.53, 0, 1),
(1009, 8, 65, 69, 150000, 7.34, 1, 1),
(1010, 8, 65, 69, 150000, 7.34, 0, 1),
(1011, 8, 65, 69, 200000, 7.97, 1, 1),
(1012, 8, 65, 69, 200000, 7.97, 0, 1),
(1013, 8, 70, 74, 15000, 5.16, 1, 1),
(1014, 8, 70, 74, 15000, 5.16, 0, 1),
(1015, 8, 70, 74, 25000, 5.53, 1, 1),
(1016, 8, 70, 74, 25000, 5.53, 0, 1),
(1017, 8, 70, 74, 50000, 7.93, 1, 1),
(1018, 8, 70, 74, 50000, 7.93, 0, 1),
(1019, 8, 70, 74, 100000, 8.98, 1, 1),
(1020, 8, 70, 74, 100000, 8.98, 0, 1),
(1021, 8, 70, 74, 150000, 11.03, 1, 1),
(1022, 8, 70, 74, 150000, 11.03, 0, 1),
(1023, 8, 70, 74, 200000, 13.22, 1, 1),
(1024, 8, 70, 74, 200000, 13.22, 0, 1),
(1025, 8, 75, 79, 15000, 6.35, 1, 1),
(1026, 8, 75, 79, 15000, 6.35, 0, 1),
(1027, 8, 75, 79, 25000, 6.53, 1, 1),
(1028, 8, 75, 79, 25000, 6.53, 0, 1),
(1029, 8, 75, 79, 50000, 9.21, 1, 1),
(1030, 8, 75, 79, 50000, 9.21, 0, 1),
(1031, 8, 75, 79, 100000, 11.15, 1, 1),
(1032, 8, 75, 79, 100000, 11.15, 0, 1),
(1033, 8, 75, 79, 150000, 12.61, 1, 1),
(1034, 8, 75, 79, 150000, 12.61, 0, 1),
(1035, 8, 75, 79, 200000, 14.06, 1, 1),
(1036, 8, 75, 79, 200000, 14.06, 0, 1),
(1037, 8, 80, 85, 15000, 9.26, 1, 1),
(1038, 8, 80, 85, 15000, 9.26, 0, 1),
(1039, 8, 80, 85, 25000, 10.7, 1, 1),
(1040, 8, 80, 85, 25000, 10.7, 0, 1),
(1041, 8, 80, 85, 50000, 11.53, 1, 1),
(1042, 8, 80, 85, 50000, 11.53, 0, 1),
(1043, 8, 80, 85, 100000, 17.14, 1, 1),
(1044, 8, 80, 85, 100000, 17.14, 0, 1),
(1045, 8, 80, 85, 150000, 22.12, 1, 1),
(1046, 8, 80, 85, 150000, 22.12, 0, 1),
(1047, 8, 80, 85, 200000, 29.23, 1, 1),
(1048, 8, 80, 85, 200000, 29.23, 0, 1),
(1049, 8, 86, NULL, 15000, NULL, 1, 0),
(1050, 8, 86, NULL, 15000, NULL, 0, 0),
(1051, 8, 86, NULL, 25000, NULL, 1, 0),
(1052, 8, 86, NULL, 25000, NULL, 0, 0),
(1053, 8, 86, NULL, 50000, NULL, 1, 0),
(1054, 8, 86, NULL, 50000, NULL, 0, 0),
(1055, 8, 86, NULL, 100000, NULL, 1, 0),
(1056, 8, 86, NULL, 100000, NULL, 0, 0),
(1057, 8, 86, NULL, 150000, NULL, 1, 0),
(1058, 8, 86, NULL, 150000, NULL, 0, 0),
(1059, 8, 86, NULL, 200000, NULL, 1, 0),
(1060, 8, 86, NULL, 200000, NULL, 0, 0);

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

--
-- Table structure for table `provinces`
--

CREATE TABLE `provinces` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `provinces`
--

INSERT INTO `provinces` (`id`, `country_id`, `slug`, `is_active`) VALUES
(1, 1, 'alberta', 1),
(2, 1, 'british-columbia', 1),
(3, 1, 'manitoba', 1),
(4, 1, 'new-brunswick', 1),
(5, 1, 'newfoundland-and-labrador', 1),
(6, 1, 'nova-scotia', 1),
(7, 1, 'ontario', 1),
(8, 1, 'prince-edward-island', 1),
(9, 1, 'quebec', 1),
(10, 1, 'saskatchewan', 1),
(11, 1, 'northwest-territories', 1),
(12, 1, 'nunavut', 1),
(13, 1, 'yukon', 1);

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

--
-- Table structure for table `province_translations`
--

CREATE TABLE `province_translations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `province_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `province_translations`
--

INSERT INTO `province_translations` (`id`, `province_id`, `language_id`, `name`, `is_active`) VALUES
(1, 1, 1, 'Alberta', 1),
(2, 1, 2, 'Alberta', 1),
(3, 2, 1, 'British Columbia', 1),
(4, 2, 2, 'British Columbia', 1),
(5, 3, 1, 'Manitoba', 1),
(6, 3, 2, 'Manitoba', 1),
(7, 4, 1, 'New Brunswick', 1),
(8, 4, 2, 'New Brunswick', 1),
(9, 5, 1, 'Newfoundland and Labrador', 1),
(10, 5, 2, 'Newfoundland and Labrador', 1),
(11, 6, 1, 'Nova Scotia', 1),
(12, 6, 2, 'Nova Scotia', 1),
(13, 7, 1, 'Ontario', 1),
(14, 7, 2, 'Ontario', 1),
(15, 8, 1, 'Prince Edward Island', 1),
(16, 8, 2, 'Prince Edward Island', 1),
(17, 9, 1, 'Quebec', 1),
(18, 9, 2, 'Quebec', 1),
(19, 10, 1, 'Saskatchewan', 1),
(20, 10, 2, 'Saskatchewan', 1),
(21, 11, 1, 'Northwest Territories', 1),
(22, 11, 2, 'Northwest Territories', 1),
(23, 12, 1, 'Nunavut', 1),
(24, 12, 2, 'Nunavut', 1),
(25, 13, 1, 'Yukon', 1),
(26, 13, 2, 'Yukon', 1);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `cities_slug_unique` (`slug`),
  ADD KEY `cities_province_id_foreign` (`province_id`);

--
-- Indexes for table `city_translations`
--
ALTER TABLE `city_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `city_translations_city_id_language_id_unique` (`city_id`,`language_id`),
  ADD KEY `city_translations_language_id_foreign` (`language_id`);

--
-- Indexes for table `companies`
--
ALTER TABLE `companies`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `companies_slug_unique` (`slug`);

--
-- Indexes for table `company_translations`
--
ALTER TABLE `company_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `company_translations_company_id_language_id_unique` (`company_id`,`language_id`),
  ADD KEY `company_translations_language_id_foreign` (`language_id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `countries_slug_unique` (`slug`);

--
-- Indexes for table `country_translations`
--
ALTER TABLE `country_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `country_translations_country_id_language_id_unique` (`country_id`,`language_id`),
  ADD KEY `country_translations_language_id_foreign` (`language_id`);

--
-- Indexes for table `deductibles`
--
ALTER TABLE `deductibles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `deductibles_slug_unique` (`slug`),
  ADD KEY `deductibles_company_id_foreign` (`company_id`);

--
-- Indexes for table `deductible_translations`
--
ALTER TABLE `deductible_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `deductible_translations_deductible_id_language_id_unique` (`deductible_id`,`language_id`),
  ADD KEY `deductible_translations_language_id_foreign` (`language_id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `languages_code_unique` (`code`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `people`
--
ALTER TABLE `people`
  ADD PRIMARY KEY (`id`),
  ADD KEY `people_inquiry_id_foreign` (`inquiry_id`),
  ADD KEY `people_deductible_id_foreign` (`deductible_id`),
  ADD KEY `people_price_id_foreign` (`price_id`);

--
-- Indexes for table `plans`
--
ALTER TABLE `plans`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plans_slug_unique` (`slug`),
  ADD KEY `plans_company_id_foreign` (`company_id`);

--
-- Indexes for table `plan_translations`
--
ALTER TABLE `plan_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `plan_translations_plan_id_language_id_unique` (`plan_id`,`language_id`),
  ADD KEY `plan_translations_language_id_foreign` (`language_id`);

--
-- Indexes for table `prices`
--
ALTER TABLE `prices`
  ADD PRIMARY KEY (`id`),
  ADD KEY `prices_plan_id_foreign` (`plan_id`);

--
-- Indexes for table `provinces`
--
ALTER TABLE `provinces`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `provinces_slug_unique` (`slug`),
  ADD KEY `provinces_country_id_foreign` (`country_id`);

--
-- Indexes for table `province_translations`
--
ALTER TABLE `province_translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `province_translations_province_id_language_id_unique` (`province_id`,`language_id`),
  ADD KEY `province_translations_language_id_foreign` (`language_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;

--
-- AUTO_INCREMENT for table `city_translations`
--
ALTER TABLE `city_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=345;

--
-- AUTO_INCREMENT for table `companies`
--
ALTER TABLE `companies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `company_translations`
--
ALTER TABLE `company_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `country_translations`
--
ALTER TABLE `country_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `deductibles`
--
ALTER TABLE `deductibles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `deductible_translations`
--
ALTER TABLE `deductible_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `plans`
--
ALTER TABLE `plans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `plan_translations`
--
ALTER TABLE `plan_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `prices`
--
ALTER TABLE `prices`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1061;

--
-- AUTO_INCREMENT for table `provinces`
--
ALTER TABLE `provinces`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `province_translations`
--
ALTER TABLE `province_translations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `city_translations`
--
ALTER TABLE `city_translations`
  ADD CONSTRAINT `city_translations_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `city_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `company_translations`
--
ALTER TABLE `company_translations`
  ADD CONSTRAINT `company_translations_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `company_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `country_translations`
--
ALTER TABLE `country_translations`
  ADD CONSTRAINT `country_translations_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `country_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `deductibles`
--
ALTER TABLE `deductibles`
  ADD CONSTRAINT `deductibles_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `deductible_translations`
--
ALTER TABLE `deductible_translations`
  ADD CONSTRAINT `deductible_translations_deductible_id_foreign` FOREIGN KEY (`deductible_id`) REFERENCES `deductibles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `deductible_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `people`
--
ALTER TABLE `people`
  ADD CONSTRAINT `people_deductible_id_foreign` FOREIGN KEY (`deductible_id`) REFERENCES `deductibles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `people_inquiry_id_foreign` FOREIGN KEY (`inquiry_id`) REFERENCES `inquiries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `people_price_id_foreign` FOREIGN KEY (`price_id`) REFERENCES `prices` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `plans`
--
ALTER TABLE `plans`
  ADD CONSTRAINT `plans_company_id_foreign` FOREIGN KEY (`company_id`) REFERENCES `companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `plan_translations`
--
ALTER TABLE `plan_translations`
  ADD CONSTRAINT `plan_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `plan_translations_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `prices`
--
ALTER TABLE `prices`
  ADD CONSTRAINT `prices_plan_id_foreign` FOREIGN KEY (`plan_id`) REFERENCES `plans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `provinces`
--
ALTER TABLE `provinces`
  ADD CONSTRAINT `provinces_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `province_translations`
--
ALTER TABLE `province_translations`
  ADD CONSTRAINT `province_translations_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `province_translations_province_id_foreign` FOREIGN KEY (`province_id`) REFERENCES `provinces` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

