diff options
Diffstat (limited to 'prisma/migrations/20231208195456_add_delete_cascade/migration.sql')
| -rw-r--r-- | prisma/migrations/20231208195456_add_delete_cascade/migration.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/prisma/migrations/20231208195456_add_delete_cascade/migration.sql b/prisma/migrations/20231208195456_add_delete_cascade/migration.sql new file mode 100644 index 0000000..80914fd --- /dev/null +++ b/prisma/migrations/20231208195456_add_delete_cascade/migration.sql @@ -0,0 +1,17 @@ +-- 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; |