-- DropForeignKey
ALTER TABLE "CustomerBranchCitizen" DROP CONSTRAINT "CustomerBranchCitizen_customerBranchId_fkey";

-- DropForeignKey
ALTER TABLE "CustomerBranchCommercialRegis" DROP CONSTRAINT "CustomerBranchCommercialRegis_customerBranchId_fkey";

-- DropForeignKey
ALTER TABLE "CustomerBranchHouseRegis" DROP CONSTRAINT "CustomerBranchHouseRegis_customerBranchId_fkey";

-- DropForeignKey
ALTER TABLE "CustomerBranchPoa" DROP CONSTRAINT "CustomerBranchPoa_customerBranchId_fkey";

-- DropForeignKey
ALTER TABLE "CustomerBranchVatRegis" DROP CONSTRAINT "CustomerBranchVatRegis_customerBranchId_fkey";

-- AddForeignKey
ALTER TABLE "CustomerBranchCitizen" ADD CONSTRAINT "CustomerBranchCitizen_customerBranchId_fkey" FOREIGN KEY ("customerBranchId") REFERENCES "CustomerBranch"("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "CustomerBranchPoa" ADD CONSTRAINT "CustomerBranchPoa_customerBranchId_fkey" FOREIGN KEY ("customerBranchId") REFERENCES "CustomerBranch"("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "CustomerBranchHouseRegis" ADD CONSTRAINT "CustomerBranchHouseRegis_customerBranchId_fkey" FOREIGN KEY ("customerBranchId") REFERENCES "CustomerBranch"("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "CustomerBranchCommercialRegis" ADD CONSTRAINT "CustomerBranchCommercialRegis_customerBranchId_fkey" FOREIGN KEY ("customerBranchId") REFERENCES "CustomerBranch"("id") ON DELETE CASCADE ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "CustomerBranchVatRegis" ADD CONSTRAINT "CustomerBranchVatRegis_customerBranchId_fkey" FOREIGN KEY ("customerBranchId") REFERENCES "CustomerBranch"("id") ON DELETE CASCADE ON UPDATE CASCADE;