spell_learn_spell

Back-to:World

The `spell_learn_spell` table

This table holds information on spells that should be learned at the same time a player learns another spell. For example the few spells that are automatically learned when a player first learns a new profession. All fields in this table use spell IDs from Spell.dbc.

NOTE: Spells with spell effects SPELL_EFFECT_LEARN_SPELL should NOT be included in this table.

Structure

Field

Type

Attributes

Key

Null

Default

Extra

Comment

entry

smallint(5)

unsigned

PRI

NO

0

 

 

SpellID

smallint(5)

unsigned

PRI

NO

0

 

 

Active

tinyint(3)

unsigned

 

NO

0

 

 

Description of the fields

entry

The entry of the spell that the player learns, either from a trainer or from anywhere else (.learn for example).

SpellID

The entry of the spell that will be automatically learned by the player when the player learns the spell specified in entry.

Active

Defines whether spell is shown in spell book or not.