[Koha-bugs] [Bug 23673] Separate time sent from time created in message_queue table
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Dec 26 19:29:57 CET 2019
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23673
--- Comment #14 from AgustÃn Moyano <agustinmoyano at 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.
More information about the Koha-bugs
mailing list