created old_issues and old_reserves tables
authorGalen Charlton <galen.charlton@liblime.com>
Thu, 13 Mar 2008 22:18:00 +0000 (17:18 -0500)
committerJoshua Ferraro <jmf@liblime.com>
Sat, 15 Mar 2008 13:36:31 +0000 (08:36 -0500)
commit9222f7a6ca80d2a74cf09872e362b116835fc02b
tree52704a5ea61e0bf770b550c6c93d11a7300f5550
parent86e4cdf54b2f9b942407078bd02165ccb0a9b439
created old_issues and old_reserves tables

The new tables have the same structure and constraints
as the tables they archive with the following exceptions:

* borrowernumber and biblionumber in old_reserves can be
  NULL
* the FK constraints (e.g., for itemnumber) on old_reserves
  set the child column to NULL if the parent row is deleted
  instead of deleting the child row.
* there is no FK constraint on old_issues.branchcode, allowing
  a branch to be deleted without changing archived requests.

Some miscellaneous cleanup was done as part of this patch:

* GetMemberIssuesAndFines (C4::Members) now uses bind variables
* fixed POD for GetMemberIssuesAndFines

Signed-off-by: Joshua Ferraro <jmf@liblime.com>
27 files changed:
C4/Accounts.pm
C4/Circulation.pm
C4/Items.pm
C4/Members.pm
C4/Overdues.pm
C4/Reserves.pm
catalogue/detail.pl
catalogue/updateitem.pl
cataloguing/additem.pl
circ/bookcount.pl
circ/overdue.pl
circ/pendingreserves.pl
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl
kohaversion.pl
misc/cronjobs/longoverdue.pl
misc/cronjobs/notifyMailsOp.pl
misc/cronjobs/overduenotices-30.pl
misc/cronjobs/overduenotices-csv.pl
misc/cronjobs/overduenotices.pl
misc/cronjobs/reservefix.pl
misc/cronjobs/update_items.pl
opac/opac-reserve.pl
reports/issues_avg_stats.pl
reserve/request.pl
serials/routing-preview.pl
tools/inventory.pl