SQL/postgres.update.sql
@@ -85,12 +85,15 @@ -- 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.2 ALTER TABLE contacts ADD words TEXT NULL; CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); TRUNCATE messages; TRUNCATE cache;