-- --------------------------------------------------------
-- Host:                         localhost
-- Server Version:               10.4.12-MariaDB-log - mariadb.org binary distribution
-- Server Betriebssystem:        Win64
-- HeidiSQL Version:             10.3.0.5771
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Exportiere Datenbank Struktur für test-order
DROP DATABASE IF EXISTS `test-order`;
CREATE DATABASE IF NOT EXISTS `test-order` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `test-order`;

-- Exportiere Struktur von Tabelle test-order.tab_a
DROP TABLE IF EXISTS `tab_a`;
CREATE TABLE IF NOT EXISTS `tab_a` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objekt_id_fk` int(10) unsigned NOT NULL,
  `pruefziel_id_fk` int(10) unsigned NOT NULL,
  `pruefung_id_fk` int(10) unsigned NOT NULL,
  `lastprf_id_fk` int(10) unsigned NOT NULL,
  `lastfri_id_fk` int(10) unsigned DEFAULT NULL,
  `lastmeld_id_fk` int(10) unsigned DEFAULT NULL,
  `position_lfdnr` int(10) unsigned NOT NULL,
  `position_status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `zeit_aktualisierung` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- Exportiere Daten aus Tabelle test-order.tab_a: ~115 rows (ungefähr)
/*!40000 ALTER TABLE `tab_a` DISABLE KEYS */;
REPLACE INTO `tab_a` (`id`, `objekt_id_fk`, `pruefziel_id_fk`, `pruefung_id_fk`, `lastprf_id_fk`, `lastfri_id_fk`, `lastmeld_id_fk`, `position_lfdnr`, `position_status`, `zeit_aktualisierung`) VALUES
	(1, 1, 1, 1, 4, 70, 25, 1, 'Abgeschlossen', '2020-01-01 23:33:41'),
	(2, 1, 1, 1, 4, 71, 25, 2, 'Abgeschlossen', '2020-01-01 23:33:42'),
	(3, 1, 1, 1, 4, 72, 25, 3, 'Abgeschlossen', '2020-01-01 23:33:43'),
	(4, 1, 1, 1, 4, 73, 25, 4, 'Abgeschlossen', '2020-01-01 23:33:44'),
	(5, 1, 1, 1, 3, 50, 14, 5, 'Abgeschlossen', '2019-12-30 12:50:44'),
	(6, 1, 1, 1, 4, 74, 25, 6, 'Abgeschlossen', '2020-01-01 23:33:46'),
	(7, 1, 1, 1, 2, 46, 8, 7, 'Abgeschlossen', '2019-12-22 12:02:14'),
	(8, 1, 1, 1, 2, 47, 8, 8, 'Abgeschlossen', '2019-12-22 12:02:17'),
	(9, 1, 1, 1, 1, 13, 1, 9, 'Abgeschlossen', '2019-12-18 23:33:58'),
	(10, 1, 1, 1, 4, 75, 25, 10, 'Abgeschlossen', '2020-01-01 23:33:47'),
	(11, 1, 1, 1, 4, 76, 25, 11, 'Abgeschlossen', '2020-01-01 23:33:48'),
	(12, 1, 1, 1, 4, 77, 25, 12, 'Abgeschlossen', '2020-01-01 23:33:50'),
	(13, 1, 1, 1, 4, 78, 25, 13, 'Abgeschlossen', '2020-01-01 23:33:51'),
	(14, 1, 1, 1, 3, 58, 14, 14, 'Abgeschlossen', '2019-12-30 12:50:46'),
	(15, 1, 1, 1, 4, 79, 25, 15, 'Abgeschlossen', '2020-01-01 23:33:51'),
	(16, 1, 1, 1, 1, 16, 1, 16, 'Abgeschlossen', '2019-12-18 23:33:59'),
	(17, 1, 1, 1, 1, 17, 2, 17, 'Abgeschlossen', '2019-12-18 22:42:36'),
	(18, 1, 1, 2, 2, 48, 8, 18, 'Abgeschlossen', '2019-12-22 12:02:18'),
	(19, 1, 1, 2, 2, 49, 9, 19, 'Abgeschlossen', '2019-12-22 11:50:17'),
	(20, 1, 2, 5, 11, 179, 64, 20, 'Abgeschlossen', '2020-01-19 12:11:21'),
	(22, 1, 2, 5, 16, 183, 65, 21, 'Abgeschlossen', '2020-01-20 10:48:06'),
	(23, 1, 2, 5, 7, 114, 46, 22, 'Abgeschlossen', '2020-01-09 15:32:17'),
	(24, 1, 2, 5, 6, 110, 36, 23, 'Abgeschlossen', '2020-01-06 14:38:50'),
	(25, 1, 2, 5, 11, 180, 64, 24, 'Abgeschlossen', '2020-01-19 12:11:27'),
	(26, 1, 2, 5, 6, 111, 36, 25, 'Abgeschlossen', '2020-01-06 14:38:51'),
	(27, 1, 2, 5, 7, 115, 40, 26, 'Abgeschlossen', '2020-01-09 03:16:00'),
	(28, 1, 2, 5, 5, 94, 27, 27, 'Abgeschlossen', '2020-01-05 18:49:32'),
	(29, 1, 2, 5, 5, 95, 27, 28, 'Abgeschlossen', '2020-01-05 18:49:33'),
	(30, 1, 2, 5, 16, 184, 65, 29, 'Abgeschlossen', '2020-01-20 10:48:07'),
	(31, 1, 2, 5, 11, 181, 64, 30, 'Abgeschlossen', '2020-01-19 12:11:28'),
	(32, 1, 2, 5, 7, 116, 43, 31, 'Abgeschlossen', '2020-01-09 14:30:08'),
	(33, 1, 2, 5, 16, 185, 65, 32, 'Abgeschlossen', '2020-01-20 10:48:09'),
	(34, 1, 2, 5, 16, 182, 65, 33, 'Abgeschlossen', '2020-01-20 10:48:10'),
	(35, 1, 2, 5, 11, 178, 64, 34, 'Abgeschlossen', '2020-01-19 12:11:30'),
	(36, 1, 2, 5, 5, 96, 27, 35, 'Abgeschlossen', '2020-01-05 18:49:33'),
	(37, 1, 2, 5, 5, 97, 28, 36, 'Abgeschlossen', '2020-01-05 19:19:45'),
	(38, 1, 2, 5, 5, 98, 27, 37, 'Abgeschlossen', '2020-01-05 18:49:34'),
	(39, 1, 2, 5, 5, 92, 28, 38, 'Abgeschlossen', '2020-01-05 19:19:46'),
	(47, 3, 7, 17, 21, 464, 90, 1, 'Abgeschlossen', '2020-01-29 16:18:25'),
	(48, 3, 7, 17, 21, 465, 90, 2, 'Abgeschlossen', '2020-01-29 16:18:25'),
	(49, 3, 7, 17, 21, 466, 90, 3, 'Abgeschlossen', '2020-01-29 16:18:26'),
	(50, 3, 7, 17, 21, 467, 90, 4, 'Abgeschlossen', '2020-01-29 16:18:27'),
	(51, 3, 7, 17, 21, 468, 90, 5, 'Abgeschlossen', '2020-01-29 16:18:28'),
	(52, 3, 7, 17, 21, 469, 90, 6, 'Abgeschlossen', '2020-01-29 16:18:28'),
	(53, 3, 7, 17, 21, 483, 90, 7, 'Abgeschlossen', '2020-01-29 16:18:29'),
	(54, 3, 7, 17, 21, 487, 90, 8, 'Abgeschlossen', '2020-01-29 16:18:30'),
	(55, 3, 7, 17, 21, 488, 90, 9, 'Abgeschlossen', '2020-01-29 16:18:31'),
	(56, 3, 7, 17, 21, 490, 90, 10, 'Abgeschlossen', '2020-01-29 16:18:32'),
	(57, 3, 7, 17, 21, 489, 90, 11, 'Abgeschlossen', '2020-01-29 16:18:33'),
	(58, 3, 7, 17, 21, 486, 90, 12, 'Abgeschlossen', '2020-01-29 16:18:34'),
	(59, 3, 7, 17, 21, 485, 90, 13, 'Abgeschlossen', '2020-01-29 16:18:35'),
	(60, 3, 7, 17, 21, 484, 90, 14, 'Abgeschlossen', '2020-01-29 16:18:35'),
	(61, 3, 7, 17, 21, 482, 90, 15, 'Abgeschlossen', '2020-01-29 16:18:37'),
	(62, 3, 7, 17, 21, 470, 90, 16, 'Abgeschlossen', '2020-01-29 16:18:39'),
	(63, 3, 7, 17, 21, 471, 90, 17, 'Abgeschlossen', '2020-01-29 16:18:40'),
	(64, 3, 7, 17, 21, 472, 90, 18, 'Abgeschlossen', '2020-01-29 16:18:40'),
	(65, 3, 7, 19, 21, 481, 90, 19, 'Abgeschlossen', '2020-01-29 16:18:41'),
	(66, 3, 7, 19, 21, 475, 90, 20, 'Abgeschlossen', '2020-01-29 16:18:42'),
	(67, 3, 7, 19, 21, 476, 90, 21, 'Abgeschlossen', '2020-01-29 16:18:42'),
	(68, 3, 7, 19, 21, 477, 90, 22, 'Abgeschlossen', '2020-01-29 16:18:43'),
	(69, 3, 7, 19, 21, 478, 90, 23, 'Abgeschlossen', '2020-01-29 16:18:43'),
	(70, 3, 7, 19, 21, 479, 90, 24, 'Abgeschlossen', '2020-01-29 16:18:44'),
	(71, 3, 7, 20, 21, 480, 90, 25, 'Abgeschlossen', '2020-01-29 16:18:45'),
	(72, 3, 7, 20, 21, 474, 90, 26, 'Abgeschlossen', '2020-01-29 16:18:45'),
	(73, 3, 7, 20, 21, 473, 90, 27, 'Abgeschlossen', '2020-01-29 16:18:46'),
	(74, 3, 7, 20, 20, 423, 77, 28, 'Abgeschlossen', '2020-01-28 14:01:24'),
	(75, 3, 7, 20, 20, 424, 77, 29, 'Abgeschlossen', '2020-01-29 13:18:42'),
	(76, 3, 7, 20, 20, 422, 77, 30, 'Abgeschlossen', '2020-01-28 14:01:25'),
	(77, 4, 8, 22, 22, 425, 83, 1, 'Bearbeitung', '2020-01-28 19:58:02'),
	(78, 4, 8, 22, 22, NULL, NULL, 2, 'Erfassung', '2020-01-28 20:41:53'),
	(79, 4, 8, 22, 22, 426, 84, 3, 'Bearbeitung', '2020-01-28 20:59:07'),
	(80, 7, 10, 23, 24, NULL, NULL, 1, 'Bearbeitung', '2020-01-28 23:41:04'),
	(81, 7, 10, 24, 24, NULL, NULL, 2, 'Erfassung', '2020-01-28 23:26:22'),
	(82, 8, 14, 25, 41, 587, 116, 1, 'Bearbeitung', '2020-02-10 19:22:49'),
	(83, 8, 14, 25, 41, 588, 114, 2, 'Bearbeitung', '2020-02-10 19:06:03'),
	(84, 8, 14, 25, 41, 589, 116, 3, 'Bearbeitung', '2020-02-10 19:22:49'),
	(85, 8, 14, 25, 32, 533, 97, 4, 'Abgeschlossen', '2020-02-05 19:21:05'),
	(86, 8, 14, 25, 41, 590, 116, 5, 'Bearbeitung', '2020-02-10 19:22:49'),
	(87, 8, 14, 25, 41, 591, 116, 6, 'Bearbeitung', '2020-02-10 19:22:49'),
	(88, 8, 14, 26, 41, 592, 114, 7, 'Bearbeitung', '2020-02-10 19:05:51'),
	(89, 8, 14, 26, 41, 593, 114, 8, 'Bearbeitung', '2020-02-10 19:06:03'),
	(90, 8, 14, 26, 41, 594, 116, 9, 'Bearbeitung', '2020-02-10 19:22:49'),
	(91, 8, 14, 26, 36, 580, 109, 10, 'Abgeschlossen', '2020-02-10 14:38:58'),
	(92, 8, 14, 26, 36, 579, 109, 11, 'Abgeschlossen', '2020-02-10 14:38:59'),
	(93, 8, 14, 26, 26, 521, 91, 12, 'Abgeschlossen', '2020-01-31 18:45:52'),
	(94, 8, 15, 28, 34, 534, 97, 13, 'Abgeschlossen', '2020-02-05 19:21:06'),
	(95, 8, 15, 28, 42, 595, 116, 14, 'Bearbeitung', '2020-02-10 19:22:20'),
	(96, 8, 15, 28, 42, 596, 114, 15, 'Bearbeitung', '2020-02-10 19:06:03'),
	(97, 8, 15, 28, 42, 597, 116, 16, 'Bearbeitung', '2020-02-10 19:22:49'),
	(98, 8, 15, 28, 42, 598, 116, 17, 'Bearbeitung', '2020-02-10 19:22:49'),
	(99, 8, 15, 28, 42, 599, 114, 18, 'Bearbeitung', '2020-02-10 19:06:03'),
	(100, 8, 16, 30, 39, 581, 107, 19, 'Abgeschlossen', '2020-02-10 11:28:33'),
	(101, 8, 16, 30, 40, 600, 116, 20, 'Bearbeitung', '2020-02-10 19:22:49'),
	(102, 8, 16, 30, 40, 601, 116, 21, 'Bearbeitung', '2020-02-10 19:22:49'),
	(103, 8, 16, 30, 40, 586, NULL, 22, 'Bearbeitung', '2020-02-10 19:01:06'),
	(104, 8, 16, 30, 33, 535, 97, 23, 'Abgeschlossen', '2020-02-05 19:21:06'),
	(105, 8, 16, 30, 40, 583, 113, 24, 'Abgeschlossen', '2020-02-10 18:48:01'),
	(106, 8, 14, 27, 27, 522, 92, 25, 'Abgeschlossen', '2020-02-03 17:54:25'),
	(107, 8, 14, 27, 27, 523, 92, 26, 'Abgeschlossen', '2020-02-03 17:54:25'),
	(108, 8, 14, 27, 27, 524, 92, 27, 'Abgeschlossen', '2020-02-03 17:54:26'),
	(109, 8, 14, 27, 27, 525, 91, 28, 'Abgeschlossen', '2020-01-31 18:45:53'),
	(110, 8, 14, 27, 27, 526, 91, 29, 'Abgeschlossen', '2020-01-31 18:45:53'),
	(111, 8, 14, 27, 27, 518, 91, 30, 'Abgeschlossen', '2020-01-31 18:45:54'),
	(112, 8, 15, 29, 42, 602, 114, 31, 'Bearbeitung', '2020-02-10 19:06:03'),
	(113, 8, 15, 29, 34, 536, 97, 32, 'Abgeschlossen', '2020-02-05 19:21:07'),
	(114, 8, 15, 29, 42, 584, 113, 33, 'Abgeschlossen', '2020-02-10 18:48:02'),
	(115, 8, 16, 31, 40, 603, 116, 34, 'Bearbeitung', '2020-02-10 19:22:49'),
	(116, 8, 16, 31, 33, 537, 97, 35, 'Abgeschlossen', '2020-02-05 19:21:07'),
	(117, 8, 16, 31, 40, 604, 114, 36, 'Bearbeitung', '2020-02-10 19:06:03'),
	(121, 8, 14, 25, 36, 582, 107, 37, 'Abgeschlossen', '2020-02-10 11:28:33'),
	(122, 8, 14, 25, 41, 585, 113, 38, 'Abgeschlossen', '2020-02-10 18:48:03'),
	(123, 8, 14, 25, 41, 605, 116, 39, 'Bearbeitung', '2020-02-10 19:22:49'),
	(124, 8, 14, 25, 25, 531, 92, 40, 'Abgeschlossen', '2020-02-03 17:54:26'),
	(125, 8, 14, 25, 25, 532, 92, 41, 'Abgeschlossen', '2020-02-03 17:54:27'),
	(126, 8, 14, 25, 25, 530, 92, 42, 'Abgeschlossen', '2020-02-03 17:54:27');
