diff options
| author |  Vitaly Takmazov | 2018-04-03 13:51:49 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2018-04-03 13:51:49 +0300 |
| commit | 3bfe060a796bd42c49a6510810fbe1cd0bbb8697 (patch) | |
| tree | 307c13ba6c416c8cbfe719e2c3983941540ce0af | |
| parent | 4ed9ead1a2339a45a39aaf59f2270af5e2fece7f (diff) | |
h2: fix schema
| -rw-r--r-- | juick-server-jdbc/src/main/resources/schema.sql | 2 |
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`), |