From 565c472918e7f9707cd8d7909ad5dbcc5a921fdf Mon Sep 17 00:00:00 2001
From: Aleksander Machniak <alec@alec.pl>
Date: Mon, 6 Aug 2012 11:08:58 +0200
Subject: Removed users.alias column, added option ('user_aliases') to use
 email address from identities as username (#1488581)

---
 SQL/postgres.update.sql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'SQL/postgres.update.sql')

diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql
index a8a9cdda8..11ab93bfc 100644
--- a/SQL/postgres.update.sql
+++ b/SQL/postgres.update.sql
@@ -180,3 +180,6 @@ ALTER TABLE contacts ALTER email TYPE text;
 
 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);
-- 
cgit v1.2.3

