Adding a DB Trigger to hook_schema() (or something like that for module install)

I need to add a trigger to a table created as part of a custom module . This table is populated through an outside process, and I need to *do something* when that outside process UPDATES a record. I can easily add a MYSQL trigger ON UPDATE to do what I need, but....how can I make the addition of this trigger part of the module install?

Thanks