[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Nick Clemens changed: What|Removed |Added See Also||https://bugs.koha-community

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 George Williams (NEKLS) changed: What|Removed |Added CC|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 claire.hernan...@biblibre.com changed: What|Removed |Added Blocks|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Jonathan Druart changed: What|Removed |Added See Also|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #12 from Jonathan Druart --- (In reply to Tomás Cohen Arazi from comment #10) > (In reply to Martin Renvoize from comment #9) > > I'd +1 the merging of tables.. but can see the

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #11 from Martin Renvoize --- I like the idea of creating a view.. but the only method that would work seamlessly would be to create an entirely new 'borrowers' table with a new name and

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #10 from Tomás Cohen Arazi --- (In reply to Martin Renvoize from comment #9) > I'd +1 the merging of tables.. but can see the annoyance it would cause > people who have written reports using said

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #9 from Martin Renvoize --- I'd +1 the merging of tables.. but can see the annoyance it would cause people who have written reports using said tables.. was that the reason it was not done

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #8 from Tomás Cohen Arazi --- (In reply to Jonathan Druart from comment #7) > See also "Merge borrowers and deletedborrowers tables" topic on koha-devel 1 > year ago: >

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Jonathan Druart changed: What|Removed |Added URL|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #6 from Jonathan Druart --- (In reply to Katrin Fischer from comment #5) > We discussed if it also happens when you delete the last added borrower and > then restart - not sure

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #5 from Katrin Fischer --- We discussed if it also happens when you delete the last added borrower and then restart - not sure what the answer was. -- You are receiving this mail because: You

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #4 from Marcel de Rooy --- Does the problem mentioned on top only occur on an empty borrowers table with a mysql restart? Supposing that this is the case and it is quite rare, can't we just use

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #3 from Josef Moravec --- > Another solution? Merge borrowers and deletedborrowers to one table and mark the deleted one with a flag -- You are receiving this mail because: You are watching

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Josef Moravec changed: What|Removed |Added CC|

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 --- Comment #1 from Jonathan Druart --- Created attachment 59616 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=59616=edit Bug 18003: Example of why we would need a PK on

[Koha-bugs] [Bug 18003] Should deletedborrowers.borrowernumber be a primary key?

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18003 Jonathan Druart changed: What|Removed |Added CC|