SpellsTable

field	type	foreign key	description
id	integer	N	The unique ID for this spell.
name	varchar	N	The name of the spell.
way_id	integer	Y WaysTable	The ID of the way of magic
realm	tinyint	N	The level in the way the spell is.
caster_effect	varchar	N	Name of visual/sound effect on the caster for casting spell.
target_effect	varchar	N	Name of visual/sound effect on the target for casting spell.
image_name	varchar	N
spell_description	longvarchar	N	The description of the spell.
offensive	tinyint	N	Flag (0/1) if this is an offensive spell.
progression_event	varchar	N	Script event name which is fired when the spell is cast.
saved_progression_event	varchar
saving_throw	varchar
saving_throw_value	integer
max_power	integer	N	The power level cap of this spell.
target_type	integer	N	Bitmask of valid target types.
cstr_npc_spell_category	integer		Name of spell category which is sent to npc perception system.
npc_spell_power	real	N	Relative power of spell as hint for the npc perception system.

Additional Notes

The target-type values for the bitmask are defined in src/server/client.h. At the time of writing these are: