summaryrefslogtreecommitdiff
path: root/roundcubemail/SQL/postgres.initial.sql
diff options
context:
space:
mode:
authorthomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>2006-08-25 11:51:11 +0000
committerthomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c>2006-08-25 11:51:11 +0000
commit12c7e7b88c581c3cf8e07a85d587a6add927d750 (patch)
tree97e3c52d3ec16a4fea87d582b74c2fa07a602a31 /roundcubemail/SQL/postgres.initial.sql
parenta6bf50cf3e8d9d49516242947619c97806c30d56 (diff)
Finalized new message parsing. Attention: changes in database schema
git-svn-id: https://svn.roundcube.net/trunk@325 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL/postgres.initial.sql')
-rwxr-xr-xroundcubemail/SQL/postgres.initial.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/roundcubemail/SQL/postgres.initial.sql b/roundcubemail/SQL/postgres.initial.sql
index 55e139603..029afaab3 100755
--- a/roundcubemail/SQL/postgres.initial.sql
+++ b/roundcubemail/SQL/postgres.initial.sql
@@ -163,6 +163,7 @@ CREATE TABLE "messages" (
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);