View | Details | Raw Unified | Return to bug 11939
Collapse All | Expand All

(-)a/installer/data/mysql/es-ES/optional/parameters.sql (-5 / +5 lines)
Lines 1-6 Link Here
1
INSERT INTO `currency` (currency, rate, symbol) VALUES
1
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
2
('USD', 1.0, '$'),
2
('USD', 1.0, '$', 0),
3
('GBP', 1.9929, '£'),
3
('GBP', 1.9929, '£', 0),
4
('CAD', 1.02207, '$'),
4
('CAD', 1.02207, '$', 0),
5
('EUR', .874003, '€');
5
('EUR', .874003, '€', 1);
6
6
(-)a/installer/data/mysql/it-IT/necessari/parameters.sql (-4 / +4 lines)
Lines 1-8 Link Here
1
SET FOREIGN_KEY_CHECKS=0;
1
SET FOREIGN_KEY_CHECKS=0;
2
2
3
INSERT INTO `currency` (currency, rate, symbol) VALUES
3
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
4
('USD', 1.4, '$'),
4
('USD', 1.4, '$', 0),
5
('GBP', .8, '£'),
5
('GBP', .8, '£', 0),
6
('EUR', 1, '€');
6
('EUR', 1, '€', 1);
7
7
8
SET FOREIGN_KEY_CHECKS=1;
8
SET FOREIGN_KEY_CHECKS=1;
(-)a/installer/data/mysql/nb-NO/2-Valgfritt/parameters.sql (-5 / +5 lines)
Lines 19-26 Link Here
19
-- with Koha; if not, write to the Free Software Foundation, Inc.,
19
-- with Koha; if not, write to the Free Software Foundation, Inc.,
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
20
-- 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
21
21
22
INSERT INTO `currency` (currency, rate, symbol) VALUES
22
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
23
('USD', 5.6157, '$'),
23
('USD', 5.6157, '$', 0),
24
('NOK', 1.0, '$'),
24
('NOK', 1.0, '$', 1),
25
('GBP', 8.9680, '£'),
25
('GBP', 8.9680, '£', 0),
26
('EUR', 7.8940, '€');
26
('EUR', 7.8940, '€', 0);
(-)a/installer/data/mysql/pl-PL/optional/parameters.sql (-5 / +5 lines)
Lines 1-6 Link Here
1
INSERT INTO `currency` (currency, rate, symbol) VALUES
1
INSERT INTO `currency` (currency, rate, symbol, active) VALUES
2
('PLN', 1.0, 'zł'),
2
('PLN', 1.0, 'zł', 1),
3
('USD', 2.77, '$'),
3
('USD', 2.77, '$', 0),
4
('GBP', 4.5, '£'),
4
('GBP', 4.5, '£', 0),
5
('EUR', 4.1, '€');
5
('EUR', 4.1, '€', 0);
6
6
(-)a/installer/data/mysql/ru-RU/optional/sample_currency.sql (-6 / +6 lines)
Lines 1-13 Link Here
1
TRUNCATE currency;
1
TRUNCATE currency;
2
2
3
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690);
3
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690, 0);
4
4
5
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('EUR','€','2009-01-23 08:15:20',9.852920);
5
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('EUR','€','2009-01-23 08:15:20',9.852920, 0);
6
6
7
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390);
7
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390, 0);
8
8
9
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GRN','грн.','2009-01-28 00:00:00',1.0);
9
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GRN','грн.','2009-01-28 00:00:00',1.0, 1);
10
10
11
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('RUB','руб.','2009-01-28 00:00:00',21.166);
11
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('RUB','руб.','2009-01-28 00:00:00',21.166, 0);
12
12
13
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('USD','$','2009-01-23 08:15:20',7.7);
13
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('USD','$','2009-01-23 08:15:20',7.7, 0);
(-)a/installer/data/mysql/uk-UA/optional/sample_currency.sql (-7 / +6 lines)
Lines 1-13 Link Here
1
TRUNCATE currency;
1
TRUNCATE currency;
2
2
3
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690);
3
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('CAD','$','2009-01-23 08:15:20',6.157690, 0);
4
4
5
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('EUR','€','2009-01-23 08:15:20',9.852920);
5
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('EUR','€','2009-01-23 08:15:20',9.852920, 0);
6
6
7
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390);
7
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GPB','£','2009-01-23 08:15:20',11.317390, 0);
8
8
9
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('GRN','грн.','2009-01-28 00:00:00',1.0);
9
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('GRN','грн.','2009-01-28 00:00:00',1.0, 1);
10
10
11
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('RUB','руб.','2009-01-28 00:00:00',21.166);
11
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('RUB','руб.','2009-01-28 00:00:00',21.166, 0);
12
12
13
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`) VALUES ('USD','$','2009-01-23 08:15:20',7.7);
13
INSERT INTO `currency` (`currency`, `symbol`, `timestamp`, `rate`, active) VALUES ('USD','$','2009-01-23 08:15:20',7.7, 0);
14
- 

Return to bug 11939