Gossamer Forum
Home : Products : DBMan SQL : Discussion :

suggestion to modify log table structure

Quote Reply
suggestion to modify log table structure
Now the log table structure is:
log_time, action, user_id, ip, tablename

the action is like: add record 1

I have a suggestion to midify the structure to be:
log_time, action, user_id, ip, tablename, record, memo

the action filed is only a action type: add, del, mod, loginout
the record field is the record ID of the action

I wish the setup of table have an option: whether record the record change detail. If yes, when modify a record, system can compare every field of after and befor the modify, then record the original content of changed field. It will be very useful to trace the change.
Subject Author Views Date
Post suggestion to modify log table structure cfox 2435 Mar 27, 2003, 11:45 PM