TriggerMan is intended to simplify the task of creating basic audit tables and triggers in MySQL. TriggerMan can:
• Read table and trigger definitions from the Information_Schema database. The user never has to enter table/column definition data when creating audit tables or triggers, or create scripts.
• 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.
Features
- • Read table and trigger definitions from the Information_Schema database. The user never has to enter table/column definition data when creating audit tables or triggers, or create scripts. • 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 all 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.