Surfing on the web, long ago, i found this... (Thus i have no clue of how it works)
Just
a few notes, i still have no clue of how to make NPCs cast spells.
Watch out that percentage may greatly change, be sure to check what's
your health percentage at level 85 ( ex. Trinity server has set it to
2,5k.)

[quoted]


This is a template for an NPC for Trinity.
You can set the values at the top of the code.

You can run the code with only setting the entry at the top and the NPC will show up ingame.
If you do so, the values will be defult and model of the NPC will be 13 (Peasant Woman).

Details about what column does what can be found in Trinitycore wiki:
[Only admins are allowed to see this link] ((Comment: Wrong))

'' fields are text
1 fields are full numbers
1.0 fields are decimal numbers

*/

SET
@ENTRY = 100000;
SET
@MODELID1 = 13,
@MODELID2 = 0,
@MODELID3 = 0,
@MODELID4 = 0,
@NAME = 'Name',
@SUBNAME = 'Subname',
@ICONNAME = '',
@GOSSIP_MENU_ID = 0,
@MINLEVEL = 1,
@MAXLEVEL = 1,
@EXP = 0,
@FACTION_A = 35,
@FACTION_H = 35,
@NPCFLAG = 1,
@SPEED_WALK = 1.0,
@SPEED_RUN = 1.14286,
@SCALE = 1,
@RANK = 0,
@MINDMG = 1.0,
@MAXDMG = 1.0,
@DMGSCHOOL = 0,
@ATTACKPOWER = 1,
@DMG_MULTIPLIER = 1.0,
@BASEATTACKTIME = 1000,
@RANGEDATTACKTIME = 1000,
@UNIT_CLASS = 1,
@UNIT_FLAGS = 0,
@DYNAMICFLAGS = 0,
@FAMILY = 0,
@TRAINER_TYPE = 0,
@TRAINER_SPELL = 0,
@TRAINER_CLASS = 0,
@TRAINER_RACE = 0,
@MINRANGEDMG = 0.0,
@MAXRANGEDMG = 0.0,
@RANGEDATTACKPOWER = 0,
@TYPE = 1,
@TYPE_FLAGS = 0,
@LOOTID = @ENTRY,
@PICKPOCKETLOOT = @ENTRY,
@SKINLOOT = @ENTRY,
@RESISTANCE1 = 0, -- Holy
@RESISTANCE2 = 0, -- Fire
@RESISTANCE3 = 0, -- Nature
@RESISTANCE4 = 0, -- Frost
@RESISTANCE5 = 0, -- Shadow
@RESISTANCE6 = 0, -- Arcane
@SPELL1 = 0, -- Spells available to the mindcontroller
@SPELL2 = 0,
@SPELL3 = 0,
@SPELL4 = 0,
@SPELL5 = 0,
@SPELL6 = 0,
@SPELL7 = 0,
@SPELL8 = 0,
@PETSPELLDATAID = 0,
@VEHICLEID = 0,
@MINGOLD = 0, -- in copper
@MAXGOLD = 0, -- in copper
@AINAME = '',
@MOVEMENTTYPE = 0,
@INHABITTYPE = 3,
@HEALTH_MOD = 1.0,
@MANA_MOD = 1.0,
@ARMOR_MOD = 1.0,
@RACIALLEADER = 0,
@QUESTITEM1 = 0,
@QUESTITEM2 = 0,
@QUESTITEM3 = 0,
@QUESTITEM4 = 0,
@QUESTITEM5 = 0,
@QUESTITEM6 = 0,
@MOVEMENTID = 0,
@REGENHEALTH = 1,
@EQUIPMENT_ID = 0,
@MECHANIC_IMMUNE_MASK = 0,
@FLAGS_EXTRA = 0,
@SCRIPTNAME = ''
;


-- ---------------------------------------------------------------------- --
-- Do not change anything beyond this unless you know what you are doing. --
-- ---------------------------------------------------------------------- --


INSERT
INTO creature_template (entry, modelid1, modelid2, modelid3, modelid4,
name, subname, IconName, gossip_menu_id, minlevel, maxlevel, exp,
faction_A, faction_H, npcflag, speed_walk, speed_run, scale, rank,
mindmg, maxdmg, dmgschool, attackpower, dmg_multiplier, baseattacktime,
rangeattacktime, unit_class, unit_flags, dynamicflags, family,
trainer_type, trainer_spell, trainer_class, trainer_race, minrangedmg,
maxrangedmg, rangedattackpower, type, type_flags, lootid,
pickpocketloot, skinloot, resistance1, resistance2, resistance3,
resistance4, resistance5, resistance6, spell1, spell2, spell3, spell4,
spell5, spell6, spell7, spell8, PetSpellDataId, VehicleId, mingold,
maxgold, AIName, MovementType, InhabitType, Health_mod, Mana_mod,
Armor_mod, RacialLeader, questItem1, questItem2, questItem3, questItem4,
questItem5, questItem6, movementId, RegenHealth, equipment_id,
mechanic_immune_mask, flags_extra, ScriptName) VALUES
(@ENTRY,
@MODELID1, @MODELID2, @MODELID3, @MODELID4, @NAME, @SUBNAME, @ICONNAME,
@GOSSIP_MENU_ID, @MINLEVEL, @MAXLEVEL, @EXP, @FACTION_A, @FACTION_H,
@NPCFLAG, @SPEED_WALK, @SPEED_RUN, @SCALE, @RANK, @MINDMG, @MAXDMG,
@DMGSCHOOL, @ATTACKPOWER, @DMG_MULTIPLIER, @BASEATTACKTIME,
@RANGEDATTACKTIME, @UNIT_CLASS, @UNIT_FLAGS, @DYNAMICFLAGS, @FAMILY,
@TRAINER_TYPE, @TRAINER_SPELL, @TRAINER_CLASS, @TRAINER_RACE,
@MINRANGEDMG, @MAXRANGEDMG, @RANGEDATTACKPOWER, @TYPE, @TYPE_FLAGS,
@LOOTID, @PICKPOCKETLOOT, @SKINLOOT, @RESISTANCE1, @RESISTANCE2,
@RESISTANCE3, @RESISTANCE4, @RESISTANCE5, @RESISTANCE6, @SPELL1,
@SPELL2, @SPELL3, @SPELL4, @SPELL5, @SPELL6, @SPELL7, @SPELL8,
@PETSPELLDATAID, @VEHICLEID, @MINGOLD, @MAXGOLD, @AINAME, @MOVEMENTTYPE,
@INHABITTYPE, @HEALTH_MOD, @MANA_MOD, @ARMOR_MOD, @RACIALLEADER,
@QUESTITEM1, @QUESTITEM2, @QUESTITEM3, @QUESTITEM4, @QUESTITEM5,
@QUESTITEM6, @MOVEMENTID, @REGENHEALTH, @EQUIPMENT_ID,
@MECHANIC_IMMUNE_MASK, @FLAGS_EXTRA, @SCRIPTNAME);

-- End

SET @Executing = 'Succeeded';

[quoted]

I hope it'll help. I found it does work.