https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23673
--- Comment #17 from Tomás Cohen Arazi <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
