Allow NULL "use restriction" fields for located URIs
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 16 Apr 2011 03:27:20 +0000 (03:27 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 16 Apr 2011 03:27:20 +0000 (03:27 +0000)
commitdfd89233f7dd2bd5d55c984596b21691db3a9aa1
treecc27877ebb206886d265e4a79bdf6857c49a1d67
parent1e5545cf392fd35cd429a0920b2feb114db92cce
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/branches/rel_2_1@20124 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]