create or replace table accounttasks ( id int auto_increment primary key, accountId int not null, taskId int not null ) charset=latin1; create or replace index accountId on accounttasks (accountId); create or replace index taskId on accounttasks (taskId);