From 92f21b53996015778b4b2f3c05734731e4790161 Mon Sep 17 00:00:00 2001 From: miker Date: Thu, 25 Sep 2008 21:08:01 +0000 Subject: [PATCH] adding columns needed for some z servers git-svn-id: svn://svn.open-ils.org/ILS/branches/acq-experiment@10703 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 85f646eba8..4f7676de12 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -445,12 +445,14 @@ CREATE TABLE config.bib_level_map ( ); 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 + name TEXT PRIMARY KEY, + label TEXT NOT NULL UNIQUE, + host TEXT NOT NULL, + port INT NOT NULL, + db TEXT NOT NULL, + record_format TEXT NOT NULL DEFAULT 'FI', + transmission_format TEXT NOT NULL DEFAULT 'usmarc', + 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); -- 2.11.0