diff options
Diffstat (limited to 'SQL/postgres.update.sql')
| -rw-r--r-- | SQL/postgres.update.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index 7e9d34fa9..11ab93bfc 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -175,3 +175,11 @@ ALTER TABLE "session" ALTER sess_id TYPE varchar(128); 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); |