aboutsummaryrefslogtreecommitdiffstats
path: root/crates/atuin-server-postgres/migrations/20240621110731_user-verified.sql
blob: 6eba02ec0d77016d6bf08608f611708b61ac0325 (plain) (blame)
1
2
3
4
5
6
7
8
alter table users add verified_at timestamp with time zone default null;

create table user_verification_token(
  id bigserial primary key, 
  user_id bigint unique references users(id), 
  token text, 
  valid_until timestamp with time zone
);