From 7df7ad070b7a6146ad638294e379d976d363763e Mon Sep 17 00:00:00 2001
From: Marius Peter <dev@marius-peter.com>
Date: Wed, 12 Nov 2025 18:23:40 +0100
Subject: Add user entity to model.

---
 db/migrations.rkt | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

(limited to 'db/migrations.rkt')

diff --git a/db/migrations.rkt b/db/migrations.rkt
index e0a1ef2..d639116 100644
--- a/db/migrations.rkt
+++ b/db/migrations.rkt
@@ -27,6 +27,36 @@
         (set-box! migrations-box (append migrations (list (cons name-symbol sql)))))))
 
 
+;;;;;;;;
+;; USERS
+;;;;;;;;
+
+(define-migration "create table users"
+  (list
+   (create-table #:if-not-exists
+                 users
+                 #:columns
+                 [id integer #:not-null]
+                 [name text #:not-null]
+                 [role_id integer]
+                 #:constraints
+                 (primary-key id)
+                 (unique name)
+                 (foreign-key role_id
+                              #:references (user_roles id)))))
+
+(define-migration "create table user_roles"
+  (list
+   (create-table #:if-not-exists
+                 user_roles
+                 #:columns
+                 [id integer #:not-null]
+                 [name text #:not-null]
+                 #:constraints
+                 (primary-key id)
+                 (unique name))))
+
+
 ;;;;;;;;;;;;
 ;; NUTRIENTS
 ;;;;;;;;;;;;
-- 
cgit v1.2.3