From a7c51ac2d032e29e9599a6f64849c24eb1f7f94d Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Mon, 12 Sep 2011 02:44:56 -0400 Subject: [PATCH] - Applied fixes from trunk up to r5202 --- SQL/postgres.update.sql | 10 ++++++++-- 1 files changed, 8 insertions(+), 2 deletions(-) diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index e3eb581..94513c5 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -85,12 +85,18 @@ -- Updates from version 0.4.2 DROP INDEX users_username_id_idx; -ALTER TABLE users ADD UNIQUE (username, mail_host); +ALTER TABLE users ADD CONSTRAINT users_username_key UNIQUE (username, mail_host); ALTER TABLE contacts ALTER email TYPE varchar(255); TRUNCATE messages; --- Updates from version 0.5.x +-- Updates from version 0.5.1 +-- Updates from version 0.5.2 +-- Updates from version 0.5.3 +-- Updates from version 0.5.4 ALTER TABLE contacts ADD words TEXT NULL; CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); + +TRUNCATE messages; +TRUNCATE cache; -- Gitblit v1.9.1