[Koha-bugs] [Bug 10636] patronimage should have borrowernumber as PK, not cardnumber

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

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

--- Comment #9 from Srdjan Jankovic <srdjan at catalyst.net.nz> ---
1. I had problems with either borrowers changing card numbers, or being removed
(have no idea what is possible, but the situation is real, I'm using a clients
prod dump). In order to establish new PK there must be no nulls, so patronimage
should be purged first, something on the lines of DELETE FROM patronimage wHERE
NOT EXISTS(borrower).

2. The patch adds UNIQUE and then PK. I understand why UNIQUE, but that is
maybe an overkill. So it should either be removed (as in not included in the
statement), or dropped afterwards.

3. There should be an FK statement to replace dropped FK

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