2 DROP SCHEMA stats CASCADE;
3 DROP SCHEMA config CASCADE;
9 COMMENT ON SCHEMA config IS $$
11 * Copyright (C) 2005 Georgia Public Library Service
12 * Mike Rylander <mrylander@gmail.com>
14 * The config schema holds static configuration data for the
15 * Open-ILS installation.
19 * This program is free software; you can redistribute it and/or
20 * modify it under the terms of the GNU General Public License
21 * as published by the Free Software Foundation; either version 2
22 * of the License, or (at your option) any later version.
24 * This program is distributed in the hope that it will be useful,
25 * but WITHOUT ANY WARRANTY; without even the implied warranty of
26 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
27 * GNU General Public License for more details.
32 CREATE TABLE config.bib_source (
33 id SERIAL PRIMARY KEY,
34 quality INT CHECK ( quality BETWEEN 0 AND 100 ),
35 source TEXT NOT NULL UNIQUE,
36 transcendant BOOL NOT NULL DEFAULT FALSE
38 COMMENT ON TABLE config.bib_source IS $$
40 * Copyright (C) 2005 Georgia Public Library Service
41 * Mike Rylander <mrylander@gmail.com>
43 * Valid sources of MARC records
45 * This is table is used to set up the relative "quality" of each
46 * MARC source, such as OCLC.
50 * This program is free software; you can redistribute it and/or
51 * modify it under the terms of the GNU General Public License
52 * as published by the Free Software Foundation; either version 2
53 * of the License, or (at your option) any later version.
55 * This program is distributed in the hope that it will be useful,
56 * but WITHOUT ANY WARRANTY; without even the implied warranty of
57 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
58 * GNU General Public License for more details.
63 INSERT INTO config.bib_source (quality, source) VALUES (90, 'oclc');
64 INSERT INTO config.bib_source (quality, source) VALUES (10, 'System Local');
65 INSERT INTO config.bib_source (quality, source, transcendant) VALUES (1, 'Project Gutenberg', TRUE);
67 CREATE TABLE config.standing (
68 id SERIAL PRIMARY KEY,
69 value TEXT NOT NULL UNIQUE
71 COMMENT ON TABLE config.standing IS $$
73 * Copyright (C) 2005 Georgia Public Library Service
74 * Mike Rylander <mrylander@gmail.com>
78 * This table contains the values that can be applied to a patron
79 * by a staff member. These values should not be changed, other
80 * that for translation, as the ID column is currently a "magic
81 * number" in the source. :(
85 * This program is free software; you can redistribute it and/or
86 * modify it under the terms of the GNU General Public License
87 * as published by the Free Software Foundation; either version 2
88 * of the License, or (at your option) any later version.
90 * This program is distributed in the hope that it will be useful,
91 * but WITHOUT ANY WARRANTY; without even the implied warranty of
92 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
93 * GNU General Public License for more details.
97 INSERT INTO config.standing (value) VALUES ('Good');
98 INSERT INTO config.standing (value) VALUES ('Barred');
101 CREATE TABLE config.xml_transform (
102 name TEXT PRIMARY KEY,
103 namespace_uri TEXT NOT NULL UNIQUE,
104 prefix TEXT NOT NULL,
107 INSERT INTO config.xml_transform VALUES ( 'marcxml', 'http://www.loc.gov/MARC21/slim', 'marc', '---' );
108 INSERT INTO config.xml_transform VALUES ( 'mods', 'http://www.loc.gov/mods/', 'mods', '/home/miker/MARC21slim2MODS.xsl' );
110 CREATE TABLE config.metabib_field (
111 id SERIAL PRIMARY KEY,
112 field_class TEXT NOT NULL CHECK (lower(field_class) IN ('title','author','subject','keyword','series')),
113 name TEXT NOT NULL UNIQUE,
115 weight INT NOT NULL DEFAULT 1,
116 format TEXT NOT NULL DEFAULT 'mods',
117 search BOOL NOT NULL DEFAULT TRUE,
118 facet BOOL NOT NULL DEFAULT FALSE
120 COMMENT ON TABLE config.metabib_field IS $$
122 * Copyright (C) 2005 Georgia Public Library Service
123 * Mike Rylander <mrylander@gmail.com>
125 * XPath used for WoRMing
127 * This table contains the XPath used to chop up MODS into it's
128 * indexable parts. Each XPath entry is named and assigned to
129 * a "class" of either title, subject, author, keyword or series.
134 * This program is free software; you can redistribute it and/or
135 * modify it under the terms of the GNU General Public License
136 * as published by the Free Software Foundation; either version 2
137 * of the License, or (at your option) any later version.
139 * This program is distributed in the hope that it will be useful,
140 * but WITHOUT ANY WARRANTY; without even the implied warranty of
141 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
142 * GNU General Public License for more details.
147 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ );
148 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abreviated')]$$ );
149 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ );
150 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ );
151 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ );
152 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'corporate', $$//mods:mods/mods:name[@type='corporate']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ );
153 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'personal', $$//mods:mods/mods:name[@type='personal']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ );
154 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'conference', $$//mods:mods/mods:name[@type='conference']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ );
155 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ );
156 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ );
157 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ );
158 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ );
159 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ );
160 -- INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ );
161 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */
165 CREATE OR REPLACE FUNCTION oils_xml_transform ( TEXT, TEXT ) RETURNS TEXT AS $_$
166 SELECT CASE WHEN (SELECT COUNT(*) FROM config.xml_transform WHERE name = $2 AND xslt = '---') > 0 THEN $1
167 ELSE xslt_process($1, (SELECT xslt FROM config.xml_transform WHERE name = $2))
169 $_$ LANGUAGE SQL STRICT IMMUTABLE;
173 CREATE TYPE biblio_field_vtype AS ( record BIGINT, field INT, content TEXT );
174 CREATE OR REPLACE FUNCTION biblio_field_table ( record BIGINT, field_list INT[] ) RETURNS SETOF biblio_field_vtype AS $_$
177 rec biblio_field_vtype%ROWTYPE;
179 FOR i IN ARRAY_LOWER(field_list,1) .. ARRAY_UPPER(field_list,1) LOOP
180 FOR rec IN SELECT DISTINCT r, field_list[i], BTRIM(REGEXP_REPLACE(REGEXP_REPLACE(f, E'\n', ' ', 'g'), '[ ]+', ' ', 'g'))
183 $$oils_xml_transform(marc,'$$ || (SELECT format FROM config.metabib_field WHERE id = field_list[i]) || $$')$$,
184 'biblio.record_entry',
185 (SELECT xpath FROM config.metabib_field WHERE id = field_list[i]),
187 (SELECT x.prefix FROM config.xml_transform x JOIN config.metabib_field m ON (m.format = x.name) WHERE m.id = field_list[i]),
188 (SELECT x.namespace_uri FROM config.xml_transform x JOIN config.metabib_field m ON (m.format = x.name) WHERE m.id = field_list[i])
189 ) AS t( r bigint, f text)
190 WHERE f IS NOT NULL LOOP
195 $_$ LANGUAGE PLPGSQL;
199 CREATE OR REPLACE FUNCTION biblio_field_table ( record BIGINT, field INT ) RETURNS SETOF biblio_field_vtype AS $_$
200 SELECT * FROM biblio_field_table( $1, ARRAY[$2] )
205 CREATE TABLE config.non_cataloged_type (
206 id SERIAL PRIMARY KEY,
207 owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id),
209 circ_duration INTERVAL NOT NULL DEFAULT '14 days'::INTERVAL,
210 in_house BOOL NOT NULL DEFAULT FALSE,
211 CONSTRAINT noncat_once_per_lib UNIQUE (owning_lib,name)
213 COMMENT ON TABLE config.non_cataloged_type IS $$
215 * Copyright (C) 2005 Georgia Public Library Service
216 * Mike Rylander <mrylander@gmail.com>
218 * Types of valid non-cataloged items.
223 * This program is free software; you can redistribute it and/or
224 * modify it under the terms of the GNU General Public License
225 * as published by the Free Software Foundation; either version 2
226 * of the License, or (at your option) any later version.
228 * This program is distributed in the hope that it will be useful,
229 * but WITHOUT ANY WARRANTY; without even the implied warranty of
230 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
231 * GNU General Public License for more details.
236 INSERT INTO config.non_cataloged_type ( owning_lib, name ) VALUES ( 1, 'Paperback Book' );
238 CREATE TABLE config.identification_type (
239 id SERIAL PRIMARY KEY,
240 name TEXT NOT NULL UNIQUE
242 COMMENT ON TABLE config.identification_type IS $$
244 * Copyright (C) 2005 Georgia Public Library Service
245 * Mike Rylander <mrylander@gmail.com>
247 * Types of valid patron identification.
249 * Each patron must display at least one valid form of identification
250 * in order to get a library card. This table lists those forms.
255 * This program is free software; you can redistribute it and/or
256 * modify it under the terms of the GNU General Public License
257 * as published by the Free Software Foundation; either version 2
258 * of the License, or (at your option) any later version.
260 * This program is distributed in the hope that it will be useful,
261 * but WITHOUT ANY WARRANTY; without even the implied warranty of
262 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
263 * GNU General Public License for more details.
268 INSERT INTO config.identification_type ( name ) VALUES ( 'Drivers License' );
269 INSERT INTO config.identification_type ( name ) VALUES ( 'SSN' );
270 INSERT INTO config.identification_type ( name ) VALUES ( 'Other' );
272 CREATE TABLE config.rule_circ_duration (
273 id SERIAL PRIMARY KEY,
274 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
275 extended INTERVAL NOT NULL,
276 normal INTERVAL NOT NULL,
277 shrt INTERVAL NOT NULL,
278 max_renewals INT NOT NULL
280 COMMENT ON TABLE config.rule_circ_duration IS $$
282 * Copyright (C) 2005 Georgia Public Library Service
283 * Mike Rylander <mrylander@gmail.com>
285 * Circulation Duration rules
287 * Each circulation is given a duration based on one of these rules.
292 * This program is free software; you can redistribute it and/or
293 * modify it under the terms of the GNU General Public License
294 * as published by the Free Software Foundation; either version 2
295 * of the License, or (at your option) any later version.
297 * This program is distributed in the hope that it will be useful,
298 * but WITHOUT ANY WARRANTY; without even the implied warranty of
299 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
300 * GNU General Public License for more details.
304 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_0_renew', '7 days', '7 days', '7 days', 0);
305 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_2_renew', '28 days', '28 days', '28 days', 2);
306 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_months_0_renew', '3 mons', '3 mons', '3 mons', 0);
307 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_days_1_renew', '3 days', '3 days', '3 days', 1);
308 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '2_months_2_renew', '2 mons', '2 mons', '2 mons', 2);
309 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '35_days_1_renew', '35 days', '35 days', '35 days', 1);
310 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_2_renew', '7 days', '7 days', '7 days', 2);
311 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '1_hour_2_renew', '1 hour', '1 hour', '1 hour', 2);
312 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_0_renew', '28 days', '28 days', '28 days', 0);
313 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '14_days_2_renew', '14 days', '14 days', '14 days', 2);
316 CREATE TABLE config.rule_max_fine (
317 id SERIAL PRIMARY KEY,
318 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
319 amount NUMERIC(6,2) NOT NULL
321 COMMENT ON TABLE config.rule_max_fine IS $$
323 * Copyright (C) 2005 Georgia Public Library Service
324 * Mike Rylander <mrylander@gmail.com>
326 * Circulation Max Fine rules
328 * Each circulation is given a maximum fine based on one of
334 * This program is free software; you can redistribute it and/or
335 * modify it under the terms of the GNU General Public License
336 * as published by the Free Software Foundation; either version 2
337 * of the License, or (at your option) any later version.
339 * This program is distributed in the hope that it will be useful,
340 * but WITHOUT ANY WARRANTY; without even the implied warranty of
341 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
342 * GNU General Public License for more details.
346 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00);
347 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00);
348 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00);
349 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_min', 25.00);
350 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_mid', 25.00);
351 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_max', 100.00);
354 CREATE TABLE config.rule_recuring_fine (
355 id SERIAL PRIMARY KEY,
356 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
357 high NUMERIC(6,2) NOT NULL,
358 normal NUMERIC(6,2) NOT NULL,
359 low NUMERIC(6,2) NOT NULL,
360 recurance_interval INTERVAL NOT NULL DEFAULT '1 day'::INTERVAL
362 COMMENT ON TABLE config.rule_recuring_fine IS $$
364 * Copyright (C) 2005 Georgia Public Library Service
365 * Mike Rylander <mrylander@gmail.com>
367 * Circulation Recuring Fine rules
369 * Each circulation is given a recuring fine amount based on one of
370 * these rules. The recurance_interval should not be any shorter
371 * than the interval between runs of the fine_processor.pl script
372 * (which is run from CRON), or you could miss fines.
377 * This program is free software; you can redistribute it and/or
378 * modify it under the terms of the GNU General Public License
379 * as published by the Free Software Foundation; either version 2
380 * of the License, or (at your option) any later version.
382 * This program is distributed in the hope that it will be useful,
383 * but WITHOUT ANY WARRANTY; without even the implied warranty of
384 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
385 * GNU General Public License for more details.
389 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day');
390 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day');
393 CREATE TABLE config.rule_age_hold_protect (
394 id SERIAL PRIMARY KEY,
395 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
396 age INTERVAL NOT NULL,
399 COMMENT ON TABLE config.rule_age_hold_protect IS $$
401 * Copyright (C) 2005 Georgia Public Library Service
402 * Mike Rylander <mrylander@gmail.com>
404 * Hold Item Age Protection rules
406 * A hold request can only capture new(ish) items when they are
407 * within a particular proximity of the home_ou of the requesting
408 * user. The proximity ('prox' column) is calculated by counting
409 * the number of tree edges beween the user's home_ou and the owning_lib
410 * of the copy that could fulfill the hold.
415 * This program is free software; you can redistribute it and/or
416 * modify it under the terms of the GNU General Public License
417 * as published by the Free Software Foundation; either version 2
418 * of the License, or (at your option) any later version.
420 * This program is distributed in the hope that it will be useful,
421 * but WITHOUT ANY WARRANTY; without even the implied warranty of
422 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
423 * GNU General Public License for more details.
427 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '3month', '3 mons', 0);
428 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '6month', '6 mons', 2);
431 CREATE TABLE config.copy_status (
432 id SERIAL PRIMARY KEY,
433 name TEXT NOT NULL UNIQUE,
434 holdable BOOL NOT NULL DEFAULT FALSE
436 COMMENT ON TABLE config.copy_status IS $$
438 * Copyright (C) 2005 Georgia Public Library Service
439 * Mike Rylander <mrylander@gmail.com>
443 * The available copy statuses, and whether a copy in that
444 * status is available for hold request capture. 0 (zero) is
445 * the only special number in this set, meaning that the item
446 * is available for imediate checkout, and is counted as available
449 * Statuses with an ID below 100 are not removable, and have special
450 * meaning in the code. Do not change them except to translate the
453 * You may add and remove statuses above 100, and these can be used
454 * to remove items from normal circulation without affecting the rest
455 * of the copy's values or it's location.
459 * This program is free software; you can redistribute it and/or
460 * modify it under the terms of the GNU General Public License
461 * as published by the Free Software Foundation; either version 2
462 * of the License, or (at your option) any later version.
464 * This program is distributed in the hope that it will be useful,
465 * but WITHOUT ANY WARRANTY; without even the implied warranty of
466 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
467 * GNU General Public License for more details.
471 INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t');
472 INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t');
473 INSERT INTO config.copy_status (name) VALUES ('Bindery');
474 INSERT INTO config.copy_status (name) VALUES ('Lost');
475 INSERT INTO config.copy_status (name) VALUES ('Missing');
476 INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t');
477 INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t');
478 INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t');
479 INSERT INTO config.copy_status (name,holdable) VALUES ('On holds shelf','t');
480 INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t');
481 INSERT INTO config.copy_status (name) VALUES ('ILL');
482 INSERT INTO config.copy_status (name) VALUES ('Cataloging');
483 INSERT INTO config.copy_status (name) VALUES ('Reserves');
484 INSERT INTO config.copy_status (name) VALUES ('Discard/Weed');
485 INSERT INTO config.copy_status (name) VALUES ('Damaged');
487 SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100);
490 CREATE TABLE config.net_access_level (
491 id SERIAL PRIMARY KEY,
492 name TEXT NOT NULL UNIQUE
494 COMMENT ON TABLE config.net_access_level IS $$
496 * Copyright (C) 2005 Georgia Public Library Service
497 * Mike Rylander <mrylander@gmail.com>
499 * Patron Network Access level
501 * This will be used to inform the in-library firewall of how much
502 * internet access the using patron should be allowed.
506 * This program is free software; you can redistribute it and/or
507 * modify it under the terms of the GNU General Public License
508 * as published by the Free Software Foundation; either version 2
509 * of the License, or (at your option) any later version.
511 * This program is distributed in the hope that it will be useful,
512 * but WITHOUT ANY WARRANTY; without even the implied warranty of
513 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
514 * GNU General Public License for more details.
518 INSERT INTO config.net_access_level (name) VALUES ('Filtered');
519 INSERT INTO config.net_access_level (name) VALUES ('Unfiltered');
520 INSERT INTO config.net_access_level (name) VALUES ('No Access');
522 CREATE TABLE config.audience_map (
523 code TEXT PRIMARY KEY,
528 COPY config.audience_map FROM STDIN;
529 Unknown or unspecified The target audience for the item not known or not specified.
530 a Preschool The item is intended for children, approximate ages 0-5 years.
531 b Primary The item is intended for children, approximate ages 6-8 years.
532 c Pre-adolescent The item is intended for young people, approximate ages 9-13 years.
533 d Adolescent The item is intended for young people, approximate ages 14-17 years.
534 e Adult The item is intended for adults.
535 f Specialized The item is aimed at a particular audience and the nature of the presentation makes the item of little interest to another audience.
536 g General The item is of general interest and not aimed at an audience of a particular intellectual level.
537 j Juvenile The item is intended for children and young people, approximate ages 0-15 years.
541 CREATE TABLE config.lit_form_map (
542 code TEXT PRIMARY KEY,
547 COPY config.lit_form_map FROM STDIN;
548 0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired
549 1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired
554 h Humor, satires, etc. The item is a humorous work, satire or of similar literary form.
555 i Letters The item is a single letter or collection of correspondence.
556 j Short stories The item is a short story or collection of short stories.
557 m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories).
558 p Poetry The item is a poem or collection of poems.
559 s Speeches The item is a speech or collection of speeches.
560 u Unknown The literary form of the item is unknown.
563 CREATE TABLE config.language_map (
564 code TEXT PRIMARY KEY,
568 COPY config.language_map FROM STDIN;
575 afa Afroasiatic (Other)
576 afh Afrihili (Artificial language)
583 alg Algonquian (Other)
585 ang English, Old (ca. 450-1100)
589 arg Aragonese Spanish
593 art Artificial (Other)
597 ath Athapascan (Other)
598 aus Australian languages
605 bai Bamileke languages
634 cai Central American Indian (Other)
638 cau Caucasian (Other)
659 cpe Creoles and Pidgins, English-based (Other)
660 cpf Creoles and Pidgins, French-based (Other)
661 cpp Creoles and Pidgins, Portuguese-based (Other)
664 crp Creoles and Pidgins (Other)
677 dra Dravidian (Other)
679 dum Dutch, Middle (ca. 1050-1350)
688 enm English, Middle (1100-1500)
690 -esk Eskimo languages
702 fiu Finno-Ugrian (Other)
706 frm French, Middle (ca. 1400-1600)
707 fro French, Old (ca. 842-1400)
726 gmh German, Middle High (ca. 1050-1500)
727 goh German, Old High (ca. 750-1050)
732 grc Greek, Ancient (to 1453)
733 gre Greek, Modern (1453- )
739 hat Haitian French Creole
761 ina Interlingua (International Auxiliary Language Association)
764 ine Indo-European (Other)
766 -int Interlingua (International Auxiliary Language Association)
770 iro Iroquoian (Other)
812 -lan Occitan (post-1500)
829 luo Luo (Kenya and Tanzania)
840 map Austronesian (Other)
847 mga Irish, Middle (ca. 1100-1550)
850 mis Miscellaneous languages
851 mkh Mon-Khmer (Other)
862 mul Multiple languages
868 nai North American Indian (Other)
869 nap Neapolitan Italian
872 nbl Ndebele (South Africa)
873 nde Ndebele (Zimbabwe)
879 nic Niger-Kordofanian (Other)
881 nno Norwegian (Nynorsk)
882 nob Norwegian (Bokmål)
893 oci Occitan (post-1500)
900 oto Otomian languages
908 peo Old Persian (ca. 600-400 B.C.)
910 phi Philippine (Other)
916 pra Prakrit languages
917 pro Provençal (to 1500)
930 sag Sango (Ubangi Creole)
932 sai South American Indian (Other)
933 sal Salishan languages
934 sam Samaritan Aramaic
944 sga Irish, Old (to 1100)
951 sit Sino-Tibetan (Other)
973 ssa Nilo-Saharan (Other)
1034 wak Wakashan languages
1039 wen Sorbian languages
1057 CREATE TABLE config.item_form_map (
1058 code TEXT PRIMARY KEY,
1062 COPY config.item_form_map FROM STDIN;
1068 r Regular print reproduction
1072 CREATE TABLE config.item_type_map (
1073 code TEXT PRIMARY KEY,
1077 COPY config.item_type_map FROM STDIN;
1079 t Manuscript language material
1081 k Two-dimensional nonprojectable graphic
1082 r Three-dimensional artifact or naturally occurring object
1085 e Cartographic material
1086 f Manuscript cartographic material
1088 d Manuscript notated music
1089 i Nonmusical sound recording
1090 j Musical sound recording