blob: 8da2ed2dc709d65381c478dc411dda953cccd9ae (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
-- Add migration script here
create table auth_user (
id uuid primary key,
email text unique not null,
private_key text 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();
|
