ALTER TABLE maintenance_jobs
    ADD COLUMN IF NOT EXISTS rating_comment TEXT NULL AFTER maintenance_history,
    ADD COLUMN IF NOT EXISTS rating_date DATE NULL AFTER rating_comment;

ALTER TABLE maintenance_jobs
    MODIFY COLUMN requisition_status ENUM(
        'Pending',
        'Raised',
        'Approved',
        'Rejected',
        'Paid',
        'Not Paid',
        'Payment Made'
    ) NULL DEFAULT 'Pending';
