[eluser]jonnyjon[/eluser]
Hi guys,
I have a friends table but I'm debated how to lay it out and use it.
Currently. this is how it looks:
=======================================================
| id | user_id | user_id_2 | is_approved | is_blocked |
=======================================================
So if user 1 and 2 are friends it would require 2 records for that friendship, one record to say user 1 is friends with 2 and another to say user 2 is friends with 1.
==============================
| 1 | 1 | 2 | true | false |
| 2 | 2 | 1 | true | false |
==============================
There must be a more efficient way to do this?