item_sparse

The `item_appearance` table

This table holds information on every applied item hotfix and can overwrite existing items within the game. Together with item, item_modified_appearance and item_modified_appearance they present the means to hotfix an item.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
ID	int(10)	unsigned	PRI	NO	0
Quality	int(10)	unsigned		NO	0
Flags	int(10)	unsigned		NO	0
Unk1	float	signed		NO	0
Unk2	float	signed		NO	0
BuyCount	int(10)	unsigned		NO	0
BuyPrice	int(10)	unsigned		NO	0
SellPrice	int(10)	unsigned		NO	0
InventoryType	int(10)	unsigned		NO	0
AllowableClass	int(11)	signed		NO	0
AllowableRace	int(11)	signed		NO	0
ItemLevel	int(10)	unsigned		NO	0
RequiredLevel	int(10)	signed		NO	0
RequiredSkill	int(10)	unsigned		NO	0
RequiredSkillRank	int(10)	unsigned		NO	0
RequiredSpell	int(10)	unsigned		NO	0
RequiredHonorRank	int(10)	unsigned		NO	0
RequiredCityRank	int(10)	unsigned		NO	0
RequiredReputationFaction	int(10)	unsigned		NO	0
RequiredReputationRank	int(10)	unsigned		NO	0
MaxCount	int(10)	unsigned		NO	0
Stackable	int(10)	unsigned		NO	0
ContainerSlots	int(10)	unsigned		NO	0
ItemStatType	int(11)	signed		NO	0
ItemStatValue	int(11)	signed		NO	0
ItemStatAllocation	int(11)	signed		NO	0
ItemStatSocketCostMultiplier	float	signed		NO	0
ScalingStatDistribution	int(10)	unsigned		NO	0
DamageType	int(10)	unsigned		NO	0
Delay	int(10)	unsigned		NO	0
RangedModRange	float	signed		NO	0
Bonding	int(10)	unsigned		NO	0
Name	TEXT			YES
Description	TEXT			YES
PageText	int(10)	unsigned		NO	0
LanguageID	int(10)	unsigned		NO	0
PageMaterial	int(10)	unsigned		NO	0
StartQuest	int(10)	unsigned		NO	0
LockID	int(10)	unsigned