Rename triggers to follow the <table>_name convention

As part of #379 (closed) we will modify a lot of triggers, so let's leverage the occasion to rename those to follow the (implicit) convention of prefixing the trigger name with the table it relates to.

This could be done as part of #379 (closed) directly but the changeset will be big enough as if, might as well keep it simple for a renaming.