[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Tomás Cohen Arazi changed: What|Removed |Added Attachment #83227|0 |1 is obsolete|

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Tomás Cohen Arazi changed: What|Removed |Added Status|In Discussion |Needs Signoff -- You

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Tomás Cohen Arazi changed: What|Removed |Added Assignee|koha-b...@lists.koha-commun |tomasco...@gmail.com

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Katrin Fischer changed: What|Removed |Added See Also|https://bugs.koha-community |

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Katrin Fischer changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 --- Comment #11 from Katrin Fischer --- as biblio_id is in the illrequests I think it would make things easier to have the deleted one there as well. Same for borrowernumber, it makes report writing much easier than a subquery to

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Tomás Cohen Arazi changed: What|Removed |Added CC||tomasco...@gmail.com

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Katrin Fischer changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Katrin Fischer changed: What|Removed |Added Depends on||22440 Referenced Bugs:

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 --- Comment #9 from Katrin Fischer --- I still think we want to preserve the biblionumber, I am open to ideas on the best way of doing it. It probably is more useful for backends that import a full MARC record from another ILL, as

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Andrew Isherwood changed: What|Removed |Added Assignee|bugzi...@warmlight.co.uk

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 --- Comment #8 from Katrin Fischer --- I think Martin solved this somewhere else by having a separate column for the deleted ID as this will allow to have cleaner FK constraints, but I don't quite remember the bug report at the

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 --- Comment #7 from Katrin Fischer --- (In reply to Andrew Isherwood from comment #6) > But it's just a foreign key to the (now deleted) bib ID, is that useful > information that needs preserving? Sorry, genuine question, I'm not

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Andrew Isherwood changed: What|Removed |Added Status|Patch doesn't apply |In Discussion ---

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 --- Comment #5 from Magnus Enger --- (In reply to Katrin Fischer from comment #4) > I am not sure about this one, as we have deleted_biblio that is often useful > for reporting. I imagine some libraries will want to remove ILL

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Katrin Fischer changed: What|Removed |Added CC||katrin.fisc...@bsz-bw.de

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Michal Denar changed: What|Removed |Added Status|Needs Signoff |Patch doesn't apply

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Andrew Isherwood changed: What|Removed |Added Attachment #83226|0 |1 is obsolete|

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Andrew Isherwood changed: What|Removed |Added Status|ASSIGNED|Needs Signoff -- You

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 --- Comment #1 from Andrew Isherwood --- Created attachment 83226 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=83226=edit Bug 21983: Add foreign key constraint on biblio_id This patch adds a foreign key

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Andrew Isherwood changed: What|Removed |Added Status|NEW |ASSIGNED

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Jonathan Druart changed: What|Removed |Added Blocks||5334 Referenced Bugs:

[Koha-bugs] [Bug 21983] Deleting a bib does not delete a request's link to it - missing foreign key

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21983 Andrew Isherwood changed: What|Removed |Added CC||mag...@libriotech.no --