This week I have been working on the support site administration side, updating it section by section to make it easier to do things, and have just automated a feature that logs database table changes.
This will be merged with the project once a user access level feature has been implemented in the Administration Tool, and allows any query to be watched and logged with one call to the database class.
Logging a query will then automatically insert the changes made (insert, update, or delete) to a database table in the logging database, with a timestamp of the changes, and obviously logs who made those changes.
This provides the benefit for a store administrator to see who did what and when, and with filtering options, easily allows to see changes made to specific modules, changes made by a particular user, and changes made between a specific date period.
The benefit is not only for store administrators though, as when another person has access to the administrator log, they will also see the changes made to modules they themselves only have access to.
All this to increase team awareness 8)