diff options
| author | Tharre <tharre3@gmail.com> | 2018-06-16 22:46:08 +0200 |
|---|---|---|
| committer | Tharre <tharre3@gmail.com> | 2018-06-17 01:41:44 +0200 |
| commit | b676355ab04479864d9c0e57b8149c567928da26 (patch) | |
| tree | 502ff589fb1b1afe42d448182170f16a34ff6914 /src/main/resources/sql/database.sql | |
| parent | b023e81778c61d7ee6a6774544704e6b43b24311 (diff) | |
| download | sepm-groupproject-b676355ab04479864d9c0e57b8149c567928da26.tar.gz sepm-groupproject-b676355ab04479864d9c0e57b8149c567928da26.tar.xz sepm-groupproject-b676355ab04479864d9c0e57b8149c567928da26.zip | |
Rework RegistrationDatabaseDAO #27305
Diffstat (limited to 'src/main/resources/sql/database.sql')
| -rw-r--r-- | src/main/resources/sql/database.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/main/resources/sql/database.sql b/src/main/resources/sql/database.sql index 3d382d1..c7a99b5 100644 --- a/src/main/resources/sql/database.sql +++ b/src/main/resources/sql/database.sql @@ -33,8 +33,8 @@ CREATE TABLE IF NOT EXISTS Registration ( id BIGINT AUTO_INCREMENT PRIMARY KEY, vehicleId BIGINT NOT NULL, employeeId BIGINT NOT NULL, - start TIMESTAMP NOT NULL, - end TIMESTAMP NOT NULL, + start TIMESTAMP WITH TIME ZONE NOT NULL, + end TIMESTAMP WITH TIME ZONE NOT NULL, active BOOLEAN NOT NULL, FOREIGN KEY (vehicleId) REFERENCES VehicleVersion(id), FOREIGN KEY (employeeId) REFERENCES EmployeeVersion(id), |