create or replace table newnpcsnew
(
	id int default 0 not null
		primary key,
	name varchar(255) null,
	world varchar(50) not null,
	x float not null,
	y float not null,
	z float not null,
	helmet tinytext null,
	chestplate tinytext null,
	leggings tinytext null,
	boots tinytext null,
	in_hand tinytext null,
	info tinytext null,
	yaw float default 1 not null,
	pitch float default 1 not null,
	in_hand_data int null,
	metadata varchar(32) null,
	skin_signature varchar(700) null,
	skin_value varchar(400) null,
	entity_type varchar(32) null
)
charset=latin1;