-- eskuel:system=sqlite
-- eskuel:systemMinVersion=3.37.0

BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "fahrschueler" (
	"nr"	INTEGER,
	"vorname"	TEXT,
	"nachname"	TEXT,
	"gebdatum"	DATE,
	"theorie_bestanden"	INTEGER,
	"anz_fahrstunden"	INTEGER,
	"fl_kuerzel"	TEXT,
	FOREIGN KEY("fl_kuerzel") REFERENCES "fahrlehrer"("kuerzel"),
	PRIMARY KEY("nr")
);
CREATE TABLE IF NOT EXISTS "fahrzeug" (
	"kennzeichen"	TEXT,
	"hersteller"	TEXT,
	"ist_automatik"	INTEGER,
	PRIMARY KEY("kennzeichen")
);
CREATE TABLE IF NOT EXISTS "fahrlehrer" (
	"kuerzel"	TEXT,
	"vorname"	TEXT,
	"nachname"	TEXT,
	"telefonnr"	TEXT,
	"fahrzeug"	TEXT,
	PRIMARY KEY("kuerzel")
);
INSERT INTO "fahrzeug" VALUES ('B-AB 1234','Volkswagen',1),
 ('M-CD 5678','BMW',0),
 ('HH-EF 9101','Audi',1),
 ('D-GH 1122','Mercedes-Benz',0),
 ('S-IJ 3344','Ford',1),
 ('F-KL 5566','Toyota',0),
 ('K-MN 7788','Hyundai',1),
 ('L-OP 9900','Nissan',0);
