Helps creating audit tables and triggers to track data changes in MySQL.
On execution, mysql-history connects to a MySQL database and creates:
- audit tables as copies of source tables (1 for every source table) with the following columns added:
hst_id INT PRIMARY KEY
hst_modified_date DATETIME
hst_type VARCHAR(2)
- triggers on INSERT, UPDATE and DELETE on source tables
- every trigger inserts modified data to audit table specifying
hst_type
as 'I', 'U' or 'D'
- every trigger inserts modified data to audit table specifying
When source tables change just re-run the script and it will add new columns to audit tables and modify datatypes of existing ones if possible.