From b4e01825c6a9a949bb0a7fc2ca95e863a7877004 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Thu, 12 Mar 2020 10:01:10 +0100
Subject: [PATCH] Bug 24856: Remove itemtypes.imageurl in fr-FR sample data

in installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql and installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql the values of imageurl point to non-existent images.

Test plan:
Insert the 2 sql file and confirm that imageurl is not empty

Signed-off-by: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
I confirm that imageurl IS empty
No errors
---
 .../fr-FR/3-LecturePub/sample_itemtypes.sql   | 24 +++++++++----------
 .../fr-FR/4-Conservation/sample_itemtypes.sql | 18 +++++++-------
 2 files changed, 21 insertions(+), 21 deletions(-)

diff --git a/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql b/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql
index 775daf5ebd..ca0ed1df31 100644
--- a/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql
+++ b/installer/data/mysql/fr-FR/3-LecturePub/sample_itemtypes.sql
@@ -4,15 +4,15 @@
 -- 
 SET NAMES utf8;
 
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 0.0000, 0, 'Fiction.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 0.0000, 0, 'MZ.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 0.0000, 0, 'Rare Book.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, 'SIRS.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0.0000, 1, 'Reference.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 1, 'PF.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 0.0000, 0, 'Music CD.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 0.0000, 0, 'CD-ROM software.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 0.0000, 0, 'DVD.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0.0000, 1, 'WEB.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 0.0000, 0, 'Fiction, large print.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 0.0000, 0, 'AVNF.gif', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0.0000, 1, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 1, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0.0000, 1, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 0.0000, 0, '', '');
diff --git a/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql b/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql
index 9aa49fc86f..977d2a2f99 100644
--- a/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql
+++ b/installer/data/mysql/fr-FR/4-Conservation/sample_itemtypes.sql
@@ -2,12 +2,12 @@
 -- Contenu de la table `itemtypes`
 -- 
 SET NAMES utf8;
-INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 0, 'Pamphlet.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MEM', 'Mémoire', 0.0000, 0, 'Faculty Course Materials.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MICR', 'Microfiche', 0.0000, 0, 'Microfiche.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONA', 'Livre ancien', 0.0000, 0, 'Rare Book.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONO', ' Livre', 0.0000, 0, 'Fiction.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MULT', 'Multimédia (K7, DVD...)', 0.0000, 0, 'Microfilm.gif', '');
-INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, 'SIRS.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('THE', 'Thèse ancienne', 0.0000, 0, 'Rare Book.gif', '');
-INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('TU', 'Travail Universitaire', 0.0000, 0, 'Faculty Course Materials.gif', '');
+INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MEM', 'Mémoire', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MICR', 'Microfiche', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONA', 'Livre ancien', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MONO', ' Livre', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('MULT', 'Multimédia (K7, DVD...)', 0.0000, 0, '', '');
+INSERT IGNORE INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('THE', 'Thèse ancienne', 0.0000, 0, '', '');
+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('TU', 'Travail Universitaire', 0.0000, 0, '', '');
-- 
2.17.1