From e26d87f4fa18999c6bcfbcf32cfa85adab11acdd Mon Sep 17 00:00:00 2001 From: rtkay123 Date: Sat, 26 Jul 2025 19:24:38 +0200 Subject: feat(auth): create user call --- .../auth-service/migrations/20250723100947_user.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 crates/auth-service/migrations/20250723100947_user.sql (limited to 'crates/auth-service/migrations/20250723100947_user.sql') diff --git a/crates/auth-service/migrations/20250723100947_user.sql b/crates/auth-service/migrations/20250723100947_user.sql new file mode 100644 index 0000000..b5566fe --- /dev/null +++ b/crates/auth-service/migrations/20250723100947_user.sql @@ -0,0 +1,20 @@ +-- Add migration script here +create table auth_user ( + id uuid primary key, + email text unique not null, + 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