18 lines
742 B
SQL
18 lines
742 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "Attendance" DROP CONSTRAINT "Attendance_matchId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "Team" DROP CONSTRAINT "Team_matchId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "TeamPlayer" DROP CONSTRAINT "TeamPlayer_teamId_fkey";
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Attendance" ADD CONSTRAINT "Attendance_matchId_fkey" FOREIGN KEY ("matchId") REFERENCES "Match"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Team" ADD CONSTRAINT "Team_matchId_fkey" FOREIGN KEY ("matchId") REFERENCES "Match"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "TeamPlayer" ADD CONSTRAINT "TeamPlayer_teamId_fkey" FOREIGN KEY ("teamId") REFERENCES "Team"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|