Bug 11954 - Clean up currency default files
authorMark Tompsett <mtompset@hotmail.com>
Wed, 19 Nov 2014 18:28:12 +0000 (13:28 -0500)
committerTomas Cohen Arazi <tomascohen@gmail.com>
Mon, 9 Feb 2015 18:47:24 +0000 (15:47 -0300)
commit3cf719433597ad6bf558950270cd564a62164ab4
tree72e9bb8c7e81720cacee154572495845ede814b2
parentf31e39246a6a77e8e10ed89c066b1c42481541e4
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 <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
installer/data/mysql/it-IT/necessari/parameters.sql
installer/data/mysql/ru-RU/optional/sample_currency.sql
installer/data/mysql/uk-UA/optional/sample_currency.sql