/*
  Warnings:

  - You are about to drop the column `country_id` on the `Educational_Qualifications_Jurisdictions` table. All the data in the column will be lost.
  - Added the required column `educational_country_id` to the `Educational_Qualifications_Jurisdictions` table without a default value. This is not possible if the table is not empty.

*/
-- DropForeignKey
ALTER TABLE `Educational_Qualifications_Jurisdictions` DROP FOREIGN KEY `Educational_Qualifications_Jurisdictions_country_id_fkey`;

-- AlterTable
ALTER TABLE `Educational_Qualifications_Jurisdictions` DROP COLUMN `country_id`,
    ADD COLUMN `educational_country_id` VARCHAR(191) NOT NULL;

-- AddForeignKey
ALTER TABLE `Educational_Qualifications_Jurisdictions` ADD CONSTRAINT `Educational_Qualifications_Jurisdictions_educational_countr_fkey` FOREIGN KEY (`educational_country_id`) REFERENCES `Country`(`country_id`) ON DELETE RESTRICT ON UPDATE CASCADE;