From 3fc71293b4e8c30b7cdf2b7d2154a8a0c97fad79 Mon Sep 17 00:00:00 2001 From: Niels van Velzen Date: Sun, 28 Sep 2025 13:07:38 +0200 Subject: Fix AddProperParentChildRelationBaseItemWithCascade migration deleting all items --- ...50913211637_AddProperParentChildRelationBaseItemWithCascade.cs | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs b/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs index 11c84d44c..38033d07f 100644 --- a/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs +++ b/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs @@ -15,22 +15,22 @@ DELETE FROM BaseItems WHERE ParentId IS NOT NULL AND - NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE ParentId = parent.Id); + NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE parent.Id = BaseItems.ParentId); DELETE FROM BaseItems WHERE ParentId IS NOT NULL AND - NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE ParentId = parent.Id); + NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE parent.Id = BaseItems.ParentId); DELETE FROM BaseItems WHERE ParentId IS NOT NULL AND - NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE ParentId = parent.Id); + NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE parent.Id = BaseItems.ParentId); DELETE FROM BaseItems WHERE ParentId IS NOT NULL AND - NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE ParentId = parent.Id); + NOT EXISTS(SELECT 1 FROM BaseItems parent WHERE parent.Id = BaseItems.ParentId); """); migrationBuilder.AddForeignKey( name: "FK_BaseItems_BaseItems_ParentId", -- cgit v1.2.3