Hello to all! I am interested in improving Moovida's music album support.
There are many improvements to be done, here are some bugs I am interested in working on : https://bugs.launchpad.net/moovida/+bug/276698 "Only one artist associated to multiple-artists' CDs" https://bugs.launchpad.net/moovida/+bug/351614 "Only one music album for all albums with the same name" https://bugs.launchpad.net/moovida/+bug/311138 "Multiple-CDs albums not correctly displayed in the music library"
And a related discussion on the forum about music album : http://www.moovida.com/forums/viewtopic.php?f=8&t=1571
Before doing any improvement, the first thing to do, I guess, is change the primary key of music_album table. Now it is on the name field but it should also include the artist and maybe some new fields like CD number.
Usually, having multiple field primary keys is not good (this means multiple field reference keys and larger queries). Moreover, having information in the primary key is not so good (if you have to change this information, you have to change it in child records also). For these reasons, the primary key should be an auto generated integer.
Changing the primary key means changing album_name from music_albums to album_id. This means also changing some code in the database plugin for retrieving albums.
Before begining with that, I'd like to have your opinion about that.
