| | |
|---|
| | | ALTER TABLE cache DROP session_id; |
|---|
| | | |
|---|
| | | CREATE INDEX session_changed_idx ON session (changed); |
|---|
| | | CREATE INDEX cache_created_idx ON "cache" (created); |
|---|
| | | |
|---|
| | | ALTER TABLE users ALTER "language" DROP NOT NULL; |
|---|
| | | ALTER TABLE users ALTER "language" DROP DEFAULT; |
|---|
| | | |
|---|
| | | ALTER TABLE identities ALTER del TYPE smallint; |
|---|
| | | ALTER TABLE identities ALTER standard TYPE smallint; |
|---|
| | | ALTER TABLE contacts ALTER del TYPE smallint; |
|---|
| | | ALTER TABLE messages ALTER del TYPE smallint; |
|---|
| | | |
|---|
| | | -- Updates from version 0.3-stable |
|---|
| | | |
|---|
| | | TRUNCATE messages; |
|---|
| | | CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx); |
|---|
| | | DROP INDEX contacts_user_id_idx; |
|---|
| | | CREATE INDEX contacts_user_id_idx ON contacts (user_id, email); |
|---|
| | | |
|---|
| | | -- Updates from version 0.3.1 |
|---|
| | | |
|---|
| | | DROP INDEX identities_user_id_idx; |
|---|
| | | CREATE INDEX identities_user_id_idx ON identities (user_id, del); |
|---|
| | | |
|---|
| | | ALTER TABLE identities ADD changed timestamp with time zone DEFAULT now() NOT NULL; |
|---|
| | | |
|---|
| | | CREATE SEQUENCE contactgroups_ids |
|---|
| | | INCREMENT BY 1 |
|---|
| | | NO MAXVALUE |
|---|
| | | NO MINVALUE |
|---|
| | | CACHE 1; |
|---|
| | | |
|---|
| | | CREATE TABLE contactgroups ( |
|---|
| | | contactgroup_id integer DEFAULT nextval('contactgroups_ids'::text) PRIMARY KEY, |
|---|
| | | user_id integer NOT NULL |
|---|
| | | REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE, |
|---|
| | | changed timestamp with time zone DEFAULT now() NOT NULL, |
|---|
| | | del smallint NOT NULL DEFAULT 0, |
|---|
| | | name varchar(128) NOT NULL DEFAULT '' |
|---|
| | | ); |
|---|
| | | |
|---|
| | | CREATE INDEX contactgroups_user_id_idx ON contactgroups (user_id, del); |
|---|
| | | |
|---|
| | | CREATE TABLE contactgroupmembers ( |
|---|
| | | contactgroup_id integer NOT NULL |
|---|
| | | REFERENCES contactgroups(contactgroup_id) ON DELETE CASCADE ON UPDATE CASCADE, |
|---|
| | | contact_id integer NOT NULL |
|---|
| | | REFERENCES contacts(contact_id) ON DELETE CASCADE ON UPDATE CASCADE, |
|---|
| | | created timestamp with time zone DEFAULT now() NOT NULL, |
|---|
| | | PRIMARY KEY (contactgroup_id, contact_id) |
|---|
| | | ); |
|---|
| | | |
|---|
| | | -- Updates from version 0.4-beta |
|---|
| | | |
|---|
| | | ALTER TABLE users ALTER last_login DROP NOT NULL; |
|---|
| | | ALTER TABLE users ALTER last_login SET DEFAULT NULL; |
|---|
