LP#778989: Attempt to find "Correct" copy location
authorThomas Berezansky <tsbere@mvlc.org>
Wed, 1 Feb 2012 21:07:05 +0000 (16:07 -0500)
committerChris Sharp <csharp@georgialibraries.org>
Mon, 5 Jan 2015 17:44:08 +0000 (12:44 -0500)
commitcdf2bee45e758747f7cbff1fc9f82c0c2e47a82d
tree720d118ac058884ebb8f7872e14142b548a7fe9a
parentf6b014dda8ed7c1b984a6bb54d5f10f532054d5f
LP#778989: 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>
Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Ben Shum <bshum@biblio.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]