From 6c0e2254697600a52f7ea9042db19864221101c0 Mon Sep 17 00:00:00 2001 From: Jens Georg Date: Thu, 3 Sep 2015 22:53:35 +0200 Subject: db: Fix schema creation Signed-off-by: Jens Georg --- src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala | 1 + src/plugins/media-export/rygel-media-export-media-cache.vala | 2 ++ 2 files changed, 3 insertions(+) diff --git a/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala b/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala index 33d982e2..1f84b16a 100644 --- a/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala +++ b/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala @@ -73,6 +73,7 @@ internal class Rygel.MediaExport.MediaCacheUpgrader { public void ensure_indices () { try { this.database.exec (this.sql.make (SQLString.INDEX_COMMON)); + this.database.exec (this.sql.make (SQLString.CREATE_BLACKLIST_INDEX)); this.database.analyze (); } catch (Error error) { warning (_("Failed to create indices: %s"), diff --git a/src/plugins/media-export/rygel-media-export-media-cache.vala b/src/plugins/media-export/rygel-media-export-media-cache.vala index 0cb1b881..05ab4220 100644 --- a/src/plugins/media-export/rygel-media-export-media-cache.vala +++ b/src/plugins/media-export/rygel-media-export-media-cache.vala @@ -882,6 +882,8 @@ public class Rygel.MediaExport.MediaCache : Object { db.exec (this.sql.make (SQLString.INDEX_COMMON)); db.exec (this.sql.make (SQLString.TRIGGER_CLOSURE)); db.exec (this.sql.make (SQLString.TRIGGER_REFERENCE)); + db.exec (this.sql.make (SQLString.CREATE_BLACKLIST_TABLE)); + db.exec (this.sql.make (SQLString.CREATE_BLACKLIST_INDEX)); db.commit (); db.analyze (); this.save_reset_token (GUPnP.get_uuid ()); -- cgit v1.2.1