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;
