[mythtv-users] Re: m3u2myth.pl inserting empty playlists

[Grant Edwards]

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