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')),
115 weight INT NOT NULL DEFAULT 1,
116 format TEXT NOT NULL DEFAULT 'mods',
117 search_field BOOL NOT NULL DEFAULT TRUE,
118 facet_field 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 record indexing ingest
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.
146 CREATE UNIQUE INDEX config_metabib_field_class_name_idx ON config.metabib_field (field_class, name);
149 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ );
150 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abreviated')]$$ );
151 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ );
152 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ );
153 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ );
154 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']]$$ );
155 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']]$$ );
156 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']]$$ );
157 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ );
158 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ );
159 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ );
160 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ );
161 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ );
162 -- INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ );
163 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */
165 CREATE TABLE config.non_cataloged_type (
166 id SERIAL PRIMARY KEY,
167 owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id),
169 circ_duration INTERVAL NOT NULL DEFAULT '14 days'::INTERVAL,
170 in_house BOOL NOT NULL DEFAULT FALSE,
171 CONSTRAINT noncat_once_per_lib UNIQUE (owning_lib,name)
173 COMMENT ON TABLE config.non_cataloged_type IS $$
175 * Copyright (C) 2005 Georgia Public Library Service
176 * Mike Rylander <mrylander@gmail.com>
178 * Types of valid non-cataloged items.
183 * This program is free software; you can redistribute it and/or
184 * modify it under the terms of the GNU General Public License
185 * as published by the Free Software Foundation; either version 2
186 * of the License, or (at your option) any later version.
188 * This program is distributed in the hope that it will be useful,
189 * but WITHOUT ANY WARRANTY; without even the implied warranty of
190 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
191 * GNU General Public License for more details.
196 INSERT INTO config.non_cataloged_type ( owning_lib, name ) VALUES ( 1, 'Paperback Book' );
198 CREATE TABLE config.identification_type (
199 id SERIAL PRIMARY KEY,
200 name TEXT NOT NULL UNIQUE
202 COMMENT ON TABLE config.identification_type IS $$
204 * Copyright (C) 2005 Georgia Public Library Service
205 * Mike Rylander <mrylander@gmail.com>
207 * Types of valid patron identification.
209 * Each patron must display at least one valid form of identification
210 * in order to get a library card. This table lists those forms.
215 * This program is free software; you can redistribute it and/or
216 * modify it under the terms of the GNU General Public License
217 * as published by the Free Software Foundation; either version 2
218 * of the License, or (at your option) any later version.
220 * This program is distributed in the hope that it will be useful,
221 * but WITHOUT ANY WARRANTY; without even the implied warranty of
222 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
223 * GNU General Public License for more details.
228 INSERT INTO config.identification_type ( name ) VALUES ( 'Drivers License' );
229 INSERT INTO config.identification_type ( name ) VALUES ( 'SSN' );
230 INSERT INTO config.identification_type ( name ) VALUES ( 'Other' );
232 CREATE TABLE config.rule_circ_duration (
233 id SERIAL PRIMARY KEY,
234 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
235 extended INTERVAL NOT NULL,
236 normal INTERVAL NOT NULL,
237 shrt INTERVAL NOT NULL,
238 max_renewals INT NOT NULL
240 COMMENT ON TABLE config.rule_circ_duration IS $$
242 * Copyright (C) 2005 Georgia Public Library Service
243 * Mike Rylander <mrylander@gmail.com>
245 * Circulation Duration rules
247 * Each circulation is given a duration based on one of these rules.
252 * This program is free software; you can redistribute it and/or
253 * modify it under the terms of the GNU General Public License
254 * as published by the Free Software Foundation; either version 2
255 * of the License, or (at your option) any later version.
257 * This program is distributed in the hope that it will be useful,
258 * but WITHOUT ANY WARRANTY; without even the implied warranty of
259 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
260 * GNU General Public License for more details.
264 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_0_renew', '7 days', '7 days', '7 days', 0);
265 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_2_renew', '28 days', '28 days', '28 days', 2);
266 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_months_0_renew', '3 mons', '3 mons', '3 mons', 0);
267 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_days_1_renew', '3 days', '3 days', '3 days', 1);
268 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '2_months_2_renew', '2 mons', '2 mons', '2 mons', 2);
269 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '35_days_1_renew', '35 days', '35 days', '35 days', 1);
270 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_2_renew', '7 days', '7 days', '7 days', 2);
271 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '1_hour_2_renew', '1 hour', '1 hour', '1 hour', 2);
272 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_0_renew', '28 days', '28 days', '28 days', 0);
273 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '14_days_2_renew', '14 days', '14 days', '14 days', 2);
275 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, 'default', '21 days', '14 days', '7 days', 2);
278 CREATE TABLE config.rule_max_fine (
279 id SERIAL PRIMARY KEY,
280 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
281 amount NUMERIC(6,2) NOT NULL
283 COMMENT ON TABLE config.rule_max_fine IS $$
285 * Copyright (C) 2005 Georgia Public Library Service
286 * Mike Rylander <mrylander@gmail.com>
288 * Circulation Max Fine rules
290 * Each circulation is given a maximum fine based on one of
296 * This program is free software; you can redistribute it and/or
297 * modify it under the terms of the GNU General Public License
298 * as published by the Free Software Foundation; either version 2
299 * of the License, or (at your option) any later version.
301 * This program is distributed in the hope that it will be useful,
302 * but WITHOUT ANY WARRANTY; without even the implied warranty of
303 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
304 * GNU General Public License for more details.
308 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'default', 5.00);
310 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00);
311 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00);
312 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00);
313 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_min', 25.00);
314 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_mid', 25.00);
315 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_max', 100.00);
318 CREATE TABLE config.rule_recuring_fine (
319 id SERIAL PRIMARY KEY,
320 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
321 high NUMERIC(6,2) NOT NULL,
322 normal NUMERIC(6,2) NOT NULL,
323 low NUMERIC(6,2) NOT NULL,
324 recurance_interval INTERVAL NOT NULL DEFAULT '1 day'::INTERVAL
326 COMMENT ON TABLE config.rule_recuring_fine IS $$
328 * Copyright (C) 2005 Georgia Public Library Service
329 * Mike Rylander <mrylander@gmail.com>
331 * Circulation Recuring Fine rules
333 * Each circulation is given a recuring fine amount based on one of
334 * these rules. The recurance_interval should not be any shorter
335 * than the interval between runs of the fine_processor.pl script
336 * (which is run from CRON), or you could miss fines.
341 * This program is free software; you can redistribute it and/or
342 * modify it under the terms of the GNU General Public License
343 * as published by the Free Software Foundation; either version 2
344 * of the License, or (at your option) any later version.
346 * This program is distributed in the hope that it will be useful,
347 * but WITHOUT ANY WARRANTY; without even the implied warranty of
348 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
349 * GNU General Public License for more details.
353 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, 'default', 0.50, 0.10, 0.05, '1 day');
354 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day');
355 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day');
358 CREATE TABLE config.rule_age_hold_protect (
359 id SERIAL PRIMARY KEY,
360 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
361 age INTERVAL NOT NULL,
364 COMMENT ON TABLE config.rule_age_hold_protect IS $$
366 * Copyright (C) 2005 Georgia Public Library Service
367 * Mike Rylander <mrylander@gmail.com>
369 * Hold Item Age Protection rules
371 * A hold request can only capture new(ish) items when they are
372 * within a particular proximity of the home_ou of the requesting
373 * user. The proximity ('prox' column) is calculated by counting
374 * the number of tree edges beween the user's home_ou and the owning_lib
375 * of the copy that could fulfill the hold.
380 * This program is free software; you can redistribute it and/or
381 * modify it under the terms of the GNU General Public License
382 * as published by the Free Software Foundation; either version 2
383 * of the License, or (at your option) any later version.
385 * This program is distributed in the hope that it will be useful,
386 * but WITHOUT ANY WARRANTY; without even the implied warranty of
387 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
388 * GNU General Public License for more details.
392 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '3month', '3 mons', 0);
393 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '6month', '6 mons', 2);
396 CREATE TABLE config.copy_status (
397 id SERIAL PRIMARY KEY,
398 name TEXT NOT NULL UNIQUE,
399 holdable BOOL NOT NULL DEFAULT FALSE
401 COMMENT ON TABLE config.copy_status IS $$
403 * Copyright (C) 2005 Georgia Public Library Service
404 * Mike Rylander <mrylander@gmail.com>
408 * The available copy statuses, and whether a copy in that
409 * status is available for hold request capture. 0 (zero) is
410 * the only special number in this set, meaning that the item
411 * is available for imediate checkout, and is counted as available
414 * Statuses with an ID below 100 are not removable, and have special
415 * meaning in the code. Do not change them except to translate the
418 * You may add and remove statuses above 100, and these can be used
419 * to remove items from normal circulation without affecting the rest
420 * of the copy's values or it's location.
424 * This program is free software; you can redistribute it and/or
425 * modify it under the terms of the GNU General Public License
426 * as published by the Free Software Foundation; either version 2
427 * of the License, or (at your option) any later version.
429 * This program is distributed in the hope that it will be useful,
430 * but WITHOUT ANY WARRANTY; without even the implied warranty of
431 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
432 * GNU General Public License for more details.
436 INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t');
437 INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t');
438 INSERT INTO config.copy_status (name) VALUES ('Bindery');
439 INSERT INTO config.copy_status (name) VALUES ('Lost');
440 INSERT INTO config.copy_status (name) VALUES ('Missing');
441 INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t');
442 INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t');
443 INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t');
444 INSERT INTO config.copy_status (name,holdable) VALUES ('On holds shelf','t');
445 INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t');
446 INSERT INTO config.copy_status (name) VALUES ('ILL');
447 INSERT INTO config.copy_status (name) VALUES ('Cataloging');
448 INSERT INTO config.copy_status (name) VALUES ('Reserves');
449 INSERT INTO config.copy_status (name) VALUES ('Discard/Weed');
450 INSERT INTO config.copy_status (name) VALUES ('Damaged');
452 SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100);
455 CREATE TABLE config.net_access_level (
456 id SERIAL PRIMARY KEY,
457 name TEXT NOT NULL UNIQUE
459 COMMENT ON TABLE config.net_access_level IS $$
461 * Copyright (C) 2005 Georgia Public Library Service
462 * Mike Rylander <mrylander@gmail.com>
464 * Patron Network Access level
466 * This will be used to inform the in-library firewall of how much
467 * internet access the using patron should be allowed.
471 * This program is free software; you can redistribute it and/or
472 * modify it under the terms of the GNU General Public License
473 * as published by the Free Software Foundation; either version 2
474 * of the License, or (at your option) any later version.
476 * This program is distributed in the hope that it will be useful,
477 * but WITHOUT ANY WARRANTY; without even the implied warranty of
478 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
479 * GNU General Public License for more details.
483 INSERT INTO config.net_access_level (name) VALUES ('Filtered');
484 INSERT INTO config.net_access_level (name) VALUES ('Unfiltered');
485 INSERT INTO config.net_access_level (name) VALUES ('No Access');
487 CREATE TABLE config.audience_map (
488 code TEXT PRIMARY KEY,
493 COPY config.audience_map FROM STDIN;
494 Unknown or unspecified The target audience for the item not known or not specified.
495 a Preschool The item is intended for children, approximate ages 0-5 years.
496 b Primary The item is intended for children, approximate ages 6-8 years.
497 c Pre-adolescent The item is intended for young people, approximate ages 9-13 years.
498 d Adolescent The item is intended for young people, approximate ages 14-17 years.
499 e Adult The item is intended for adults.
500 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.
501 g General The item is of general interest and not aimed at an audience of a particular intellectual level.
502 j Juvenile The item is intended for children and young people, approximate ages 0-15 years.
506 CREATE TABLE config.lit_form_map (
507 code TEXT PRIMARY KEY,
512 COPY config.lit_form_map FROM STDIN;
513 0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired
514 1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired
519 h Humor, satires, etc. The item is a humorous work, satire or of similar literary form.
520 i Letters The item is a single letter or collection of correspondence.
521 j Short stories The item is a short story or collection of short stories.
522 m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories).
523 p Poetry The item is a poem or collection of poems.
524 s Speeches The item is a speech or collection of speeches.
525 u Unknown The literary form of the item is unknown.
528 CREATE TABLE config.language_map (
529 code TEXT PRIMARY KEY,
533 COPY config.language_map FROM STDIN;
540 afa Afroasiatic (Other)
541 afh Afrihili (Artificial language)
548 alg Algonquian (Other)
550 ang English, Old (ca. 450-1100)
554 arg Aragonese Spanish
558 art Artificial (Other)
562 ath Athapascan (Other)
563 aus Australian languages
570 bai Bamileke languages
599 cai Central American Indian (Other)
603 cau Caucasian (Other)
624 cpe Creoles and Pidgins, English-based (Other)
625 cpf Creoles and Pidgins, French-based (Other)
626 cpp Creoles and Pidgins, Portuguese-based (Other)
629 crp Creoles and Pidgins (Other)
642 dra Dravidian (Other)
644 dum Dutch, Middle (ca. 1050-1350)
653 enm English, Middle (1100-1500)
655 -esk Eskimo languages
667 fiu Finno-Ugrian (Other)
671 frm French, Middle (ca. 1400-1600)
672 fro French, Old (ca. 842-1400)
691 gmh German, Middle High (ca. 1050-1500)
692 goh German, Old High (ca. 750-1050)
697 grc Greek, Ancient (to 1453)
698 gre Greek, Modern (1453- )
704 hat Haitian French Creole
726 ina Interlingua (International Auxiliary Language Association)
729 ine Indo-European (Other)
731 -int Interlingua (International Auxiliary Language Association)
735 iro Iroquoian (Other)
777 -lan Occitan (post-1500)
794 luo Luo (Kenya and Tanzania)
805 map Austronesian (Other)
812 mga Irish, Middle (ca. 1100-1550)
815 mis Miscellaneous languages
816 mkh Mon-Khmer (Other)
827 mul Multiple languages
833 nai North American Indian (Other)
834 nap Neapolitan Italian
837 nbl Ndebele (South Africa)
838 nde Ndebele (Zimbabwe)
844 nic Niger-Kordofanian (Other)
846 nno Norwegian (Nynorsk)
847 nob Norwegian (Bokmål)
858 oci Occitan (post-1500)
865 oto Otomian languages
873 peo Old Persian (ca. 600-400 B.C.)
875 phi Philippine (Other)
881 pra Prakrit languages
882 pro Provençal (to 1500)
895 sag Sango (Ubangi Creole)
897 sai South American Indian (Other)
898 sal Salishan languages
899 sam Samaritan Aramaic
909 sga Irish, Old (to 1100)
916 sit Sino-Tibetan (Other)
938 ssa Nilo-Saharan (Other)
999 wak Wakashan languages
1004 wen Sorbian languages
1022 CREATE TABLE config.item_form_map (
1023 code TEXT PRIMARY KEY,
1027 COPY config.item_form_map FROM STDIN;
1033 r Regular print reproduction
1037 CREATE TABLE config.item_type_map (
1038 code TEXT PRIMARY KEY,
1042 COPY config.item_type_map FROM STDIN;
1044 t Manuscript language material
1046 k Two-dimensional nonprojectable graphic
1047 r Three-dimensional artifact or naturally occurring object
1050 e Cartographic material
1051 f Manuscript cartographic material
1053 d Manuscript notated music
1054 i Nonmusical sound recording
1055 j Musical sound recording