Friend list

[waynew]

I'm designing a system that allows users to add each other as friends and was wondering if anyone had a better way of designing a table for such a system. What I have is:

 

<?php

mysql_query("

CREATE TABLE friends(
	friendship_id BIGINT(50) NOT NULL AUTO_INCREMENT,
	user_a BIGINT(50) NOT NULL,
	user_b BIGINT(50) NOT NULL,
	PRIMARY KEY(friendship_id))") or die(mysql_error());
?>

[efficacious]

well you'd atleast just need to create a table for each possibilty your giving them.. as far as options go..

 

Date Added    //Newly added friends

Date Removed  //Recently Removed friends

FriendName    //Name of friend

Ignored       //People that are not friends

 

ect..