| | |
| | | -- 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; |