item_template

Field	Type	Attributes	Key	Null	Default
entry	mediumint	unsigned	PRI	NO	0
class	tinyint	unsigned	MUL	NO	0
subclass	tinyint	unsigned		NO	0
SoundOverrideSubclass	tinyint	signed		NO	-1
name	varchar(255)		MUL	NO	''
displayid	mediumint	unsigned		NO	0
Quality	tinyint	unsigned		NO	0
Flags	int	unsigned		NO	0
FlagsExtra	int	unsigned		NO	0
BuyCount	tinyint	unsigned		NO	1
BuyPrice	bigint	signed		NO	0
SellPrice	int	unsigned		NO	0
InventoryType	tinyint	unsigned		NO	0
AllowableClass	int	signed		NO	-1
AllowableRace	int	signed		NO	-1
ItemLevel	smallint	unsigned		NO	0
RequiredLevel	tinyint	unsigned		NO	0
RequiredSkill	smallint	unsigned		NO	0
RequiredSkillRank	smallint	unsigned		NO	0
requiredspell	mediumint	unsigned		NO	0
requiredhonorrank	mediumint	unsigned		NO	0
RequiredCityRank	mediumint	unsigned		NO	0
RequiredReputationFaction	smallint	unsigned		NO	0
RequiredReputationRank	smallint	unsigned		NO	0
maxcount	int	signed		NO	0
stackable	int	signed		YES	1
ContainerSlots	tinyint	unsigned		NO	0
StatsCount	tinyint	unsigned		NO	0
stat_type1	tinyint	unsigned		NO	0
stat_value1	smallint	signed		NO	0
stat_type2	tinyint	unsigned		NO	0
stat_value2	smallint	signed		NO	0
stat_type3	tinyint	unsigned		NO	0
stat_value3	smallint	signed		NO	0
stat_type4	tinyint	unsigned		NO	0
stat_value4	smallint	signed		NO	0
stat_type5	tinyint	unsigned		NO	0
stat_value5	smallint	signed		NO	0
stat_type6	tinyint	unsigned		NO	0
stat_value6	smallint	signed		NO	0
stat_type7	tinyint	unsigned		NO	0
stat_value7	smallint	signed		NO	0
stat_type8	tinyint	unsigned		NO	0
stat_value8	smallint	signed		NO	0
stat_type9	tinyint	unsigned		NO	0
stat_value9	smallint	signed		NO	0
stat_type10	tinyint	unsigned		NO	0
stat_value10	smallint	signed		NO	0
ScalingStatDistribution	smallint	signed		NO	0
ScalingStatValue	int	unsigned		NO	0
dmg_min1	float			NO	0
dmg_max1	float			NO	0
dmg_type1	tinyint	unsigned		NO	0
dmg_min2	float			NO	0
dmg_max2	float			NO	0
dmg_type2	tinyint	unsigned		NO	0
armor	smallint	unsigned		NO	0
holy_res	tinyint	unsigned		NO	0
fire_res	tinyint	unsigned		NO	0
nature_res	tinyint	unsigned		NO	0
frost_res	tinyint	unsigned		NO	0
shadow_res	tinyint	unsigned		NO	0
arcane_res	tinyint	unsigned		NO	0
delay	smallint	unsigned		NO	1000
ammo_type	tinyint	unsigned		NO	0
RangedModRange	float			NO	0
spellid_1	mediumint	signed		NO	0
spelltrigger_1	tinyint	unsigned		NO	0
spellcharges_1	smallint	signed		NO	0
spellppmRate_1	float			NO	0
spellcooldown_1	int	signed		NO	-1
spellcategory_1	smallint	unsigned		NO	0
spellcategorycooldown_1	int	signed		NO	-1
spellid_2	mediumint	signed		NO	0
spelltrigger_2	tinyint	unsigned		NO	0
spellcharges_2	smallint	signed		NO	0
spellppmRate_2	float			NO	0
spellcooldown_2	int	signed		NO	-1
spellcategory_2	smallint	unsigned		NO	0
spellcategorycooldown_2	int	signed		NO	-1
spellid_3	mediumint	signed		NO	0
spelltrigger_3	tinyint	unsigned		NO	0
spellcharges_3	smallint	signed		NO	0
spellppmRate_3	float			NO	0
spellcooldown_3	int	signed		NO	-1
spellcategory_3	smallint	unsigned		NO	0
spellcategorycooldown_3	int	signed		NO	-1
spellid_4	mediumint	signed		NO	0
spelltrigger_4	tinyint	unsigned		NO	0
spellcharges_4	smallint	signed		NO	0
spellppmRate_4	float			NO	0
spellcooldown_4	int	signed		NO	-1
spellcategory_4	smallint	unsigned		NO	0
spellcategorycooldown_4	int	signed		NO	-1
spellid_5	mediumint	signed		NO	0
spelltrigger_5	tinyint	unsigned		NO	0
spellcharges_5	smallint	signed		NO	0
spellppmRate_5	float			NO	0
spellcooldown_5	int	signed		NO	-1
spellcategory_5	smallint	unsigned		NO	0
spellcategorycooldown_5	int	signed		NO	-1
bonding	tinyint	unsigned		NO	0
description	varchar(255)			NO	''
PageText	mediumint	unsigned		NO	0
LanguageID	tinyint	unsigned		NO	0
PageMaterial	tinyint	unsigned		NO	0
startquest	mediumint	unsigned		NO	0
lockid	mediumint	unsigned		NO	0
Material	tinyint	signed		NO	0
sheath	tinyint	unsigned		NO	0
RandomProperty	mediumint	signed		NO	0
RandomSuffix	mediumint	unsigned		NO	0
block	mediumint	unsigned		NO	0
itemset	mediumint	unsigned		NO	0
MaxDurability	smallint	unsigned		NO	0
area	mediumint	unsigned		NO	0
Map	smallint	signed		NO	0
BagFamily	mediumint	signed		NO	0
TotemCategory	mediumint	signed		NO	0
socketColor_1	tinyint	signed		NO	0
socketContent_1	mediumint	signed		NO	0
socketColor_2	tinyint	signed		NO	0
socketContent_2	mediumint	signed		NO	0
socketColor_3	tinyint	signed		NO	0
socketContent_3	mediumint	signed		NO	0
socketBonus	mediumint	signed		NO	0
GemProperties	mediumint	signed		NO	0
RequiredDisenchantSkill	smallint	signed		NO	-1
ArmorDamageModifier	float			NO	0
duration	int	unsigned		NO	0
ItemLimitCategory	smallint	signed		NO	0
HolidayId	int	unsigned		NO	0
ScriptName	varchar(64)			NO	''
DisenchantID	mediumint	unsigned		NO	0
FoodType	tinyint	unsigned		NO	0
minMoneyLoot	int	unsigned		NO	0
maxMoneyLoot	int	unsigned		NO	0
flagsCustom	int	unsigned		NO	0
VerifiedBuild	smallint	signed		YES	0

