Prepare a new release for unstable

[roundcube.git] / debian / sql / pgsql / 0.2~stable-1

diff --git a/debian/sql/pgsql/0.2~stable-1 b/debian/sql/pgsql/0.2~stable-1
new file mode 100644 (file)
index 0000000..102843e
--- /dev/null
+++ b/debian/sql/pgsql/0.2~stable-1
@@ -0,0 +1,18 @@
+-- Updates from version 0.2-alpha
+
+CREATE INDEX messages_created_idx ON messages (created);
+
+-- Updates from version 0.2-beta
+
+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;