Bug 12864: Add LOC SRU server to sample z3950servers.sql
[koha.git] / installer / data / mysql / de-DE / optional / sample_z3950_servers.sql
1 INSERT INTO z3950servers
2 (host, port, db, userid, password, servername, checked, rank, syntax, encoding,recordtype) VALUES
3 ('lx2.loc.gov',210,'LCDB','','','LIBRARY OF CONGRESS',1,1,'USMARC','utf8','biblio'),
4 ('lx2.loc.gov',210,'NAF','','','LIBRARY OF CONGRESS NAMES',1,1,'USMARC','utf8','authority'),
5 ('lx2.loc.gov',210,'SAF','','','LIBRARY OF CONGRESS SUBJECTS',1,2,'USMARC','utf8','authority'),
6 ('clio-db.cc.columbia.edu',7090,'voyager','','','COLUMBIA UNIVERSITY',0,0,'USMARC','MARC-8','biblio'),
7 ('siris-libraries.si.edu',210,'Default','','','SMITHSONIAN INSTITUTION LIBRARIES',0,0,'USMARC','MARC-8','biblio'); 
8
9 #Insert SRU server
10 INSERT INTO z3950servers
11 (host, port, db, servername, syntax, encoding, servertype, sru_fields)
12 VALUES
13 ('lx2.loc.gov',210,'LCDB','LIBRARY OF CONGRESS SRU','USMARC','utf8','sru','title=dc.title,isbn=bath.isbn,srchany=cql.anywhere,author=dc.author,issn=bath.issn,subject=dc.subject,stdid=bath.standardIdentifier');