`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',