From c99743d0c05b0f3e406de4bf4c1a77bc6045d047 Mon Sep 17 00:00:00 2001 From: Zeno Tajoli Date: Fri, 14 Mar 2014 11:38:07 +0100 Subject: [PATCH] [SIGNED OFF] Bug 11939 - Better default for currencies This patch offers a better default for currencies, with USA dollar as default active currency. To test the patch: 1)Install master without the patch, during web installation select 'parameters.sql' file 2)Finish install and go to Administration -Currencies & Exchange rates 3)No active currency 4)Install master with this patch, during web installation select 'parameters.sql' file 5)Finish install and go to Administration -Currencies & Exchange rates 6)Now USA dollar is the active currency http://bugs.koha-community.org/show_bug.cgi?id=11939 NOTE: This does solve the problem of everything being NULL for active, and lacking an active value. It also corrects the description of the optional item to check related to currencies. Signed-off-by: Mark Tompsett --- installer/data/mysql/en/optional/parameters.sql | 11 +++++------ installer/data/mysql/en/optional/parameters.txt | 2 +- 2 files changed, 6 insertions(+), 7 deletions(-) diff --git a/installer/data/mysql/en/optional/parameters.sql b/installer/data/mysql/en/optional/parameters.sql index 84a176b..16e8642 100644 --- a/installer/data/mysql/en/optional/parameters.sql +++ b/installer/data/mysql/en/optional/parameters.sql @@ -1,6 +1,5 @@ -INSERT INTO `currency` (currency, rate, symbol) VALUES -('USD', 1.0, '$'), -('GBP', 1.9929, '£'), -('CAD', 1.02207, '$'), -('EUR', .874003, '€'); - +INSERT INTO `currency` (currency, rate, symbol, active) VALUES +('USD', 1.0, '$', '1'), +('GBP', 1.9929, '£', '0'), +('CAD', 1.02207, '$', '0'), +('EUR', .874003, '€', '0'); diff --git a/installer/data/mysql/en/optional/parameters.txt b/installer/data/mysql/en/optional/parameters.txt index a104562..a778b1f 100644 --- a/installer/data/mysql/en/optional/parameters.txt +++ b/installer/data/mysql/en/optional/parameters.txt @@ -1 +1 @@ -Some basic settings including USD currency, and a sampling of Z39.50 servers. +Some basic currencies with USA dollar as default for ACQ module -- 1.7.9.5