/*!40000 ALTER TABLE `tab_a` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle test-order.tab_b
DROP TABLE IF EXISTS `tab_b`;
CREATE TABLE IF NOT EXISTS `tab_b` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objekt_id_fk` int(10) unsigned NOT NULL,
  `pruefziel_id_fk` int(10) unsigned NOT NULL,
  `pruefung_id_fk` int(10) unsigned NOT NULL,
  `position_id_fk` int(10) unsigned NOT NULL,
  `zeit_aktualisierung` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=462 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- Exportiere Daten aus Tabelle test-order.tab_b: ~327 rows (ungefähr)
/*!40000 ALTER TABLE `tab_b` DISABLE KEYS */;
REPLACE INTO `tab_b` (`id`, `objekt_id_fk`, `pruefziel_id_fk`, `pruefung_id_fk`, `position_id_fk`, `zeit_aktualisierung`) VALUES
	(1, 1, 1, 1, 1, '2019-12-29 14:47:59'),
	(2, 1, 1, 1, 2, '2019-12-29 14:47:59'),
	(3, 1, 1, 1, 3, '2019-12-29 14:47:59'),
	(4, 1, 1, 1, 4, '2019-12-29 14:47:59'),
	(5, 1, 1, 1, 5, '2019-12-29 14:47:59'),
	(6, 1, 1, 1, 6, '2019-12-29 14:47:59'),
	(7, 1, 1, 1, 7, '2019-12-29 14:47:59'),
	(8, 1, 1, 1, 8, '2019-12-29 14:47:59'),
	(9, 1, 1, 1, 9, '2019-12-29 14:48:18'),
	(10, 1, 1, 1, 10, '2019-12-29 14:47:59'),
	(11, 1, 1, 1, 11, '2019-12-29 14:47:59'),
	(12, 1, 1, 1, 12, '2019-12-29 14:47:59'),
	(13, 1, 1, 1, 13, '2019-12-29 14:47:59'),
	(14, 1, 1, 1, 14, '2019-12-29 14:47:59'),
	(15, 1, 1, 1, 15, '2019-12-29 14:47:59'),
	(16, 1, 1, 1, 16, '2019-12-29 14:48:18'),
	(17, 1, 1, 1, 17, '2019-12-29 14:48:18'),
	(18, 1, 1, 2, 6, '2019-12-29 14:48:18'),
	(19, 1, 1, 2, 1, '2019-12-29 14:48:18'),
	(20, 1, 1, 2, 2, '2019-12-29 14:48:18'),
	(21, 1, 1, 2, 3, '2019-12-29 14:48:18'),
	(22, 1, 1, 2, 4, '2019-12-29 14:48:18'),
	(23, 1, 1, 2, 10, '2019-12-29 14:48:18'),
	(24, 1, 1, 2, 11, '2019-12-29 14:48:18'),
	(25, 1, 1, 2, 12, '2019-12-29 14:48:18'),
	(26, 1, 1, 2, 13, '2019-12-29 14:48:18'),
	(27, 1, 1, 2, 14, '2019-12-29 14:48:18'),
	(28, 1, 1, 2, 15, '2019-12-29 14:48:18'),
	(29, 1, 1, 2, 5, '2019-12-29 14:48:18'),
	(30, 1, 1, 2, 7, '2019-12-29 14:48:18'),
	(31, 1, 1, 2, 8, '2019-12-29 14:48:18'),
	(32, 1, 1, 2, 18, '2019-12-29 14:48:18'),
	(33, 1, 1, 2, 19, '2019-12-29 14:48:18'),
	(37, 1, 1, 3, 5, '2019-12-30 12:50:23'),
	(38, 1, 1, 3, 14, '2019-12-30 12:50:33'),
	(39, 1, 1, 3, 12, '2019-12-30 22:45:42'),
	(40, 1, 1, 3, 2, '2019-12-30 22:45:42'),
	(41, 1, 1, 3, 1, '2019-12-30 22:45:42'),
	(42, 1, 1, 3, 3, '2019-12-30 22:45:42'),
	(43, 1, 1, 3, 4, '2019-12-30 22:45:42'),
	(44, 1, 1, 3, 6, '2019-12-30 22:45:42'),
	(45, 1, 1, 3, 10, '2019-12-30 22:45:42'),
	(46, 1, 1, 3, 11, '2019-12-30 22:45:42'),
	(47, 1, 1, 3, 13, '2019-12-30 22:45:42'),
	(48, 1, 1, 3, 15, '2019-12-30 22:45:29'),
	(49, 1, 1, 4, 1, '2020-01-01 23:20:52'),
	(50, 1, 1, 4, 2, '2020-01-01 23:21:09'),
	(51, 1, 1, 4, 3, '2020-01-01 23:21:09'),
	(52, 1, 1, 4, 4, '2020-01-01 23:21:09'),
	(53, 1, 1, 4, 6, '2020-01-01 23:21:09'),
	(54, 1, 1, 4, 10, '2020-01-01 23:21:09'),
	(55, 1, 1, 4, 11, '2020-01-01 23:21:09'),
	(56, 1, 1, 4, 12, '2020-01-01 23:21:09'),
	(57, 1, 1, 4, 13, '2020-01-01 23:21:09'),
	(58, 1, 1, 4, 15, '2020-01-01 23:21:09'),
	(59, 1, 2, 5, 20, '2020-01-03 19:36:15'),
	(61, 1, 2, 5, 22, '2020-01-05 14:38:41'),
	(62, 1, 2, 5, 23, '2020-01-05 14:38:57'),
	(63, 1, 2, 5, 24, '2020-01-05 14:37:13'),
	(64, 1, 2, 5, 25, '2020-01-05 14:39:36'),
	(65, 1, 2, 5, 26, '2020-01-05 14:40:25'),
	(66, 1, 2, 5, 27, '2020-01-05 14:41:11'),
	(67, 1, 2, 5, 28, '2020-01-05 14:43:19'),
	(68, 1, 2, 5, 29, '2020-01-05 14:46:36'),
	(69, 1, 2, 5, 30, '2020-01-05 14:48:24'),
	(70, 1, 2, 5, 31, '2020-01-05 14:49:49'),
	(71, 1, 2, 5, 32, '2020-01-05 14:50:32'),
	(72, 1, 2, 5, 33, '2020-01-05 14:51:24'),
	(73, 1, 2, 5, 34, '2020-01-05 14:51:58'),
	(74, 1, 2, 5, 35, '2020-01-05 14:52:25'),
	(75, 1, 2, 5, 36, '2020-01-05 14:54:05'),
	(76, 1, 2, 5, 37, '2020-01-05 14:56:09'),
	(77, 1, 2, 5, 38, '2020-01-05 14:56:49'),
	(78, 1, 2, 5, 39, '2020-01-05 14:57:31'),
	(79, 1, 2, 6, 27, '2020-01-06 11:38:27'),
	(80, 1, 2, 6, 25, '2020-01-06 13:57:21'),
	(81, 1, 2, 6, 24, '2020-01-06 14:38:38'),
	(82, 1, 2, 6, 26, '2020-01-06 14:38:26'),
	(83, 1, 2, 6, 20, '2020-01-06 13:56:27'),
	(84, 1, 2, 6, 22, '2020-01-06 13:57:21'),
	(85, 1, 2, 6, 23, '2020-01-06 13:57:21'),
	(86, 1, 2, 6, 30, '2020-01-06 13:57:21'),
	(87, 1, 2, 6, 31, '2020-01-06 13:57:21'),
	(88, 1, 2, 6, 32, '2020-01-06 13:57:21'),
	(89, 1, 2, 6, 33, '2020-01-06 13:57:21'),
	(90, 1, 2, 6, 34, '2020-01-06 13:57:21'),
	(91, 1, 2, 6, 35, '2020-01-06 13:57:21'),
	(92, 1, 3, 7, 27, '2020-01-07 14:15:18'),
	(93, 1, 3, 7, 25, '2020-01-09 01:00:31'),
	(94, 1, 3, 7, 35, '2020-01-09 01:01:31'),
	(95, 1, 3, 7, 32, '2020-01-09 14:29:42'),
	(96, 1, 3, 7, 23, '2020-01-09 15:32:09'),
	(97, 1, 3, 7, 20, '2020-01-09 01:01:31'),
	(98, 1, 3, 7, 22, '2020-01-09 01:01:31'),
	(99, 1, 3, 7, 30, '2020-01-09 01:01:31'),
	(100, 1, 3, 7, 31, '2020-01-09 01:01:31'),
	(101, 1, 3, 7, 33, '2020-01-09 01:01:31'),
	(102, 1, 3, 7, 34, '2020-01-09 01:01:31'),
	(125, 1, 3, 11, 35, '2020-01-19 12:00:50'),
	(126, 1, 3, 11, 34, '2020-01-16 13:23:59'),
	(127, 1, 3, 11, 20, '2020-01-19 12:01:13'),
	(128, 1, 3, 11, 25, '2020-01-19 12:01:13'),
	(129, 1, 3, 11, 31, '2020-01-19 12:01:13'),
	(130, 1, 3, 11, 33, '2020-01-16 13:24:10'),
	(131, 1, 3, 11, 30, '2020-01-16 13:24:10'),
	(132, 1, 3, 11, 22, '2020-01-16 13:24:10'),
	(133, 1, 3, 16, 34, '2020-01-20 10:47:37'),
	(134, 1, 3, 16, 22, '2020-01-20 10:47:46'),
	(135, 1, 3, 16, 30, '2020-01-20 10:47:46'),
	(136, 1, 3, 16, 33, '2020-01-20 10:47:46'),
	(137, 3, 7, 17, 47, '2020-01-24 13:43:09'),
	(138, 3, 7, 17, 48, '2020-01-24 13:46:09'),
	(139, 3, 7, 17, 49, '2020-01-24 13:46:27'),
	(140, 3, 7, 17, 50, '2020-01-24 13:46:58'),
	(141, 3, 7, 17, 51, '2020-01-24 13:51:17'),
	(142, 3, 7, 17, 52, '2020-01-24 14:28:49'),
	(143, 3, 7, 17, 53, '2020-01-24 15:11:18'),
	(144, 3, 7, 17, 54, '2020-01-24 15:13:10'),
	(145, 3, 7, 17, 55, '2020-01-24 15:15:00'),
	(146, 3, 7, 17, 56, '2020-01-24 15:17:18'),
	(147, 3, 7, 17, 57, '2020-01-24 15:19:36'),
	(148, 3, 7, 17, 58, '2020-01-24 15:50:25'),
	(149, 3, 7, 17, 59, '2020-01-24 15:23:51'),
	(150, 3, 7, 17, 60, '2020-01-24 15:51:40'),
	(151, 3, 7, 17, 61, '2020-01-24 15:31:24'),
	(152, 3, 7, 17, 62, '2020-01-24 15:33:24'),
	(153, 3, 7, 17, 63, '2020-01-24 15:35:57'),
	(154, 3, 7, 17, 64, '2020-01-24 15:37:42'),
	(155, 3, 7, 18, 47, '2020-01-27 20:45:50'),
	(156, 3, 7, 18, 48, '2020-01-27 20:46:45'),
	(157, 3, 7, 18, 49, '2020-01-27 20:46:45'),
	(158, 3, 7, 18, 50, '2020-01-27 20:46:45'),
	(159, 3, 7, 18, 51, '2020-01-27 20:46:45'),
	(160, 3, 7, 18, 52, '2020-01-27 20:46:45'),
	(161, 3, 7, 18, 53, '2020-01-27 20:46:45'),
	(162, 3, 7, 18, 54, '2020-01-27 20:46:45'),
	(163, 3, 7, 18, 55, '2020-01-27 20:46:45'),
	(164, 3, 7, 18, 56, '2020-01-27 20:46:45'),
	(165, 3, 7, 18, 57, '2020-01-27 20:46:45'),
	(166, 3, 7, 18, 58, '2020-01-27 20:46:45'),
	(167, 3, 7, 18, 59, '2020-01-27 20:46:45'),
	(168, 3, 7, 18, 60, '2020-01-27 20:46:45'),
	(169, 3, 7, 18, 61, '2020-01-27 20:46:45'),
	(170, 3, 7, 18, 62, '2020-01-27 20:46:45'),
	(171, 3, 7, 18, 63, '2020-01-27 20:46:45'),
	(172, 3, 7, 18, 64, '2020-01-27 20:46:45'),
	(173, 3, 7, 19, 65, '2020-01-27 18:47:51'),
	(174, 3, 7, 19, 66, '2020-01-27 18:47:20'),
	(175, 3, 7, 19, 67, '2020-01-27 18:48:11'),
	(176, 3, 7, 19, 68, '2020-01-27 18:48:58'),
	(177, 3, 7, 19, 69, '2020-01-27 18:49:19'),
	(178, 3, 7, 19, 70, '2020-01-27 18:49:49'),
	(179, 3, 7, 20, 71, '2020-01-27 22:14:58'),
	(180, 3, 7, 20, 72, '2020-01-27 22:15:31'),
	(181, 3, 7, 20, 73, '2020-01-27 22:16:03'),
	(182, 3, 7, 20, 47, '2020-01-28 11:50:07'),
	(183, 3, 7, 20, 48, '2020-01-28 11:50:07'),
	(184, 3, 7, 20, 49, '2020-01-28 11:50:07'),
	(185, 3, 7, 20, 50, '2020-01-28 11:50:07'),
	(186, 3, 7, 20, 51, '2020-01-28 11:50:07'),
	(187, 3, 7, 20, 52, '2020-01-28 11:50:07'),
	(188, 3, 7, 20, 53, '2020-01-28 11:50:07'),
	(189, 3, 7, 20, 54, '2020-01-28 11:50:07'),
	(190, 3, 7, 20, 55, '2020-01-28 11:50:07'),
	(191, 3, 7, 20, 56, '2020-01-28 11:50:08'),
	(192, 3, 7, 20, 57, '2020-01-28 11:50:08'),
	(193, 3, 7, 20, 58, '2020-01-28 11:50:08'),
	(194, 3, 7, 20, 59, '2020-01-28 11:50:08'),
	(195, 3, 7, 20, 60, '2020-01-28 11:50:08'),
	(196, 3, 7, 20, 61, '2020-01-28 11:50:08'),
	(197, 3, 7, 20, 62, '2020-01-28 11:50:08'),
	(198, 3, 7, 20, 63, '2020-01-28 11:50:08'),
	(199, 3, 7, 20, 64, '2020-01-28 11:49:55'),
	(200, 3, 7, 20, 65, '2020-01-28 11:48:16'),
	(201, 3, 7, 20, 66, '2020-01-28 11:48:16'),
	(202, 3, 7, 20, 67, '2020-01-28 11:48:16'),
	(203, 3, 7, 20, 68, '2020-01-28 11:48:16'),
	(204, 3, 7, 20, 69, '2020-01-28 11:48:16'),
	(205, 3, 7, 20, 70, '2020-01-28 11:47:43'),
	(206, 3, 7, 20, 74, '2020-01-28 11:58:06'),
	(207, 3, 7, 20, 75, '2020-01-28 12:00:19'),
	(208, 3, 7, 20, 76, '2020-01-28 12:03:25'),
	(211, 4, 8, 22, 77, '2020-01-28 20:33:50'),
	(215, 4, 8, 22, 78, '2020-01-28 20:41:53'),
	(216, 4, 8, 22, 79, '2020-01-28 20:56:22'),
	(251, 7, 10, 23, 80, '2020-01-28 23:01:30'),
	(252, 7, 10, 24, 81, '2020-01-28 23:26:22'),
	(253, 7, 10, 24, 80, '2020-01-28 23:41:04'),
	(292, 3, 7, 21, 47, '2020-01-29 16:17:46'),
	(293, 3, 7, 21, 48, '2020-01-29 16:17:46'),
	(294, 3, 7, 21, 49, '2020-01-29 16:17:46'),
	(295, 3, 7, 21, 50, '2020-01-29 16:17:46'),
	(296, 3, 7, 21, 51, '2020-01-29 16:17:46'),
	(297, 3, 7, 21, 52, '2020-01-29 16:17:46'),
	(298, 3, 7, 21, 53, '2020-01-29 16:17:46'),
	(299, 3, 7, 21, 54, '2020-01-29 16:17:46'),
	(300, 3, 7, 21, 55, '2020-01-29 16:17:46'),
	(301, 3, 7, 21, 56, '2020-01-29 16:17:46'),
	(302, 3, 7, 21, 57, '2020-01-29 16:17:46'),
	(303, 3, 7, 21, 58, '2020-01-29 16:17:46'),
	(304, 3, 7, 21, 59, '2020-01-29 16:17:46'),
	(305, 3, 7, 21, 60, '2020-01-29 16:17:46'),
	(306, 3, 7, 21, 61, '2020-01-29 16:17:46'),
	(307, 3, 7, 21, 62, '2020-01-29 16:17:46'),
	(308, 3, 7, 21, 63, '2020-01-29 16:17:12'),
	(309, 3, 7, 21, 64, '2020-01-29 16:17:46'),
	(310, 3, 7, 21, 65, '2020-01-29 16:17:46'),
	(311, 3, 7, 21, 66, '2020-01-29 16:17:46'),
	(312, 3, 7, 21, 67, '2020-01-29 16:17:46'),
	(313, 3, 7, 21, 68, '2020-01-29 16:17:46'),
	(314, 3, 7, 21, 69, '2020-01-29 16:17:46'),
	(315, 3, 7, 21, 70, '2020-01-29 16:17:46'),
	(316, 3, 7, 21, 71, '2020-01-29 16:17:46'),
	(317, 3, 7, 21, 72, '2020-01-29 16:17:47'),
	(318, 3, 7, 21, 73, '2020-01-29 16:17:47'),
	(319, 8, 14, 25, 82, '2020-01-31 17:26:50'),
	(320, 8, 14, 25, 83, '2020-01-31 17:27:35'),
	(321, 8, 14, 25, 84, '2020-01-31 17:27:51'),
	(322, 8, 14, 25, 85, '2020-01-31 17:28:38'),
	(323, 8, 14, 25, 86, '2020-01-31 17:28:55'),
	(324, 8, 14, 25, 87, '2020-01-31 17:29:12'),
	(325, 8, 14, 26, 88, '2020-01-31 17:30:31'),
	(326, 8, 14, 26, 89, '2020-01-31 17:30:52'),
	(327, 8, 14, 26, 90, '2020-01-31 17:31:15'),
	(328, 8, 14, 26, 91, '2020-01-31 17:32:20'),
	(329, 8, 14, 26, 92, '2020-01-31 17:33:04'),
	(330, 8, 14, 26, 93, '2020-01-31 17:33:44'),
	(331, 8, 15, 28, 94, '2020-01-31 17:48:48'),
	(332, 8, 15, 28, 95, '2020-01-31 17:49:11'),
	(333, 8, 15, 28, 96, '2020-01-31 17:49:41'),
	(334, 8, 15, 28, 97, '2020-01-31 17:50:48'),
	(335, 8, 15, 28, 98, '2020-01-31 17:51:06'),
	(336, 8, 15, 28, 99, '2020-01-31 17:51:24'),
	(337, 8, 16, 30, 100, '2020-01-31 17:56:30'),
	(338, 8, 16, 30, 101, '2020-01-31 17:56:59'),
	(339, 8, 16, 30, 102, '2020-01-31 17:57:20'),
	(340, 8, 16, 30, 103, '2020-01-31 17:59:24'),
	(341, 8, 16, 30, 104, '2020-01-31 17:59:42'),
	(342, 8, 16, 30, 105, '2020-01-31 18:03:08'),
	(343, 8, 14, 27, 106, '2020-01-31 18:05:23'),
	(344, 8, 14, 27, 107, '2020-01-31 18:05:41'),
	(345, 8, 14, 27, 108, '2020-01-31 18:05:57'),
	(346, 8, 14, 27, 109, '2020-01-31 18:07:05'),
	(347, 8, 14, 27, 110, '2020-01-31 18:07:25'),
	(348, 8, 14, 27, 111, '2020-01-31 18:07:41'),
	(349, 8, 15, 29, 112, '2020-01-31 18:10:32'),
	(350, 8, 15, 29, 113, '2020-01-31 18:10:53'),
	(351, 8, 15, 29, 114, '2020-01-31 18:11:11'),
	(352, 8, 16, 31, 115, '2020-01-31 18:12:14'),
	(353, 8, 16, 31, 116, '2020-01-31 18:12:33'),
	(354, 8, 16, 31, 117, '2020-01-31 18:12:49'),
	(358, 8, 14, 25, 121, '2020-01-31 20:47:17'),
	(359, 8, 14, 25, 122, '2020-01-31 20:47:31'),
	(360, 8, 14, 25, 123, '2020-01-31 20:47:53'),
	(361, 8, 14, 25, 124, '2020-01-31 20:49:48'),
	(362, 8, 14, 25, 125, '2020-01-31 20:50:03'),
	(363, 8, 14, 25, 126, '2020-01-31 20:50:16'),
	(364, 8, 14, 32, 83, '2020-02-05 21:49:15'),
	(365, 8, 16, 33, 105, '2020-02-05 21:52:36'),
	(374, 8, 16, 33, 104, '2020-02-05 19:20:51'),
	(375, 8, 16, 33, 103, '2020-02-05 21:52:52'),
	(376, 8, 14, 32, 122, '2020-02-05 21:49:15'),
	(377, 8, 15, 34, 97, '2020-02-05 21:49:15'),
	(378, 8, 15, 34, 98, '2020-02-05 21:49:15'),
	(379, 8, 15, 34, 99, '2020-02-05 21:49:15'),
	(380, 8, 16, 33, 100, '2020-02-05 21:49:15'),
	(381, 8, 16, 33, 101, '2020-02-05 21:49:15'),
	(382, 8, 16, 33, 102, '2020-02-05 21:49:15'),
	(385, 8, 15, 34, 114, '2020-02-05 21:49:15'),
	(386, 8, 16, 33, 115, '2020-02-05 21:49:15'),
	(387, 8, 14, 32, 85, '2020-02-05 18:49:16'),
	(388, 8, 15, 34, 94, '2020-02-05 19:20:51'),
	(389, 8, 15, 34, 113, '2020-02-05 19:20:51'),
	(390, 8, 16, 33, 116, '2020-02-05 19:20:51'),
	(391, 8, 15, 34, 95, '2020-02-05 21:49:15'),
	(393, 8, 14, 32, 82, '2020-02-05 21:49:15'),
	(394, 8, 14, 32, 84, '2020-02-05 21:49:15'),
	(396, 8, 14, 32, 87, '2020-02-05 19:56:12'),
	(399, 8, 14, 32, 90, '2020-02-05 21:49:15'),
	(400, 8, 14, 32, 121, '2020-02-05 21:49:15'),
	(401, 8, 14, 32, 123, '2020-02-05 21:49:15'),
	(402, 8, 14, 32, 88, '2020-02-05 21:49:15'),
	(403, 8, 14, 32, 86, '2020-02-05 21:49:15'),
	(416, 8, 14, 36, 89, '2020-02-10 14:43:45'),
	(417, 8, 15, 38, 96, '2020-02-10 14:43:45'),
	(418, 8, 15, 38, 112, '2020-02-10 14:43:45'),
	(419, 8, 16, 39, 117, '2020-02-10 14:43:34'),
	(420, 8, 16, 39, 101, '2020-02-10 14:41:26'),
	(421, 8, 14, 36, 87, '2020-02-10 14:41:26'),
	(422, 8, 16, 39, 103, '2020-02-10 14:45:28'),
	(423, 8, 16, 39, 100, '2020-02-10 11:28:13'),
	(424, 8, 16, 39, 115, '2020-02-10 14:41:26'),
	(425, 8, 15, 38, 95, '2020-02-10 14:41:26'),
	(426, 8, 16, 39, 102, '2020-02-10 14:41:26'),
	(427, 8, 15, 38, 98, '2020-02-10 14:41:26'),
	(428, 8, 14, 36, 82, '2020-02-10 14:41:25'),
	(429, 8, 14, 36, 90, '2020-02-10 14:41:26'),
	(430, 8, 14, 36, 121, '2020-02-10 11:28:03'),
	(432, 8, 14, 36, 84, '2020-02-10 14:41:25'),
	(433, 8, 14, 36, 123, '2020-02-10 14:40:49'),
	(434, 8, 14, 36, 86, '2020-02-10 14:41:26'),
	(435, 8, 15, 38, 97, '2020-02-10 14:41:26'),
	(436, 8, 14, 36, 91, '2020-02-05 23:17:40'),
	(437, 8, 14, 36, 92, '2020-02-05 23:18:02'),
	(439, 8, 14, 41, 82, '2020-02-10 19:22:49'),
	(440, 8, 14, 41, 122, '2020-02-10 18:47:49'),
	(441, 8, 16, 40, 105, '2020-02-10 18:47:39'),
	(442, 8, 15, 42, 114, '2020-02-10 18:47:49'),
	(443, 8, 14, 41, 123, '2020-02-10 19:22:49'),
	(444, 8, 16, 40, 117, '2020-02-10 19:06:03'),
	(445, 8, 16, 40, 115, '2020-02-10 19:22:49'),
	(446, 8, 15, 42, 112, '2020-02-10 19:06:03'),
	(447, 8, 16, 40, 103, '2020-02-10 18:31:30'),
	(448, 8, 16, 40, 102, '2020-02-10 19:22:49'),
	(449, 8, 16, 40, 101, '2020-02-10 19:22:49'),
	(450, 8, 15, 42, 99, '2020-02-10 19:06:03'),
	(451, 8, 15, 42, 98, '2020-02-10 19:22:49'),
	(452, 8, 15, 42, 97, '2020-02-10 19:22:49'),
	(453, 8, 15, 42, 96, '2020-02-10 19:06:03'),
	(454, 8, 15, 42, 95, '2020-02-10 19:22:20'),
	(455, 8, 14, 41, 90, '2020-02-10 19:22:49'),
	(456, 8, 14, 41, 89, '2020-02-10 19:06:03'),
	(457, 8, 14, 41, 88, '2020-02-10 19:05:51'),
	(458, 8, 14, 41, 87, '2020-02-10 19:22:49'),
	(459, 8, 14, 41, 86, '2020-02-10 19:22:49'),
	(460, 8, 14, 41, 84, '2020-02-10 19:22:49'),
	(461, 8, 14, 41, 83, '2020-02-10 19:06:03');
