bug 2522 [1/3]: DB rev 3.1/001 - hold request targetting
authorGalen Charlton <galen.charlton@liblime.com>
Fri, 15 Aug 2008 01:59:49 +0000 (20:59 -0500)
committerGalen Charlton <galen.charlton@liblime.com>
Mon, 18 Aug 2008 12:16:08 +0000 (07:16 -0500)
commit4c037341e4ca1aa9e9d3bf8a3ff599d83f357426
tree1babc640735d6d883dd8906af280719cb1ad5270
parentdee5f4945b645bbd314602479f990a08a896370c
bug 2522 [1/3]: DB rev 3.1/001 - hold request targetting

For bug 2522, add a new table called hold_fill_targets to
implement hold request targeting.  This table
has the following columns:

  borrowernumber     - identify request
  biblionumber       - ditto
  itemnumber         - item targeted to fill request
  source_branchcode  - current location of item
  item_level_request - if 1, request is item-level

For bug 2331, adds a column called item_level_request
to tmp_holdsqueue.

Note: both of the item_level_request columns can
go away once reserves is modified so that
it is clear whether a request is item-level or
bib-level.

Signed-off-by: Galen Charlton <galen.charlton@liblime.com>
installer/data/mysql/kohastructure.sql
installer/data/mysql/updatedatabase.pl
kohaversion.pl