summaryrefslogtreecommitdiff
path: root/webmail/SQL/postgres/2012080700.sql
diff options
context:
space:
mode:
authorTristan Zur <tzur@web.web.ccwn.org>2014-03-27 22:27:47 +0100
committerTristan Zur <tzur@web.web.ccwn.org>2014-03-27 22:27:47 +0100
commitb62676ca5d3d6f6ba3f019ea3f99722e165a98d8 (patch)
tree86722cb80f07d4569f90088eeaea2fc2f6e2ef94 /webmail/SQL/postgres/2012080700.sql
Initial commit of intern.ccwn.org contentsHEADmaster
Diffstat (limited to 'webmail/SQL/postgres/2012080700.sql')
-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);