aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-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`),