onasty: migrations/20250509131258_password_reset

onasty/migrations/20250509131258_password_reset_tokens.up.sql(view raw)

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