From e6c7c3ca9381aa10f7147544cd93f6179d32f359 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Tue, 13 Mar 2007 18:53:26 -0400 Subject: [PATCH] Fixed bugs in rcube_db and rcube_imap classes --- SQL/postgres.initial.sql | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/SQL/postgres.initial.sql b/SQL/postgres.initial.sql index 55e1396..ebd504d 100755 --- a/SQL/postgres.initial.sql +++ b/SQL/postgres.initial.sql @@ -69,7 +69,8 @@ email character varying(128) NOT NULL, "reply-to" character varying(128), bcc character varying(128), - signature text + signature text, + html_signature integer DEFAULT 0 NOT NULL ); @@ -163,6 +164,7 @@ date timestamp with time zone NOT NULL, size integer DEFAULT 0 NOT NULL, headers text NOT NULL, - body text + structure text ); +ALTER TABLE "messages" ADD UNIQUE (cache_key, uid); -- Gitblit v1.9.1