From 243e58dff03499b325a0b0172a2bf3979d72ed52 Mon Sep 17 00:00:00 2001 From: dbs Date: Sun, 28 Sep 2008 23:15:31 +0000 Subject: [PATCH] i18n-ize the default in-db Z39.50 servers (and fix a missing column value for OCLC along the way) git-svn-id: svn://svn.open-ils.org/ILS/trunk@10721 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 23 ---------- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 46 ++++++++++++++++++++ 2 files changed, 46 insertions(+), 23 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index fbe5b0dc05..01badcc900 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -455,9 +455,6 @@ CREATE TABLE config.z3950_source ( auth BOOL NOT NULL DEFAULT TRUE ); -INSERT INTO config.z3950_source (name,label,host,port,db,auth) VALUES ('loc','Library of Congress','z3950.loc.gov',7090,'Voyager',FALSE); -INSERT INTO config.z3950_source (name,label,host,port,db) VALUES ('oclc','OCLC','zcat.oclc.org',210,'OLUCWorldCat'); - CREATE TABLE config.z3950_attr ( id SERIAL PRIMARY KEY, source TEXT NOT NULL REFERENCES config.z3950_source (name), @@ -469,26 +466,6 @@ CREATE TABLE config.z3950_attr ( CONSTRAINT z_code_format_once_per_source UNIQUE (code,format,source) ); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','tcn','Title Control Number',12,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','isbn','ISBN',7,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','lccn','LCCN',9,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','author','Author',1003,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','title','Title',4,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','issn','ISSN',8,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','publisher','Publisher',1018,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','pubdate','Publication Date',31,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('loc','item_type','Item Type',1001,1); - -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','tcn','Title Control Number',12,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','isbn','ISBN',7,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','lccn','LCCN',9,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','author','Author',1003,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','title','Title',4,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','issn','ISSN',8,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','publisher','Publisher',1018,6); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','pubdate','Publication Date',31,1); -INSERT INTO config.z3950_attr (source,name,label,code,format) VALUES ('oclc','item_type','Item Type',1001,1); - CREATE TABLE config.i18n_locale ( code TEXT PRIMARY KEY, marc_code TEXT NOT NULL REFERENCES config.language_map (code) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index c5b75f87f1..1450058e5d 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -739,6 +739,52 @@ INSERT INTO config.i18n_locale (code,marc_code,name,description) VALUES ('hy-AM', 'arm', oils_i18n_gettext('hy-AM', 'Armenian', 'i18n_l', 'name'), oils_i18n_gettext('hy-AM', 'Armenian', 'i18n_l', 'description')); +-- Z39.50 server attributes + +INSERT INTO config.z3950_source (name, label, host, port, db, auth) + VALUES ('loc', oils_i18n_gettext('loc', 'Library of Congress', 'czs', 'label'), 'z3950.loc.gov', 7090, 'Voyager', FALSE); +INSERT INTO config.z3950_source (name, label, host, port, db, auth) + VALUES ('oclc', oils_i18n_gettext('loc', 'OCLC', 'czs', 'label'), 'zcat.oclc.org', 210, 'OLUCWorldCat', TRUE); + +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (1, 'loc','tcn', oils_i18n_gettext(1, 'Title Control Number', 'cza', 'label'), 12, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (2, 'loc', 'isbn', oils_i18n_gettext(2, 'ISBN', 'cza', 'label'), 7, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (3, 'loc', 'lccn', oils_i18n_gettext(3, 'LCCN', 'cza', 'label'), 9, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (4, 'loc', 'author', oils_i18n_gettext(4, 'Author', 'cza', 'label'), 1003, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (5, 'loc', 'title', oils_i18n_gettext(5, 'Title', 'cza', 'label'), 4, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (6, 'loc', 'issn', oils_i18n_gettext(6, 'ISSN', 'cza', 'label'), 8, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (7, 'loc', 'publisher', oils_i18n_gettext(7, 'Publisher', 'cza', 'label'), 1018, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (8, 'loc', 'pubdate', oils_i18n_gettext(8, 'Publication Date', 'cza', 'label'), 31, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (9, 'loc', 'item_type', oils_i18n_gettext(9, 'Item Type', 'cza', 'label'), 1001, 1); + +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (10, 'oclc', 'tcn', oils_i18n_gettext(10, 'Title Control Number', 'cza', 'label'), 12, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (11, 'oclc', 'isbn', oils_i18n_gettext(11, 'ISBN', 'cza', 'label'), 7, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (12, 'oclc', 'lccn', oils_i18n_gettext(12, 'LCCN', 'cza', 'label'), 9, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (13, 'oclc', 'author', oils_i18n_gettext(13, 'Author', 'cza', 'label'), 1003, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (14, 'oclc', 'title', oils_i18n_gettext(14, 'Title', 'cza', 'label'), 4, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (15, 'oclc', 'issn', oils_i18n_gettext(15, 'ISSN', 'cza', 'label'), 8, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (16, 'oclc', 'publisher', oils_i18n_gettext(16, 'Publisher', 'cza', 'label'), 1018, 6); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (17, 'oclc', 'pubdate', oils_i18n_gettext(17, 'Publication Date', 'cza', 'label'), 31, 1); +INSERT INTO config.z3950_attr (id, source, name, label, code, format) + VALUES (18, 'oclc', 'item_type', oils_i18n_gettext(18, 'Item Type', 'cza', 'label'), 1001, 1); +SELECT SETVAL('config.z3950_attr_id_seq'::TEXT, 100); + --005.schema.actors.sql: -- The PINES levels -- 2.43.2