CREATE TABLE `theTable` ( `response_id` smallint(5) unsigned NOT NULL default '0', `respondent_id` smallint(5) unsigned NOT NULL default '0', PRIMARY KEY (`response_id`,`respondent_id`) ) TYPE=MyISAM