-- DropForeignKey
ALTER TABLE "programme" DROP CONSTRAINT "programme_course_director_id_fkey";

-- DropForeignKey
ALTER TABLE "programme_master" DROP CONSTRAINT "programme_master_course_director_id_fkey";

-- AddForeignKey
ALTER TABLE "programme_master" ADD FOREIGN KEY ("course_director_id") REFERENCES "faculty"("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "programme" ADD FOREIGN KEY ("course_director_id") REFERENCES "faculty"("id") ON DELETE SET NULL ON UPDATE CASCADE;