/*!40000 ALTER TABLE `tab_b` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle test-order.tab_c
DROP TABLE IF EXISTS `tab_c`;
CREATE TABLE IF NOT EXISTS `tab_c` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objekt_id_fk` int(10) unsigned NOT NULL,
  `pruefziel_status` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `zeit_aktualisierung` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- Exportiere Daten aus Tabelle test-order.tab_c: ~10 rows (ungefähr)
/*!40000 ALTER TABLE `tab_c` DISABLE KEYS */;
REPLACE INTO `tab_c` (`id`, `objekt_id_fk`, `pruefziel_status`, `zeit_aktualisierung`) VALUES
	(1, 1, 'Abgeschlossen', '2020-01-29 16:23:49'),
	(2, 1, 'Abgeschlossen', '2020-01-06 18:48:38'),
	(3, 1, 'Abgeschlossen', '2020-01-29 16:23:49'),
	(7, 3, 'Abgeschlossen', '2020-01-29 16:22:38'),
	(8, 4, 'Bearbeitung', '2020-01-28 20:25:40'),
	(9, 7, 'Erfassung', '2020-01-28 22:50:34'),
	(10, 7, 'Bearbeitung', '2020-01-28 22:59:02'),
	(14, 8, 'Bearbeitung', '2020-01-31 17:06:46'),
	(15, 8, 'Bearbeitung', '2020-01-31 17:08:13'),
	(16, 8, 'Bearbeitung', '2020-01-31 17:09:11');
