/*
  Warnings:

  - You are about to drop the column `plan` on the `subscription` table. All the data in the column will be lost.

*/
-- AlterTable
ALTER TABLE `subscription` DROP COLUMN `plan`,
    ADD COLUMN `planId` VARCHAR(191) NULL,
    MODIFY `endDate` DATETIME(3) NULL;

-- AddForeignKey
ALTER TABLE `subscription` ADD CONSTRAINT `subscription_planId_fkey` FOREIGN KEY (`planId`) REFERENCES `subscriptionplan`(`id`) ON DELETE CASCADE ON UPDATE CASCADE;