CREATE TABLE member_relationships (
	memberid int not null references member(memberid),
	friendid int not null references member(memberid),
	primary key (memberid, friendid)
);