INSERT INTO "fahrlehrer" VALUES ('Dem','Aylin','Demir','0176-48392715','B-AB 1234'),
 ('Had','Sammy','Hadamard','0157-20968431','HH-EF 9101'),
 ('Pet','Herbert','Petersen','0172-61590384','M-CD 5678'),
 ('Schm','Elaine','Schmidt','0160-74825196','D-GH 1122'),
 ('Mul','Edgar','Müller','0151-93640728','S-IJ 3344'),
 ('Schu','Sabine','Schubert','0176-85019364','F-KL 5566'),
 ('Hof','Markus','Hoffmann','0157-62483905','K-MN 7788'),
 ('Ko','Christine','Koch','0171-39057642','L-OP 9900'),
 ('Bu','Andreas','Burmann','0162-84730519','N/A'),
 ('Rad','Katrin','Rademacher','0152-70849631','N/A'),
 ('Be','Michael','Becker','0173-56192840','N/A');
 INSERT INTO "fahrschueler" VALUES (1,'Hans','Schmidt','2000-01-01',0,10,'Dem'),
 (2,'Meilin','Zhang','2002-02-02',1,15,'Had'),
 (3,'Jason','Miller','2004-03-03',0,12,'Pet'),
 (4,'Layla','Al-Hassan','2006-04-04',1,20,'Schm'),
 (5,'Fritz','Feidel','2008-05-05',0,8,'Dem'),
 (6,'Hugo','Laurent','2001-12-02',1,17,'Dem'),
 (7,'Jana','Bisslich','2010-06-06',1,18,'Dem'),
 (8,'Paul','Wagner','1999-07-07',1,14,'Hof'),
 (9,'Boris','Czerban','2003-09-01',0,0,NULL),
 (10,'Laura','Beckmann','2006-08-08',1,22,'Ko'),
 (11,'Max','Abdelaziz','2002-09-09',1,16,'Bu'),
 (12,'Minh','Nguyen','2004-10-10',1,24,'Rad'),
 (13,'Kai','Nussbaum','2005-11-11',1,7,'Had'),
 (14,'Lara','Hoffmann','2001-12-12',1,15,'Had'),
 (15,'Jan','Koch','2004-01-01',1,12,'Pet'),
 (16,'Mia','Seßmann','2006-02-02',1,20,'Schm'),
 (17,'Ben','Stein','2004-03-03',0,4,'Mul'),
 (18,'Emma','Kunkel','2002-04-04',1,18,'Schu'),
 (19,'Tim','Renneberg','2000-05-05',1,14,'Hof'),
 (20,'Luisa','Keller','1998-06-06',1,22,'Ko'),
 (21,'Jonas','Stab','1996-07-07',1,16,'Bu'),
 (22,'Sean','Murphy','1994-08-08',1,24,'Had'),
 (23,'Finja','Samuel','1992-09-09',1,1,'Dem'),
 (24,'Lukas','Wittkewitz','1990-10-10',1,15,'Had'),
 (25,'Lara','Wong','1988-11-11',1,12,'Pet'),
 (26,'Leon','Becker','1986-12-12',1,20,'Schm'),
 (27,'Simon','Guillaume','1984-01-01',1,0,'Mul'),
 (28,'Juli','Nassar','1982-02-02',1,18,'Schu'),
 (29,'Sarah','Schultheiss','1980-03-03',1,14,'Hof'),
 (30,'Luca','Hoffmann','1978-04-04',1,22,'Ko'),
 (31,'Marlon','Pohl','1976-05-05',1,16,'Bu'),
 (32,'Melanie','Tekampe','2004-01-28',1,0,NULL),
 (33,'Camille','Dubois','1974-06-06',1,24,'Rad'),
 (34,'Felix','Gates','1972-07-07',0,7,'Dem'),
 (35,'Emilia','Hartmann','1970-08-08',1,15,'Had'),
 (36,'Elias','Mrasok','1968-09-09',1,12,'Pet'),
 (37,'Hannah','Amani','2000-01-01',1,10,'Dem'),
 (38,'Paul','Granger','2002-02-02',1,15,'Had'),
 (39,'Erik','Hoffmann','2004-03-03',1,12,'Pet'),
 (40,'Finn','Sachs','2006-04-04',1,20,'Schm'),
 (41,'Lina','Schwesig','2004-05-05',0,0,'Mul'),
 (42,'Leon','Vogt','2001-06-06',1,18,'Schu'),
 (43,'Lara','Roth','1999-07-07',1,14,'Hof'),
 (44,'Julian','Maaßen','2006-08-08',1,22,'Ko'),
 (45,'Lucía','García','2002-09-09',1,16,'Bu'),
 (46,'Luca','Rowling','2004-10-10',1,24,'Rad'),
 (47,'Marlon','Hoffmann','2005-11-11',0,4,'Dem'),
 (48,'Mila','Dierksen','2001-12-12',1,15,'Had'),
 (49,'Jonte','Eigner','2004-01-01',1,12,'Pet'),
 (50,'Emilia','Berger','2006-02-02',1,20,'Schm'),
 (51,'Elias','Friedmann','2004-03-03',0,2,'Mul'),
 (52,'Hannah','Turan','2002-04-04',1,18,'Schu'),
 (53,'Paul','Malik','2000-05-05',1,14,'Rad'),
 (54,'Emma','Laut','1998-06-06',1,22,'Ko'),
 (55,'Rasmus','Hoffmann','1996-07-07',1,16,'Bu'),
 (56,'Liam','Kelly','2004-10-10',1,24,'Had'),
 (57,'Cem','Korkmaz','2005-11-11',1,10,'Dem'),
 (58,'Zeynep','Yildiz','2001-12-12',1,15,'Had'),
 (59,'Selim','Kaya','2004-01-01',1,12,'Pet'),
 (60,'Ebru','Aydin','2006-02-02',1,20,'Schm'),
 (61,'Mojtaba','Moradi','2005-03-04',0,0,NULL),
 (62,'Burak','Kilic','2004-03-03',1,8,'Mul'),
 (63,'Selin','Kara','2002-04-04',1,18,'Schu'),
 (64,'Diego','Martínez','2000-05-05',1,14,'Hof'),
 (65,'Sibel','Sari','1998-06-06',1,22,'Ko'),
 (66,'Kai','Zaech','2000-01-01',1,10,'Dem'),
 (67,'Mariam','Erakat','2002-02-02',1,15,'Had'),
 (68,'Jan','Abshoff','2004-03-03',1,12,'Pet'),
 (69,'Mia','Hoffmann','2006-04-04',1,20,'Schm'),
 (70,'Ben','Böhm','2004-05-05',0,8,'Rad'),
 (71,'Emma','Haarmann','2001-06-06',1,18,'Schu'),
 (72,'Tim','Waltz','1999-07-07',0,14,'Hof'),
 (73,'Luisa','Rüdiger','2006-08-08',1,22,'Ko'),
 (74,'Jonas','Bell','2002-09-09',1,16,'Bu'),
 (75,'Emily','Winston','2004-10-10',1,24,'Had'),
 (76,'Evgeny','Sunderland','2005-11-11',1,10,'Dem'),
 (77,'Tobias','Westendorf','1998-10-16',0,0,NULL),
 (78,'Lukas','Hoffmann','2001-12-12',1,15,'Had'),
 (79,'Lara','Jäger','2004-01-01',1,12,'Pet'),
 (80,'Leon','Beth','2006-02-02',1,20,'Schm'),
 (81,'Lina','Bernhard','2004-03-03',0,8,'Mul'),
 (82,'Julian','Schlimme','2002-04-04',1,18,'Schu'),
 (83,'Sarah','Münster','2000-05-05',1,14,'Hof'),
 (84,'Luca','Poletta','1998-06-06',1,22,'Rad'),
 (85,'Dennis','Dragowski','1999-03-07',0,0,NULL),
 (86,'Anita','Kamphoff','1999-03-10',1,0,NULL),
 (87,'Jana','Weber','2003-07-15',0,6,'Pet');
COMMIT;