CREATE TABLE graph (
  uid1 int(10) unsigned NOT NULL default '0',
  uid2 int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;

CREATE TABLE profiles (
  uid int(10) unsigned NOT NULL default '0' PRIMARY KEY,
  name varchar(15) default NULL,
  age tinyint(3) unsigned default NULL,
  gender enum('Male','Female') default NULL,
  status enum('Single','In a Relationship','Married','Open Marriage') default NULL,
  interested_in set('Dating','Serious Relationship','Friends','Activity Partners','Just Here To Help!') default NULL,
  preference set('Men','Women') default NULL,
  location varchar(50) default NULL,
  hometown varchar(50) default NULL,
  occupation varchar(50) default NULL,
  interests varchar(255) default NULL,
  music varchar(255) default NULL,
  books varchar(255) default NULL,
  tvshows varchar(255) default NULL,
  movies varchar(255) default NULL,
  membersince date default NULL,
  lastlogin date default NULL,
  lastmod date default NULL,
  about text,
  want_to_meet text,
  photourl varchar(255) default NULL,
  nfriends int(10) NOT NULL default '0'
) TYPE=MyISAM;