CREATE TABLE referrers (
  ref_id int(7) NOT NULL auto_increment,
  page varchar(150) NOT NULL default '',
  referrer varchar(150) NOT NULL default '',
  ip varchar(15) NOT NULL default '',
  datetime datetime NOT NULL default '0000-00-00 00:00:00',
  delete_flag enum('0','1') NOT NULL default '0',
  PRIMARY KEY  (ref_id),
  KEY page (page,referrer)
) TYPE=MyISAM;


CREATE TABLE titles (
  title_key int(5) NOT NULL auto_increment,
  referrer varchar(255) NOT NULL default '',
  title varchar(150) NOT NULL default '',
  PRIMARY KEY  (title_key)
) TYPE=MyISAM;