ALTER TABLE `JobPost`
    ADD COLUMN `focusKeyword` TEXT NULL,
    ADD COLUMN `publicContentHtml` LONGTEXT NULL,
    ADD COLUMN `publicContentText` LONGTEXT NULL,
    ADD COLUMN `contentDetailsJson` JSON NULL,
    ADD COLUMN `structuredSectionsJson` JSON NULL,
    ADD COLUMN `rankMathJson` JSON NULL,
    ADD COLUMN `readabilityScore` INTEGER NULL,
    ADD COLUMN `readabilityIssuesJson` JSON NULL,
    ADD COLUMN `contentFormatVersion` VARCHAR(191) NULL,
    ADD COLUMN `contentFormattingStatus` VARCHAR(191) NULL,
    ADD COLUMN `contentFormattedAt` DATETIME(3) NULL;

ALTER TABLE `DpsaExtractedPost`
    ADD COLUMN `formattedContentJson` JSON NULL,
    ADD COLUMN `formattingStatus` VARCHAR(191) NOT NULL DEFAULT 'not_generated',
    ADD COLUMN `formattingApprovedAt` DATETIME(3) NULL,
    ADD COLUMN `formattedByAdminId` VARCHAR(191) NULL,
    ADD COLUMN `formattingUpdatedAt` DATETIME(3) NULL;