mirror of
https://github.com/spliit-app/spliit.git
synced 2026-02-23 07:56:12 +01:00
18 lines
795 B
SQL
18 lines
795 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "Expense" DROP CONSTRAINT "Expense_groupId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "Expense" DROP CONSTRAINT "Expense_paidById_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "ExpensePaidFor" DROP CONSTRAINT "ExpensePaidFor_participantId_fkey";
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Expense" ADD CONSTRAINT "Expense_groupId_fkey" FOREIGN KEY ("groupId") REFERENCES "Group"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Expense" ADD CONSTRAINT "Expense_paidById_fkey" FOREIGN KEY ("paidById") REFERENCES "Participant"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "ExpensePaidFor" ADD CONSTRAINT "ExpensePaidFor_participantId_fkey" FOREIGN KEY ("participantId") REFERENCES "Participant"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|