From 10a2a316a4da8962126d59ee422be3b8dd8c0cc1 Mon Sep 17 00:00:00 2001
From: JPVenson <github@jpb.email>
Date: Sun, 20 Oct 2024 10:11:24 +0000
Subject: i have too much time. Refactored BaseItem and UserData relation

---
 .../ModelConfiguration/BaseItemConfiguration.cs               |  1 -
 .../ModelConfiguration/UserDataConfiguration.cs               | 11 ++++++-----
 2 files changed, 6 insertions(+), 6 deletions(-)

(limited to 'Jellyfin.Server.Implementations/ModelConfiguration')

diff --git a/Jellyfin.Server.Implementations/ModelConfiguration/BaseItemConfiguration.cs b/Jellyfin.Server.Implementations/ModelConfiguration/BaseItemConfiguration.cs
index ab54032715..b8419a59fc 100644
--- a/Jellyfin.Server.Implementations/ModelConfiguration/BaseItemConfiguration.cs
+++ b/Jellyfin.Server.Implementations/ModelConfiguration/BaseItemConfiguration.cs
@@ -35,7 +35,6 @@ public class BaseItemConfiguration : IEntityTypeConfiguration<BaseItemEntity>
         builder.HasIndex(e => e.ParentId);
         builder.HasIndex(e => e.PresentationUniqueKey);
         builder.HasIndex(e => new { e.Id, e.Type, e.IsFolder, e.IsVirtualItem });
-        builder.HasIndex(e => new { e.UserDataKey, e.Type });
 
         // covering index
         builder.HasIndex(e => new { e.TopParentId, e.Id });
diff --git a/Jellyfin.Server.Implementations/ModelConfiguration/UserDataConfiguration.cs b/Jellyfin.Server.Implementations/ModelConfiguration/UserDataConfiguration.cs
index 1113adb7bc..5ebdf8d593 100644
--- a/Jellyfin.Server.Implementations/ModelConfiguration/UserDataConfiguration.cs
+++ b/Jellyfin.Server.Implementations/ModelConfiguration/UserDataConfiguration.cs
@@ -13,10 +13,11 @@ public class UserDataConfiguration : IEntityTypeConfiguration<UserData>
     /// <inheritdoc/>
     public void Configure(EntityTypeBuilder<UserData> builder)
     {
-        builder.HasKey(d => new { d.Key, d.UserId });
-        builder.HasIndex(d => new { d.Key, d.UserId, d.Played });
-        builder.HasIndex(d => new { d.Key, d.UserId, d.PlaybackPositionTicks });
-        builder.HasIndex(d => new { d.Key, d.UserId, d.IsFavorite });
-        builder.HasIndex(d => new { d.Key, d.UserId, d.LastPlayedDate });
+        builder.HasKey(d => new { d.ItemId, d.UserId });
+        builder.HasIndex(d => new { d.ItemId, d.UserId, d.Played });
+        builder.HasIndex(d => new { d.ItemId, d.UserId, d.PlaybackPositionTicks });
+        builder.HasIndex(d => new { d.ItemId, d.UserId, d.IsFavorite });
+        builder.HasIndex(d => new { d.ItemId, d.UserId, d.LastPlayedDate });
+        builder.HasOne(e => e.Item);
     }
 }
-- 
cgit v1.2.3