summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJens Georg <mail@jensge.org>2015-09-03 22:53:35 +0200
committerJens Georg <mail@jensge.org>2015-09-03 22:54:30 +0200
commit6c0e2254697600a52f7ea9042db19864221101c0 (patch)
tree80551128d623c977ca56c4674d28bfa327b2874e
parent9cc38dbd7c0a4016e8399796f0422c26018b34e7 (diff)
downloadrygel-6c0e2254697600a52f7ea9042db19864221101c0.tar.gz
db: Fix schema creation
Signed-off-by: Jens Georg <mail@jensge.org>
-rw-r--r--src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala1
-rw-r--r--src/plugins/media-export/rygel-media-export-media-cache.vala2
2 files changed, 3 insertions, 0 deletions
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 ());