ass2.sql

-- phpMyAdmin SQL Dump
-- version 5.0.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 13, 2020 at 11:39 PM
-- Server version: 10.4.13-MariaDB
-- PHP Version: 7.4.8

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `ass2`
--
CREATE DATABASE IF NOT EXISTS `ass2` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
USE `ass2`;

DELIMITER $$
--
-- Procedures
--
DROP PROCEDURE IF EXISTS `createNewFlights`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `createNewFlights` (IN `num_iterations` INT)  NO SQL
BEGIN

DECLARE done BOOLEAN DEFAULT FALSE;
DECLARE flight_id int;
  DECLARE route_id int;
  declare dates datetime;
  declare counter int default 0;
 
 DECLARE cur CURSOR FOR SELECT times.flight_id, times.route_id, times.time FROM times WHERE times.historic = 0;
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done := TRUE;
   label1: LOOP

  OPEN cur;

  testLoop: LOOP
    FETCH cur INTO flight_id, route_id,dates ;
     IF done THEN
      LEAVE testLoop;
    END IF;
      UPDATE `times` SET `Historic` = '1' WHERE `times`.`flight_ID` = flight_id;
      
     INSERT INTO `times` (`flight_ID`, `time`, `route_id`, `Historic`) VALUES (NULL,  DATE_ADD(dates,INTERVAL 2 WEEK),route_id, '0');
      
    
    
  END LOOP testLoop;

  CLOSE cur;
  SET counter = counter + 1;
    IF counter < num_iterations THEN
    	SET done = FALSE;
      ITERATE label1;
    END IF;
    INSERT INTO `debug_logging` (`timestamp`, `comment`, `id`) VALUES (current_timestamp(), concat('Iterated number: ', counter ), NULL);
    LEAVE label1;
  END LOOP label1;


END$$

DELIMITER ;

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

--
-- Table structure for table `aircraft`
--

