From 646cebd34843f30c63b59c80456650f36a135441 Mon Sep 17 00:00:00 2001 From: svncommit <devs@roundcube.net> Date: Mon, 20 Nov 2006 13:15:53 -0500 Subject: [PATCH] Initialize this.message_list only if we have one. --- 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