Imported Upstream version 0.6+dfsg

[roundcube.git] / SQL / sqlite.initial.sql

diff --git a/SQL/sqlite.initial.sql b/SQL/sqlite.initial.sql
index 875b3cba02a2ee7cf0786bc172bcf1a9a5240ef6..d2885e9686d01b0e999d3d7d0d04a26da9faf1f8 100644 (file)
--- a/SQL/sqlite.initial.sql
+++ b/SQL/sqlite.initial.sql
@@ -31,7 +31,8 @@ CREATE TABLE contacts (
   email varchar(255) NOT NULL default '',
   firstname varchar(128) NOT NULL default '',
   surname 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);
 );
 
 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);


@@ -55,6 +56,8 @@ CREATE TABLE contactgroupmembers (
   PRIMARY KEY (contactgroup_id, contact_id)
 );
 
   PRIMARY KEY (contactgroup_id, contact_id)
 );
 

+CREATE INDEX ix_contactgroupmembers_contact_id ON contactgroupmembers (contact_id);
+

 
 -- --------------------------------------------------------
 
 
 -- --------------------------------------------------------