onasty/migrations/20250509131258_password_reset_tokens.up.sql(view raw)
1 2 3 4 5 6 7 8
CREATE TABLE password_reset_tokens ( id uuid PRIMARY KEY DEFAULT uuid_generate_v4 (), user_id uuid NOT NULL 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 );