We have field named "Modified" in certain tables (including category items), that holds last modification date of and database record. There are several problems in current implementation:
- field is updated no matter was something changed or not;
- field is always updated no matter what user have entered on editing template.
I propose to fix that by:
- check that other fields (except that Modified) field were changed before changing it
make Modified field on editing form as label, since user entered value will be always ignored.
Same about ModifiedById field around the system.