/*!40000 ALTER TABLE `tab_c` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle test-order.tab_d
DROP TABLE IF EXISTS `tab_d`;
CREATE TABLE IF NOT EXISTS `tab_d` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objekt_id_fk` int(10) unsigned NOT NULL DEFAULT 0,
  `pruefziel_id_fk` int(10) unsigned NOT NULL DEFAULT 0,
  `pruefziel_raum_relstr` varchar(8000) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zeit_aktualisierung` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- Exportiere Daten aus Tabelle test-order.tab_d: ~0 rows (ungefähr)
/*!40000 ALTER TABLE `tab_d` DISABLE KEYS */;
REPLACE INTO `tab_d` (`id`, `objekt_id_fk`, `pruefziel_id_fk`, `pruefziel_raum_relstr`, `zeit_aktualisierung`) VALUES
	(1, 3, 3, 'sometext', '2020-02-11 13:31:41');
/*!40000 ALTER TABLE `tab_d` ENABLE KEYS */;

-- Exportiere Struktur von Tabelle test-order.tab_e
DROP TABLE IF EXISTS `tab_e`;
CREATE TABLE IF NOT EXISTS `tab_e` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `objekt_id_fk` int(10) unsigned NOT NULL,
  `pruefziel_id_fk` int(10) unsigned NOT NULL,
  `pruefung_id_fk` int(10) unsigned NOT NULL,
  `position_id_fk` int(10) unsigned NOT NULL,
  `frist_art` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `frist_datum` date NOT NULL,
  `zeit_aktualisierung` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=606 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;

