]> git.evergreen-ils.org Git - Evergreen.git/commit
Fix divergence of stock serials schema and upgraded schema
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Tue, 23 Oct 2012 16:25:18 +0000 (12:25 -0400)
committerMike Rylander <mrylander@gmail.com>
Mon, 11 Mar 2013 20:23:52 +0000 (16:23 -0400)
commit302e1bc0f09ea24b7c9449c33cb13acc86e417a0
tree7fbafb3479f3f7afdd2090c50b6cd600f1c64c9d
parent9a082a5f6d66c96a057015e9207882ca94e53814
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>
Signed-off-by: Mike Rylander <mrylander@gmail.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]