onasty/migrations/20240729115827_verification_tokens.up.sql(view raw)
1 2 3 4 5 6 7 8 |
create table verification_tokens ( id uuid primary key default uuid_generate_v4(), user_id uuid not null unique references users(id), token varchar(255) not null unique, created_at timestamptz not null default now(), expires_at timestamptz not null, used_at timestamptz default null ); |