/*
  Warnings:

  - Added the required column `call_letter_url` to the `programme_call_letter` table without a default value. This is not possible if the table is not empty.
  - Added the required column `department_id` to the `programme_call_letter` table without a default value. This is not possible if the table is not empty.
  - Made the column `template_id` on table `programme_call_letter` required. This step will fail if there are existing NULL values in that column.

*/
-- AlterTable
ALTER TABLE "programme_call_letter" ADD COLUMN     "call_letter_code" TEXT,
ADD COLUMN     "call_letter_no" INTEGER,
ADD COLUMN     "call_letter_url" TEXT NOT NULL,
ADD COLUMN     "department_id" TEXT NOT NULL,
ALTER COLUMN "template_id" SET NOT NULL;

-- AddForeignKey
ALTER TABLE "programme_call_letter" ADD FOREIGN KEY ("department_id") REFERENCES "department"("id") ON DELETE CASCADE ON UPDATE CASCADE;
