SpellsTable


UE	Field	Type	Key Type	Default	Extra	Description
	id	int(8) unsigned	PRI		auto_increment	The unique ID for this spell.
	name	varchar(30)	UNI			The name of the spell.
	way_id	int(8) unsigned		0		The ID of the way of magic
	realm	tinyint(3) unsigned		0		The level in the way the spell is.
	casting_effect	varchar(255)				Name of visual/sound effect on the caster for casting spell.
	image_name	varchar(100)
	spell_description	text				The description of the spell.
	offensive	tinyint(1)		1		Flag (0/1) if this is an offensive spell.
DIF	max_power	float(4,2)		1		The power level cap of this spell. Type used to be 'int(4)' in PSLegacy. Default used to be in PSLegacy.
	target_type	int(4)		32		Bitmask of valid target types.
	cast_duration	text
	range	text
	aoe_radius	text
	aoe_angle	text
	outcome	text
	cstr_npc_spell_category	varchar(200)				Name of spell category which is sent to npc perception system.
	npc_spell_power	float(10,3)		0.000		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: