From 04a3a00ef891a088acee88d10ab6fb9a8bba587f Mon Sep 17 00:00:00 2001
From: Bernardo Gonzalez Kriegel <bgkriegel@gmail.com>
Date: Wed, 5 Feb 2020 09:39:52 -0300
Subject: [PATCH] Bug 24584: Rewrite optional/sample_itemtypes to YAML

YAML version of optional sample_itemtypes

To test:
1) Same test plan of first patch, only check table
   itemtypes

Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 .../mysql/en/optional/sample_itemtypes.sql    |  9 --
 .../mysql/en/optional/sample_itemtypes.txt    |  1 -
 .../mysql/en/optional/sample_itemtypes.yml    | 83 +++++++++++++++++++
 3 files changed, 83 insertions(+), 10 deletions(-)
 delete mode 100644 installer/data/mysql/en/optional/sample_itemtypes.sql
 delete mode 100644 installer/data/mysql/en/optional/sample_itemtypes.txt
 create mode 100644 installer/data/mysql/en/optional/sample_itemtypes.yml

diff --git a/installer/data/mysql/en/optional/sample_itemtypes.sql b/installer/data/mysql/en/optional/sample_itemtypes.sql
deleted file mode 100644
index ab887b215e..0000000000
--- a/installer/data/mysql/en/optional/sample_itemtypes.sql
+++ /dev/null
@@ -1,9 +0,0 @@
-INSERT INTO itemtypes (itemtype, description, rentalcharge, notforloan, imageurl, summary) VALUES
-('BK', 'Books',0,0,'bridge/book.gif',''),
-('MX', 'Mixed Materials',5,0,'bridge/kit.gif',''),
-('CF', 'Computer Files',5,0,'bridge/computer_file.gif',''),
-('MP', 'Maps',5,0,'bridge/map.gif',''),
-('VM', 'Visual Materials',5,1,'bridge/dvd.gif',''),
-('MU', 'Music',5,0,'bridge/sound.gif',''),
-('CR', 'Continuing Resources',5,0,'bridge/periodical.gif',''),
-('REF', 'Reference',0,1,'bridge/reference.gif','');
diff --git a/installer/data/mysql/en/optional/sample_itemtypes.txt b/installer/data/mysql/en/optional/sample_itemtypes.txt
deleted file mode 100644
index 1af4c51b93..0000000000
--- a/installer/data/mysql/en/optional/sample_itemtypes.txt
+++ /dev/null
@@ -1 +0,0 @@
-A set of default item types.
diff --git a/installer/data/mysql/en/optional/sample_itemtypes.yml b/installer/data/mysql/en/optional/sample_itemtypes.yml
new file mode 100644
index 0000000000..d56152b193
--- /dev/null
+++ b/installer/data/mysql/en/optional/sample_itemtypes.yml
@@ -0,0 +1,83 @@
+---
+#
+#  Copyright 2020 Koha Development Team
+#
+#  This file is part of Koha.
+#
+#  Koha is free software; you can redistribute it and/or modify it under the
+#  terms of the GNU General Public License as published by the Free Software
+#  Foundation; either version 2 of the License, or (at your option) any later
+#  version.
+#
+#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
+#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
+#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
+#
+#  You should have received a copy of the GNU General Public License along
+#  with Koha; if not, write to the Free Software Foundation, Inc.,
+#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+#
+
+description:
+  - "A set of default item types."
+
+tables:
+  - itemtypes:
+      translatable: [ description ]
+      multiline: []
+      rows:
+        - itemtype: BK
+          description: "Books"
+          rentalcharge: 0
+          notforloan: 0
+          imageurl: "bridge/book.gif"
+          summary: ""
+
+        - itemtype: MX
+          description: "Mixed Materials"
+          rentalcharge: 5
+          notforloan: 0
+          imageurl: "bridge/kit.gif"
+          summary: ""
+
+        - itemtype: CF
+          description: "Computer Files"
+          rentalcharge: 5
+          notforloan: 0
+          imageurl: "bridge/computer_file.gif"
+          summary: ""
+
+        - itemtype: MP
+          description: "Maps"
+          rentalcharge: 5
+          notforloan: 0
+          imageurl: "bridge/map.gif"
+          summary: ""
+
+        - itemtype: VM
+          description: "Visual Materials"
+          rentalcharge: 5
+          notforloan: 1
+          imageurl: "bridge/dvd.gif"
+          summary: ""
+
+        - itemtype: MU
+          description: "Music"
+          rentalcharge: 5
+          notforloan: 0
+          imageurl: "bridge/sound.gif"
+          summary: ""
+
+        - itemtype: CR
+          description: "Continuing Resources"
+          rentalcharge: 5
+          notforloan: 0
+          imageurl: "bridge/periodical.gif"
+          summary: ""
+
+        - itemtype: REF
+          description: "Reference"
+          rentalcharge: 0
+          notforloan: 1
+          imageurl: "bridge/reference.gif"
+          summary: ""
-- 
2.20.1