-- AlterTable
ALTER TABLE `comment` ADD COLUMN `emissionId` INTEGER NULL,
    MODIFY `post_date` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3);

-- AlterTable
ALTER TABLE `response` MODIFY `post_date` DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3);

-- AddForeignKey
ALTER TABLE `Comment` ADD CONSTRAINT `Comment_emissionId_fkey` FOREIGN KEY (`emissionId`) REFERENCES `Emission`(`id`) ON DELETE SET NULL ON UPDATE CASCADE;
