From d3d4820209ca8a35cf5fcce9595a8d7700ca9da9 Mon Sep 17 00:00:00 2001
From: Kyle M Hall <kyle@bywatersolutions.com>
Date: Thu, 23 Jun 2016 13:24:54 +0000
Subject: [PATCH] Bug 16735: Clean up sample data

Signed-off-by: Josef Moravec <josef.moravec@gmail.com>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 .../mysql/en/optional/sample_libraries.sql    |  2 --
 .../mysql/es-ES/optional/sample_libraries.sql |  4 ----
 .../nb-NO/2-Valgfritt/sample_libraries.sql    |  4 ----
 .../mysql/pl-PL/optional/sample_libraries.sql |  4 ----
 .../mysql/ru-RU/optional/example_branches.sql | 19 -------------------
 5 files changed, 33 deletions(-)

diff --git a/installer/data/mysql/en/optional/sample_libraries.sql b/installer/data/mysql/en/optional/sample_libraries.sql
index cfbe0b158b..234cba5498 100644
--- a/installer/data/mysql/en/optional/sample_libraries.sql
+++ b/installer/data/mysql/en/optional/sample_libraries.sql
@@ -1,5 +1,3 @@
--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
-
 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 
 ('MPL','Midway','372 Forest Street'),
diff --git a/installer/data/mysql/es-ES/optional/sample_libraries.sql b/installer/data/mysql/es-ES/optional/sample_libraries.sql
index a2fa52e8c6..58dc24e249 100644
--- a/installer/data/mysql/es-ES/optional/sample_libraries.sql
+++ b/installer/data/mysql/es-ES/optional/sample_libraries.sql
@@ -1,5 +1,3 @@
--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
-
 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 
 ('MPL','Midway','372 Forest Street'),
@@ -15,5 +13,3 @@ INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 ('LPL','Liberty','East Hills'),
 ('UPL','Union','Chestnut Hollow')
 ;
-
--- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
diff --git a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql
index a2fa52e8c6..58dc24e249 100644
--- a/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql
+++ b/installer/data/mysql/nb-NO/2-Valgfritt/sample_libraries.sql
@@ -1,5 +1,3 @@
--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
-
 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 
 ('MPL','Midway','372 Forest Street'),
@@ -15,5 +13,3 @@ INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 ('LPL','Liberty','East Hills'),
 ('UPL','Union','Chestnut Hollow')
 ;
-
--- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
diff --git a/installer/data/mysql/pl-PL/optional/sample_libraries.sql b/installer/data/mysql/pl-PL/optional/sample_libraries.sql
index a2fa52e8c6..58dc24e249 100644
--- a/installer/data/mysql/pl-PL/optional/sample_libraries.sql
+++ b/installer/data/mysql/pl-PL/optional/sample_libraries.sql
@@ -1,5 +1,3 @@
--- INSERT INTO branchcategories ( `categorycode`,`categoryname`,`codedescription`) VALUES
-
 INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 
 ('MPL','Midway','372 Forest Street'),
@@ -15,5 +13,3 @@ INSERT INTO branches ( `branchcode`,`branchname`,`branchaddress1`) VALUES
 ('LPL','Liberty','East Hills'),
 ('UPL','Union','Chestnut Hollow')
 ;
-
--- INSERT INTO branchrelations ( `branchcode`,`categorycode`) VALUES
diff --git a/installer/data/mysql/ru-RU/optional/example_branches.sql b/installer/data/mysql/ru-RU/optional/example_branches.sql
index d4ec0de816..51d1efe90f 100644
--- a/installer/data/mysql/ru-RU/optional/example_branches.sql
+++ b/installer/data/mysql/ru-RU/optional/example_branches.sql
@@ -1,6 +1,4 @@
 TRUNCATE branches;
-TRUNCATE branchcategories;
-TRUNCATE branchrelations;
 
 INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchaddress2`, `branchaddress3`, `branchphone`, `branchfax`, `branchemail`, `issuing`, `branchip`, `branchprinter`) VALUES
 ('AB',   'Абонемент', 
@@ -19,20 +17,3 @@ INSERT INTO `branches` (`branchcode`, `branchname`, `branchaddress1`, `branchadd
              'Украина', 'м. Тернопіль', 'ул. Руська 56, кабинет 5 (второй корпус)', '8 (0352) 52-53-45', '', 'lib@tu.edu.te.ua', NULL, '', NULL),
 ('NPLU', 'Национальная парламентская библиотека Украины', 
              'Украина', 'г. Киев', 'ул. Грушевского, 1', '38 (044) 278-85-12', '38 (044) 278-85-12', 'office@nplu.org', NULL, '192.168.1.*', NULL);
-
-INSERT INTO `branchcategories` (`categorycode`, `categoryname`, `codedescription`, `categorytype`) VALUES
-('HOME',   'Дом',                        'Может устанавливаться как домашняя библиотека', 'properties'),
-('ISSUE',  'Книговыдача',                'Может выдавать книги',                          'properties'),
-('NATIOS', 'Национальные библиотеки',    'Поисковая область национальных библиотек',      'searchdomain'),
-('PUBLS',  'Публичные библиотеки',       'Поисковая область публичных библиотек',         'searchdomain'),
-('UNIVS',  'Университетские библиотеки', 'Поисковая область университетских библиотек',   'searchdomain');
-
-INSERT INTO `branchrelations` (`branchcode`, `categorycode`) VALUES
-('AB',   'ISSUE'),
-('ABH',  'ISSUE'),
-('LNSL', 'HOME'),
-('LNSL', 'NATIOS'),
-('NPLU', 'HOME'),
-('NPLU', 'NATIOS'),
-('STL',  'HOME'),
-('STL',  'UNIVS');
-- 
2.39.5