You'll want to use Triggers. Something along this line:
AFTER INSERT
INSERT INTO syspass_AuditTrail SELECT 'syspass_sql' as TableName, 'Insert' as Action, USER() as ModifiedBy, NOW() as ModifiedDate FROM __new
AFTER DELETE
INSERT INTO AuditTrail SELECT 'syspass_sql' as TableName, 'Delete' as Action, USER() as ModifiedBy, NOW() as ModifiedDate FROM __new