DROP TABLE IF EXISTS `aircraft`;
CREATE TABLE `aircraft` (
  `model` varchar(55) NOT NULL,
  `craftID` varchar(3) NOT NULL,
  `capacity` int(11) NOT NULL,
  `rangenmi` float NOT NULL,
  `cruisekn` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `aircraft`
--

INSERT INTO `aircraft` (`model`, `craftID`, `capacity`, `rangenmi`, `cruisekn`) VALUES
('SyberJet SJ30i', 'A01', 6, 622, 233),
('Cirrus SF50', 'A02', 4, 1171, 342),
('HondaJet Elite', 'A03', 5, 2205, 408);

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

--
-- Table structure for table `booking`
--

DROP TABLE IF EXISTS `booking`;
CREATE TABLE `booking` (
  `user_id` int(11) NOT NULL,
  `flight_id` int(11) NOT NULL,
  `booking_ref` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `booking`
--

INSERT INTO `booking` (`user_id`, `flight_id`, `booking_ref`) VALUES
(14, 130, 35),
(14, 166, 36),
(14, 106, 37);

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

--
-- Table structure for table `debug_logging`
--

DROP TABLE IF EXISTS `debug_logging`;
CREATE TABLE `debug_logging` (
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `comment` varchar(50) NOT NULL,
  `id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `debug_logging`
--

INSERT INTO `debug_logging` (`timestamp`, `comment`, `id`) VALUES
('2020-09-23 21:01:03', 'Iterated number: 2', 1),
('2020-09-23 21:01:58', 'Iterated number: 52', 2),
('2020-09-23 21:07:55', 'Iterated number: 52', 3);

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

--
-- Table structure for table `destinations`
--

DROP TABLE IF EXISTS `destinations`;
CREATE TABLE `destinations` (
  `airport` varchar(55) NOT NULL,
  `code` varchar(4) NOT NULL,
  `region` varchar(55) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `destinations`
--

INSERT INTO `destinations` (`airport`, `code`, `region`) VALUES
('Tuuta Aiport', 'NZCI', 'Chatham Islands'),
('Claris Aerodrome', 'NZGB', 'Great Barrier Island'),
('Dairy Flat Airport', 'NZNE', 'North Shore'),
('Rotorua Aiport', 'NZRO', 'Rotorua'),
('Lake Tekapo Airport', 'NZTL', 'Mackenzie District'),
('Sydney Kingsford Smith Airport', 'YSSY', 'Sydney');

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

--
-- Table structure for table `routes`
--

DROP TABLE IF EXISTS `routes`;
CREATE TABLE `routes` (
  `routeID` int(12) NOT NULL,
  `start` varchar(4) NOT NULL,
  `end` varchar(4) NOT NULL,
  `plane_id` varchar(50) DEFAULT NULL,
  `cost` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `routes`
--

INSERT INTO `routes` (`routeID`, `start`, `end`, `plane_id`, `cost`) VALUES
(1, 'NZNE', 'YSSY', 'A01', 50),
(2, 'YSSY', 'NZNE', 'A01', 50),
(3, 'NZNE', 'NZRO', 'A02', 60),
(4, 'NZRO', 'NZNE', 'A02', 60),
(5, 'NZNE', 'NZGB', 'A02', 60),
(6, 'NZGB', 'NZNE', 'A02', 60),
(7, 'NZNE', 'NZCI', 'A03', 55),
(8, 'NZCI', 'NZNE', 'A03', 55),
(9, 'NZNE', 'NZTL', 'A03', 55),
(10, 'NZTL', 'NZNE', 'A03', 55);

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

--
-- Table structure for table `times`
--

DROP TABLE IF EXISTS `times`;
CREATE TABLE `times` (
  `flight_ID` int(11) NOT NULL,
  `time` datetime NOT NULL DEFAULT current_timestamp(),
  `route_id` int(11) NOT NULL,
  `Historic` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `times`
--

INSERT INTO `times` (`flight_ID`, `time`, `route_id`, `Historic`) VALUES
(1, '2020-09-11 16:00:00', 1, 1),
(2, '2020-09-13 16:00:00', 2, 1),
(3, '2020-09-07 08:00:00', 3, 1),
(4, '2020-09-07 12:00:00', 4, 1),
(5, '2020-09-07 15:00:00', 3, 1),
(6, '2020-09-07 18:00:00', 4, 1),
(7, '2020-09-08 08:00:00', 3, 1),
(8, '2020-09-08 12:00:00', 4, 1),
(9, '2020-09-08 15:00:00', 3, 1),
(10, '2020-09-08 18:00:00', 4, 1),
(11, '2020-09-09 08:00:00', 3, 1),
(12, '2020-09-09 12:00:00', 4, 1),
(13, '2020-09-09 15:00:00', 3, 1),
(14, '2020-09-09 18:00:00', 4, 1),
(15, '2020-09-10 08:00:00', 3, 1),
(16, '2020-09-10 12:00:00', 4, 1),
(17, '2020-09-10 15:00:00', 3, 1),
(18, '2020-09-10 18:00:00', 4, 1),
(19, '2020-09-12 08:00:00', 3, 1),
(20, '2020-09-12 12:00:00', 4, 1),
(21, '2020-09-12 15:00:00', 3, 1),
(22, '2020-09-12 18:00:00', 4, 1),
(23, '2020-09-07 10:00:00', 5, 1),
(24, '2020-09-09 10:00:00', 5, 1),
(25, '2020-09-11 10:00:00', 5, 1),
(26, '2020-09-08 10:00:00', 6, 1),
(27, '2020-09-08 10:00:00', 6, 1),
(28, '2020-09-11 10:00:00', 6, 1),
(29, '2020-09-12 10:00:00', 6, 1),
(30, '2020-09-08 10:00:00', 7, 1),
(31, '2020-09-11 10:00:00', 7, 1),
(32, '2020-09-09 10:00:00', 8, 1),
(33, '2020-09-12 10:00:00', 8, 1),
(34, '2020-09-07 10:00:00', 9, 1),
(35, '2020-09-11 10:00:00', 10, 1),
(71, '2020-09-25 16:00:00', 1, 1),
(72, '2020-09-27 16:00:00', 2, 1),
(73, '2020-09-21 08:00:00', 3, 1),
(74, '2020-09-21 12:00:00', 4, 1),
(75, '2020-09-21 15:00:00', 3, 1),
(76, '2020-09-21 18:00:00', 4, 1),
(77, '2020-09-22 08:00:00', 3, 1),
(78, '2020-09-22 12:00:00', 4, 1),
(79, '2020-09-22 15:00:00', 3, 1),
(80, '2020-09-22 18:00:00', 4, 1),
(81, '2020-09-23 08:00:00', 3, 1),
(82, '2020-09-23 12:00:00', 4, 1),
(83, '2020-09-23 15:00:00', 3, 1),
(84, '2020-09-23 18:00:00', 4, 1),
(85, '2020-09-24 08:00:00', 3, 1),
(86, '2020-09-24 12:00:00', 4, 1),
(87, '2020-09-24 15:00:00', 3, 1),
(88, '2020-09-24 18:00:00', 4, 1),
(89, '2020-09-26 08:00:00', 3, 1),
(90, '2020-09-26 12:00:00', 4, 1),
(91, '2020-09-26 15:00:00', 3, 1),
(92, '2020-09-26 18:00:00', 4, 1),
(93, '2020-09-21 10:00:00', 5, 1),
(94, '2020-09-23 10:00:00', 5, 1),
(95, '2020-09-25 10:00:00', 5, 1),
(96, '2020-09-22 10:00:00', 6, 1),
(97, '2020-09-22 10:00:00', 6, 1),
(98, '2020-09-25 10:00:00', 6, 1),
(99, '2020-09-26 10:00:00', 6, 1),
(100, '2020-09-22 10:00:00', 7, 1),
(101, '2020-09-25 10:00:00', 7, 1),
(102, '2020-09-23 10:00:00', 8, 1),
(103, '2020-09-26 10:00:00', 8, 1),
(104, '2020-09-21 10:00:00', 9, 1),
(105, '2020-09-25 10:00:00', 10, 1),
(106, '2020-10-09 16:00:00', 1, 1),
(107, '2020-10-11 16:00:00', 2, 1),
(108, '2020-10-05 08:00:00', 3, 1),
(109, '2020-10-05 12:00:00', 4, 1),
(110, '2020-10-05 15:00:00', 3, 1),
(111, '2020-10-05 18:00:00', 4, 1),
(112, '2020-10-06 08:00:00', 3, 1),
(113, '2020-10-06 12:00:00', 4, 1),
(114, '2020-10-06 15:00:00', 3, 1),
(115, '2020-10-06 18:00:00', 4, 1),
(116, '2020-10-07 08:00:00', 3, 1),
(117, '2020-10-07 12:00:00', 4, 1),
(118, '2020-10-07 15:00:00', 3, 1),
(119, '2020-10-07 18:00:00', 4, 1),
(120, '2020-10-08 08:00:00', 3, 1),
(121, '2020-10-08 12:00:00', 4, 1),
(122, '2020-10-08 15:00:00', 3, 1),
(123, '2020-10-08 18:00:00', 4, 1),
(124, '2020-10-10 08:00:00', 3, 1),
(125, '2020-10-10 12:00:00', 4, 1),
(126, '2020-10-10 15:00:00', 3, 1),
(127, '2020-10-10 18:00:00', 4, 1),
(128, '2020-10-05 10:00:00', 5, 1),
(129, '2020-10-07 10:00:00', 5, 1),
(130, '2020-10-09 10:00:00', 5, 1),
(131, '2020-10-06 10:00:00', 6, 1),
(132, '2020-10-06 10:00:00', 6, 1),
(133, '2020-10-09 10:00:00', 6, 1),
(134, '2020-10-10 10:00:00', 6, 1),
(135, '2020-10-06 10:00:00', 7, 1),
(136, '2020-10-09 10:00:00', 7, 1),
(137, '2020-10-07 10:00:00', 8, 1),
(138, '2020-10-10 10:00:00', 8, 1),
(139, '2020-10-05 10:00:00', 9, 1),
(140, '2020-10-09 10:00:00', 10, 1),
(141, '2020-10-23 16:00:00', 1, 1),
(142, '2020-10-25 16:00:00', 2, 1),
(143, '2020-10-19 08:00:00', 3, 1),
(144, '2020-10-19 12:00:00', 4, 1),
(145, '2020-10-19 15:00:00', 3, 1),
(146, '2020-10-19 18:00:00', 4, 1),
(147, '2020-10-20 08:00:00', 3, 1),
(148, '2020-10-20 12:00:00', 4, 1),
(149, '2020-10-20 15:00:00', 3, 1),
(150, '2020-10-20 18:00:00', 4, 1),
(151, '2020-10-21 08:00:00', 3, 1),
(152, '2020-10-21 12:00:00', 4, 1),
(153, '2020-10-21 15:00:00', 3, 1),
(154, '2020-10-21 18:00:00', 4, 1),
(155, '2020-10-22 08:00:00', 3, 1),
(156, '2020-10-22 12:00:00', 4, 1),
(157, '2020-10-22 15:00:00', 3, 1),
(158, '2020-10-22 18:00:00', 4, 1),
(159, '2020-10-24 08:00:00', 3, 1),
(160, '2020-10-24 12:00:00', 4, 1),
(161, '2020-10-24 15:00:00', 3, 1),
(162, '2020-10-24 18:00:00', 4, 1),
(163, '2020-10-19 10:00:00', 5, 1),
(164, '2020-10-21 10:00:00', 5, 1),
(165, '2020-10-23 10:00:00', 5, 1),
(166, '2020-10-20 10:00:00', 6, 1),
(167, '2020-10-20 10:00:00', 6, 1),
(168, '2020-10-23 10:00:00', 6, 1),
(169, '2020-10-24 10:00:00', 6, 1),
(170, '2020-10-20 10:00:00', 7, 1),
(171, '2020-10-23 10:00:00', 7, 1),
(172, '2020-10-21 10:00:00', 8, 1),
(173, '2020-10-24 10:00:00', 8, 1),
(174, '2020-10-19 10:00:00', 9, 1),
(175, '2020-10-23 10:00:00', 10, 1),
(176, '2020-11-06 16:00:00', 1, 1),
(177, '2020-11-08 16:00:00', 2, 1),
(178, '2020-11-02 08:00:00', 3, 1),
(179, '2020-11-02 12:00:00', 4, 1),
(180, '2020-11-02 15:00:00', 3, 1),
(181, '2020-11-02 18:00:00', 4, 1),
(182, '2020-11-03 08:00:00', 3, 1),
(183, '2020-11-03 12:00:00', 4, 1),
(184, '2020-11-03 15:00:00', 3, 1),
(185, '2020-11-03 18:00:00', 4, 1),
(186, '2020-11-04 08:00:00', 3, 1),
(187, '2020-11-04 12:00:00', 4, 1),
(188, '2020-11-04 15:00:00', 3, 1),
(189, '2020-11-04 18:00:00', 4, 1),
(190, '2020-11-05 08:00:00', 3, 1),
(191, '2020-11-05 12:00:00', 4, 1),
(192, '2020-11-05 15:00:00', 3, 1),
(193, '2020-11-05 18:00:00', 4, 1),
(194, '2020-11-07 08:00:00', 3, 1),
(195, '2020-11-07 12:00:00', 4, 1),
(196, '2020-11-07 15:00:00', 3, 1),
(197, '2020-11-07 18:00:00', 4, 1),
(198, '2020-11-02 10:00:00', 5, 1),
(199, '2020-11-04 10:00:00', 5, 1),
(200, '2020-11-06 10:00:00', 5, 1),
(201, '2020-11-03 10:00:00', 6, 1),
(202, '2020-11-03 10:00:00', 6, 1),
(203, '2020-11-06 10:00:00', 6, 1),
(204, '2020-11-07 10:00:00', 6, 1),
(205, '2020-11-03 10:00:00', 7, 1),
(206, '2020-11-06 10:00:00', 7, 1),
(207, '2020-11-04 10:00:00', 8, 1),
(208, '2020-11-07 10:00:00', 8, 1),
(209, '2020-11-02 10:00:00', 9, 1),
(210, '2020-11-06 10:00:00', 10, 1),
(211, '2020-11-20 16:00:00', 1, 1),
(212, '2020-11-22 16:00:00', 2, 1),
(213, '2020-11-16 08:00:00', 3, 1),
(214, '2020-11-16 12:00:00', 4, 1),
(215, '2020-11-16 15:00:00', 3, 1),
(216, '2020-11-16 18:00:00', 4, 1),
(217, '2020-11-17 08:00:00', 3, 1),
(218, '2020-11-17 12:00:00', 4, 1),
(219, '2020-11-17 15:00:00', 3, 1),
(220, '2020-11-17 18:00:00', 4, 1),
(221, '2020-11-18 08:00:00', 3, 1),
(222, '2020-11-18 12:00:00', 4, 1),
(223, '2020-11-18 15:00:00', 3, 1),
(224, '2020-11-18 18:00:00', 4, 1),
(225, '2020-11-19 08:00:00', 3, 1),
(226, '2020-11-19 12:00:00', 4, 1),
(227, '2020-11-19 15:00:00', 3, 1),
(228, '2020-11-19 18:00:00', 4, 1),
(229, '2020-11-21 08:00:00', 3, 1),
(230, '2020-11-21 12:00:00', 4, 1),
(231, '2020-11-21 15:00:00', 3, 1),
(232, '2020-11-21 18:00:00', 4, 1),
(233, '2020-11-16 10:00:00', 5, 1),
(234, '2020-11-18 10:00:00', 5, 1),
(235, '2020-11-20 10:00:00', 5, 1),
(236, '2020-11-17 10:00:00', 6, 1),
(237, '2020-11-17 10:00:00', 6, 1),
(238, '2020-11-20 10:00:00', 6, 1),
(239, '2020-11-21 10:00:00', 6, 1),
(240, '2020-11-17 10:00:00', 7, 1),
(241, '2020-11-20 10:00:00', 7, 1),
(242, '2020-11-18 10:00:00', 8, 1),
(243, '2020-11-21 10:00:00', 8, 1),
(244, '2020-11-16 10:00:00', 9, 1),
(245, '2020-11-20 10:00:00', 10, 1),
(246, '2020-12-04 16:00:00', 1, 1),
(247, '2020-12-06 16:00:00', 2, 1),
(248, '2020-11-30 08:00:00', 3, 1),
(249, '2020-11-30 12:00:00', 4, 1),
(250, '2020-11-30 15:00:00', 3, 1),
(251, '2020-11-30 18:00:00', 4, 1),
(252, '2020-12-01 08:00:00', 3, 1),
(253, '2020-12-01 12:00:00', 4, 1),
(254, '2020-12-01 15:00:00', 3, 1),
(255, '2020-12-01 18:00:00', 4, 1),
(256, '2020-12-02 08:00:00', 3, 1),
(257, '2020-12-02 12:00:00', 4, 1),
(258, '2020-12-02 15:00:00', 3, 1),
(259, '2020-12-02 18:00:00', 4, 1),
(260, '2020-12-03 08:00:00', 3, 1),
(261, '2020-12-03 12:00:00', 4, 1),
(262, '2020-12-03 15:00:00', 3, 1),
(263, '2020-12-03 18:00:00', 4, 1),
(264, '2020-12-05 08:00:00', 3, 1),
(265, '2020-12-05 12:00:00', 4, 1),
(266, '2020-12-05 15:00:00', 3, 1),
(267, '2020-12-05 18:00:00', 4, 1),
(268, '2020-11-30 10:00:00', 5, 1),
(269, '2020-12-02 10:00:00', 5, 1),
(270, '2020-12-04 10:00:00', 5, 1),
(271, '2020-12-01 10:00:00', 6, 1),
(272, '2020-12-01 10:00:00', 6, 1),
(273, '2020-12-04 10:00:00', 6, 1),
(274, '2020-12-05 10:00:00', 6, 1),
(275, '2020-12-01 10:00:00', 7, 1),
(276, '2020-12-04 10:00:00', 7, 1),
(277, '2020-12-02 10:00:00', 8, 1),
(278, '2020-12-05 10:00:00', 8, 1),
(279, '2020-11-30 10:00:00', 9, 1),
(280, '2020-12-04 10:00:00', 10, 1),
(281, '2020-12-18 16:00:00', 1, 1),
(282, '2020-12-20 16:00:00', 2, 1),
(283, '2020-12-14 08:00:00', 3, 1),
(284, '2020-12-14 12:00:00', 4, 1),
(285, '2020-12-14 15:00:00', 3, 1),
(286, '2020-12-14 18:00:00', 4, 1),
(287, '2020-12-15 08:00:00', 3, 1),
(288, '2020-12-15 12:00:00', 4, 1),
(289, '2020-12-15 15:00:00', 3, 1),
(290, '2020-12-15 18:00:00', 4, 1),
(291, '2020-12-16 08:00:00', 3, 1),
(292, '2020-12-16 12:00:00', 4, 1),
(293, '2020-12-16 15:00:00', 3, 1),
(294, '2020-12-16 18:00:00', 4, 1),
(295, '2020-12-17 08:00:00', 3, 1),
(296, '2020-12-17 12:00:00', 4, 1),
(297, '2020-12-17 15:00:00', 3, 1),
(298, '2020-12-17 18:00:00', 4, 1),
(299, '2020-12-19 08:00:00', 3, 1),
(300, '2020-12-19 12:00:00', 4, 1),
(301, '2020-12-19 15:00:00', 3, 1),
(302, '2020-12-19 18:00:00', 4, 1),
(303, '2020-12-14 10:00:00', 5, 1),
(304, '2020-12-16 10:00:00', 5, 1),
(305, '2020-12-18 10:00:00', 5, 1),
(306, '2020-12-15 10:00:00', 6, 1),
(307, '2020-12-15 10:00:00', 6, 1),
(308, '2020-12-18 10:00:00', 6, 1),
(309, '2020-12-19 10:00:00', 6, 1),
(310, '2020-12-15 10:00:00', 7, 1),
(311, '2020-12-18 10:00:00', 7, 1),
(312, '2020-12-16 10:00:00', 8, 1),
(313, '2020-12-19 10:00:00', 8, 1),
(314, '2020-12-14 10:00:00', 9, 1),
(315, '2020-12-18 10:00:00', 10, 1),
(316, '2021-01-01 16:00:00', 1, 1),
(317, '2021-01-03 16:00:00', 2, 1),
(318, '2020-12-28 08:00:00', 3, 1),
(319, '2020-12-28 12:00:00', 4, 1),
(320, '2020-12-28 15:00:00', 3, 1),
(321, '2020-12-28 18:00:00', 4, 1),
(322, '2020-12-29 08:00:00', 3, 1),
(323, '2020-12-29 12:00:00', 4, 1),
(324, '2020-12-29 15:00:00', 3, 1),
(325, '2020-12-29 18:00:00', 4, 1),
(326, '2020-12-30 08:00:00', 3, 1),
(327, '2020-12-30 12:00:00', 4, 1),
(328, '2020-12-30 15:00:00', 3, 1),
(329, '2020-12-30 18:00:00', 4, 1),
(330, '2020-12-31 08:00:00', 3, 1),
(331, '2020-12-31 12:00:00', 4, 1),
(332, '2020-12-31 15:00:00', 3, 1),
(333, '2020-12-31 18:00:00', 4, 1),
(334, '2021-01-02 08:00:00', 3, 1),
(335, '2021-01-02 12:00:00', 4, 1),
(336, '2021-01-02 15:00:00', 3, 1),
(337, '2021-01-02 18:00:00', 4, 1),
(338, '2020-12-28 10:00:00', 5, 1),
(339, '2020-12-30 10:00:00', 5, 1),
(340, '2021-01-01 10:00:00', 5, 1),
(341, '2020-12-29 10:00:00', 6, 1),
(342, '2020-12-29 10:00:00', 6, 1),
(343, '2021-01-01 10:00:00', 6, 1),
(344, '2021-01-02 10:00:00', 6, 1),
(345, '2020-12-29 10:00:00', 7, 1),
(346, '2021-01-01 10:00:00', 7, 1),
(347, '2020-12-30 10:00:00', 8, 1),
(348, '2021-01-02 10:00:00', 8, 1),
(349, '2020-12-28 10:00:00', 9, 1),
(350, '2021-01-01 10:00:00', 10, 1),
(351, '2021-01-15 16:00:00', 1, 1),
(352, '2021-01-17 16:00:00', 2, 1),
(353, '2021-01-11 08:00:00', 3, 1),
(354, '2021-01-11 12:00:00', 4, 1),
(355, '2021-01-11 15:00:00', 3, 1),
(356, '2021-01-11 18:00:00', 4, 1),
(357, '2021-01-12 08:00:00', 3, 1),
(358, '2021-01-12 12:00:00', 4, 1),
(359, '2021-01-12 15:00:00', 3, 1),
(360, '2021-01-12 18:00:00', 4, 1),
(361, '2021-01-13 08:00:00', 3, 1),
(362, '2021-01-13 12:00:00', 4, 1),
(363, '2021-01-13 15:00:00', 3, 1),
(364, '2021-01-13 18:00:00', 4, 1),
(365, '2021-01-14 08:00:00', 3, 1),
(366, '2021-01-14 12:00:00', 4, 1),
(367, '2021-01-14 15:00:00', 3, 1),
(368, '2021-01-14 18:00:00', 4, 1),
(369, '2021-01-16 08:00:00', 3, 1),
(370, '2021-01-16 12:00:00', 4, 1),
(371, '2021-01-16 15:00:00', 3, 1),
(372, '2021-01-16 18:00:00', 4, 1),
(373, '2021-01-11 10:00:00', 5, 1),
(374, '2021-01-13 10:00:00', 5, 1),
(375, '2021-01-15 10:00:00', 5, 1),
(376, '2021-01-12 10:00:00', 6, 1),
(377, '2021-01-12 10:00:00', 6, 1),
(378, '2021-01-15 10:00:00', 6, 1),
(379, '2021-01-16 10:00:00', 6, 1),
(380, '2021-01-12 10:00:00', 7, 1),
(381, '2021-01-15 10:00:00', 7, 1),
(382, '2021-01-13 10:00:00', 8, 1),
(383, '2021-01-16 10:00:00', 8, 1),
(384, '2021-01-11 10:00:00', 9, 1),
(385, '2021-01-15 10:00:00', 10, 1),
(386, '2021-01-29 16:00:00', 1, 1),
(387, '2021-01-31 16:00:00', 2, 1),
(388, '2021-01-25 08:00:00', 3, 1),
(389, '2021-01-25 12:00:00', 4, 1),
(390, '2021-01-25 15:00:00', 3, 1),
(391, '2021-01-25 18:00:00', 4, 1),
(392, '2021-01-26 08:00:00', 3, 1),
(393, '2021-01-26 12:00:00', 4, 1),
(394, '2021-01-26 15:00:00', 3, 1),
(395, '2021-01-26 18:00:00', 4, 1),
(396, '2021-01-27 08:00:00', 3, 1),
(397, '2021-01-27 12:00:00', 4, 1),
(398, '2021-01-27 15:00:00', 3, 1),
(399, '2021-01-27 18:00:00', 4, 1),
(400, '2021-01-28 08:00:00', 3, 1),
(401, '2021-01-28 12:00:00', 4, 1),
(402, '2021-01-28 15:00:00', 3, 1),
(403, '2021-01-28 18:00:00', 4, 1),
(404, '2021-01-30 08:00:00', 3, 1),
(405, '2021-01-30 12:00:00', 4, 1),
(406, '2021-01-30 15:00:00', 3, 1),
(407, '2021-01-30 18:00:00', 4, 1),
(408, '2021-01-25 10:00:00', 5, 1),
(409, '2021-01-27 10:00:00', 5, 1),
(410, '2021-01-29 10:00:00', 5, 1),
(411, '2021-01-26 10:00:00', 6, 1),
(412, '2021-01-26 10:00:00', 6, 1),
(413, '2021-01-29 10:00:00', 6, 1),
(414, '2021-01-30 10:00:00', 6, 1),
(415, '2021-01-26 10:00:00', 7, 1),
(416, '2021-01-29 10:00:00', 7, 1),
(417, '2021-01-27 10:00:00', 8, 1),
(418, '2021-01-30 10:00:00', 8, 1),
(419, '2021-01-25 10:00:00', 9, 1),
(420, '2021-01-29 10:00:00', 10, 1),
(421, '2021-02-12 16:00:00', 1, 1),
(422, '2021-02-14 16:00:00', 2, 1),
(423, '2021-02-08 08:00:00', 3, 1),
(424, '2021-02-08 12:00:00', 4, 1),
(425, '2021-02-08 15:00:00', 3, 1),
(426, '2021-02-08 18:00:00', 4, 1),
(427, '2021-02-09 08:00:00', 3, 1),
(428, '2021-02-09 12:00:00', 4, 1),
(429, '2021-02-09 15:00:00', 3, 1),
(430, '2021-02-09 18:00:00', 4, 1),
(431, '2021-02-10 08:00:00', 3, 1),
(432, '2021-02-10 12:00:00', 4, 1),
(433, '2021-02-10 15:00:00', 3, 1),
(434, '2021-02-10 18:00:00', 4, 1),
(435, '2021-02-11 08:00:00', 3, 1),
(436, '2021-02-11 12:00:00', 4, 1),
(437, '2021-02-11 15:00:00', 3, 1),
(438, '2021-02-11 18:00:00', 4, 1),
(439, '2021-02-13 08:00:00', 3, 1),
(440, '2021-02-13 12:00:00', 4, 1),
(441, '2021-02-13 15:00:00', 3, 1),
(442, '2021-02-13 18:00:00', 4, 1),
(443, '2021-02-08 10:00:00', 5, 1),
(444, '2021-02-10 10:00:00', 5, 1),
(445, '2021-02-12 10:00:00', 5, 1),
(446, '2021-02-09 10:00:00', 6, 1),
(447, '2021-02-09 10:00:00', 6, 1),
(448, '2021-02-12 10:00:00', 6, 1),
(449, '2021-02-13 10:00:00', 6, 1),
(450, '2021-02-09 10:00:00', 7, 1),
(451, '2021-02-12 10:00:00', 7, 1),
(452, '2021-02-10 10:00:00', 8, 1),
(453, '2021-02-13 10:00:00', 8, 1),
(454, '2021-02-08 10:00:00', 9, 1),
(455, '2021-02-12 10:00:00', 10, 1),
(456, '2021-02-26 16:00:00', 1, 1),
(457, '2021-02-28 16:00:00', 2, 1),
(458, '2021-02-22 08:00:00', 3, 1),
(459, '2021-02-22 12:00:00', 4, 1),
(460, '2021-02-22 15:00:00', 3, 1),
(461, '2021-02-22 18:00:00', 4, 1),
(462, '2021-02-23 08:00:00', 3, 1),
(463, '2021-02-23 12:00:00', 4, 1),
(464, '2021-02-23 15:00:00', 3, 1),
(465, '2021-02-23 18:00:00', 4, 1),
(466, '2021-02-24 08:00:00', 3, 1),
(467, '2021-02-24 12:00:00', 4, 1),
(468, '2021-02-24 15:00:00', 3, 1),
(469, '2021-02-24 18:00:00', 4, 1),
(470, '2021-02-25 08:00:00', 3, 1),
(471, '2021-02-25 12:00:00', 4, 1),
(472, '2021-02-25 15:00:00', 3, 1),
(473, '2021-02-25 18:00:00', 4, 1),
(474, '2021-02-27 08:00:00', 3, 1),
(475, '2021-02-27 12:00:00', 4, 1),
(476, '2021-02-27 15:00:00', 3, 1),
(477, '2021-02-27 18:00:00', 4, 1),
(478, '2021-02-22 10:00:00', 5, 1),
(479, '2021-02-24 10:00:00', 5, 1),
(480, '2021-02-26 10:00:00', 5, 1),
(481, '2021-02-23 10:00:00', 6, 1),
(482, '2021-02-23 10:00:00', 6, 1),
(483, '2021-02-26 10:00:00', 6, 1),
(484, '2021-02-27 10:00:00', 6, 1),
(485, '2021-02-23 10:00:00', 7, 1),
(486, '2021-02-26 10:00:00', 7, 1),
(487, '2021-02-24 10:00:00', 8, 1),
(488, '2021-02-27 10:00:00', 8, 1),
(489, '2021-02-22 10:00:00', 9, 1),
(490, '2021-02-26 10:00:00', 10, 1),
(491, '2021-03-12 16:00:00', 1, 1),
(492, '2021-03-14 16:00:00', 2, 1),
(493, '2021-03-08 08:00:00', 3, 1),
(494, '2021-03-08 12:00:00', 4, 1),
(495, '2021-03-08 15:00:00', 3, 1),
(496, '2021-03-08 18:00:00', 4, 1),
(497, '2021-03-09 08:00:00', 3, 1),
(498, '2021-03-09 12:00:00', 4, 1),
(499, '2021-03-09 15:00:00', 3, 1),
(500, '2021-03-09 18:00:00', 4, 1),
(501, '2021-03-10 08:00:00', 3, 1),
(502, '2021-03-10 12:00:00', 4, 1),
(503, '2021-03-10 15:00:00', 3, 1),
(504, '2021-03-10 18:00:00', 4, 1),
(505, '2021-03-11 08:00:00', 3, 1),
(506, '2021-03-11 12:00:00', 4, 1),
(507, '2021-03-11 15:00:00', 3, 1),
(508, '2021-03-11 18:00:00', 4, 1),
(509, '2021-03-13 08:00:00', 3, 1),
(510, '2021-03-13 12:00:00', 4, 1),
(511, '2021-03-13 15:00:00', 3, 1),
(512, '2021-03-13 18:00:00', 4, 1),
(513, '2021-03-08 10:00:00', 5, 1),
(514, '2021-03-10 10:00:00', 5, 1),
(515, '2021-03-12 10:00:00', 5, 1),
(516, '2021-03-09 10:00:00', 6, 1),
(517, '2021-03-09 10:00:00', 6, 1),
(518, '2021-03-12 10:00:00', 6, 1),
(519, '2021-03-13 10:00:00', 6, 1),
(520, '2021-03-09 10:00:00', 7, 1),
(521, '2021-03-12 10:00:00', 7, 1),
(522, '2021-03-10 10:00:00', 8, 1),
(523, '2021-03-13 10:00:00', 8, 1),
(524, '2021-03-08 10:00:00', 9, 1),
(525, '2021-03-12 10:00:00', 10, 1),
(526, '2021-03-26 16:00:00', 1, 1),
(527, '2021-03-28 16:00:00', 2, 1),
(528, '2021-03-22 08:00:00', 3, 1),
(529, '2021-03-22 12:00:00', 4, 1),
(530, '2021-03-22 15:00:00', 3, 1),
(531, '2021-03-22 18:00:00', 4, 1),
(532, '2021-03-23 08:00:00', 3, 1),
(533, '2021-03-23 12:00:00', 4, 1),
(534, '2021-03-23 15:00:00', 3, 1),
(535, '2021-03-23 18:00:00', 4, 1),
(536, '2021-03-24 08:00:00', 3, 1),
(537, '2021-03-24 12:00:00', 4, 1),
(538, '2021-03-24 15:00:00', 3, 1),
(539, '2021-03-24 18:00:00', 4, 1),
(540, '2021-03-25 08:00:00', 3, 1),
(541, '2021-03-25 12:00:00', 4, 1),
(542, '2021-03-25 15:00:00', 3, 1),
(543, '2021-03-25 18:00:00', 4, 1),
(544, '2021-03-27 08:00:00', 3, 1),
(545, '2021-03-27 12:00:00', 4, 1),
(546, '2021-03-27 15:00:00', 3, 1),
(547, '2021-03-27 18:00:00', 4, 1),
(548, '2021-03-22 10:00:00', 5, 1),
(549, '2021-03-24 10:00:00', 5, 1),
(550, '2021-03-26 10:00:00', 5, 1),
(551, '2021-03-23 10:00:00', 6, 1),
(552, '2021-03-23 10:00:00', 6, 1),
(553, '2021-03-26 10:00:00', 6, 1),
(554, '2021-03-27 10:00:00', 6, 1),
(555, '2021-03-23 10:00:00', 7, 1),
(556, '2021-03-26 10:00:00', 7, 1),
(557, '2021-03-24 10:00:00', 8, 1),
(558, '2021-03-27 10:00:00', 8, 1),
(559, '2021-03-22 10:00:00', 9, 1),
(560, '2021-03-26 10:00:00', 10, 1),
(561, '2021-04-09 16:00:00', 1, 1),
(562, '2021-04-11 16:00:00', 2, 1),
(563, '2021-04-05 08:00:00', 3, 1),
(564, '2021-04-05 12:00:00', 4, 1),
(565, '2021-04-05 15:00:00', 3, 1),
(566, '2021-04-05 18:00:00', 4, 1),
(567, '2021-04-06 08:00:00', 3, 1),
(568, '2021-04-06 12:00:00', 4, 1),
(569, '2021-04-06 15:00:00', 3, 1),
(570, '2021-04-06 18:00:00', 4, 1),
(571, '2021-04-07 08:00:00', 3, 1),
(572, '2021-04-07 12:00:00', 4, 1),
(573, '2021-04-07 15:00:00', 3, 1),
(574, '2021-04-07 18:00:00', 4, 1),
(575, '2021-04-08 08:00:00', 3, 1),
(576, '2021-04-08 12:00:00', 4, 1),
(577, '2021-04-08 15:00:00', 3, 1),
(578, '2021-04-08 18:00:00', 4, 1),
(579, '2021-04-10 08:00:00', 3, 1),
(580, '2021-04-10 12:00:00', 4, 1),
(581, '2021-04-10 15:00:00', 3, 1),
(582, '2021-04-10 18:00:00', 4, 1),
(583, '2021-04-05 10:00:00', 5, 1),
(584, '2021-04-07 10:00:00', 5, 1),
(585, '2021-04-09 10:00:00', 5, 1),
(586, '2021-04-06 10:00:00', 6, 1),
(587, '2021-04-06 10:00:00', 6, 1),
(588, '2021-04-09 10:00:00', 6, 1),
(589, '2021-04-10 10:00:00', 6, 1),
(590, '2021-04-06 10:00:00', 7, 1),
(591, '2021-04-09 10:00:00', 7, 1),
(592, '2021-04-07 10:00:00', 8, 1),
(593, '2021-04-10 10:00:00', 8, 1),
(594, '2021-04-05 10:00:00', 9, 1),
(595, '2021-04-09 10:00:00', 10, 1),
(596, '2021-04-23 16:00:00', 1, 1),
(597, '2021-04-25 16:00:00', 2, 1),
(598, '2021-04-19 08:00:00', 3, 1),
(599, '2021-04-19 12:00:00', 4, 1),
(600, '2021-04-19 15:00:00', 3, 1),
(601, '2021-04-19 18:00:00', 4, 1),
(602, '2021-04-20 08:00:00', 3, 1),
(603, '2021-04-20 12:00:00', 4, 1),
(604, '2021-04-20 15:00:00', 3, 1),
(605, '2021-04-20 18:00:00', 4, 1),
(606, '2021-04-21 08:00:00', 3, 1),
(607, '2021-04-21 12:00:00', 4, 1),
(608, '2021-04-21 15:00:00', 3, 1),
(609, '2021-04-21 18:00:00', 4, 1),
(610, '2021-04-22 08:00:00', 3, 1),
(611, '2021-04-22 12:00:00', 4, 1),
(612, '2021-04-22 15:00:00', 3, 1),
(613, '2021-04-22 18:00:00', 4, 1),
(614, '2021-04-24 08:00:00', 3, 1),
(615, '2021-04-24 12:00:00', 4, 1),
(616, '2021-04-24 15:00:00', 3, 1),
(617, '2021-04-24 18:00:00', 4, 1),
(618, '2021-04-19 10:00:00', 5, 1),
(619, '2021-04-21 10:00:00', 5, 1),
(620, '2021-04-23 10:00:00', 5, 1),
(621, '2021-04-20 10:00:00', 6, 1),
(622, '2021-04-20 10:00:00', 6, 1),
(623, '2021-04-23 10:00:00', 6, 1),
(624, '2021-04-24 10:00:00', 6, 1),
(625, '2021-04-20 10:00:00', 7, 1),
(626, '2021-04-23 10:00:00', 7, 1),
(627, '2021-04-21 10:00:00', 8, 1),
(628, '2021-04-24 10:00:00', 8, 1),
(629, '2021-04-19 10:00:00', 9, 1),
(630, '2021-04-23 10:00:00', 10, 1),
(631, '2021-05-07 16:00:00', 1, 1),
(632, '2021-05-09 16:00:00', 2, 1),
(633, '2021-05-03 08:00:00', 3, 1),
(634, '2021-05-03 12:00:00', 4, 1),
(635, '2021-05-03 15:00:00', 3, 1),
(636, '2021-05-03 18:00:00', 4, 1),
(637, '2021-05-04 08:00:00', 3, 1),
(638, '2021-05-04 12:00:00', 4, 1),
(639, '2021-05-04 15:00:00', 3, 1),
(640, '2021-05-04 18:00:00', 4, 1),
(641, '2021-05-05 08:00:00', 3, 1),
(642, '2021-05-05 12:00:00', 4, 1),
(643, '2021-05-05 15:00:00', 3, 1),
(644, '2021-05-05 18:00:00', 4, 1),
(645, '2021-05-06 08:00:00', 3, 1),
(646, '2021-05-06 12:00:00', 4, 1),
(647, '2021-05-06 15:00:00', 3, 1),
(648, '2021-05-06 18:00:00', 4, 1),
(649, '2021-05-08 08:00:00', 3, 1),
(650, '2021-05-08 12:00:00', 4, 1),
(651, '2021-05-08 15:00:00', 3, 1),
(652, '2021-05-08 18:00:00', 4, 1),
(653, '2021-05-03 10:00:00', 5, 1),
(654, '2021-05-05 10:00:00', 5, 1),
(655, '2021-05-07 10:00:00', 5, 1),
(656, '2021-05-04 10:00:00', 6, 1),
(657, '2021-05-04 10:00:00', 6, 1),
(658, '2021-05-07 10:00:00', 6, 1),
(659, '2021-05-08 10:00:00', 6, 1),
(660, '2021-05-04 10:00:00', 7, 1),
(661, '2021-05-07 10:00:00', 7, 1),
(662, '2021-05-05 10:00:00', 8, 1),
(663, '2021-05-08 10:00:00', 8, 1),
(664, '2021-05-03 10:00:00', 9, 1),
(665, '2021-05-07 10:00:00', 10, 1),
(666, '2021-05-21 16:00:00', 1, 1),
(667, '2021-05-23 16:00:00', 2, 1),
(668, '2021-05-17 08:00:00', 3, 1),
(669, '2021-05-17 12:00:00', 4, 1),
(670, '2021-05-17 15:00:00', 3, 1),
(671, '2021-05-17 18:00:00', 4, 1),
(672, '2021-05-18 08:00:00', 3, 1),
(673, '2021-05-18 12:00:00', 4, 1),
(674, '2021-05-18 15:00:00', 3, 1),
(675, '2021-05-18 18:00:00', 4, 1),
(676, '2021-05-19 08:00:00', 3, 1),
(677, '2021-05-19 12:00:00', 4, 1),
(678, '2021-05-19 15:00:00', 3, 1),
(679, '2021-05-19 18:00:00', 4, 1),
(680, '2021-05-20 08:00:00', 3, 1),
(681, '2021-05-20 12:00:00', 4, 1),
(682, '2021-05-20 15:00:00', 3, 1),
(683, '2021-05-20 18:00:00', 4, 1),
(684, '2021-05-22 08:00:00', 3, 1),
(685, '2021-05-22 12:00:00', 4, 1),
(686, '2021-05-22 15:00:00', 3, 1),
(687, '2021-05-22 18:00:00', 4, 1),
(688, '2021-05-17 10:00:00', 5, 1),
(689, '2021-05-19 10:00:00', 5, 1),
(690, '2021-05-21 10:00:00', 5, 1),
(691, '2021-05-18 10:00:00', 6, 1),
(692, '2021-05-18 10:00:00', 6, 1),
(693, '2021-05-21 10:00:00', 6, 1),
(694, '2021-05-22 10:00:00', 6, 1),
(695, '2021-05-18 10:00:00', 7, 1),
(696, '2021-05-21 10:00:00', 7, 1),
(697, '2021-05-19 10:00:00', 8, 1),
(698, '2021-05-22 10:00:00', 8, 1),
(699, '2021-05-17 10:00:00', 9, 1),
(700, '2021-05-21 10:00:00', 10, 1),
(701, '2021-06-04 16:00:00', 1, 1),
(702, '2021-06-06 16:00:00', 2, 1),
(703, '2021-05-31 08:00:00', 3, 1),
(704, '2021-05-31 12:00:00', 4, 1),
(705, '2021-05-31 15:00:00', 3, 1),
(706, '2021-05-31 18:00:00', 4, 1),
(707, '2021-06-01 08:00:00', 3, 1),
(708, '2021-06-01 12:00:00', 4, 1),
(709, '2021-06-01 15:00:00', 3, 1),
(710, '2021-06-01 18:00:00', 4, 1),
(711, '2021-06-02 08:00:00', 3, 1),
(712, '2021-06-02 12:00:00', 4, 1),
(713, '2021-06-02 15:00:00', 3, 1),
(714, '2021-06-02 18:00:00', 4, 1),
(715, '2021-06-03 08:00:00', 3, 1),
(716, '2021-06-03 12:00:00', 4, 1),
(717, '2021-06-03 15:00:00', 3, 1),
(718, '2021-06-03 18:00:00', 4, 1),
(719, '2021-06-05 08:00:00', 3, 1),
(720, '2021-06-05 12:00:00', 4, 1),
(721, '2021-06-05 15:00:00', 3, 1),
(722, '2021-06-05 18:00:00', 4, 1),
(723, '2021-05-31 10:00:00', 5, 1),
(724, '2021-06-02 10:00:00', 5, 1),
(725, '2021-06-04 10:00:00', 5, 1),
(726, '2021-06-01 10:00:00', 6, 1),
(727, '2021-06-01 10:00:00', 6, 1),
(728, '2021-06-04 10:00:00', 6, 1),
(729, '2021-06-05 10:00:00', 6, 1),
(730, '2021-06-01 10:00:00', 7, 1),
(731, '2021-06-04 10:00:00', 7, 1),
(732, '2021-06-02 10:00:00', 8, 1),
(733, '2021-06-05 10:00:00', 8, 1),
(734, '2021-05-31 10:00:00', 9, 1),
(735, '2021-06-04 10:00:00', 10, 1),
(736, '2021-06-18 16:00:00', 1, 1),
(737, '2021-06-20 16:00:00', 2, 1),
(738, '2021-06-14 08:00:00', 3, 1),
(739, '2021-06-14 12:00:00', 4, 1),
(740, '2021-06-14 15:00:00', 3, 1),
(741, '2021-06-14 18:00:00', 4, 1),
(742, '2021-06-15 08:00:00', 3, 1),
(743, '2021-06-15 12:00:00', 4, 1),
(744, '2021-06-15 15:00:00', 3, 1),
(745, '2021-06-15 18:00:00', 4, 1),
(746, '2021-06-16 08:00:00', 3, 1),
(747, '2021-06-16 12:00:00', 4, 1),
(748, '2021-06-16 15:00:00', 3, 1),
(749, '2021-06-16 18:00:00', 4, 1),
(750, '2021-06-17 08:00:00', 3, 1),
(751, '2021-06-17 12:00:00', 4, 1),
(752, '2021-06-17 15:00:00', 3, 1),
(753, '2021-06-17 18:00:00', 4, 1),
(754, '2021-06-19 08:00:00', 3, 1),
(755, '2021-06-19 12:00:00', 4, 1),
(756, '2021-06-19 15:00:00', 3, 1),
(757, '2021-06-19 18:00:00', 4, 1),
(758, '2021-06-14 10:00:00', 5, 1),
(759, '2021-06-16 10:00:00', 5, 1),
(760, '2021-06-18 10:00:00', 5, 1),
(761, '2021-06-15 10:00:00', 6, 1),
(762, '2021-06-15 10:00:00', 6, 1),
(763, '2021-06-18 10:00:00', 6, 1),
(764, '2021-06-19 10:00:00', 6, 1),
(765, '2021-06-15 10:00:00', 7, 1),
(766, '2021-06-18 10:00:00', 7, 1),
(767, '2021-06-16 10:00:00', 8, 1),
(768, '2021-06-19 10:00:00', 8, 1),
(769, '2021-06-14 10:00:00', 9, 1),
(770, '2021-06-18 10:00:00', 10, 1),
(771, '2021-07-02 16:00:00', 1, 1),
(772, '2021-07-04 16:00:00', 2, 1),
(773, '2021-06-28 08:00:00', 3, 1),
(774, '2021-06-28 12:00:00', 4, 1),
(775, '2021-06-28 15:00:00', 3, 1),
(776, '2021-06-28 18:00:00', 4, 1),
(777, '2021-06-29 08:00:00', 3, 1),
(778, '2021-06-29 12:00:00', 4, 1),
(779, '2021-06-29 15:00:00', 3, 1),
(780, '2021-06-29 18:00:00', 4, 1),
(781, '2021-06-30 08:00:00', 3, 1),
(782, '2021-06-30 12:00:00', 4, 1),
(783, '2021-06-30 15:00:00', 3, 1),
(784, '2021-06-30 18:00:00', 4, 1),
(785, '2021-07-01 08:00:00', 3, 1),
(786, '2021-07-01 12:00:00', 4, 1),
(787, '2021-07-01 15:00:00', 3, 1),
(788, '2021-07-01 18:00:00', 4, 1),
(789, '2021-07-03 08:00:00', 3, 1),
(790, '2021-07-03 12:00:00', 4, 1),
(791, '2021-07-03 15:00:00', 3, 1),
(792, '2021-07-03 18:00:00', 4, 1),
(793, '2021-06-28 10:00:00', 5, 1),
(794, '2021-06-30 10:00:00', 5, 1),
(795, '2021-07-02 10:00:00', 5, 1),
(796, '2021-06-29 10:00:00', 6, 1),
(797, '2021-06-29 10:00:00', 6, 1),
(798, '2021-07-02 10:00:00', 6, 1),
(799, '2021-07-03 10:00:00', 6, 1),
(800, '2021-06-29 10:00:00', 7, 1),
(801, '2021-07-02 10:00:00', 7, 1),
(802, '2021-06-30 10:00:00', 8, 1),
(803, '2021-07-03 10:00:00', 8, 1),
(804, '2021-06-28 10:00:00', 9, 1),
(805, '2021-07-02 10:00:00', 10, 1),
(806, '2021-07-16 16:00:00', 1, 1),
(807, '2021-07-18 16:00:00', 2, 1),
(808, '2021-07-12 08:00:00', 3, 1),
(809, '2021-07-12 12:00:00', 4, 1),
(810, '2021-07-12 15:00:00', 3, 1),
(811, '2021-07-12 18:00:00', 4, 1),
(812, '2021-07-13 08:00:00', 3, 1),
(813, '2021-07-13 12:00:00', 4, 1),
(814, '2021-07-13 15:00:00', 3, 1),
(815, '2021-07-13 18:00:00', 4, 1),
(816, '2021-07-14 08:00:00', 3, 1),
(817, '2021-07-14 12:00:00', 4, 1),
(818, '2021-07-14 15:00:00', 3, 1),
(819, '2021-07-14 18:00:00', 4, 1),
(820, '2021-07-15 08:00:00', 3, 1),
(821, '2021-07-15 12:00:00', 4, 1),
(822, '2021-07-15 15:00:00', 3, 1),
(823, '2021-07-15 18:00:00', 4, 1),
(824, '2021-07-17 08:00:00', 3, 1),
(825, '2021-07-17 12:00:00', 4, 1),
(826, '2021-07-17 15:00:00', 3, 1),
(827, '2021-07-17 18:00:00', 4, 1),
(828, '2021-07-12 10:00:00', 5, 1),
(829, '2021-07-14 10:00:00', 5, 1),
(830, '2021-07-16 10:00:00', 5, 1),
(831, '2021-07-13 10:00:00', 6, 1),
(832, '2021-07-13 10:00:00', 6, 1),
(833, '2021-07-16 10:00:00', 6, 1),
(834, '2021-07-17 10:00:00', 6, 1),
(835, '2021-07-13 10:00:00', 7, 1),
(836, '2021-07-16 10:00:00', 7, 1),
(837, '2021-07-14 10:00:00', 8, 1),
(838, '2021-07-17 10:00:00', 8, 1),
(839, '2021-07-12 10:00:00', 9, 1),
(840, '2021-07-16 10:00:00', 10, 1),
(841, '2021-07-30 16:00:00', 1, 1),
(842, '2021-08-01 16:00:00', 2, 1),
(843, '2021-07-26 08:00:00', 3, 1),
(844, '2021-07-26 12:00:00', 4, 1),
(845, '2021-07-26 15:00:00', 3, 1),
(846, '2021-07-26 18:00:00', 4, 1),
(847, '2021-07-27 08:00:00', 3, 1),
(848, '2021-07-27 12:00:00', 4, 1),
(849, '2021-07-27 15:00:00', 3, 1),
(850, '2021-07-27 18:00:00', 4, 1),
(851, '2021-07-28 08:00:00', 3, 1),
(852, '2021-07-28 12:00:00', 4, 1),
(853, '2021-07-28 15:00:00', 3, 1),
(854, '2021-07-28 18:00:00', 4, 1),
(855, '2021-07-29 08:00:00', 3, 1),
(856, '2021-07-29 12:00:00', 4, 1),
(857, '2021-07-29 15:00:00', 3, 1),
(858, '2021-07-29 18:00:00', 4, 1),
(859, '2021-07-31 08:00:00', 3, 1),
(860, '2021-07-31 12:00:00', 4, 1),
(861, '2021-07-31 15:00:00', 3, 1),
(862, '2021-07-31 18:00:00', 4, 1),
(863, '2021-07-26 10:00:00', 5, 1),
(864, '2021-07-28 10:00:00', 5, 1),
(865, '2021-07-30 10:00:00', 5, 1),
(866, '2021-07-27 10:00:00', 6, 1),
(867, '2021-07-27 10:00:00', 6, 1),
(868, '2021-07-30 10:00:00', 6, 1),
(869, '2021-07-31 10:00:00', 6, 1),
(870, '2021-07-27 10:00:00', 7, 1),
(871, '2021-07-30 10:00:00', 7, 1),
(872, '2021-07-28 10:00:00', 8, 1),
(873, '2021-07-31 10:00:00', 8, 1),
(874, '2021-07-26 10:00:00', 9, 1),
(875, '2021-07-30 10:00:00', 10, 1),
(876, '2021-08-13 16:00:00', 1, 1),
(877, '2021-08-15 16:00:00', 2, 1),
(878, '2021-08-09 08:00:00', 3, 1),
(879, '2021-08-09 12:00:00', 4, 1),
(880, '2021-08-09 15:00:00', 3, 1),
(881, '2021-08-09 18:00:00', 4, 1),
(882, '2021-08-10 08:00:00', 3, 1),
(883, '2021-08-10 12:00:00', 4, 1),
(884, '2021-08-10 15:00:00', 3, 1),
(885, '2021-08-10 18:00:00', 4, 1),
(886, '2021-08-11 08:00:00', 3, 1),
(887, '2021-08-11 12:00:00', 4, 1),
(888, '2021-08-11 15:00:00', 3, 1),
(889, '2021-08-11 18:00:00', 4, 1),
(890, '2021-08-12 08:00:00', 3, 1),
(891, '2021-08-12 12:00:00', 4, 1),
(892, '2021-08-12 15:00:00', 3, 1),
(893, '2021-08-12 18:00:00', 4, 1),
(894, '2021-08-14 08:00:00', 3, 1),
(895, '2021-08-14 12:00:00', 4, 1),
(896, '2021-08-14 15:00:00', 3, 1),
(897, '2021-08-14 18:00:00', 4, 1),
(898, '2021-08-09 10:00:00', 5, 1),
(899, '2021-08-11 10:00:00', 5, 1),
(900, '2021-08-13 10:00:00', 5, 1),
(901, '2021-08-10 10:00:00', 6, 1),
(902, '2021-08-10 10:00:00', 6, 1),
(903, '2021-08-13 10:00:00', 6, 1),
(904, '2021-08-14 10:00:00', 6, 1),
(905, '2021-08-10 10:00:00', 7, 1),
(906, '2021-08-13 10:00:00', 7, 1),
(907, '2021-08-11 10:00:00', 8, 1),
(908, '2021-08-14 10:00:00', 8, 1),
(909, '2021-08-09 10:00:00', 9, 1),
(910, '2021-08-13 10:00:00', 10, 1),
(911, '2021-08-27 16:00:00', 1, 1),
(912, '2021-08-29 16:00:00', 2, 1),
(913, '2021-08-23 08:00:00', 3, 1),
(914, '2021-08-23 12:00:00', 4, 1),
(915, '2021-08-23 15:00:00', 3, 1),
(916, '2021-08-23 18:00:00', 4, 1),
(917, '2021-08-24 08:00:00', 3, 1),
(918, '2021-08-24 12:00:00', 4, 1),
(919, '2021-08-24 15:00:00', 3, 1),
(920, '2021-08-24 18:00:00', 4, 1),
(921, '2021-08-25 08:00:00', 3, 1),
(922, '2021-08-25 12:00:00', 4, 1),
(923, '2021-08-25 15:00:00', 3, 1),
(924, '2021-08-25 18:00:00', 4, 1),
(925, '2021-08-26 08:00:00', 3, 1),
(926, '2021-08-26 12:00:00', 4, 1),
(927, '2021-08-26 15:00:00', 3, 1),
(928, '2021-08-26 18:00:00', 4, 1),
(929, '2021-08-28 08:00:00', 3, 1),
(930, '2021-08-28 12:00:00', 4, 1),
(931, '2021-08-28 15:00:00', 3, 1),
(932, '2021-08-28 18:00:00', 4, 1),
(933, '2021-08-23 10:00:00', 5, 1),
(934, '2021-08-25 10:00:00', 5, 1),
(935, '2021-08-27 10:00:00', 5, 1),
(936, '2021-08-24 10:00:00', 6, 1),
(937, '2021-08-24 10:00:00', 6, 1),
(938, '2021-08-27 10:00:00', 6, 1),
(939, '2021-08-28 10:00:00', 6, 1),
(940, '2021-08-24 10:00:00', 7, 1),
(941, '2021-08-27 10:00:00', 7, 1),
(942, '2021-08-25 10:00:00', 8, 1),
(943, '2021-08-28 10:00:00', 8, 1),
(944, '2021-08-23 10:00:00', 9, 1),
(945, '2021-08-27 10:00:00', 10, 1),
(946, '2021-09-10 16:00:00', 1, 1),
(947, '2021-09-12 16:00:00', 2, 1),
(948, '2021-09-06 08:00:00', 3, 1),
(949, '2021-09-06 12:00:00', 4, 1),
(950, '2021-09-06 15:00:00', 3, 1),
(951, '2021-09-06 18:00:00', 4, 1),
(952, '2021-09-07 08:00:00', 3, 1),
(953, '2021-09-07 12:00:00', 4, 1),
(954, '2021-09-07 15:00:00', 3, 1),
(955, '2021-09-07 18:00:00', 4, 1),
(956, '2021-09-08 08:00:00', 3, 1),
(957, '2021-09-08 12:00:00', 4, 1),
(958, '2021-09-08 15:00:00', 3, 1),
(959, '2021-09-08 18:00:00', 4, 1),
(960, '2021-09-09 08:00:00', 3, 1),
(961, '2021-09-09 12:00:00', 4, 1),
(962, '2021-09-09 15:00:00', 3, 1),
(963, '2021-09-09 18:00:00', 4, 1),
(964, '2021-09-11 08:00:00', 3, 1),
(965, '2021-09-11 12:00:00', 4, 1),
(966, '2021-09-11 15:00:00', 3, 1),
(967, '2021-09-11 18:00:00', 4, 1),
(968, '2021-09-06 10:00:00', 5, 1),
(969, '2021-09-08 10:00:00', 5, 1),
(970, '2021-09-10 10:00:00', 5, 1),
(971, '2021-09-07 10:00:00', 6, 1),
(972, '2021-09-07 10:00:00', 6, 1),
(973, '2021-09-10 10:00:00', 6, 1),
(974, '2021-09-11 10:00:00', 6, 1),
(975, '2021-09-07 10:00:00', 7, 1),
(976, '2021-09-10 10:00:00', 7, 1),
(977, '2021-09-08 10:00:00', 8, 1),
(978, '2021-09-11 10:00:00', 8, 1),
(979, '2021-09-06 10:00:00', 9, 1),
(980, '2021-09-10 10:00:00', 10, 1),
(981, '2021-09-24 16:00:00', 1, 1),
(982, '2021-09-26 16:00:00', 2, 1),
(983, '2021-09-20 08:00:00', 3, 1),
(984, '2021-09-20 12:00:00', 4, 1),
(985, '2021-09-20 15:00:00', 3, 1),
(986, '2021-09-20 18:00:00', 4, 1),
(987, '2021-09-21 08:00:00', 3, 1),
(988, '2021-09-21 12:00:00', 4, 1),
(989, '2021-09-21 15:00:00', 3, 1),
(990, '2021-09-21 18:00:00', 4, 1),
(991, '2021-09-22 08:00:00', 3, 1),
(992, '2021-09-22 12:00:00', 4, 1),
(993, '2021-09-22 15:00:00', 3, 1),
(994, '2021-09-22 18:00:00', 4, 1),
(995, '2021-09-23 08:00:00', 3, 1),
(996, '2021-09-23 12:00:00', 4, 1),
(997, '2021-09-23 15:00:00', 3, 1),
(998, '2021-09-23 18:00:00', 4, 1),
(999, '2021-09-25 08:00:00', 3, 1),
(1000, '2021-09-25 12:00:00', 4, 1),
(1001, '2021-09-25 15:00:00', 3, 1),
(1002, '2021-09-25 18:00:00', 4, 1),
(1003, '2021-09-20 10:00:00', 5, 1),
(1004, '2021-09-22 10:00:00', 5, 1),
(1005, '2021-09-24 10:00:00', 5, 1),
(1006, '2021-09-21 10:00:00', 6, 1),
(1007, '2021-09-21 10:00:00', 6, 1),
(1008, '2021-09-24 10:00:00', 6, 1),
(1009, '2021-09-25 10:00:00', 6, 1),
(1010, '2021-09-21 10:00:00', 7, 1),
(1011, '2021-09-24 10:00:00', 7, 1),
(1012, '2021-09-22 10:00:00', 8, 1),
(1013, '2021-09-25 10:00:00', 8, 1),
(1014, '2021-09-20 10:00:00', 9, 1),
(1015, '2021-09-24 10:00:00', 10, 1),
(1016, '2021-10-08 16:00:00', 1, 1),
(1017, '2021-10-10 16:00:00', 2, 1),
(1018, '2021-10-04 08:00:00', 3, 1),
(1019, '2021-10-04 12:00:00', 4, 1),
(1020, '2021-10-04 15:00:00', 3, 1),
(1021, '2021-10-04 18:00:00', 4, 1),
(1022, '2021-10-05 08:00:00', 3, 1),
(1023, '2021-10-05 12:00:00', 4, 1),
(1024, '2021-10-05 15:00:00', 3, 1),
(1025, '2021-10-05 18:00:00', 4, 1),
(1026, '2021-10-06 08:00:00', 3, 1),
(1027, '2021-10-06 12:00:00', 4, 1),
(1028, '2021-10-06 15:00:00', 3, 1),
(1029, '2021-10-06 18:00:00', 4, 1),
(1030, '2021-10-07 08:00:00', 3, 1),
(1031, '2021-10-07 12:00:00', 4, 1),
(1032, '2021-10-07 15:00:00', 3, 1),
(1033, '2021-10-07 18:00:00', 4, 1),
(1034, '2021-10-09 08:00:00', 3, 1),
(1035, '2021-10-09 12:00:00', 4, 1),
(1036, '2021-10-09 15:00:00', 3, 1),
(1037, '2021-10-09 18:00:00', 4, 1),
(1038, '2021-10-04 10:00:00', 5, 1),
(1039, '2021-10-06 10:00:00', 5, 1),
(1040, '2021-10-08 10:00:00', 5, 1),
(1041, '2021-10-05 10:00:00', 6, 1),
(1042, '2021-10-05 10:00:00', 6, 1),
(1043, '2021-10-08 10:00:00', 6, 1),
(1044, '2021-10-09 10:00:00', 6, 1),
(1045, '2021-10-05 10:00:00', 7, 1),
(1046, '2021-10-08 10:00:00', 7, 1),
(1047, '2021-10-06 10:00:00', 8, 1),
(1048, '2021-10-09 10:00:00', 8, 1),
(1049, '2021-10-04 10:00:00', 9, 1),
(1050, '2021-10-08 10:00:00', 10, 1),
(1051, '2021-10-22 16:00:00', 1, 1),
(1052, '2021-10-24 16:00:00', 2, 1),
(1053, '2021-10-18 08:00:00', 3, 1),
(1054, '2021-10-18 12:00:00', 4, 1),
(1055, '2021-10-18 15:00:00', 3, 1),
(1056, '2021-10-18 18:00:00', 4, 1),
(1057, '2021-10-19 08:00:00', 3, 1),
(1058, '2021-10-19 12:00:00', 4, 1),
(1059, '2021-10-19 15:00:00', 3, 1),
(1060, '2021-10-19 18:00:00', 4, 1),
(1061, '2021-10-20 08:00:00', 3, 1),
(1062, '2021-10-20 12:00:00', 4, 1),
(1063, '2021-10-20 15:00:00', 3, 1),
(1064, '2021-10-20 18:00:00', 4, 1),
(1065, '2021-10-21 08:00:00', 3, 1),
(1066, '2021-10-21 12:00:00', 4, 1),
(1067, '2021-10-21 15:00:00', 3, 1),
(1068, '2021-10-21 18:00:00', 4, 1),
(1069, '2021-10-23 08:00:00', 3, 1),
(1070, '2021-10-23 12:00:00', 4, 1),
(1071, '2021-10-23 15:00:00', 3, 1),
(1072, '2021-10-23 18:00:00', 4, 1),
(1073, '2021-10-18 10:00:00', 5, 1),
(1074, '2021-10-20 10:00:00', 5, 1),
(1075, '2021-10-22 10:00:00', 5, 1),
(1076, '2021-10-19 10:00:00', 6, 1),
(1077, '2021-10-19 10:00:00', 6, 1),
(1078, '2021-10-22 10:00:00', 6, 1),
(1079, '2021-10-23 10:00:00', 6, 1),
(1080, '2021-10-19 10:00:00', 7, 1),
(1081, '2021-10-22 10:00:00', 7, 1),
(1082, '2021-10-20 10:00:00', 8, 1),
(1083, '2021-10-23 10:00:00', 8, 1),
(1084, '2021-10-18 10:00:00', 9, 1),
(1085, '2021-10-22 10:00:00', 10, 1),
(1086, '2021-11-05 16:00:00', 1, 1),
(1087, '2021-11-07 16:00:00', 2, 1),
(1088, '2021-11-01 08:00:00', 3, 1),
(1089, '2021-11-01 12:00:00', 4, 1),
(1090, '2021-11-01 15:00:00', 3, 1),
(1091, '2021-11-01 18:00:00', 4, 1),
(1092, '2021-11-02 08:00:00', 3, 1),
(1093, '2021-11-02 12:00:00', 4, 1),
(1094, '2021-11-02 15:00:00', 3, 1),
(1095, '2021-11-02 18:00:00', 4, 1),
(1096, '2021-11-03 08:00:00', 3, 1),
(1097, '2021-11-03 12:00:00', 4, 1),
(1098, '2021-11-03 15:00:00', 3, 1),
(1099, '2021-11-03 18:00:00', 4, 1),
(1100, '2021-11-04 08:00:00', 3, 1),
(1101, '2021-11-04 12:00:00', 4, 1),
(1102, '2021-11-04 15:00:00', 3, 1),
(1103, '2021-11-04 18:00:00', 4, 1),
(1104, '2021-11-06 08:00:00', 3, 1),
(1105, '2021-11-06 12:00:00', 4, 1),
(1106, '2021-11-06 15:00:00', 3, 1),
(1107, '2021-11-06 18:00:00', 4, 1),
(1108, '2021-11-01 10:00:00', 5, 1),
(1109, '2021-11-03 10:00:00', 5, 1),
(1110, '2021-11-05 10:00:00', 5, 1),
(1111, '2021-11-02 10:00:00', 6, 1),
(1112, '2021-11-02 10:00:00', 6, 1),
(1113, '2021-11-05 10:00:00', 6, 1),
(1114, '2021-11-06 10:00:00', 6, 1),
(1115, '2021-11-02 10:00:00', 7, 1),
(1116, '2021-11-05 10:00:00', 7, 1),
(1117, '2021-11-03 10:00:00', 8, 1),
(1118, '2021-11-06 10:00:00', 8, 1),
(1119, '2021-11-01 10:00:00', 9, 1),
(1120, '2021-11-05 10:00:00', 10, 1),
(1121, '2021-11-19 16:00:00', 1, 1),
(1122, '2021-11-21 16:00:00', 2, 1),
(1123, '2021-11-15 08:00:00', 3, 1),
(1124, '2021-11-15 12:00:00', 4, 1),
(1125, '2021-11-15 15:00:00', 3, 1),
(1126, '2021-11-15 18:00:00', 4, 1),
(1127, '2021-11-16 08:00:00', 3, 1),
(1128, '2021-11-16 12:00:00', 4, 1),
(1129, '2021-11-16 15:00:00', 3, 1),
(1130, '2021-11-16 18:00:00', 4, 1),
(1131, '2021-11-17 08:00:00', 3, 1),
(1132, '2021-11-17 12:00:00', 4, 1),
(1133, '2021-11-17 15:00:00', 3, 1),
(1134, '2021-11-17 18:00:00', 4, 1),
(1135, '2021-11-18 08:00:00', 3, 1),
(1136, '2021-11-18 12:00:00', 4, 1),
(1137, '2021-11-18 15:00:00', 3, 1),
(1138, '2021-11-18 18:00:00', 4, 1),
(1139, '2021-11-20 08:00:00', 3, 1),
(1140, '2021-11-20 12:00:00', 4, 1),
(1141, '2021-11-20 15:00:00', 3, 1),
(1142, '2021-11-20 18:00:00', 4, 1),
(1143, '2021-11-15 10:00:00', 5, 1),
(1144, '2021-11-17 10:00:00', 5, 1),
(1145, '2021-11-19 10:00:00', 5, 1),
(1146, '2021-11-16 10:00:00', 6, 1),
(1147, '2021-11-16 10:00:00', 6, 1),
(1148, '2021-11-19 10:00:00', 6, 1),
(1149, '2021-11-20 10:00:00', 6, 1),
(1150, '2021-11-16 10:00:00', 7, 1),
(1151, '2021-11-19 10:00:00', 7, 1),
(1152, '2021-11-17 10:00:00', 8, 1),
(1153, '2021-11-20 10:00:00', 8, 1),
(1154, '2021-11-15 10:00:00', 9, 1),
(1155, '2021-11-19 10:00:00', 10, 1),
(1156, '2021-12-03 16:00:00', 1, 1),
(1157, '2021-12-05 16:00:00', 2, 1),
(1158, '2021-11-29 08:00:00', 3, 1),
(1159, '2021-11-29 12:00:00', 4, 1),
(1160, '2021-11-29 15:00:00', 3, 1),
(1161, '2021-11-29 18:00:00', 4, 1),
(1162, '2021-11-30 08:00:00', 3, 1),
(1163, '2021-11-30 12:00:00', 4, 1),
(1164, '2021-11-30 15:00:00', 3, 1),
(1165, '2021-11-30 18:00:00', 4, 1),
(1166, '2021-12-01 08:00:00', 3, 1),
(1167, '2021-12-01 12:00:00', 4, 1),
(1168, '2021-12-01 15:00:00', 3, 1),
(1169, '2021-12-01 18:00:00', 4, 1),
(1170, '2021-12-02 08:00:00', 3, 1),
(1171, '2021-12-02 12:00:00', 4, 1),
(1172, '2021-12-02 15:00:00', 3, 1),
(1173, '2021-12-02 18:00:00', 4, 1),
(1174, '2021-12-04 08:00:00', 3, 1),
(1175, '2021-12-04 12:00:00', 4, 1),
(1176, '2021-12-04 15:00:00', 3, 1),
(1177, '2021-12-04 18:00:00', 4, 1),
(1178, '2021-11-29 10:00:00', 5, 1),
(1179, '2021-12-01 10:00:00', 5, 1),
(1180, '2021-12-03 10:00:00', 5, 1),
(1181, '2021-11-30 10:00:00', 6, 1),
(1182, '2021-11-30 10:00:00', 6, 1),
(1183, '2021-12-03 10:00:00', 6, 1),
(1184, '2021-12-04 10:00:00', 6, 1),
(1185, '2021-11-30 10:00:00', 7, 1),
(1186, '2021-12-03 10:00:00', 7, 1),
(1187, '2021-12-01 10:00:00', 8, 1),
(1188, '2021-12-04 10:00:00', 8, 1),
(1189, '2021-11-29 10:00:00', 9, 1),
(1190, '2021-12-03 10:00:00', 10, 1),
(1191, '2021-12-17 16:00:00', 1, 1),
(1192, '2021-12-19 16:00:00', 2, 1),
(1193, '2021-12-13 08:00:00', 3, 1),
(1194, '2021-12-13 12:00:00', 4, 1),
(1195, '2021-12-13 15:00:00', 3, 1),
(1196, '2021-12-13 18:00:00', 4, 1),
(1197, '2021-12-14 08:00:00', 3, 1),
(1198, '2021-12-14 12:00:00', 4, 1),
(1199, '2021-12-14 15:00:00', 3, 1),
(1200, '2021-12-14 18:00:00', 4, 1),
(1201, '2021-12-15 08:00:00', 3, 1),
(1202, '2021-12-15 12:00:00', 4, 1),
(1203, '2021-12-15 15:00:00', 3, 1),
(1204, '2021-12-15 18:00:00', 4, 1),
(1205, '2021-12-16 08:00:00', 3, 1),
(1206, '2021-12-16 12:00:00', 4, 1),
(1207, '2021-12-16 15:00:00', 3, 1),
(1208, '2021-12-16 18:00:00', 4, 1),
(1209, '2021-12-18 08:00:00', 3, 1),
(1210, '2021-12-18 12:00:00', 4, 1),
(1211, '2021-12-18 15:00:00', 3, 1),
(1212, '2021-12-18 18:00:00', 4, 1),
(1213, '2021-12-13 10:00:00', 5, 1),
(1214, '2021-12-15 10:00:00', 5, 1),
(1215, '2021-12-17 10:00:00', 5, 1),
(1216, '2021-12-14 10:00:00', 6, 1),
(1217, '2021-12-14 10:00:00', 6, 1),
(1218, '2021-12-17 10:00:00', 6, 1),
(1219, '2021-12-18 10:00:00', 6, 1),
(1220, '2021-12-14 10:00:00', 7, 1),
(1221, '2021-12-17 10:00:00', 7, 1),
(1222, '2021-12-15 10:00:00', 8, 1),
(1223, '2021-12-18 10:00:00', 8, 1),
(1224, '2021-12-13 10:00:00', 9, 1),
(1225, '2021-12-17 10:00:00', 10, 1),
(1226, '2021-12-31 16:00:00', 1, 1),
(1227, '2022-01-02 16:00:00', 2, 1),
(1228, '2021-12-27 08:00:00', 3, 1),
(1229, '2021-12-27 12:00:00', 4, 1),
(1230, '2021-12-27 15:00:00', 3, 1),
(1231, '2021-12-27 18:00:00', 4, 1),
(1232, '2021-12-28 08:00:00', 3, 1),
(1233, '2021-12-28 12:00:00', 4, 1),
(1234, '2021-12-28 15:00:00', 3, 1),
(1235, '2021-12-28 18:00:00', 4, 1),
(1236, '2021-12-29 08:00:00', 3, 1),
(1237, '2021-12-29 12:00:00', 4, 1),
(1238, '2021-12-29 15:00:00', 3, 1),
(1239, '2021-12-29 18:00:00', 4, 1),
(1240, '2021-12-30 08:00:00', 3, 1),
(1241, '2021-12-30 12:00:00', 4, 1),
(1242, '2021-12-30 15:00:00', 3, 1),
(1243, '2021-12-30 18:00:00', 4, 1),
(1244, '2022-01-01 08:00:00', 3, 1),
(1245, '2022-01-01 12:00:00', 4, 1),
(1246, '2022-01-01 15:00:00', 3, 1),
(1247, '2022-01-01 18:00:00', 4, 1),
(1248, '2021-12-27 10:00:00', 5, 1),
(1249, '2021-12-29 10:00:00', 5, 1),
(1250, '2021-12-31 10:00:00', 5, 1),
(1251, '2021-12-28 10:00:00', 6, 1),
(1252, '2021-12-28 10:00:00', 6, 1),
(1253, '2021-12-31 10:00:00', 6, 1),
(1254, '2022-01-01 10:00:00', 6, 1),
(1255, '2021-12-28 10:00:00', 7, 1),
(1256, '2021-12-31 10:00:00', 7, 1),
(1257, '2021-12-29 10:00:00', 8, 1),
(1258, '2022-01-01 10:00:00', 8, 1),
(1259, '2021-12-27 10:00:00', 9, 1),
(1260, '2021-12-31 10:00:00', 10, 1),
(1261, '2022-01-14 16:00:00', 1, 1),
(1262, '2022-01-16 16:00:00', 2, 1),
(1263, '2022-01-10 08:00:00', 3, 1),
(1264, '2022-01-10 12:00:00', 4, 1),
(1265, '2022-01-10 15:00:00', 3, 1),
(1266, '2022-01-10 18:00:00', 4, 1),
(1267, '2022-01-11 08:00:00', 3, 1),
(1268, '2022-01-11 12:00:00', 4, 1),
(1269, '2022-01-11 15:00:00', 3, 1),
(1270, '2022-01-11 18:00:00', 4, 1),
(1271, '2022-01-12 08:00:00', 3, 1),
(1272, '2022-01-12 12:00:00', 4, 1),
(1273, '2022-01-12 15:00:00', 3, 1),
(1274, '2022-01-12 18:00:00', 4, 1),
(1275, '2022-01-13 08:00:00', 3, 1),
(1276, '2022-01-13 12:00:00', 4, 1),
(1277, '2022-01-13 15:00:00', 3, 1),
(1278, '2022-01-13 18:00:00', 4, 1),
(1279, '2022-01-15 08:00:00', 3, 1),
(1280, '2022-01-15 12:00:00', 4, 1),
(1281, '2022-01-15 15:00:00', 3, 1),
(1282, '2022-01-15 18:00:00', 4, 1),
(1283, '2022-01-10 10:00:00', 5, 1),
(1284, '2022-01-12 10:00:00', 5, 1),
(1285, '2022-01-14 10:00:00', 5, 1),
(1286, '2022-01-11 10:00:00', 6, 1),
(1287, '2022-01-11 10:00:00', 6, 1),
(1288, '2022-01-14 10:00:00', 6, 1),
(1289, '2022-01-15 10:00:00', 6, 1),
(1290, '2022-01-11 10:00:00', 7, 1),
(1291, '2022-01-14 10:00:00', 7, 1),
(1292, '2022-01-12 10:00:00', 8, 1),
(1293, '2022-01-15 10:00:00', 8, 1),
(1294, '2022-01-10 10:00:00', 9, 1),
(1295, '2022-01-14 10:00:00', 10, 1),
(1296, '2022-01-28 16:00:00', 1, 1),
(1297, '2022-01-30 16:00:00', 2, 1),
(1298, '2022-01-24 08:00:00', 3, 1),
(1299, '2022-01-24 12:00:00', 4, 1),
(1300, '2022-01-24 15:00:00', 3, 1),
(1301, '2022-01-24 18:00:00', 4, 1),
(1302, '2022-01-25 08:00:00', 3, 1),
(1303, '2022-01-25 12:00:00', 4, 1),
(1304, '2022-01-25 15:00:00', 3, 1),
(1305, '2022-01-25 18:00:00', 4, 1),
(1306, '2022-01-26 08:00:00', 3, 1),
(1307, '2022-01-26 12:00:00', 4, 1),
(1308, '2022-01-26 15:00:00', 3, 1),
(1309, '2022-01-26 18:00:00', 4, 1),
(1310, '2022-01-27 08:00:00', 3, 1),
(1311, '2022-01-27 12:00:00', 4, 1),
(1312, '2022-01-27 15:00:00', 3, 1),
(1313, '2022-01-27 18:00:00', 4, 1),
(1314, '2022-01-29 08:00:00', 3, 1),
(1315, '2022-01-29 12:00:00', 4, 1),
(1316, '2022-01-29 15:00:00', 3, 1),
(1317, '2022-01-29 18:00:00', 4, 1),
(1318, '2022-01-24 10:00:00', 5, 1),
(1319, '2022-01-26 10:00:00', 5, 1),
(1320, '2022-01-28 10:00:00', 5, 1),
(1321, '2022-01-25 10:00:00', 6, 1),
(1322, '2022-01-25 10:00:00', 6, 1),
(1323, '2022-01-28 10:00:00', 6, 1),
(1324, '2022-01-29 10:00:00', 6, 1),
(1325, '2022-01-25 10:00:00', 7, 1),
(1326, '2022-01-28 10:00:00', 7, 1),
(1327, '2022-01-26 10:00:00', 8, 1),
(1328, '2022-01-29 10:00:00', 8, 1),
(1329, '2022-01-24 10:00:00', 9, 1),
(1330, '2022-01-28 10:00:00', 10, 1),
(1331, '2022-02-11 16:00:00', 1, 1),
(1332, '2022-02-13 16:00:00', 2, 1),
(1333, '2022-02-07 08:00:00', 3, 1),
(1334, '2022-02-07 12:00:00', 4, 1),
(1335, '2022-02-07 15:00:00', 3, 1),
(1336, '2022-02-07 18:00:00', 4, 1),
(1337, '2022-02-08 08:00:00', 3, 1),
(1338, '2022-02-08 12:00:00', 4, 1),
(1339, '2022-02-08 15:00:00', 3, 1),
(1340, '2022-02-08 18:00:00', 4, 1),
(1341, '2022-02-09 08:00:00', 3, 1),
(1342, '2022-02-09 12:00:00', 4, 1),
(1343, '2022-02-09 15:00:00', 3, 1),
(1344, '2022-02-09 18:00:00', 4, 1),
(1345, '2022-02-10 08:00:00', 3, 1),
(1346, '2022-02-10 12:00:00', 4, 1),
(1347, '2022-02-10 15:00:00', 3, 1),
(1348, '2022-02-10 18:00:00', 4, 1),
(1349, '2022-02-12 08:00:00', 3, 1),
(1350, '2022-02-12 12:00:00', 4, 1),
(1351, '2022-02-12 15:00:00', 3, 1),
(1352, '2022-02-12 18:00:00', 4, 1),
(1353, '2022-02-07 10:00:00', 5, 1),
(1354, '2022-02-09 10:00:00', 5, 1),
(1355, '2022-02-11 10:00:00', 5, 1),
(1356, '2022-02-08 10:00:00', 6, 1),
(1357, '2022-02-08 10:00:00', 6, 1),
(1358, '2022-02-11 10:00:00', 6, 1),
(1359, '2022-02-12 10:00:00', 6, 1),
(1360, '2022-02-08 10:00:00', 7, 1),
(1361, '2022-02-11 10:00:00', 7, 1),
(1362, '2022-02-09 10:00:00', 8, 1),
(1363, '2022-02-12 10:00:00', 8, 1),
(1364, '2022-02-07 10:00:00', 9, 1),
(1365, '2022-02-11 10:00:00', 10, 1),
(1366, '2022-02-25 16:00:00', 1, 1),
(1367, '2022-02-27 16:00:00', 2, 1),
(1368, '2022-02-21 08:00:00', 3, 1),
(1369, '2022-02-21 12:00:00', 4, 1),
(1370, '2022-02-21 15:00:00', 3, 1),
(1371, '2022-02-21 18:00:00', 4, 1),
(1372, '2022-02-22 08:00:00', 3, 1),
(1373, '2022-02-22 12:00:00', 4, 1),
(1374, '2022-02-22 15:00:00', 3, 1),
(1375, '2022-02-22 18:00:00', 4, 1),
(1376, '2022-02-23 08:00:00', 3, 1),
(1377, '2022-02-23 12:00:00', 4, 1),
(1378, '2022-02-23 15:00:00', 3, 1),
(1379, '2022-02-23 18:00:00', 4, 1),
(1380, '2022-02-24 08:00:00', 3, 1),
(1381, '2022-02-24 12:00:00', 4, 1),
(1382, '2022-02-24 15:00:00', 3, 1),
(1383, '2022-02-24 18:00:00', 4, 1),
(1384, '2022-02-26 08:00:00', 3, 1),
(1385, '2022-02-26 12:00:00', 4, 1),
(1386, '2022-02-26 15:00:00', 3, 1),
(1387, '2022-02-26 18:00:00', 4, 1),
(1388, '2022-02-21 10:00:00', 5, 1),
(1389, '2022-02-23 10:00:00', 5, 1),
(1390, '2022-02-25 10:00:00', 5, 1),
(1391, '2022-02-22 10:00:00', 6, 1),
(1392, '2022-02-22 10:00:00', 6, 1),
(1393, '2022-02-25 10:00:00', 6, 1),
(1394, '2022-02-26 10:00:00', 6, 1),
(1395, '2022-02-22 10:00:00', 7, 1),
(1396, '2022-02-25 10:00:00', 7, 1),
(1397, '2022-02-23 10:00:00', 8, 1),
(1398, '2022-02-26 10:00:00', 8, 1),
(1399, '2022-02-21 10:00:00', 9, 1),
(1400, '2022-02-25 10:00:00', 10, 1),
(1401, '2022-03-11 16:00:00', 1, 1),
(1402, '2022-03-13 16:00:00', 2, 1),
(1403, '2022-03-07 08:00:00', 3, 1),
(1404, '2022-03-07 12:00:00', 4, 1),
(1405, '2022-03-07 15:00:00', 3, 1),
(1406, '2022-03-07 18:00:00', 4, 1),
(1407, '2022-03-08 08:00:00', 3, 1),
(1408, '2022-03-08 12:00:00', 4, 1),
(1409, '2022-03-08 15:00:00', 3, 1),
(1410, '2022-03-08 18:00:00', 4, 1),
(1411, '2022-03-09 08:00:00', 3, 1),
(1412, '2022-03-09 12:00:00', 4, 1),
(1413, '2022-03-09 15:00:00', 3, 1),
(1414, '2022-03-09 18:00:00', 4, 1),
(1415, '2022-03-10 08:00:00', 3, 1),
(1416, '2022-03-10 12:00:00', 4, 1),
(1417, '2022-03-10 15:00:00', 3, 1),
(1418, '2022-03-10 18:00:00', 4, 1),
(1419, '2022-03-12 08:00:00', 3, 1),
(1420, '2022-03-12 12:00:00', 4, 1),
(1421, '2022-03-12 15:00:00', 3, 1),
(1422, '2022-03-12 18:00:00', 4, 1),
(1423, '2022-03-07 10:00:00', 5, 1),
(1424, '2022-03-09 10:00:00', 5, 1),
(1425, '2022-03-11 10:00:00', 5, 1),
(1426, '2022-03-08 10:00:00', 6, 1),
(1427, '2022-03-08 10:00:00', 6, 1),
(1428, '2022-03-11 10:00:00', 6, 1),
(1429, '2022-03-12 10:00:00', 6, 1),
(1430, '2022-03-08 10:00:00', 7, 1),
(1431, '2022-03-11 10:00:00', 7, 1),
(1432, '2022-03-09 10:00:00', 8, 1),
(1433, '2022-03-12 10:00:00', 8, 1),
(1434, '2022-03-07 10:00:00', 9, 1),
(1435, '2022-03-11 10:00:00', 10, 1),
(1436, '2022-03-25 16:00:00', 1, 1),
(1437, '2022-03-27 16:00:00', 2, 1),
(1438, '2022-03-21 08:00:00', 3, 1),
(1439, '2022-03-21 12:00:00', 4, 1),
(1440, '2022-03-21 15:00:00', 3, 1),
(1441, '2022-03-21 18:00:00', 4, 1),
(1442, '2022-03-22 08:00:00', 3, 1),
(1443, '2022-03-22 12:00:00', 4, 1),
(1444, '2022-03-22 15:00:00', 3, 1),
(1445, '2022-03-22 18:00:00', 4, 1),
(1446, '2022-03-23 08:00:00', 3, 1),
(1447, '2022-03-23 12:00:00', 4, 1),
(1448, '2022-03-23 15:00:00', 3, 1),
(1449, '2022-03-23 18:00:00', 4, 1),
(1450, '2022-03-24 08:00:00', 3, 1),
(1451, '2022-03-24 12:00:00', 4, 1),
(1452, '2022-03-24 15:00:00', 3, 1),
(1453, '2022-03-24 18:00:00', 4, 1),
(1454, '2022-03-26 08:00:00', 3, 1),
(1455, '2022-03-26 12:00:00', 4, 1),
(1456, '2022-03-26 15:00:00', 3, 1),
(1457, '2022-03-26 18:00:00', 4, 1),
(1458, '2022-03-21 10:00:00', 5, 1),
(1459, '2022-03-23 10:00:00', 5, 1),
(1460, '2022-03-25 10:00:00', 5, 1),
(1461, '2022-03-22 10:00:00', 6, 1),
(1462, '2022-03-22 10:00:00', 6, 1),
(1463, '2022-03-25 10:00:00', 6, 1),
(1464, '2022-03-26 10:00:00', 6, 1),
(1465, '2022-03-22 10:00:00', 7, 1),
(1466, '2022-03-25 10:00:00', 7, 1),
(1467, '2022-03-23 10:00:00', 8, 1),
(1468, '2022-03-26 10:00:00', 8, 1),
(1469, '2022-03-21 10:00:00', 9, 1),
(1470, '2022-03-25 10:00:00', 10, 1),
(1471, '2022-04-08 16:00:00', 1, 1),
(1472, '2022-04-10 16:00:00', 2, 1),
(1473, '2022-04-04 08:00:00', 3, 1),
(1474, '2022-04-04 12:00:00', 4, 1),
(1475, '2022-04-04 15:00:00', 3, 1),
(1476, '2022-04-04 18:00:00', 4, 1),
(1477, '2022-04-05 08:00:00', 3, 1),
(1478, '2022-04-05 12:00:00', 4, 1),
(1479, '2022-04-05 15:00:00', 3, 1),
(1480, '2022-04-05 18:00:00', 4, 1),
(1481, '2022-04-06 08:00:00', 3, 1),
(1482, '2022-04-06 12:00:00', 4, 1),
(1483, '2022-04-06 15:00:00', 3, 1),
(1484, '2022-04-06 18:00:00', 4, 1),
(1485, '2022-04-07 08:00:00', 3, 1),
(1486, '2022-04-07 12:00:00', 4, 1),
(1487, '2022-04-07 15:00:00', 3, 1),
(1488, '2022-04-07 18:00:00', 4, 1),
(1489, '2022-04-09 08:00:00', 3, 1);
INSERT INTO `times` (`flight_ID`, `time`, `route_id`, `Historic`) VALUES
(1490, '2022-04-09 12:00:00', 4, 1),
(1491, '2022-04-09 15:00:00', 3, 1),
(1492, '2022-04-09 18:00:00', 4, 1),
(1493, '2022-04-04 10:00:00', 5, 1),
(1494, '2022-04-06 10:00:00', 5, 1),
(1495, '2022-04-08 10:00:00', 5, 1),
(1496, '2022-04-05 10:00:00', 6, 1),
(1497, '2022-04-05 10:00:00', 6, 1),
(1498, '2022-04-08 10:00:00', 6, 1),
(1499, '2022-04-09 10:00:00', 6, 1),
(1500, '2022-04-05 10:00:00', 7, 1),
(1501, '2022-04-08 10:00:00', 7, 1),
(1502, '2022-04-06 10:00:00', 8, 1),
(1503, '2022-04-09 10:00:00', 8, 1),
(1504, '2022-04-04 10:00:00', 9, 1),
(1505, '2022-04-08 10:00:00', 10, 1),
(1506, '2022-04-22 16:00:00', 1, 1),
(1507, '2022-04-24 16:00:00', 2, 1),
(1508, '2022-04-18 08:00:00', 3, 1),
(1509, '2022-04-18 12:00:00', 4, 1),
(1510, '2022-04-18 15:00:00', 3, 1),
(1511, '2022-04-18 18:00:00', 4, 1),
(1512, '2022-04-19 08:00:00', 3, 1),
(1513, '2022-04-19 12:00:00', 4, 1),
(1514, '2022-04-19 15:00:00', 3, 1),
(1515, '2022-04-19 18:00:00', 4, 1),
(1516, '2022-04-20 08:00:00', 3, 1),
(1517, '2022-04-20 12:00:00', 4, 1),
(1518, '2022-04-20 15:00:00', 3, 1),
(1519, '2022-04-20 18:00:00', 4, 1),
(1520, '2022-04-21 08:00:00', 3, 1),
(1521, '2022-04-21 12:00:00', 4, 1),
(1522, '2022-04-21 15:00:00', 3, 1),
(1523, '2022-04-21 18:00:00', 4, 1),
(1524, '2022-04-23 08:00:00', 3, 1),
(1525, '2022-04-23 12:00:00', 4, 1),
(1526, '2022-04-23 15:00:00', 3, 1),
(1527, '2022-04-23 18:00:00', 4, 1),
(1528, '2022-04-18 10:00:00', 5, 1),
(1529, '2022-04-20 10:00:00', 5, 1),
(1530, '2022-04-22 10:00:00', 5, 1),
(1531, '2022-04-19 10:00:00', 6, 1),
(1532, '2022-04-19 10:00:00', 6, 1),
(1533, '2022-04-22 10:00:00', 6, 1),
(1534, '2022-04-23 10:00:00', 6, 1),
(1535, '2022-04-19 10:00:00', 7, 1),
(1536, '2022-04-22 10:00:00', 7, 1),
(1537, '2022-04-20 10:00:00', 8, 1),
(1538, '2022-04-23 10:00:00', 8, 1),
(1539, '2022-04-18 10:00:00', 9, 1),
(1540, '2022-04-22 10:00:00', 10, 1),
(1541, '2022-05-06 16:00:00', 1, 1),
(1542, '2022-05-08 16:00:00', 2, 1),
(1543, '2022-05-02 08:00:00', 3, 1),
(1544, '2022-05-02 12:00:00', 4, 1),
(1545, '2022-05-02 15:00:00', 3, 1),
(1546, '2022-05-02 18:00:00', 4, 1),
(1547, '2022-05-03 08:00:00', 3, 1),
(1548, '2022-05-03 12:00:00', 4, 1),
(1549, '2022-05-03 15:00:00', 3, 1),
(1550, '2022-05-03 18:00:00', 4, 1),
(1551, '2022-05-04 08:00:00', 3, 1),
(1552, '2022-05-04 12:00:00', 4, 1),
(1553, '2022-05-04 15:00:00', 3, 1),
(1554, '2022-05-04 18:00:00', 4, 1),
(1555, '2022-05-05 08:00:00', 3, 1),
(1556, '2022-05-05 12:00:00', 4, 1),
(1557, '2022-05-05 15:00:00', 3, 1),
(1558, '2022-05-05 18:00:00', 4, 1),
(1559, '2022-05-07 08:00:00', 3, 1),
(1560, '2022-05-07 12:00:00', 4, 1),
(1561, '2022-05-07 15:00:00', 3, 1),
(1562, '2022-05-07 18:00:00', 4, 1),
(1563, '2022-05-02 10:00:00', 5, 1),
(1564, '2022-05-04 10:00:00', 5, 1),
(1565, '2022-05-06 10:00:00', 5, 1),
(1566, '2022-05-03 10:00:00', 6, 1),
(1567, '2022-05-03 10:00:00', 6, 1),
(1568, '2022-05-06 10:00:00', 6, 1),
(1569, '2022-05-07 10:00:00', 6, 1),
(1570, '2022-05-03 10:00:00', 7, 1),
(1571, '2022-05-06 10:00:00', 7, 1),
(1572, '2022-05-04 10:00:00', 8, 1),
(1573, '2022-05-07 10:00:00', 8, 1),
(1574, '2022-05-02 10:00:00', 9, 1),
(1575, '2022-05-06 10:00:00', 10, 1),
(1576, '2022-05-20 16:00:00', 1, 1),
(1577, '2022-05-22 16:00:00', 2, 1),
(1578, '2022-05-16 08:00:00', 3, 1),
(1579, '2022-05-16 12:00:00', 4, 1),
(1580, '2022-05-16 15:00:00', 3, 1),
(1581, '2022-05-16 18:00:00', 4, 1),
(1582, '2022-05-17 08:00:00', 3, 1),
(1583, '2022-05-17 12:00:00', 4, 1),
(1584, '2022-05-17 15:00:00', 3, 1),
(1585, '2022-05-17 18:00:00', 4, 1),
(1586, '2022-05-18 08:00:00', 3, 1),
(1587, '2022-05-18 12:00:00', 4, 1),
(1588, '2022-05-18 15:00:00', 3, 1),
(1589, '2022-05-18 18:00:00', 4, 1),
(1590, '2022-05-19 08:00:00', 3, 1),
(1591, '2022-05-19 12:00:00', 4, 1),
(1592, '2022-05-19 15:00:00', 3, 1),
(1593, '2022-05-19 18:00:00', 4, 1),
(1594, '2022-05-21 08:00:00', 3, 1),
(1595, '2022-05-21 12:00:00', 4, 1),
(1596, '2022-05-21 15:00:00', 3, 1),
(1597, '2022-05-21 18:00:00', 4, 1),
(1598, '2022-05-16 10:00:00', 5, 1),
(1599, '2022-05-18 10:00:00', 5, 1),
(1600, '2022-05-20 10:00:00', 5, 1),
(1601, '2022-05-17 10:00:00', 6, 1),
(1602, '2022-05-17 10:00:00', 6, 1),
(1603, '2022-05-20 10:00:00', 6, 1),
(1604, '2022-05-21 10:00:00', 6, 1),
(1605, '2022-05-17 10:00:00', 7, 1),
(1606, '2022-05-20 10:00:00', 7, 1),
(1607, '2022-05-18 10:00:00', 8, 1),
(1608, '2022-05-21 10:00:00', 8, 1),
(1609, '2022-05-16 10:00:00', 9, 1),
(1610, '2022-05-20 10:00:00', 10, 1),
(1611, '2022-06-03 16:00:00', 1, 1),
(1612, '2022-06-05 16:00:00', 2, 1),
(1613, '2022-05-30 08:00:00', 3, 1),
(1614, '2022-05-30 12:00:00', 4, 1),
(1615, '2022-05-30 15:00:00', 3, 1),
(1616, '2022-05-30 18:00:00', 4, 1),
(1617, '2022-05-31 08:00:00', 3, 1),
(1618, '2022-05-31 12:00:00', 4, 1),
(1619, '2022-05-31 15:00:00', 3, 1),
(1620, '2022-05-31 18:00:00', 4, 1),
(1621, '2022-06-01 08:00:00', 3, 1),
(1622, '2022-06-01 12:00:00', 4, 1),
(1623, '2022-06-01 15:00:00', 3, 1),
(1624, '2022-06-01 18:00:00', 4, 1),
(1625, '2022-06-02 08:00:00', 3, 1),
(1626, '2022-06-02 12:00:00', 4, 1),
(1627, '2022-06-02 15:00:00', 3, 1),
(1628, '2022-06-02 18:00:00', 4, 1),
(1629, '2022-06-04 08:00:00', 3, 1),
(1630, '2022-06-04 12:00:00', 4, 1),
(1631, '2022-06-04 15:00:00', 3, 1),
(1632, '2022-06-04 18:00:00', 4, 1),
(1633, '2022-05-30 10:00:00', 5, 1),
(1634, '2022-06-01 10:00:00', 5, 1),
(1635, '2022-06-03 10:00:00', 5, 1),
(1636, '2022-05-31 10:00:00', 6, 1),
(1637, '2022-05-31 10:00:00', 6, 1),
(1638, '2022-06-03 10:00:00', 6, 1),
(1639, '2022-06-04 10:00:00', 6, 1),
(1640, '2022-05-31 10:00:00', 7, 1),
(1641, '2022-06-03 10:00:00', 7, 1),
(1642, '2022-06-01 10:00:00', 8, 1),
(1643, '2022-06-04 10:00:00', 8, 1),
(1644, '2022-05-30 10:00:00', 9, 1),
(1645, '2022-06-03 10:00:00', 10, 1),
(1646, '2022-06-17 16:00:00', 1, 1),
(1647, '2022-06-19 16:00:00', 2, 1),
(1648, '2022-06-13 08:00:00', 3, 1),
(1649, '2022-06-13 12:00:00', 4, 1),
(1650, '2022-06-13 15:00:00', 3, 1),
(1651, '2022-06-13 18:00:00', 4, 1),
(1652, '2022-06-14 08:00:00', 3, 1),
(1653, '2022-06-14 12:00:00', 4, 1),
(1654, '2022-06-14 15:00:00', 3, 1),
(1655, '2022-06-14 18:00:00', 4, 1),
(1656, '2022-06-15 08:00:00', 3, 1),
(1657, '2022-06-15 12:00:00', 4, 1),
(1658, '2022-06-15 15:00:00', 3, 1),
(1659, '2022-06-15 18:00:00', 4, 1),
(1660, '2022-06-16 08:00:00', 3, 1),
(1661, '2022-06-16 12:00:00', 4, 1),
(1662, '2022-06-16 15:00:00', 3, 1),
(1663, '2022-06-16 18:00:00', 4, 1),
(1664, '2022-06-18 08:00:00', 3, 1),
(1665, '2022-06-18 12:00:00', 4, 1),
(1666, '2022-06-18 15:00:00', 3, 1),
(1667, '2022-06-18 18:00:00', 4, 1),
(1668, '2022-06-13 10:00:00', 5, 1),
(1669, '2022-06-15 10:00:00', 5, 1),
(1670, '2022-06-17 10:00:00', 5, 1),
(1671, '2022-06-14 10:00:00', 6, 1),
(1672, '2022-06-14 10:00:00', 6, 1),
(1673, '2022-06-17 10:00:00', 6, 1),
(1674, '2022-06-18 10:00:00', 6, 1),
(1675, '2022-06-14 10:00:00', 7, 1),
(1676, '2022-06-17 10:00:00', 7, 1),
(1677, '2022-06-15 10:00:00', 8, 1),
(1678, '2022-06-18 10:00:00', 8, 1),
(1679, '2022-06-13 10:00:00', 9, 1),
(1680, '2022-06-17 10:00:00', 10, 1),
(1681, '2022-07-01 16:00:00', 1, 1),
(1682, '2022-07-03 16:00:00', 2, 1),
(1683, '2022-06-27 08:00:00', 3, 1),
(1684, '2022-06-27 12:00:00', 4, 1),
(1685, '2022-06-27 15:00:00', 3, 1),
(1686, '2022-06-27 18:00:00', 4, 1),
(1687, '2022-06-28 08:00:00', 3, 1),
(1688, '2022-06-28 12:00:00', 4, 1),
(1689, '2022-06-28 15:00:00', 3, 1),
(1690, '2022-06-28 18:00:00', 4, 1),
(1691, '2022-06-29 08:00:00', 3, 1),
(1692, '2022-06-29 12:00:00', 4, 1),
(1693, '2022-06-29 15:00:00', 3, 1),
(1694, '2022-06-29 18:00:00', 4, 1),
(1695, '2022-06-30 08:00:00', 3, 1),
(1696, '2022-06-30 12:00:00', 4, 1),
(1697, '2022-06-30 15:00:00', 3, 1),
(1698, '2022-06-30 18:00:00', 4, 1),
(1699, '2022-07-02 08:00:00', 3, 1),
(1700, '2022-07-02 12:00:00', 4, 1),
(1701, '2022-07-02 15:00:00', 3, 1),
(1702, '2022-07-02 18:00:00', 4, 1),
(1703, '2022-06-27 10:00:00', 5, 1),
(1704, '2022-06-29 10:00:00', 5, 1),
(1705, '2022-07-01 10:00:00', 5, 1),
(1706, '2022-06-28 10:00:00', 6, 1),
(1707, '2022-06-28 10:00:00', 6, 1),
(1708, '2022-07-01 10:00:00', 6, 1),
(1709, '2022-07-02 10:00:00', 6, 1),
(1710, '2022-06-28 10:00:00', 7, 1),
(1711, '2022-07-01 10:00:00', 7, 1),
(1712, '2022-06-29 10:00:00', 8, 1),
(1713, '2022-07-02 10:00:00', 8, 1),
(1714, '2022-06-27 10:00:00', 9, 1),
(1715, '2022-07-01 10:00:00', 10, 1),
(1716, '2022-07-15 16:00:00', 1, 1),
(1717, '2022-07-17 16:00:00', 2, 1),
(1718, '2022-07-11 08:00:00', 3, 1),
(1719, '2022-07-11 12:00:00', 4, 1),
(1720, '2022-07-11 15:00:00', 3, 1),
(1721, '2022-07-11 18:00:00', 4, 1),
(1722, '2022-07-12 08:00:00', 3, 1),
(1723, '2022-07-12 12:00:00', 4, 1),
(1724, '2022-07-12 15:00:00', 3, 1),
(1725, '2022-07-12 18:00:00', 4, 1),
(1726, '2022-07-13 08:00:00', 3, 1),
(1727, '2022-07-13 12:00:00', 4, 1),
(1728, '2022-07-13 15:00:00', 3, 1),
(1729, '2022-07-13 18:00:00', 4, 1),
(1730, '2022-07-14 08:00:00', 3, 1),
(1731, '2022-07-14 12:00:00', 4, 1),
(1732, '2022-07-14 15:00:00', 3, 1),
(1733, '2022-07-14 18:00:00', 4, 1),
(1734, '2022-07-16 08:00:00', 3, 1),
(1735, '2022-07-16 12:00:00', 4, 1),
(1736, '2022-07-16 15:00:00', 3, 1),
(1737, '2022-07-16 18:00:00', 4, 1),
(1738, '2022-07-11 10:00:00', 5, 1),
(1739, '2022-07-13 10:00:00', 5, 1),
(1740, '2022-07-15 10:00:00', 5, 1),
(1741, '2022-07-12 10:00:00', 6, 1),
(1742, '2022-07-12 10:00:00', 6, 1),
(1743, '2022-07-15 10:00:00', 6, 1),
(1744, '2022-07-16 10:00:00', 6, 1),
(1745, '2022-07-12 10:00:00', 7, 1),
(1746, '2022-07-15 10:00:00', 7, 1),
(1747, '2022-07-13 10:00:00', 8, 1),
(1748, '2022-07-16 10:00:00', 8, 1),
(1749, '2022-07-11 10:00:00', 9, 1),
(1750, '2022-07-15 10:00:00', 10, 1),
(1751, '2022-07-29 16:00:00', 1, 1),
(1752, '2022-07-31 16:00:00', 2, 1),
(1753, '2022-07-25 08:00:00', 3, 1),
(1754, '2022-07-25 12:00:00', 4, 1),
(1755, '2022-07-25 15:00:00', 3, 1),
(1756, '2022-07-25 18:00:00', 4, 1),
(1757, '2022-07-26 08:00:00', 3, 1),
(1758, '2022-07-26 12:00:00', 4, 1),
(1759, '2022-07-26 15:00:00', 3, 1),
(1760, '2022-07-26 18:00:00', 4, 1),
(1761, '2022-07-27 08:00:00', 3, 1),
(1762, '2022-07-27 12:00:00', 4, 1),
(1763, '2022-07-27 15:00:00', 3, 1),
(1764, '2022-07-27 18:00:00', 4, 1),
(1765, '2022-07-28 08:00:00', 3, 1),
(1766, '2022-07-28 12:00:00', 4, 1),
(1767, '2022-07-28 15:00:00', 3, 1),
(1768, '2022-07-28 18:00:00', 4, 1),
(1769, '2022-07-30 08:00:00', 3, 1),
(1770, '2022-07-30 12:00:00', 4, 1),
(1771, '2022-07-30 15:00:00', 3, 1),
(1772, '2022-07-30 18:00:00', 4, 1),
(1773, '2022-07-25 10:00:00', 5, 1),
(1774, '2022-07-27 10:00:00', 5, 1),
(1775, '2022-07-29 10:00:00', 5, 1),
(1776, '2022-07-26 10:00:00', 6, 1),
(1777, '2022-07-26 10:00:00', 6, 1),
(1778, '2022-07-29 10:00:00', 6, 1),
(1779, '2022-07-30 10:00:00', 6, 1),
(1780, '2022-07-26 10:00:00', 7, 1),
(1781, '2022-07-29 10:00:00', 7, 1),
(1782, '2022-07-27 10:00:00', 8, 1),
(1783, '2022-07-30 10:00:00', 8, 1),
(1784, '2022-07-25 10:00:00', 9, 1),
(1785, '2022-07-29 10:00:00', 10, 1),
(1786, '2022-08-12 16:00:00', 1, 1),
(1787, '2022-08-14 16:00:00', 2, 1),
(1788, '2022-08-08 08:00:00', 3, 1),
(1789, '2022-08-08 12:00:00', 4, 1),
(1790, '2022-08-08 15:00:00', 3, 1),
(1791, '2022-08-08 18:00:00', 4, 1),
(1792, '2022-08-09 08:00:00', 3, 1),
(1793, '2022-08-09 12:00:00', 4, 1),
(1794, '2022-08-09 15:00:00', 3, 1),
(1795, '2022-08-09 18:00:00', 4, 1),
(1796, '2022-08-10 08:00:00', 3, 1),
(1797, '2022-08-10 12:00:00', 4, 1),
(1798, '2022-08-10 15:00:00', 3, 1),
(1799, '2022-08-10 18:00:00', 4, 1),
(1800, '2022-08-11 08:00:00', 3, 1),
(1801, '2022-08-11 12:00:00', 4, 1),
(1802, '2022-08-11 15:00:00', 3, 1),
(1803, '2022-08-11 18:00:00', 4, 1),
(1804, '2022-08-13 08:00:00', 3, 1),
(1805, '2022-08-13 12:00:00', 4, 1),
(1806, '2022-08-13 15:00:00', 3, 1),
(1807, '2022-08-13 18:00:00', 4, 1),
(1808, '2022-08-08 10:00:00', 5, 1),
(1809, '2022-08-10 10:00:00', 5, 1),
(1810, '2022-08-12 10:00:00', 5, 1),
(1811, '2022-08-09 10:00:00', 6, 1),
(1812, '2022-08-09 10:00:00', 6, 1),
(1813, '2022-08-12 10:00:00', 6, 1),
(1814, '2022-08-13 10:00:00', 6, 1),
(1815, '2022-08-09 10:00:00', 7, 1),
(1816, '2022-08-12 10:00:00', 7, 1),
(1817, '2022-08-10 10:00:00', 8, 1),
(1818, '2022-08-13 10:00:00', 8, 1),
(1819, '2022-08-08 10:00:00', 9, 1),
(1820, '2022-08-12 10:00:00', 10, 1),
(1821, '2022-08-26 16:00:00', 1, 1),
(1822, '2022-08-28 16:00:00', 2, 1),
(1823, '2022-08-22 08:00:00', 3, 1),
(1824, '2022-08-22 12:00:00', 4, 1),
(1825, '2022-08-22 15:00:00', 3, 1),
(1826, '2022-08-22 18:00:00', 4, 1),
(1827, '2022-08-23 08:00:00', 3, 1),
(1828, '2022-08-23 12:00:00', 4, 1),
(1829, '2022-08-23 15:00:00', 3, 1),
(1830, '2022-08-23 18:00:00', 4, 1),
(1831, '2022-08-24 08:00:00', 3, 1),
(1832, '2022-08-24 12:00:00', 4, 1),
(1833, '2022-08-24 15:00:00', 3, 1),
(1834, '2022-08-24 18:00:00', 4, 1),
(1835, '2022-08-25 08:00:00', 3, 1),
(1836, '2022-08-25 12:00:00', 4, 1),
(1837, '2022-08-25 15:00:00', 3, 1),
(1838, '2022-08-25 18:00:00', 4, 1),
(1839, '2022-08-27 08:00:00', 3, 1),
(1840, '2022-08-27 12:00:00', 4, 1),
(1841, '2022-08-27 15:00:00', 3, 1),
(1842, '2022-08-27 18:00:00', 4, 1),
(1843, '2022-08-22 10:00:00', 5, 1),
(1844, '2022-08-24 10:00:00', 5, 1),
(1845, '2022-08-26 10:00:00', 5, 1),
(1846, '2022-08-23 10:00:00', 6, 1),
(1847, '2022-08-23 10:00:00', 6, 1),
(1848, '2022-08-26 10:00:00', 6, 1),
(1849, '2022-08-27 10:00:00', 6, 1),
(1850, '2022-08-23 10:00:00', 7, 1),
(1851, '2022-08-26 10:00:00', 7, 1),
(1852, '2022-08-24 10:00:00', 8, 1),
(1853, '2022-08-27 10:00:00', 8, 1),
(1854, '2022-08-22 10:00:00', 9, 1),
(1855, '2022-08-26 10:00:00', 10, 1),
(1856, '2022-09-09 16:00:00', 1, 1),
(1857, '2022-09-11 16:00:00', 2, 1),
(1858, '2022-09-05 08:00:00', 3, 1),
(1859, '2022-09-05 12:00:00', 4, 1),
(1860, '2022-09-05 15:00:00', 3, 1),
(1861, '2022-09-05 18:00:00', 4, 1),
(1862, '2022-09-06 08:00:00', 3, 1),
(1863, '2022-09-06 12:00:00', 4, 1),
(1864, '2022-09-06 15:00:00', 3, 1),
(1865, '2022-09-06 18:00:00', 4, 1),
(1866, '2022-09-07 08:00:00', 3, 1),
(1867, '2022-09-07 12:00:00', 4, 1),
(1868, '2022-09-07 15:00:00', 3, 1),
(1869, '2022-09-07 18:00:00', 4, 1),
(1870, '2022-09-08 08:00:00', 3, 1),
(1871, '2022-09-08 12:00:00', 4, 1),
(1872, '2022-09-08 15:00:00', 3, 1),
(1873, '2022-09-08 18:00:00', 4, 1),
(1874, '2022-09-10 08:00:00', 3, 1),
(1875, '2022-09-10 12:00:00', 4, 1),
(1876, '2022-09-10 15:00:00', 3, 1),
(1877, '2022-09-10 18:00:00', 4, 1),
(1878, '2022-09-05 10:00:00', 5, 1),
(1879, '2022-09-07 10:00:00', 5, 1),
(1880, '2022-09-09 10:00:00', 5, 1),
(1881, '2022-09-06 10:00:00', 6, 1),
(1882, '2022-09-06 10:00:00', 6, 1),
(1883, '2022-09-09 10:00:00', 6, 1),
(1884, '2022-09-10 10:00:00', 6, 1),
(1885, '2022-09-06 10:00:00', 7, 1),
(1886, '2022-09-09 10:00:00', 7, 1),
(1887, '2022-09-07 10:00:00', 8, 1),
(1888, '2022-09-10 10:00:00', 8, 1),
(1889, '2022-09-05 10:00:00', 9, 1),
(1890, '2022-09-09 10:00:00', 10, 1),
(1891, '2022-09-23 16:00:00', 1, 1),
(1892, '2022-09-25 16:00:00', 2, 1),
(1893, '2022-09-19 08:00:00', 3, 1),
(1894, '2022-09-19 12:00:00', 4, 1),
(1895, '2022-09-19 15:00:00', 3, 1),
(1896, '2022-09-19 18:00:00', 4, 1),
(1897, '2022-09-20 08:00:00', 3, 1),
(1898, '2022-09-20 12:00:00', 4, 1),
(1899, '2022-09-20 15:00:00', 3, 1),
(1900, '2022-09-20 18:00:00', 4, 1),
(1901, '2022-09-21 08:00:00', 3, 1),
(1902, '2022-09-21 12:00:00', 4, 1),
(1903, '2022-09-21 15:00:00', 3, 1),
(1904, '2022-09-21 18:00:00', 4, 1),
(1905, '2022-09-22 08:00:00', 3, 1),
(1906, '2022-09-22 12:00:00', 4, 1),
(1907, '2022-09-22 15:00:00', 3, 1),
(1908, '2022-09-22 18:00:00', 4, 1),
(1909, '2022-09-24 08:00:00', 3, 1),
(1910, '2022-09-24 12:00:00', 4, 1),
(1911, '2022-09-24 15:00:00', 3, 1),
(1912, '2022-09-24 18:00:00', 4, 1),
(1913, '2022-09-19 10:00:00', 5, 1),
(1914, '2022-09-21 10:00:00', 5, 1),
(1915, '2022-09-23 10:00:00', 5, 1),
(1916, '2022-09-20 10:00:00', 6, 1),
(1917, '2022-09-20 10:00:00', 6, 1),
(1918, '2022-09-23 10:00:00', 6, 1),
(1919, '2022-09-24 10:00:00', 6, 1),
(1920, '2022-09-20 10:00:00', 7, 1),
(1921, '2022-09-23 10:00:00', 7, 1),
(1922, '2022-09-21 10:00:00', 8, 1),
(1923, '2022-09-24 10:00:00', 8, 1),
(1924, '2022-09-19 10:00:00', 9, 1),
(1925, '2022-09-23 10:00:00', 10, 1),
(1926, '2022-10-07 16:00:00', 1, 1),
(1927, '2022-10-09 16:00:00', 2, 1),
(1928, '2022-10-03 08:00:00', 3, 1),
(1929, '2022-10-03 12:00:00', 4, 1),
(1930, '2022-10-03 15:00:00', 3, 1),
(1931, '2022-10-03 18:00:00', 4, 1),
(1932, '2022-10-04 08:00:00', 3, 1),
(1933, '2022-10-04 12:00:00', 4, 1),
(1934, '2022-10-04 15:00:00', 3, 1),
(1935, '2022-10-04 18:00:00', 4, 1),
(1936, '2022-10-05 08:00:00', 3, 1),
(1937, '2022-10-05 12:00:00', 4, 1),
(1938, '2022-10-05 15:00:00', 3, 1),
(1939, '2022-10-05 18:00:00', 4, 1),
(1940, '2022-10-06 08:00:00', 3, 1),
(1941, '2022-10-06 12:00:00', 4, 1),
(1942, '2022-10-06 15:00:00', 3, 1),
(1943, '2022-10-06 18:00:00', 4, 1),
(1944, '2022-10-08 08:00:00', 3, 1),
(1945, '2022-10-08 12:00:00', 4, 1),
(1946, '2022-10-08 15:00:00', 3, 1),
(1947, '2022-10-08 18:00:00', 4, 1),
(1948, '2022-10-03 10:00:00', 5, 1),
(1949, '2022-10-05 10:00:00', 5, 1),
(1950, '2022-10-07 10:00:00', 5, 1),
(1951, '2022-10-04 10:00:00', 6, 1),
(1952, '2022-10-04 10:00:00', 6, 1),
(1953, '2022-10-07 10:00:00', 6, 1),
(1954, '2022-10-08 10:00:00', 6, 1),
(1955, '2022-10-04 10:00:00', 7, 1),
(1956, '2022-10-07 10:00:00', 7, 1),
(1957, '2022-10-05 10:00:00', 8, 1),
(1958, '2022-10-08 10:00:00', 8, 1),
(1959, '2022-10-03 10:00:00', 9, 1),
(1960, '2022-10-07 10:00:00', 10, 1),
(1961, '2022-10-21 16:00:00', 1, 1),
(1962, '2022-10-23 16:00:00', 2, 1),
(1963, '2022-10-17 08:00:00', 3, 1),
(1964, '2022-10-17 12:00:00', 4, 1),
(1965, '2022-10-17 15:00:00', 3, 1),
(1966, '2022-10-17 18:00:00', 4, 1),
(1967, '2022-10-18 08:00:00', 3, 1),
(1968, '2022-10-18 12:00:00', 4, 1),
(1969, '2022-10-18 15:00:00', 3, 1),
(1970, '2022-10-18 18:00:00', 4, 1),
(1971, '2022-10-19 08:00:00', 3, 1),
(1972, '2022-10-19 12:00:00', 4, 1),
(1973, '2022-10-19 15:00:00', 3, 1),
(1974, '2022-10-19 18:00:00', 4, 1),
(1975, '2022-10-20 08:00:00', 3, 1),
(1976, '2022-10-20 12:00:00', 4, 1),
(1977, '2022-10-20 15:00:00', 3, 1),
(1978, '2022-10-20 18:00:00', 4, 1),
(1979, '2022-10-22 08:00:00', 3, 1),
(1980, '2022-10-22 12:00:00', 4, 1),
(1981, '2022-10-22 15:00:00', 3, 1),
(1982, '2022-10-22 18:00:00', 4, 1),
(1983, '2022-10-17 10:00:00', 5, 1),
(1984, '2022-10-19 10:00:00', 5, 1),
(1985, '2022-10-21 10:00:00', 5, 1),
(1986, '2022-10-18 10:00:00', 6, 1),
(1987, '2022-10-18 10:00:00', 6, 1),
(1988, '2022-10-21 10:00:00', 6, 1),
(1989, '2022-10-22 10:00:00', 6, 1),
(1990, '2022-10-18 10:00:00', 7, 1),
(1991, '2022-10-21 10:00:00', 7, 1),
(1992, '2022-10-19 10:00:00', 8, 1),
(1993, '2022-10-22 10:00:00', 8, 1),
(1994, '2022-10-17 10:00:00', 9, 1),
(1995, '2022-10-21 10:00:00', 10, 1),
(1996, '2022-11-04 16:00:00', 1, 0),
(1997, '2022-11-06 16:00:00', 2, 0),
(1998, '2022-10-31 08:00:00', 3, 0),
(1999, '2022-10-31 12:00:00', 4, 0),
(2000, '2022-10-31 15:00:00', 3, 0),
(2001, '2022-10-31 18:00:00', 4, 0),
(2002, '2022-11-01 08:00:00', 3, 0),
(2003, '2022-11-01 12:00:00', 4, 0),
(2004, '2022-11-01 15:00:00', 3, 0),
(2005, '2022-11-01 18:00:00', 4, 0),
(2006, '2022-11-02 08:00:00', 3, 0),
(2007, '2022-11-02 12:00:00', 4, 0),
(2008, '2022-11-02 15:00:00', 3, 0),
(2009, '2022-11-02 18:00:00', 4, 0),
(2010, '2022-11-03 08:00:00', 3, 0),
(2011, '2022-11-03 12:00:00', 4, 0),
(2012, '2022-11-03 15:00:00', 3, 0),
(2013, '2022-11-03 18:00:00', 4, 0),
(2014, '2022-11-05 08:00:00', 3, 0),
(2015, '2022-11-05 12:00:00', 4, 0),
(2016, '2022-11-05 15:00:00', 3, 0),
(2017, '2022-11-05 18:00:00', 4, 0),
(2018, '2022-10-31 10:00:00', 5, 0),
(2019, '2022-11-02 10:00:00', 5, 0),
(2020, '2022-11-04 10:00:00', 5, 0),
(2021, '2022-11-01 10:00:00', 6, 0),
(2022, '2022-11-01 10:00:00', 6, 0),
(2023, '2022-11-04 10:00:00', 6, 0),
(2024, '2022-11-05 10:00:00', 6, 0),
(2025, '2022-11-01 10:00:00', 7, 0),
(2026, '2022-11-04 10:00:00', 7, 0),
(2027, '2022-11-02 10:00:00', 8, 0),
(2028, '2022-11-05 10:00:00', 8, 0),
(2029, '2022-10-31 10:00:00', 9, 0),
(2030, '2022-11-04 10:00:00', 10, 0);

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL,
  `fname` varchar(20) NOT NULL,
  `lname` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(16) NOT NULL,
  `user_level` int(11) NOT NULL DEFAULT 0,
  `pass` varchar(70) DEFAULT '12345'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `fname`, `lname`, `email`, `phone`, `user_level`, `pass`) VALUES
(13, 'mathew', 'lawrence', '17354272@gmail.com', '02102625325', 1, '$2b$10$9tgSlDOfeZjOxqMfU34fkOXxUqRFuyNLE8in/.RXj6JLFrV9xjoba'),
(14, 'Bob', 'Soap', 'bobby@gmail.com', '201212020', 1, '$2b$10$Cep446L6p0v0XvLaJYoXxOXzTlnooAaWyq0abi7uZiQlvbQO6jHTa'),
(15, '\" \"select * from use', 'Munasinge', 'test@gmail.com', '02102625325', 1, '$2b$10$EPgTjrSHdxTH0NotHl9pZOrQQ9JV6hQ3P1XRaclxVMfWg1RJgC.ve');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aircraft`
--
ALTER TABLE `aircraft`
  ADD PRIMARY KEY (`craftID`);

--
-- Indexes for table `booking`
--
ALTER TABLE `booking`
  ADD PRIMARY KEY (`booking_ref`),
  ADD KEY `fk_user_id` (`user_id`),
  ADD KEY `fk_flight_num` (`flight_id`);

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

--
-- Indexes for table `destinations`
--
ALTER TABLE `destinations`
  ADD PRIMARY KEY (`code`);

--
-- Indexes for table `routes`
--
ALTER TABLE `routes`
  ADD PRIMARY KEY (`routeID`),
  ADD KEY `point1` (`start`),
  ADD KEY `point2` (`end`),
  ADD KEY `fk_plane` (`plane_id`);

--
-- Indexes for table `times`
--
ALTER TABLE `times`
  ADD PRIMARY KEY (`flight_ID`),
  ADD KEY `fk_route` (`route_id`);

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`user_id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `booking`
--
ALTER TABLE `booking`
  MODIFY `booking_ref` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `debug_logging`
--
ALTER TABLE `debug_logging`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `routes`
--
ALTER TABLE `routes`
  MODIFY `routeID` int(12) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `times`
--
ALTER TABLE `times`
  MODIFY `flight_ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2031;

--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `booking`
--
ALTER TABLE `booking`
  ADD CONSTRAINT `fk_flight_num` FOREIGN KEY (`flight_id`) REFERENCES `times` (`flight_ID`),
  ADD CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`);

--
-- Constraints for table `routes`
--
ALTER TABLE `routes`
  ADD CONSTRAINT `fk_plane` FOREIGN KEY (`plane_id`) REFERENCES `aircraft` (`craftID`),
  ADD CONSTRAINT `routes_ibfk_1` FOREIGN KEY (`start`) REFERENCES `destinations` (`code`),
  ADD CONSTRAINT `routes_ibfk_2` FOREIGN KEY (`end`) REFERENCES `destinations` (`code`);

--
-- Constraints for table `times`
--
ALTER TABLE `times`
  ADD CONSTRAINT `fk_route` FOREIGN KEY (`route_id`) REFERENCES `routes` (`routeID`);
COMMIT;

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