ALTER TABLE `character_friends` 
DROP PRIMARY KEY, ADD PRIMARY KEY (`charId`, `friendId`),
DROP column `friend_name`;