/*
  Warnings:

  - The primary key for the `Interests` table will be changed. If it partially fails, the table could be left without primary key constraint.
  - You are about to drop the column `interns_interest_id` on the `Interests` table. All the data in the column will be lost.
  - The required column `interest_id` was added to the `Interests` table with a prisma-level default value. This is not possible if the table is not empty. Please add this column as optional, then populate it before making it required.

*/
-- DropForeignKey
ALTER TABLE `Intern_Interests` DROP FOREIGN KEY `Intern_Interests_interest_id_fkey`;

-- AlterTable
ALTER TABLE `Interests` DROP PRIMARY KEY,
    DROP COLUMN `interns_interest_id`,
    ADD COLUMN `interest_id` VARCHAR(191) NOT NULL,
    ADD PRIMARY KEY (`interest_id`);

-- AddForeignKey
ALTER TABLE `Intern_Interests` ADD CONSTRAINT `Intern_Interests_interest_id_fkey` FOREIGN KEY (`interest_id`) REFERENCES `Interests`(`interest_id`) ON DELETE RESTRICT ON UPDATE CASCADE;
