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 | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index 762f5fb..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); @@ -76,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