Creating an audit trail on php

What is the best way on implementing an audit trail on multiple tables which requires an audit trail?

This is so far what I've done. It's too much work if I put the same column on other tables repeatedly. Is there a better way to achieve than this approach?

[Users Table]
id
user_id
username
password
first_name
middle_name
last_name
email_address
is_active
date_and_time_activated
activated_by
date_and_time_deactivated
deactivated_by
date_and_time_created
created_by
date_and_time_modified
modified_by
is_locked
date_and_time_locked
locked_by
is_deleted
date_and_time_deleted
deleted_by
date_and_time_restored
restored_by

[IP Addresses Table]
id
ip_address
subnet_mask
name
description
is_active
date_and_time_activated
activated_by
date_and_time_deactivated
deactivated_by
date_and_time_created
created_by
date_and_time_modified
modified_by
is_locked
date_and_time_locked
locked_by
is_deleted
date_and_time_deleted
deleted_by
date_and_time_restored
restored_by