On Fri, Oct 9, 2009 at 8:54 AM, Kyle Hall <span dir="ltr"><<a href="mailto:kyle.m.hall@gmail.com">kyle.m.hall@gmail.com</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Here's the roadmap I have planned out. I'll put this on the wiki if<br>
anyone would like me to.<br>
<br>
Step 1) accountlines.accountno becomes the primary key. Payments<br>
reference fines paid via accountno_paid. ( I've already written this<br>
and sent a patch ).<br></blockquote><div><br>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.<br>
<br>I think the overdue script will be unchanged. The options and configurations for fines/debar are all exposed already.<br></div></div>--joe<br>