[Koha-bugs] [Bug 13518] Table borrower_modifications is missing FK and not deleted with the patron

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

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

--- Comment #2 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
The problem is that this table is used for the borrower modifications and the
self-registration features.

So far borrowernumber is the PK (int(11) NOT NULL DEFAULT '0'), for the
self-registration feature we can have borrowernumber that is not defined (0 is
used)

Ideally we would like to have borrowernumber a DEFAULT NULL, and use NULL for
self-reg, but then we will loose the PK (PK cannot be NULL).

I do not think we will be able to keep the correct constraints at DB level
anyway, we will need to handle consistency at code-level.

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