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.
31 CREATE TABLE config.i18n_core (
32 id BIGSERIAL PRIMARY KEY,
33 fq_field TEXT NOT NULL,
34 identity_value TEXT NOT NULL,
35 translation TEXT NOT NULL,
39 CREATE UNIQUE INDEX i18n_identity ON config.i18n_core (fq_field,identity_value,translation);
41 CREATE TABLE config.bib_source (
42 id SERIAL PRIMARY KEY,
43 quality INT CHECK ( quality BETWEEN 0 AND 100 ),
44 source TEXT NOT NULL UNIQUE,
45 transcendant BOOL NOT NULL DEFAULT FALSE
47 COMMENT ON TABLE config.bib_source IS $$
49 * Copyright (C) 2005 Georgia Public Library Service
50 * Mike Rylander <mrylander@gmail.com>
52 * Valid sources of MARC records
54 * This is table is used to set up the relative "quality" of each
55 * MARC source, such as OCLC.
59 * This program is free software; you can redistribute it and/or
60 * modify it under the terms of the GNU General Public License
61 * as published by the Free Software Foundation; either version 2
62 * of the License, or (at your option) any later version.
64 * This program is distributed in the hope that it will be useful,
65 * but WITHOUT ANY WARRANTY; without even the implied warranty of
66 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
67 * GNU General Public License for more details.
72 INSERT INTO config.bib_source (quality, source) VALUES (90, 'oclc');
73 INSERT INTO config.bib_source (quality, source) VALUES (10, 'System Local');
74 INSERT INTO config.bib_source (quality, source, transcendant) VALUES (1, 'Project Gutenberg', TRUE);
76 CREATE TABLE config.standing (
77 id SERIAL PRIMARY KEY,
78 value TEXT NOT NULL UNIQUE
80 COMMENT ON TABLE config.standing IS $$
82 * Copyright (C) 2005 Georgia Public Library Service
83 * Mike Rylander <mrylander@gmail.com>
87 * This table contains the values that can be applied to a patron
88 * by a staff member. These values should not be changed, other
89 * that for translation, as the ID column is currently a "magic
90 * number" in the source. :(
94 * This program is free software; you can redistribute it and/or
95 * modify it under the terms of the GNU General Public License
96 * as published by the Free Software Foundation; either version 2
97 * of the License, or (at your option) any later version.
99 * This program is distributed in the hope that it will be useful,
100 * but WITHOUT ANY WARRANTY; without even the implied warranty of
101 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
102 * GNU General Public License for more details.
106 INSERT INTO config.standing (value) VALUES ('Good');
107 INSERT INTO config.standing (value) VALUES ('Barred');
110 CREATE TABLE config.xml_transform (
111 name TEXT PRIMARY KEY,
112 namespace_uri TEXT NOT NULL UNIQUE,
113 prefix TEXT NOT NULL,
116 INSERT INTO config.xml_transform VALUES ( 'marcxml', 'http://www.loc.gov/MARC21/slim', 'marc', '---' );
117 INSERT INTO config.xml_transform VALUES ( 'mods', 'http://www.loc.gov/mods/', 'mods', '/home/miker/MARC21slim2MODS.xsl' );
119 CREATE TABLE config.metabib_field (
120 id SERIAL PRIMARY KEY,
121 field_class TEXT NOT NULL CHECK (lower(field_class) IN ('title','author','subject','keyword','series')),
124 weight INT NOT NULL DEFAULT 1,
125 format TEXT NOT NULL DEFAULT 'mods',
126 search_field BOOL NOT NULL DEFAULT TRUE,
127 facet_field BOOL NOT NULL DEFAULT FALSE
129 COMMENT ON TABLE config.metabib_field IS $$
131 * Copyright (C) 2005 Georgia Public Library Service
132 * Mike Rylander <mrylander@gmail.com>
134 * XPath used for record indexing ingest
136 * This table contains the XPath used to chop up MODS into it's
137 * indexable parts. Each XPath entry is named and assigned to
138 * a "class" of either title, subject, author, keyword or series.
143 * This program is free software; you can redistribute it and/or
144 * modify it under the terms of the GNU General Public License
145 * as published by the Free Software Foundation; either version 2
146 * of the License, or (at your option) any later version.
148 * This program is distributed in the hope that it will be useful,
149 * but WITHOUT ANY WARRANTY; without even the implied warranty of
150 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
151 * GNU General Public License for more details.
155 CREATE UNIQUE INDEX config_metabib_field_class_name_idx ON config.metabib_field (field_class, name);
158 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ );
159 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abbreviated')]$$ );
160 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ );
161 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ );
162 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ );
163 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']]$$ );
164 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']]$$ );
165 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']]$$ );
166 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ );
167 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ );
168 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ );
169 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ );
170 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ );
171 -- INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ );
172 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */
174 CREATE TABLE config.non_cataloged_type (
175 id SERIAL PRIMARY KEY,
176 owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id),
178 circ_duration INTERVAL NOT NULL DEFAULT '14 days'::INTERVAL,
179 in_house BOOL NOT NULL DEFAULT FALSE,
180 CONSTRAINT noncat_once_per_lib UNIQUE (owning_lib,name)
182 COMMENT ON TABLE config.non_cataloged_type IS $$
184 * Copyright (C) 2005 Georgia Public Library Service
185 * Mike Rylander <mrylander@gmail.com>
187 * Types of valid non-cataloged items.
192 * This program is free software; you can redistribute it and/or
193 * modify it under the terms of the GNU General Public License
194 * as published by the Free Software Foundation; either version 2
195 * of the License, or (at your option) any later version.
197 * This program is distributed in the hope that it will be useful,
198 * but WITHOUT ANY WARRANTY; without even the implied warranty of
199 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
200 * GNU General Public License for more details.
205 INSERT INTO config.non_cataloged_type ( owning_lib, name ) VALUES ( 1, 'Paperback Book' );
207 CREATE TABLE config.identification_type (
208 id SERIAL PRIMARY KEY,
209 name TEXT NOT NULL UNIQUE
211 COMMENT ON TABLE config.identification_type IS $$
213 * Copyright (C) 2005 Georgia Public Library Service
214 * Mike Rylander <mrylander@gmail.com>
216 * Types of valid patron identification.
218 * Each patron must display at least one valid form of identification
219 * in order to get a library card. This table lists those forms.
224 * This program is free software; you can redistribute it and/or
225 * modify it under the terms of the GNU General Public License
226 * as published by the Free Software Foundation; either version 2
227 * of the License, or (at your option) any later version.
229 * This program is distributed in the hope that it will be useful,
230 * but WITHOUT ANY WARRANTY; without even the implied warranty of
231 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
232 * GNU General Public License for more details.
237 INSERT INTO config.identification_type ( name ) VALUES ( 'Drivers License' );
238 INSERT INTO config.identification_type ( name ) VALUES ( 'SSN' );
239 INSERT INTO config.identification_type ( name ) VALUES ( 'Other' );
241 CREATE TABLE config.rule_circ_duration (
242 id SERIAL PRIMARY KEY,
243 name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ),
244 extended INTERVAL NOT NULL,
245 normal INTERVAL NOT NULL,
246 shrt INTERVAL NOT NULL,
247 max_renewals INT NOT NULL
249 COMMENT ON TABLE config.rule_circ_duration IS $$
251 * Copyright (C) 2005 Georgia Public Library Service
252 * Mike Rylander <mrylander@gmail.com>
254 * Circulation Duration rules
256 * Each circulation is given a duration based on one of these rules.
261 * This program is free software; you can redistribute it and/or
262 * modify it under the terms of the GNU General Public License
263 * as published by the Free Software Foundation; either version 2
264 * of the License, or (at your option) any later version.
266 * This program is distributed in the hope that it will be useful,
267 * but WITHOUT ANY WARRANTY; without even the implied warranty of
268 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
269 * GNU General Public License for more details.
273 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_0_renew', '7 days', '7 days', '7 days', 0);
274 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_2_renew', '28 days', '28 days', '28 days', 2);
275 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_months_0_renew', '3 mons', '3 mons', '3 mons', 0);
276 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_days_1_renew', '3 days', '3 days', '3 days', 1);
277 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '2_months_2_renew', '2 mons', '2 mons', '2 mons', 2);
278 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '35_days_1_renew', '35 days', '35 days', '35 days', 1);
279 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_2_renew', '7 days', '7 days', '7 days', 2);
280 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '1_hour_2_renew', '1 hour', '1 hour', '1 hour', 2);
281 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_0_renew', '28 days', '28 days', '28 days', 0);
282 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '14_days_2_renew', '14 days', '14 days', '14 days', 2);
284 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, 'default', '21 days', '14 days', '7 days', 2);
287 CREATE TABLE config.rule_max_fine (
288 id SERIAL PRIMARY KEY,
289 name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ),
290 amount NUMERIC(6,2) NOT NULL
292 COMMENT ON TABLE config.rule_max_fine IS $$
294 * Copyright (C) 2005 Georgia Public Library Service
295 * Mike Rylander <mrylander@gmail.com>
297 * Circulation Max Fine rules
299 * Each circulation is given a maximum fine based on one of
305 * This program is free software; you can redistribute it and/or
306 * modify it under the terms of the GNU General Public License
307 * as published by the Free Software Foundation; either version 2
308 * of the License, or (at your option) any later version.
310 * This program is distributed in the hope that it will be useful,
311 * but WITHOUT ANY WARRANTY; without even the implied warranty of
312 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
313 * GNU General Public License for more details.
317 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'default', 5.00);
319 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00);
320 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00);
321 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00);
322 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_min', 25.00);
323 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_mid', 25.00);
324 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_max', 100.00);
327 CREATE TABLE config.rule_recuring_fine (
328 id SERIAL PRIMARY KEY,
329 name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ),
330 high NUMERIC(6,2) NOT NULL,
331 normal NUMERIC(6,2) NOT NULL,
332 low NUMERIC(6,2) NOT NULL,
333 recurance_interval INTERVAL NOT NULL DEFAULT '1 day'::INTERVAL
335 COMMENT ON TABLE config.rule_recuring_fine IS $$
337 * Copyright (C) 2005 Georgia Public Library Service
338 * Mike Rylander <mrylander@gmail.com>
340 * Circulation Recuring Fine rules
342 * Each circulation is given a recuring fine amount based on one of
343 * these rules. The recurance_interval should not be any shorter
344 * than the interval between runs of the fine_processor.pl script
345 * (which is run from CRON), or you could miss fines.
350 * This program is free software; you can redistribute it and/or
351 * modify it under the terms of the GNU General Public License
352 * as published by the Free Software Foundation; either version 2
353 * of the License, or (at your option) any later version.
355 * This program is distributed in the hope that it will be useful,
356 * but WITHOUT ANY WARRANTY; without even the implied warranty of
357 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
358 * GNU General Public License for more details.
362 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, 'default', 0.50, 0.10, 0.05, '1 day');
363 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day');
364 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day');
367 CREATE TABLE config.rule_age_hold_protect (
368 id SERIAL PRIMARY KEY,
369 name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ),
370 age INTERVAL NOT NULL,
373 COMMENT ON TABLE config.rule_age_hold_protect IS $$
375 * Copyright (C) 2005 Georgia Public Library Service
376 * Mike Rylander <mrylander@gmail.com>
378 * Hold Item Age Protection rules
380 * A hold request can only capture new(ish) items when they are
381 * within a particular proximity of the home_ou of the requesting
382 * user. The proximity ('prox' column) is calculated by counting
383 * the number of tree edges beween the user's home_ou and the owning_lib
384 * of the copy that could fulfill the hold.
389 * This program is free software; you can redistribute it and/or
390 * modify it under the terms of the GNU General Public License
391 * as published by the Free Software Foundation; either version 2
392 * of the License, or (at your option) any later version.
394 * This program is distributed in the hope that it will be useful,
395 * but WITHOUT ANY WARRANTY; without even the implied warranty of
396 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
397 * GNU General Public License for more details.
401 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '3month', '3 mons', 0);
402 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '6month', '6 mons', 2);
405 CREATE TABLE config.copy_status (
406 id SERIAL PRIMARY KEY,
407 name TEXT NOT NULL UNIQUE,
408 holdable BOOL NOT NULL DEFAULT FALSE
410 COMMENT ON TABLE config.copy_status IS $$
412 * Copyright (C) 2005 Georgia Public Library Service
413 * Mike Rylander <mrylander@gmail.com>
417 * The available copy statuses, and whether a copy in that
418 * status is available for hold request capture. 0 (zero) is
419 * the only special number in this set, meaning that the item
420 * is available for imediate checkout, and is counted as available
423 * Statuses with an ID below 100 are not removable, and have special
424 * meaning in the code. Do not change them except to translate the
427 * You may add and remove statuses above 100, and these can be used
428 * to remove items from normal circulation without affecting the rest
429 * of the copy's values or it's location.
433 * This program is free software; you can redistribute it and/or
434 * modify it under the terms of the GNU General Public License
435 * as published by the Free Software Foundation; either version 2
436 * of the License, or (at your option) any later version.
438 * This program is distributed in the hope that it will be useful,
439 * but WITHOUT ANY WARRANTY; without even the implied warranty of
440 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
441 * GNU General Public License for more details.
445 INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t');
446 INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t');
447 INSERT INTO config.copy_status (name) VALUES ('Bindery');
448 INSERT INTO config.copy_status (name) VALUES ('Lost');
449 INSERT INTO config.copy_status (name) VALUES ('Missing');
450 INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t');
451 INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t');
452 INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t');
453 INSERT INTO config.copy_status (name,holdable) VALUES ('On holds shelf','t');
454 INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t');
455 INSERT INTO config.copy_status (name) VALUES ('ILL');
456 INSERT INTO config.copy_status (name) VALUES ('Cataloging');
457 INSERT INTO config.copy_status (name) VALUES ('Reserves');
458 INSERT INTO config.copy_status (name) VALUES ('Discard/Weed');
459 INSERT INTO config.copy_status (name) VALUES ('Damaged');
461 SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100);
464 CREATE TABLE config.net_access_level (
465 id SERIAL PRIMARY KEY,
466 name TEXT NOT NULL UNIQUE
468 COMMENT ON TABLE config.net_access_level IS $$
470 * Copyright (C) 2005 Georgia Public Library Service
471 * Mike Rylander <mrylander@gmail.com>
473 * Patron Network Access level
475 * This will be used to inform the in-library firewall of how much
476 * internet access the using patron should be allowed.
480 * This program is free software; you can redistribute it and/or
481 * modify it under the terms of the GNU General Public License
482 * as published by the Free Software Foundation; either version 2
483 * of the License, or (at your option) any later version.
485 * This program is distributed in the hope that it will be useful,
486 * but WITHOUT ANY WARRANTY; without even the implied warranty of
487 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
488 * GNU General Public License for more details.
492 INSERT INTO config.net_access_level (name) VALUES ('Filtered');
493 INSERT INTO config.net_access_level (name) VALUES ('Unfiltered');
494 INSERT INTO config.net_access_level (name) VALUES ('No Access');
496 CREATE TABLE config.audience_map (
497 code TEXT PRIMARY KEY,
502 COPY config.audience_map FROM STDIN;
503 Unknown or unspecified The target audience for the item not known or not specified.
504 a Preschool The item is intended for children, approximate ages 0-5 years.
505 b Primary The item is intended for children, approximate ages 6-8 years.
506 c Pre-adolescent The item is intended for young people, approximate ages 9-13 years.
507 d Adolescent The item is intended for young people, approximate ages 14-17 years.
508 e Adult The item is intended for adults.
509 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.
510 g General The item is of general interest and not aimed at an audience of a particular intellectual level.
511 j Juvenile The item is intended for children and young people, approximate ages 0-15 years.
515 CREATE TABLE config.lit_form_map (
516 code TEXT PRIMARY KEY,
521 COPY config.lit_form_map FROM STDIN;
522 0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired
523 1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired
528 h Humor, satires, etc. The item is a humorous work, satire or of similar literary form.
529 i Letters The item is a single letter or collection of correspondence.
530 j Short stories The item is a short story or collection of short stories.
531 m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories).
532 p Poetry The item is a poem or collection of poems.
533 s Speeches The item is a speech or collection of speeches.
534 u Unknown The literary form of the item is unknown.
537 CREATE TABLE config.language_map (
538 code TEXT PRIMARY KEY,
542 COPY config.language_map FROM STDIN;
549 afa Afroasiatic (Other)
550 afh Afrihili (Artificial language)
557 alg Algonquian (Other)
559 ang English, Old (ca. 450-1100)
563 arg Aragonese Spanish
567 art Artificial (Other)
571 ath Athapascan (Other)
572 aus Australian languages
579 bai Bamileke languages
608 cai Central American Indian (Other)
612 cau Caucasian (Other)
633 cpe Creoles and Pidgins, English-based (Other)
634 cpf Creoles and Pidgins, French-based (Other)
635 cpp Creoles and Pidgins, Portuguese-based (Other)
638 crp Creoles and Pidgins (Other)
651 dra Dravidian (Other)
653 dum Dutch, Middle (ca. 1050-1350)
662 enm English, Middle (1100-1500)
664 -esk Eskimo languages
676 fiu Finno-Ugrian (Other)
680 frm French, Middle (ca. 1400-1600)
681 fro French, Old (ca. 842-1400)
700 gmh German, Middle High (ca. 1050-1500)
701 goh German, Old High (ca. 750-1050)
706 grc Greek, Ancient (to 1453)
707 gre Greek, Modern (1453- )
713 hat Haitian French Creole
735 ina Interlingua (International Auxiliary Language Association)
738 ine Indo-European (Other)
740 -int Interlingua (International Auxiliary Language Association)
744 iro Iroquoian (Other)
786 -lan Occitan (post-1500)
803 luo Luo (Kenya and Tanzania)
814 map Austronesian (Other)
821 mga Irish, Middle (ca. 1100-1550)
824 mis Miscellaneous languages
825 mkh Mon-Khmer (Other)
836 mul Multiple languages
842 nai North American Indian (Other)
843 nap Neapolitan Italian
846 nbl Ndebele (South Africa)
847 nde Ndebele (Zimbabwe)
853 nic Niger-Kordofanian (Other)
855 nno Norwegian (Nynorsk)
856 nob Norwegian (Bokmål)
867 oci Occitan (post-1500)
874 oto Otomian languages
882 peo Old Persian (ca. 600-400 B.C.)
884 phi Philippine (Other)
890 pra Prakrit languages
891 pro Provençal (to 1500)
904 sag Sango (Ubangi Creole)
906 sai South American Indian (Other)
907 sal Salishan languages
908 sam Samaritan Aramaic
918 sga Irish, Old (to 1100)
925 sit Sino-Tibetan (Other)
947 ssa Nilo-Saharan (Other)
1008 wak Wakashan languages
1013 wen Sorbian languages
1031 CREATE TABLE config.item_form_map (
1032 code TEXT PRIMARY KEY,
1036 COPY config.item_form_map FROM STDIN;
1042 r Regular print reproduction
1046 CREATE TABLE config.item_type_map (
1047 code TEXT PRIMARY KEY,
1051 COPY config.item_type_map FROM STDIN;
1053 t Manuscript language material
1055 k Two-dimensional nonprojectable graphic
1056 r Three-dimensional artifact or naturally occurring object
1059 e Cartographic material
1060 f Manuscript cartographic material
1062 d Manuscript notated music
1063 i Nonmusical sound recording
1064 j Musical sound recording