1 -- Updates from version 0.2-alpha
3 CREATE INDEX messages_created_idx ON messages (created);
5 -- Updates from version 0.2-beta
7 ALTER TABLE cache DROP session_id;
9 CREATE INDEX session_changed_idx ON session (changed);
10 CREATE INDEX cache_created_idx ON "cache" (created);
12 ALTER TABLE users ALTER "language" DROP NOT NULL;
13 ALTER TABLE users ALTER "language" DROP DEFAULT;
15 ALTER TABLE identities ALTER del TYPE smallint;
16 ALTER TABLE identities ALTER standard TYPE smallint;
17 ALTER TABLE contacts ALTER del TYPE smallint;
18 ALTER TABLE messages ALTER del TYPE smallint;