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
);
|