Allow NULL "use restriction" fields for located URIs
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 16 Apr 2011 03:26:11 +0000 (03:26 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 16 Apr 2011 03:26:11 +0000 (03:26 +0000)
commitb7b4e1ecf328a0f6f44362374957cfde9400b9b7
treee27e2926ed120cceb7e27bdd2973d5d943734b4b
parent8685c7934f8c5d078ece464ed4b25efec8b716a6
Allow NULL "use restriction" fields for located URIs

The asset.uri.use_restriction field, which is really a sort of public notes
field for 856 fields, was grabbing the $u subfield (URL) as a sort of last-gasp
effort to give it some data. However, the effect was rather odd and led to
workarounds like Conifer's skin to avoid displaying the use restriction field
if its value was identical to the URL, etc.

Instead, stop grabbing $u and handle the case where use_restriction column is
NULL gracefully, just like the schema intended.

git-svn-id: svn://svn.open-ils.org/ILS/trunk@20123 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/030.schema.metabib.sql
Open-ILS/src/sql/Pg/upgrade/0521.schema.u-no-uri-use.sql [new file with mode: 0644]