d6jg wrote: > Are you sure that is the current structure? I ask because I was looking > at the tracks table and there is a field called primary_artist (INT) > which equates to "artist" in tag terms and that isn't in the table in > your PDF.
No, I'm not sure. I found it in my archives :-) It is for sure a few years old. I can't find a way to display the database relationships with the sqlite browser I'm using. But I guess that the relationships between the album, tracks and album_contributor, track_contributor and contributor tables would still be more or less the same. >From a first glance, this is how I think these tables are linked and this will be important to create an SQL query that would retrieve the correct data. Anyway, I'm not an expert on SQL... EDIT: maybe we should ask Michael. He might have a current version. 'M-DAC' (http://www.audiolab.co.uk/M-DAC%20Series.aspx?lang=En) -> 'Focal MP1200' (http://www.mp1200.co.nf/) -> 'Focal Electra 1028 Be' (http://www.focal.com/en/electra-1000-be-2/209-electra-1028-be-3544053695099.html) 1 x SB3, 1 x SB Boom, 1 x SB Radio and 2 x SB Touch - all wireless 2 x Wandboard Dual, 1 x Wandboard Quad ReadyNAS NVX running LMS 7.9.0. iPeng on iPhone, SqueezePad & iPeng on iPad. http://www.last.fm/user/phibon ------------------------------------------------------------------------ Pascal Hibon's Profile: http://forums.slimdevices.com/member.php?userid=7969 View this thread: http://forums.slimdevices.com/showthread.php?t=104566 _______________________________________________ discuss mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/discuss
