From bfe3be04dde8b72bba1d0dd30ce48625b48cffa4 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Ale=C5=A1=20Smodi=C5=A1?= <aless@guru.si>
Date: Fri, 6 Nov 2015 15:39:06 +0100
Subject: Fix SAML login: account upgrading is done via the email attribute,
 username is eduPersonPrincipalName.

---
 scripts/db_update-20151106.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 scripts/db_update-20151106.sql

(limited to 'scripts')

diff --git a/scripts/db_update-20151106.sql b/scripts/db_update-20151106.sql
new file mode 100644
index 0000000..6a06dbe
--- /dev/null
+++ b/scripts/db_update-20151106.sql
@@ -0,0 +1,3 @@
+alter table codeq_user drop constraint codeq_user_uq1;
+create unique index codeq_user_username_saml_idx on codeq_user (username) where password is null;
+create unique index codeq_user_username_common_idx on codeq_user (username) where password is not null;
-- 
cgit v1.2.1