Mine

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));