https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12146 Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Failed QA |Needs Signoff Assignee|indradg@l2c2.co.in |martin.renvoize@openfifth.c | |o.uk --- Comment #10 from Martin Renvoize (ashimema) <martin.renvoize@openfifth.co.uk> --- Reviving this with a wider scope, prompted by review feedback on bug 43291 (SIP2 currency code): currency.isocode being a free-text varchar(5) with no format enforcement meant it couldn't be trusted to hold a valid ISO 4217 code. New patch series: 1) Resize currency.isocode to CHAR(3), matching the ISO 4217 alpha code format, normalizing any existing bad data first. 2) Automated schema update. 3) Populate the "Some basic currencies" sample dataset with the full set of active ISO 4217 currency codes (in addition to the original ask of just adding isocode to the existing curated entries). Bug 43291 will depend on this one and drop its own defensive isocode validation once this lands, since the schema itself now guarantees the format. -- You are receiving this mail because: You are watching all bug changes.