create or replace table accounts
(
	id int auto_increment,
	uuid varchar(100) not null,
	name varchar(40) not null,
	gems int default 2500 null,
	lastLogin timestamp default current_timestamp() not null,
	totalPlayTime tinytext null,
	gold int default 1000 not null,
	coins int default 5000 null,
	donorRank varchar(20) null,
	`rank` varchar(20) default 'ALL' null,
	rankPerm tinyint null,
	rankExpire timestamp default current_timestamp() not null on update current_timestamp(),
	constraint id
		unique (id)
)
charset=latin1;