[Carnage]

To recreate the userlist table:

CREATE TABLE IF NOT EXISTS `phpbb_userlist` (
  `userid` int(10) unsigned NOT NULL default '0',
  `relationid` int(10) unsigned NOT NULL default '0',
  `type` enum('buddy','ignore') NOT NULL default 'buddy',
  `friend` enum('yes','no','pending','denied') NOT NULL default 'no',
  PRIMARY KEY  (`userid`,`relationid`,`type`),
  KEY `userid` (`relationid`),
  KEY `relationid` (`relationid`,`type`,`friend`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;