[Koha-bugs] [Bug 16170] Pseudo foreign key in Items
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu Mar 31 02:15:21 CEST 2016
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16170
M. Tompsett <mtompset at hotmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Attachment #49681|0 |1
is obsolete| |
--- Comment #3 from M. Tompsett <mtompset at hotmail.com> ---
Created attachment 49707
-->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=49707&action=edit
Bug 16170: Pseudo foreign key in Items
While many of us would like to get rid of biblioitems one day, the current
scheme includes a biblioitemnumber and a biblionumber in Items.
(Which is not so great..)
But also note that biblionumber is NOT defined as a foreign key in Items,
although a belongs_to relation has been added to the DBIx scheme!
This inconsistency should be resolved. The "remove biblioitem table"
operation is a large one, but in the meantime we better make biblionumber
a regular FK not a 'pseudo' one.
Note: If in an (very) exceptional case biblionumbers are found in items,
that do not exist in biblio, this patch prints a warning at upgrade
time and does not add the constraint.
@RM: Please update the DBIx scheme accordingly.
Test plan:
[1] Run the upgrade. Check if the FK constraint has been added.
[2] Remove the FK constraint. Change the biblionumber of one item to an
unexisting record. Run the upgrade again. Notice the warning.
Signed-off-by: Marcel de Rooy <m.de.rooy at rijksmuseum.nl>
Tested both cases: constraint added as well as warning printed.
Signed-off-by: Mark Tompsett <mtompset at hotmail.com>
Tested with my patch too.
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list