On 3/11/08, Galen Charlton <galen.charlton@liblime.com> wrote:

Hi,

I would like to create two new tables, old_issues and old_reserves,
that would be used to store completed checkouts (issues) and hold
requests (reserves). Similar to how tables like deleteditems
function, whenever a checkout or hold request transaction is completed
or canceled, the row representing it would be moved to old_issues or
old_reserves respectively.

Hi Galen

This sounds like a great Idea to me. As long as things like borrower history know to look in the new table, it should be all good.

Chris