aboutsummaryrefslogtreecommitdiff
path: root/src/Jellyfin.Database/Jellyfin.Database.Implementations
diff options
context:
space:
mode:
authorKGT1 <kilian.gamn@gmx.de>2026-05-05 14:12:39 +0200
committerGitHub <noreply@github.com>2026-05-05 14:12:39 +0200
commitf8ff13c8f491947a652491afa6dd407ee08980e7 (patch)
treef4fd37ed35c9ad9ae92465fd98d1de89a75ede4c /src/Jellyfin.Database/Jellyfin.Database.Implementations
parent4464b2e2ed9d8cc3f4c520ee76dfedac3557cf0d (diff)
parentec04313317bed62728b059108cd232e9744f6354 (diff)
Merge branch 'jellyfin:master' into removeGenericConfigurationEndpoint
Diffstat (limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations')
-rw-r--r--src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs4
1 files changed, 4 insertions, 0 deletions
diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs
index 7fe1836c42..8556fb7bb3 100644
--- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs
+++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemConfiguration.cs
@@ -73,6 +73,10 @@ public class BaseItemConfiguration : IEntityTypeConfiguration<BaseItemEntity>
builder.HasIndex(e => e.SeasonId);
builder.HasIndex(e => e.SeriesId);
+ // Items/Counts: SELECT Type, COUNT(*) GROUP BY Type filtered by TopParentId.
+ builder.HasIndex(e => new { e.TopParentId, e.Type, e.IsVirtualItem })
+ .HasFilter("\"PrimaryVersionId\" IS NULL AND (\"OwnerId\" IS NULL OR \"ExtraType\" IS NOT NULL)");
+
builder.HasData(new BaseItemEntity()
{
Id = Guid.Parse("00000000-0000-0000-0000-000000000001"),