Fix divergence of stock serials schema and upgraded schema collab/senator/serials-harmonize-divergent-schema
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Tue, 23 Oct 2012 16:25:18 +0000 (12:25 -0400)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Tue, 23 Oct 2012 16:25:18 +0000 (12:25 -0400)
commit45f0b7e05cf5a5c6786244421032c01662405a1c
treebf150232cb68c9a9e124791c760ee218542db31d
parent67b236752db8735c4a71ebeaa9bb60e18bf20e8b
Fix divergence of stock serials schema and upgraded schema

And additionally make a function used in a constraint on
serial.issuance.holding_code a little bit smarter.

These issues were reported to me by Galen Charlton.

The upgrade script included here will set serial.issuance.holding_code
to NULL in cases where the value doesn't validate, but in those cases
there is no part of Evergreen that could have made use of the data
anyway, and the data is just plain bad.

Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Open-ILS/src/sql/Pg/000.functions.general.sql
Open-ILS/src/sql/Pg/210.schema.serials.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serials-holding-code-test-improved.sql [new file with mode: 0644]