diff options
Diffstat (limited to 'prisma/migrations')
| -rw-r--r-- | prisma/migrations/20230810051657_ondelete_cascade/migration.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/prisma/migrations/20230810051657_ondelete_cascade/migration.sql b/prisma/migrations/20230810051657_ondelete_cascade/migration.sql new file mode 100644 index 0000000..a521884 --- /dev/null +++ b/prisma/migrations/20230810051657_ondelete_cascade/migration.sql @@ -0,0 +1,5 @@ +-- DropForeignKey +ALTER TABLE "WatchListEpisode" DROP CONSTRAINT "WatchListEpisode_userProfileId_fkey"; + +-- AddForeignKey +ALTER TABLE "WatchListEpisode" ADD CONSTRAINT "WatchListEpisode_userProfileId_fkey" FOREIGN KEY ("userProfileId") REFERENCES "UserProfile"("name") ON DELETE CASCADE ON UPDATE CASCADE; |