onasty/migrations/20250821143449_change_email_tokens.up.sql(view raw)
1 2 3 4 5 6 7 8 9 |
CREATE TABLE change_email_tokens (
id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (),
user_id uuid NOT NULL REFERENCES users (id),
token varchar(255) NOT NULL UNIQUE,
new_email varchar(255) NOT NULL UNIQUE,
created_at timestamptz NOT NULL DEFAULT now(),
expires_at timestamptz NOT NULL,
used_at timestamptz DEFAULT NULL
);
|