From 7c3ccb6fbca054f91f14f574761a6d6dd42f68c7 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 12 Jan 2011 06:56:25 -0500 Subject: [PATCH] Update Chinese messages --- SQL/sqlite.initial.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index e7faeed..875b3cb 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -28,7 +28,7 @@ changed datetime NOT NULL default '0000-00-00 00:00:00', del tinyint NOT NULL default '0', name varchar(128) NOT NULL default '', - email varchar(128) NOT NULL default '', + email varchar(255) NOT NULL default '', firstname varchar(128) NOT NULL default '', surname varchar(128) NOT NULL default '', vcard text NOT NULL default '' @@ -97,7 +97,7 @@ preferences text NOT NULL default '' ); -CREATE INDEX ix_users_username ON users(username); +CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host); CREATE INDEX ix_users_alias ON users(alias); -- -------------------------------------------------------- -- Gitblit v1.9.1