diff options
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrations.rkt | 30 |
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 ;;;;;;;;;;;; |