create or replace table bonus ( accountId int not null primary key, dailytime timestamp null, ranktime date null ) charset=latin1;