From 785b981a1fce480ff9de45a0b4dd29acaa655823 Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 13 Feb 2006 23:21:42 +0000 Subject: [PATCH] adding lit_form_map git-svn-id: svn://svn.open-ils.org/ILS/trunk@3060 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 7657a4a0b8..a03ef8044c 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -447,6 +447,28 @@ INSERT INTO config.net_access_level (name) VALUES ('Restricted'); INSERT INTO config.net_access_level (name) VALUES ('Full'); INSERT INTO config.net_access_level (name) VALUES ('None'); +CREATE TABLE config.lit_form_map ( + code "char" PRIMARY KEY, + value TEXT NOT NULL, + description TEXT +); + +COPY config.lit_form_map FROM STDIN; +0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired +1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired +c Comic strips \N +d Dramas \N +e Essays \N +f Novels \N +h Humor, satires, etc. The item is a humorous work, satire or of similar literary form. +i Letters The item is a single letter or collection of correspondence. +j Short stories The item is a short story or collection of short stories. +m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories). +p Poetry The item is a poem or collection of poems. +s Speeches The item is a speech or collection of speeches. +u Unknown The literary form of the item is unknown. +\. + CREATE TABLE config.language_map ( code TEXT PRIMARY KEY, value TEXT NOT NULL -- 2.43.2