diff options
| author | Luke Pulverenti <luke.pulverenti@gmail.com> | 2016-05-15 21:22:22 -0400 |
|---|---|---|
| committer | Luke Pulverenti <luke.pulverenti@gmail.com> | 2016-05-15 21:22:22 -0400 |
| commit | 233f9cb238201c7dfdb060b718ff635947161f30 (patch) | |
| tree | aca23f1b693093b7acf60ba354b5c8bf3637cf12 /MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs | |
| parent | 5f1e0cf2d344d6fdbc18b09d6ab3552e208434c1 (diff) | |
update shared components
Diffstat (limited to 'MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs')
| -rw-r--r-- | MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs b/MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs index cecf03ddf..10e8c5699 100644 --- a/MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs +++ b/MediaBrowser.Server.Implementations/Notifications/SqliteNotificationsRepository.cs @@ -41,7 +41,8 @@ namespace MediaBrowser.Server.Implementations.Notifications string[] queries = { "create table if not exists Notifications (Id GUID NOT NULL, UserId GUID NOT NULL, Date DATETIME NOT NULL, Name TEXT NOT NULL, Description TEXT, Url TEXT, Level TEXT NOT NULL, IsRead BOOLEAN NOT NULL, Category TEXT NOT NULL, RelatedId TEXT, PRIMARY KEY (Id, UserId))", - "create index if not exists idx_Notifications on Notifications(Id, UserId)", + "create index if not exists idx_Notifications1 on Notifications(Id)", + "create index if not exists idx_Notifications2 on Notifications(UserId)", //pragmas "pragma temp_store = memory", |