-- Adiciona campos de empresa e status de encaminhamento na tabela de agenda de entrevistas
ALTER TABLE interview_schedules
    ADD COLUMN IF NOT EXISTS company VARCHAR(255) NULL COMMENT 'Empresa (para entrevistas in company)' AFTER responsible,
    ADD COLUMN IF NOT EXISTS forwarding_status ENUM('pending', 'approved', 'rejected') NOT NULL DEFAULT 'pending' COMMENT 'Status do encaminhamento' AFTER candidate_name,
    ADD INDEX IF NOT EXISTS idx_company (company),
    ADD INDEX IF NOT EXISTS idx_forwarding_status (forwarding_status);


