From b676355ab04479864d9c0e57b8149c567928da26 Mon Sep 17 00:00:00 2001 From: Tharre Date: Sat, 16 Jun 2018 22:46:08 +0200 Subject: Rework RegistrationDatabaseDAO #27305 --- src/main/resources/sql/database.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'src/main/resources/sql') 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), -- cgit v1.2.3-70-g09d2