From 13cdbc7ff760ae91ee3f62b2a2f62c7559ccaa3c Mon Sep 17 00:00:00 2001
From: Ilion Beyst <ilion.beyst@gmail.com>
Date: Tue, 14 Dec 2021 20:23:07 +0100
Subject: test registration & login

---
 backend/migrations/2021-12-13-145111_users/up.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'backend/migrations/2021-12-13-145111_users/up.sql')

diff --git a/backend/migrations/2021-12-13-145111_users/up.sql b/backend/migrations/2021-12-13-145111_users/up.sql
index 6ec7e01..f35e718 100644
--- a/backend/migrations/2021-12-13-145111_users/up.sql
+++ b/backend/migrations/2021-12-13-145111_users/up.sql
@@ -3,4 +3,6 @@ CREATE TABLE users(
     username VARCHAR(52) NOT NULL,
     password_salt BYTEA NOT NULL,
     password_hash BYTEA NOT NULL
-);
\ No newline at end of file
+);
+
+CREATE UNIQUE INDEX users_username_index ON users(username);
\ No newline at end of file
-- 
cgit v1.2.3

