From 3cf719433597ad6bf558950270cd564a62164ab4 Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Wed, 19 Nov 2014 13:28:12 -0500 Subject: [PATCH] Bug 11954 - Clean up currency default files It makes no sense to have TRUNCATE or foreign key checks. TEST PLAN --------- 1) Back up your database 2) in an mysql client: 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. Signed-off-by: Marcel de Rooy Signed-off-by: Kyle M Hall Signed-off-by: Tomas Cohen Arazi --- installer/data/mysql/it-IT/necessari/parameters.sql | 4 ---- installer/data/mysql/ru-RU/optional/sample_currency.sql | 2 -- installer/data/mysql/uk-UA/optional/sample_currency.sql | 2 -- 3 files changed, 8 deletions(-) diff --git a/installer/data/mysql/it-IT/necessari/parameters.sql b/installer/data/mysql/it-IT/necessari/parameters.sql index 806bba7c85..6fc7c51833 100644 --- a/installer/data/mysql/it-IT/necessari/parameters.sql +++ b/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; diff --git a/installer/data/mysql/ru-RU/optional/sample_currency.sql b/installer/data/mysql/ru-RU/optional/sample_currency.sql index 87af40157f..6f2eb87491 100644 --- a/installer/data/mysql/ru-RU/optional/sample_currency.sql +++ b/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); diff --git a/installer/data/mysql/uk-UA/optional/sample_currency.sql b/installer/data/mysql/uk-UA/optional/sample_currency.sql index 87af40157f..6f2eb87491 100644 --- a/installer/data/mysql/uk-UA/optional/sample_currency.sql +++ b/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); -- 2.39.2