29 lines
1.7 KiB
SQL
29 lines
1.7 KiB
SQL
-- 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;
|