From fba8330783caed87a4603f200bdeae634a13348d Mon Sep 17 00:00:00 2001
From: physcik <mynameisgennadiy@vk.com>
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

