From e441dbde675bd2d3382c1b48a2efca8e3b9a59b2 Mon Sep 17 00:00:00 2001
From: Josef Moravec <josef.moravec@gmail.com>
Date: Tue, 8 Aug 2017 15:03:19 +0200
Subject: [PATCH] [SIGNED OFF] Bug 19043: Z39.50 target
 clio-db.cc.columbia.edu:7090 is no longer publicly available

Test plan:
0) Apply the patch
1) Install all affected languages: de-DE, es-ES, fr-CA and pl-PL
2) Remove and recreate Koha database
3) Go through web installer in English and don't forgot to load sample Z39.50 servers
4) Go to Administration -> Z39.50/SRU Servers and confirm the sample
servers are here, but columbia.edu is not here
5) Repeat 2-4 for other languages: de-DE, es-ES, fr-CA and pl-PL

Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
---
 installer/data/mysql/de-DE/optional/sample_z3950_servers.sql   | 3 +--
 installer/data/mysql/en/optional/sample_z3950_servers.sql      | 3 +--
 installer/data/mysql/es-ES/optional/sample_z3950_servers.sql   | 3 +--
 installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql | 1 -
 installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql   | 3 +--
 5 files changed, 4 insertions(+), 9 deletions(-)

diff --git a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql
index b52a939..ae4e9bc 100644
--- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql
+++ b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql
@@ -2,8 +2,7 @@ INSERT INTO z3950servers
 (host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
 ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
 ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
-('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
-('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio');
+('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
 
 #Insert SRU server
 INSERT INTO z3950servers
diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.sql b/installer/data/mysql/en/optional/sample_z3950_servers.sql
index b52a939..ae4e9bc 100644
--- a/installer/data/mysql/en/optional/sample_z3950_servers.sql
+++ b/installer/data/mysql/en/optional/sample_z3950_servers.sql
@@ -2,8 +2,7 @@ INSERT INTO z3950servers
 (host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
 ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
 ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
-('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
-('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio');
+('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
 
 #Insert SRU server
 INSERT INTO z3950servers
diff --git a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql b/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql
index b52a939..ae4e9bc 100644
--- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql
+++ b/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql
@@ -2,8 +2,7 @@ INSERT INTO z3950servers
 (host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
 ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
 ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
-('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
-('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio');
+('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
 
 #Insert SRU server
 INSERT INTO z3950servers
diff --git a/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql b/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql
index 99b002e..bea0a40 100644
--- a/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql
+++ b/installer/data/mysql/fr-CA/facultatif/sample_z3950_servers.sql
@@ -3,7 +3,6 @@ INSERT INTO z3950servers
 ('lx2.loc.gov',210,'LCDB','','','Bibliothèque du congrès',1,1,'USMARC','utf8','biblio'),
 ('lx2.loc.gov',210,'NAF','','','Bibliothèque du congrès NOMS',1,1,'USMARC','utf8','authority'),
 ('lx2.loc.gov',210,'SAF','','','Bibliothèque du congrès SUJETS',1,2,'USMARC','utf8','authority'),
-('clio-db.cc.columbia.edu',7090,'voyager','','','Université Columbia',0,0,'USMARC','MARC-8','biblio'),
 ('amicus.collectionscanada.gc.ca',210,'NL','','','AMICUS',0,0,'USMARC','MARC-8','biblio'),
 ('catalogue.banq.qc.ca',210,'IRIS','','','BANQ',0,1,'USMARC','MARC-8','biblio'),
 ('siris-libraries.si.edu',210,'Default','','','Bibliothèques de l''institution Smithsonian',0,0,'USMARC','MARC-8','biblio');
diff --git a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql b/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql
index d9a188c..a6a2f1a 100644
--- a/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql
+++ b/installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql
@@ -3,8 +3,7 @@ INSERT INTO z3950servers
 ('alpha.bn.org.pl',210,'INNOPAC','','','BIBLIOTEKA NARODOWA',1,1,'MARC21','utf8', 'biblio'),
 ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
 ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
-('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
-('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio');
+('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority');
 
 #Insert SRU server
 INSERT INTO z3950servers
-- 
2.7.4