| | |
|---|
| | | NO MAXVALUE |
|---|
| | | NO MINVALUE |
|---|
| | | CACHE 1; |
|---|
| | | |
|---|
| | | |
|---|
| | | CREATE TABLE contactgroups ( |
|---|
| | | contactgroup_id integer DEFAULT nextval('contactgroups_ids'::text) PRIMARY KEY, |
|---|
| | | user_id integer NOT NULL |
|---|
| | |
|---|
| | | |
|---|
| | | ALTER TABLE users ALTER last_login DROP NOT NULL; |
|---|
| | | ALTER TABLE users ALTER last_login SET DEFAULT NULL; |
|---|
| | | |
|---|
| | | -- Updates from version 0.4.2 |
|---|
| | | |
|---|
| | | DROP INDEX users_username_id_idx; |
|---|
| | | ALTER TABLE users ADD UNIQUE (username, mail_host); |
|---|
| | | ALTER TABLE contacts ALTER email TYPE varchar(255); |
|---|
| | | |
|---|
| | | TRUNCATE messages; |
|---|
| | | |
|---|
| | | -- Updates from version 0.5.1 |
|---|
| | | |
|---|
| | | ALTER TABLE contacts ADD words TEXT NULL; |
|---|
| | | CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); |
|---|
