item_template

Table Structure

Holds information on every item that exists in the game. All items are created from their template stored in this table.

(See additional information in the ItemPrototype.h file.)

Field	Type	Attributes	Key	Null	Default	Comment
entry	mediumint(8)	unsigned	PRI	NO	0
class	tinyint(3)	unsigned		NO	0
subclass	tinyint(3)	unsigned		NO	0
SoundOverrideSubclass	tinyint(3)	signed		NO	-1
name	varchar(255)	signed		NO	NULL
displayid	mediumint(8)	unsigned		NO	0
Quality	tinyint(3)	unsigned		NO	0
Flags	bigint(20)	signed		NO	0
iFlagsExtra	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		NO	1
ContainerSlots	smallint(5)	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(6)	unsigned		NO	0
dmg_min1	float	signed		NO	0
dmg_max1	float	signed		NO	0
dmg_type1	tinyint(3)	unsigned		NO	0
dmg_min2	float	signed		NO	0
dmg_max2	float	signed		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	signed		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	signed		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	signed		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	signed		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	signed		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	signed		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	NULL
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(9)	signed		NO	0
TotemCategory	mediumint(9)	signed		NO	0
socketColor_1	tinyint(4)	signed		NO	0
socketContent_1	mediumint(9)	signed		NO	0
socketColor_2	tinyint(4)	signed		NO	0
socketContent_2	mediumint(9)	signed		NO	0
socketColor_3	tinyint(4)	signed		NO	0
socketContent_3	mediumint(9)	signed		NO	0
socketBonus	mediumint(9)	signed		NO	0
GemProperties	mediumint(9)	signed		NO	0
RequiredDisenchantSkill	smallint(6)	signed		NO	-1
ArmorDamageModifier	float	signed		NO	0
duration	int(10)	unsigned		NO	0	Duration in seconds
ItemLimitCategory	smallint(6)	signed		NO	0
HolidayId	int(11)	unsigned		NO	0
ScriptName	varchar(64)	signed		NO	NULL
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 (WDBVerified)	smallint(5)	signed		YES	1