Using trigger based store procedure to create audit table. It follows the wordpress meta data approach to store the changes, so all the data is store in just two centalized tables.