[Koha-bugs] [Bug 23066] Add foreign key for issues tables to branches table for branchcodes

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23066

--- Comment #8 from David Cook <dcook at prosentient.com.au> ---
(In reply to Marcel de Rooy from comment #7)
> Please send a mail to the list asking for further feedback from the
> community before adding this constraint. It is obvious at first sight, but
> why didn't we add it years ago then? Anything to do with keeping the old
> branchcode in old issue records or so?

A search of git suggests it might have just been an oversight?

In master kohastructure.sql we see the following for the branchcode column:

`branchcode` varchar(10) default NULL, -- foreign key, linking to the branches
table for the location the item was checked out

However, there is no foreign key. 

It appears the comment was added by commit 91b5a09c6ce (Sun Aug 2011) but even
then there was no foreign key there.

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