alpha_dbc.Spell

Table

6590 rows in this table. Schema below.

Name Type Null Key Default
ID int(11) NO PRI 0
School int(11) NO 0
Category int(11) NO 0
CastUI int(11) NO 0
Attributes int(11) NO 0
AttributesEx int(11) NO 0
ShapeshiftMask int(11) NO 0
Targets int(11) NO 0
TargetCreatureType int(11) NO 0
RequiresSpellFocus int(11) NO 0
CasterAuraState int(11) NO 0
TargetAuraState int(11) NO 0
CastingTimeIndex int(11) NO 0
RecoveryTime int(11) NO 0
CategoryRecoveryTime int(11) NO 0
InterruptFlags int(11) NO 0
AuraInterruptFlags int(11) NO 0
ChannelInterruptFlags int(11) NO 0
ProcFlags int(11) NO 0
ProcChance int(11) NO 0
ProcCharges int(11) NO 0
MaxLevel int(11) NO 0
BaseLevel int(11) NO 0
SpellLevel int(11) NO 0
DurationIndex int(11) NO 0
PowerType int(11) NO 0
ManaCost int(11) NO 0
ManaCostPerLevel int(11) NO 0
ManaPerSecond int(11) NO 0
ManaPerSecondPerLevel int(11) NO 0
RangeIndex int(11) NO 0
Speed float NO 0
ModalNextSpell int(11) NO 0
Totem_1 int(11) NO 0
Totem_2 int(11) NO 0
Reagent_1 int(11) NO 0
Reagent_2 int(11) NO 0
Reagent_3 int(11) NO 0
Reagent_4 int(11) NO 0
Reagent_5 int(11) NO 0
Reagent_6 int(11) NO 0
Reagent_7 int(11) NO 0
Reagent_8 int(11) NO 0
ReagentCount_1 int(11) NO 0
ReagentCount_2 int(11) NO 0
ReagentCount_3 int(11) NO 0
ReagentCount_4 int(11) NO 0
ReagentCount_5 int(11) NO 0
ReagentCount_6 int(11) NO 0
ReagentCount_7 int(11) NO 0
ReagentCount_8 int(11) NO 0
EquippedItemClass int(11) NO 0
EquippedItemSubclass int(11) NO 0
Effect_1 int(11) NO 0
Effect_2 int(11) NO 0
Effect_3 int(11) NO 0
EffectDieSides_1 int(11) NO 0
EffectDieSides_2 int(11) NO 0
EffectDieSides_3 int(11) NO 0
EffectBaseDice_1 int(11) NO 0
EffectBaseDice_2 int(11) NO 0
EffectBaseDice_3 int(11) NO 0
EffectDicePerLevel_1 int(11) NO 0
EffectDicePerLevel_2 int(11) NO 0
EffectDicePerLevel_3 int(11) NO 0
EffectRealPointsPerLevel_1 float NO 0
EffectRealPointsPerLevel_2 float NO 0
EffectRealPointsPerLevel_3 float NO 0
EffectBasePoints_1 int(11) NO 0
EffectBasePoints_2 int(11) NO 0
EffectBasePoints_3 int(11) NO 0
ImplicitTargetA_1 int(11) NO 0
ImplicitTargetA_2 int(11) NO 0
ImplicitTargetA_3 int(11) NO 0
ImplicitTargetB_1 int(11) NO 0
ImplicitTargetB_2 int(11) NO 0
ImplicitTargetB_3 int(11) NO 0
EffectRadiusIndex_1 int(11) NO 0
EffectRadiusIndex_2 int(11) NO 0
EffectRadiusIndex_3 int(11) NO 0
EffectAura_1 int(11) NO 0
EffectAura_2 int(11) NO 0
EffectAura_3 int(11) NO 0
EffectAuraPeriod_1 int(11) NO 0
EffectAuraPeriod_2 int(11) NO 0
EffectAuraPeriod_3 int(11) NO 0
EffectAmplitude_1 float NO 0
EffectAmplitude_2 float NO 0
EffectAmplitude_3 float NO 0
EffectChainTargets_1 int(11) NO 0
EffectChainTargets_2 int(11) NO 0
EffectChainTargets_3 int(11) NO 0
EffectItemType_1 int(11) NO 0
EffectItemType_2 int(11) NO 0
EffectItemType_3 int(11) NO 0
EffectMiscValue_1 int(11) NO 0
EffectMiscValue_2 int(11) NO 0
EffectMiscValue_3 int(11) NO 0
EffectTriggerSpell_1 int(11) NO 0
EffectTriggerSpell_2 int(11) NO 0
EffectTriggerSpell_3 int(11) NO 0
SpellVisualID int(11) NO 0
SpellIconID int(11) NO 0
ActiveIconID int(11) NO 0
SpellPriority int(11) NO 0
Name_enUS text YES NULL
Name_enGB text YES NULL
Name_koKR text YES NULL
Name_frFR text YES NULL
Name_deDE text YES NULL
Name_enCN text YES NULL
Name_zhCN text YES NULL
Name_enTW text YES NULL
Name_Mask int(10) unsigned NO 0
NameSubtext_enUS text YES NULL
NameSubtext_enGB text YES NULL
NameSubtext_koKR text YES NULL
NameSubtext_frFR text YES NULL
NameSubtext_deDE text YES NULL
NameSubtext_enCN text YES NULL
NameSubtext_zhCN text YES NULL
NameSubtext_enTW text YES NULL
NameSubtext_Mask int(10) unsigned NO 0
Description_enUS text YES NULL
Description_enGB text YES NULL
Description_koKR text YES NULL
Description_frFR text YES NULL
Description_deDE text YES NULL
Description_enCN text YES NULL
Description_zhCN text YES NULL
Description_enTW text YES NULL
Description_Mask int(10) unsigned NO 0
ManaCostPct int(11) NO 0
StartRecoveryCategory int(11) NO 0
StartRecoveryTime int(11) NO 0
custom_DispelType int(4) NO 0