From cd528dbb7fb5d596b47178110a3dcef9af573c8d Mon Sep 17 00:00:00 2001 From: rtkay123 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