]> git.evergreen-ils.org Git - working/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:20:59 +0000 (16:20 -0400)
commit0e1335cab7cf7328d107c86b0cd237146bda38e2
tree3dfca2e31c53bf923b6ed71d9811042480fb5ba8
parent1602d92b9ef4ac152722c136296230d1f20eb4d8
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]