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 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.
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);
276 CREATE TABLE config.rule_max_fine (
277 id SERIAL PRIMARY KEY,
278 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
279 amount NUMERIC(6,2) NOT NULL
281 COMMENT ON TABLE config.rule_max_fine IS $$
283 * Copyright (C) 2005 Georgia Public Library Service
284 * Mike Rylander <mrylander@gmail.com>
286 * Circulation Max Fine rules
288 * Each circulation is given a maximum fine based on one of
294 * This program is free software; you can redistribute it and/or
295 * modify it under the terms of the GNU General Public License
296 * as published by the Free Software Foundation; either version 2
297 * of the License, or (at your option) any later version.
299 * This program is distributed in the hope that it will be useful,
300 * but WITHOUT ANY WARRANTY; without even the implied warranty of
301 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
302 * GNU General Public License for more details.
306 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00);
307 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00);
308 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00);
309 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_min', 25.00);
310 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_mid', 25.00);
311 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_max', 100.00);
314 CREATE TABLE config.rule_recuring_fine (
315 id SERIAL PRIMARY KEY,
316 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
317 high NUMERIC(6,2) NOT NULL,
318 normal NUMERIC(6,2) NOT NULL,
319 low NUMERIC(6,2) NOT NULL,
320 recurance_interval INTERVAL NOT NULL DEFAULT '1 day'::INTERVAL
322 COMMENT ON TABLE config.rule_recuring_fine IS $$
324 * Copyright (C) 2005 Georgia Public Library Service
325 * Mike Rylander <mrylander@gmail.com>
327 * Circulation Recuring Fine rules
329 * Each circulation is given a recuring fine amount based on one of
330 * these rules. The recurance_interval should not be any shorter
331 * than the interval between runs of the fine_processor.pl script
332 * (which is run from CRON), or you could miss fines.
337 * This program is free software; you can redistribute it and/or
338 * modify it under the terms of the GNU General Public License
339 * as published by the Free Software Foundation; either version 2
340 * of the License, or (at your option) any later version.
342 * This program is distributed in the hope that it will be useful,
343 * but WITHOUT ANY WARRANTY; without even the implied warranty of
344 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
345 * GNU General Public License for more details.
349 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day');
350 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day');
353 CREATE TABLE config.rule_age_hold_protect (
354 id SERIAL PRIMARY KEY,
355 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
356 age INTERVAL NOT NULL,
359 COMMENT ON TABLE config.rule_age_hold_protect IS $$
361 * Copyright (C) 2005 Georgia Public Library Service
362 * Mike Rylander <mrylander@gmail.com>
364 * Hold Item Age Protection rules
366 * A hold request can only capture new(ish) items when they are
367 * within a particular proximity of the home_ou of the requesting
368 * user. The proximity ('prox' column) is calculated by counting
369 * the number of tree edges beween the user's home_ou and the owning_lib
370 * of the copy that could fulfill the hold.
375 * This program is free software; you can redistribute it and/or
376 * modify it under the terms of the GNU General Public License
377 * as published by the Free Software Foundation; either version 2
378 * of the License, or (at your option) any later version.
380 * This program is distributed in the hope that it will be useful,
381 * but WITHOUT ANY WARRANTY; without even the implied warranty of
382 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
383 * GNU General Public License for more details.
387 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '3month', '3 mons', 0);
388 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '6month', '6 mons', 2);
391 CREATE TABLE config.copy_status (
392 id SERIAL PRIMARY KEY,
393 name TEXT NOT NULL UNIQUE,
394 holdable BOOL NOT NULL DEFAULT FALSE
396 COMMENT ON TABLE config.copy_status IS $$
398 * Copyright (C) 2005 Georgia Public Library Service
399 * Mike Rylander <mrylander@gmail.com>
403 * The available copy statuses, and whether a copy in that
404 * status is available for hold request capture. 0 (zero) is
405 * the only special number in this set, meaning that the item
406 * is available for imediate checkout, and is counted as available
409 * Statuses with an ID below 100 are not removable, and have special
410 * meaning in the code. Do not change them except to translate the
413 * You may add and remove statuses above 100, and these can be used
414 * to remove items from normal circulation without affecting the rest
415 * of the copy's values or it's location.
419 * This program is free software; you can redistribute it and/or
420 * modify it under the terms of the GNU General Public License
421 * as published by the Free Software Foundation; either version 2
422 * of the License, or (at your option) any later version.
424 * This program is distributed in the hope that it will be useful,
425 * but WITHOUT ANY WARRANTY; without even the implied warranty of
426 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
427 * GNU General Public License for more details.
431 INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t');
432 INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t');
433 INSERT INTO config.copy_status (name) VALUES ('Bindery');
434 INSERT INTO config.copy_status (name) VALUES ('Lost');
435 INSERT INTO config.copy_status (name) VALUES ('Missing');
436 INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t');
437 INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t');
438 INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t');
439 INSERT INTO config.copy_status (name,holdable) VALUES ('On holds shelf','t');
440 INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t');
441 INSERT INTO config.copy_status (name) VALUES ('ILL');
442 INSERT INTO config.copy_status (name) VALUES ('Cataloging');
443 INSERT INTO config.copy_status (name) VALUES ('Reserves');
444 INSERT INTO config.copy_status (name) VALUES ('Discard/Weed');
445 INSERT INTO config.copy_status (name) VALUES ('Damaged');
447 SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100);
450 CREATE TABLE config.net_access_level (
451 id SERIAL PRIMARY KEY,
452 name TEXT NOT NULL UNIQUE
454 COMMENT ON TABLE config.net_access_level IS $$
456 * Copyright (C) 2005 Georgia Public Library Service
457 * Mike Rylander <mrylander@gmail.com>
459 * Patron Network Access level
461 * This will be used to inform the in-library firewall of how much
462 * internet access the using patron should be allowed.
466 * This program is free software; you can redistribute it and/or
467 * modify it under the terms of the GNU General Public License
468 * as published by the Free Software Foundation; either version 2
469 * of the License, or (at your option) any later version.
471 * This program is distributed in the hope that it will be useful,
472 * but WITHOUT ANY WARRANTY; without even the implied warranty of
473 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
474 * GNU General Public License for more details.
478 INSERT INTO config.net_access_level (name) VALUES ('Filtered');
479 INSERT INTO config.net_access_level (name) VALUES ('Unfiltered');
480 INSERT INTO config.net_access_level (name) VALUES ('No Access');
482 CREATE TABLE config.audience_map (
483 code TEXT PRIMARY KEY,
488 COPY config.audience_map FROM STDIN;
489 Unknown or unspecified The target audience for the item not known or not specified.
490 a Preschool The item is intended for children, approximate ages 0-5 years.
491 b Primary The item is intended for children, approximate ages 6-8 years.
492 c Pre-adolescent The item is intended for young people, approximate ages 9-13 years.
493 d Adolescent The item is intended for young people, approximate ages 14-17 years.
494 e Adult The item is intended for adults.
495 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.
496 g General The item is of general interest and not aimed at an audience of a particular intellectual level.
497 j Juvenile The item is intended for children and young people, approximate ages 0-15 years.
501 CREATE TABLE config.lit_form_map (
502 code TEXT PRIMARY KEY,
507 COPY config.lit_form_map FROM STDIN;
508 0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired
509 1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired
514 h Humor, satires, etc. The item is a humorous work, satire or of similar literary form.
515 i Letters The item is a single letter or collection of correspondence.
516 j Short stories The item is a short story or collection of short stories.
517 m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories).
518 p Poetry The item is a poem or collection of poems.
519 s Speeches The item is a speech or collection of speeches.
520 u Unknown The literary form of the item is unknown.
523 CREATE TABLE config.language_map (
524 code TEXT PRIMARY KEY,
528 COPY config.language_map FROM STDIN;
535 afa Afroasiatic (Other)
536 afh Afrihili (Artificial language)
543 alg Algonquian (Other)
545 ang English, Old (ca. 450-1100)
549 arg Aragonese Spanish
553 art Artificial (Other)
557 ath Athapascan (Other)
558 aus Australian languages
565 bai Bamileke languages
594 cai Central American Indian (Other)
598 cau Caucasian (Other)
619 cpe Creoles and Pidgins, English-based (Other)
620 cpf Creoles and Pidgins, French-based (Other)
621 cpp Creoles and Pidgins, Portuguese-based (Other)
624 crp Creoles and Pidgins (Other)
637 dra Dravidian (Other)
639 dum Dutch, Middle (ca. 1050-1350)
648 enm English, Middle (1100-1500)
650 -esk Eskimo languages
662 fiu Finno-Ugrian (Other)
666 frm French, Middle (ca. 1400-1600)
667 fro French, Old (ca. 842-1400)
686 gmh German, Middle High (ca. 1050-1500)
687 goh German, Old High (ca. 750-1050)
692 grc Greek, Ancient (to 1453)
693 gre Greek, Modern (1453- )
699 hat Haitian French Creole
721 ina Interlingua (International Auxiliary Language Association)
724 ine Indo-European (Other)
726 -int Interlingua (International Auxiliary Language Association)
730 iro Iroquoian (Other)
772 -lan Occitan (post-1500)
789 luo Luo (Kenya and Tanzania)
800 map Austronesian (Other)
807 mga Irish, Middle (ca. 1100-1550)
810 mis Miscellaneous languages
811 mkh Mon-Khmer (Other)
822 mul Multiple languages
828 nai North American Indian (Other)
829 nap Neapolitan Italian
832 nbl Ndebele (South Africa)
833 nde Ndebele (Zimbabwe)
839 nic Niger-Kordofanian (Other)
841 nno Norwegian (Nynorsk)
842 nob Norwegian (Bokmål)
853 oci Occitan (post-1500)
860 oto Otomian languages
868 peo Old Persian (ca. 600-400 B.C.)
870 phi Philippine (Other)
876 pra Prakrit languages
877 pro Provençal (to 1500)
890 sag Sango (Ubangi Creole)
892 sai South American Indian (Other)
893 sal Salishan languages
894 sam Samaritan Aramaic
904 sga Irish, Old (to 1100)
911 sit Sino-Tibetan (Other)
933 ssa Nilo-Saharan (Other)
994 wak Wakashan languages
999 wen Sorbian languages
1017 CREATE TABLE config.item_form_map (
1018 code TEXT PRIMARY KEY,
1022 COPY config.item_form_map FROM STDIN;
1028 r Regular print reproduction
1032 CREATE TABLE config.item_type_map (
1033 code TEXT PRIMARY KEY,
1037 COPY config.item_type_map FROM STDIN;
1039 t Manuscript language material
1041 k Two-dimensional nonprojectable graphic
1042 r Three-dimensional artifact or naturally occurring object
1045 e Cartographic material
1046 f Manuscript cartographic material
1048 d Manuscript notated music
1049 i Nonmusical sound recording
1050 j Musical sound recording