[Koha-bugs] [Bug 23673] Separate time sent from time created in message_queue table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23673

--- Comment #16 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Agustín Moyano from comment #14)
> 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.

Hola Agustín, Yes I know and that's why I suggested to have it on the new
column :)

Take a look at library_groups or borrowers tables for instance. Note that
article_requests does the reverse.

-- 
You are receiving this mail because:
You are watching all bug changes.