CREATE TABLE `responses` ( `respondent` smallint(5) unsigned NOT NULL default '0', `response` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`respondent`,`response`), KEY `respondent` (`respondent`), KEY `response` (`response`) ) TYPE=MyISAM