diff options
| author | Joshua M. Boniface <joshua@boniface.me> | 2025-09-28 12:26:40 -0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2025-09-28 12:26:40 -0400 |
| commit | 4942b2c15f1fadfe769534bcf3f80c0895a5a2a1 (patch) | |
| tree | df9cd125d96c72d53e86691ed18f8eed10161fb7 /src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs | |
| parent | baa7f5f0b02df1ca755addac661d21286510512b (diff) | |
| parent | 3fc71293b4e8c30b7cdf2b7d2154a8a0c97fad79 (diff) | |
Merge pull request #14890 from nielsvanvelzen/destructive-migrationv10.11.0-rc8
Fix AddProperParentChildRelationBaseItemWithCascade migration deleting all items
Diffstat (limited to 'src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs')
| -rw-r--r-- | src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20250913211637_AddProperParentChildRelationBaseItemWithCascade.cs | 8 |
1 files 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", |