[Kayen]

UPDATE npc_types SET HP = HP * 0.75;
UPDATE npc_types SET spellscale = 75;
UPDATE npc_types SET healscale = 75;

That will do exactly what you want. Alter ALL NPC's in database by 25 pct for HP and spells damage / healing.