[mythtv-users] [PATCH] Mythweb -- Mythmusic playlist
functionality AND Request for SQL help
Ryan Steffes
rbsteffes at gmail.com
Wed Oct 27 20:04:30 UTC 2004
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.
More information about the mythtv-users
mailing list