subscriptionroutinglist fields borrowernumber and subscriptionid must not be null. Also, borrowernumber and subscriptionid combination must be unique.
Created attachment 2689 [details] [review] Proposed patch
This could be made even stricter - borrowernumber and subscriptionid ought to have foreign key constraints.
Submitted pull request for git://git.librarypolice.com/git/koha-galen.git bug5308 which includes a sign-off of Srdjan's patch and a follow-up to add the foreign key constraints.
Pulled into branch new/bug_5308, If it tests cleanly, will be merged to master, please test and let me know
Tested ok, pushed to master, please test and close
This bug has a patch presently committed to HEAD and 3.2.x. Please take the appropriate action to update the status of this bug. Remember, bugs which have been resolved should be tested and marked closed, preferably by the original reporter.
This bug is mentioned in: bug 5308: subscriptionroutinglist more strict http://lists.koha-community.org/pipermail/koha-patches/2010-October/012685.html
This bug has a fix which was committed to the 3.2.x branch and released in 3.2.1. Please take time to update the status of this bug and mark it RESOLVED FIXED so that it may be closed.