1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
DELETE FROM Registration;
DELETE FROM Vehicle;
DELETE FROM VehicleVersion;
DELETE FROM Employee;
DELETE FROM EmployeeVersion;
INSERT INTO EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) VALUES (1, 'John Doe', '2000-01-01', 'RS', TRUE, TRUE);
INSERT INTO EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) VALUES (2, 'Nick "Kage" Verily', '1990-01-01', 'NKV', TRUE, FALSE);
INSERT INTO EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) VALUES (3, 'Nicht Arzt', '1980-01-01', 'NA', FALSE, FALSE);
INSERT INTO Employee (id, version) VALUES (1, 1);
INSERT INTO Employee (id, version) VALUES (2, 2);
INSERT INTO Employee (id, version) VALUES (3, 3);
INSERT INTO VehicleVersion (id, name, hasNef, constructionType, type) VALUES (1, 'RTW-1', TRUE, 'HOCHDACH', 'RTW');
INSERT INTO VehicleVersion (id, name, hasNef, constructionType, type) VALUES (2, 'NEF-1', FALSE, 'NORMAL', 'NEF');
INSERT INTO Vehicle (id, version, status) VALUES (1, 1, 'ABGEMELDET');
INSERT INTO Vehicle (id, version, status) VALUES (2, 2, 'ABGEMELDET');
|
