| commit | author | age | ||
| b7e7c8 | 1 | -- Updates from version 0.3.1 |
| AM | 2 | |
| 3 | DROP INDEX identities_user_id_idx; | |
| 4 | CREATE INDEX identities_user_id_idx ON identities (user_id, del); | |
| 5 | ||
| 6 | ALTER TABLE identities ADD changed timestamp with time zone DEFAULT now() NOT NULL; | |
| 7 | ||
| 8 | CREATE SEQUENCE contactgroups_ids | |
| 9 | INCREMENT BY 1 | |
| 10 | NO MAXVALUE | |
| 11 | NO MINVALUE | |
| 12 | CACHE 1; | |
| 13 | ||
| 14 | CREATE TABLE contactgroups ( | |
| 15 | contactgroup_id integer DEFAULT nextval('contactgroups_ids'::text) PRIMARY KEY, | |
| 16 | user_id integer NOT NULL | |
| 17 | REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE, | |
| 18 | changed timestamp with time zone DEFAULT now() NOT NULL, | |
| 19 | del smallint NOT NULL DEFAULT 0, | |
| 20 | name varchar(128) NOT NULL DEFAULT '' | |
| 21 | ); | |
| 22 | ||
| 23 | CREATE INDEX contactgroups_user_id_idx ON contactgroups (user_id, del); | |
| 24 | ||
| 25 | CREATE TABLE contactgroupmembers ( | |
| 26 | contactgroup_id integer NOT NULL | |
| 27 | REFERENCES contactgroups(contactgroup_id) ON DELETE CASCADE ON UPDATE CASCADE, | |
| 28 | contact_id integer NOT NULL | |
| 29 | REFERENCES contacts(contact_id) ON DELETE CASCADE ON UPDATE CASCADE, | |
| 30 | created timestamp with time zone DEFAULT now() NOT NULL, | |
| 31 | PRIMARY KEY (contactgroup_id, contact_id) | |
| 32 | ); | |
