Add user entity to model.

1 files changed, 30 insertions, 0 deletions

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
 ;;;;;;;;;;;;