From 3e2637351da9559a4aa420004ac90e9fe30477ef Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Mon, 14 Feb 2011 15:46:48 -0500 Subject: [PATCH] Fulltext search over contact fields. Attention: DATABASE SCHEMA CHANGED\! --- SQL/sqlite.initial.sql | 7 ++++--- 1 files changed, 4 insertions(+), 3 deletions(-) diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql index e7faeed..3aacccb 100644 --- a/SQL/sqlite.initial.sql +++ b/SQL/sqlite.initial.sql @@ -28,10 +28,11 @@ 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 '' + vcard text NOT NULL default '', + words text NOT NULL default '' ); CREATE INDEX ix_contacts_user_id ON contacts(user_id, email); @@ -97,7 +98,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