diff options
| author | Luke Pulverenti <luke.pulverenti@gmail.com> | 2016-05-08 02:31:08 -0400 |
|---|---|---|
| committer | Luke Pulverenti <luke.pulverenti@gmail.com> | 2016-05-08 02:31:08 -0400 |
| commit | fb25ac7c087be0808677f431023f0769a69c76d2 (patch) | |
| tree | 6ded17c324de6cd7453759ea20be117adb8f323c /MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs | |
| parent | e78565491a0c00555c083da42577ae7d865b5b0c (diff) | |
update user data queries
Diffstat (limited to 'MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Persistence/SqliteUserDataRepository.cs | 1 |
1 files changed, 1 insertions, 0 deletions
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 |