-- Migration: Supplier Portal v3 — Password Reset Support
-- Adds reset_token and reset_token_expires columns to supplier_portal_users

ALTER TABLE supplier_portal_users
  ADD COLUMN reset_token VARCHAR(128) DEFAULT NULL,
  ADD COLUMN reset_token_expires DATETIME DEFAULT NULL;

CREATE INDEX idx_supplier_portal_users_reset_token ON supplier_portal_users(reset_token);
