· 8 years ago · Jun 20, 2018, 01:58 AM
1--- upgrade.php.orig 2010-10-27 11:56:13.000000000 +0900
2+++ upgrade.php 2010-10-27 11:52:40.000000000 +0900
3@@ -167,7 +167,7 @@
4 '{FULLTEXT}' => 'FULLTEXT',
5 '{BOOLEAN}' => 'tinyint(1) NOT NULL',
6 '{UTF-8}' => '/*!40100 CHARACTER SET utf8 */',
7- '{LATIN1}' => '/*!40100 CHARACTER SET latin1 */',
8+ '{LATIN1}' => '/*!40100 CHARACTER SET utf8 */',
9 '{IF_NOT_EXISTS}' => 'IF NOT EXISTS',
10 '{RENAME_COLUMN}' => 'CHANGE COLUMN',
11 '{MYISAM}' => 'ENGINE=MyISAM',
12@@ -1097,7 +1097,7 @@
13 # table for dovecot v1.0 & 1.1
14 db_query_parsed("
15 CREATE TABLE {IF_NOT_EXISTS} $table_quota (
16- username VARCHAR(255) {LATIN1} NOT NULL,
17+ username VARCHAR(200) {LATIN1} NOT NULL,
18 path VARCHAR(100) {LATIN1} NOT NULL,
19 current {BIGINT},
20 PRIMARY KEY (username, path)