create or replace table items
(
	id int auto_increment
		primary key,
	name varchar(100) null,
	categoryId int null,
	rarity int null,
	constraint uniqueNameCategoryIndex
		unique (name, categoryId)
)
charset=latin1;

create or replace index categoryId
	on items (categoryId);