[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
Mon Jan 27 19:51:25 CET 2020
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23673
--- Comment #17 from Tomás Cohen Arazi <tomascohen at gmail.com> ---
(In reply to Jonathan Druart from comment #16)
> (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 mean making the 'time_queued' column TIMESTAMP DEFAULT NULL (and so making
us set it manually), and making 'updated_on' be the one with the trigger? (so
we don't do the update manually?). I'm fine with either. Just trying to clarify
so we move this forward.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list