From 100e7340be63f1e78537de58332df8f09fed3faf Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Mon, 26 Mar 2018 10:01:18 +0300
Subject: h2 schema update

---
 .../src/main/java/com/juick/configuration/DataConfiguration.java      | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'juick-server-jdbc')

diff --git a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
index ee9d0baa..78c6e1d6 100644
--- a/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
+++ b/juick-server-jdbc/src/main/java/com/juick/configuration/DataConfiguration.java
@@ -267,6 +267,10 @@ public class DataConfiguration implements TransactionManagementConfigurer {
                     "  `descr` varchar(255) DEFAULT NULL," +
                     "  PRIMARY KEY (`user_id`)" +
                     ")");
+            jdbcTemplate.execute("CREATE TABLE IF NOT EXISTS `telegram_chats` (\n" +
+                    "  `chat_id` bigint(20) DEFAULT NULL,\n" +
+                    "  UNIQUE KEY `chat_id` (`chat_id`)\n" +
+                    ")");
         }
         return jdbcTemplate;
     }
-- 
cgit v1.2.3