summaryrefslogtreecommitdiff
path: root/scripts
diff options
context:
space:
mode:
Diffstat (limited to 'scripts')
-rw-r--r--scripts/db_update-20151106.sql3
1 files changed, 3 insertions, 0 deletions
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;