0010-shomei-password-reset-tokens.sql

SET LOCAL search_path = pg_catalog, pg_temp;

CREATE TABLE IF NOT EXISTS shomei.shomei_password_reset_tokens (
  password_reset_token_id uuid PRIMARY KEY,
  user_id                 uuid NOT NULL REFERENCES shomei.shomei_users(user_id),
  token_hash              text NOT NULL UNIQUE,
  status                  text NOT NULL,
  created_at              timestamptz NOT NULL,
  expires_at              timestamptz NOT NULL,
  consumed_at             timestamptz NULL,
  revoked_at              timestamptz NULL
);

CREATE INDEX IF NOT EXISTS shomei_password_reset_tokens_user_id_idx
  ON shomei.shomei_password_reset_tokens (user_id);
CREATE INDEX IF NOT EXISTS shomei_password_reset_tokens_status_idx
  ON shomei.shomei_password_reset_tokens (status);