create or replace table accountcointransactions
(
	id int auto_increment
		primary key,
	accountId int not null,
	reason varchar(100) null,
	coins int null,
	constraint accountCoinTransactions_ibfk_1
		foreign key (accountId) references accounts (id)
)
charset=latin1;

create or replace index accountId
	on accountcointransactions (accountId);