-- AlterTable
ALTER TABLE "User" ADD COLUMN     "adresse" VARCHAR(250),
ADD COLUMN     "collegeId" TEXT,
ADD COLUMN     "commissions" TEXT[] DEFAULT ARRAY[]::TEXT[],
ADD COLUMN     "details" TEXT,
ADD COLUMN     "mandateId" TEXT,
ADD COLUMN     "provinceId" TEXT;

-- AddForeignKey
ALTER TABLE "User" ADD CONSTRAINT "User_collegeId_fkey" FOREIGN KEY ("collegeId") REFERENCES "College"("id") ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "User" ADD CONSTRAINT "User_provinceId_fkey" FOREIGN KEY ("provinceId") REFERENCES "Province"("id") ON DELETE RESTRICT ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "User" ADD CONSTRAINT "User_mandateId_fkey" FOREIGN KEY ("mandateId") REFERENCES "Mandate"("id") ON DELETE RESTRICT ON UPDATE CASCADE;