From 8219df7241e3c96bb6b7f9abfa057b8a64b1839f Mon Sep 17 00:00:00 2001 From: alec Date: Sun, 18 Sep 2011 09:02:35 +0000 Subject: - Cache synchronization using QRESYNC/CONDSTORE - Fixed message ID updates in cache - Changed message flags handling + some fixes (e.g. fixed messages listing after delete) git-svn-id: https://svn.roundcube.net/trunk@5233 208e9e7b-5314-0410-a742-e7e81cd9613c --- roundcubemail/SQL/postgres.update.sql | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) (limited to 'roundcubemail/SQL/postgres.update.sql') diff --git a/roundcubemail/SQL/postgres.update.sql b/roundcubemail/SQL/postgres.update.sql index 4bd0400c9..741495fbe 100644 --- a/roundcubemail/SQL/postgres.update.sql +++ b/roundcubemail/SQL/postgres.update.sql @@ -159,12 +159,7 @@ CREATE TABLE cache_messages ( uid integer NOT NULL, changed timestamp with time zone DEFAULT now() NOT NULL, data text NOT NULL, - seen smallint NOT NULL DEFAULT 0, - deleted smallint NOT NULL DEFAULT 0, - answered smallint NOT NULL DEFAULT 0, - forwarded smallint NOT NULL DEFAULT 0, - flagged smallint NOT NULL DEFAULT 0, - mdnsent smallint NOT NULL DEFAULT 0, + flags integer NOT NULL DEFAULT 0, PRIMARY KEY (user_id, mailbox, uid) ); -- cgit v1.2.3