-- AlterTable
ALTER TABLE `site_blog` MODIFY `sb_content` MEDIUMTEXT NOT NULL;

-- AlterTable
ALTER TABLE `subscriber_mail_queue` MODIFY `smq_content` MEDIUMTEXT NOT NULL;

-- CreateTable
CREATE TABLE `site_contact_reply` (
    `scr_id` INTEGER NOT NULL AUTO_INCREMENT,
    `scr_sc_id` INTEGER NOT NULL,
    `scr_reply` MEDIUMTEXT NOT NULL,
    `scr_date` INTEGER NULL DEFAULT 0,

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

-- AddForeignKey
ALTER TABLE `site_contact_reply` ADD CONSTRAINT `site_contact_reply_scr_sc_id_fkey` FOREIGN KEY (`scr_sc_id`) REFERENCES `site_contact`(`sc_id`) ON DELETE RESTRICT ON UPDATE CASCADE;
