Bug 2685

Summary: add a foreign key from items.bibionumber to biblio.biblionumber
Product: Koha Reporter: Chris Cormack <chris>
Component: DatabaseAssignee: Galen Charlton <gmcharlt>
Status: CLOSED REMIND QA Contact:
Severity: normal    
Priority: P3    
Version: Main   
Hardware: PC   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16170
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Chris Cormack 2010-05-21 00:54:41 UTC


---- Reported by Andrew.moore@liblime.com 2008-10-16 06:20:41 ----

I don't think there's a FK from items.biblionumber into the bibio table. I think that there should be one.

I caught Paul on IRC and he seemed to agree with me, but I don't think he actually looked at the schema definition.

I haven't tried to add a key to see if it causes any problems.



---- Additional Comments From gmcharlt@gmail.com 2008-10-16 06:29:41 ----

I agree that the FK should be added.  There is an FK on items.biblioitemnumber to biblioitems, but since biblioitems is effectively just an extension of biblio nowadays, having a direct FK between items and bilbio would be better.



---- Additional Comments From nengard@gmail.com 2009-12-23 17:59:39 ----

This bug hasn't been touched in nearly a year, please revisit and test and close if appropriate.



--- Bug imported by chris@bigballofwax.co.nz 2010-05-21 00:54 UTC  ---

This bug was previously known as _bug_ 2685 at http://bugs.koha.org/cgi-bin/bugzilla3/show_bug.cgi?id=2685

Actual time not defined. Setting to 0.0
The original reporter of this bug does not have
   an account here. Reassigning to the person who moved
   it here: chris@bigballofwax.co.nz.
   Previous reporter was Andrew.moore@liblime.com.