d6jg wrote: > There are 3 significant tables in the db > Albums > Tracks > Contributors > > Album_id is the ID no assigned to an an album in the albums table > > Every Contributor has an ID > The contributors table contains an entry for any entity the scan finds > whether it be band, artist, composer, conductor etc > > Artist_id is from the Tracks table and equates to the Contributor ID of > the principal track artist (I think - Im typing from memory). In the > tracks table you will also find columns for album_id, composer_id etc > etc > > As I say a bit of a dig into the tables explains a lot. If you do take a > look make sure you only look at a copy of library.db and stop LMS before > you take the copy. > > I think Im correct in saying that the LMS scanner uses a piece of > generic Perl - Audio::Scan - but its Michael and his predecessors who > have decided how to populate the database from the tags data it finds > accordingly. > > Everything in LMS works from the db except Music Folder browsing and > More, More Info, View TagsAll tracks have entries for album and > primary_artist so I still don't know why I can't click on the links.
Sent from my Pixel 3a using Tapatalk ------------------------------------------------------------------------ slartibartfast's Profile: http://forums.slimdevices.com/member.php?userid=35609 View this thread: http://forums.slimdevices.com/showthread.php?t=109624
_______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins