CREATE TABLE `spell` (
  `ID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Category` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Dispel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Mechanic` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Attributes` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AttributesEx7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Stances` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Unknown1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `StancesNot` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Unknown2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Targets` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TargetCreatureType` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RequiresSpellFocus` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `FacingCasterFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `CasterAuraState` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TargetAuraState` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `CasterAuraStateNot` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TargetAuraStateNot` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `CasterAuraSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TargetAuraSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExcludeCasterAuraSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ExcludeTargetAuraSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `CastingTimeIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RecoveryTime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `CategoryRecoveryTime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `InterruptFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AuraInterruptFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ChannelInterruptFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ProcFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ProcChance` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ProcCharges` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `MaximumLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `BaseLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `DurationIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `PowerType` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ManaCost` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ManaCostPerLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ManaPerSecond` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ManaPerSecondPerLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RangeIndex` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Speed` DOUBLE NOT NULL DEFAULT '0',
  `ModalNextSpell` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `StackAmount` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Totem1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Totem2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Reagent1` INT(11) NOT NULL DEFAULT '0',
  `Reagent2` INT(11) NOT NULL DEFAULT '0',
  `Reagent3` INT(11) NOT NULL DEFAULT '0',
  `Reagent4` INT(11) NOT NULL DEFAULT '0',
  `Reagent5` INT(11) NOT NULL DEFAULT '0',
  `Reagent6` INT(11) NOT NULL DEFAULT '0',
  `Reagent7` INT(11) NOT NULL DEFAULT '0',
  `Reagent8` INT(11) NOT NULL DEFAULT '0',
  `ReagentCount1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ReagentCount8` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EquippedItemClass` INT(11) NOT NULL DEFAULT '0',
  `EquippedItemSubClassMask` INT(11) NOT NULL DEFAULT '0',
  `EquippedItemInventoryTypeMask` INT(11) NOT NULL DEFAULT '0',
  `Effect1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Effect2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `Effect3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectDieSides1` INT(11) NOT NULL DEFAULT '0',
  `EffectDieSides2` INT(11) NOT NULL DEFAULT '0',
  `EffectDieSides3` INT(11) NOT NULL DEFAULT '0',
  `EffectRealPointsPerLevel1` DOUBLE NOT NULL DEFAULT '0',
  `EffectRealPointsPerLevel2` DOUBLE NOT NULL DEFAULT '0',
  `EffectRealPointsPerLevel3` DOUBLE NOT NULL DEFAULT '0',
  `EffectBasePoints1` INT(11) NOT NULL DEFAULT '0',
  `EffectBasePoints2` INT(11) NOT NULL DEFAULT '0',
  `EffectBasePoints3` INT(11) NOT NULL DEFAULT '0',
  `EffectMechanic1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectMechanic2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectMechanic3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectImplicitTargetA1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectImplicitTargetA2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectImplicitTargetA3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectImplicitTargetB1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectImplicitTargetB2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectImplicitTargetB3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectRadiusIndex1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectRadiusIndex2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectRadiusIndex3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectApplyAuraName1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectApplyAuraName2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectApplyAuraName3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectAmplitude1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectAmplitude2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectAmplitude3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectMultipleValue1` DOUBLE NOT NULL DEFAULT '0',
  `EffectMultipleValue2` DOUBLE NOT NULL DEFAULT '0',
  `EffectMultipleValue3` DOUBLE NOT NULL DEFAULT '0',
  `EffectChainTarget1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectChainTarget2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectChainTarget3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectItemType1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectItemType2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectItemType3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectMiscValue1` INT(11) NOT NULL DEFAULT '0',
  `EffectMiscValue2` INT(11) NOT NULL DEFAULT '0',
  `EffectMiscValue3` INT(11) NOT NULL DEFAULT '0',
  `EffectMiscValueB1` INT(11) NOT NULL DEFAULT '0',
  `EffectMiscValueB2` INT(11) NOT NULL DEFAULT '0',
  `EffectMiscValueB3` INT(11) NOT NULL DEFAULT '0',
  `EffectTriggerSpell1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectTriggerSpell2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectTriggerSpell3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectPointsPerComboPoint1` DOUBLE NOT NULL DEFAULT '0',
  `EffectPointsPerComboPoint2` DOUBLE NOT NULL DEFAULT '0',
  `EffectPointsPerComboPoint3` DOUBLE NOT NULL DEFAULT '0',
  `EffectSpellClassMaskA1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskA2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskA3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskB1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskB2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskB3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskC1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskC2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectSpellClassMaskC3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellVisual1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellVisual2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellIconID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ActiveIconID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellPriority` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellName0` text NOT NULL,
  `SpellName1` text NOT NULL,
  `SpellName2` text NOT NULL,
  `SpellName3` text NOT NULL,
  `SpellName4` text NOT NULL,
  `SpellName5` text NOT NULL,
  `SpellName6` text NOT NULL,
  `SpellName7` text NOT NULL,
  `SpellName8` text NOT NULL,
  `SpellNameFlag0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellNameFlag7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRank0` text NOT NULL,
  `SpellRank1` text NOT NULL,
  `SpellRank2` text NOT NULL,
  `SpellRank3` text NOT NULL,
  `SpellRank4` text NOT NULL,
  `SpellRank5` text NOT NULL,
  `SpellRank6` text NOT NULL,
  `SpellRank7` text NOT NULL,
  `SpellRank8` text NOT NULL,
  `SpellRankFlags0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellRankFlags7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescription0` text NOT NULL,
  `SpellDescription1` text NOT NULL,
  `SpellDescription2` text NOT NULL,
  `SpellDescription3` text NOT NULL,
  `SpellDescription4` text NOT NULL,
  `SpellDescription5` text NOT NULL,
  `SpellDescription6` text NOT NULL,
  `SpellDescription7` text NOT NULL,
  `SpellDescription8` text NOT NULL,
  `SpellDescriptionFlags0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDescriptionFlags7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTip0` text NOT NULL,
  `SpellToolTip1` text NOT NULL,
  `SpellToolTip2` text NOT NULL,
  `SpellToolTip3` text NOT NULL,
  `SpellToolTip4` text NOT NULL,
  `SpellToolTip5` text NOT NULL,
  `SpellToolTip6` text NOT NULL,
  `SpellToolTip7` text NOT NULL,
  `SpellToolTip8` text NOT NULL,
  `SpellToolTipFlags0` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags3` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags4` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags5` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags6` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellToolTipFlags7` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `ManaCostPercentage` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `StartRecoveryCategory` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `StartRecoveryTime` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `MaximumTargetLevel` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellFamilyName` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellFamilyFlags` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellFamilyFlags1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellFamilyFlags2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `MaximumAffectedTargets` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `DamageClass` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `PreventionType` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `StanceBarOrder` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectDamageMultiplier1` DOUBLE NOT NULL DEFAULT '0',
  `EffectDamageMultiplier2` DOUBLE NOT NULL DEFAULT '0',
  `EffectDamageMultiplier3` DOUBLE NOT NULL DEFAULT '0',
  `MinimumFactionId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `MinimumReputation` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RequiredAuraVision` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TotemCategory1` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `TotemCategory2` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `AreaGroupID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SchoolMask` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `RuneCostID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellMissileID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `PowerDisplayId` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `EffectBonusMultiplier1` DOUBLE NOT NULL DEFAULT '0',
  `EffectBonusMultiplier2` DOUBLE NOT NULL DEFAULT '0',
  `EffectBonusMultiplier3` DOUBLE NOT NULL DEFAULT '0',
  `SpellDescriptionVariableID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  `SpellDifficultyID` INT(10) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;