diff options
| author | Tharre <tharre3@gmail.com> | 2018-06-20 22:07:36 +0200 |
|---|---|---|
| committer | Tharre <tharre3@gmail.com> | 2018-06-20 22:07:36 +0200 |
| commit | 0c995a05985da749d93aa56eba976c7fc621a4fa (patch) | |
| tree | 5b80394920705aae5e2b6004c3dfbd839c8b8fa3 /src/main/resources/sql/H2RegistrationDAOTest_populate.sql | |
| parent | f5bc7925a8fbbe247972a6f0e0571cc7e92fbefa (diff) | |
| parent | e21feb3ac772a5394dc5381b58142c3c061de716 (diff) | |
| download | sepm-groupproject-0c995a05985da749d93aa56eba976c7fc621a4fa.tar.gz sepm-groupproject-0c995a05985da749d93aa56eba976c7fc621a4fa.tar.xz sepm-groupproject-0c995a05985da749d93aa56eba976c7fc621a4fa.zip | |
Diffstat (limited to 'src/main/resources/sql/H2RegistrationDAOTest_populate.sql')
| -rw-r--r-- | src/main/resources/sql/H2RegistrationDAOTest_populate.sql | 15 |
1 files changed, 0 insertions, 15 deletions
diff --git a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql b/src/main/resources/sql/H2RegistrationDAOTest_populate.sql deleted file mode 100644 index 7e7b428..0000000 --- a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql +++ /dev/null @@ -1,15 +0,0 @@ -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');
\ No newline at end of file |