From 3bfe060a796bd42c49a6510810fbe1cd0bbb8697 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Tue, 3 Apr 2018 13:51:49 +0300
Subject: h2: fix schema

---
 juick-server-jdbc/src/main/resources/schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'juick-server-jdbc')

diff --git a/juick-server-jdbc/src/main/resources/schema.sql b/juick-server-jdbc/src/main/resources/schema.sql
index c4b1026e..68282f88 100644
--- a/juick-server-jdbc/src/main/resources/schema.sql
+++ b/juick-server-jdbc/src/main/resources/schema.sql
@@ -217,7 +217,7 @@ CREATE TABLE IF NOT EXISTS `replies` (
   `user_id` int(10) unsigned NOT NULL,
   `replyto` smallint(5) unsigned NOT NULL DEFAULT '0',
   `ts` timestamp(9) NOT NULL DEFAULT CURRENT_TIMESTAMP,
-  `attach` enum('jpg','mp4','png') DEFAULT NULL,
+  `attach` nchar(3) check (attach in ('jpg', 'mp4', 'png')),
   `txt` mediumtext NOT NULL,
   KEY (`message_id`),
   KEY (`user_id`),
-- 
cgit v1.2.3