[Koha-bugs] [Bug 14069] Follow-up 13790: Fix database update to drop PK on issues/old_issues first

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

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

--- Comment #7 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
(In reply to Colin Campbell from comment #6)
> Wonder if there needs to be a unique constraint on itemnumber in issues.
> Have noticed after losing the old PK constraint that duplicate issues can
> now occur, in various places ( fines? holds?) I think there are assumptions
> that only 1 isssue will exist for an itemnumber

I think a unique for the issues table would make sense. 

Did you experience double issues? It sounds scary, but I am still hoping we are
not doing that, as it looked like not all installations had the PK to begin
with. We removed the line from kohastructure quite a while back by accident
with:
http://git.koha-community.org/gitweb/?p=koha.git;a=commit;h=91b5a09c6cef398d9ad39ca1ced7d6569a87456b

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