I have created a trigger on the category table so when a new category is added it will perform an insert on the discount mapping table for all discounts.  Adding a new category in nopCommerce administration section is not running the trigger as expected, however, if I use an insert statement it is working as expected.

Is there some configuration I need to set up first or is there somthing I am missing.