https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23673 --- Comment #14 from Agustín Moyano <agustinmoyano@theke.io> --- Hi Jonathan
1. Should not we have the new column with the "default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP" clause in order to delegate the update of this value to the DBMS?
Mysql doesn't accept a table with 2 columns with "default CURRENT_TIMESTAMP".. there can be only one.
2. I think we almost agreed on a pattern for the timestamp/datetime columns (there is nothing in the coding guidelines however), to name them suffixed by _on time_status_changed would be updated_on
Ok, I didn't know about that rule.. I'll change that name in follow up. Regards. -- You are receiving this mail because: You are watching all bug changes.