-- ============================================================
-- May Cash Franchise — Migration 2026-04-28
-- Adds: is_gold flag (Gold Candidate marker for priority follow-up)
-- Run this ONCE in phpMyAdmin (database: maymounafinance_franchise → SQL tab)
-- ============================================================

ALTER TABLE submissions
  ADD COLUMN is_gold TINYINT(1) NOT NULL DEFAULT 0 AFTER comment,
  ADD INDEX  idx_gold (is_gold);