-- Exportiere Daten aus Tabelle test-order.tab_e: ~324 rows (ungefähr)
/*!40000 ALTER TABLE `tab_e` DISABLE KEYS */;
REPLACE INTO `tab_e` (`id`, `objekt_id_fk`, `pruefziel_id_fk`, `pruefung_id_fk`, `position_id_fk`, `frist_art`, `frist_datum`, `zeit_aktualisierung`) VALUES
	(1, 1, 1, 1, 1, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(2, 1, 1, 1, 2, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(3, 1, 1, 1, 3, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(4, 1, 1, 1, 4, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(5, 1, 1, 1, 5, 'Frist', '2019-01-16', '2019-12-20 16:05:52'),
	(6, 1, 1, 1, 6, 'Frist', '2019-01-16', '2019-12-20 14:35:02'),
	(7, 1, 1, 1, 10, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(8, 1, 1, 1, 11, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(9, 1, 1, 1, 12, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(10, 1, 1, 1, 13, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(11, 1, 1, 1, 14, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(12, 1, 1, 1, 15, 'Frist', '2019-01-16', '2019-12-20 16:03:59'),
	(13, 1, 1, 1, 9, 'Berichtsfrist intern', '2019-01-11', '2019-12-19 21:53:23'),
	(14, 1, 1, 1, 7, 'Berichtsfrist intern', '2019-01-11', '2019-12-19 21:55:41'),
	(15, 1, 1, 1, 8, 'Berichtsfrist intern', '2019-01-11', '2019-12-19 21:55:43'),
	(16, 1, 1, 1, 16, 'Berichtsfrist intern', '2019-01-11', '2019-12-19 21:53:25'),
	(17, 1, 1, 1, 17, 'Berichtsfrist intern', '2019-01-11', '2019-12-19 21:53:25'),
	(31, 1, 1, 2, 1, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(32, 1, 1, 2, 15, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(36, 1, 1, 2, 2, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:41:54'),
	(37, 1, 1, 2, 3, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(38, 1, 1, 2, 4, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(39, 1, 1, 2, 5, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:09:31'),
	(40, 1, 1, 2, 6, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(41, 1, 1, 2, 10, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(42, 1, 1, 2, 11, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(43, 1, 1, 2, 12, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:24:48'),
	(44, 1, 1, 2, 13, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:42:24'),
	(45, 1, 1, 2, 14, '1\\. Nachfrist', '2019-01-18', '2019-12-30 12:11:54'),
	(46, 1, 1, 2, 7, 'Berichtsfrist intern', '2019-01-11', '2019-12-22 12:02:14'),
	(47, 1, 1, 2, 8, 'Berichtsfrist intern', '2019-01-11', '2019-12-22 12:02:17'),
	(48, 1, 1, 2, 18, 'Berichtsfrist intern', '2019-01-11', '2019-12-22 12:02:18'),
	(49, 1, 1, 2, 19, 'Berichtsfrist intern', '2019-01-11', '2019-12-22 11:50:17'),
	(50, 1, 1, 3, 5, 'Berichtsfrist intern', '2019-01-22', '2019-12-30 12:50:44'),
	(58, 1, 1, 3, 14, 'Berichtsfrist intern', '2019-01-22', '2019-12-30 12:50:46'),
	(60, 1, 1, 3, 1, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:17:12'),
	(61, 1, 1, 3, 2, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(62, 1, 1, 3, 3, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(63, 1, 1, 3, 4, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(64, 1, 1, 3, 6, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(65, 1, 1, 3, 10, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(66, 1, 1, 3, 11, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(67, 1, 1, 3, 12, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(68, 1, 1, 3, 13, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(69, 1, 1, 3, 15, 'Berichtsfrist intern', '2019-01-22', '2020-01-01 22:18:15'),
	(70, 1, 1, 4, 1, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:41'),
	(71, 1, 1, 4, 2, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:42'),
	(72, 1, 1, 4, 3, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:43'),
	(73, 1, 1, 4, 4, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:44'),
	(74, 1, 1, 4, 6, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:46'),
	(75, 1, 1, 4, 10, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:47'),
	(76, 1, 1, 4, 11, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:48'),
	(77, 1, 1, 4, 12, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:50'),
	(78, 1, 1, 4, 13, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:51'),
	(79, 1, 1, 4, 15, 'Berichtsfrist intern', '2019-02-01', '2020-01-01 23:33:51'),
	(80, 1, 2, 5, 20, 'Frist', '2019-01-16', '2020-01-09 00:31:07'),
	(81, 1, 2, 5, 22, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(82, 1, 2, 5, 23, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(83, 1, 2, 5, 24, 'Frist', '2019-01-16', '2020-01-06 11:45:46'),
	(84, 1, 2, 5, 25, 'Frist', '2019-01-16', '2020-01-06 11:41:29'),
	(85, 1, 2, 5, 26, 'Frist', '2019-01-16', '2020-01-06 11:50:18'),
	(86, 1, 2, 5, 30, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(87, 1, 2, 5, 31, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(88, 1, 2, 5, 32, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(89, 1, 2, 5, 33, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(90, 1, 2, 5, 34, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(91, 1, 2, 5, 35, 'Frist', '2019-01-16', '2020-01-06 11:51:36'),
	(92, 1, 2, 5, 39, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 19:19:46'),
	(93, 1, 2, 5, 27, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 18:49:31'),
	(94, 1, 2, 5, 28, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 18:49:32'),
	(95, 1, 2, 5, 29, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 18:49:33'),
	(96, 1, 2, 5, 36, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 18:49:33'),
	(97, 1, 2, 5, 37, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 19:19:45'),
	(98, 1, 2, 5, 38, 'Berichtsfrist intern', '2019-01-10', '2020-01-05 18:49:34'),
	(99, 1, 2, 6, 20, '1\\. Nachfrist', '2019-01-24', '2020-01-09 00:27:14'),
	(100, 1, 2, 6, 22, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:54'),
	(101, 1, 2, 6, 23, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:55'),
	(102, 1, 2, 6, 25, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:56'),
	(103, 1, 2, 6, 30, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:56'),
	(104, 1, 2, 6, 31, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:57'),
	(105, 1, 2, 6, 32, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:57'),
	(106, 1, 2, 6, 33, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:58'),
	(107, 1, 2, 6, 34, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:58'),
	(108, 1, 2, 6, 35, '1\\. Nachfrist', '2019-01-24', '2020-01-07 23:03:59'),
	(109, 1, 2, 6, 27, 'Berichtsfrist intern', '2019-01-22', '2020-01-06 23:50:41'),
	(110, 1, 2, 6, 24, 'Berichtsfrist intern', '2019-01-22', '2020-01-06 14:38:50'),
	(111, 1, 2, 6, 26, 'Berichtsfrist intern', '2019-01-22', '2020-01-06 14:38:51'),
	(114, 1, 3, 7, 23, 'Berichtsfrist intern', '2019-01-28', '2020-01-09 15:32:17'),
	(115, 1, 3, 7, 27, 'Berichtsfrist intern', '2019-01-28', '2020-01-09 03:16:00'),
	(116, 1, 3, 7, 32, 'Berichtsfrist intern', '2019-01-28', '2020-01-09 14:30:08'),
	(126, 1, 3, 7, 25, '2\\. Nachfrist', '2019-02-07', '2020-01-13 14:10:10'),
	(127, 1, 3, 7, 20, '2\\. Nachfrist', '2019-02-07', '2020-01-13 14:10:10'),
	(128, 1, 3, 7, 22, '2\\. Nachfrist', '2019-02-07', '2020-01-13 20:57:11'),
	(129, 1, 3, 7, 30, '2\\. Nachfrist', '2019-02-07', '2020-01-13 20:57:04'),
	(130, 1, 3, 7, 31, '2\\. Nachfrist', '2019-02-07', '2020-01-13 14:10:10'),
	(131, 1, 3, 7, 33, '2\\. Nachfrist', '2019-02-07', '2020-01-13 20:56:55'),
	(132, 1, 3, 7, 34, '2\\. Nachfrist', '2019-02-07', '2020-01-13 13:51:46'),
	(133, 1, 3, 7, 35, '2\\. Nachfrist', '2019-02-07', '2020-01-13 12:38:33'),
	(174, 1, 3, 11, 33, '3\\. Nachfrist', '2019-02-19', '2020-01-20 10:46:54'),
	(175, 1, 3, 11, 22, '3\\. Nachfrist', '2019-02-19', '2020-01-20 10:46:54'),
	(176, 1, 3, 11, 30, '3\\. Nachfrist', '2019-02-19', '2020-01-20 10:46:54'),
	(177, 1, 3, 11, 34, '3\\. Nachfrist', '2019-02-19', '2020-01-20 10:46:41'),
	(178, 1, 3, 11, 35, 'Berichtsfrist intern', '2019-02-11', '2020-01-19 12:11:30'),
	(179, 1, 3, 11, 20, 'Berichtsfrist intern', '2019-02-11', '2020-01-19 12:11:21'),
	(180, 1, 3, 11, 25, 'Berichtsfrist intern', '2019-02-11', '2020-01-19 12:11:27'),
	(181, 1, 3, 11, 31, 'Berichtsfrist intern', '2019-02-11', '2020-01-19 12:11:28'),
	(182, 1, 3, 16, 34, 'Berichtsfrist intern', '2019-02-21', '2020-01-20 10:48:10'),
	(183, 1, 3, 16, 22, 'Berichtsfrist intern', '2019-02-21', '2020-01-20 10:48:06'),
	(184, 1, 3, 16, 30, 'Berichtsfrist intern', '2019-02-21', '2020-01-20 10:48:07'),
	(185, 1, 3, 16, 33, 'Berichtsfrist intern', '2019-02-21', '2020-01-20 10:48:09'),
	(204, 3, 7, 17, 47, 'Frist', '2020-01-10', '2020-01-25 13:15:33'),
	(206, 3, 7, 17, 48, 'Frist', '2020-01-10', '2020-01-25 13:18:14'),
	(207, 3, 7, 17, 49, 'Frist', '2020-01-10', '2020-01-25 13:18:14'),
	(208, 3, 7, 17, 50, 'Frist', '2020-01-10', '2020-01-25 13:18:14'),
	(209, 3, 7, 17, 51, 'Frist', '2020-01-10', '2020-01-25 13:18:14'),
	(210, 3, 7, 17, 52, 'Frist', '2020-01-10', '2020-01-25 13:18:14'),
	(211, 3, 7, 17, 53, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(212, 3, 7, 17, 54, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(213, 3, 7, 17, 55, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(214, 3, 7, 17, 56, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(215, 3, 7, 17, 57, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(216, 3, 7, 17, 58, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(217, 3, 7, 17, 59, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(218, 3, 7, 17, 60, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(219, 3, 7, 17, 61, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(220, 3, 7, 17, 62, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(221, 3, 7, 17, 63, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(222, 3, 7, 17, 64, 'Frist', '2020-01-10', '2020-01-25 13:18:15'),
	(350, 3, 7, 18, 47, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:17:57'),
	(351, 3, 7, 18, 48, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(352, 3, 7, 18, 49, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(353, 3, 7, 18, 50, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(354, 3, 7, 18, 51, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(355, 3, 7, 18, 52, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(356, 3, 7, 18, 53, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(357, 3, 7, 18, 54, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(358, 3, 7, 18, 55, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(359, 3, 7, 18, 56, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(360, 3, 7, 18, 57, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(361, 3, 7, 18, 58, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(362, 3, 7, 18, 59, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(363, 3, 7, 18, 60, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(364, 3, 7, 18, 61, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(365, 3, 7, 18, 62, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(366, 3, 7, 18, 63, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(367, 3, 7, 18, 64, '1\\. Nachfrist', '2020-01-17', '2020-01-27 22:19:12'),
	(368, 3, 7, 19, 65, 'Frist', '2020-01-17', '2020-01-27 22:19:12'),
	(369, 3, 7, 19, 66, 'Frist', '2020-01-17', '2020-01-27 22:19:12'),
	(370, 3, 7, 19, 67, 'Frist', '2020-01-17', '2020-01-27 22:19:13'),
	(371, 3, 7, 19, 68, 'Frist', '2020-01-17', '2020-01-27 22:19:13'),
	(372, 3, 7, 19, 69, 'Frist', '2020-01-17', '2020-01-27 22:19:13'),
	(373, 3, 7, 19, 70, 'Frist', '2020-01-17', '2020-01-27 22:19:13'),
	(374, 3, 7, 20, 66, '1\\. Nachfrist', '2020-01-27', '2020-01-29 13:49:55'),
	(393, 3, 7, 20, 65, '1\\. Nachfrist', '2020-01-27', '2020-01-29 13:49:55'),
	(394, 3, 7, 20, 67, '1\\. Nachfrist', '2020-01-27', '2020-01-29 13:49:55'),
	(395, 3, 7, 20, 68, '1\\. Nachfrist', '2020-01-27', '2020-01-29 13:49:55'),
	(396, 3, 7, 20, 69, '1\\. Nachfrist', '2020-01-27', '2020-01-29 13:49:55'),
	(397, 3, 7, 20, 70, '1\\. Nachfrist', '2020-01-27', '2020-01-29 13:49:55'),
	(398, 3, 7, 20, 71, 'Frist', '2020-01-27', '2020-01-29 13:49:55'),
	(399, 3, 7, 20, 72, 'Frist', '2020-01-27', '2020-01-29 13:49:55'),
	(400, 3, 7, 20, 73, 'Frist', '2020-01-27', '2020-01-29 13:49:55'),
	(401, 3, 7, 20, 47, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:48:25'),
	(402, 3, 7, 20, 48, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(403, 3, 7, 20, 49, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(404, 3, 7, 20, 50, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(405, 3, 7, 20, 51, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(406, 3, 7, 20, 52, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(407, 3, 7, 20, 53, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(408, 3, 7, 20, 54, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(409, 3, 7, 20, 55, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(410, 3, 7, 20, 56, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(411, 3, 7, 20, 57, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(412, 3, 7, 20, 58, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(413, 3, 7, 20, 59, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(414, 3, 7, 20, 60, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(415, 3, 7, 20, 61, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(416, 3, 7, 20, 62, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(417, 3, 7, 20, 63, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(418, 3, 7, 20, 64, '2\\. Nachfrist', '2020-01-29', '2020-01-29 13:49:55'),
	(422, 3, 7, 20, 76, 'Berichtsfrist intern', '2020-01-22', '2020-01-28 14:01:25'),
	(423, 3, 7, 20, 74, 'Berichtsfrist intern', '2020-01-22', '2020-01-28 14:01:24'),
	(424, 3, 7, 20, 75, 'Berichtsfrist intern', '2020-01-22', '2020-01-28 14:01:24'),
	(425, 4, 8, 22, 77, 'Frist', '2020-01-02', '2020-01-28 20:22:54'),
	(426, 4, 8, 22, 79, 'Frist', '2020-01-04', '2020-01-28 20:59:07'),
	(427, 7, 10, 23, 80, 'Frist', '2020-01-20', '2020-01-28 23:41:04'),
	(464, 3, 7, 21, 47, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:25'),
	(465, 3, 7, 21, 48, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:25'),
	(466, 3, 7, 21, 49, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:26'),
	(467, 3, 7, 21, 50, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:27'),
	(468, 3, 7, 21, 51, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:28'),
	(469, 3, 7, 21, 52, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:28'),
	(470, 3, 7, 21, 62, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:39'),
	(471, 3, 7, 21, 63, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:40'),
	(472, 3, 7, 21, 64, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:40'),
	(473, 3, 7, 21, 73, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:46'),
	(474, 3, 7, 21, 72, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:45'),
	(475, 3, 7, 21, 66, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:42'),
	(476, 3, 7, 21, 67, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:42'),
	(477, 3, 7, 21, 68, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:43'),
	(478, 3, 7, 21, 69, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:43'),
	(479, 3, 7, 21, 70, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:44'),
	(480, 3, 7, 21, 71, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:45'),
	(481, 3, 7, 21, 65, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:41'),
	(482, 3, 7, 21, 61, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:37'),
	(483, 3, 7, 21, 53, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:29'),
	(484, 3, 7, 21, 60, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:35'),
	(485, 3, 7, 21, 59, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:35'),
	(486, 3, 7, 21, 58, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:34'),
	(487, 3, 7, 21, 54, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:30'),
	(488, 3, 7, 21, 55, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:31'),
	(489, 3, 7, 21, 57, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:33'),
	(490, 3, 7, 21, 56, 'Berichtsfrist intern', '2020-01-31', '2020-01-29 16:18:32'),
	(491, 8, 14, 25, 82, 'Frist', '2019-11-12', '2020-02-05 18:41:05'),
	(492, 8, 14, 25, 84, 'Frist', '2019-11-12', '2020-02-05 18:41:23'),
	(493, 8, 14, 25, 85, 'Frist', '2019-11-12', '2020-02-05 18:39:41'),
	(494, 8, 14, 26, 89, 'Frist', '2019-11-12', '2020-02-05 23:09:40'),
	(495, 8, 15, 28, 94, 'Frist', '2019-11-12', '2020-02-05 18:39:41'),
	(496, 8, 15, 28, 95, 'Frist', '2019-11-12', '2020-02-05 18:40:10'),
	(497, 8, 15, 28, 99, 'Frist', '2019-11-12', '2020-02-05 18:33:09'),
	(498, 8, 16, 30, 100, 'Frist', '2019-11-12', '2020-02-05 18:37:44'),
	(499, 8, 16, 30, 102, 'Frist', '2019-11-12', '2020-02-05 18:38:00'),
	(500, 8, 16, 30, 105, 'Frist', '2019-11-12', '2020-02-04 22:18:09'),
	(501, 8, 15, 29, 113, 'Frist', '2019-11-12', '2020-02-05 18:39:41'),
	(502, 8, 15, 29, 114, 'Frist', '2019-11-12', '2020-02-05 18:39:04'),
	(503, 8, 16, 31, 116, 'Frist', '2019-11-12', '2020-02-05 18:39:41'),
	(504, 8, 14, 25, 83, 'Frist', '2019-11-14', '2020-02-04 20:41:16'),
	(505, 8, 14, 25, 86, 'Frist', '2019-11-14', '2020-02-05 18:46:10'),
	(506, 8, 14, 25, 87, 'Frist', '2019-11-14', '2020-02-05 18:41:23'),
	(507, 8, 14, 26, 88, 'Frist', '2019-11-14', '2020-02-05 18:42:50'),
	(508, 8, 15, 28, 96, 'Frist', '2019-11-14', '2020-02-05 23:09:56'),
	(509, 8, 15, 28, 97, 'Frist', '2019-11-14', '2020-02-05 18:24:17'),
	(510, 8, 16, 30, 103, 'Frist', '2019-11-14', '2020-02-05 18:18:04'),
	(511, 8, 16, 30, 104, 'Frist', '2019-11-14', '2020-02-05 18:17:23'),
	(512, 8, 16, 31, 115, 'Frist', '2019-11-14', '2020-02-05 18:39:04'),
	(513, 8, 14, 26, 90, 'Frist', '2019-11-15', '2020-02-05 18:41:23'),
	(514, 8, 15, 28, 98, 'Frist', '2019-11-15', '2020-02-05 18:33:09'),
	(515, 8, 16, 30, 101, 'Frist', '2019-11-15', '2020-02-05 18:38:00'),
	(516, 8, 15, 29, 112, 'Frist', '2019-11-15', '2020-02-05 23:10:05'),
	(517, 8, 16, 31, 117, 'Frist', '2019-11-15', '2020-02-05 23:10:29'),
	(518, 8, 14, 27, 111, 'Berichtsfrist intern', '2019-11-08', '2020-01-31 18:45:54'),
	(519, 8, 14, 26, 91, 'Berichtsfrist intern', '2019-11-08', '2020-01-31 18:45:51'),
	(520, 8, 14, 26, 92, 'Berichtsfrist intern', '2019-11-08', '2020-01-31 18:45:52'),
	(521, 8, 14, 26, 93, 'Berichtsfrist intern', '2019-11-08', '2020-01-31 18:45:52'),
	(522, 8, 14, 27, 106, 'Berichtsfrist intern', '2019-11-08', '2020-02-03 17:54:25'),
	(523, 8, 14, 27, 107, 'Berichtsfrist intern', '2019-11-08', '2020-02-03 17:54:25'),
	(524, 8, 14, 27, 108, 'Berichtsfrist intern', '2019-11-08', '2020-02-03 17:54:26'),
	(525, 8, 14, 27, 109, 'Berichtsfrist intern', '2019-11-08', '2020-01-31 18:45:53'),
	(526, 8, 14, 27, 110, 'Berichtsfrist intern', '2019-11-08', '2020-01-31 18:45:53'),
	(527, 8, 14, 25, 123, 'Frist', '2019-11-11', '2020-02-05 18:41:23'),
	(528, 8, 14, 25, 121, 'Frist', '2019-11-11', '2020-02-05 18:41:23'),
	(529, 8, 14, 25, 122, 'Frist', '2019-11-11', '2020-02-05 18:20:17'),
	(530, 8, 14, 25, 126, 'Berichtsfrist intern', '2019-11-08', '2020-02-03 17:54:27'),
	(531, 8, 14, 25, 124, 'Berichtsfrist intern', '2019-11-08', '2020-02-03 17:54:26'),
	(532, 8, 14, 25, 125, 'Berichtsfrist intern', '2019-11-08', '2020-02-03 17:54:27'),
	(533, 8, 14, 32, 85, 'Berichtsfrist intern', '2019-11-18', '2020-02-05 19:21:05'),
	(534, 8, 15, 34, 94, 'Berichtsfrist intern', '2019-11-18', '2020-02-05 19:21:06'),
	(535, 8, 16, 33, 104, 'Berichtsfrist intern', '2019-11-18', '2020-02-05 19:21:06'),
	(536, 8, 15, 34, 113, 'Berichtsfrist intern', '2019-11-18', '2020-02-05 19:21:07'),
	(537, 8, 16, 33, 116, 'Berichtsfrist intern', '2019-11-18', '2020-02-05 19:21:07'),
	(538, 8, 14, 32, 82, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:13:11'),
	(539, 8, 14, 32, 84, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:14:00'),
	(540, 8, 14, 32, 87, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:11:04'),
	(541, 8, 14, 32, 90, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:13:18'),
	(542, 8, 15, 34, 95, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:12:38'),
	(543, 8, 15, 34, 98, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:12:57'),
	(544, 8, 16, 33, 100, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:11:38'),
	(545, 8, 16, 33, 102, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:12:46'),
	(546, 8, 16, 33, 103, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:11:12'),
	(547, 8, 15, 34, 114, '1\\. Nachfrist', '2019-11-25', '2020-02-10 18:29:07'),
	(548, 8, 16, 33, 115, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:12:28'),
	(549, 8, 14, 32, 121, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:13:35'),
	(550, 8, 14, 32, 123, '1\\. Nachfrist', '2019-11-25', '2020-02-05 23:14:14'),
	(551, 8, 15, 34, 97, '1\\. Nachfrist', '2019-11-28', '2020-02-05 23:14:40'),
	(552, 8, 15, 34, 99, '1\\. Nachfrist', '2019-11-29', '2020-02-10 18:31:52'),
	(553, 8, 16, 33, 105, '1\\. Nachfrist', '2019-12-06', '2020-02-10 18:29:06'),
	(554, 8, 14, 32, 88, '1\\. Nachfrist', '2019-12-03', '2020-02-10 18:33:08'),
	(555, 8, 14, 32, 86, '1\\. Nachfrist', '2019-11-28', '2020-02-05 23:14:29'),
	(556, 8, 14, 32, 83, '1\\. Nachfrist', '2019-12-10', '2020-02-10 18:33:41'),
	(557, 8, 14, 32, 122, '1\\. Nachfrist', '2019-12-03', '2020-02-10 18:28:39'),
	(558, 8, 16, 33, 101, '1\\. Nachfrist', '2019-11-22', '2020-02-05 23:10:55'),
	(559, 8, 14, 36, 123, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:30:57'),
	(560, 8, 14, 36, 82, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:28:07'),
	(561, 8, 14, 36, 84, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:33:31'),
	(562, 8, 14, 36, 86, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:33:24'),
	(563, 8, 14, 36, 87, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:33:16'),
	(564, 8, 14, 36, 89, '1\\. Nachfrist', '2019-12-06', '2020-02-10 18:32:58'),
	(565, 8, 14, 36, 90, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:32:49'),
	(566, 8, 15, 38, 95, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:32:40'),
	(567, 8, 15, 38, 96, '1\\. Nachfrist', '2019-12-06', '2020-02-10 18:32:31'),
	(568, 8, 15, 38, 97, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:32:12'),
	(569, 8, 15, 38, 98, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:32:01'),
	(570, 8, 16, 39, 101, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:31:44'),
	(571, 8, 16, 39, 102, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:31:37'),
	(572, 8, 16, 39, 103, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:31:30'),
	(573, 8, 15, 38, 112, '1\\. Nachfrist', '2019-12-06', '2020-02-10 18:31:21'),
	(574, 8, 16, 39, 115, '2\\. Nachfrist', '2019-12-06', '2020-02-10 18:31:13'),
	(575, 8, 16, 39, 117, '1\\. Nachfrist', '2019-12-06', '2020-02-10 18:31:04'),
	(579, 8, 14, 36, 92, 'Berichtsfrist intern', '2019-12-02', '2020-02-10 14:38:59'),
	(580, 8, 14, 36, 91, 'Berichtsfrist intern', '2019-12-02', '2020-02-10 14:38:58'),
	(581, 8, 16, 39, 100, 'Berichtsfrist intern', '2019-12-02', '2020-02-10 11:28:33'),
	(582, 8, 14, 36, 121, 'Berichtsfrist intern', '2019-12-02', '2020-02-10 11:28:33'),
	(583, 8, 16, 40, 105, 'Berichtsfrist intern', '2019-12-13', '2020-02-10 18:48:01'),
	(584, 8, 15, 42, 114, 'Berichtsfrist intern', '2019-12-13', '2020-02-10 18:48:02'),
	(585, 8, 14, 41, 122, 'Berichtsfrist intern', '2019-12-13', '2020-02-10 18:48:03'),
	(586, 8, 16, 40, 103, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:01:06'),
	(587, 8, 14, 41, 82, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(588, 8, 14, 41, 83, '2\\. Nachfrist', '2019-12-13', '2020-02-10 19:06:03'),
	(589, 8, 14, 41, 84, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(590, 8, 14, 41, 86, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(591, 8, 14, 41, 87, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(592, 8, 14, 41, 88, '2\\. Nachfrist', '2019-12-13', '2020-02-10 19:05:51'),
	(593, 8, 14, 41, 89, '2\\. Nachfrist', '2019-12-13', '2020-02-10 19:06:03'),
	(594, 8, 14, 41, 90, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(595, 8, 15, 42, 95, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:20'),
	(596, 8, 15, 42, 96, '2\\. Nachfrist', '2019-12-13', '2020-02-10 19:06:03'),
	(597, 8, 15, 42, 97, '3\\. Nachfrist', '2019-12-17', '2020-02-10 19:22:49'),
	(598, 8, 15, 42, 98, '3\\. Nachfrist', '2019-12-17', '2020-02-10 19:22:49'),
	(599, 8, 15, 42, 99, '2\\. Nachfrist', '2019-12-17', '2020-02-10 19:06:03'),
	(600, 8, 16, 40, 101, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(601, 8, 16, 40, 102, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(602, 8, 15, 42, 112, '2\\. Nachfrist', '2019-12-13', '2020-02-10 19:06:03'),
	(603, 8, 16, 40, 115, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49'),
	(604, 8, 16, 40, 117, '2\\. Nachfrist', '2019-12-13', '2020-02-10 19:06:03'),
	(605, 8, 14, 41, 123, '3\\. Nachfrist', '2019-12-13', '2020-02-10 19:22:49');
/*!40000 ALTER TABLE `tab_e` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
