item_template

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