On your data mapping tables, shouldn't you have a unique key? Do you even need a key specified on those tables?
> Data mapping tables
> =========================================================
>
>
> song_locations (list of songs and locations, one to many relation)
> --------------
> song_id
> location_id [fk guild_locations]
>
>
> song_unstackables (list of songs which don't stack, one to many)
> ----------------- (this doesnt support 'other' comments, needs work here)
> song_id
> unstack_song_id
>
>
> song_comments (list of comments by type)
> -------------
> song_id
> comment_id [fk comment_types]
> comment_desc
> comment_author