feat(auth): jwt

1 files changed, 15 insertions, 4 deletions

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