From 6c31a368029a52aefd72b4e220cba43033c0f88a Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 19 Dec 2007 23:23:22 +0000 Subject: [PATCH] adding in-db z sources git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@8239 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 68 +++++++++++++++++++++++-------- Open-ILS/src/sql/Pg/002.schema.config.sql | 43 +++++++++++++++++++ 2 files changed, 93 insertions(+), 18 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index c05215c3ef..bd4308f55b 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -118,6 +118,38 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -2241,11 +2273,11 @@ - + - + @@ -2257,13 +2289,13 @@ - + - + - + @@ -2273,13 +2305,13 @@ - + - + - + @@ -2289,13 +2321,13 @@ - + - + - + @@ -2304,13 +2336,13 @@ - + - + - + @@ -2319,11 +2351,11 @@ - + - + @@ -2333,11 +2365,11 @@ - + - + diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index e840715910..7d7f9af5b4 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -429,5 +429,48 @@ CREATE TABLE config.item_type_map ( value TEXT NOT NULL ); +CREATE TABLE config.z3950_source ( + name TEXT PRIMARY KEY, + label TEXT NOT NULL UNIQUE, + host TEXT NOT NULL, + port INT NOT NULL, + db TEXT NOT NULL, + 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), + name TEXT NOT NULL, + label TEXT NOT NULL, + code INT NOT NULL, + format INT NOT NULL, + 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); + + COMMIT; -- 2.11.0