-- Adds the "JD Advice" tab's data: an AI-rewritten job description plus
-- recruiter do's/don'ts, generated alongside role extraction. NULL for any
-- analysis whose role profile came from the keyword fallback rather than
-- Claude (that path has no advice to offer).
ALTER TABLE role_profiles
    ADD COLUMN improved_job_description MEDIUMTEXT NULL AFTER confidence,
    ADD COLUMN recruiter_dos   JSON NULL AFTER improved_job_description,
    ADD COLUMN recruiter_donts JSON NULL AFTER recruiter_dos;