From 046dc2e32512dad2458be3e367e16e6e1a6f46f3 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen@syndamia.com>
Date: Sat, 25 Jan 2025 19:30:45 +0200
Subject: feat(models/user): Store password hash instead of plain password

---
 migrations/00-initial.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'migrations/00-initial.sql')

diff --git a/migrations/00-initial.sql b/migrations/00-initial.sql
index ba00b32..7b08719 100644
--- a/migrations/00-initial.sql
+++ b/migrations/00-initial.sql
@@ -1,10 +1,11 @@
 CREATE DATABASE IF NOT EXISTS nwfh;
 USE nwfh;
 
+-- Password is BCRYPT encrypted, and is maximum 72 characters
 CREATE TABLE IF NOT EXISTS Users (
     UID      INT                   NOT NULL AUTO_INCREMENT,
     Username VARCHAR(50)           NOT NULL UNIQUE,
-    Password VARCHAR(50)           NOT NULL,
+    Password VARCHAR(72)           NOT NULL,
     Role     ENUM('User', 'Admin') NOT NULL,
     PRIMARY KEY (UID)
 );
-- 
cgit v1.2.3

