[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

David Cook <dcook at prosentient.com.au> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dcook at prosentient.com.au

--- Comment #5 from David Cook <dcook at prosentient.com.au> ---
This makes me so happy. I was just about to report this, so I'm glad to see the
issue and a patch. 

I'm in a rush at the moment, but I'll make a note to come back to this to test
and sign off. 

(I wish that there were an alternative to "SET NULL" for old_issues, but I
don't think there is with our current architecture.)

A library of ours got bitten by this. They moved their items to a new branch,
deleted the old branch, but their issues are all for the old non-existent
branch. 

I took a little look around and it seems like these might be the only relevant
tables missing the foreign key relationship to the branches table. 

Once again, thanks Kyle!

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