From 103ddcde87f77da28fa2c1f7942763db1c65b34a Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Mon, 04 Oct 2010 14:09:26 -0400 Subject: [PATCH] - Minimize FETCH response for messages listing (when caching is disabled) --- SQL/postgres.update.sql | 9 ++++++++- 1 files changed, 8 insertions(+), 1 deletions(-) diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index ec7ce9b..1ef93d8 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -1,4 +1,4 @@ --- RoundCube Webmail update script for Postgres databases +-- Roundcube Webmail update script for Postgres databases -- Updates from version 0.1-stable to 0.1.1 CREATE INDEX cache_user_id_idx ON cache (user_id, cache_key); @@ -49,6 +49,8 @@ DROP INDEX identities_user_id_idx; CREATE INDEX identities_user_id_idx ON identities (user_id, del); +ALTER TABLE identities ADD changed timestamp with time zone DEFAULT now() NOT NULL; + CREATE SEQUENCE contactgroups_ids INCREMENT BY 1 NO MAXVALUE @@ -74,3 +76,8 @@ created timestamp with time zone DEFAULT now() NOT NULL, PRIMARY KEY (contactgroup_id, contact_id) ); + +-- Updates from version 0.4-beta + +ALTER TABLE users ALTER last_login DROP NOT NULL; +ALTER TABLE users ALTER last_login SET DEFAULT NULL; -- Gitblit v1.9.1