2 files changed, 4 insertions, 1 deletions
diff --git a/backend/migrations/2021-12-13-145111_users/down.sql b/backend/migrations/2021-12-13-145111_users/down.sql
index 441087a..49285a1 100644
--- a/backend/migrations/2021-12-13-145111_users/down.sql
+++ b/backend/migrations/2021-12-13-145111_users/down.sql
@@ -1 +1,2 @@
+DROP INDEX users_username_index
 DROP TABLE users;
 \ No newline at end of file
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