`entry` int(255) NOT NULL default '0',
`class` tinyint(3) NOT NULL default '0',
`subclass` tinyint(3) NOT NULL default '0',
`name` char(255) NOT NULL,
`name2` char(255) NOT NULL,
`name3` char(255) NOT NULL,
`name4` char(255) NOT NULL,
`displayid` int(11) NOT NULL default '0',
`Quality` tinyint(3) NOT NULL default '0',
`Flags` int(30) NOT NULL default '0',
`BuyCount` tinyint(3) NOT NULL default '1',
`BuyPrice` int(30) NOT NULL default '0',
`SellPrice` int(30) NOT NULL default '0',
`InventoryType` int(3) NOT NULL default '0',
`AllowableClass` mediumint(9) NOT NULL default '0',
`AllowableRace` int(11) NOT NULL default '0',
`ItemLevel` int(30) NOT NULL default '0',
`RequiredLevel` tinyint(3) NOT NULL default '0',
`RequiredSkill` int(30) NOT NULL default '0',
`RequiredSkillRank` int(30) NOT NULL default '0',
`requiredspell` int(30) NOT NULL default '0',
`requiredhonorrank` int(30) NOT NULL default '0',
`RequiredCityRank` int(30) NOT NULL default '0',
`RequiredReputationFaction` int(30) NOT NULL default '0',
`RequiredReputationRank` int(30) NOT NULL default '0',
`maxcount` smallint(5) NOT NULL default '0',
`stackable` smallint(5) NOT NULL default '0',
`ContainerSlots` tinyint(3) NOT NULL default '0',
`stat_type1` tinyint(4) NOT NULL default '0',
`stat_value1` smallint(6) NOT NULL default '0',
`stat_type2` tinyint(4) NOT NULL,
`stat_value2` smallint(6) NOT NULL,
`stat_type3` tinyint(4) NOT NULL,
`stat_value3` smallint(6) NOT NULL,
`stat_type4` tinyint(4) NOT NULL,
`stat_value4` smallint(6) NOT NULL,
`stat_type5` tinyint(4) NOT NULL,
`stat_value5` smallint(6) NOT NULL,
`stat_type6` tinyint(4) NOT NULL,
`stat_value6` smallint(6) NOT NULL,
`stat_type7` tinyint(4) NOT NULL,
`stat_value7` smallint(6) NOT NULL,
`stat_type8` tinyint(4) NOT NULL,
`stat_value8` smallint(6) NOT NULL,
`stat_type9` tinyint(4) NOT NULL,
`stat_value9` smallint(6) NOT NULL,
`stat_type10` tinyint(4) NOT NULL,
`stat_value10` smallint(6) NOT NULL,
`dmg_min1` float NOT NULL default '0',
`dmg_max1` float NOT NULL default '0',
`dmg_type1` tinyint(3) NOT NULL default '0',
`dmg_min2` float NOT NULL default '0',
`dmg_max2` float NOT NULL default '0',
`dmg_type2` tinyint(3) NOT NULL default '0',
`dmg_min3` float NOT NULL default '0',
`dmg_max3` float NOT NULL default '0',
`dmg_type3` tinyint(3) NOT NULL default '0',
`dmg_min4` float NOT NULL default '0',
`dmg_max4` float NOT NULL default '0',
`dmg_type4` tinyint(3) NOT NULL default '0',
`dmg_min5` float NOT NULL default '0',
`dmg_max5` float NOT NULL default '0',
`dmg_type5` tinyint(3) NOT NULL default '0',
`armor` int(30) NOT NULL default '0',
`holy_res` int(30) NOT NULL,
`fire_res` int(30) NOT NULL,
`nature_res` int(30) NOT NULL,
`frost_res` int(30) NOT NULL,
`shadow_res` int(30) NOT NULL,
`arcane_res` int(30) NOT NULL,
`delay` int(11) NOT NULL default '1000',
`ammo_type` int(30) NOT NULL default '0',
`RangedModRange` float NOT NULL default '0',
`spellid_1` int(30) NOT NULL,
`spelltrigger_1` int(30) NOT NULL,
`spellcharges_1` int(30) NOT NULL,
`spellcooldown_1` int(30) NOT NULL,
`spellcategory_1` int(30) NOT NULL,
`spellcategorycooldown_1` int(30) NOT NULL,
`spellid_2` int(30) NOT NULL,
`spelltrigger_2` int(30) NOT NULL,
`spellcharges_2` int(30) NOT NULL,
`spellcooldown_2` int(30) NOT NULL,
`spellcategory_2` int(30) NOT NULL,
`spellcategorycooldown_2` int(30) NOT NULL,
`spellid_3` int(30) NOT NULL,
`spelltrigger_3` int(30) NOT NULL,
`spellcharges_3` int(30) NOT NULL default '0',
`spellcooldown_3` int(30) NOT NULL,
`spellcategory_3` int(30) NOT NULL,
`spellcategorycooldown_3` int(30) NOT NULL,
`spellid_4` int(30) NOT NULL,
`spelltrigger_4` int(30) NOT NULL,
`spellcharges_4` int(30) NOT NULL default '0',
`spellcooldown_4` int(30) NOT NULL,
`spellcategory_4` int(30) NOT NULL,
`spellcategorycooldown_4` int(30) NOT NULL,
`spellid_5` int(30) NOT NULL,
`spelltrigger_5` int(30) NOT NULL,
`spellcharges_5` int(30) NOT NULL default '0',
`spellcooldown_5` int(30) NOT NULL,
`spellcategory_5` int(30) NOT NULL,
`spellcategorycooldown_5` int(30) NOT NULL,
`bonding` tinyint(3) NOT NULL,
`description` char(255) NOT NULL,
`PageText` int(30) NOT NULL,
`LanguageID` int(30) NOT NULL,
`PageMaterial` int(30) NOT NULL,
`startquest` int(30) NOT NULL,
`lockid` int(30) NOT NULL,
`Material` int(30) NOT NULL,
`sheath` int(30) NOT NULL,
`Extra` int(30) NOT NULL,
`block` int(30) NOT NULL,
`itemset` int(30) NOT NULL,
`MaxDurability` int(30) NOT NULL,
`area` int(30) NOT NULL,
`Map` int(10) NOT NULL,
`BagFamily` int(11) NOT NULL,
`TotemCategory` int(11) NOT NULL,
`Socket1type` int(11) NOT NULL,
`Unknown1` int(11) NOT NULL,
`Socket2type` int(11) NOT NULL,
`Unknown2` int(11) NOT NULL,
`Socket3type` int(11) NOT NULL,
`Unknown3` int(11) NOT NULL,
`BonusSpellitemEnch` int(11) NOT NULL default '0',
`GemProperties` int(11) NOT NULL,
`HonorUnk` int(11) NOT NULL,
`RequiredDisenchantSkill` int(11) NOT NULL default '-1',
`ScriptName` char(250) NOT NULL default '0',
`DisenchantID` int(11) unsigned NOT NULL default '0',