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 |