create or replace table accountinventory
(
	id int auto_increment
		primary key,
	accountId int not null,
	itemId int not null,
	count int not null,
	constraint accountItemIndex
		unique (accountId, itemId)
)
charset=latin1;

create or replace index itemId
	on accountinventory (itemId);