-- =====================================================================
--  Migration: pause/resume support
--
--  Safe to run on an EXISTING database — widening an ENUM to add a new
--  value doesn't affect existing rows.
--
--  Run:  mysql -u root -p email_verifier < migrations/004_pause_resume.sql
-- =====================================================================

ALTER TABLE verification_jobs
    MODIFY COLUMN status ENUM('pending','processing','paused','completed','failed')
    NOT NULL DEFAULT 'pending';