· 7 years ago · Feb 12, 2019, 01:46 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server Version: 5.7.20-log - MySQL Community Server (GPL)
4-- Server Betriebssystem: Win64
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Exportiere Datenbank Struktur für flottekiste2018
16CREATE DATABASE IF NOT EXISTS `flottekiste2018` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `flottekiste2018`;
18
19-- Exportiere Struktur von Tabelle flottekiste2018.kunde
20CREATE TABLE IF NOT EXISTS `kunde` (
21 `KdNr` int(11) NOT NULL DEFAULT '0',
22 `Name` char(20) DEFAULT NULL,
23 `Vorname` char(15) DEFAULT NULL,
24 `Strasse` char(30) DEFAULT NULL,
25 `PLZ` char(5) DEFAULT NULL,
26 `Ort` char(20) DEFAULT NULL,
27 `Telefon` char(20) DEFAULT NULL,
28 `Vorliebe` char(30) DEFAULT NULL,
29 PRIMARY KEY (`KdNr`)
30) ENGINE=InnoDB DEFAULT CHARSET=latin1;
31
32-- Exportiere Daten aus Tabelle flottekiste2018.kunde: ~120 rows (ungefähr)
33/*!40000 ALTER TABLE `kunde` DISABLE KEYS */;
34INSERT INTO `kunde` (`KdNr`, `Name`, `Vorname`, `Strasse`, `PLZ`, `Ort`, `Telefon`, `Vorliebe`) VALUES
35 (1, 'Böhm', 'Dana', 'Leipziger Str. 43', '10117', 'Berlin', '030/ 2040715', 'Cabrio'),
36 (2, 'Ackermann', 'Ines', 'Leuenberger Str. 14', '13055', 'Berlin', '030/ 9818512', NULL),
37 (3, 'Müller', 'Gustav', 'Holzweg 7', '10678', 'Berlin', '030/ 1234567', NULL),
38 (4, 'Knute', 'Liselotte', 'Dorfstr. 13', '58976', 'Kleinkleckersdorf', '03895/ 1542', '30 er Jahre'),
39 (5, 'Schmidt', 'Dieter', 'Holzweg 7', '10678', 'Berlin', '030/ 1234567', 'Nobelkarossen'),
40 (6, 'vom Deich', 'Gustav', 'Deichstr. 34', '23456', 'Kirchheim', NULL, 'Cabrio'),
41 (7, 'Grieß', 'Carola', 'Weichdamm 123', '12343', 'Kuhstedt', '03456 / 43534', 'Nobelkarossen'),
42 (8, 'Boss', 'Horst', 'Berliner Str. 34', '10234', 'Berlin', '030/ 776567', 'Cabrio'),
43 (9, 'Wiegand', 'Berta', 'Bergstr. 56', '23458', 'Köhlen', NULL, 'Mercedes'),
44 (10, 'Terletzki', 'Frank', 'Kantianstraße 14', '12345', 'Berlin', NULL, 'Nobelkarossen'),
45 (11, 'Dalichow', 'Uwe', 'Hosemannstraße 11', '10243', 'Berlin', '030/ 4252741', 'Mercedes'),
46 (12, 'von Sinnen', 'Hella', 'Sesamstraße 111', '80111', 'München', NULL, 'Rennwagen'),
47 (13, 'Wussow', 'Klaus Jürgen', 'Große Freiheit 1', '20102', 'Hamburg', NULL, 'Sportwagen'),
48 (14, 'Neumann', 'Barbara', 'Kundenstraße 27', '45569', 'Hassloch', NULL, NULL),
49 (15, 'Witt', 'Sebastian', 'Alfred-Randt-Straße 14', '12559', 'Berlin', '030/ 57 25 63', 'Sportwagen'),
50 (16, 'Wollschläger', 'Veronica', 'Finkenstraße 2', '12459', 'Berlin', '030/ 56 70 17 64', 'Nobelkarossen'),
51 (17, 'Wolle', 'Rolf', 'Bärensteinstraße 44', '12685', 'Berlin', '030/ 5 43 22 07', NULL),
52 (18, 'Hennig', 'Grit', 'Stubenrauchstraße 11', '14482', 'Potsdam', '0331 / 71 86 07', '30 er Jahre'),
53 (19, 'Kirsten', 'Andrea', 'Nossener Straße 48', '10568', 'Berlin', '030 / 48 52 65', 'Sportwagen'),
54 (20, 'Schnitzler', 'Karl-Eduard', 'Baumschulenweg 40', '11995', 'Berlin', '030/ 6 64 54 55', '30 er Jahre'),
55 (21, 'Krause', 'Alex', 'Goethestraße 4', '10432', 'Berlin', '0171/123456', 'Sportwagen'),
56 (22, 'Bach', 'Martin', 'Molestr. 33', '80329', 'Augsburg', '8213 / 3139', 'Rennwagen'),
57 (23, 'Hadder', 'Curt', 'Innerer Ring 34', '75131', 'Stuttgart', '7408 / 1267', '30 er Jahre'),
58 (24, 'Daniels', 'Martin', 'Huberstr. 78', '90091', 'Weimar', '9312 / 2896', NULL),
59 (25, 'Allmeier', 'Georg', 'Schaghof 6', '87215', 'Neustadt', '8615 / 6150', 'Mercedes'),
60 (26, 'Flieger', 'Rudolf', 'Westallee 68', '90023', 'Nürnberg', '718 / 23365', NULL),
61 (27, 'Haldemann', 'Amin', 'Drankstr. 43', '71153', 'Siegen', '7912 / 3906', 'Mercedes'),
62 (28, 'Rasmussen', 'M', 'Nußweg 12', '70180', 'Villingen', '7404 / 5452', NULL),
63 (29, 'Mader', 'Martha', 'Leopoldstr. 45', '80087', 'München', '89 / 426764', NULL),
64 (30, 'Springer', 'Doris', 'Reginastr. 45', '66554', 'Frankfurt', '7304 / 4288', 'Sportwagen'),
65 (31, 'Bartels', 'Benjamin', 'Maronistr. 7', '01306', 'Dredsen', '918 / 87153', 'Nobelkarossen'),
66 (32, 'David', 'Johann', 'Phöter Platz 19', '20801', 'Olpe', '2105 / 7626', NULL),
67 (33, 'Fuchs', 'Rudolf', 'Lacher Str. 56', '74539', 'Freiburg', '8708 / 3204', NULL),
68 (34, 'Harrer', 'Reinhardt', 'Tenable Court 9', '45393', 'Wolfsburg', '512 / 47395', 'Rennwagen'),
69 (35, 'Heider', 'Casimir', 'Mentorgasse 9', '10889', 'Berlin', '030 / 155164', NULL),
70 (36, 'Taubert', 'Lora', 'Rubauerstr. 6', '53309', 'Bachfeld', '5345 / 9573', 'Nobelkarossen'),
71 (37, 'Fleischmann', 'Gerhard', 'Zingstr. 23', '75080', 'Reichart', '7214 / 9325', '30 er Jahre'),
72 (38, 'Cherneff', 'Richard', 'Postweg 18', '80401', 'Glonn', '8393 / 5522', '30 er Jahre'),
73 (39, 'Flungs', 'Gerhard', 'Befallener Str. 13', '60805', 'Darmstadt', '7213 / 7753', 'Rennwagen'),
74 (40, 'Waltmann', 'Jasmin', 'Phillips-Platz 2', '80557', 'München', '89 / 634069', NULL),
75 (41, 'Pitters', 'Dora', 'Schönstr. 34', '04048', 'Leipzig', '9213 / 3769', 'Sportwagen'),
76 (42, 'Aue', 'Georg', 'Inzeller Str. 23', '88802', 'Berchtesgaden', '8409 / 2615', NULL),
77 (43, 'Mostermann', 'David', 'Hubertusstr. 21', '45014', 'Celle', '408 / 29061', 'Nobelkarossen'),
78 (44, 'Röpe', 'Eduard', 'Sarastr. 19', '31303', 'Camen', '3609 / 8247', 'Mercedes'),
79 (45, 'Allberger', 'Karl', 'Slautterstr. 17', '66179', 'Frankfurt', '717 / 96421', 'Sportwagen'),
80 (46, 'Cona', 'Johannes', 'Zykadenweg 9', '45429', 'Duisburg', '4513 / 9523', 'Mercedes'),
81 (47, 'Mauer', 'Verena', 'Furtstr. 187', '53186', 'Wiesbaden', '7321 / 3439', 'Cabrio'),
82 (48, 'Porochner', 'Georg', 'Parter Weg 65', '24025', 'Kiel', '241 / 77580', 'Mercedes'),
83 (49, 'Dröge', 'Gabi', 'Spessartring 22', '67063', 'Frankfurt', '713 / 35021', 'Sportwagen'),
84 (50, 'Ascherbach', 'Verena', 'Albertstr. 78', '53154', 'Sahmerberg', '5021 / 8825', 'Rennwagen'),
85 (51, 'Krowe', 'Rudi', 'Lausitzstr. 6', '57917', 'Köln', '315 / 32603', NULL),
86 (52, 'Ozer', 'Bernhard', 'Schmollerstr. 65', '87609', 'Regensburg', '8919 / 7715', 'Sportwagen'),
87 (53, 'Keller', 'Maria', 'Turmallee 17', '74751', 'Meersburg', '715 / 7242', NULL),
88 (54, 'Murmann', 'Georg', 'Frenzelstr. 6', '86104', 'Augsburg', '813 / 93658', 'Sportwagen'),
89 (55, 'Deller', 'Adelheid', 'Mitterweg 13', '27092', 'Hamburg', '2713 / 1514', 'Rennwagen'),
90 (56, 'Meier', 'Martha', 'Bieler Allee 15', '31607', 'Mittelstadt', '3228 / 5961', 'Cabrio'),
91 (57, 'Richard', 'R', 'Bucklerstr. 67', '30309', 'Altenstadt', '3123 / 2007', NULL),
92 (58, 'Botter', 'Martin', 'Auf der Drift 23', '15410', 'Potsdam', '1619 / 8760', NULL),
93 (59, 'Korsen', 'Susanne', 'Efeustr. 67', '21978', 'Flensburg', '1516 / 7229', 'Rennwagen'),
94 (60, 'Paretta', 'Norbert', 'Tröndlestr. 56', '78659', 'Nierburg', '719 / 40377', NULL),
95 (61, 'Seiner', 'Johannes', 'Rotemundstr. 33', '21246', 'Brackstadt', '2174 / 5451', NULL),
96 (62, 'Seemeier', 'Philip', 'Balzacstr. 41', '73347', 'Saarbrücken', '7415 / 1808', NULL),
97 (63, 'Collins', 'Michael', 'Köhlerstr. 6', '70113', 'Koblenz', '7504 / 1463', 'Cabrio'),
98 (64, 'Geiers', 'Allan', 'Jasminstr. 3', '54010', 'Braunschweig', '5918 / 2612', '30 er Jahre'),
99 (65, 'Weir', 'Walter', 'Wernerstr. 45', '54608', 'Emden', '5415 / 9399', NULL),
100 (66, 'Robert', 'Franz', 'Fliegerstr. 5', '99026', 'Nürnberg', '8212 / 4358', 'Rennwagen'),
101 (67, 'Alvis', 'Franz', 'Zeusstr. 12', '89577', 'Mindelheim', '8803 / 6432', 'Rennwagen'),
102 (68, 'Gilbert', 'Johann', 'Daiserstr. 34', '23604', 'Langenbach', '2214 / 9865', NULL),
103 (69, 'Martin', 'Philip', 'Dastlerstr. 7', '25207', 'Detmold', '2214 / 8429', NULL),
104 (70, 'Straub', 'Anton', 'Hürdenstr. 39', '70706', 'Bietigheim', '7213 / 2876', 'Sportwagen'),
105 (71, 'Steiner', 'Hubert', 'Bernardstr. 11', '64110', 'Winterberg', '6603 / 4712', 'Nobelkarossen'),
106 (72, 'Stegner', 'Johannes', 'Nickelring 12', '27035', 'Hannover', '2713 / 6256', NULL),
107 (73, 'Martin', 'Andreas', 'Pollerweg 5', '81213', 'Starnberg', '8151 / 2457', NULL),
108 (74, 'Karon', 'Rita', 'Piusstr. 9', '25234', 'Detmold', '2214 / 9519', 'Rennwagen'),
109 (75, 'Hager', 'Peter', 'Vogelbergstr. 5', '04071', 'Leipzig', '9213 / 8405', 'Mercedes'),
110 (76, 'Hintermann', 'Fritz', 'Sonnenstr. 29', '82174', 'Augsburg', '8617 / 4465', NULL),
111 (77, 'Machter', 'Jasmin', 'Mehlwiesenstr. 67', '82176', 'München', '89 / 393491', 'Rennwagen'),
112 (78, 'Siltmann', 'Michael', 'Grasserstr. 56', '22301', 'Tucherberg', '2904 / 3170', NULL),
113 (79, 'Hansen', 'Philip', 'Hofplatz 45', '75074', 'Stuttgart', '640 / 16069', NULL),
114 (80, 'Golder', 'Josef', 'Kaiserstr. 17', '31040', 'Hannover', '3203 / 8252', 'Cabrio'),
115 (81, 'Breuster', 'Ronald', 'Schindlerstr. 27', '25926', 'Bonn', '2916 / 6078', 'Cabrio'),
116 (82, 'Perez', 'M', 'Freudstr. 7', '62053', 'Mörs', '6312 / 5550', '30 er Jahre'),
117 (83, 'Kmickle', 'Matthias', 'Luggerstr. 78', '63780', 'Trendheim', '6317 / 7193', NULL),
118 (84, 'Sander', 'Rosemarie', 'Dreilandstr. 44', '73303', 'Seifert', '7503 / 5475', 'Rennwagen'),
119 (85, 'Wachter', 'Roland', 'Wislerstr. 3', '25201', 'Tribach', '2514 / 6447', 'Sportwagen'),
120 (86, 'Troiano', 'Albert', 'Lüfnerstr. 67', '04026', 'Leipzig', '9213 / 3719', 'Nobelkarossen'),
121 (87, 'Daniel', 'Robert', 'Neubergerstr. 6', '40303', 'Bühren', '4303 / 2435', NULL),
122 (88, 'Giese', 'Hannes', 'Russenstr. 9', '29413', 'Lübeck', '2806 / 9127', 'Rennwagen'),
123 (89, 'Mosser', 'Dieter', 'Primelweg 6', '64610', 'Ottoberg', '6415 / 1690', 'Cabrio'),
124 (90, 'Allberger', 'Sandra', 'Zauberweg 19', '82212', 'Achtbach', '8518 / 7246', NULL),
125 (91, 'Erickson', 'Boris', 'Alberichstr. 67', '74104', 'Stuttgart', '7415 / 9650', 'Nobelkarossen'),
126 (92, 'Sommer', 'Sabrina', 'Westufer 16', '63382', 'Viehberg', '6314 / 7008', 'Rennwagen'),
127 (93, 'Komerossky', 'Josef', 'Rauherweg 45', '87871', 'Sonnigheim', '8201 / 2799', 'Mercedes'),
128 (94, 'Stanglmeier', 'Lisa', 'Winzerstr. 9', '35050', 'Saulberg', '3408 / 1774', 'Mercedes'),
129 (95, 'Krosber', 'Martin', 'Bayernring 21', '76814', 'Homburg', '7808 / 8450', 'Sportwagen'),
130 (96, 'Kuklinsky', 'Harald', 'Maiglöckchengasse 16', '65247', 'Darmstadt', '6214 / 7289', NULL),
131 (97, 'Krosber', 'Friedrich', 'Lärchenstr. 56', '74897', 'Weinheim', '7203 / 8263', 'Rennwagen'),
132 (98, 'Straub', 'Adam', 'Eifelstr. 3', '44116', 'Tauberheim', '4918 / 7813', NULL),
133 (99, 'Busch', 'Richard', 'Ardbergstr. 15', '68093', 'Wüstenberg', '6313 / 4429', 'Sportwagen'),
134 (100, 'Garner', 'Doris', 'Pfauenstr. 9', '25101', 'Straub', '2612 / 7752', 'Rennwagen'),
135 (101, 'Kaiser', 'Lisa', 'Königsstr. 41', '37701', 'Düsseldorf', '3201 / 4975', '30 er Jahre'),
136 (102, 'Bechtel', 'Isidor', 'Harthofstr. 6', '37757', 'Obergurgel', '3201 / 5801', '30 er Jahre'),
137 (103, 'Dröge', 'Michael', 'Starkfeld 2', '85638', 'Inzingen', '8606 / 2227', 'Rennwagen'),
138 (104, 'Daniel', 'Sandra', 'Pucherstr. 6', '23121', 'Hamburg', '2305 / 2384', 'Mercedes'),
139 (105, 'Kessler', 'Marion', 'Gogglerstr. 5', '61701', 'Blaufeld', '6309 / 1522', 'Mercedes'),
140 (106, 'Hayden', 'Verena', 'Hanckestr. 97', '12103', 'Berlin', '030/6175587', NULL),
141 (107, 'Gold', 'Juliane', 'Sachsenhof', '09013', 'Halle', '9303 / 7594', 'Cabrio'),
142 (108, 'Johnson', 'Toni', 'Abrahamstr. 9', '62174', 'Ãœbersee', '6617 / 3541', 'Mercedes'),
143 (109, 'Albrecht', 'Dieter', 'Südallee 113', '85205', 'Straubing', '8209 / 6618', 'Mercedes'),
144 (110, 'Karon', 'Bernhard', 'Krügerweg 13a', '66501', 'Erbach', '6814 / 2216', 'Mercedes'),
145 (111, 'Pattersen', 'Susanne', 'Ludwigstr. 78', '99743', 'Nürnberg', '8212 / 8384', '30 er Jahre'),
146 (112, 'Matthesen', 'Eberhard', 'Steinstr. 2', '99743', 'Nürnberg', '8212 / 6391', 'Cabrio'),
147 (113, 'Apter', 'Wofgang', 'Fährgasse 9', '37408', 'Gladbach', '3919 / 7259', 'Cabrio'),
148 (114, 'Keller', 'Robert', 'Kurfüstenstr. 35', '10470', 'Berlin', '030/2018302', NULL),
149 (115, 'Tauber', 'Peter', 'Rondellstr. 77', '32025', 'Essen', '3619 / 8923', 'Nobelkarossen'),
150 (116, 'Rosen', 'Norbert', 'Mühlbergstr. 34', '04041', 'Leipzig', '9213 / 4041', 'Cabrio'),
151 (117, 'Auer', 'Josef', 'Zugspitzstr. 67', '80631', 'Garmisch', '8303 / 7758', 'Cabrio'),
152 (118, 'Erdmann', 'Sabrina', 'Ringstr. 3', '68840', 'Seeberg', '6512 / 9838', 'Cabrio'),
153 (119, 'Walter', 'Daniel', 'Wiesbadener Str. 9', '66830', 'Ludwigshafen', '6203 / 4285', NULL),
154 (120, 'Funner', 'R', 'Hallberger Str. 32', '60706', 'Langenfeld', '6301 / 2066', 'Nobelkarossen');
155/*!40000 ALTER TABLE `kunde` ENABLE KEYS */;
156
157-- Exportiere Struktur von Tabelle flottekiste2018.mieten
158CREATE TABLE IF NOT EXISTS `mieten` (
159 `Kunde_KdNr` int(11) NOT NULL DEFAULT '0',
160 `Oldtimer_Kennzeichen` char(10) NOT NULL DEFAULT '',
161 `Mietbeginn` date NOT NULL DEFAULT '0000-00-00',
162 `Mietende` date DEFAULT NULL,
163 `Bezahlt` tinyint(1) DEFAULT NULL,
164 `Mietgrund` char(11) DEFAULT NULL,
165 PRIMARY KEY (`Kunde_KdNr`,`Oldtimer_Kennzeichen`,`Mietbeginn`)
166) ENGINE=InnoDB DEFAULT CHARSET=latin1;
167
168-- Exportiere Daten aus Tabelle flottekiste2018.mieten: ~614 rows (ungefähr)
169/*!40000 ALTER TABLE `mieten` DISABLE KEYS */;
170INSERT INTO `mieten` (`Kunde_KdNr`, `Oldtimer_Kennzeichen`, `Mietbeginn`, `Mietende`, `Bezahlt`, `Mietgrund`) VALUES
171 (1, 'B-AF 3952H', '2013-01-13', '2013-01-27', 1, NULL),
172 (1, 'B-E 5438H', '2015-11-12', '2015-11-14', 1, NULL),
173 (1, 'B-LY 7945H', '2015-10-19', '2015-10-21', 1, NULL),
174 (1, 'B-MA 554H', '2014-02-14', '2014-02-28', 1, NULL),
175 (1, 'B-TR 4320H', '2014-12-02', '2014-12-03', 1, NULL),
176 (1, 'B-TR 4320H', '2015-01-26', '2015-02-09', 1, NULL),
177 (1, 'B-TX 6521H', '2017-05-26', '2017-06-01', 1, NULL),
178 (2, 'B-AF 3952H', '2016-07-04', '2016-07-08', 1, NULL),
179 (2, 'B-AH 7843H', '2017-08-08', '2017-08-21', 1, NULL),
180 (2, 'B-DB 8787H', '2017-10-23', '2017-10-24', 1, NULL),
181 (2, 'B-EW 3478H', '2016-08-13', '2016-08-14', 1, NULL),
182 (2, 'B-EW 3478H', '2016-10-09', '2016-10-13', 1, NULL),
183 (2, 'B-FE 3561H', '2015-08-11', '2015-08-24', 1, NULL),
184 (2, 'B-LY 7945H', '2015-08-29', '2015-09-12', 1, NULL),
185 (2, 'B-NH 442H', '2013-06-16', '2013-06-22', 1, NULL),
186 (2, 'B-TR 4320H', '2016-03-15', '2016-03-23', 1, NULL),
187 (2, 'B-TX 6521H', '2015-07-11', '2015-07-25', 1, NULL),
188 (3, 'B-AH 7843H', '2015-09-30', '2015-10-11', 1, NULL),
189 (3, 'B-ET 324H', '2012-11-10', '2012-11-16', 1, NULL),
190 (4, 'B-AL 341H', '2017-05-09', '2017-05-21', 1, NULL),
191 (5, 'B-FE 3561H', '2017-08-13', '2017-08-23', 1, NULL),
192 (5, 'B-MA 554H', '2014-03-03', '2014-03-04', 1, NULL),
193 (6, 'B-DB 8787H', '2015-03-11', '2015-03-18', 1, NULL),
194 (6, 'B-KL 743H', '2015-04-10', '2015-04-24', 1, NULL),
195 (6, 'B-MA 554H', '2016-07-31', '2016-08-06', 1, NULL),
196 (6, 'B-MA 554H', '2017-08-01', '2017-08-05', 1, NULL),
197 (6, 'B-VD 649H', '2013-07-19', '2013-07-26', 1, NULL),
198 (7, 'B-DB 8787H', '2013-05-29', '2013-05-30', 1, NULL),
199 (7, 'B-E 5438H', '2015-09-01', '2015-09-10', 1, NULL),
200 (7, 'B-EW 3478H', '2015-07-04', '2015-07-07', 1, NULL),
201 (7, 'B-MA 554H', '2013-01-27', '2013-01-30', 0, NULL),
202 (7, 'B-ZZ 2349H', '2013-03-05', '2013-03-17', 1, NULL),
203 (7, 'B-ZZ 2349H', '2017-06-19', '2017-06-26', 1, NULL),
204 (8, 'B-AH 7843H', '2017-12-05', '2017-12-18', 1, NULL),
205 (8, 'B-KL 743H', '2015-12-16', '2015-12-29', 1, NULL),
206 (8, 'B-NH 442H', '2017-06-18', '2017-06-22', 1, NULL),
207 (9, 'B-AL 341H', '2017-11-02', '2017-11-15', 1, NULL),
208 (9, 'B-RL 9299H', '2014-11-17', '2014-11-20', 1, NULL),
209 (9, 'B-TR 4320H', '2014-05-24', '2014-05-25', 0, NULL),
210 (9, 'B-VX 445H', '2014-02-12', '2014-02-14', 0, NULL),
211 (9, 'B-VX 445H', '2016-09-15', '2016-09-28', 1, NULL),
212 (10, 'B-AH 7843H', '2012-11-27', '2012-12-06', 0, NULL),
213 (10, 'B-AL 341H', '2015-10-04', '2015-10-11', 1, NULL),
214 (10, 'B-DB 8787H', '2017-03-29', '2017-03-31', 1, NULL),
215 (10, 'B-ET 324H', '2013-06-02', '2013-06-04', 1, NULL),
216 (10, 'B-EW 3478H', '2013-03-07', '2013-03-17', 1, NULL),
217 (10, 'B-FE 3561H', '2013-12-11', '2013-12-16', 1, NULL),
218 (10, 'B-FE 3561H', '2016-09-29', '2016-10-07', 1, NULL),
219 (10, 'B-MA 554H', '2017-07-26', '2017-08-09', 1, NULL),
220 (10, 'B-VD 649H', '2013-05-31', '2013-06-06', 1, NULL),
221 (11, 'B-AL 341H', '2015-06-24', '2015-06-30', 1, NULL),
222 (11, 'B-E 5438H', '2015-05-03', '2015-05-05', 1, NULL),
223 (11, 'B-ET 324H', '2013-02-21', '2013-03-05', 1, NULL),
224 (11, 'B-LY 7945H', '2014-06-29', '2014-07-03', 1, NULL),
225 (11, 'B-MA 554H', '2014-11-30', '2014-12-08', 1, NULL),
226 (11, 'B-PO 1265H', '2017-08-11', '2017-08-24', 1, NULL),
227 (11, 'B-RL 9299H', '2012-11-11', '2012-11-23', 1, NULL),
228 (11, 'B-RT 683H', '2016-09-26', '2016-10-10', 1, NULL),
229 (11, 'B-SL 300H', '2016-03-05', '2016-03-10', 1, NULL),
230 (12, 'B-AL 341H', '2014-03-08', '2014-03-14', 1, NULL),
231 (12, 'B-DS 8969H', '2015-04-05', '2015-04-09', 1, NULL),
232 (12, 'B-ET 324H', '2013-11-08', '2013-11-11', 1, NULL),
233 (12, 'B-KL 743H', '2016-06-27', '2016-06-29', 1, NULL),
234 (12, 'B-VD 649H', '2013-08-18', '2013-08-25', 1, NULL),
235 (12, 'B-VX 445H', '2012-09-05', '2012-09-19', 1, NULL),
236 (13, 'B-AL 341H', '2013-09-03', '2013-09-06', 1, NULL),
237 (13, 'B-AL 341H', '2015-02-09', '2015-02-20', 1, NULL),
238 (13, 'B-AL 341H', '2015-07-04', '2015-07-07', 1, NULL),
239 (13, 'B-ET 324H', '2014-08-01', '2014-08-09', 1, NULL),
240 (13, 'B-ET 324H', '2014-10-27', '2014-11-05', 1, NULL),
241 (13, 'B-KL 743H', '2013-06-19', '2013-06-21', 0, NULL),
242 (13, 'B-ZZ 2349H', '2014-10-11', '2014-10-22', 1, NULL),
243 (14, 'B-DB 8787H', '2013-07-28', '2013-08-06', 1, NULL),
244 (14, 'B-DB 8787H', '2015-05-28', '2015-06-07', 1, NULL),
245 (14, 'B-E 5438H', '2014-05-30', '2014-06-04', 1, NULL),
246 (14, 'B-FE 3561H', '2014-01-20', '2014-01-26', 1, NULL),
247 (14, 'B-PO 1265H', '2014-06-25', '2014-06-29', 1, NULL),
248 (14, 'B-SL 300H', '2014-06-13', '2014-06-24', 1, NULL),
249 (15, 'B-FE 3561H', '2015-11-02', '2015-11-15', 1, NULL),
250 (15, 'B-LY 7945H', '2015-11-25', '2015-11-30', 1, NULL),
251 (15, 'B-NH 442H', '2016-12-17', '2016-12-23', 0, NULL),
252 (15, 'B-PO 1265H', '2013-03-18', '2013-03-22', 1, NULL),
253 (15, 'B-PO 1265H', '2014-02-27', '2014-03-08', 0, NULL),
254 (15, 'B-PO 1265H', '2016-03-12', '2016-03-25', 1, NULL),
255 (15, 'B-RL 9299H', '2017-12-21', '2017-12-27', 1, 'Hochzeit'),
256 (15, 'B-TR 4320H', '2014-06-13', '2014-06-19', 0, NULL),
257 (16, 'B-AH 7843H', '2016-05-03', '2016-05-17', 1, NULL),
258 (16, 'B-EW 3478H', '2013-12-18', '2013-12-24', 1, NULL),
259 (16, 'B-EW 3478H', '2014-12-27', '2014-12-31', 1, NULL),
260 (16, 'B-LO 7777H', '2016-08-19', '2016-08-27', 1, NULL),
261 (16, 'B-PO 1265H', '2013-01-07', '2013-01-11', 1, NULL),
262 (16, 'B-PO 1265H', '2015-07-20', '2015-07-26', 0, NULL),
263 (16, 'B-SL 300H', '2017-11-23', '2017-11-30', 1, NULL),
264 (16, 'B-TX 6521H', '2013-12-31', '2014-01-03', 1, NULL),
265 (17, 'B-AF 3952H', '2013-04-18', '2013-05-02', 1, NULL),
266 (17, 'B-ET 324H', '2015-12-10', '2015-12-23', 1, NULL),
267 (17, 'B-LY 7945H', '2014-05-25', '2014-06-02', 1, NULL),
268 (18, 'B-FE 3561H', '2017-01-27', '2017-01-28', 0, NULL),
269 (18, 'B-RT 683H', '2017-09-08', '2017-09-17', 1, NULL),
270 (18, 'B-SL 300H', '2016-11-06', '2016-11-17', 1, NULL),
271 (19, 'B-ET 324H', '2017-01-03', '2017-01-16', 1, NULL),
272 (19, 'B-RT 683H', '2017-12-25', '2017-12-27', 1, NULL),
273 (20, 'B-DB 8787H', '2014-03-28', '2014-04-06', 1, NULL),
274 (20, 'B-E 5438H', '2014-04-09', '2014-04-18', 0, NULL),
275 (20, 'B-ET 324H', '2013-10-11', '2013-10-18', 1, NULL),
276 (21, 'B-AH 7843H', '2017-05-10', '2017-05-18', 1, NULL),
277 (21, 'B-AH 7843H', '2017-07-26', '2017-08-04', 1, NULL),
278 (21, 'B-EW 3478H', '2013-07-26', '2013-08-06', 1, NULL),
279 (21, 'B-SL 300H', '2017-01-24', '2017-01-28', 1, NULL),
280 (21, 'B-VD 649H', '2014-03-15', '2014-03-19', 0, NULL),
281 (22, 'B-AH 7843H', '2016-12-26', '2016-12-31', 1, NULL),
282 (22, 'B-AL 341H', '2018-01-28', '2018-02-06', 1, NULL),
283 (22, 'B-EW 3478H', '2015-08-31', '2015-09-12', 1, NULL),
284 (22, 'B-KL 743H', '2017-03-21', '2017-03-30', 1, NULL),
285 (22, 'B-LO 7777H', '2018-01-25', '2018-01-29', 1, NULL),
286 (22, 'B-PO 1265H', '2012-10-31', '2012-11-10', 1, NULL),
287 (23, 'B-DS 8969H', '2014-02-03', '2014-02-04', 0, NULL),
288 (23, 'B-KL 743H', '2016-07-19', '2016-07-28', 1, NULL),
289 (23, 'B-KL 743H', '2017-11-06', '2017-11-20', 1, NULL),
290 (23, 'B-RT 683H', '2013-07-03', '2013-07-13', 1, NULL),
291 (23, 'B-VX 445H', '2015-10-07', '2015-10-13', 0, NULL),
292 (23, 'B-ZZ 2349H', '2013-01-22', '2013-01-29', 1, NULL),
293 (23, 'B-ZZ 2349H', '2016-06-29', '2016-07-06', 1, NULL),
294 (24, 'B-EW 3478H', '2017-06-05', '2017-06-08', 1, NULL),
295 (24, 'B-LO 7777H', '2014-11-20', '2014-11-29', 1, NULL),
296 (24, 'B-PO 1265H', '2015-06-09', '2015-06-15', 1, NULL),
297 (24, 'B-VD 649H', '2014-05-24', '2014-06-05', 1, NULL),
298 (24, 'B-VX 445H', '2014-07-17', '2014-07-28', 1, NULL),
299 (25, 'B-AF 3952H', '2015-09-12', '2015-09-14', 1, NULL),
300 (25, 'B-E 5438H', '2017-03-27', '2017-04-03', 1, NULL),
301 (25, 'B-LO 7777H', '2013-06-08', '2013-06-20', 1, NULL),
302 (25, 'B-LY 7945H', '2013-03-31', '2013-04-01', 1, NULL),
303 (25, 'B-PO 1265H', '2016-11-20', '2016-11-24', 1, NULL),
304 (25, 'B-RL 9299H', '2017-12-10', '2017-12-13', 1, NULL),
305 (25, 'B-TR 4320H', '2013-01-17', '2013-01-20', 1, NULL),
306 (26, 'B-AH 7843H', '2014-04-11', '2014-04-22', 0, NULL),
307 (26, 'B-LY 7945H', '2014-01-29', '2014-02-07', 1, NULL),
308 (26, 'B-NH 442H', '2016-04-13', '2016-04-21', 1, NULL),
309 (26, 'B-VD 649H', '2016-01-07', '2016-01-18', 1, NULL),
310 (26, 'B-VD 649H', '2016-04-05', '2016-04-13', 1, NULL),
311 (27, 'B-AF 3952H', '2012-10-18', '2012-10-28', 1, NULL),
312 (27, 'B-AH 7843H', '2015-09-21', '2015-10-01', 1, NULL),
313 (27, 'B-DS 8969H', '2017-04-03', '2017-04-11', 1, NULL),
314 (28, 'B-AL 341H', '2017-08-04', '2017-08-13', 1, NULL),
315 (28, 'B-EW 3478H', '2016-04-14', '2016-04-27', 1, NULL),
316 (28, 'B-FE 3561H', '2016-12-21', '2016-12-24', 1, NULL),
317 (28, 'B-MA 554H', '2014-04-29', '2014-05-12', 1, NULL),
318 (28, 'B-RL 9299H', '2016-04-01', '2016-04-03', 1, NULL),
319 (28, 'B-TX 6521H', '2012-12-21', '2013-01-02', 1, NULL),
320 (28, 'B-VX 445H', '2014-10-19', '2014-10-22', 0, NULL),
321 (28, 'B-ZZ 2349H', '2014-07-10', '2014-07-21', 1, NULL),
322 (29, 'B-AF 3952H', '2013-04-08', '2013-04-16', 1, NULL),
323 (29, 'B-AH 7843H', '2013-06-10', '2013-06-12', 1, NULL),
324 (29, 'B-PO 1265H', '2016-05-12', '2016-05-17', 1, NULL),
325 (29, 'B-RL 9299H', '2015-01-26', '2015-02-03', 0, 'Hochzeit'),
326 (29, 'B-VD 649H', '2017-02-28', '2017-03-11', 1, NULL),
327 (30, 'B-E 5438H', '2015-11-13', '2015-11-27', 1, NULL),
328 (30, 'B-LO 7777H', '2012-12-07', '2012-12-15', 0, NULL),
329 (30, 'B-PO 1265H', '2013-06-03', '2013-06-15', 1, NULL),
330 (30, 'B-RL 9299H', '2014-05-03', '2014-05-12', 0, 'Hochzeit'),
331 (30, 'B-RT 683H', '2016-07-16', '2016-07-25', 1, NULL),
332 (31, 'B-AF 3952H', '2018-01-09', '2018-01-20', 1, NULL),
333 (31, 'B-ET 324H', '2017-12-13', '2017-12-18', 1, NULL),
334 (31, 'B-KL 743H', '2012-12-05', '2012-12-13', 1, NULL),
335 (31, 'B-NH 442H', '2017-04-28', '2017-05-01', 1, NULL),
336 (31, 'B-PO 1265H', '2014-02-05', '2014-02-11', 1, NULL),
337 (31, 'B-SL 300H', '2013-02-21', '2013-03-03', 1, NULL),
338 (31, 'B-ZZ 2349H', '2015-03-24', '2015-03-28', 1, NULL),
339 (31, 'B-ZZ 2349H', '2015-06-03', '2015-06-04', 1, NULL),
340 (31, 'B-ZZ 2349H', '2017-11-22', '2017-11-24', 1, NULL),
341 (32, 'B-AH 7843H', '2013-09-20', '2013-09-27', 1, NULL),
342 (32, 'B-ET 324H', '2016-06-02', '2016-06-05', 1, NULL),
343 (32, 'B-MA 554H', '2014-08-12', '2014-08-15', 1, NULL),
344 (32, 'B-RL 9299H', '2013-08-22', '2013-08-30', 1, NULL),
345 (32, 'B-VD 649H', '2014-03-26', '2014-03-30', 1, NULL),
346 (33, 'B-FE 3561H', '2014-03-29', '2014-04-05', 1, NULL),
347 (33, 'B-LO 7777H', '2014-05-24', '2014-06-06', 1, NULL),
348 (33, 'B-MA 554H', '2013-11-25', '2013-12-06', 1, NULL),
349 (33, 'B-NH 442H', '2016-09-28', '2016-09-29', 1, NULL),
350 (33, 'B-RT 683H', '2016-09-07', '2016-09-14', 0, NULL),
351 (33, 'B-VD 649H', '2017-11-09', '2017-11-18', 1, NULL),
352 (33, 'B-VX 445H', '2012-12-15', '2012-12-26', 1, NULL),
353 (33, 'B-VX 445H', '2016-10-06', '2016-10-15', 1, NULL),
354 (34, 'B-AH 7843H', '2014-04-11', '2014-04-14', 1, NULL),
355 (34, 'B-LY 7945H', '2014-06-29', '2014-07-13', 1, NULL),
356 (34, 'B-LY 7945H', '2017-12-21', '2018-01-04', 1, NULL),
357 (34, 'B-SL 300H', '2016-06-05', '2016-06-14', 1, NULL),
358 (34, 'B-TR 4320H', '2015-08-10', '2015-08-19', 1, NULL),
359 (34, 'B-VD 649H', '2014-01-03', '2014-01-09', 1, NULL),
360 (35, 'B-AH 7843H', '2016-05-11', '2016-05-20', 1, NULL),
361 (35, 'B-AH 7843H', '2017-01-06', '2017-01-17', 1, NULL),
362 (35, 'B-E 5438H', '2012-09-20', '2012-10-02', 1, NULL),
363 (35, 'B-FE 3561H', '2014-12-31', '2015-01-13', 1, NULL),
364 (35, 'B-TX 6521H', '2013-12-26', '2013-12-28', 1, NULL),
365 (36, 'B-E 5438H', '2017-04-23', '2017-04-25', 1, NULL),
366 (36, 'B-RL 9299H', '2015-07-19', '2015-08-02', 1, NULL),
367 (37, 'B-DB 8787H', '2018-01-01', '2018-01-14', 1, NULL),
368 (37, 'B-DS 8969H', '2013-05-19', '2013-06-02', 1, NULL),
369 (37, 'B-TR 4320H', '2016-05-27', '2016-06-01', 1, NULL),
370 (37, 'B-VD 649H', '2017-01-13', '2017-01-16', 1, NULL),
371 (37, 'B-VD 649H', '2017-04-20', '2017-04-30', 1, NULL),
372 (37, 'B-VX 445H', '2016-01-04', '2016-01-09', 1, NULL),
373 (38, 'B-AH 7843H', '2017-02-20', '2017-02-27', 1, NULL),
374 (38, 'B-AL 341H', '2017-08-15', '2017-08-23', 1, NULL),
375 (38, 'B-FE 3561H', '2013-05-10', '2013-05-16', 1, NULL),
376 (38, 'B-PO 1265H', '2015-09-17', '2015-09-24', 1, NULL),
377 (38, 'B-VX 445H', '2013-07-25', '2013-08-02', 1, NULL),
378 (39, 'B-DB 8787H', '2017-06-19', '2017-06-22', 1, NULL),
379 (39, 'B-FE 3561H', '2016-08-27', '2016-09-04', 1, NULL),
380 (39, 'B-LO 7777H', '2016-01-12', '2016-01-20', 1, NULL),
381 (39, 'B-SL 300H', '2017-06-24', '2017-07-04', 1, NULL),
382 (39, 'B-TX 6521H', '2016-01-25', '2016-01-30', 1, NULL),
383 (40, 'B-EW 3478H', '2017-07-27', '2017-08-09', 1, NULL),
384 (40, 'B-MA 554H', '2017-06-23', '2017-06-25', 1, NULL),
385 (40, 'B-RL 9299H', '2016-09-12', '2016-09-26', 1, NULL),
386 (40, 'B-RT 683H', '2012-09-05', '2012-09-08', 0, NULL),
387 (41, 'B-AF 3952H', '2013-07-26', '2013-07-27', 1, NULL),
388 (41, 'B-AF 3952H', '2016-09-01', '2016-09-11', 1, NULL),
389 (41, 'B-DS 8969H', '2014-08-06', '2014-08-15', 1, NULL),
390 (41, 'B-E 5438H', '2017-05-08', '2017-05-10', 1, NULL),
391 (41, 'B-NH 442H', '2013-09-13', '2013-09-17', 1, NULL),
392 (41, 'B-RL 9299H', '2014-07-04', '2014-07-08', 1, 'Hochzeit'),
393 (41, 'B-RT 683H', '2014-12-27', '2015-01-04', 1, NULL),
394 (42, 'B-AF 3952H', '2017-04-12', '2017-04-23', 1, NULL),
395 (42, 'B-DS 8969H', '2013-12-13', '2013-12-20', 1, NULL),
396 (43, 'B-DB 8787H', '2017-11-17', '2017-11-24', 1, NULL),
397 (43, 'B-E 5438H', '2016-01-13', '2016-01-27', 1, NULL),
398 (43, 'B-EW 3478H', '2017-12-22', '2018-01-01', 1, NULL),
399 (43, 'B-KL 743H', '2014-11-27', '2014-12-06', 1, NULL),
400 (43, 'B-NH 442H', '2016-05-14', '2016-05-19', 1, NULL),
401 (43, 'B-RL 9299H', '2018-01-04', '2018-01-17', 1, 'Hochzeit'),
402 (43, 'B-SL 300H', '2016-04-06', '2016-04-16', 1, NULL),
403 (44, 'B-DS 8969H', '2013-01-28', '2013-01-30', 1, NULL),
404 (44, 'B-ZZ 2349H', '2012-10-21', '2012-10-31', 0, NULL),
405 (45, 'B-LO 7777H', '2015-05-16', '2015-05-17', 1, NULL),
406 (45, 'B-LO 7777H', '2016-03-26', '2016-04-06', 1, NULL),
407 (45, 'B-LY 7945H', '2014-01-19', '2014-01-27', 1, NULL),
408 (45, 'B-PO 1265H', '2015-12-25', '2015-12-29', 0, NULL),
409 (46, 'B-FE 3561H', '2014-06-16', '2014-06-29', 1, NULL),
410 (46, 'B-LO 7777H', '2012-09-07', '2012-09-08', 1, NULL),
411 (46, 'B-RT 683H', '2016-09-19', '2016-09-25', 1, NULL),
412 (46, 'B-RT 683H', '2017-06-17', '2017-06-25', 1, NULL),
413 (47, 'B-ET 324H', '2013-07-15', '2013-07-25', 1, NULL),
414 (47, 'B-TX 6521H', '2017-05-26', '2017-05-30', 1, NULL),
415 (47, 'B-TX 6521H', '2018-01-08', '2018-01-20', 0, NULL),
416 (47, 'B-VD 649H', '2017-08-04', '2017-08-16', 0, NULL),
417 (47, 'B-ZZ 2349H', '2012-10-15', '2012-10-20', 1, NULL),
418 (47, 'B-ZZ 2349H', '2014-02-20', '2014-02-22', 1, NULL),
419 (48, 'B-DS 8969H', '2017-11-15', '2017-11-16', 1, NULL),
420 (48, 'B-LO 7777H', '2017-02-09', '2017-02-21', 1, NULL),
421 (48, 'B-LY 7945H', '2016-12-13', '2016-12-25', 1, NULL),
422 (48, 'B-TX 6521H', '2013-04-13', '2013-04-26', 1, NULL),
423 (48, 'B-TX 6521H', '2015-10-04', '2015-10-15', 1, NULL),
424 (49, 'B-DB 8787H', '2014-10-02', '2014-10-08', 1, NULL),
425 (49, 'B-FE 3561H', '2013-01-29', '2013-01-30', 1, NULL),
426 (49, 'B-MA 554H', '2014-05-19', '2014-05-20', 1, NULL),
427 (49, 'B-NH 442H', '2013-11-07', '2013-11-08', 1, NULL),
428 (49, 'B-PO 1265H', '2013-05-28', '2013-06-07', 1, NULL),
429 (49, 'B-RL 9299H', '2017-02-22', '2017-02-25', 1, NULL),
430 (49, 'B-VD 649H', '2013-12-26', '2013-12-31', 1, NULL),
431 (49, 'B-VD 649H', '2017-07-06', '2017-07-17', 1, NULL),
432 (49, 'B-ZZ 2349H', '2015-09-11', '2015-09-14', 1, NULL),
433 (50, 'B-AF 3952H', '2012-10-03', '2012-10-10', 1, NULL),
434 (50, 'B-DS 8969H', '2015-08-03', '2015-08-11', 1, NULL),
435 (50, 'B-ET 324H', '2016-02-17', '2016-02-22', 1, NULL),
436 (50, 'B-EW 3478H', '2013-05-12', '2013-05-23', 1, NULL),
437 (50, 'B-FE 3561H', '2013-07-03', '2013-07-08', 1, NULL),
438 (50, 'B-FE 3561H', '2015-08-05', '2015-08-17', 1, NULL),
439 (50, 'B-LY 7945H', '2013-02-20', '2013-03-02', 1, NULL),
440 (50, 'B-LY 7945H', '2016-05-30', '2016-06-12', 1, NULL),
441 (50, 'B-PO 1265H', '2014-08-16', '2014-08-28', 1, NULL),
442 (50, 'B-VX 445H', '2016-06-04', '2016-06-12', 1, NULL),
443 (51, 'B-E 5438H', '2014-02-01', '2014-02-15', 0, NULL),
444 (51, 'B-LO 7777H', '2017-03-07', '2017-03-11', 1, NULL),
445 (51, 'B-LY 7945H', '2012-10-10', '2012-10-23', 1, NULL),
446 (51, 'B-VD 649H', '2014-07-16', '2014-07-19', 1, NULL),
447 (52, 'B-AF 3952H', '2016-05-20', '2016-05-27', 1, NULL),
448 (52, 'B-AL 341H', '2013-07-06', '2013-07-08', 1, NULL),
449 (52, 'B-DB 8787H', '2018-01-04', '2018-01-11', 1, NULL),
450 (52, 'B-KL 743H', '2013-07-30', '2013-08-02', 1, NULL),
451 (52, 'B-NH 442H', '2017-01-25', '2017-02-02', 1, NULL),
452 (52, 'B-ZZ 2349H', '2018-01-31', '2018-02-13', 1, NULL),
453 (53, 'B-DB 8787H', '2016-12-10', '2016-12-24', 0, NULL),
454 (53, 'B-NH 442H', '2016-03-20', '2016-03-23', 0, NULL),
455 (54, 'B-DS 8969H', '2013-04-17', '2013-04-29', 1, NULL),
456 (54, 'B-ET 324H', '2015-10-07', '2015-10-20', 1, NULL),
457 (54, 'B-KL 743H', '2014-06-21', '2014-06-29', 1, NULL),
458 (54, 'B-MA 554H', '2014-08-13', '2014-08-20', 1, NULL),
459 (54, 'B-MA 554H', '2015-11-13', '2015-11-16', 1, NULL),
460 (54, 'B-SL 300H', '2016-10-29', '2016-11-11', 1, NULL),
461 (55, 'B-AH 7843H', '2017-02-03', '2017-02-17', 1, NULL),
462 (55, 'B-E 5438H', '2012-10-19', '2012-10-25', 1, NULL),
463 (55, 'B-EW 3478H', '2017-09-10', '2017-09-14', 1, NULL),
464 (55, 'B-KL 743H', '2017-07-13', '2017-07-27', 1, NULL),
465 (55, 'B-LO 7777H', '2013-01-17', '2013-01-28', 1, NULL),
466 (55, 'B-LY 7945H', '2013-07-05', '2013-07-17', 0, NULL),
467 (55, 'B-SL 300H', '2015-05-24', '2015-05-25', 1, NULL),
468 (56, 'B-DB 8787H', '2017-04-01', '2017-04-04', 1, NULL),
469 (56, 'B-ET 324H', '2012-10-30', '2012-11-09', 1, NULL),
470 (56, 'B-EW 3478H', '2014-05-11', '2014-05-23', 1, NULL),
471 (56, 'B-RL 9299H', '2013-12-19', '2013-12-31', 1, NULL),
472 (57, 'B-AF 3952H', '2013-08-30', '2013-09-12', 1, NULL),
473 (57, 'B-DS 8969H', '2016-04-12', '2016-04-24', 1, NULL),
474 (57, 'B-E 5438H', '2013-10-27', '2013-10-28', 1, NULL),
475 (57, 'B-MA 554H', '2017-02-16', '2017-03-01', 1, NULL),
476 (57, 'B-RT 683H', '2016-05-21', '2016-06-01', 0, NULL),
477 (58, 'B-AF 3952H', '2014-07-13', '2014-07-15', 1, NULL),
478 (58, 'B-AF 3952H', '2014-11-27', '2014-12-09', 1, NULL),
479 (58, 'B-LO 7777H', '2015-12-21', '2015-12-22', 1, NULL),
480 (58, 'B-LY 7945H', '2012-10-13', '2012-10-25', 1, NULL),
481 (58, 'B-RT 683H', '2013-09-07', '2013-09-19', 1, NULL),
482 (58, 'B-VX 445H', '2014-03-13', '2014-03-14', 1, NULL),
483 (58, 'B-VX 445H', '2015-05-05', '2015-05-17', 1, NULL),
484 (59, 'B-DS 8969H', '2013-12-03', '2013-12-08', 1, NULL),
485 (59, 'B-E 5438H', '2013-07-27', '2013-08-09', 1, NULL),
486 (59, 'B-KL 743H', '2013-09-22', '2013-10-05', 1, NULL),
487 (59, 'B-LO 7777H', '2017-01-17', '2017-01-30', 1, NULL),
488 (59, 'B-PO 1265H', '2014-09-17', '2014-09-20', 1, NULL),
489 (60, 'B-DB 8787H', '2014-08-29', '2014-09-07', 1, NULL),
490 (60, 'B-E 5438H', '2014-06-05', '2014-06-07', 1, NULL),
491 (60, 'B-EW 3478H', '2012-11-28', '2012-12-07', 1, NULL),
492 (60, 'B-TR 4320H', '2015-06-27', '2015-07-07', 1, NULL),
493 (61, 'B-AH 7843H', '2015-02-21', '2015-02-27', 1, NULL),
494 (61, 'B-AL 341H', '2012-10-26', '2012-10-30', 1, NULL),
495 (61, 'B-DB 8787H', '2013-01-18', '2013-01-28', 1, NULL),
496 (61, 'B-EW 3478H', '2017-04-15', '2017-04-18', 0, NULL),
497 (61, 'B-FE 3561H', '2017-04-30', '2017-05-04', 1, NULL),
498 (61, 'B-KL 743H', '2013-12-25', '2013-12-27', 1, NULL),
499 (61, 'B-LY 7945H', '2017-02-19', '2017-03-01', 1, NULL),
500 (61, 'B-NH 442H', '2017-12-09', '2017-12-11', 1, NULL),
501 (61, 'B-TR 4320H', '2015-05-21', '2015-05-30', 1, NULL),
502 (62, 'B-KL 743H', '2013-11-22', '2013-12-05', 1, NULL),
503 (62, 'B-LY 7945H', '2014-04-23', '2014-05-07', 1, NULL),
504 (62, 'B-TX 6521H', '2014-09-16', '2014-09-21', 1, NULL),
505 (62, 'B-ZZ 2349H', '2013-12-23', '2014-01-06', 1, NULL),
506 (63, 'B-AF 3952H', '2017-04-15', '2017-04-26', 1, NULL),
507 (63, 'B-ET 324H', '2015-06-25', '2015-07-09', 1, NULL),
508 (63, 'B-ET 324H', '2015-09-28', '2015-10-09', 1, NULL),
509 (63, 'B-FE 3561H', '2012-12-07', '2012-12-17', 1, NULL),
510 (63, 'B-NH 442H', '2016-02-07', '2016-02-10', 0, NULL),
511 (63, 'B-RL 9299H', '2014-04-22', '2014-04-28', 1, NULL),
512 (63, 'B-SL 300H', '2014-06-17', '2014-06-30', 1, NULL),
513 (63, 'B-TR 4320H', '2015-03-03', '2015-03-07', 1, NULL),
514 (63, 'B-ZZ 2349H', '2012-10-13', '2012-10-24', 1, NULL),
515 (64, 'B-E 5438H', '2013-07-22', '2013-08-04', 1, NULL),
516 (64, 'B-ET 324H', '2014-10-19', '2014-10-21', 0, NULL),
517 (64, 'B-EW 3478H', '2014-05-28', '2014-05-31', 1, NULL),
518 (64, 'B-EW 3478H', '2018-01-22', '2018-02-04', 1, NULL),
519 (64, 'B-FE 3561H', '2016-06-12', '2016-06-15', 0, NULL),
520 (64, 'B-LO 7777H', '2014-02-26', '2014-02-28', 1, NULL),
521 (64, 'B-LY 7945H', '2014-05-13', '2014-05-25', 1, NULL),
522 (64, 'B-RL 9299H', '2015-06-22', '2015-06-27', 1, NULL),
523 (64, 'B-VD 649H', '2016-08-06', '2016-08-13', 1, NULL),
524 (65, 'B-AH 7843H', '2017-06-30', '2017-07-14', 1, NULL),
525 (65, 'B-MA 554H', '2014-08-11', '2014-08-25', 1, NULL),
526 (65, 'B-PO 1265H', '2012-10-13', '2012-10-25', 1, NULL),
527 (65, 'B-PO 1265H', '2017-04-07', '2017-04-12', 1, NULL),
528 (65, 'B-RL 9299H', '2013-10-26', '2013-11-02', 1, NULL),
529 (65, 'B-SL 300H', '2016-06-06', '2016-06-18', 1, NULL),
530 (65, 'B-SL 300H', '2017-05-06', '2017-05-08', 1, NULL),
531 (65, 'B-VX 445H', '2017-11-22', '2017-11-27', 1, NULL),
532 (66, 'B-AF 3952H', '2015-06-06', '2015-06-12', 1, NULL),
533 (66, 'B-AL 341H', '2013-08-27', '2013-08-30', 1, NULL),
534 (66, 'B-AL 341H', '2016-08-02', '2016-08-14', 1, NULL),
535 (66, 'B-AL 341H', '2017-07-13', '2017-07-18', 1, NULL),
536 (66, 'B-KL 743H', '2017-03-01', '2017-03-06', 1, NULL),
537 (67, 'B-DS 8969H', '2015-02-28', '2015-03-12', 1, NULL),
538 (67, 'B-RL 9299H', '2013-08-21', '2013-08-28', 1, NULL),
539 (67, 'B-VD 649H', '2017-02-11', '2017-02-13', 1, NULL),
540 (68, 'B-ET 324H', '2015-04-22', '2015-04-27', 1, NULL),
541 (68, 'B-PO 1265H', '2014-07-22', '2014-07-24', 1, NULL),
542 (68, 'B-PO 1265H', '2016-11-18', '2016-11-30', 1, NULL),
543 (68, 'B-TR 4320H', '2015-08-04', '2015-08-15', 1, NULL),
544 (68, 'B-VD 649H', '2015-04-26', '2015-05-10', 1, NULL),
545 (69, 'B-AH 7843H', '2014-01-24', '2014-02-05', 0, NULL),
546 (69, 'B-NH 442H', '2016-09-21', '2016-09-22', 1, NULL),
547 (69, 'B-SL 300H', '2016-12-24', '2017-01-01', 1, NULL),
548 (69, 'B-ZZ 2349H', '2018-01-08', '2018-01-11', 1, NULL),
549 (70, 'B-AF 3952H', '2012-08-17', '2012-08-28', 1, NULL),
550 (70, 'B-AF 3952H', '2017-10-07', '2017-10-09', 1, NULL),
551 (70, 'B-NH 442H', '2016-04-13', '2016-04-15', 1, NULL),
552 (70, 'B-VX 445H', '2015-05-09', '2015-05-19', 1, NULL),
553 (70, 'B-ZZ 2349H', '2012-08-17', '2012-08-20', 1, NULL),
554 (71, 'B-PO 1265H', '2014-08-15', '2014-08-21', 1, NULL),
555 (71, 'B-TR 4320H', '2016-06-03', '2016-06-17', 1, NULL),
556 (72, 'B-AF 3952H', '2015-05-29', '2015-06-08', 1, NULL),
557 (72, 'B-DB 8787H', '2016-02-05', '2016-02-07', 1, NULL),
558 (72, 'B-DS 8969H', '2016-03-24', '2016-03-25', 1, NULL),
559 (72, 'B-FE 3561H', '2012-12-01', '2012-12-15', 1, NULL),
560 (72, 'B-LY 7945H', '2015-05-18', '2015-05-27', 1, NULL),
561 (72, 'B-VD 649H', '2017-10-26', '2017-10-28', 1, NULL),
562 (73, 'B-FE 3561H', '2013-10-10', '2013-10-14', 0, NULL),
563 (73, 'B-FE 3561H', '2015-01-19', '2015-01-21', 1, NULL),
564 (73, 'B-LO 7777H', '2012-12-28', '2012-12-30', 1, NULL),
565 (74, 'B-AH 7843H', '2015-02-17', '2015-03-01', 1, NULL),
566 (74, 'B-ET 324H', '2014-04-27', '2014-05-01', 1, NULL),
567 (74, 'B-VX 445H', '2017-10-11', '2017-10-23', 1, NULL),
568 (74, 'B-ZZ 2349H', '2015-02-08', '2015-02-09', 1, NULL),
569 (75, 'B-AL 341H', '2014-06-19', '2014-06-20', 1, NULL),
570 (75, 'B-EW 3478H', '2017-11-30', '2017-12-11', 1, NULL),
571 (75, 'B-LY 7945H', '2015-03-16', '2015-03-28', 1, NULL),
572 (75, 'B-NH 442H', '2013-02-14', '2013-02-27', 1, NULL),
573 (75, 'B-RL 9299H', '2016-01-26', '2016-02-05', 1, 'Hochzeit'),
574 (75, 'B-VD 649H', '2015-05-21', '2015-05-30', 1, NULL),
575 (75, 'B-ZZ 2349H', '2014-08-23', '2014-09-03', 1, NULL),
576 (76, 'B-ET 324H', '2013-04-15', '2013-04-21', 1, NULL),
577 (76, 'B-EW 3478H', '2017-07-18', '2017-07-21', 1, NULL),
578 (76, 'B-NH 442H', '2013-06-05', '2013-06-13', 1, NULL),
579 (76, 'B-RT 683H', '2015-06-12', '2015-06-13', 1, NULL),
580 (76, 'B-TX 6521H', '2016-08-31', '2016-09-02', 1, NULL),
581 (77, 'B-DB 8787H', '2017-12-22', '2017-12-26', 1, NULL),
582 (77, 'B-EW 3478H', '2014-03-06', '2014-03-10', 1, NULL),
583 (77, 'B-MA 554H', '2014-12-22', '2015-01-05', 1, NULL),
584 (77, 'B-SL 300H', '2014-01-06', '2014-01-12', 1, NULL),
585 (78, 'B-AH 7843H', '2015-12-28', '2015-12-31', 1, NULL),
586 (78, 'B-MA 554H', '2014-12-29', '2015-01-06', 1, NULL),
587 (78, 'B-NH 442H', '2015-06-14', '2015-06-28', 1, NULL),
588 (78, 'B-NH 442H', '2016-11-17', '2016-11-18', 1, NULL),
589 (78, 'B-RL 9299H', '2016-10-27', '2016-11-07', 0, 'Hochzeit'),
590 (78, 'B-RT 683H', '2017-10-14', '2017-10-28', 1, NULL),
591 (78, 'B-RT 683H', '2017-10-20', '2017-10-31', 1, NULL),
592 (78, 'B-SL 300H', '2017-11-30', '2017-12-02', 1, NULL),
593 (78, 'B-TX 6521H', '2017-01-03', '2017-01-10', 0, NULL),
594 (78, 'B-ZZ 2349H', '2014-10-10', '2014-10-12', 1, NULL),
595 (79, 'B-AF 3952H', '2016-05-02', '2016-05-07', 1, NULL),
596 (79, 'B-EW 3478H', '2014-10-06', '2014-10-07', 1, NULL),
597 (79, 'B-MA 554H', '2015-12-07', '2015-12-12', 1, NULL),
598 (80, 'B-AF 3952H', '2015-09-27', '2015-10-09', 1, NULL),
599 (80, 'B-PO 1265H', '2016-11-30', '2016-12-11', 1, NULL),
600 (81, 'B-FE 3561H', '2013-10-24', '2013-10-27', 1, NULL),
601 (81, 'B-RL 9299H', '2015-04-02', '2015-04-04', 1, 'Hochzeit'),
602 (81, 'B-TR 4320H', '2017-10-27', '2017-11-10', 1, NULL),
603 (81, 'B-TX 6521H', '2013-05-20', '2013-06-03', 1, NULL),
604 (82, 'B-VX 445H', '2015-04-05', '2015-04-16', 0, NULL),
605 (83, 'B-DS 8969H', '2017-03-14', '2017-03-18', 1, NULL),
606 (83, 'B-ET 324H', '2017-01-16', '2017-01-23', 1, NULL),
607 (83, 'B-TR 4320H', '2017-09-26', '2017-09-29', 1, NULL),
608 (83, 'B-VX 445H', '2015-11-08', '2015-11-19', 0, NULL),
609 (84, 'B-E 5438H', '2015-09-30', '2015-10-06', 0, NULL),
610 (84, 'B-LY 7945H', '2013-06-02', '2013-06-16', 1, NULL),
611 (84, 'B-NH 442H', '2016-05-09', '2016-05-19', 1, NULL),
612 (84, 'B-RT 683H', '2012-11-19', '2012-11-27', 1, NULL),
613 (84, 'B-SL 300H', '2018-01-24', '2018-02-06', 1, NULL),
614 (84, 'B-TR 4320H', '2015-05-07', '2015-05-12', 0, NULL),
615 (85, 'B-DB 8787H', '2014-05-11', '2014-05-25', 1, NULL),
616 (85, 'B-FE 3561H', '2015-08-26', '2015-09-08', 1, NULL),
617 (85, 'B-KL 743H', '2014-10-07', '2014-10-17', 1, NULL),
618 (85, 'B-MA 554H', '2015-06-08', '2015-06-15', 1, NULL),
619 (85, 'B-PO 1265H', '2015-04-03', '2015-04-17', 1, NULL),
620 (85, 'B-RL 9299H', '2016-09-07', '2016-09-21', 1, NULL),
621 (85, 'B-RL 9299H', '2017-03-25', '2017-04-04', 1, NULL),
622 (85, 'B-TX 6521H', '2015-04-29', '2015-05-02', 1, NULL),
623 (86, 'B-AL 341H', '2014-07-13', '2014-07-20', 1, NULL),
624 (86, 'B-AL 341H', '2016-03-30', '2016-03-31', 1, NULL),
625 (86, 'B-LY 7945H', '2017-09-07', '2017-09-09', 1, NULL),
626 (86, 'B-NH 442H', '2012-08-15', '2012-08-28', 1, NULL),
627 (86, 'B-RL 9299H', '2017-12-11', '2017-12-16', 1, 'Hochzeit'),
628 (87, 'B-E 5438H', '2014-02-11', '2014-02-18', 1, NULL),
629 (87, 'B-TR 4320H', '2015-11-11', '2015-11-25', 1, NULL),
630 (88, 'B-AL 341H', '2015-06-13', '2015-06-14', 1, NULL),
631 (88, 'B-DS 8969H', '2013-01-31', '2013-02-10', 1, NULL),
632 (88, 'B-DS 8969H', '2015-05-10', '2015-05-18', 0, NULL),
633 (88, 'B-EW 3478H', '2015-09-18', '2015-09-25', 1, NULL),
634 (88, 'B-MA 554H', '2017-11-25', '2017-12-01', 1, NULL),
635 (88, 'B-VD 649H', '2013-11-12', '2013-11-19', 1, NULL),
636 (88, 'B-VX 445H', '2018-01-23', '2018-01-28', 1, NULL),
637 (88, 'B-ZZ 2349H', '2016-01-18', '2016-02-01', 1, NULL),
638 (89, 'B-EW 3478H', '2015-01-24', '2015-01-25', 1, NULL),
639 (89, 'B-EW 3478H', '2015-05-31', '2015-06-09', 1, NULL),
640 (89, 'B-FE 3561H', '2016-04-19', '2016-04-24', 1, NULL),
641 (89, 'B-LO 7777H', '2013-07-21', '2013-07-22', 1, NULL),
642 (89, 'B-LO 7777H', '2014-12-21', '2014-12-24', 1, NULL),
643 (89, 'B-MA 554H', '2015-02-16', '2015-02-20', 1, NULL),
644 (89, 'B-RL 9299H', '2014-03-04', '2014-03-17', 1, NULL),
645 (90, 'B-AH 7843H', '2014-12-23', '2014-12-28', 1, NULL),
646 (90, 'B-DS 8969H', '2015-03-02', '2015-03-09', 1, NULL),
647 (90, 'B-EW 3478H', '2016-11-08', '2016-11-16', 1, NULL),
648 (90, 'B-KL 743H', '2015-05-11', '2015-05-24', 1, NULL),
649 (90, 'B-LO 7777H', '2014-09-20', '2014-09-26', 1, NULL),
650 (90, 'B-TR 4320H', '2015-07-13', '2015-07-20', 1, NULL),
651 (91, 'B-AL 341H', '2013-09-04', '2013-09-18', 1, NULL),
652 (91, 'B-MA 554H', '2016-02-17', '2016-03-03', 1, NULL),
653 (91, 'B-MA 554H', '2017-11-08', '2017-11-20', 1, NULL),
654 (91, 'B-NH 442H', '2016-05-16', '2016-05-29', 1, NULL),
655 (91, 'B-TR 4320H', '2012-12-31', '2013-01-08', 1, NULL),
656 (91, 'B-TX 6521H', '2013-06-03', '2013-06-10', 0, NULL),
657 (91, 'B-TX 6521H', '2017-08-09', '2017-08-12', 1, NULL),
658 (92, 'B-AL 341H', '2017-05-26', '2017-05-31', 1, NULL),
659 (92, 'B-EW 3478H', '2017-02-27', '2017-03-01', 1, NULL),
660 (92, 'B-SL 300H', '2014-09-13', '2014-09-14', 1, NULL),
661 (93, 'B-DB 8787H', '2013-03-28', '2013-04-07', 1, NULL),
662 (93, 'B-LO 7777H', '2017-07-11', '2017-07-19', 1, NULL),
663 (93, 'B-VX 445H', '2016-08-21', '2016-08-31', 1, NULL),
664 (94, 'B-AF 3952H', '2016-04-18', '2016-04-28', 1, NULL),
665 (94, 'B-AL 341H', '2013-06-16', '2013-06-24', 1, NULL),
666 (94, 'B-AL 341H', '2017-06-22', '2017-07-03', 1, NULL),
667 (94, 'B-LO 7777H', '2015-11-23', '2015-12-07', 1, NULL),
668 (94, 'B-VD 649H', '2013-01-29', '2013-02-02', 1, NULL),
669 (95, 'B-AH 7843H', '2013-03-24', '2013-03-31', 1, NULL),
670 (95, 'B-AL 341H', '2016-11-09', '2016-11-11', 1, NULL),
671 (95, 'B-ET 324H', '2013-12-14', '2013-12-19', 1, NULL),
672 (95, 'B-FE 3561H', '2014-01-18', '2014-01-20', 1, NULL),
673 (95, 'B-RL 9299H', '2013-05-15', '2013-05-27', 1, NULL),
674 (95, 'B-VX 445H', '2015-03-03', '2015-03-04', 1, NULL),
675 (95, 'B-ZZ 2349H', '2016-03-13', '2016-03-16', 1, NULL),
676 (96, 'B-KL 743H', '2013-09-20', '2013-09-26', 1, NULL),
677 (96, 'B-KL 743H', '2014-08-27', '2014-09-02', 1, NULL),
678 (97, 'B-AL 341H', '2012-12-08', '2012-12-16', 1, NULL),
679 (97, 'B-EW 3478H', '2015-05-08', '2015-05-10', 1, NULL),
680 (97, 'B-FE 3561H', '2016-04-20', '2016-04-21', 1, NULL),
681 (97, 'B-VX 445H', '2014-11-20', '2014-11-24', 1, NULL),
682 (98, 'B-LO 7777H', '2013-09-02', '2013-09-05', 1, NULL),
683 (98, 'B-LO 7777H', '2017-12-18', '2017-12-20', 1, NULL),
684 (98, 'B-SL 300H', '2016-05-16', '2016-05-17', 1, NULL),
685 (99, 'B-FE 3561H', '2013-09-03', '2013-09-11', 0, NULL),
686 (99, 'B-MA 554H', '2017-04-08', '2017-04-14', 1, NULL),
687 (99, 'B-TR 4320H', '2016-04-29', '2016-05-07', 1, NULL),
688 (100, 'B-E 5438H', '2016-01-08', '2016-01-19', 1, NULL),
689 (100, 'B-KL 743H', '2016-01-01', '2016-01-09', 1, NULL),
690 (100, 'B-LY 7945H', '2017-12-05', '2017-12-14', 1, NULL),
691 (100, 'B-MA 554H', '2014-12-31', '2015-01-07', 1, NULL),
692 (100, 'B-PO 1265H', '2014-06-04', '2014-06-10', 1, NULL),
693 (100, 'B-RT 683H', '2017-04-14', '2017-04-22', 1, NULL),
694 (100, 'B-SL 300H', '2012-12-15', '2012-12-17', 1, NULL),
695 (100, 'B-VD 649H', '2016-08-10', '2016-08-11', 1, NULL),
696 (100, 'B-VD 649H', '2017-02-24', '2017-02-27', 1, NULL),
697 (100, 'B-ZZ 2349H', '2017-06-10', '2017-06-19', 1, NULL),
698 (101, 'B-DB 8787H', '2017-01-22', '2017-02-04', 1, NULL),
699 (101, 'B-DS 8969H', '2015-03-09', '2015-03-10', 1, NULL),
700 (101, 'B-FE 3561H', '2015-03-26', '2015-04-08', 1, NULL),
701 (101, 'B-FE 3561H', '2017-04-12', '2017-04-14', 1, NULL),
702 (101, 'B-PO 1265H', '2013-02-12', '2013-02-15', 1, NULL),
703 (101, 'B-RT 683H', '2015-08-21', '2015-08-23', 0, NULL),
704 (102, 'B-AF 3952H', '2013-01-30', '2013-02-03', 1, NULL),
705 (102, 'B-AF 3952H', '2016-03-02', '2016-03-16', 1, NULL),
706 (102, 'B-AF 3952H', '2017-01-25', '2017-01-28', 1, NULL),
707 (102, 'B-AH 7843H', '2012-11-19', '2012-11-23', 1, NULL),
708 (102, 'B-ET 324H', '2013-11-23', '2013-12-07', 1, NULL),
709 (102, 'B-FE 3561H', '2014-06-14', '2014-06-28', 1, NULL),
710 (102, 'B-SL 300H', '2017-12-16', '2017-12-24', 0, NULL),
711 (103, 'B-AL 341H', '2016-09-20', '2016-09-29', 0, NULL),
712 (103, 'B-TR 4320H', '2015-10-08', '2015-10-16', 1, NULL),
713 (103, 'B-TX 6521H', '2013-05-22', '2013-06-03', 1, NULL),
714 (103, 'B-TX 6521H', '2017-08-07', '2017-08-20', 1, NULL),
715 (104, 'B-EW 3478H', '2013-07-03', '2013-07-11', 1, NULL),
716 (104, 'B-KL 743H', '2014-12-04', '2014-12-14', 1, NULL),
717 (104, 'B-NH 442H', '2012-08-23', '2012-09-04', 1, NULL),
718 (105, 'B-AF 3952H', '2017-08-23', '2017-08-25', 1, NULL),
719 (105, 'B-E 5438H', '2016-04-05', '2016-04-08', 1, NULL),
720 (105, 'B-RT 683H', '2018-01-08', '2018-01-21', 1, NULL),
721 (106, 'B-AL 341H', '2017-12-13', '2017-12-14', 1, NULL),
722 (106, 'B-LO 7777H', '2016-08-20', '2016-08-29', 1, NULL),
723 (106, 'B-MA 554H', '2017-02-27', '2017-03-12', 1, NULL),
724 (106, 'B-RL 9299H', '2017-10-25', '2017-11-01', 1, NULL),
725 (106, 'B-VD 649H', '2016-11-23', '2016-12-02', 1, NULL),
726 (106, 'B-ZZ 2349H', '2013-10-13', '2013-10-18', 1, NULL),
727 (107, 'B-AL 341H', '2017-05-09', '2017-05-17', 1, NULL),
728 (107, 'B-TR 4320H', '2013-03-28', '2013-04-01', 1, NULL),
729 (108, 'B-AL 341H', '2013-12-15', '2013-12-27', 1, NULL),
730 (108, 'B-PO 1265H', '2013-07-15', '2013-07-21', 1, NULL),
731 (108, 'B-RL 9299H', '2014-10-04', '2014-10-08', 0, NULL),
732 (108, 'B-VD 649H', '2017-11-24', '2017-12-03', 1, NULL),
733 (109, 'B-AH 7843H', '2014-12-08', '2014-12-11', 1, NULL),
734 (109, 'B-E 5438H', '2013-09-13', '2013-09-14', 1, NULL),
735 (109, 'B-ET 324H', '2016-07-19', '2016-07-23', 1, NULL),
736 (109, 'B-KL 743H', '2015-10-18', '2015-10-28', 1, NULL),
737 (109, 'B-RL 9299H', '2014-11-27', '2014-12-07', 1, 'Hochzeit'),
738 (110, 'B-KL 743H', '2014-11-18', '2014-11-23', 1, NULL),
739 (110, 'B-LO 7777H', '2013-03-02', '2013-03-04', 1, NULL),
740 (110, 'B-RT 683H', '2015-11-01', '2015-11-03', 0, NULL),
741 (111, 'B-AH 7843H', '2015-03-10', '2015-03-19', 1, NULL),
742 (111, 'B-DB 8787H', '2017-08-28', '2017-09-02', 1, NULL),
743 (111, 'B-DS 8969H', '2014-07-15', '2014-07-23', 1, NULL),
744 (111, 'B-LO 7777H', '2014-12-06', '2014-12-18', 1, NULL),
745 (111, 'B-TR 4320H', '2016-04-16', '2016-04-20', 0, NULL),
746 (111, 'B-VD 649H', '2016-08-25', '2016-09-06', 1, NULL),
747 (111, 'B-VX 445H', '2013-10-08', '2013-10-10', 1, NULL),
748 (112, 'B-E 5438H', '2015-01-04', '2015-01-05', 1, NULL),
749 (113, 'B-AH 7843H', '2016-03-07', '2016-03-13', 1, NULL),
750 (113, 'B-ET 324H', '2012-10-10', '2012-10-17', 1, NULL),
751 (113, 'B-LO 7777H', '2013-01-14', '2013-01-28', 1, NULL),
752 (113, 'B-MA 554H', '2012-11-28', '2012-12-07', 1, NULL),
753 (113, 'B-MA 554H', '2017-04-18', '2017-05-02', 1, NULL),
754 (113, 'B-NH 442H', '2017-03-04', '2017-03-05', 1, NULL),
755 (113, 'B-PO 1265H', '2015-02-11', '2015-02-18', 1, NULL),
756 (114, 'B-AF 3952H', '2014-07-11', '2014-07-22', 1, NULL),
757 (114, 'B-SL 300H', '2015-09-23', '2015-10-04', 1, NULL),
758 (114, 'B-VD 649H', '2014-03-02', '2014-03-07', 1, NULL),
759 (114, 'B-VX 445H', '2013-09-24', '2013-09-30', 1, NULL),
760 (115, 'B-DB 8787H', '2015-12-02', '2015-12-09', 1, NULL),
761 (115, 'B-EW 3478H', '2012-12-02', '2012-12-03', 0, NULL),
762 (115, 'B-NH 442H', '2015-06-26', '2015-07-08', 1, NULL),
763 (115, 'B-NH 442H', '2017-12-02', '2017-12-03', 1, NULL),
764 (116, 'B-PO 1265H', '2012-12-31', '2013-01-08', 1, NULL),
765 (116, 'B-SL 300H', '2017-03-05', '2017-03-09', 1, NULL),
766 (116, 'B-TX 6521H', '2017-07-01', '2017-07-09', 1, NULL),
767 (117, 'B-MA 554H', '2012-11-27', '2012-12-11', 1, NULL),
768 (117, 'B-RL 9299H', '2014-12-30', '2015-01-13', 1, 'Hochzeit'),
769 (117, 'B-TR 4320H', '2016-03-29', '2016-04-12', 1, NULL),
770 (118, 'B-AH 7843H', '2017-10-11', '2017-10-23', 1, NULL),
771 (118, 'B-ET 324H', '2014-06-29', '2014-07-04', 1, NULL),
772 (118, 'B-LO 7777H', '2016-07-07', '2016-07-09', 1, NULL),
773 (118, 'B-LY 7945H', '2012-09-09', '2012-09-10', 0, NULL),
774 (118, 'B-PO 1265H', '2017-04-29', '2017-05-02', 1, NULL),
775 (118, 'B-RT 683H', '2014-04-25', '2014-05-01', 1, NULL),
776 (118, 'B-TR 4320H', '2016-03-24', '2016-03-29', 1, NULL),
777 (119, 'B-AF 3952H', '2013-12-21', '2013-12-23', 1, NULL),
778 (119, 'B-PO 1265H', '2013-12-12', '2013-12-15', 1, NULL),
779 (119, 'B-RL 9299H', '2014-01-13', '2014-01-20', 1, NULL),
780 (119, 'B-VX 445H', '2016-09-18', '2016-10-01', 1, NULL),
781 (119, 'B-ZZ 2349H', '2016-12-10', '2016-12-11', 1, NULL),
782 (119, 'B-ZZ 2349H', '2017-05-25', '2017-05-30', 1, NULL),
783 (120, 'B-EW 3478H', '2014-06-08', '2014-06-21', 1, NULL),
784 (120, 'B-LY 7945H', '2017-08-15', '2017-08-19', 1, NULL);
785/*!40000 ALTER TABLE `mieten` ENABLE KEYS */;
786
787-- Exportiere Struktur von Tabelle flottekiste2018.oldtimer
788CREATE TABLE IF NOT EXISTS `oldtimer` (
789 `Kennzeichen` char(10) NOT NULL DEFAULT '',
790 `Typ` char(15) DEFAULT NULL,
791 `Hersteller` char(15) DEFAULT NULL,
792 `Hubraum` int(11) DEFAULT NULL,
793 `PS` int(11) DEFAULT NULL,
794 `Baujahr` year(4) DEFAULT NULL,
795 `Tagespreis` decimal(5,2) DEFAULT NULL,
796 PRIMARY KEY (`Kennzeichen`)
797) ENGINE=InnoDB DEFAULT CHARSET=latin1;
798
799-- Exportiere Daten aus Tabelle flottekiste2018.oldtimer: ~23 rows (ungefähr)
800/*!40000 ALTER TABLE `oldtimer` DISABLE KEYS */;
801INSERT INTO `oldtimer` (`Kennzeichen`, `Typ`, `Hersteller`, `Hubraum`, `PS`, `Baujahr`, `Tagespreis`) VALUES
802 ('B-AF 3952H', '500B - Topolino', 'Fiat', 500, 23, '1948', 34.00),
803 ('B-AH 7843H', '100 SIX', 'Austin-Healey', 2700, 140, '1953', 55.55),
804 ('B-AL 341H', '6 C 1500 Super', 'Alfa Romeo', 1500, 76, '1928', 45.90),
805 ('B-DB 8787H', '540 K', 'Mercedes-Benz', 5398, 180, '1939', 54.00),
806 ('B-DS 8969H', 'DS 19', 'Citroen', 1349, 68, '1956', 40.00),
807 ('B-E 5438H', 'G4', 'Ginetta', 997, 85, '1960', 40.00),
808 ('B-ET 324H', 'Traction Avant', 'Citroen', 1299, 34, '1936', 34.00),
809 ('B-EW 3478H', '212 Barchetta', 'Ferrari', 1890, 188, '1951', 68.50),
810 ('B-FE 3561H', '3500 GT', 'Maserati', 3500, 192, '1958', 50.00),
811 ('B-KL 743H', '328', 'BMW', 2000, 80, '1936', 48.70),
812 ('B-LO 7777H', 'Seven', 'Lotus', 1600, 85, '1959', 40.00),
813 ('B-LY 7945H', 'NSU 1000 TTS', 'Audi', 1000, 70, '1970', 34.00),
814 ('B-MA 554H', 'Sprite', 'Austin-Healey', 1200, 75, '1959', 50.00),
815 ('B-NH 442H', 'DB2', 'Aston-Martin', 3000, 120, '1947', 48.70),
816 ('B-PO 1265H', '356-Speedster', 'Porsche', 1600, 120, '1951', 68.50),
817 ('B-RL 9299H', 'Phantom II', 'Rolls-Royce', 7688, 130, '1936', 70.00),
818 ('B-RT 683H', 'Aprillia', 'Lancia', 2349, 123, '1947', 45.00),
819 ('B-SL 300H', '300 SL', 'Mercedes-Benz', 3000, 180, '1958', 40.00),
820 ('B-TR 4320H', 'TR2', 'Triumph', 2000, 90, '1952', 45.00),
821 ('B-TX 6521H', 'TR6', 'Triumph', 2500, 150, '1969', 45.00),
822 ('B-VD 649H', 'KR 200', 'Messerschmitt', 200, 17, '1954', 29.99),
823 ('B-VX 445H', 'XK 120', 'Jaguar', 3349, 125, '1950', 68.50),
824 ('B-ZZ 2349H', '190 SL', 'Mercedes-Benz', 1900, 105, '1962', 45.00);
825/*!40000 ALTER TABLE `oldtimer` ENABLE KEYS */;
826
827/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
828/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
829/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;