-- Retain real circular requirements and application instructions after a reviewed
-- extraction becomes a normal public JobPost.
ALTER TABLE `JobPost`
    MODIFY `shortSummary` TEXT NULL,
    MODIFY `salary` TEXT NULL,
    MODIFY `description` LONGTEXT NULL,
    MODIFY `descriptionHtml` LONGTEXT NULL,
    MODIFY `descriptionText` LONGTEXT NULL,
    MODIFY `duties` LONGTEXT NULL,
    MODIFY `dutiesHtml` LONGTEXT NULL,
    MODIFY `dutiesText` LONGTEXT NULL,
    MODIFY `requirementsHtml` LONGTEXT NULL,
    MODIFY `requirementsText` LONGTEXT NULL,
    MODIFY `howToApply` LONGTEXT NULL,
    MODIFY `howToApplyHtml` LONGTEXT NULL,
    MODIFY `howToApplyText` LONGTEXT NULL,
    MODIFY `applicationInstructions` LONGTEXT NULL,
    MODIFY `applicationUrl` TEXT NULL,
    MODIFY `applicationAddress` LONGTEXT NULL,
    MODIFY `sourceUrl` TEXT NULL,
    MODIFY `departmentScope` TEXT NULL,
    MODIFY `adminNote` TEXT NULL,
    MODIFY `reviewNote` TEXT NULL;