Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel
titleTable 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



...