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

BEGIN TRANSACTION;
CREATE TABLE IF NOT EXISTS "driving_student" (
	"id"	INTEGER,
	"first_name"	TEXT,
	"last_name"	TEXT,
	"date_of_birth"	DATE,
	"theory_test_passed"	INTEGER,
	"number_of_driving_lessons"	INTEGER,
	"instructor_code"	TEXT,
	FOREIGN KEY("instructor_code") REFERENCES "driving_instructor"("code"),
	PRIMARY KEY("id" AUTOINCREMENT)
);
CREATE TABLE IF NOT EXISTS "vehicle" (
	"license_plate"	TEXT,
	"manufacturer"	TEXT,
	"is_automatic"	INTEGER,
	PRIMARY KEY("license_plate")
);
CREATE TABLE IF NOT EXISTS "driving_instructor" (
	"code"	TEXT,
	"first_name"	TEXT,
	"last_name"	TEXT,
	"phone_number"	TEXT,
	"vehicle"	TEXT,
	PRIMARY KEY("code")
);
INSERT INTO "vehicle" 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 "driving_instructor" VALUES ('Dem','Aylin','Demir','0176-48392715','B-AB 1234'),
 ('Had','Sammy','Hadamard','0157-20968431','HH-EF 9101'),
 ('Pet','Peter','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 "driving_student" VALUES (1,'Hans','Schmidt','2000-01-01',0,10,'Dem'),
 (2,'Lisa','Terhoog','2002-02-02',1,15,'Had'),
 (3,'Karl','Scholz','2004-03-03',0,12,'Pet'),
 (4,'Marie','Korting','2006-04-04',1,20,'Schm'),
 (5,'Fritz','Feidel','2008-05-05',0,8,'Dem'),
 (6,'Marie','Hermes','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,'Lena','Feierabend','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,'Emily','Hoffmann','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,'Mila','Hankel','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,'Sarah','Temiz','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,'Serdar','Kilic','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,'Yusuf','Cetin','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);
COMMIT;