13120 rows in this table. Schema below.
Name | Type | Null | Key | Default |
---|---|---|---|---|
entry | mediumint(8) unsigned | NO | PRI | 0 |
class | tinyint(3) unsigned | NO | MUL | 0 |
subclass | tinyint(3) unsigned | NO | 0 | |
name | varchar(255) | NO | '' | |
description | varchar(255) | NO | '' | |
display_id | mediumint(8) unsigned | NO | 0 | |
quality | tinyint(3) unsigned | NO | 0 | |
flags | int(10) unsigned | NO | 0 | |
buy_count | tinyint(3) unsigned | NO | 1 | |
buy_price | int(10) unsigned | NO | 0 | |
sell_price | int(10) unsigned | NO | 0 | |
inventory_type | tinyint(3) unsigned | NO | 0 | |
allowable_class | mediumint(9) | NO | -1 | |
allowable_race | mediumint(9) | NO | -1 | |
item_level | tinyint(3) unsigned | NO | 0 | |
required_level | tinyint(3) unsigned | NO | 0 | |
required_skill | smallint(5) unsigned | NO | 0 | |
required_skill_rank | smallint(5) unsigned | NO | 0 | |
required_spell | mediumint(8) unsigned | NO | 0 | |
required_honor_rank | mediumint(8) unsigned | NO | 0 | |
required_city_rank | mediumint(8) unsigned | NO | 0 | |
required_reputation_faction | smallint(5) unsigned | NO | 0 | |
required_reputation_rank | smallint(5) unsigned | NO | 0 | |
max_count | smallint(5) unsigned | NO | 0 | |
stackable | smallint(5) unsigned | NO | 1 | |
container_slots | tinyint(3) unsigned | NO | 0 | |
stat_type1 | tinyint(3) | NO | 0 | |
stat_value1 | smallint(6) | NO | 0 | |
stat_type2 | tinyint(3) | NO | 0 | |
stat_value2 | smallint(6) | NO | 0 | |
stat_type3 | tinyint(3) | NO | 0 | |
stat_value3 | smallint(6) | NO | 0 | |
stat_type4 | tinyint(3) | NO | 0 | |
stat_value4 | smallint(6) | NO | 0 | |
stat_type5 | tinyint(3) | NO | 0 | |
stat_value5 | smallint(6) | NO | 0 | |
stat_type6 | tinyint(3) | NO | 0 | |
stat_value6 | smallint(6) | NO | 0 | |
stat_type7 | tinyint(3) | NO | 0 | |
stat_value7 | smallint(6) | NO | 0 | |
stat_type8 | tinyint(3) | NO | 0 | |
stat_value8 | smallint(6) | NO | 0 | |
stat_type9 | tinyint(3) | NO | 0 | |
stat_value9 | smallint(6) | NO | 0 | |
stat_type10 | tinyint(3) | NO | 0 | |
stat_value10 | smallint(6) | NO | 0 | |
delay | smallint(5) unsigned | NO | 1000 | |
range_mod | float | NO | 0 | |
ammo_type | tinyint(3) 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 | |
dmg_min3 | float | NO | 0 | |
dmg_max3 | float | NO | 0 | |
dmg_type3 | tinyint(3) unsigned | NO | 0 | |
dmg_min4 | float | NO | 0 | |
dmg_max4 | float | NO | 0 | |
dmg_type4 | tinyint(3) unsigned | NO | 0 | |
dmg_min5 | float | NO | 0 | |
dmg_max5 | float | NO | 0 | |
dmg_type5 | tinyint(3) unsigned | NO | 0 | |
block | mediumint(8) unsigned | NO | 0 | |
armor | smallint(5) | NO | 0 | |
holy_res | smallint(5) | NO | 0 | |
fire_res | smallint(5) | NO | 0 | |
nature_res | smallint(5) | NO | 0 | |
frost_res | smallint(5) | NO | 0 | |
shadow_res | smallint(5) | NO | 0 | |
arcane_res | smallint(5) | NO | 0 | |
spellid_1 | mediumint(8) unsigned | NO | 0 | |
spelltrigger_1 | tinyint(3) unsigned | NO | 0 | |
spellcharges_1 | tinyint(4) | NO | 0 | |
spellppmrate_1 | float | NO | 0 | |
spellcooldown_1 | int(11) | NO | -1 | |
spellcategory_1 | smallint(5) unsigned | NO | 0 | |
spellcategorycooldown_1 | int(11) | NO | -1 | |
spellid_2 | mediumint(8) unsigned | NO | 0 | |
spelltrigger_2 | tinyint(3) unsigned | NO | 0 | |
spellcharges_2 | tinyint(4) | NO | 0 | |
spellppmrate_2 | float | NO | 0 | |
spellcooldown_2 | int(11) | NO | -1 | |
spellcategory_2 | smallint(5) unsigned | NO | 0 | |
spellcategorycooldown_2 | int(11) | NO | -1 | |
spellid_3 | mediumint(8) unsigned | NO | 0 | |
spelltrigger_3 | tinyint(3) unsigned | NO | 0 | |
spellcharges_3 | tinyint(4) | NO | 0 | |
spellppmrate_3 | float | NO | 0 | |
spellcooldown_3 | int(11) | NO | -1 | |
spellcategory_3 | smallint(5) unsigned | NO | 0 | |
spellcategorycooldown_3 | int(11) | NO | -1 | |
spellid_4 | mediumint(8) unsigned | NO | 0 | |
spelltrigger_4 | tinyint(3) unsigned | NO | 0 | |
spellcharges_4 | tinyint(4) | NO | 0 | |
spellppmrate_4 | float | NO | 0 | |
spellcooldown_4 | int(11) | NO | -1 | |
spellcategory_4 | smallint(5) unsigned | NO | 0 | |
spellcategorycooldown_4 | int(11) | NO | -1 | |
spellid_5 | mediumint(8) unsigned | NO | 0 | |
spelltrigger_5 | tinyint(3) unsigned | NO | 0 | |
spellcharges_5 | tinyint(4) | NO | 0 | |
spellppmrate_5 | float | NO | 0 | |
spellcooldown_5 | int(11) | NO | -1 | |
spellcategory_5 | smallint(5) unsigned | NO | 0 | |
spellcategorycooldown_5 | int(11) | NO | -1 | |
bonding | tinyint(3) unsigned | NO | 0 | |
page_text | mediumint(8) unsigned | NO | 0 | |
page_language | tinyint(3) unsigned | NO | 0 | |
page_material | tinyint(3) unsigned | NO | 0 | |
start_quest | mediumint(8) unsigned | NO | 0 | |
lock_id | mediumint(8) unsigned | NO | 0 | |
material | tinyint(4) | NO | 0 | |
sheath | tinyint(3) unsigned | NO | 0 | |
random_property | mediumint(8) unsigned | NO | 0 | |
set_id | mediumint(8) unsigned | NO | 0 | |
max_durability | smallint(5) unsigned | NO | 0 | |
area_bound | mediumint(8) unsigned | NO | 0 | |
map_bound | smallint(6) | NO | 0 | |
duration | int(11) unsigned | NO | 0 | |
bag_family | mediumint(9) | NO | 0 | |
disenchant_id | mediumint(8) unsigned | NO | 0 | |
food_type | tinyint(3) unsigned | NO | 0 | |
min_money_loot | int(10) unsigned | NO | 0 | |
max_money_loot | int(10) unsigned | NO | 0 | |
extra_flags | tinyint(1) unsigned | NO | 0 | |
ignored | tinyint(1) unsigned | NO | 0 |