create or replace table accountstats ( id int auto_increment primary key, accountId int not null, statId int not null, value bigint default 1 null ) charset=latin1; create or replace index accountId on accountstats (accountId); create or replace index statId on accountstats (statId);