-- Migration: add password reset fields to admins
-- Run this against an existing bmmg_records database that predates
-- these columns (fresh installs already get them via schema.sql).
--
-- On cPanel: paste this into phpMyAdmin's SQL tab for the bmmg_records
-- database, or run via the mysql CLI if you have shell access:
--   mysql -u <user> -p bmmg_records < 003_add_password_reset_fields.sql

USE tokensto_bmmg_records;

ALTER TABLE admins
  ADD COLUMN reset_token_hash       VARCHAR(64) NULL AFTER password_hash,
  ADD COLUMN reset_token_expires_at TIMESTAMP   NULL AFTER reset_token_hash;
