Delete SPL entries when deleting the SPL.

1 files changed, 7 insertions, 3 deletions

diff --git a/src/lib/show_playlist_list.cc b/src/lib/show_playlist_list.cc
index 6dfbbad29..901f537ff 100644
--- a/src/lib/show_playlist_list.cc
+++ b/src/lib/show_playlist_list.cc
@@ -114,9 +114,13 @@ ShowPlaylistList::update_show_playlist(ShowPlaylistID id, ShowPlaylist const& pl
 void
 ShowPlaylistList::remove_show_playlist(ShowPlaylistID id)
 {
-	SQLiteStatement statement(_db, "DELETE FROM show_playlists WHERE ID=?");
-	statement.bind_int64(1, id.get());
-	statement.execute();
+	SQLiteStatement playlists(_db, "DELETE FROM show_playlists WHERE ID=?");
+	playlists.bind_int64(1, id.get());
+	playlists.execute();
+
+	SQLiteStatement entries(_db, "DELETE FROM entries WHERE show_playlist=?");
+	entries.bind_int64(1, id.get());
+	entries.execute();
 }