-- AlterTable
ALTER TABLE "programme" ADD COLUMN     "created_by_id" TEXT;

-- AlterTable
ALTER TABLE "programme_session" ALTER COLUMN "created_date_time" SET DATA TYPE TIMESTAMPTZ(6),
ALTER COLUMN "end_date_time" SET DATA TYPE TIMESTAMPTZ(6),
ALTER COLUMN "start_date_time" SET DATA TYPE TIMESTAMPTZ(6);

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