Poking holes: what if the database schema is changes at same point later in time, and a column name changes or is deleted completely?
For data integrity: you must make sure that every update or delete operation will update your tracking table. That is best accomplished by triggers calling stored procedures. You should make sure only those stored procedures have writing access to your tracking table, so noone else can write wrong values.