11 lines
513 B
SQL
11 lines
513 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "Invoice" DROP CONSTRAINT "Invoice_quotationId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "Payment" DROP CONSTRAINT "Payment_invoiceId_fkey";
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Invoice" ADD CONSTRAINT "Invoice_quotationId_fkey" FOREIGN KEY ("quotationId") REFERENCES "Quotation"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Payment" ADD CONSTRAINT "Payment_invoiceId_fkey" FOREIGN KEY ("invoiceId") REFERENCES "Invoice"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|