Attempt to find "Correct" copy location
authorThomas Berezansky <tsbere@mvlc.org>
Wed, 1 Feb 2012 21:07:05 +0000 (16:07 -0500)
committerJason Stephenson <jstephenson@mvlc.org>
Fri, 1 Feb 2013 14:50:33 +0000 (09:50 -0500)
commitc252a99825a85ca18b2a47274eddd5e6ea76577f
tree48f432f54751186523b92d71a2dfbb38b6986ed6
parente9aaad28bcd44d51f70882239bcbb6233f07db98
Attempt to find "Correct" copy location

This adds a trigger to asset.copy that on insert or change of the location
and/or call number tries to find an identically named copy location that
is scoped to the owning library of the copy.

If it does not find one it uses the location provided.

Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Open-ILS/src/sql/Pg/040.schema.asset.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.correct_copy_location.sql [new file with mode: 0644]