diff options
| author | Felix Kehrer <felix.kehrer@gmail.com> | 2018-06-02 23:17:49 +0200 |
|---|---|---|
| committer | Felix Kehrer <felix.kehrer@gmail.com> | 2018-06-02 23:17:49 +0200 |
| commit | 5c78e3a566f1da10491f22bf51aeafd52f9cd871 (patch) | |
| tree | 67a35aaf0d0c5fa536e99187549eb34aeddd6582 /src/main/resources/sql | |
| parent | c7254f1c1f9509c6b9888e97838864eff2ebaaa2 (diff) | |
| download | sepm-groupproject-5c78e3a566f1da10491f22bf51aeafd52f9cd871.tar.gz sepm-groupproject-5c78e3a566f1da10491f22bf51aeafd52f9cd871.tar.xz sepm-groupproject-5c78e3a566f1da10491f22bf51aeafd52f9cd871.zip | |
change database schema to include time zone data with timestamp #27844
Diffstat (limited to 'src/main/resources/sql')
| -rw-r--r-- | src/main/resources/sql/database.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/main/resources/sql/database.sql b/src/main/resources/sql/database.sql index 463e8ac..3d382d1 100644 --- a/src/main/resources/sql/database.sql +++ b/src/main/resources/sql/database.sql @@ -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'), |