1 files changed, 7 insertions, 0 deletions
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
+);