11 lines
726 B
SQL
11 lines
726 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "QuotationProductServiceWorker" DROP CONSTRAINT "QuotationProductServiceWorker_employeeId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "QuotationProductServiceWorker" DROP CONSTRAINT "QuotationProductServiceWorker_productServiceId_fkey";
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "QuotationProductServiceWorker" ADD CONSTRAINT "QuotationProductServiceWorker_productServiceId_fkey" FOREIGN KEY ("productServiceId") REFERENCES "QuotationProductServiceList"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "QuotationProductServiceWorker" ADD CONSTRAINT "QuotationProductServiceWorker_employeeId_fkey" FOREIGN KEY ("employeeId") REFERENCES "Employee"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|