From 065e89a65d793e2bb6484e06f08b9f33854b3b7e Mon Sep 17 00:00:00 2001 From: Mark Tompsett Date: Sat, 25 Jul 2015 04:24:42 -0400 Subject: [PATCH] Bug 4925: Remove Smithsonian as a delivered z39.50 target [3.16.x] Removes the Smithsonian as a target installed with the sample data during installation. Also adds the newer LOC authority targets to files where they were missing. To test: - Verify the Smithsonian has been removed from all translated installers - Verify the files are still valid SQL and install correctly NOTE: There was tiny scope creep which included ensuring there were two Authority z39.50 servers as well. Text files properly reflect the removal. SQL 'source' of SQL files worked properly. Was able to Z39.50 search for all of the 'en'. Signed-off-by: Mark Tompsett Signed-off-by: Jonathan Druart --- installer/data/mysql/de-DE/optional/sample_z3950_servers.sql | 3 +-- installer/data/mysql/de-DE/optional/sample_z3950_servers.txt | 3 ++- installer/data/mysql/en/optional/sample_z3950_servers.sql | 3 +-- installer/data/mysql/en/optional/sample_z3950_servers.txt | 1 - installer/data/mysql/es-ES/optional/sample_z3950_servers.sql | 11 ++++++----- installer/data/mysql/es-ES/optional/sample_z3950_servers.txt | 3 ++- 6 files changed, 12 insertions(+), 12 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 68e28a0..ad74a59 100644 --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/de-DE/optional/sample_z3950_servers.sql @@ -3,5 +3,4 @@ INSERT INTO z3950servers ('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'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'); diff --git a/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt b/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt index 4cba418..a151dd8 100644 --- a/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt +++ b/installer/data/mysql/de-DE/optional/sample_z3950_servers.txt @@ -1,4 +1,5 @@ Vorkonfigurierte Z39.50-Server: LIBRARY OF CONGRESS +LIBRARY OF CONGRESS NAMES (Normsätze) +LIBRARY OF CONGRESS SUBJECTS (Normsätze) COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.sql b/installer/data/mysql/en/optional/sample_z3950_servers.sql index 68e28a0..ad74a59 100644 --- a/installer/data/mysql/en/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/en/optional/sample_z3950_servers.sql @@ -3,5 +3,4 @@ INSERT INTO z3950servers ('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'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); +('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'); diff --git a/installer/data/mysql/en/optional/sample_z3950_servers.txt b/installer/data/mysql/en/optional/sample_z3950_servers.txt index 0adcde2..a0bab98 100644 --- a/installer/data/mysql/en/optional/sample_z3950_servers.txt +++ b/installer/data/mysql/en/optional/sample_z3950_servers.txt @@ -2,4 +2,3 @@ LIBRARY OF CONGRESS LIBRARY OF CONGRESS NAMES (authority records) LIBRARY OF CONGRESS SUBJECTS (authority records) COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES 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 472d8eb..6ae994b 100644 --- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql +++ b/installer/data/mysql/es-ES/optional/sample_z3950_servers.sql @@ -1,5 +1,6 @@ -INSERT INTO `z3950servers` -(`host`, `port`, `db`, `userid`, `password`, `name`, `id`, `checked`, `rank`, `syntax`, `encoding`) VALUES -('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,1,'USMARC','utf8'), -('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',6,0,0,'USMARC','MARC-8'), -('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',10,0,0,'USMARC','MARC-8'); +INSERT INTO z3950servers +(host, port, db, userid, password, name, 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'); diff --git a/installer/data/mysql/es-ES/optional/sample_z3950_servers.txt b/installer/data/mysql/es-ES/optional/sample_z3950_servers.txt index 89d7250..ab5499c 100644 --- a/installer/data/mysql/es-ES/optional/sample_z3950_servers.txt +++ b/installer/data/mysql/es-ES/optional/sample_z3950_servers.txt @@ -1,3 +1,4 @@ LIBRARY OF CONGRESS +LIBRARY OF CONGRESS NAMES +LIBRARY OF CONGRESS SUBJECTS COLUMBIA UNIVERSITY -SMITHSONIAN INSTITUTION LIBRARIES -- 2.1.4