捣鼓 postfix+dovecot+postfixadmin 失败
数据库老装不上,超过1000字节什么的
CREATE TABLE IF NOT EXISTS config ( `id` int(11) not null auto_increment primary key, `name` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', `value` VARCHAR(20) /*!40100 CHARACTER SET latin1 */ NOT NULL DEFAULT '', UNIQUE name ( `name` ) ) ENGINE = MYISAM COMMENT = 'PostfixAdmin settings'
CREATE TABLE IF NOT EXISTS vacation_notification ( on_vacation varchar(255) /*!40100 CHARACTER SET latin1 */ NOT NULL, notified varchar(255) NOT NULL, notified_at timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY on_vacation (`on_vacation`, `notified`), CONSTRAINT `vacation_notification_pkey` FOREIGN KEY (`on_vacation`) REFERENCES vacation(`email`) ON DELETE CASCADE ) ENGINE=InnoDB COMMENT='Postfix Admin - Virtual Vacation Notifications'
DEBUG INFORMATION:
Invalid query: Specified key was too long; max key length is 1000 bytes
可是我已改小了字节大小,还选的LATIN就是不行了 |