[mythtv-users] [PATCH] Mythweb -- Mythmusic playlist functionality AND Request for SQL help

[Ryan Steffes]

On Wed, 27 Oct 2004 14:45:48 -0400, Christopher Flynn
<flynnguy at gmail.com> wrote:
> Well I took a quick look at things and I downloaded your patch and I
> think there needs to be some work done in mythmusic itself to allow
> multiple playlists. (Unless I'm missing something here)
> 
> Perhaps I should take this over to the devlist but it almost seems
> silly to only allow for one playlist. I also think the database should
> be changed a little. we need a lookup table that consists of the
> playlistid and the songid (intid) we could then drop the songlist
> field and have individual entries that would have the playlist that
> the song belongs to and then the song itself.
> 
> You could then order things however you want. You could even add a
> order number field to the lookup table and allow the user to order
> their playlists to play things in a certain order. Maybe I'll take a
> look at it later but I don't really have all that much free time right
> now.
> 
> 

Not sure what you mean, playlists are stored in musicplaylists and are
keyed off of playlistid.  The way it goes is each playlist has a
playlistid, name, hostname, and songlist.  The song list is a string
containing the intid of each song in the playlist seperated by commas.
 I do agree though, that seperate table related songs to playlist may
be more useful, but this way is fairly robust with some limited
exceptions.