SQL/postgres.update.sql
@@ -127,7 +127,7 @@ CONSTRAINT searches_user_id_key UNIQUE (user_id, "type", name) ); DROP SEQUENCE messages_ids; DROP SEQUENCE message_ids; DROP TABLE messages; CREATE TABLE cache_index ( @@ -169,3 +169,9 @@ -- 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;