Be very careful with MySql triggers.

This verified serious bug has been sitting in the closet for 10 years now!

Please don’t expect your update/delete triggers to happen in your foreign key table unless the above bug is addressed by MySql.