aboutsummaryrefslogtreecommitdiff
path: root/juick-server-jdbc/src/main/resources
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-04-03 13:51:49 +0300
committerGravatar Vitaly Takmazov2018-04-03 13:51:49 +0300
commit3bfe060a796bd42c49a6510810fbe1cd0bbb8697 (patch)
tree307c13ba6c416c8cbfe719e2c3983941540ce0af /juick-server-jdbc/src/main/resources
parent4ed9ead1a2339a45a39aaf59f2270af5e2fece7f (diff)
h2: fix schema
Diffstat (limited to 'juick-server-jdbc/src/main/resources')
-rw-r--r--juick-server-jdbc/src/main/resources/schema.sql2
1 files changed, 1 insertions, 1 deletions
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`),