[Koha-patches] [PATCH] Bug 12146 [ENH] Add isocode column to parameters.sql

[Indranil Das Gupta]

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
---
 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');
-- 
1.9.1