[werebat]

One line fixes all, for example: this line will halve the hp's of all npcs

update npc_types set hp = hp * 0.5;

Backup your table first so if you mess up you can restore it.