diff options
| author | Benjamin Southall <applemansigloo@gmail.com> | 2017-06-08 08:06:39 +0900 |
|---|---|---|
| committer | Benjamin Southall <applemansigloo@gmail.com> | 2017-06-08 08:06:39 +0900 |
| commit | 986efe8980de233d83e651dc747667be0a357099 (patch) | |
| tree | c8d668dd8f9671e70ae447f8ec7fea5017408104 | |
| parent | 257ead7313f5a3248d07e9be89f84aa2ea984008 (diff) | |
Merge pull request from vichan-devel/vichan##202 from pngcrypt/master table fix nntpchan install.sql fix from https://github.com/vichan-devel/vichan/commit/6049979dafcdbf17410a15ab250577e222c11bbe
| -rw-r--r-- | install.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/install.sql b/install.sql index 8edc568b..c7f1b021 100644 --- a/install.sql +++ b/install.sql @@ -305,8 +305,8 @@ CREATE TABLE IF NOT EXISTS `ban_appeals` ( CREATE TABLE `pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `board` varchar(125) DEFAULT NULL, - `name` varchar(125) NOT NULL, + `board` varchar(58) CHARACTER SET utf8 DEFAULT NULL, + `name` varchar(255) CHARACTER SET utf8 NOT NULL, `title` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `content` text, @@ -321,7 +321,7 @@ CREATE TABLE `pages` ( -- CREATE TABLE `nntp_references` ( - `board` varchar(60) NOT NULL, + `board` varchar(30) NOT NULL, `id` int(11) unsigned NOT NULL, `message_id` varchar(255) CHARACTER SET ascii NOT NULL, `message_id_digest` varchar(40) CHARACTER SET ascii NOT NULL, |