From cfdf044df284d294e0e73efb10ebce1052264694 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 20 Dec 2006 09:05:23 -0500 Subject: [PATCH] Cleaned up scripts, merged redundant functionality --- 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