[Koha-bugs] [Bug 21065] Data in account_offsets and accountlines is deleted with the patron leaving gaps in financial reports

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

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

--- Comment #30 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
(In reply to Martin Renvoize from comment #29)
> Did I mess up here.. should we be replacing the query to INFORMATION SCHEMA
> with foreign_key_exists? 
> 
> Jonathan Druart, I'd appreciate your thoughts here... I'm happy to code it
> up as a followup or a new bug.

I do not think so.
We are dropping the FK to recreate it with a different ON DELETE clause value.

So we could have used foreign_key_exists but rename the FK.

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