-- Migration: password-reset token columns for the member portal.
-- Required by: Forgot Password flow (portal/forgot_password.php,
-- portal/reset_password.php). These columns did not exist before this
-- migration, so the existing forgot/reset password code was non-functional.
-- Database: pinnadb7_customer
-- Never removes existing data — additive columns only.

ALTER TABLE `member`
    ADD COLUMN `reset_token` VARCHAR(64) NULL DEFAULT NULL AFTER `member_password`,
    ADD COLUMN `reset_token_expiry` DATETIME NULL DEFAULT NULL AFTER `reset_token`;
