aboutsummaryrefslogtreecommitdiff
path: root/migrations/00-initial.sql
diff options
context:
space:
mode:
Diffstat (limited to 'migrations/00-initial.sql')
-rw-r--r--migrations/00-initial.sql3
1 files changed, 2 insertions, 1 deletions
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)
);