--
-- Table structure for table `user_relationship`
--

CREATE TABLE IF NOT EXISTS /*_*/user_relationship (
  `r_id` int(11) PRIMARY KEY auto_increment,
  `r_user_id` int(5) unsigned NOT NULL default '0',
  `r_user_name` varchar(255) NOT NULL default '',
  `r_user_id_relation` int(5) unsigned NOT NULL default '0',
  `r_user_name_relation` varchar(255) NOT NULL default '',
  `r_type` int(2) default NULL,
  `r_date` datetime default NULL
) /*$wgDBTableOptions*/;
CREATE INDEX /*i*/r_user_id          ON /*_*/user_relationship (`r_user_id`);
CREATE INDEX /*i*/r_user_id_relation ON /*_*/user_relationship (`r_user_id_relation`);
