Bug 2685 - add a foreign key from items.bibionumber to biblio.biblionumber
Summary: add a foreign key from items.bibionumber to biblio.biblionumber
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: master
Hardware: PC All
: P3 normal (vote)
Assignee: Galen Charlton
QA Contact:
Depends on:
Reported: 2008-10-16 06:20 UTC by Chris Cormack
Modified: 2016-03-30 14:22 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Who signed the patch off:
Text to go in the release notes:
Version(s) released in:


Note You need to log in before you can comment on or make changes to this bug.
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.