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/database.sql | |
| parent | f5bc7925a8fbbe247972a6f0e0571cc7e92fbefa (diff) | |
| parent | e21feb3ac772a5394dc5381b58142c3c061de716 (diff) | |
| download | sepm-groupproject-3.0.tar.gz sepm-groupproject-3.0.tar.xz sepm-groupproject-3.0.zip | |
Diffstat (limited to 'src/main/resources/sql/database.sql')
| -rw-r--r-- | src/main/resources/sql/database.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/src/main/resources/sql/database.sql b/src/main/resources/sql/database.sql index 463e8ac..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), @@ -44,7 +44,7 @@ CREATE TABLE IF NOT EXISTS Operation ( id BIGINT AUTO_INCREMENT PRIMARY KEY, opCode VARCHAR(20) NOT NULL, severity ENUM('A', 'B', 'C', 'D', 'E', 'O') NOT NULL, - created TIMESTAMP NOT NULL, + created TIMESTAMP WITH TIME ZONE NOT NULL, destination VARCHAR(100) NOT NULL, additionalInfo VARCHAR(100), status ENUM('ACTIVE', 'COMPLETED', 'CANCELLED'), |