CREATE TABLE `passiveProfileAOI` ( `userId` char(22) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `fieldId` char(22) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `value` char(100) NOT NULL, `count` int(11) DEFAULT NULL, PRIMARY KEY (`userId`,`fieldId`,`value`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8