add index

1 files changed, 2 insertions, 1 deletions

diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
index 994d2f3e3..19932c96c 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteItemRepository.cs
@@ -245,7 +245,8 @@ namespace MediaBrowser.Server.Implementations.Persistence
             string[] postQueries =
                 {
                 "create index if not exists idx_PresentationUniqueKey on TypedBaseItems(PresentationUniqueKey)",
-                "create index if not exists idx_Type on TypedBaseItems(Type)"
+                "create index if not exists idx_Type on TypedBaseItems(Type)",
+                "create index if not exists idx_TopParentId on TypedBaseItems(TopParentId)"
             };
 
             _connection.RunQueries(postQueries, Logger);