X-Git-Url: https://git.donarmstrong.com/?a=blobdiff_plain;f=SQL%2Fpostgres.initial.sql;h=e12a9978a34a40beb92783fd8bd188be07564558;hb=5058e04171cbe6d82a65fc9d869ddef90e829e36;hp=3710dac4a7f70c7bf2c40827bdf1b01b5dba54d0;hpb=76507f7c63a660742e76889ad6e3919f3dde3bb0;p=roundcube.git

diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql
index 3710dac..e12a997 100644
--- a/SQL/postgres.initial.sql
+++ b/SQL/postgres.initial.sql
@@ -107,14 +107,14 @@ CREATE TABLE contacts (
     changed timestamp with time zone DEFAULT now() NOT NULL,
     del smallint DEFAULT 0 NOT NULL,
     name varchar(128) DEFAULT '' NOT NULL,
-    email varchar(255) DEFAULT '' NOT NULL,
+    email text DEFAULT '' NOT NULL,
     firstname varchar(128) DEFAULT '' NOT NULL,
     surname varchar(128) DEFAULT '' NOT NULL,
     vcard text,
     words text
 );
 
-CREATE INDEX contacts_user_id_idx ON contacts (user_id, email);
+CREATE INDEX contacts_user_id_idx ON contacts (user_id, del);
 
 --
 -- Sequence "contactgroups_ids"