TriggerMan
An Audit Table and Trigger Management Tool for MySQL
...
• List existing tables and TriggerMan objects in a schema, and allow the user to choose which ones to operate on.
• Given a table, it can dynamically generate a corresponding audit table. This audit table contains specified columns from the original table, plus additional auditing information columns, such as when changes were made, and by whom.
• After creating an audit table, it can create triggers on the original table which control how and when data is written to the audit table; for example, Before Update or After Insert.
• Apply processing to multiple objects in a single operation.