From fb25ac7c087be0808677f431023f0769a69c76d2 Mon Sep 17 00:00:00 2001
From: Luke Pulverenti <luke.pulverenti@gmail.com>
Date: Sun, 8 May 2016 02:31:08 -0400
Subject: update user data queries

---
 .../Persistence/SqliteUserDataRepository.cs                              | 1 +
 1 file changed, 1 insertion(+)

(limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs')

diff --git a/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs b/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs
index 33a2b1187..8c521d88a 100644
--- a/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs
+++ b/MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs
@@ -47,6 +47,7 @@ namespace MediaBrowser.Server.Implementations.Persistence
 
                                 "create table if not exists userdata (key nvarchar, userId GUID, rating float null, played bit, playCount int, isFavorite bit, playbackPositionTicks bigint, lastPlayedDate datetime null)",
 
+                                "create index if not exists idx_userdata on userdata(key)",
                                 "create unique index if not exists userdataindex on userdata (key, userId)",
 
                                 //pragmas
-- 
cgit v1.2.3