12 lines
633 B
MySQL
12 lines
633 B
MySQL
|
-- 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;
|