1 -- Updates from version 0.3-stable
4 CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx);
5 DROP INDEX contacts_user_id_idx;
6 CREATE INDEX contacts_user_id_idx ON contacts (user_id, email);
8 -- Updates from version 0.3.1
10 DROP INDEX identities_user_id_idx;
11 CREATE INDEX identities_user_id_idx ON identities (user_id, del);
13 ALTER TABLE identities ADD changed timestamp with time zone DEFAULT now() NOT NULL;
15 CREATE SEQUENCE contactgroups_ids
21 CREATE TABLE contactgroups (
22 contactgroup_id integer DEFAULT nextval('contactgroups_ids'::text) PRIMARY KEY,
23 user_id integer NOT NULL
24 REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE,
25 changed timestamp with time zone DEFAULT now() NOT NULL,
26 del smallint NOT NULL DEFAULT 0,
27 name varchar(128) NOT NULL DEFAULT ''
30 CREATE INDEX contactgroups_user_id_idx ON contactgroups (user_id, del);
32 CREATE TABLE contactgroupmembers (
33 contactgroup_id integer NOT NULL
34 REFERENCES contactgroups(contactgroup_id) ON DELETE CASCADE ON UPDATE CASCADE,
35 contact_id integer NOT NULL
36 REFERENCES contacts(contact_id) ON DELETE CASCADE ON UPDATE CASCADE,
37 created timestamp with time zone DEFAULT now() NOT NULL,
38 PRIMARY KEY (contactgroup_id, contact_id)
41 -- Updates from version 0.4-beta
43 ALTER TABLE users ALTER last_login DROP NOT NULL;
44 ALTER TABLE users ALTER last_login SET DEFAULT NULL;
46 -- Updates from version 0.4.2
48 DROP INDEX users_username_id_idx;
49 ALTER TABLE users ADD UNIQUE (username, mail_host);
50 ALTER TABLE contacts ALTER email TYPE varchar(255);