I 'm looking to add a Friends section to my website, right now I have built the user sign up / management myself and it works great. Now I want my users to be able to make friends with each other.
I was thinking of creating a new table called my_friends but I'm not sure how the table should be setup. Should I just have a column for user_id and then friends_id and thats how the users are associated?
I'm not really sure, does anyone have any tips for me?