[mythtv-users] Re: m3u2myth.pl inserting empty playlists
Grant Edwards
grante at visi.com
Tue Aug 31 16:33:51 EDT 2004
On Tue, Aug 31, 2004 at 03:18:11PM -0500, Grant Edwards wrote:
>
> >> Is there any documentation anywhere on the "layout" of the
> >> database used by MythTv/MythMusic?
> >
> > Not really, but here's pretty much all you need to know:
> >
> > mysql -p -u mythtv mythconverg
> > {enter mythtv as password}
> > show columns from musicmetadata ;
> > select * from musicmetadata limit 1 ;
> > show columns from musicplaylist ;
> > select * from musicplaylist limit 1 ;
> > exit ;
> >
> > note that all columns in musicmetadata from mythdigest onwards are not used by
> > mythmusic (they are in the process of being used by mfd/mfe).
>
> Thanks!
>
> That actually helped a lot.
Any clue on what goes into the "songlist" field in the playlist
table? It's of type "text", but I can't tell from the Perl
code what is supposed to go in that field. I assume it's a
list of values from one of the columns in the musicmetadata
table. Is it title, filename, ??.
--
Grant Edwards
grante at visi.com
More information about the mythtv-users
mailing list