-- Adds an explicit provenance flag to salary_statistics so the UI can
-- honestly label a range as real (Jooble-derived) vs an AI estimate
-- (Claude, used when too few real postings listed a salary) vs none.
ALTER TABLE salary_statistics
    ADD COLUMN source ENUM('jooble','ai_estimate','none') NOT NULL DEFAULT 'none' AFTER confidence;
