summaryrefslogtreecommitdiffstats
path: root/migrations/20240412153150_create_user_.up.sql
diff options
context:
space:
mode:
authorToby Vincent <tobyv@tobyvin.dev>2024-04-12 16:42:43 -0500
committerToby Vincent <tobyv@tobyvin.dev>2024-04-12 16:42:43 -0500
commit00d63f5a5648f76d8e9cb8597446e05901543a0c (patch)
tree3ff855a7c40d8edad0edc6a344eca6b7dec2e60b /migrations/20240412153150_create_user_.up.sql
parent9f604a8404aac4113a56ddd2203cfbe154cd0f78 (diff)
refactor: improve auth flow and router layout
Diffstat (limited to 'migrations/20240412153150_create_user_.up.sql')
-rw-r--r--migrations/20240412153150_create_user_.up.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/migrations/20240412153150_create_user_.up.sql b/migrations/20240412153150_create_user_.up.sql
new file mode 100644
index 0000000..e13fd90
--- /dev/null
+++ b/migrations/20240412153150_create_user_.up.sql
@@ -0,0 +1,7 @@
+CREATE TABLE user_ (
+ id UUID NOT NULL PRIMARY KEY,
+ name VARCHAR(100) NOT NULL,
+ email VARCHAR(255) NOT NULL UNIQUE,
+ created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(),
+ updated_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW()
+);