/*
  Warnings:

  - You are about to drop the column `feedback_questionId` on the `programme_feedback` table. All the data in the column will be lost.
  - You are about to drop the column `programme_feedback_question_id` on the `programme_feedback` table. All the data in the column will be lost.
  - You are about to drop the column `feedback_questionId` on the `session_feedBack` table. All the data in the column will be lost.
  - You are about to drop the column `programme_session_feedback_question_id` on the `session_feedBack` table. All the data in the column will be lost.
  - Added the required column `feedback_question_id` to the `programme_feedback` table without a default value. This is not possible if the table is not empty.
  - Added the required column `feedback_question_id` to the `session_feedBack` table without a default value. This is not possible if the table is not empty.

*/
-- DropForeignKey
ALTER TABLE "programme_feedback" DROP CONSTRAINT "programme_feedback_feedback_questionId_fkey";

-- DropForeignKey
ALTER TABLE "programme_feedback" DROP CONSTRAINT "programme_feedback_programme_feedback_question_id_fkey";

-- DropForeignKey
ALTER TABLE "session_feedBack" DROP CONSTRAINT "session_feedBack_feedback_questionId_fkey";

-- DropForeignKey
ALTER TABLE "session_feedBack" DROP CONSTRAINT "session_feedBack_programme_session_feedback_question_id_fkey";

-- AlterTable
ALTER TABLE "programme_feedback" DROP COLUMN "feedback_questionId",
DROP COLUMN "programme_feedback_question_id",
ADD COLUMN     "feedback_question_id" TEXT NOT NULL;

-- AlterTable
ALTER TABLE "session_feedBack" DROP COLUMN "feedback_questionId",
DROP COLUMN "programme_session_feedback_question_id",
ADD COLUMN     "feedback_question_id" TEXT NOT NULL;

-- AddForeignKey
ALTER TABLE "session_feedBack" ADD FOREIGN KEY ("feedback_question_id") REFERENCES "programme_session_feedback_question"("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "programme_feedback" ADD FOREIGN KEY ("feedback_question_id") REFERENCES "programme_feedback_question"("id") ON DELETE CASCADE ON UPDATE CASCADE;
