Bug 11939: set active currency when using English sample data

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

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 <mtompset@hotmail.com>
Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de>
Works as described, passes all tests and QA script.

Signed-off-by: Galen Charlton <gmc@esilibrary.com>
(cherry picked from commit 6a5c2d51819c193580a2bc42856215a9b7d3b9f8)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>

Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
(cherry picked from commit 9eb55874ca87794b1a254bd2a194d3f1453e14b8)

diff --git a/installer/data/mysql/en/optional/parameters.sql b/installer/data/mysql/en/optional/parameters.sql
index 84a176b..16e8642 100644 (file)
--- 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 (file)
--- 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