CREATE TABLE `authusergroup` ( `id` int(11) NOT NULL auto_increment, `userid` varchar(32) NOT NULL default '', `groupid` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `sid_idgroupid` (`userid`,`groupid`) ) ENGINE=MyISAM;