diff options
| author | Cody Robibero <cody@robibe.ro> | 2024-04-12 17:44:16 -0600 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-04-12 17:44:16 -0600 |
| commit | eccc9a0b647b8cdd7380ea83ddbb77333ce691e3 (patch) | |
| tree | 5a220754a8c8020eafb26478aeb5816cbdbcf6e9 | |
| parent | 79087eadd3a55a0671077349d3e8567d0d5a1ad9 (diff) | |
Add index for lastPlayedDate (#11342)
| -rw-r--r-- | Emby.Server.Implementations/Data/SqliteUserDataRepository.cs | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs b/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs index a5edcc58c..20359e4ad 100644 --- a/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs +++ b/Emby.Server.Implementations/Data/SqliteUserDataRepository.cs @@ -58,7 +58,8 @@ namespace Emby.Server.Implementations.Data "create unique index if not exists UserDatasIndex1 on UserDatas (key, userId)", "create index if not exists UserDatasIndex2 on UserDatas (key, userId, played)", "create index if not exists UserDatasIndex3 on UserDatas (key, userId, playbackPositionTicks)", - "create index if not exists UserDatasIndex4 on UserDatas (key, userId, isFavorite)")); + "create index if not exists UserDatasIndex4 on UserDatas (key, userId, isFavorite)", + "create index if not exists UserDatasIndex5 on UserDatas (key, userId, lastPlayedDate)")); if (!userDataTableExists) { |