search

buddhika75 / circular

2 stars 0 forks source link

Audit trail #14

Open chamiw2008 opened 11 years ago

chamiw2008 commented 11 years ago

We have to add a good audit trail.

Log server time IP address/ MAC address (need to get from client side by ? Java script?) User

for all ADD, EDIT, DELETE functions !

For EDIT and DELETE we have to archive the old.

Since most of the code is written and database is designed;

My suggestion is,

  1. Add a 'audit' table with five fields : audtoID, Time, IP Addr.............
  2. Generate a record for each activity / button press
  3. Add a required field for each other table and save the relevant autoID of the audit table record.
chamiw2008 commented 11 years ago

In the audit table another field for event type (Add, edit, view, delete, login, logoff, etc)

Have to preserve the deleted and edited records, it the current database arch need drastic change to accommodate this;

We can generate text record and save in a separate table or file.

buddhika75 commented 11 years ago

I will do it. Preserving old records is not difficult. We just mark them as retired and remove from searches.