From 5c78e3a566f1da10491f22bf51aeafd52f9cd871 Mon Sep 17 00:00:00 2001
From: Felix Kehrer <felix.kehrer@gmail.com>
Date: Sat, 2 Jun 2018 23:17:49 +0200
Subject: change database schema to include time zone data with timestamp
 #27844

---
 src/main/resources/sql/database.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/main/resources/sql/database.sql')

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'),
-- 
cgit v1.2.3-70-g09d2

