[Koha-bugs] [Bug 7241] circulation action logs record biblionumber instead of item number

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

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7241

--- Comment #25 from Adrien SAURAT <adrien.saurat at biblibre.com> ---
Ok, I made a test with this request and it modified all the timestamps of my
updated rows.
That's because this field is designed to store the date of each sql update:
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,

It seems to me that, for these logs, the important date is the "library action"
date and not the "last SQL modification" date.

---

I suggest adding also the following line before the UPDATE:
ALTER TABLE action_logs CHANGE timestamp timestamp TIMESTAMP NOT NULL DEFAULT
CURRENT_TIMESTAMP;

The timestamp will still be automatically set when creating a row, but updating
won't change the original date/time.

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