Skip to content

spell_check Table

Internal spell validation table - lists spells whose properties are relied on in code (Code), so .debug spellcheck can verify them against the client data.


Schema Summary

Field Type Key Null Default Extra
spellid smallint(5) unsigned PRI NO 0
SpellFamilyName smallint(5) PRI NO -1
SpellFamilyMask bigint(30) PRI NO -1
SpellIcon int(10) PRI NO -1
SpellVisual int(10) PRI NO -1
SpellCategory int(10) PRI NO -1
EffectType int(10) NO -1
EffectAura int(10) NO -1
EffectIdx tinyint(3) NO -1
Name varchar(40) NO ''
Code varchar(40) PRI NO ''

Field Breakdown

  • spellid - Primary Key. Spell ID. (see spell_template.entry)
  • SpellFamilyName - Family name.
  • SpellFamilyMask - Family mask.
  • SpellIcon - Icon ID.
  • SpellVisual - Visual ID.
  • SpellCategory - Category.
  • EffectType - Effect type.
  • EffectAura - Aura type.
  • EffectIdx - Effect index.
  • Name - Internal name.
  • Code - Primary Key. Internal code.