11 lines
633 B
SQL
11 lines
633 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "QuotationProductServiceList" DROP CONSTRAINT "QuotationProductServiceList_quotationId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "QuotationWorker" DROP CONSTRAINT "QuotationWorker_quotationId_fkey";
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "QuotationWorker" ADD CONSTRAINT "QuotationWorker_quotationId_fkey" FOREIGN KEY ("quotationId") REFERENCES "Quotation"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "QuotationProductServiceList" ADD CONSTRAINT "QuotationProductServiceList_quotationId_fkey" FOREIGN KEY ("quotationId") REFERENCES "Quotation"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|