CREATE TABLE `searchgroup` (
  `searchgroupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contenttypeid` int(10) unsigned NOT NULL,
  `groupid` int(10) unsigned NOT NULL,
  `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(100) NOT NULL,
  PRIMARY KEY (`searchgroupid`),
  UNIQUE KEY `groupunique` (`contenttypeid`,`groupid`),
  KEY `dateline` (`dateline`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=7999956 DEFAULT CHARSET=utf8