diff --git a/util/db-mysql.sql b/util/db-mysql.sql index 8ccfb54..2ded4df 100644 --- a/util/db-mysql.sql +++ b/util/db-mysql.sql @@ -46,8 +46,8 @@ `direction` int default 0, `attachments` int default 0, `piler_id` char(36) not null, - `message_id` char(128) character set 'latin1' not null, - `reference` char(64) character set 'latin1' not null, + `message_id` char(128) not null, + `reference` char(64) not null, `digest` char(64) not null, `bodydigest` char(64) not null, `vcode` char(64) default null, @@ -115,12 +115,12 @@ drop table if exists `archiving_rule`; create table if not exists `archiving_rule` ( `id` bigint unsigned not null auto_increment, - `from` char(128) character set 'latin1' default null, - `to` char(255) character set 'latin1' default null, - `subject` char(255) character set 'latin1' default null, + `from` char(128) default null, + `to` char(255) default null, + `subject` char(255) default null, `_size` char(2) default null, `size` int default 0, - `attachment_type` char(128) character set 'latin1' default null, + `attachment_type` char(128) default null, `_attachment_size` char(2) default null, `attachment_size` int default 0, `spam` tinyint(1) default -1, @@ -133,12 +133,12 @@ drop table if exists `retention_rule`; create table if not exists `retention_rule` ( `id` bigint unsigned not null auto_increment, - `from` char(128) character set 'latin1' default null, - `to` char(255) character set 'latin1' default null, - `subject` char(255) character set 'latin1' default null, + `from` char(128) default null, + `to` char(255) default null, + `subject` char(255) default null, `_size` char(2) default null, `size` int default 0, - `attachment_type` char(128) character set 'latin1' default null, + `attachment_type` char(128) default null, `_attachment_size` char(2) default null, `attachment_size` int default 0, `spam` tinyint(1) default -1,