From fba8330783caed87a4603f200bdeae634a13348d Mon Sep 17 00:00:00 2001 From: physcik Date: Wed, 15 Apr 2026 15:04:24 +0500 Subject: User model pt 1 --- db/create_script.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'db/create_script.sql') diff --git a/db/create_script.sql b/db/create_script.sql index 5b016e6..150e9c4 100644 --- a/db/create_script.sql +++ b/db/create_script.sql @@ -14,3 +14,10 @@ CREATE TABLE RangedWeapons ( updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); +CREATE TABLE Users ( + Id UUID PRIMARY KEY, + Username TEXT NOT NULL UNIQUE, + /* SHA512 encryption */ + PasswordHash VARCHAR(512) NOT NULL UNIQUE, + Role TEXT NOT NULL +); -- cgit v1.3