diff options
Diffstat (limited to 'docs/item_template.md')
| -rw-r--r-- | docs/item_template.md | 3857 |
1 files changed, 3714 insertions, 143 deletions
diff --git a/docs/item_template.md b/docs/item_template.md index 73304b4..b9fcf73 100644 --- a/docs/item_template.md +++ b/docs/item_template.md @@ -1,143 +1,3714 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [item_template](item_template) - -Column | Type | Description ---- | --- | --- -Entry | mediumint(8) unsigned | -Class | tinyint(3) unsigned | -Subclass | tinyint(3) unsigned | -SoundOverrideSubclass | tinyint(3) | -Name | varchar(255) | -Displayid | mediumint(8) unsigned | -Quality | tinyint(3) unsigned | -Flags | int(10) unsigned | -FlagsExtra | int(10) unsigned | -BuyCount | tinyint(3) unsigned | -BuyPrice | bigint(20) | -SellPrice | int(10) unsigned | -InventoryType | tinyint(3) unsigned | -AllowableClass | int(11) | -AllowableRace | int(11) | -ItemLevel | smallint(5) unsigned | -RequiredLevel | tinyint(3) unsigned | -RequiredSkill | smallint(5) unsigned | -RequiredSkillRank | smallint(5) unsigned | -Requiredspell | mediumint(8) unsigned | -Requiredhonorrank | mediumint(8) unsigned | -RequiredCityRank | mediumint(8) unsigned | -RequiredReputationFaction | smallint(5) unsigned | -RequiredReputationRank | smallint(5) unsigned | -Maxcount | int(11) | -Stackable | int(11) | -ContainerSlots | tinyint(3) unsigned | -StatsCount | tinyint(3) unsigned | -Stat_type1 | tinyint(3) unsigned | -Stat_value1 | smallint(6) | -Stat_type2 | tinyint(3) unsigned | -Stat_value2 | smallint(6) | -Stat_type3 | tinyint(3) unsigned | -Stat_value3 | smallint(6) | -Stat_type4 | tinyint(3) unsigned | -Stat_value4 | smallint(6) | -Stat_type5 | tinyint(3) unsigned | -Stat_value5 | smallint(6) | -Stat_type6 | tinyint(3) unsigned | -Stat_value6 | smallint(6) | -Stat_type7 | tinyint(3) unsigned | -Stat_value7 | smallint(6) | -Stat_type8 | tinyint(3) unsigned | -Stat_value8 | smallint(6) | -Stat_type9 | tinyint(3) unsigned | -Stat_value9 | smallint(6) | -Stat_type10 | tinyint(3) unsigned | -Stat_value10 | smallint(6) | -ScalingStatDistribution | smallint(6) | -ScalingStatValue | int(10) unsigned | -Dmg_min1 | float | -Dmg_max1 | float | -Dmg_type1 | tinyint(3) unsigned | -Dmg_min2 | float | -Dmg_max2 | float | -Dmg_type2 | tinyint(3) unsigned | -Armor | smallint(5) unsigned | -Holy_res | tinyint(3) unsigned | -Fire_res | tinyint(3) unsigned | -Nature_res | tinyint(3) unsigned | -Frost_res | tinyint(3) unsigned | -Shadow_res | tinyint(3) unsigned | -Arcane_res | tinyint(3) unsigned | -Delay | smallint(5) unsigned | -Ammo_type | tinyint(3) unsigned | -RangedModRange | float | -Spellid_1 | mediumint(8) | -Spelltrigger_1 | tinyint(3) unsigned | -Spellcharges_1 | smallint(6) | -SpellppmRate_1 | float | -Spellcooldown_1 | int(11) | -Spellcategory_1 | smallint(5) unsigned | -Spellcategorycooldown_1 | int(11) | -Spellid_2 | mediumint(8) | -Spelltrigger_2 | tinyint(3) unsigned | -Spellcharges_2 | smallint(6) | -SpellppmRate_2 | float | -Spellcooldown_2 | int(11) | -Spellcategory_2 | smallint(5) unsigned | -Spellcategorycooldown_2 | int(11) | -Spellid_3 | mediumint(8) | -Spelltrigger_3 | tinyint(3) unsigned | -Spellcharges_3 | smallint(6) | -SpellppmRate_3 | float | -Spellcooldown_3 | int(11) | -Spellcategory_3 | smallint(5) unsigned | -Spellcategorycooldown_3 | int(11) | -Spellid_4 | mediumint(8) | -Spelltrigger_4 | tinyint(3) unsigned | -Spellcharges_4 | smallint(6) | -SpellppmRate_4 | float | -Spellcooldown_4 | int(11) | -Spellcategory_4 | smallint(5) unsigned | -Spellcategorycooldown_4 | int(11) | -Spellid_5 | mediumint(8) | -Spelltrigger_5 | tinyint(3) unsigned | -Spellcharges_5 | smallint(6) | -SpellppmRate_5 | float | -Spellcooldown_5 | int(11) | -Spellcategory_5 | smallint(5) unsigned | -Spellcategorycooldown_5 | int(11) | -Bonding | tinyint(3) unsigned | -Description | varchar(255) | -PageText | mediumint(8) unsigned | -LanguageID | tinyint(3) unsigned | -PageMaterial | tinyint(3) unsigned | -Startquest | mediumint(8) unsigned | -Lockid | mediumint(8) unsigned | -Material | tinyint(4) | -Sheath | tinyint(3) unsigned | -RandomProperty | mediumint(8) | -RandomSuffix | mediumint(8) unsigned | -Block | mediumint(8) unsigned | -Itemset | mediumint(8) unsigned | -MaxDurability | smallint(5) unsigned | -Area | mediumint(8) unsigned | -Map | smallint(6) | -BagFamily | mediumint(8) | -TotemCategory | mediumint(8) | -SocketColor_1 | tinyint(4) | -SocketContent_1 | mediumint(8) | -SocketColor_2 | tinyint(4) | -SocketContent_2 | mediumint(8) | -SocketColor_3 | tinyint(4) | -SocketContent_3 | mediumint(8) | -SocketBonus | mediumint(8) | -GemProperties | mediumint(8) | -RequiredDisenchantSkill | smallint(6) | -ArmorDamageModifier | float | -Duration | int(10) unsigned | -ItemLimitCategory | smallint(6) | -HolidayId | int(11) unsigned | -ScriptName | varchar(64) | -DisenchantID | mediumint(8) unsigned | -FoodType | tinyint(3) unsigned | -MinMoneyLoot | int(10) unsigned | -MaxMoneyLoot | int(10) unsigned | -FlagsCustom | int(10) unsigned | -VerifiedBuild | smallint(6) | +# item\_template + +`Back-to:World` + +**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.) + +<table style="width:100%;"> +<colgroup> +<col width="14%" /> +<col width="14%" /> +<col width="14%" /> +<col width="14%" /> +<col width="14%" /> +<col width="14%" /> +<col width="14%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +<td><p><strong>Comment</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-entry">entry</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-class">class</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-subclass">subclass</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-SoundOverrideSubclass">SoundOverrideSubclass</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-name">name</a></p></td> +<td><p>varchar(255)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>NULL</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-displayid">displayid</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-Quality">Quality</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-Flags">Flags</a></p></td> +<td><p>bigint(20)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-FlagsExtra">FlagsExtra</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-BuyCount">BuyCount</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>1</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-BuyPrice">BuyPrice</a></p></td> +<td><p>bigint(20)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-SellPrice">SellPrice</a></p></td> +<td><p>int(10)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-InventoryType">InventoryType</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-AllowableClass">AllowableClass</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-AllowableRace">AllowableRace</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-ItemLevel">ItemLevel</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-RequiredLevel">RequiredLevel</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-RequiredSkill">RequiredSkill</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-RequiredSkillRank">RequiredSkillRank</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-requiredspell">requiredspell</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-requiredhonorrank">requiredhonorrank</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-RequiredCityRank">RequiredCityRank</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-RequiredReputationFaction">RequiredReputationFaction</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-RequiredReputationRank">RequiredReputationRank</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-maxcount">maxcount</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stackable">stackable</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>1</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-ContainerSlots">ContainerSlots</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-StatsCount">StatsCount</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type1</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value1</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type2</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value2</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type3</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value3</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type4</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value4</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type5</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value5</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type6</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value6</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type7</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value7</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type8</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value8</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type9</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value9</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-stat_type">stat_type10</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-stat_value">stat_value10</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-ScalingStatDistribution">ScalingStatDistribution</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-ScalingStatValue">ScalingStatValue</a></p></td> +<td><p>int(6)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-dmg_min">dmg_min1</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-dmg_max">dmg_max1</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-dmg_type">dmg_type1</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-dmg_min">dmg_min2</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-dmg_max">dmg_max2</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-dmg_type">dmg_type2</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-armor">armor</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-holy_res">holy_res</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-fire_res">fire_res</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-nature_res">nature_res</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-frost_res">frost_res</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-shadow_res">shadow_res</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-arcane_res">arcane_res</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-delay">delay</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>1000</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-ammo_type">ammo_type</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-RangedModRange">RangedModRange</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellid">spellid_1</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spelltrigger">spelltrigger_1</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellcharges">spellcharges_1</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spellppmRate">spellppmRate_1</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellcooldown">spellcooldown_1</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spellcategory">spellcategory_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellcategorycooldown">spellcategorycooldown_1</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spellid">spellid_2</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spelltrigger">spelltrigger_2</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spellcharges">spellcharges_2</a></p></td> +<td><p>smallint(6)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellppmRate">spellppmRate_2</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spellcooldown">spellcooldown_2</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p> +<p> </p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellcategory">spellcategory_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +<td><p><a href="#item_template-spellcategorycooldown">spellcategorycooldown_2</a></p></td> +<td><p>int(11)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>-1</p></td> +<td><p> </p></td> +</tr> +<tr class="even"> +<td><p><a href="#item_template-spellid">spellid_3</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +<td><p> </p></td> +</tr> +<tr class="odd"> +< |