Bugzilla – Attachment 47281 Details for
Bug 12146
Add new ISO code column to currency sample files
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 12146 [ENH] Add isocode column to parameters.sql
Bug-12146-ENH-Add-isocode-column-to-parameterssql.patch (text/plain), 1.87 KB, created by
Nick Clemens (kidclamp)
on 2016-01-25 21:37:00 UTC
(
hide
)
Description:
Bug 12146 [ENH] Add isocode column to parameters.sql
Filename:
MIME Type:
Creator:
Nick Clemens (kidclamp)
Created:
2016-01-25 21:37:00 UTC
Size:
1.87 KB
patch
obsolete
>From af562d18675013c7c0b9c52872eef58ebeca7bd5 Mon Sep 17 00:00:00 2001 >From: Indranil Das Gupta <indradg@gmail.com> >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 <nick@bywatersolutions.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 12146
:
39020
| 47281