¶ Structure

¶ Description of fields

¶ entry

¶ class

¶ subclass

¶ SoundOverrideSubclass

¶ name

¶ displayid

¶ Quality

¶ Flags

¶ FlagsExtra

¶ BuyCount

¶ BuyPrice

¶ SellPrice

¶ InventoryType

¶ AllowableClass

¶ AllowableRace

¶ ItemLevel

¶ RequiredLevel

¶ RequiredSkill

¶ RequiredSkillRank

¶ requiredspell

¶ requiredhonorrank

¶ RequiredCityRank

¶ RequiredReputationFaction

¶ RequiredReputationRank

¶ maxcount

¶ stackable

¶ ContainerSlots

¶ StatsCount

¶ stat_type1

¶ stat_value1

¶ stat_type2

¶ stat_value2

¶ stat_type3

¶ stat_value3

¶ stat_type4

¶ stat_value4

¶ stat_type5

¶ stat_value5

¶ stat_type6

¶ stat_value6

¶ stat_type7

¶ stat_value7

¶ stat_type8

¶ stat_value8

¶ stat_type9

¶ stat_value9

¶ stat_type10

¶ stat_value10

¶ ScalingStatDistribution

¶ ScalingStatValue

¶ dmg_min1

¶ dmg_max1

¶ dmg_type1

¶ dmg_min2

¶ dmg_max2

¶ dmg_type2

¶ armor

¶ holy_res

¶ fire_res

¶ nature_res

¶ frost_res

¶ shadow_res

¶ arcane_res

¶ delay

¶ ammo_type

¶ RangedModRange

¶ spellid_1

¶ spelltrigger_1

¶ spellcharges_1

¶ spellppmRate_1

¶ spellcooldown_1

¶ spellcategory_1

¶ spellcategorycooldown_1

¶ spellid_2

¶ spelltrigger_2

¶ spellcharges_2

¶ spellppmRate_2

¶ spellcooldown_2