CREATE TABLE `spell` (
  `SpellId` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `Category` int(10) unsigned NOT NULL,
  `Dispel` int(10) unsigned NOT NULL,
  `Mechanic` int(11) NOT NULL,
  `Attributes` int(10) unsigned NOT NULL,
  `AttributesEx` int(10) unsigned NOT NULL,
  `AttributesEx2` int(10) unsigned NOT NULL,
  `AttributesEx3` int(10) unsigned NOT NULL,
  `AttributesEx4` int(10) unsigned NOT NULL,
  `AttributesEx5` int(10) unsigned NOT NULL,
  `AttributesEx6` int(10) unsigned NOT NULL,
  `AttributesEx7` int(10) unsigned NOT NULL,
  `Stances` bigint(20) unsigned NOT NULL,
  `StancesNot` bigint(20) unsigned NOT NULL,
  `Targets` int(10) unsigned NOT NULL,
  `TargetCreatureType` int(11) NOT NULL,
  `RequiresSpellFocus` int(10) unsigned NOT NULL,
  `FacingCasterFlags` int(10) unsigned NOT NULL,
  `CasterAuraState` int(11) NOT NULL,
  `TargetAuraState` int(11) NOT NULL,
  `CasterAuraStateNot` int(11) NOT NULL,
  `TargetAuraStateNot` int(11) NOT NULL,
  `CasterAuraSpell` int(10) unsigned NOT NULL,
  `TargetAuraSpell` int(10) unsigned NOT NULL,
  `ExcludeCasterAuraSpell` int(10) unsigned NOT NULL,
  `ExcludeTargetAuraSpell` int(10) unsigned NOT NULL,
  `CastingTimeIndex` int(10) unsigned NOT NULL,
  `RecoveryTime` int(10) unsigned NOT NULL,
  `CategoryRecoveryTime` int(10) unsigned NOT NULL,
  `InterruptFlags` int(10) unsigned NOT NULL,
  `AuraInterruptFlags` int(10) unsigned NOT NULL,
  `ChannelInterruptFlags` int(10) unsigned NOT NULL,
  `ProcFlags` int(11) NOT NULL,
  `ProcChance` int(10) unsigned NOT NULL,
  `ProcCharges` int(10) unsigned NOT NULL,
  `MaxLevel` int(10) unsigned NOT NULL,
  `BaseLevel` int(10) unsigned NOT NULL,
  `SpellLevel` int(10) unsigned NOT NULL,
  `DurationIndex` int(10) unsigned NOT NULL,
  `PowerType` int(10) unsigned NOT NULL,
  `ManaCost` int(10) unsigned NOT NULL,
  `ManaCostPerlevel` int(10) unsigned NOT NULL,
  `ManaPerSecond` int(10) unsigned NOT NULL,
  `ManaPerSecondPerLevel` int(10) unsigned NOT NULL,
  `RangeIndex` int(10) unsigned NOT NULL,
  `Speed` float NOT NULL,
  `ModalNextSpell` int(10) unsigned NOT NULL,
  `StackAmount` int(10) unsigned NOT NULL,
  `ReagentsRequired_Totem_One` int(10) unsigned NOT NULL,
  `ReagentsRequired_Totem_Two` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentId_One` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Two` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Three` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Four` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Five` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Six` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Seven` int(11) NOT NULL,
  `ReagentsRequired_ReagentId_Eight` int(11) NOT NULL,
  `ReagentsRequired_ReagentCount_One` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Two` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Three` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Four` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Five` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Six` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Seven` int(10) unsigned NOT NULL,
  `ReagentsRequired_ReagentCount_Eight` int(10) unsigned NOT NULL,
  `EquippedItemClass` int(11) NOT NULL,
  `EquippedItemSubClassMask` int(11) NOT NULL,
  `EquippedItemInventoryTypeMask` int(11) NOT NULL,
  `SpellEffectInformation_Effect_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_Effect_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_Effect_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectDieSides_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectDieSides_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectDieSides_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectRealPointsPerLevel_Effect1` float NOT NULL,
  `SpellEffectInformation_EffectRealPointsPerLevel_Effect2` float NOT NULL,
  `SpellEffectInformation_EffectRealPointsPerLevel_Effect3` float NOT NULL,
  `SpellEffectInformation_EffectBasePoints_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectBasePoints_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectBasePoints_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectMechanic_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectMechanic_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectMechanic_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectImplicitTargetA_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectImplicitTargetA_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectImplicitTargetA_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectImplicitTargetB_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectImplicitTargetB_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectImplicitTargetB_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectRadiusIndex_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectRadiusIndex_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectRadiusIndex_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectApplyAuraName_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectApplyAuraName_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectApplyAuraName_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectAmplitude_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectAmplitude_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectAmplitude_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectMultipleValue_Effect1` float NOT NULL,
  `SpellEffectInformation_EffectMultipleValue_Effect2` float NOT NULL,
  `SpellEffectInformation_EffectMultipleValue_Effect3` float NOT NULL,
  `SpellEffectInformation_EffectChainTarget_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectChainTarget_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectChainTarget_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectItemType_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectItemType_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectItemType_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectMiscValue_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectMiscValue_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectMiscValue_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectMiscValueB_Effect1` int(11) NOT NULL,
  `SpellEffectInformation_EffectMiscValueB_Effect2` int(11) NOT NULL,
  `SpellEffectInformation_EffectMiscValueB_Effect3` int(11) NOT NULL,
  `SpellEffectInformation_EffectTriggerSpell_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectTriggerSpell_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectTriggerSpell_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectPointsPerComboPoint_Effect1` float NOT NULL,
  `SpellEffectInformation_EffectPointsPerComboPoint_Effect2` float NOT NULL,
  `SpellEffectInformation_EffectPointsPerComboPoint_Effect3` float NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskA_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskA_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskA_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskB_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskB_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskB_Effect3` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskC_Effect1` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskC_Effect2` int(10) unsigned NOT NULL,
  `SpellEffectInformation_EffectSpellClassMaskC_Effect3` int(10) unsigned NOT NULL,
  `SpellVisual_One` int(10) unsigned NOT NULL,
  `SpellVisual_Two` int(10) unsigned NOT NULL,
  `SpellIconID` int(10) unsigned NOT NULL,
  `ActiveIconID` int(10) unsigned NOT NULL,
  `SpellPriority` int(10) unsigned NOT NULL,
  `ManaCostPercentage` int(10) unsigned NOT NULL,
  `StartRecoveryCategory` int(10) unsigned NOT NULL,
  `StartRecoveryTime` int(10) unsigned NOT NULL,
  `MaxTargetLevel` int(10) unsigned NOT NULL,
  `SpellFamilyName` int(11) NOT NULL,
  `SpellFamilyFlags_One` int(10) unsigned NOT NULL,
  `SpellFamilyFlags_Two` int(10) unsigned NOT NULL,
  `SpellFamilyFlags_Three` int(10) unsigned NOT NULL,
  `MaxAffectedTargets` int(10) unsigned NOT NULL,
  `DmgClass` int(11) NOT NULL,
  `PreventionType` int(11) NOT NULL,
  `StanceBarOrder` int(10) unsigned NOT NULL,
  `DmgMultiplier_Effect1` float NOT NULL,
  `DmgMultiplier_Effect2` float NOT NULL,
  `DmgMultiplier_Effect3` float NOT NULL,
  `MinFactionId` int(10) unsigned NOT NULL,
  `MinReputation` int(10) unsigned NOT NULL,
  `RequiredAuraVision` int(10) unsigned NOT NULL,
  `TotemCategory_One` int(10) unsigned NOT NULL,
  `TotemCategory_Two` int(10) unsigned NOT NULL,
  `AreaGroupId` int(11) NOT NULL,
  `SchoolMask` int(11) NOT NULL,
  `RuneCostID` int(10) unsigned NOT NULL,
  `SpellMissileID` int(10) unsigned NOT NULL,
  `PowerDisplayId` int(10) unsigned NOT NULL,
  `DamageCoeficient_Effect1` float NOT NULL,
  `DamageCoeficient_Effect2` float NOT NULL,
  `DamageCoeficient_Effect3` float NOT NULL,
  `SpellDescriptionVariableID` int(10) unsigned NOT NULL,
  `SpellDifficultyId` int(10) unsigned NOT NULL,
  `Description_Flags` int(10) unsigned NOT NULL DEFAULT '0',
  `Description_deDE` longtext,
  `Description_enCN` longtext,
  `Description_enTW` longtext,
  `Description_enUS` longtext,
  `Description_esES` longtext,
  `Description_esMX` longtext,
  `Description_frFR` longtext,
  `Description_itIT` longtext,
  `Description_koKR` longtext,
  `Description_ptPT` longtext,
  `Description_ruRU` longtext,
  `Rank_Flags` int(10) unsigned NOT NULL DEFAULT '0',
  `Rank_deDE` longtext,
  `Rank_enCN` longtext,
  `Rank_enTW` longtext,
  `Rank_enUS` longtext,
  `Rank_esES` longtext,
  `Rank_esMX` longtext,
  `Rank_frFR` longtext,
  `Rank_itIT` longtext,
  `Rank_koKR` longtext,
  `Rank_ptPT` longtext,
  `Rank_ruRU` longtext,
  `SpellName_Flags` int(10) unsigned NOT NULL DEFAULT '0',
  `SpellName_deDE` longtext,
  `SpellName_enCN` longtext,
  `SpellName_enTW` longtext,
  `SpellName_enUS` longtext,
  `SpellName_esES` longtext,
  `SpellName_esMX` longtext,
  `SpellName_frFR` longtext,
  `SpellName_itIT` longtext,
  `SpellName_koKR` longtext,
  `SpellName_ptPT` longtext,
  `SpellName_ruRU` longtext,
  `ToolTip_Flags` int(10) unsigned NOT NULL DEFAULT '0',
  `ToolTip_deDE` longtext,
  `ToolTip_enCN` longtext,
  `ToolTip_enTW` longtext,
  `ToolTip_enUS` longtext,
  `ToolTip_esES` longtext,
  `ToolTip_esMX` longtext,
  `ToolTip_frFR` longtext,
  `ToolTip_itIT` longtext,
  `ToolTip_koKR` longtext,
  `ToolTip_ptPT` longtext,
  `ToolTip_ruRU` longtext,
  PRIMARY KEY (`SpellId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;