1 -- Updates from version 0.3-stable
4 DROP INDEX ix_messages_user_cache_uid;
5 CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid);
6 CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx);
7 DROP INDEX ix_contacts_user_id;
8 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);
10 -- Updates from version 0.3.1
12 -- ALTER TABLE identities ADD COLUMN changed datetime NOT NULL default '0000-00-00 00:00:00'; --
14 CREATE TABLE temp_identities (
15 identity_id integer NOT NULL PRIMARY KEY,
16 user_id integer NOT NULL default '0',
17 standard tinyint NOT NULL default '0',
18 name varchar(128) NOT NULL default '',
19 organization varchar(128) default '',
20 email varchar(128) NOT NULL default '',
21 "reply-to" varchar(128) NOT NULL default '',
22 bcc varchar(128) NOT NULL default '',
23 signature text NOT NULL default '',
24 html_signature tinyint NOT NULL default '0'
26 INSERT INTO temp_identities (identity_id, user_id, standard, name, organization, email, "reply-to", bcc, signature, html_signature)
27 SELECT identity_id, user_id, standard, name, organization, email, "reply-to", bcc, signature, html_signature
28 FROM identities WHERE del=0;
30 DROP INDEX ix_identities_user_id;
31 DROP TABLE identities;
33 CREATE TABLE identities (
34 identity_id integer NOT NULL PRIMARY KEY,
35 user_id integer NOT NULL default '0',
36 changed datetime NOT NULL default '0000-00-00 00:00:00',
37 del tinyint NOT NULL default '0',
38 standard tinyint NOT NULL default '0',
39 name varchar(128) NOT NULL default '',
40 organization varchar(128) default '',
41 email varchar(128) NOT NULL default '',
42 "reply-to" varchar(128) NOT NULL default '',
43 bcc varchar(128) NOT NULL default '',
44 signature text NOT NULL default '',
45 html_signature tinyint NOT NULL default '0'
47 CREATE INDEX ix_identities_user_id ON identities(user_id, del);
49 INSERT INTO identities (identity_id, user_id, standard, name, organization, email, "reply-to", bcc, signature, html_signature)
50 SELECT identity_id, user_id, standard, name, organization, email, "reply-to", bcc, signature, html_signature
53 DROP TABLE temp_identities;
55 CREATE TABLE contactgroups (
56 contactgroup_id integer NOT NULL PRIMARY KEY,
57 user_id integer NOT NULL default '0',
58 changed datetime NOT NULL default '0000-00-00 00:00:00',
59 del tinyint NOT NULL default '0',
60 name varchar(128) NOT NULL default ''
63 CREATE INDEX ix_contactgroups_user_id ON contactgroups(user_id, del);
65 CREATE TABLE contactgroupmembers (
66 contactgroup_id integer NOT NULL,
67 contact_id integer NOT NULL default '0',
68 created datetime NOT NULL default '0000-00-00 00:00:00',
69 PRIMARY KEY (contactgroup_id, contact_id)
72 -- Updates from version 0.3.1
74 CREATE TABLE tmp_users (
75 user_id integer NOT NULL PRIMARY KEY,
76 username varchar(128) NOT NULL default '',
77 mail_host varchar(128) NOT NULL default '',
78 alias varchar(128) NOT NULL default '',
79 created datetime NOT NULL default '0000-00-00 00:00:00',
80 last_login datetime NOT NULL default '0000-00-00 00:00:00',
82 preferences text NOT NULL default ''
85 INSERT INTO tmp_users (user_id, username, mail_host, alias, created, last_login, language, preferences)
86 SELECT user_id, username, mail_host, alias, created, last_login, language, preferences FROM users;
91 user_id integer NOT NULL PRIMARY KEY,
92 username varchar(128) NOT NULL default '',
93 mail_host varchar(128) NOT NULL default '',
94 alias varchar(128) NOT NULL default '',
95 created datetime NOT NULL default '0000-00-00 00:00:00',
96 last_login datetime DEFAULT NULL,
98 preferences text NOT NULL default ''
101 INSERT INTO users (user_id, username, mail_host, alias, created, last_login, language, preferences)
102 SELECT user_id, username, mail_host, alias, created, last_login, language, preferences FROM tmp_users;
104 CREATE INDEX ix_users_username ON users(username);
105 CREATE INDEX ix_users_alias ON users(alias);
106 DROP TABLE tmp_users;
108 -- Updates from version 0.4.2
110 DROP INDEX ix_users_username;
111 CREATE UNIQUE INDEX ix_users_username ON users(username, mail_host);
113 CREATE TABLE contacts_tmp (
114 contact_id integer NOT NULL PRIMARY KEY,
115 user_id integer NOT NULL default '0',
116 changed datetime NOT NULL default '0000-00-00 00:00:00',
117 del tinyint NOT NULL default '0',
118 name varchar(128) NOT NULL default '',
119 email varchar(255) NOT NULL default '',
120 firstname varchar(128) NOT NULL default '',
121 surname varchar(128) NOT NULL default '',
122 vcard text NOT NULL default ''
125 INSERT INTO contacts_tmp (contact_id, user_id, changed, del, name, email, firstname, surname, vcard)
126 SELECT contact_id, user_id, changed, del, name, email, firstname, surname, vcard FROM contacts;
129 CREATE TABLE contacts (
130 contact_id integer NOT NULL PRIMARY KEY,
131 user_id integer NOT NULL default '0',
132 changed datetime NOT NULL default '0000-00-00 00:00:00',
133 del tinyint NOT NULL default '0',
134 name varchar(128) NOT NULL default '',
135 email varchar(255) NOT NULL default '',
136 firstname varchar(128) NOT NULL default '',
137 surname varchar(128) NOT NULL default '',
138 vcard text NOT NULL default ''
141 INSERT INTO contacts (contact_id, user_id, changed, del, name, email, firstname, surname, vcard)
142 SELECT contact_id, user_id, changed, del, name, email, firstname, surname, vcard FROM contacts_tmp;
144 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);
145 DROP TABLE contacts_tmp;