Reply to thread

Message: <blockquote data-quote="zombiepig" data-source="post: 77291" data-attributes="member: 12049">ok, here's my thoughts on a possible music database structure:<img src="http://werewolves.soundslikechicken.com.au/mp/mp_music_db.gif" alt="" class="fr-fic fr-dii fr-draggable " style="" />basic changes are:- addition of dateadded and datelastplayed to the song table. would make it possible to have views like 'tracks i haven't heard in a while', 'tracks recently added', etc- added 4 replaygain fields to the song table- added a 'songartistlink' and 'songgenrelink' table, to enable multiple artists/genres per song. these would be split up from a delimated list in the tags, ie, like how wmp does using the ; character. ie, the artist tag for a song could be "Dr Octagon;DJ Dexter", thus making it appear under both "dr octagon" and "dj dexter". same thing with genres - would let you classify a song as "reggae;hip-hop" to appear under both genres! <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin    :D" loading="lazy" data-shortname=":D" />- added a 'songtag' table. this is the one i really wanna see <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin    :D" loading="lazy" data-shortname=":D" /> basically, when a track is scanned, any non standard tags (ie, not 'artist','year',etc) get put in this table. the custom tags could be semi-standard things, like 'composer','publisher','conductor',etc... or something totally user-defined, such as 'record label','mood','speed',.. whatever! totally up to the user <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile    :)" loading="lazy" data-shortname=":)" />secondly, i propose that the music views setup be changed so it's like this:[CODE]selection  operation   restriction   limit   sort   sortorder   viewas[/CODE]operation, restriction, limit, viewas will be the same as they are now.selection and sort will list:albumartistalbumartisttitlegenreyeartrackratingfavourite, then all unique tag names from songtag table eg:composerconductorrecord labelmood... (depending on how user has tagged files)my theory is that this will allow almost infinite flexibility with organizing music, without penalizing new users or people who don't want to configure things!! here's some example views that would be possible:albums (sorted by artist) -> tracksalbumartist -> albums (sorted by year descending (newest first)) -> trackscomposer -> year -> conductor -> trackscomposer -> year -> orchestra -> tracksgenre -> mood -> tempo -> tracks..... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin    :D" loading="lazy" data-shortname=":D" />ok - now let me know what i've got wrong <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink    ;)" loading="lazy" data-shortname=";)" /></blockquote>

Verification