create or replace table accountpolls ( id int auto_increment, accountId int not null, pollId int not null, value tinyint not null, primary key (id, accountId, pollId) ) charset=latin1; create or replace index accountId on accountpolls (accountId); create or replace index pollId on accountpolls (pollId);