Allow NULL "use restriction" fields for located URIs
authordbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 16 Apr 2011 03:28:36 +0000 (03:28 +0000)
committerdbs <dbs@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Sat, 16 Apr 2011 03:28:36 +0000 (03:28 +0000)
commit37dd4a76f047d3a3bd6c18f32b7dccbabac549cd
tree207a5df7cea0d28702d457d4ca669f08e2cdda88
parent9d7ef98800a6dcb5f04c7f8f50eb062055a094f8
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_0@20125 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]