Item instancesTable

field	type	foreign key	description
id	int(10) unsigned
char_id_owner	int(10) unsigned
char_id_guardian	int(10) unsigned
parent_item_id	int(10) unsigned
location_in_parent	smallint(4)
stack_count	int(10) unsigned
creator_mark_id	int(10) unsigned
guild_mark_id	int(10) unsigned
loc_instance	int(11) unsigned
loc_sector_id	smallint(4) unsigned
loc_x	float(14,6)
loc_y	float(14,6)
loc_z	float(14,6)
loc_yrot	float(14,6)
decay_resistance	float(3,2)
item_quality	float(5,2)
crafted_quality	float(5,2)
item_stats_id_standard	int(10) unsigned
item_stats_id_unique	int(10) unsigned
flags	varchar(200)
lock_str	int(5)
lock_skill	int(2)
openable_locks	varchar(100)
item_name	varchar(100)
item_description	varchar(255)
charges	int(3)