From 0e04874af7e467eec5b77bb822425a5bc40bd3f8 Mon Sep 17 00:00:00 2001 From: erickson Date: Fri, 11 Sep 2009 13:27:44 +0000 Subject: [PATCH] Patch from Ben Ostrowsky to add some comments to the z39 config table git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@14011 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 926541e07a..050144cc99 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -487,6 +487,21 @@ CREATE TABLE config.z3950_source ( auth BOOL NOT NULL DEFAULT TRUE ); +COMMENT ON TABLE config.z3950_source IS $$ +Z39.50 Sources + +Each row in this table represents a database searchable via Z39.50. +$$; + +COMMENT ON COLUMN config.z3950_source.record_format IS $$ +Z39.50 element set. +$$; + +COMMENT ON COLUMN config.z3950_source.transmission_format IS $$ +Z39.50 preferred record syntax.. +$$; + + CREATE TABLE config.z3950_attr ( id SERIAL PRIMARY KEY, source TEXT NOT NULL REFERENCES config.z3950_source (name) DEFERRABLE INITIALLY DEFERRED, -- 2.11.0