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

create or replace index accountId
	on mail (accountId);