create or replace table mailbox ( id int auto_increment primary key, accountId int null, sender varchar(64) null, message varchar(1024) null, archived tinyint null, deleted tinyint null, timeSent timestamp default current_timestamp() not null on update current_timestamp() ) charset=latin1; create or replace index accountId on mailbox (accountId);