DROP TABLE IF EXISTS member;
DROP TABLE IF EXISTS member_relationships;


CREATE TABLE member (
	memberid int not null auto_increment,
	name text not null,
	primary key (memberid)
);

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