ALTER TABLE `customers`
    ADD COLUMN `emailOptOut` BOOLEAN NOT NULL DEFAULT false;

ALTER TABLE `renewal_notices`
    ADD COLUMN `providerMessageId` VARCHAR(191) NULL;

CREATE TABLE `scheduled_job_states` (
    `name` VARCHAR(191) NOT NULL,
    `lockedUntil` DATETIME(3) NULL,
    `lastSuccessfulAt` DATETIME(3) NULL,
    `createdAt` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
    `updatedAt` DATETIME(3) NOT NULL,

    PRIMARY KEY (`name`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
