SQL/postgres.update.sql
@@ -169,3 +169,17 @@ -- Updates from version 0.7-beta ALTER TABLE "session" ALTER sess_id TYPE varchar(128); -- Updates from version 0.7 DROP INDEX contacts_user_id_idx; CREATE INDEX contacts_user_id_idx ON contacts USING btree (user_id, del); ALTER TABLE contacts ALTER email TYPE text; -- Updates from version 0.8 ALTER TABLE cache DROP COLUMN cache_id; DROP SEQUENCE cache_ids; ALTER TABLE users DROP COLUMN alias; CREATE INDEX identities_email_idx ON identities (email, del);
