-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Gegenereerd op: 04 apr 2018 om 17:16
-- Serverversie: 10.1.28-MariaDB
-- PHP-versie: 5.6.32

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `blueco_mpd_fleet_manager`
--

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

--
-- Tabelstructuur voor tabel `alarm`
--

DROP TABLE IF EXISTS `alarm`;
CREATE TABLE `alarm` (
  `alarm_id` int(11) NOT NULL,
  `obm_id` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT 'obm ship id',
  `ship` int(11) NOT NULL COMMENT 'link to table ship',
  `engine` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Engine id/name',
  `alarm_status` int(11) NOT NULL DEFAULT '1' COMMENT 'link to alarm_status.code',
  `pgn` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'alarm group id',
  `spn` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'spn alarm code',
  `fmi` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'fmi alarm code',
  `fault_code` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Cummins fault code',
  `line1` varchar(256) COLLATE utf8_unicode_ci NOT NULL COMMENT 'alarm text 1',
  `line2` varchar(256) COLLATE utf8_unicode_ci NOT NULL COMMENT 'alarm text 2',
  `lamp` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'lamp status',
  `date_received` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'when received on server',
  `date_occurred` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'when alarm occurred',
  `date_sent` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'when notification was sent to users',
  `processed` int(11) NOT NULL DEFAULT '0' COMMENT 'Alarm linked to users (=processed)?',
  `assigned_to` int(11) NOT NULL COMMENT 'Alarm assigned to user'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `alarm`
--

INSERT INTO `alarm` (`alarm_id`, `obm_id`, `ship`, `engine`, `alarm_status`, `pgn`, `spn`, `fmi`, `fault_code`, `line1`, `line2`, `lamp`, `date_received`, `date_occurred`, `date_sent`, `processed`, `assigned_to`) VALUES
(4, '0000000059c27625', 1, '', 1, '0', '1133', '16', '1986', 'Intake Manifold 4 Temperature', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 13:59:14', '2018-01-28 13:59:14', 1, 0),
(5, '0000000059c27625', 1, '', 1, '0', '1142', '16', '2133', 'Exh. Gas Temp. 6', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 09:40:02', '2018-01-28 09:40:02', 1, 0),
(6, '0000000059c27625', 1, '', 1, '0', '1141', '16', '2123', 'Exh. Gas Temp. 5', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 08:13:38', '2018-01-28 08:13:38', 1, 0),
(7, '0000000059c27625', 1, '', 1, '0', '110', '4', '145', 'Engine Coolant Temperature', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 00:32:50', '2018-01-28 00:32:50', 1, 0),
(8, '0000000059c27625', 1, '', 1, '0', '1147', '16', '2126', 'Exh. Gas Temp. 11', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 23:06:26', '2018-01-27 23:06:26', 1, 0),
(9, '0000000059c27625', 1, '', 1, '0', '111', '1', '235', 'Coolant Level', 'Low - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-27 22:08:50', '2018-01-27 22:08:50', 1, 0),
(10, '0000000059c27625', 1, '', 1, '0', '3511', '4', '238', 'Sensor Supply 3', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 18:18:26', '2018-01-27 18:18:26', 1, 0),
(11, '0000000059c27625', 1, '', 1, '0', '1142', '3', '1531', 'Exh. Gas Temp. 6', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 18:18:26', '2018-01-27 18:18:26', 1, 0),
(12, '0000000059c27625', 1, '', 1, '0', '1131', '16', '1984', 'Intake Manifold 2 Temperature', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 17:20:50', '2018-01-27 17:20:50', 1, 0),
(13, '0000000059c27625', 1, '', 1, '0', '974', '4', '1361', 'Backup Throttle', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 13:01:38', '2018-01-27 13:01:38', 1, 0),
(14, '0000000059c27625', 1, '', 1, '0', '1146', '16', '2135', 'Exh. Gas Temp. 10', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 12:04:02', '2018-01-27 12:04:02', 1, 0),
(15, '0000000059c27625', 1, '', 1, '0', '175', '4', '213', 'Engine Oil Temperature', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 07:16:02', '2018-01-27 07:16:02', 1, 0),
(16, '00000000a6e7fbc3', 2, '', 1, '0', '190', '2', '689', 'Crankshaft EPS', 'Data Erratic or Incorrect', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 06:47:14', '2018-01-28 06:47:14', 1, 0),
(17, '00000000a6e7fbc3', 2, '', 1, '0', '1132', '3', '159', 'Intake Manifold 3 Temperature ', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 21:40:02', '2018-01-27 21:40:02', 1, 0),
(18, '00000000a6e7fbc3', 2, '', 1, '0', '157', '18', '559', 'Fuel Rail Pressure', 'Low - Moderately Severe Level', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 03:25:38', '2018-01-27 03:25:38', 1, 0),
(19, '00000000a6e7fbc3', 2, '', 1, '0', '105', '4', '154', 'Intake Manifold 1 Temperature', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-26 16:52:02', '2018-01-26 16:52:02', 1, 0),
(20, '00000000fc2e0ea2', 4, '', 1, '0', '94', '3', '546', 'Fuel Delivery Pressure', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 12:04:02', '2018-01-28 12:04:02', 1, 0),
(21, '00000000fc2e0ea2', 4, '', 1, '0', '105', '0', '155', 'Intake Manifold 1 Temperature', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-28 07:16:02', '2018-01-28 07:16:02', 1, 0),
(22, '00000000fc2e0ea2', 4, '', 1, '0', '1152', '16', '2138', 'Exh. Gas Temp. 16', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 01:01:38', '2018-01-28 01:01:38', 1, 0),
(23, '00000000fc2e0ea2', 4, '', 1, '0', '3509', '4', '352', 'Sensor Supply 1', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 20:42:26', '2018-01-27 20:42:26', 1, 0),
(24, '00000000fc2e0ea2', 4, '', 1, '0', '101', '0', '556', 'Crankcase Pressure', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-27 19:44:50', '2018-01-27 19:44:50', 1, 0),
(25, '00000000fc2e0ea2', 4, '', 1, '0', '630', '13', '342', 'Calibration Code Incompatibile', 'Out of Calibration', 'RED', '2018-03-05 08:49:28', '2018-01-27 18:47:14', '2018-01-27 18:47:14', 1, 0),
(26, '00000000fc2e0ea2', 4, '', 1, '0', '100', '4', '141', 'Engine Oil Pressure', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 14:28:02', '2018-01-27 14:28:02', 1, 0),
(27, '00000000fc2e0ea2', 4, '', 1, '0', '157', '0', '1911', 'Injector Metering Rail 1 Pressure', 'High - Most Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 12:32:50', '2018-01-27 12:32:50', 1, 0),
(28, '00000000fc2e0ea2', 4, '', 1, '0', '1138', '3', '1529', 'Exh. Gas Temp. 2', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 12:32:50', '2018-01-27 12:32:50', 1, 0),
(29, '00000000fc2e0ea2', 4, '', 1, '0', '183', '16', '327', 'Fuel Consuption Rate', 'Above Normal - Moderately Severe', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 11:06:26', '2018-01-27 11:06:26', 1, 0),
(30, '00000000fc2e0ea2', 4, '', 1, '0', '3549', '4', '1378', 'Post-filter Oil Pressure', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 02:28:02', '2018-01-27 02:28:02', 1, 0),
(31, '00000000fc2e0ea2', 4, '', 1, '0', '110', '14', '1847', 'Engine Coolant Temperature', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-27 01:59:14', '2018-01-27 01:59:14', 1, 0),
(32, '00000000fc2e0ea2', 4, '', 1, '0', '1337', '17', '628', 'Exh. Gas Temp. 15  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-26 23:06:26', '2018-01-26 23:06:26', 1, 0),
(33, '00000000fc2e0ea2', 4, '', 1, '0', '1347', '3', '272', 'Fuel Pump Pressure', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-26 22:08:50', '2018-01-26 22:08:50', 1, 0),
(34, '00000000fc2e0ea2', 4, '', 1, '0', '173', '16', '248', 'Exh. Gas Temp.', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-26 22:08:50', '2018-01-26 22:08:50', 1, 0),
(35, '00000000789b4a17', 7, '', 7, '0', '1145', '16', '2125', 'Exh. Gas Temp. 9', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 15:40:02', '2018-01-28 15:40:02', 1, 0),
(36, '00000000789b4a17', 7, '', 7, '0', '1148', '16', '2136', 'Exh. Gas Temp. 12', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 14:13:38', '2018-01-28 14:13:38', 1, 0),
(37, '00000000789b4a17', 7, '', 7, '0', '656', '5', '325', 'Injector 6', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 13:16:02', '2018-01-28 13:16:02', 1, 0),
(38, '00000000789b4a17', 7, '', 7, '0', '663', '5', '1554', 'Injector 13', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 08:56:50', '2018-01-28 08:56:50', 1, 0),
(39, '00000000789b4a17', 7, '', 7, '0', '1147', '4', '676', 'Exh. Gas Temp. 11  ', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 06:18:26', '2018-01-28 06:18:26', 1, 0),
(40, '00000000789b4a17', 7, '', 7, '0', '97', '3', '1845', 'Water in Fuel Indicator ', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 04:37:38', '2018-01-28 04:37:38', 1, 0),
(41, '00000000789b4a17', 7, '', 7, '0', '1265', '3', '224', 'Oil Burn Valve', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 00:04:02', '2018-01-28 00:04:02', 1, 0),
(42, '00000000789b4a17', 7, '', 7, '0', '1152', '4', '728', 'Exh. Gas Temp. 16', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 20:56:50', '2018-01-27 20:56:50', 1, 0),
(43, '00000000789b4a17', 7, '', 7, '0', '1338', '17', '638', 'Exh. Gas Temp. 16', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 19:01:38', '2018-01-27 19:01:38', 1, 0),
(44, '00000000789b4a17', 7, '', 7, '0', '105', '3', '153', 'Intake Manifold 1 Temperature', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 17:20:50', '2018-01-27 17:20:50', 1, 0),
(45, '00000000538ba028', 8, '', 3, '0', '1139', '16', '2122', 'Exh. Gas Temp. 3', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 14:42:26', '2018-01-28 14:42:26', 1, 0),
(46, '00000000538ba028', 8, '', 1, '0', '102', '3', '122', 'Intake Manifold 1 Pressure', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 13:59:14', '2018-01-28 13:59:14', 1, 0),
(47, '00000000538ba028', 8, '', 1, '0', '660', '5', '1551', 'Injector 10', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 04:52:02', '2018-01-28 04:52:02', 1, 0),
(48, '00000000538ba028', 8, '', 1, '0', '1380', '18', '1357', 'Remote Oil Level', 'Low - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 02:42:26', '2018-01-28 02:42:26', 1, 0),
(49, '00000000538ba028', 8, '', 1, '0', '1132', '16', '1985', 'Intake Manifold 3 Temperature', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 02:28:02', '2018-01-28 02:28:02', 1, 0),
(50, '00000000538ba028', 8, '', 1, '0', '168', '18', '441', 'Battery 1 Voltage ', 'Low - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 01:01:38', '2018-01-28 01:01:38', 1, 0),
(51, '00000000538ba028', 8, '', 1, '0', '1329', '17', '624', 'Exh. Gas Temp. 7  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 00:47:14', '2018-01-28 00:47:14', 1, 0),
(52, '00000000538ba028', 8, '', 1, '0', '1328', '17', '633', 'Exh. Gas Temp. 6', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 23:06:26', '2018-01-27 23:06:26', 1, 0),
(53, '00000000538ba028', 8, '', 1, '0', '644', '2', '237', 'MUS Input', 'Data Erratic or Incorrect', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 21:11:14', '2018-01-27 21:11:14', 1, 0),
(54, '00000000538ba028', 8, '', 1, '0', '2434', '3', '2655', 'Exh. Stack Temp. - Left', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 19:59:14', '2018-01-27 19:59:14', 1, 0),
(55, '00000000538ba028', 8, '', 1, '0', '1265', '4', '223', 'Oil Burn Valve', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 16:37:38', '2018-01-27 16:37:38', 1, 0),
(56, '000000007b019b16', 9, '', 1, '0', '1152', '3', '1536', 'Exh. Gas Temp. 16', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 13:44:50', '2018-01-28 13:44:50', 1, 0),
(57, '000000007b019b16', 9, '', 1, '0', '1075', '3', '2265', 'Electric Lift Pump', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 13:30:26', '2018-01-28 13:30:26', 1, 0),
(58, '000000007b019b16', 9, '', 1, '0', '100', '18', '143', 'Engine Oil Pressure', 'Low - Moderately Severe Level', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 13:16:02', '2018-01-28 13:16:02', 1, 0),
(59, '000000007b019b16', 9, '', 1, '0', '1336', '17', '637', 'Exh. Gas Temp. 14', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 11:35:14', '2018-01-28 11:35:14', 1, 0),
(60, '000000007b019b16', 9, '', 1, '0', '3549', '3', '1377', 'Post-filter Oil Pressure', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 09:25:38', '2018-01-28 09:25:38', 1, 0),
(61, '000000007b019b16', 9, '', 1, '0', '105', '16', '488', 'Intake Manifold Temperature', 'High - Moderately Severe Level', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 08:28:02', '2018-01-28 08:28:02', 1, 0),
(62, '000000007b019b16', 9, '', 1, '0', '658', '5', '1549', 'Injector 8', 'Current Below Normal or Open Circuit', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 08:13:38', '2018-01-28 08:13:38', 1, 0),
(63, '000000007b019b16', 9, '', 1, '0', '1128', '4', '1386', 'Intake Manifold 2 Pressure', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 04:08:50', '2018-01-28 04:08:50', 1, 0),
(64, '000000007b019b16', 9, '', 1, '0', '1140', '4', '722', 'Exh. Gas Temp. 4', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 00:32:50', '2018-01-28 00:32:50', 1, 0),
(65, '000000007b019b16', 9, '', 1, '0', '2433', '3', '2651', 'Exh. Stack Temp. - Right', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 23:06:26', '2018-01-27 23:06:26', 1, 0),
(66, '000000007b019b16', 9, '', 1, '0', '1139', '4', '672', 'Exh. Gas Temp. 3  ', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 22:08:50', '2018-01-27 22:08:50', 1, 0),
(67, '000000007b019b16', 9, '', 1, '0', '1150', '4', '727', 'Exh. Gas Temp. 14', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 19:30:26', '2018-01-27 19:30:26', 1, 0),
(68, '000000007b019b16', 9, '', 1, '0', '1335', '17', '627', 'Exh. Gas Temp. 13  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 18:47:14', '2018-01-27 18:47:14', 1, 0),
(69, '00000000f53b1307', 10, '', 1, '0', '174', '0', '266', 'Engine Fuel Temperature', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-28 13:01:38', '2018-01-28 13:01:38', 1, 0),
(70, '00000000f53b1307', 10, '', 1, '0', '1148', '3', '1534', 'Exh. Gas Temp. 12', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 11:35:14', '2018-01-28 11:35:14', 1, 0),
(71, '00000000f53b1307', 10, '', 1, '0', '657', '5', '1548', 'Injector 7', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 10:08:50', '2018-01-28 10:08:50', 1, 0),
(72, '00000000f53b1307', 10, '', 1, '0', '1150', '3', '1535', 'Exh. Gas Temp. 14', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 07:16:02', '2018-01-28 07:16:02', 1, 0),
(73, '00000000f53b1307', 10, '', 1, '0', '1137', '3', '1618', 'Exh. Gas Temp. 1', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 05:49:38', '2018-01-28 05:49:38', 1, 0),
(74, '00000000f53b1307', 10, '', 1, '0', '190', '0', '234', 'Crankshaft EPS', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-28 05:49:38', '2018-01-28 05:49:38', 1, 0),
(75, '00000000f53b1307', 10, '', 1, '0', '664', '5', '1555', 'Injector 14', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 04:37:38', '2018-01-28 04:37:38', 1, 0),
(76, '00000000f53b1307', 10, '', 1, '0', '659', '5', '1622', 'Injector 9', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 01:59:14', '2018-01-28 01:59:14', 1, 0),
(77, '00000000f53b1307', 10, '', 1, '0', '3510', '4', '187', 'Sensor Supply 2', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 00:04:02', '2018-01-28 00:04:02', 1, 0),
(78, '00000000f53b1307', 10, '', 1, '0', '108', '3', '221', 'Barometric Pressure', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 19:30:26', '2018-01-27 19:30:26', 1, 0),
(80, '0000000042ca2e81', 12, '', 1, '0', '1149', '16', '2127', 'Exh. Gas Temp. 13', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 12:04:02', '2018-01-28 12:04:02', 1, 0),
(81, '0000000042ca2e81', 12, '', 1, '0', '558', '2', '431', 'Idle Validation Switch', 'Data Erratic or Incorrect', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 09:54:26', '2018-01-28 09:54:26', 1, 0),
(82, '0000000042ca2e81', 12, '', 1, '0', '665', '5', '1556', 'Injector 15', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 05:20:50', '2018-01-28 05:20:50', 1, 0),
(83, '0000000042ca2e81', 12, '', 1, '0', '661', '5', '1552', 'Injector 11', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 03:25:38', '2018-01-28 03:25:38', 1, 0),
(84, '0000000042ca2e81', 12, '', 1, '0', '102', '4', '1384', 'Intake Manifold Pressure', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 00:18:26', '2018-01-28 00:18:26', 1, 0),
(85, '0000000042ca2e81', 12, '', 1, '0', '1143', '16', '2124', 'Exh. Gas Temp. 7', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-27 21:40:02', '2018-01-27 21:40:02', 1, 0),
(87, '000000008416916d', 16, '', 1, '0', '101', '3', '1843', 'Crankcase Pressure', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 13:59:14', '2018-01-28 13:59:14', 1, 0),
(88, '000000008416916d', 16, '', 1, '0', '1137', '16', '2121', 'Exh. Gas Temp. 1', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 13:44:50', '2018-01-28 13:44:50', 1, 0),
(89, '000000008416916d', 16, '', 1, '0', '1333', '17', '626', 'Exh. Gas Temp. 11  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 11:06:26', '2018-01-28 11:06:26', 1, 0),
(90, '000000008416916d', 16, '', 1, '0', '1330', '17', '634', 'Exh. Gas Temp. 8', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 08:42:26', '2018-01-28 08:42:26', 1, 0),
(91, '000000008416916d', 16, '', 1, '0', '102', '3', '1383', 'Intake Manifold Pressure', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 08:13:38', '2018-01-28 08:13:38', 1, 0),
(92, '000000008416916d', 16, '', 1, '0', '3512', '3', '2185', 'Sensor Supply 4 Circuit', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 03:11:14', '2018-01-28 03:11:14', 1, 0),
(93, '000000008416916d', 16, '', 1, '0', '2434', '16', '2657', 'Exh. Stack Temp. - Left', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 03:11:14', '2018-01-28 03:11:14', 1, 0),
(94, '000000008416916d', 16, '', 1, '0', '1131', '4', '157', 'Intake Manifold 2 Temperature ', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 02:13:38', '2018-01-28 02:13:38', 1, 0),
(95, '000000008416916d', 16, '', 1, '0', '110', '16', '146', 'Engine Coolant Temperature', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 01:44:50', '2018-01-28 01:44:50', 1, 0),
(96, '000000008416916d', 16, '', 1, '0', '175', '0', '214', 'Engine Oil Temperature', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-28 00:04:02', '2018-01-28 00:04:02', 1, 0),
(97, '000000008416916d', 16, '', 1, '0', '1146', '3', '1533', 'Exh. Gas Temp. 10', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-27 18:18:26', '2018-01-27 18:18:26', 1, 0),
(98, '00000000c1063dc1', 19, '', 6, '0', '1132', '0', '162', 'Intake Manifold 3 Temperature ', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:28', '2018-01-28 15:25:38', '2018-01-28 15:25:38', 1, 0),
(99, '00000000c1063dc1', 19, '', 1, '0', '3509', '3', '386', 'Sensor Supply 1', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 14:28:02', '2018-01-28 14:28:02', 1, 0),
(100, '00000000c1063dc1', 19, '', 1, '0', '1143', '4', '674', 'Exh. Gas Temp. 7  ', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:28', '2018-01-28 11:20:50', '2018-01-28 11:20:50', 1, 0),
(101, '00000000c1063dc1', 19, '', 1, '0', '100', '3', '135', 'Engine Oil Pressure', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 10:37:38', '2018-01-28 10:37:38', 1, 0),
(102, '00000000c1063dc1', 19, '', 1, '0', '94', '18', '2215', 'Fuel Pump Delivery Pressure', 'Low - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:28', '2018-01-28 09:11:14', '2018-01-28 09:11:14', 1, 0),
(103, '00000000c1063dc1', 19, '', 1, '0', '105', '10', '783', 'Intake Manifold Temperature', 'Abnormal Rate of Change', 'RED', '2018-03-05 08:49:29', '2018-01-28 07:44:50', '2018-01-28 07:44:50', 1, 0),
(104, '00000000c1063dc1', 19, '', 1, '0', '633', '31', '2311', 'Fuel Injection Control Valve', 'Fault Condition Exists', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 05:20:50', '2018-01-28 05:20:50', 1, 0),
(105, '00000000c1063dc1', 19, '', 1, '0', '974', '3', '1595', 'Backup Throttle', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 04:23:14', '2018-01-28 04:23:14', 1, 0),
(106, '00000000c1063dc1', 19, '', 1, '0', '100', '1', '415', 'Engine Oil Pressure', 'Low - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-28 03:54:26', '2018-01-28 03:54:26', 1, 0),
(107, '00000000c1063dc1', 19, '', 1, '0', '1133', '0', '165', 'Intake Manifold 4 Temperature', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-28 01:44:50', '2018-01-28 01:44:50', 1, 0),
(108, '00000000c1063dc1', 19, '', 1, '0', '1075', '4', '2266', 'Electric Lift Pump', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 00:47:14', '2018-01-28 00:47:14', 1, 0),
(109, '00000000c1063dc1', 19, '', 1, '0', '157', '4', '452', ' Fuel Rail Pressure', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 00:18:26', '2018-01-28 00:18:26', 1, 0),
(110, '00000000c1063dc1', 19, '', 1, '0', '109', '4', '232', 'Coolant Pressure', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 23:20:50', '2018-01-27 23:20:50', 1, 0),
(111, '00000000c1063dc1', 19, '', 1, '0', '612', '2', '115', 'Main/Crank EPS', 'Data Erratic or Incorrect', 'RED', '2018-03-05 08:49:29', '2018-01-27 18:32:50', '2018-01-27 18:32:50', 1, 0),
(114, '0000000053230424', 23, '', 1, '0', '1142', '4', '723', 'Exh. Gas Temp. 6', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 14:42:26', '2018-01-28 14:42:26', 1, 0),
(115, '0000000053230424', 23, '', 1, '0', '1377', '2', '497', 'Multiple Unit Synchronization Switch', 'Data Erratic or Incorrect', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 13:30:26', '2018-01-28 13:30:26', 1, 0),
(116, '0000000053230424', 23, '', 1, '0', '653', '5', '324', 'Injector 3', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 04:52:02', '2018-01-28 04:52:02', 1, 0),
(117, '0000000053230424', 23, '', 1, '0', '173', '0', '2737', 'Exh. Stack Temp. ', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-28 04:23:14', '2018-01-28 04:23:14', 1, 0),
(118, '0000000053230424', 23, '', 1, '0', '1149', '3', '1526', 'Exh. Gas Temp. 13', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 03:40:02', '2018-01-28 03:40:02', 1, 0),
(119, '0000000053230424', 23, '', 1, '0', '1208', '4', '1368', 'Pre-filter Oil Pressure', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 03:25:38', '2018-01-28 03:25:38', 1, 0),
(120, '0000000053230424', 23, '', 1, '0', '723', '7', '731', 'Crank/Cam EPS', 'Out of Adjustment', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 21:11:14', '2018-01-27 21:11:14', 1, 0),
(121, '0000000053230424', 23, '', 1, '0', '1143', '3', '1523', 'Exh. Gas Temp. 7', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 21:11:14', '2018-01-27 21:11:14', 1, 0),
(122, '0000000053230424', 23, '', 1, '0', '723', '2', '1376', 'Camshaft EPS', 'Data Erratic or Incorrect', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 21:11:14', '2018-01-27 21:11:14', 1, 0),
(123, '0000000053230424', 23, '', 1, '0', '111', '3', '195', 'Coolant Level', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 19:59:14', '2018-01-27 19:59:14', 1, 0),
(124, '0000000053230424', 23, '', 1, '0', '1148', '4', '726', 'Exh. Gas Temp. 12', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 16:37:38', '2018-01-27 16:37:38', 1, 0),
(125, '00000000985cd9d5', 25, '', 1, '0', '1144', '16', '2134', 'Exh. Gas Temp. 8', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 13:59:14', '2018-01-28 13:59:14', 1, 0),
(126, '00000000985cd9d5', 25, '', 1, '0', '1145', '3', '1524', 'Exh. Gas Temp. 9', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 09:11:14', '2018-01-28 09:11:14', 1, 0),
(127, '00000000985cd9d5', 25, '', 1, '0', '1133', '4', '164', 'Intake Manifold 4 Temperature', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 02:56:50', '2018-01-28 02:56:50', 1, 0),
(128, '00000000985cd9d5', 25, '', 1, '0', '651', '5', '322', 'Injector 1', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 13:01:38', '2018-01-27 13:01:38', 1, 0),
(129, '00000000985cd9d5', 25, '', 1, '0', '1146', '4', '725', 'Exh. Gas Temp. 10', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 12:32:50', '2018-01-27 12:32:50', 1, 0),
(130, '00000000985cd9d5', 25, '', 1, '0', '109', '1', '228', 'Coolant Pressure', 'Low - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-27 06:18:26', '2018-01-27 06:18:26', 1, 0),
(131, '00000000985cd9d5', 25, '', 1, '0', '2433', '0', '2654', 'Exh. Stack Temp. - Right', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-27 05:49:38', '2018-01-27 05:49:38', 1, 0),
(132, '00000000985cd9d5', 25, '', 1, '0', '1138', '4', '721', 'Exh. Gas Temp. 2', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 03:54:26', '2018-01-27 03:54:26', 1, 0),
(133, '00000000985cd9d5', 25, '', 1, '0', '1132', '4', '161', 'Intake Manifold 3 Temperature ', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 01:59:14', '2018-01-27 01:59:14', 1, 0),
(134, '00000000985cd9d5', 25, '', 1, '0', '4184', '3', '1418', 'Gain Adjust', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 01:01:38', '2018-01-27 01:01:38', 1, 0),
(135, '00000000985cd9d5', 25, '', 1, '0', '174', '16', '261', 'Engine Fuel Temperature', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:29', '2018-01-26 18:18:26', '2018-01-26 18:18:26', 1, 0),
(136, '00000000985cd9d5', 25, '', 1, '0', '111', '18', '197', 'Coolant Level', 'Low - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:29', '2018-01-26 17:49:38', '2018-01-26 17:49:38', 1, 0),
(138, '000000002d006c75', 28, '', 7, '0', '1327', '17', '623', 'Exh. Gas Temp. 5  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 14:56:50', '2018-01-28 14:56:50', 1, 0),
(139, '000000002d006c75', 28, '', 7, '0', '1140', '16', '2132', 'Exh. Gas Temp. 4', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 13:59:14', '2018-01-28 13:59:14', 1, 0),
(140, '000000002d006c75', 28, '', 7, '0', '1151', '4', '678', 'Exh. Gas Temp. 15  ', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 11:06:26', '2018-01-28 11:06:26', 1, 0),
(141, '000000002d006c75', 28, '', 7, '0', '174', '4', '265', 'Engine Fuel Temperature', 'Voltage Below Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 08:28:02', '2018-01-28 08:28:02', 1, 0),
(142, '000000002d006c75', 28, '', 7, '0', '97', '4', '1846', 'Water in Fuel Indicator', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 06:18:26', '2018-01-28 06:18:26', 1, 0),
(143, '000000002d006c75', 28, '', 6, '0', '2434', '0', '2658', 'Exh. Stack Temp. - Left', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-28 01:16:02', '2018-01-28 01:16:02', 1, 0),
(144, '000000002d006c75', 28, '', 7, '0', '652', '5', '331', 'Injector 2', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 20:42:26', '2018-01-27 20:42:26', 1, 0),
(145, '000000002d006c75', 28, '', 7, '0', '666', '5', '1557', 'Injector 16', 'Current Below Normal or Open Circuit', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 18:32:50', '2018-01-27 18:32:50', 1, 0),
(146, '000000002d006c75', 28, '', 7, '0', '1331', '17', '625', 'Exh. Gas Temp. 9  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 18:32:50', '2018-01-27 18:32:50', 1, 0),
(147, '000000002d006c75', 28, '', 7, '0', '4183', '3', '1412', 'Droop Adjust ', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 17:35:14', '2018-01-27 17:35:14', 1, 0),
(149, '00000000de16d3e9', 33, '', 1, '0', '168', '16', '442', 'Battery 1 Voltage', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 13:59:14', '2018-01-28 13:59:14', 1, 0),
(150, '00000000de16d3e9', 33, '', 1, '0', '1325', '17', '622', 'Exh. Gas Temp. 3  ', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 13:01:38', '2018-01-28 13:01:38', 1, 0),
(151, '00000000de16d3e9', 33, '', 1, '0', '1334', '17', '636', 'Exh. Gas Temp. 12', 'Temperature Low - Moderately Severe', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 09:11:14', '2018-01-28 09:11:14', 1, 0),
(152, '00000000de16d3e9', 33, '', 1, '0', '97', '16', '1852', 'Water in Fuel Indicator', 'High - Moderately Severe Level', 'AMBER', '2018-03-05 08:49:29', '2018-01-28 07:16:02', '2018-01-28 07:16:02', 1, 0),
(153, '00000000de16d3e9', 33, '', 1, '0', '1131', '10', '2157', 'Intake Manifold 2 Temperature', 'Abnormal Rate of Change', 'RED', '2018-03-05 08:49:29', '2018-01-28 06:47:14', '2018-01-28 06:47:14', 1, 0),
(154, '00000000de16d3e9', 33, '', 1, '0', '558', '13', '2697', 'Idle Validation Switch', 'Out of Calibration', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 01:59:14', '2018-01-28 01:59:14', 1, 0),
(155, '00000000de16d3e9', 33, '', 1, '0', '1149', '4', '677', 'Exh. Gas Temp. 13  ', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 01:01:38', '2018-01-28 01:01:38', 1, 0),
(156, '00000000de16d3e9', 33, '', 1, '0', '1137', '4', '671', 'Exh. Gas Temp. 1 ', 'Voltage Below Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-28 01:01:38', '2018-01-28 01:01:38', 1, 0),
(157, '00000000de16d3e9', 33, '', 1, '0', '157', '0', '449', ' Fuel Rail Pressure', 'High - Most Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-27 18:18:26', '2018-01-27 18:18:26', 1, 0),
(158, '00000000de16d3e9', 33, '', 1, '0', '1141', '3', '1522', 'Exh. Gas Temp. 5', 'Voltage Above Normal', 'MAINTENANCE', '2018-03-05 08:49:29', '2018-01-27 14:56:50', '2018-01-27 14:56:50', 1, 0),
(159, '00000000de16d3e9', 33, '', 1, '0', '3938', '3', '1978', 'Speed Bias Circuit', 'Voltage Above Normal', 'AMBER', '2018-03-05 08:49:29', '2018-01-27 07:44:50', '2018-01-27 07:44:50', 1, 0),
(160, '00000000de16d3e9', 33, '', 1, '0', '190', '16', '1992', 'Engine Overspeed ', 'High - Moderately Severe Level', 'RED', '2018-03-05 08:49:29', '2018-01-27 02:56:50', '2018-01-27 02:56:50', 1, 0);

--
-- Triggers `alarm`
--
DROP TRIGGER IF EXISTS `Delete_alarm_related`;
DELIMITER $$
CREATE TRIGGER `Delete_alarm_related` AFTER DELETE ON `alarm` FOR EACH ROW BEGIN
	DELETE FROM alarm_user
	WHERE alarm_user.alarm = OLD.alarm_id;
	DELETE FROM alarm_user_device
	WHERE alarm_user_device.alarm = OLD.alarm_id;
	DELETE FROM alarm_status_history
	WHERE alarm_status_history.alarm = OLD.alarm_id;
END
$$
DELIMITER ;

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

--
-- Tabelstructuur voor tabel `alarm_status`
--

DROP TABLE IF EXISTS `alarm_status`;
CREATE TABLE `alarm_status` (
  `alarm_status_id` int(11) NOT NULL,
  `status_code` int(11) NOT NULL,
  `language` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `text` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
  `color` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `alarm_status`
--

INSERT INTO `alarm_status` (`alarm_status_id`, `status_code`, `language`, `text`, `color`) VALUES
(1, 1, 'en', 'New alarm', 1),
(2, 1, 'nl', 'Nieuw alarm', 1),
(3, 2, 'en', 'Call taken', 2),
(4, 2, 'nl', 'Gebeld met klant', 2),
(5, 3, 'en', 'To be planned', 2),
(6, 3, 'nl', 'Te plannen', 2),
(7, 4, 'en', 'Appointment made', 2),
(8, 4, 'nl', 'Afspraak gemaakt', 2),
(9, 5, 'en', 'Work done', 3),
(10, 5, 'nl', 'Werk gereed', 3),
(11, 6, 'en', 'Checked by coordinator', 3),
(12, 6, 'nl', 'Beoordeeld door coördinator', 3),
(13, 7, 'en', 'Finished', 4),
(14, 7, 'nl', 'Afgehandeld', 4);

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

--
-- Tabelstructuur voor tabel `alarm_status_history`
--

DROP TABLE IF EXISTS `alarm_status_history`;
CREATE TABLE `alarm_status_history` (
  `alarm_status_history_id` int(11) NOT NULL,
  `alarm` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `date_changed` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `user` int(11) NOT NULL,
  `double` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `alarm_status_history`
--

INSERT INTO `alarm_status_history` (`alarm_status_history_id`, `alarm`, `status`, `date_changed`, `user`, `double`) VALUES
(1, 4, 1, '2018-04-04 15:11:34', 0, 0),
(2, 5, 1, '2018-04-04 15:11:34', 0, 0),
(3, 6, 1, '2018-04-04 15:11:34', 0, 0),
(4, 7, 1, '2018-04-04 15:11:34', 0, 0),
(5, 8, 1, '2018-04-04 15:11:34', 0, 0),
(6, 9, 1, '2018-04-04 15:11:34', 0, 0),
(7, 10, 1, '2018-04-04 15:11:34', 0, 0),
(8, 11, 1, '2018-04-04 15:11:34', 0, 0),
(9, 12, 1, '2018-04-04 15:11:34', 0, 0),
(10, 13, 1, '2018-04-04 15:11:34', 0, 0),
(11, 14, 1, '2018-04-04 15:11:34', 0, 0),
(12, 15, 1, '2018-04-04 15:11:34', 0, 0),
(13, 16, 1, '2018-04-04 15:11:34', 0, 0),
(14, 17, 1, '2018-04-04 15:11:34', 0, 0),
(15, 18, 1, '2018-04-04 15:11:34', 0, 0),
(16, 19, 1, '2018-04-04 15:11:34', 0, 0),
(17, 20, 1, '2018-04-04 15:11:34', 0, 0),
(18, 21, 1, '2018-04-04 15:11:34', 0, 0),
(19, 22, 1, '2018-04-04 15:11:34', 0, 0),
(20, 23, 1, '2018-04-04 15:11:34', 0, 0),
(21, 24, 1, '2018-04-04 15:11:34', 0, 0),
(22, 25, 1, '2018-04-04 15:11:34', 0, 0),
(23, 26, 1, '2018-04-04 15:11:34', 0, 0),
(24, 27, 1, '2018-04-04 15:11:34', 0, 0),
(25, 28, 1, '2018-04-04 15:11:34', 0, 0),
(26, 29, 1, '2018-04-04 15:11:34', 0, 0),
(27, 30, 1, '2018-04-04 15:11:34', 0, 0),
(28, 31, 1, '2018-04-04 15:11:34', 0, 0),
(29, 32, 1, '2018-04-04 15:11:34', 0, 0),
(30, 33, 1, '2018-04-04 15:11:34', 0, 0),
(31, 34, 1, '2018-04-04 15:11:34', 0, 0),
(32, 46, 1, '2018-04-04 15:11:34', 0, 0),
(33, 47, 1, '2018-04-04 15:11:34', 0, 0),
(34, 48, 1, '2018-04-04 15:11:34', 0, 0),
(35, 49, 1, '2018-04-04 15:11:34', 0, 0),
(36, 50, 1, '2018-04-04 15:11:34', 0, 0),
(37, 51, 1, '2018-04-04 15:11:34', 0, 0),
(38, 52, 1, '2018-04-04 15:11:34', 0, 0),
(39, 53, 1, '2018-04-04 15:11:34', 0, 0),
(40, 54, 1, '2018-04-04 15:11:34', 0, 0),
(41, 55, 1, '2018-04-04 15:11:34', 0, 0),
(42, 56, 1, '2018-04-04 15:11:34', 0, 0),
(43, 57, 1, '2018-04-04 15:11:34', 0, 0),
(44, 58, 1, '2018-04-04 15:11:34', 0, 0),
(45, 59, 1, '2018-04-04 15:11:34', 0, 0),
(46, 60, 1, '2018-04-04 15:11:34', 0, 0),
(47, 61, 1, '2018-04-04 15:11:34', 0, 0),
(48, 62, 1, '2018-04-04 15:11:34', 0, 0),
(49, 63, 1, '2018-04-04 15:11:34', 0, 0),
(50, 64, 1, '2018-04-04 15:11:34', 0, 0),
(51, 65, 1, '2018-04-04 15:11:34', 0, 0),
(52, 66, 1, '2018-04-04 15:11:34', 0, 0),
(53, 67, 1, '2018-04-04 15:11:34', 0, 0),
(54, 68, 1, '2018-04-04 15:11:34', 0, 0),
(55, 69, 1, '2018-04-04 15:11:34', 0, 0),
(56, 70, 1, '2018-04-04 15:11:34', 0, 0),
(57, 71, 1, '2018-04-04 15:11:34', 0, 0),
(58, 72, 1, '2018-04-04 15:11:34', 0, 0),
(59, 73, 1, '2018-04-04 15:11:34', 0, 0),
(60, 74, 1, '2018-04-04 15:11:34', 0, 0),
(61, 75, 1, '2018-04-04 15:11:34', 0, 0),
(62, 76, 1, '2018-04-04 15:11:34', 0, 0),
(63, 77, 1, '2018-04-04 15:11:34', 0, 0),
(64, 78, 1, '2018-04-04 15:11:34', 0, 0),
(65, 80, 1, '2018-04-04 15:11:34', 0, 0),
(66, 81, 1, '2018-04-04 15:11:34', 0, 0),
(67, 82, 1, '2018-04-04 15:11:34', 0, 0),
(68, 83, 1, '2018-04-04 15:11:34', 0, 0),
(69, 84, 1, '2018-04-04 15:11:34', 0, 0),
(70, 85, 1, '2018-04-04 15:11:34', 0, 0),
(71, 87, 1, '2018-04-04 15:11:34', 0, 0),
(72, 88, 1, '2018-04-04 15:11:34', 0, 0),
(73, 89, 1, '2018-04-04 15:11:34', 0, 0),
(74, 90, 1, '2018-04-04 15:11:34', 0, 0),
(75, 91, 1, '2018-04-04 15:11:34', 0, 0),
(76, 92, 1, '2018-04-04 15:11:34', 0, 0),
(77, 93, 1, '2018-04-04 15:11:34', 0, 0),
(78, 94, 1, '2018-04-04 15:11:34', 0, 0),
(79, 95, 1, '2018-04-04 15:11:34', 0, 0),
(80, 96, 1, '2018-04-04 15:11:34', 0, 0),
(81, 97, 1, '2018-04-04 15:11:34', 0, 0),
(82, 99, 1, '2018-04-04 15:11:34', 0, 0),
(83, 100, 1, '2018-04-04 15:11:34', 0, 0),
(84, 101, 1, '2018-04-04 15:11:34', 0, 0),
(85, 102, 1, '2018-04-04 15:11:34', 0, 0),
(86, 103, 1, '2018-04-04 15:11:34', 0, 0),
(87, 104, 1, '2018-04-04 15:11:34', 0, 0),
(88, 105, 1, '2018-04-04 15:11:34', 0, 0),
(89, 106, 1, '2018-04-04 15:11:34', 0, 0),
(90, 107, 1, '2018-04-04 15:11:34', 0, 0),
(91, 108, 1, '2018-04-04 15:11:34', 0, 0),
(92, 109, 1, '2018-04-04 15:11:34', 0, 0),
(93, 110, 1, '2018-04-04 15:11:34', 0, 0),
(94, 111, 1, '2018-04-04 15:11:34', 0, 0),
(95, 114, 1, '2018-04-04 15:11:34', 0, 0),
(96, 115, 1, '2018-04-04 15:11:34', 0, 0),
(97, 116, 1, '2018-04-04 15:11:34', 0, 0),
(98, 117, 1, '2018-04-04 15:11:34', 0, 0),
(99, 118, 1, '2018-04-04 15:11:34', 0, 0),
(100, 119, 1, '2018-04-04 15:11:34', 0, 0),
(101, 120, 1, '2018-04-04 15:11:34', 0, 0),
(102, 121, 1, '2018-04-04 15:11:34', 0, 0),
(103, 122, 1, '2018-04-04 15:11:34', 0, 0),
(104, 123, 1, '2018-04-04 15:11:34', 0, 0),
(105, 124, 1, '2018-04-04 15:11:34', 0, 0),
(106, 125, 1, '2018-04-04 15:11:34', 0, 0),
(107, 126, 1, '2018-04-04 15:11:34', 0, 0),
(108, 127, 1, '2018-04-04 15:11:34', 0, 0),
(109, 128, 1, '2018-04-04 15:11:34', 0, 0),
(110, 129, 1, '2018-04-04 15:11:34', 0, 0),
(111, 130, 1, '2018-04-04 15:11:34', 0, 0),
(112, 131, 1, '2018-04-04 15:11:34', 0, 0),
(113, 132, 1, '2018-04-04 15:11:34', 0, 0),
(114, 133, 1, '2018-04-04 15:11:34', 0, 0),
(115, 134, 1, '2018-04-04 15:11:34', 0, 0),
(116, 135, 1, '2018-04-04 15:11:34', 0, 0),
(117, 136, 1, '2018-04-04 15:11:34', 0, 0),
(118, 149, 1, '2018-04-04 15:11:34', 0, 0),
(119, 150, 1, '2018-04-04 15:11:34', 0, 0),
(120, 151, 1, '2018-04-04 15:11:34', 0, 0),
(121, 152, 1, '2018-04-04 15:11:34', 0, 0),
(122, 153, 1, '2018-04-04 15:11:34', 0, 0),
(123, 154, 1, '2018-04-04 15:11:34', 0, 0),
(124, 155, 1, '2018-04-04 15:11:34', 0, 0),
(125, 156, 1, '2018-04-04 15:11:34', 0, 0),
(126, 157, 1, '2018-04-04 15:11:34', 0, 0),
(127, 158, 1, '2018-04-04 15:11:34', 0, 0),
(128, 159, 1, '2018-04-04 15:11:34', 0, 0),
(129, 160, 1, '2018-04-04 15:11:34', 0, 0),
(130, 45, 1, '2018-04-04 15:11:34', 0, 0),
(131, 98, 1, '2018-04-04 15:11:34', 0, 0),
(132, 143, 1, '2018-04-04 15:11:34', 0, 0),
(133, 35, 1, '2018-04-04 15:11:34', 0, 0),
(134, 36, 1, '2018-04-04 15:11:34', 0, 0),
(135, 37, 1, '2018-04-04 15:11:34', 0, 0),
(136, 38, 1, '2018-04-04 15:11:34', 0, 0),
(137, 39, 1, '2018-04-04 15:11:34', 0, 0),
(138, 40, 1, '2018-04-04 15:11:34', 0, 0),
(139, 41, 1, '2018-04-04 15:11:34', 0, 0),
(140, 42, 1, '2018-04-04 15:11:34', 0, 0),
(141, 43, 1, '2018-04-04 15:11:34', 0, 0),
(142, 44, 1, '2018-04-04 15:11:34', 0, 0),
(143, 138, 1, '2018-04-04 15:11:34', 0, 0),
(144, 139, 1, '2018-04-04 15:11:34', 0, 0),
(145, 140, 1, '2018-04-04 15:11:34', 0, 0),
(146, 141, 1, '2018-04-04 15:11:34', 0, 0),
(147, 142, 1, '2018-04-04 15:11:34', 0, 0),
(148, 144, 1, '2018-04-04 15:11:34', 0, 0),
(149, 145, 1, '2018-04-04 15:11:34', 0, 0),
(150, 146, 1, '2018-04-04 15:11:34', 0, 0),
(151, 147, 1, '2018-04-04 15:11:34', 0, 0);

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

--
-- Tabelstructuur voor tabel `alarm_user`
--

DROP TABLE IF EXISTS `alarm_user`;
CREATE TABLE `alarm_user` (
  `alarm_user_id` int(11) NOT NULL,
  `alarm` int(11) NOT NULL COMMENT 'link to table alarm',
  `user` int(11) NOT NULL COMMENT 'link to table user',
  `is_read` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'alarm is read by user?',
  `date_read` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'when the notification was read by user',
  `processed` int(11) NOT NULL DEFAULT '0' COMMENT 'All new alarms linked to users (processed = 1)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Gegevens worden geëxporteerd voor tabel `alarm_user`
--

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

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

--
-- Tabelstructuur voor tabel `alarm_user_device`
--

DROP TABLE IF EXISTS `alarm_user_device`;
CREATE TABLE `alarm_user_device` (
  `alarm_user_device_id` int(11) NOT NULL,
  `user_app` int(11) NOT NULL COMMENT 'Link to table user_app (with devices of user)',
  `alarm` int(11) NOT NULL COMMENT 'Link to alarm message',
  `is_pushed` int(11) NOT NULL DEFAULT '0' COMMENT 'Push message sent to user?',
  `new_or_change` int(11) NOT NULL DEFAULT '1' COMMENT 'New alarm (1) or value changed of existing alarm (2)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

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

--
-- Tabelstructuur voor tabel `user_app`
--

DROP TABLE IF EXISTS `user_app`;
CREATE TABLE `user_app` (
  `user_app_id` int(11) NOT NULL,
  `user` int(11) NOT NULL COMMENT 'link to table user',
  `token` varchar(128) COLLATE utf8_unicode_ci NOT NULL COMMENT 'login token',
  `device_token_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'mobile device token id (Firebase)',
  `platform` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Device platform (Android, iOS, browser)',
  `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `date_last_active` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last date this device connected to the server'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Indexen voor geëxporteerde tabellen
--

--
-- Indexen voor tabel `alarm`
--
ALTER TABLE `alarm`
  ADD PRIMARY KEY (`alarm_id`),
  ADD UNIQUE KEY `date_occurred` (`date_occurred`,`obm_id`,`spn`,`fmi`) USING BTREE,
  ADD KEY `alarm_status` (`alarm_status`),
  ADD KEY `spn` (`spn`),
  ADD KEY `fmi` (`fmi`),
  ADD KEY `fault_code` (`fault_code`),
  ADD KEY `lamp` (`lamp`),
  ADD KEY `date_received` (`date_received`),
  ADD KEY `date_sent` (`date_sent`),
  ADD KEY `obm_id` (`obm_id`),
  ADD KEY `pgn` (`pgn`),
  ADD KEY `processed` (`processed`),
  ADD KEY `assigned_to` (`assigned_to`),
  ADD KEY `ship` (`ship`,`engine`) USING BTREE,
  ADD KEY `ship_2` (`ship`,`date_occurred`,`engine`);

--
-- Indexen voor tabel `alarm_status`
--
ALTER TABLE `alarm_status`
  ADD PRIMARY KEY (`alarm_status_id`),
  ADD KEY `status_code` (`status_code`,`language`);

--
-- Indexen voor tabel `alarm_status_history`
--
ALTER TABLE `alarm_status_history`
  ADD PRIMARY KEY (`alarm_status_history_id`),
  ADD KEY `alarm` (`alarm`,`date_changed`) USING BTREE;

--
-- Indexen voor tabel `alarm_user`
--
ALTER TABLE `alarm_user`
  ADD PRIMARY KEY (`alarm_user_id`),
  ADD UNIQUE KEY `alarm_2` (`alarm`,`user`),
  ADD KEY `user` (`user`),
  ADD KEY `alarm` (`alarm`,`user`,`is_read`) USING BTREE,
  ADD KEY `is_pushed` (`processed`);

--
-- Indexen voor tabel `alarm_user_device`
--
ALTER TABLE `alarm_user_device`
  ADD PRIMARY KEY (`alarm_user_device_id`),
  ADD KEY `is_pushed` (`is_pushed`),
  ADD KEY `user_app` (`user_app`,`new_or_change`) USING BTREE;

--
-- Indexen voor tabel `user_app`
--
ALTER TABLE `user_app`
  ADD PRIMARY KEY (`user_app_id`),
  ADD UNIQUE KEY `user` (`user`,`device_token_id`) USING BTREE,
  ADD KEY `device_token_id` (`device_token_id`),
  ADD KEY `token` (`token`,`user`) USING BTREE,
  ADD KEY `date_created` (`date_created`),
  ADD KEY `date_last_active` (`date_last_active`);

--
-- AUTO_INCREMENT voor geëxporteerde tabellen
--

--
-- AUTO_INCREMENT voor een tabel `alarm`
--
ALTER TABLE `alarm`
  MODIFY `alarm_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;

--
-- AUTO_INCREMENT voor een tabel `alarm_status`
--
ALTER TABLE `alarm_status`
  MODIFY `alarm_status_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT voor een tabel `alarm_status_history`
--
ALTER TABLE `alarm_status_history`
  MODIFY `alarm_status_history_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=256;

--
-- AUTO_INCREMENT voor een tabel `alarm_user`
--
ALTER TABLE `alarm_user`
  MODIFY `alarm_user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2048;

--
-- AUTO_INCREMENT voor een tabel `alarm_user_device`
--
ALTER TABLE `alarm_user_device`
  MODIFY `alarm_user_device_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT voor een tabel `user_app`
--
ALTER TABLE `user_app`
  MODIFY `user_app_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
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 */;
