From cd528dbb7fb5d596b47178110a3dcef9af573c8d Mon Sep 17 00:00:00 2001
From: rtkay123 <dev@kanjala.com>
Date: Fri, 25 Jul 2025 17:33:47 +0200
Subject: feat(auth): jwt

---
 crates/auth/migrations/20250723100947_user.sql | 19 +++++++++++++++----
 1 file changed, 15 insertions(+), 4 deletions(-)

(limited to 'crates/auth/migrations/20250723100947_user.sql')

diff --git a/crates/auth/migrations/20250723100947_user.sql b/crates/auth/migrations/20250723100947_user.sql
index 440afc7..b5566fe 100644
--- a/crates/auth/migrations/20250723100947_user.sql
+++ b/crates/auth/migrations/20250723100947_user.sql
@@ -2,8 +2,19 @@
 create table auth_user (
     id uuid primary key,
     email text unique not null,
-    avatar text,
-    description text,
-    updated_at text,
-    create_at timestamptz not null default now()
+    updated_at timestamptz not null default now(),
+    created_at timestamptz not null default now()
 );
+
+create or replace function set_updated_at()
+returns trigger as $$
+begin
+  new.updated_at := now();
+  return new;
+end;
+$$ language plpgsql;
+
+create trigger trigger_set_updated_at
+before update on auth_user
+for each row
+execute function set_updated_at();
-- 
cgit v1.2.3

