/*
  Warnings:

  - You are about to drop the column `recommendation_letter` on the `JobRecommendations` table. All the data in the column will be lost.
  - You are about to drop the column `recommendation_statement` on the `JobRecommendations` table. All the data in the column will be lost.
  - You are about to drop the column `recommender` on the `JobRecommendations` table. All the data in the column will be lost.
  - Added the required column `referee` to the `JobRecommendations` table without a default value. This is not possible if the table is not empty.
  - Added the required column `reference` to the `JobRecommendations` table without a default value. This is not possible if the table is not empty.

*/
-- AlterTable
ALTER TABLE `JobRecommendations` DROP COLUMN `recommendation_letter`,
    DROP COLUMN `recommendation_statement`,
    DROP COLUMN `recommender`,
    ADD COLUMN `referee` VARCHAR(191) NOT NULL,
    ADD COLUMN `reference` VARCHAR(191) NOT NULL;

-- CreateTable
CREATE TABLE `User_Qualifications_Jurisdictions` (
    `qualification_jurisdiction_id` VARCHAR(191) NOT NULL,
    `country_id` VARCHAR(191) NOT NULL,
    `professional_qualification_id` VARCHAR(191) NOT NULL,
    `educational_qualification_id` VARCHAR(191) NOT NULL,

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

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

-- AddForeignKey
ALTER TABLE `User_Qualifications_Jurisdictions` ADD CONSTRAINT `User_Qualifications_Jurisdictions_professional_qualificatio_fkey` FOREIGN KEY (`professional_qualification_id`) REFERENCES `Professional_Qualifications`(`pro_qualification_id`) ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE `User_Qualifications_Jurisdictions` ADD CONSTRAINT `User_Qualifications_Jurisdictions_educational_qualification_fkey` FOREIGN KEY (`educational_qualification_id`) REFERENCES `Educational_Qualifications`(`edu_qualification_id`) ON DELETE RESTRICT ON UPDATE CASCADE;
