From af562d18675013c7c0b9c52872eef58ebeca7bd5 Mon Sep 17 00:00:00 2001 From: Indranil Das Gupta Date: Mon, 11 May 2015 02:20:13 +0530 Subject: [PATCH] Bug 12146 [ENH] Add isocode column to parameters.sql a) Adds currency.isocode column to parameters.sql b) Introduces INR as an option for Koha's EN installation locale in the list of currencies Remarks: The issue of non-mandatory nature of isocode column is already settled via bug 9593, comment 77. Test Plan ========= 1/ create a fresh Koha instance and run the web installer 2/ at step #3 - "Selecting Default Settings", select "Some basic currencies with USA dollar as default for ACQ module" under the section "Optional" to import the sample currencies. 3/ login to this new instance and go to Home -> Administration -> Currencies & Exchange rates 4/ click edit for any of the currency options 5/ ISO code will be blank 6/ Apply patch 7/ Repeat steps 1 to 4 above 8/ ISO code will now show 3-letter ISO codes inserted by patched parameters.sql Signed-off-by: Nick Clemens --- installer/data/mysql/en/optional/parameters.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/en/optional/parameters.sql b/installer/data/mysql/en/optional/parameters.sql index 16e8642..5334740 100644 --- a/installer/data/mysql/en/optional/parameters.sql +++ b/installer/data/mysql/en/optional/parameters.sql @@ -1,5 +1,6 @@ -INSERT INTO `currency` (currency, rate, symbol, active) VALUES -('USD', 1.0, '$', '1'), -('GBP', 1.9929, '£', '0'), -('CAD', 1.02207, '$', '0'), -('EUR', .874003, '€', '0'); +INSERT INTO `currency` (currency, rate, symbol, active, isocode) VALUES +('USD', 1.0, '$', '1', 'USD'), +('GBP', 1.9929, '£', '0', 'GBP'), +('CAD', 1.02207, '$', '0', 'CAD'), +('EUR', .874003, '€', '0', 'EUR'), +('INR', 63.71, '₹', '0', 'INR'); -- 2.1.4