@@ -, +, @@ --------- use kohadata; SET FOREIGN_KEY_CHECKS=0; TRUNCATE currency; source /home/mtompset/kohaclone/installer/data/mysql/ru-RU/optional/sample_currency.sql SET FOREIGN_KEY_CHECKS=0; TRUNCATE currency; source /home/mtompset/kohaclone/installer/data/mysql/uk-UA/optional/sample_currency.sql SET FOREIGN_KEY_CHECKS=0; TRUNCATE currency; source /home/mtompset/kohaclone/installer/data/mysql/it-IT/necessari/parameters.sql SET FOREIGN_KEY_CHECKS=1; QUIT -- These should all work without problem. --- .../data/mysql/it-IT/necessari/parameters.sql | 4 ---- .../data/mysql/ru-RU/optional/sample_currency.sql | 2 -- .../data/mysql/uk-UA/optional/sample_currency.sql | 2 -- 3 files changed, 0 insertions(+), 8 deletions(-) --- a/installer/data/mysql/it-IT/necessari/parameters.sql +++ a/installer/data/mysql/it-IT/necessari/parameters.sql @@ -1,8 +1,4 @@ -SET FOREIGN_KEY_CHECKS=0; - INSERT INTO `currency` (currency, rate, symbol, active) VALUES ('USD', 1.4, '$', 0), ('GBP', .8, '£', 0), ('EUR', 1, '€', 1); - -SET FOREIGN_KEY_CHECKS=1; --- a/installer/data/mysql/ru-RU/optional/sample_currency.sql +++ a/installer/data/mysql/ru-RU/optional/sample_currency.sql @@ -1,5 +1,3 @@ -TRUNCATE currency; - 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`, active) VALUES ('EUR','€','2009-01-23 08:15:20',9.852920, 0); --- a/installer/data/mysql/uk-UA/optional/sample_currency.sql +++ a/installer/data/mysql/uk-UA/optional/sample_currency.sql @@ -1,5 +1,3 @@ -TRUNCATE currency; - 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`, active) VALUES ('EUR','€','2009-01-23 08:15:20',9.852920, 0); --