Bugzilla – Attachment 26415 Details for
Bug 11939
Sample of currencies with a working active value
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11939: Add active currency for all data files
Bug-11939-Add-active-currency-for-all-data-files.patch (text/plain), 6.86 KB, created by
Jonathan Druart
on 2014-03-17 16:22:15 UTC
(
hide
)
Description:
Bug 11939: Add active currency for all data files
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2014-03-17 16:22:15 UTC
Size:
6.86 KB
patch
obsolete
>From 74a7d15660ad37ef217d8087db6c4a4911f0af4a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@biblibre.com> >Date: Mon, 17 Mar 2014 17:21:09 +0100 >Subject: [PATCH] Bug 11939: Add active currency for all data files > >Test plan: >insert all sql files modified by this patch and verify the data is >correctly inserted. >--- > installer/data/mysql/es-ES/optional/parameters.sql | 10 +++++----- > installer/data/mysql/it-IT/necessari/parameters.sql | 8 ++++---- > installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql | 10 +++++----- > installer/data/mysql/pl-PL/optional/parameters.sql | 10 +++++----- > installer/data/mysql/ru-RU/optional/sample_currency.sql | 12 ++++++------ > installer/data/mysql/uk-UA/optional/sample_currency.sql | 12 ++++++------ > 6 files changed, 31 insertions(+), 31 deletions(-) > >diff --git a/installer/data/mysql/es-ES/optional/parameters.sql b/installer/data/mysql/es-ES/optional/parameters.sql >index 84a176b..00cc5a9 100644 >--- a/installer/data/mysql/es-ES/optional/parameters.sql >+++ b/installer/data/mysql/es-ES/optional/parameters.sql >@@ -1,6 +1,6 @@ >-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, '$', 0), >+('GBP', 1.9929, '£', 0), >+('CAD', 1.02207, '$', 0), >+('EUR', .874003, 'â¬', 1); > >diff --git a/installer/data/mysql/it-IT/necessari/parameters.sql b/installer/data/mysql/it-IT/necessari/parameters.sql >index 1319f33..806bba7 100644 >--- a/installer/data/mysql/it-IT/necessari/parameters.sql >+++ b/installer/data/mysql/it-IT/necessari/parameters.sql >@@ -1,8 +1,8 @@ > SET FOREIGN_KEY_CHECKS=0; > >-INSERT INTO `currency` (currency, rate, symbol) VALUES >-('USD', 1.4, '$'), >-('GBP', .8, '£'), >-('EUR', 1, 'â¬'); >+INSERT INTO `currency` (currency, rate, symbol, active) VALUES >+('USD', 1.4, '$', 0), >+('GBP', .8, '£', 0), >+('EUR', 1, 'â¬', 1); > > SET FOREIGN_KEY_CHECKS=1; >diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql b/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql >index 0670137..6343e54 100644 >--- a/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql >+++ b/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql >@@ -19,8 +19,8 @@ > -- with Koha; if not, write to the Free Software Foundation, Inc., > -- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. > >-INSERT INTO `currency` (currency, rate, symbol) VALUES >-('USD', 5.6157, '$'), >-('NOK', 1.0, '$'), >-('GBP', 8.9680, '£'), >-('EUR', 7.8940, 'â¬'); >+INSERT INTO `currency` (currency, rate, symbol, active) VALUES >+('USD', 5.6157, '$', 0), >+('NOK', 1.0, '$', 1), >+('GBP', 8.9680, '£', 0), >+('EUR', 7.8940, 'â¬', 0); >diff --git a/installer/data/mysql/pl-PL/optional/parameters.sql b/installer/data/mysql/pl-PL/optional/parameters.sql >index bfc9084..2b7b886 100644 >--- a/installer/data/mysql/pl-PL/optional/parameters.sql >+++ b/installer/data/mysql/pl-PL/optional/parameters.sql >@@ -1,6 +1,6 @@ >-INSERT INTO `currency` (currency, rate, symbol) VALUES >-('PLN', 1.0, 'zÅ'), >-('USD', 2.77, '$'), >-('GBP', 4.5, '£'), >-('EUR', 4.1, 'â¬'); >+INSERT INTO `currency` (currency, rate, symbol, active) VALUES >+('PLN', 1.0, 'zÅ', 1), >+('USD', 2.77, '$', 0), >+('GBP', 4.5, '£', 0), >+('EUR', 4.1, 'â¬', 0); > >diff --git a/installer/data/mysql/ru-RU/optional/sample_currency.sql b/installer/data/mysql/ru-RU/optional/sample_currency.sql >index ef32083..87af401 100644 >--- a/installer/data/mysql/ru-RU/optional/sample_currency.sql >+++ b/installer/data/mysql/ru-RU/optional/sample_currency.sql >@@ -1,13 +1,13 @@ > TRUNCATE currency; > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('EUR','â¬','2009-01-23 08:15:20',9.852920); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('EUR','â¬','2009-01-23 08:15:20',9.852920, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GRN','гÑн.','2009-01-28 00:00:00',1.0); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GRN','гÑн.','2009-01-28 00:00:00',1.0, 1); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('RUB','ÑÑб.','2009-01-28 00:00:00',21.166); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('RUB','ÑÑб.','2009-01-28 00:00:00',21.166, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('USD','$','2009-01-23 08:15:20',7.7); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('USD','$','2009-01-23 08:15:20',7.7, 0); >diff --git a/installer/data/mysql/uk-UA/optional/sample_currency.sql b/installer/data/mysql/uk-UA/optional/sample_currency.sql >index ef32083..87af401 100644 >--- a/installer/data/mysql/uk-UA/optional/sample_currency.sql >+++ b/installer/data/mysql/uk-UA/optional/sample_currency.sql >@@ -1,13 +1,13 @@ > TRUNCATE currency; > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('EUR','â¬','2009-01-23 08:15:20',9.852920); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('EUR','â¬','2009-01-23 08:15:20',9.852920, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GRN','гÑн.','2009-01-28 00:00:00',1.0); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GRN','гÑн.','2009-01-28 00:00:00',1.0, 1); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('RUB','ÑÑб.','2009-01-28 00:00:00',21.166); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('RUB','ÑÑб.','2009-01-28 00:00:00',21.166, 0); > >-INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('USD','$','2009-01-23 08:15:20',7.7); >+INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('USD','$','2009-01-23 08:15:20',7.7, 0); >-- >1.7.10.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 11939
:
26339
|
26380
|
26415
|
26439
|
26440
|
26523
|
26524