From e7a20b9d8f8d7c47173c59782c5bd24a0ba6cac9 Mon Sep 17 00:00:00 2001
From: Frédéric Guillot <fred@kanboard.net>
Date: Tue, 16 Sep 2014 19:30:18 +0200
Subject: Improve API calls for users

---
 app/Schema/Mysql.php    | 7 ++++++-
 app/Schema/Postgres.php | 7 ++++++-
 app/Schema/Sqlite.php   | 7 ++++++-
 3 files changed, 18 insertions(+), 3 deletions(-)

(limited to 'app/Schema')

diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php
index 86685067..196fb856 100644
--- a/app/Schema/Mysql.php
+++ b/app/Schema/Mysql.php
@@ -4,7 +4,12 @@ namespace Schema;
 
 use Core\Security;
 
-const VERSION = 26;
+const VERSION = 27;
+
+function version_27($pdo)
+{
+    $pdo->exec('CREATE UNIQUE INDEX users_username_idx ON users(username)');
+}
 
 function version_26($pdo)
 {
diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php
index a7e57d66..3341d4a1 100644
--- a/app/Schema/Postgres.php
+++ b/app/Schema/Postgres.php
@@ -4,7 +4,12 @@ namespace Schema;
 
 use Core\Security;
 
-const VERSION = 7;
+const VERSION = 8;
+
+function version_8($pdo)
+{
+    $pdo->exec('CREATE UNIQUE INDEX users_username_idx ON users(username)');
+}
 
 function version_7($pdo)
 {
diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php
index cab69fa0..108c07f2 100644
--- a/app/Schema/Sqlite.php
+++ b/app/Schema/Sqlite.php
@@ -4,7 +4,12 @@ namespace Schema;
 
 use Core\Security;
 
-const VERSION = 26;
+const VERSION = 27;
+
+function version_27($pdo)
+{
+    $pdo->exec('CREATE UNIQUE INDEX users_username_idx ON users(username)');
+}
 
 function version_26($pdo)
 {
-- 
cgit v1.2.3