summaryrefslogtreecommitdiff
path: root/webmail/SQL/postgres/2012080700.sql
diff options
context:
space:
mode:
Diffstat (limited to '')
-rw-r--r--webmail/SQL/postgres/2012080700.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/webmail/SQL/postgres/2012080700.sql b/webmail/SQL/postgres/2012080700.sql
new file mode 100644
index 0000000..41f6016
--- /dev/null
+++ b/webmail/SQL/postgres/2012080700.sql
@@ -0,0 +1,7 @@
+-- Updates from version 0.8
+
+ALTER TABLE cache DROP COLUMN cache_id;
+DROP SEQUENCE cache_ids;
+
+ALTER TABLE users DROP COLUMN alias;
+CREATE INDEX identities_email_idx ON identities (email, del);