[rygel/rygel-0-12] media-export: Add indices for virtual containers

[Jens Georg <jensgeorg src gnome org>]

commit d56381d1483b97e66f23bd548d5c331b7b9ff834
Author: Jens Georg <mail jensge org>
Date:   Thu Sep 8 21:17:47 2011 +0200

    media-export: Add indices for virtual containers

 .../rygel-media-export-sql-factory.vala            |    8 +++++++-
 1 files changed, 7 insertions(+), 1 deletions(-)
---
diff --git a/src/plugins/media-export/rygel-media-export-sql-factory.vala b/src/plugins/media-export/rygel-media-export-sql-factory.vala
index 243e6d5..5991c91 100644
--- a/src/plugins/media-export/rygel-media-export-sql-factory.vala
+++ b/src/plugins/media-export/rygel-media-export-sql-factory.vala
@@ -233,7 +233,13 @@ internal class Rygel.MediaExport.SQLFactory : Object {
     "CREATE INDEX IF NOT EXISTS idx_closure on Closure(descendant,depth);" +
     "CREATE INDEX IF NOT EXISTS idx_closure_descendant on Closure(descendant);" +
     "CREATE INDEX IF NOT EXISTS idx_closure_ancestor on Closure(ancestor);" +
-    "CREATE INDEX IF NOT EXISTS idx_uri on Object(uri);";
+    "CREATE INDEX IF NOT EXISTS idx_uri on Object(uri);" +
+    "CREATE INDEX IF NOT EXISTS idx_meta_data_date on meta_data(date);" +
+    "CREATE INDEX IF NOT EXISTS idx_meta_data_genre on meta_data(genre);" +
+    "CREATE INDEX IF NOT EXISTS idx_meta_data_album on meta_data(album);" +
+    "CREATE INDEX IF NOT EXISTS idx_meta_data_artist_album on " +
+                                "meta_data(author, album);";
+
 
 
     private const string EXISTS_CACHE_STRING =