[banshee/podcast-ng] [database/podcast-ng] Create 'CoreAlbumArtistIndex' and 'CoreTracksArtistAlbumSourceIndex' on fresh

[Michael C. Urbanski <murbanski src gnome org>]

commit 1244e07fd72ace3a218c3b24942db283f9c0905b
Author: Mike Urbanski <michael c urbanski gmail com>
Date:   Mon Apr 12 01:48:55 2010 -0500

    [database/podcast-ng] Create 'CoreAlbumArtistIndex' and 'CoreTracksArtistAlbumSourceIndex' on fresh db

 .../Banshee.Database/BansheeDbFormatMigrator.cs    |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)
---
diff --git a/src/Core/Banshee.Services/Banshee.Database/BansheeDbFormatMigrator.cs b/src/Core/Banshee.Services/Banshee.Database/BansheeDbFormatMigrator.cs
index 55d29a4..e0cac97 100644
--- a/src/Core/Banshee.Services/Banshee.Database/BansheeDbFormatMigrator.cs
+++ b/src/Core/Banshee.Services/Banshee.Database/BansheeDbFormatMigrator.cs
@@ -1033,6 +1033,7 @@ namespace Banshee.Database
             Execute("CREATE INDEX CoreTracksExternalIDIndex ON CoreTracks(PrimarySourceID, ExternalID)");
             Execute("CREATE INDEX CoreTracksUriIndex ON CoreTracks(PrimarySourceID, Uri)");
             Execute("CREATE INDEX CoreTracksCoverArtIndex ON CoreTracks (PrimarySourceID, AlbumID, DateUpdatedStamp)");
+            Execute("CREATE INDEX CoreTracksArtistAlbumSourceIndex ON CoreTracks(AlbumID, ArtistID, ExternalID, PrimarySourceID)");
 
             Execute(@"
                 CREATE TABLE CoreAlbums (
@@ -1062,6 +1063,7 @@ namespace Banshee.Database
             ");
             Execute ("CREATE INDEX CoreAlbumsIndex ON CoreAlbums(ArtistID, TitleSortKey)");
             Execute ("CREATE INDEX CoreAlbumsArtistIndex ON CoreAlbums(TitleSortKey, ArtistNameSortKey)");
+            Execute ("CREATE INDEX CoreAlbumArtistIndex ON CoreAlbums(AlbumID, ArtistID)");
 
             Execute(@"
                 CREATE TABLE CoreArtists (