Back to 'item_set_names_locale' Return to world Go to 'item_template_locale'
Field | Type | Attributes | Key | Null | Default | Extra | Comment |
---|---|---|---|---|---|---|---|
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 |
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
- no description -
Back to 'item_set_names_locale' Return to world Go to 'item_template_locale'