diff options
| author | Jonathan Marshall <jmarshall@xbmc.org> | 2013-11-30 21:52:41 +1300 |
|---|---|---|
| committer | Jonathan Marshall <jmarshall@xbmc.org> | 2013-12-24 13:48:50 +1300 |
| commit | 21d789c39b5aec304c96c864fcb8b669cba9b5dc (patch) | |
| tree | ad583632327c9a706d9bb911e9821129f4e877e7 | |
| parent | 15ccc41a6e7fc4d18057aae8696d1837f0f4b984 (diff) | |
[musicdb] cosmetic: tidy up songview
| -rw-r--r-- | xbmc/music/MusicDatabase.cpp | 27 |
1 files changed, 17 insertions, 10 deletions
diff --git a/xbmc/music/MusicDatabase.cpp b/xbmc/music/MusicDatabase.cpp index cb9e9145df..67e12e81ad 100644 --- a/xbmc/music/MusicDatabase.cpp +++ b/xbmc/music/MusicDatabase.cpp @@ -251,16 +251,23 @@ void CMusicDatabase::CreateViews() CLog::Log(LOGINFO, "create song view"); m_pDS->exec("DROP VIEW IF EXISTS songview"); m_pDS->exec("CREATE VIEW songview AS SELECT " - " song.idSong AS idSong, " - " song.strArtists AS strArtists," - " song.strGenres AS strGenres," - " strTitle, iTrack, iDuration," - " song.iYear AS iYear, dwFileNameCRC, strFileName, strMusicBrainzTrackID," - " iTimesPlayed, iStartOffset, iEndOffset, lastplayed," - " rating, comment, song.idAlbum AS idAlbum, strAlbum, strPath," - " iKaraNumber, iKaraDelay, strKaraEncoding," - " album.bCompilation AS bCompilation," - " album.strArtists AS strAlbumArtists " + " song.idSong AS idSong, " + " song.strArtists AS strArtists," + " song.strGenres AS strGenres," + " strTitle, " + " iTrack, iDuration, " + " song.iYear AS iYear, " + " dwFileNameCRC, " + " strFileName, " + " strMusicBrainzTrackID, " + " iTimesPlayed, iStartOffset, iEndOffset, " + " lastplayed, rating, comment, " + " song.idAlbum AS idAlbum, " + " strAlbum, " + " strPath, " + " iKaraNumber, iKaraDelay, strKaraEncoding," + " album.bCompilation AS bCompilation," + " album.strArtists AS strAlbumArtists " "FROM song" " JOIN album ON" " song.idAlbum=album.idAlbum" |