You can use DEFAULT constraints to set the timestamp: ALTER TABLE MODIFY dt_created datetime DEFAULT CURRENT_TIMESTAMP ALTER TABLE MODIFY dt_modified datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP Then you wouldn’t have to specify NOW() in your INSERT/UPDATE statements. Reference: TIMESTAMP properties
Logging typically means the recording of implementation level events that happen as the program is running (methods get called, objects are created, etc.). As such it focuses on things that interest programmers Auditing is about recording domain-level events: a transaction is created, a user is performing an action, etc. In certain types of application (Banking) … Read more
That’s simple: sudo fs_usage | grep [path_to_file]
In the project I’m working on, audit log also started from the very minimalistic design, like the one you described: event ID event date/time event type user ID description The idea was the same: to keep things simple. However, it quickly became obvious that this minimalistic design was not sufficient. The typical audit was boiling … Read more
One method that is used by a few wiki platforms is to separate the identifying data and the content you’re auditing. It adds complexity, but you end up with an audit trail of complete records, not just listings of fields that were edited that you then have to mash up to give the user an … Read more