CREATE TABLE `theTable` ( `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`)
	)