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 KEYhst_modified_date DATETIMEhst_type VARCHAR(2)
- triggers on INSERT, UPDATE and DELETE on source tables
- every trigger inserts modified data to audit table specifying
hst_typeas '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.
It requires MySQLdb and Python 2.7.x to function properly.