This is quick job for someone who has already done this.
We have 4 tables: packages, transactions, book history, user table.
We need to create audit table for each to track any changes made to above. So, whenever there is insert, update or delete, it creates new entry in the packages_audit, ... etc tables.
* show me example of what you done before
* deliverable is mysql statements that we can deploy to install triggers. Obviously put if exists delete trigger on top so that it is rerunnable. also, obviously need to create the tables as well.