That makes sense. I'll have to modify my patch for that. FYI, if anyone is interested, this work is available at http://koha-plus.git.sourceforge.net/git/gitweb.cgi?p=koha-plus/koha-plus;a=... if anyone wants to monitor it. Kyle http://www.kylehall.info Information Technology Crawford County Federated Library System ( http://www.ccfls.org ) On Fri, Oct 9, 2009 at 10:57 AM, Joe Atzberger <ohiocore@gmail.com> wrote:
On Fri, Oct 9, 2009 at 8:54 AM, Kyle Hall <kyle.m.hall@gmail.com> wrote:
Here's the roadmap I have planned out. I'll put this on the wiki if anyone would like me to.
Step 1) accountlines.accountno becomes the primary key. Payments reference fines paid via accountno_paid. ( I've already written this and sent a patch ).
No, we should create an entirely new primary key (say, "line_id"), to avoid the problem that accountno might already have conflicting values in it, blocking the DB conversion to primary key or forcing data to be dropped in the process.
I think the overdue script will be unchanged. The options and configurations for fines/debar are all exposed already. --joe