Skip to content

locales_spell Table

Localized spell names, subtitles, descriptions, and aura descriptions.


Schema Summary

Field Type Key Null Default Extra
entry smallint(5) unsigned PRI NO
name_loc1 varchar(256) NO ''
name_loc2 varchar(256) NO ''
name_loc3 varchar(256) NO ''
name_loc4 varchar(256) NO ''
name_loc5 varchar(256) NO ''
name_loc6 varchar(256) NO ''
nameSubtext_loc1 varchar(256) NO ''
nameSubtext_loc2 varchar(256) NO ''
nameSubtext_loc3 varchar(256) NO ''
nameSubtext_loc4 varchar(256) NO ''
nameSubtext_loc5 varchar(256) NO ''
nameSubtext_loc6 varchar(256) NO ''
description_loc1 varchar(1024) NO ''
description_loc2 varchar(1024) NO ''
description_loc3 varchar(1024) NO ''
description_loc4 varchar(1024) NO ''
description_loc5 varchar(1024) NO ''
description_loc6 varchar(1024) NO ''
auraDescription_loc1 varchar(512) NO ''
auraDescription_loc2 varchar(512) NO ''
auraDescription_loc3 varchar(512) NO ''
auraDescription_loc4 varchar(512) NO ''
auraDescription_loc5 varchar(512) NO ''
auraDescription_loc6 varchar(512) NO ''

Field Breakdown

  • entry - Primary Key. Spell id (spell_template.entry).
  • name_loc1 - Localized spell name.
  • name_loc2 - Localized spell name.
  • name_loc3 - Localized spell name.
  • name_loc4 - Localized spell name.
  • name_loc5 - Localized spell name.
  • name_loc6 - Localized spell name.
  • nameSubtext_loc1 - Localized subtext (rank line).
  • nameSubtext_loc2 - Localized subtext (rank line).
  • nameSubtext_loc3 - Localized subtext (rank line).
  • nameSubtext_loc4 - Localized subtext (rank line).
  • nameSubtext_loc5 - Localized subtext (rank line).
  • nameSubtext_loc6 - Localized subtext (rank line).
  • description_loc1 - Localized tooltip description.
  • description_loc2 - Localized tooltip description.
  • description_loc3 - Localized tooltip description.
  • description_loc4 - Localized tooltip description.
  • description_loc5 - Localized tooltip description.
  • description_loc6 - Localized tooltip description.
  • auraDescription_loc1 - Localized aura description.
  • auraDescription_loc2 - Localized aura description.
  • auraDescription_loc3 - Localized aura description.
  • auraDescription_loc4 - Localized aura description.
  • auraDescription_loc5 - Localized aura description.
  • auraDescription_loc6 - Localized aura description.