“spell_chain” table

The spell_chain table holds information on the chain of spells with ranks.

Table structure

Field Type Null Key Default Extra
spell_id mediumint(9) NO PRI 0  
prev_spell mediumint(9) NO   0  
first_spell mediumint(9) NO   0  
rank tinyint(4) NO   0  
req_spell mediumint(9) NO   0  

Fields

spell_id

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc.

prev_spell

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This is the previous rank in the spell chain.

first_spell

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This is the rank 1 spell in the spell chain

rank

The rank of the spell referenced in spell_id.

req_spell

The spell identifier. The value has to match with a spell identifier defined in Spell.dbc. This references a spell required to use the spell referenced in spell_id.