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');
102 CREATE TABLE config.metabib_field (
103 id SERIAL PRIMARY KEY,
104 field_class TEXT NOT NULL CHECK (lower(field_class) IN ('title','author','subject','keyword','series')),
105 name TEXT NOT NULL UNIQUE,
107 weight INT NOT NULL DEFAULT 1,
108 format TEXT NOT NULL DEFAULT 'mods'
110 COMMENT ON TABLE config.metabib_field IS $$
112 * Copyright (C) 2005 Georgia Public Library Service
113 * Mike Rylander <mrylander@gmail.com>
115 * XPath used for WoRMing
117 * This table contains the XPath used to chop up MODS into it's
118 * indexable parts. Each XPath entry is named and assigned to
119 * a "class" of either title, subject, author, keyword or series.
124 * This program is free software; you can redistribute it and/or
125 * modify it under the terms of the GNU General Public License
126 * as published by the Free Software Foundation; either version 2
127 * of the License, or (at your option) any later version.
129 * This program is distributed in the hope that it will be useful,
130 * but WITHOUT ANY WARRANTY; without even the implied warranty of
131 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
132 * GNU General Public License for more details.
137 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ );
138 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abreviated')]$$ );
139 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ );
140 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ );
141 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ );
142 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']]$$ );
143 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']]$$ );
144 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']]$$ );
145 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ );
146 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ );
147 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ );
148 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ );
149 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ );
150 -- INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ );
151 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */
153 CREATE TABLE config.non_cataloged_type (
154 id SERIAL PRIMARY KEY,
155 owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id),
157 circ_duration INTERVAL NOT NULL DEFAULT '14 days'::INTERVAL,
158 in_house BOOL NOT NULL DEFAULT FALSE,
159 CONSTRAINT noncat_once_per_lib UNIQUE (owning_lib,name)
161 COMMENT ON TABLE config.non_cataloged_type IS $$
163 * Copyright (C) 2005 Georgia Public Library Service
164 * Mike Rylander <mrylander@gmail.com>
166 * Types of valid non-cataloged items.
171 * This program is free software; you can redistribute it and/or
172 * modify it under the terms of the GNU General Public License
173 * as published by the Free Software Foundation; either version 2
174 * of the License, or (at your option) any later version.
176 * This program is distributed in the hope that it will be useful,
177 * but WITHOUT ANY WARRANTY; without even the implied warranty of
178 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
179 * GNU General Public License for more details.
184 INSERT INTO config.non_cataloged_type ( owning_lib, name ) VALUES ( 1, 'Paperback Book' );
186 CREATE TABLE config.identification_type (
187 id SERIAL PRIMARY KEY,
188 name TEXT NOT NULL UNIQUE
190 COMMENT ON TABLE config.identification_type IS $$
192 * Copyright (C) 2005 Georgia Public Library Service
193 * Mike Rylander <mrylander@gmail.com>
195 * Types of valid patron identification.
197 * Each patron must display at least one valid form of identification
198 * in order to get a library card. This table lists those forms.
203 * This program is free software; you can redistribute it and/or
204 * modify it under the terms of the GNU General Public License
205 * as published by the Free Software Foundation; either version 2
206 * of the License, or (at your option) any later version.
208 * This program is distributed in the hope that it will be useful,
209 * but WITHOUT ANY WARRANTY; without even the implied warranty of
210 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
211 * GNU General Public License for more details.
216 INSERT INTO config.identification_type ( name ) VALUES ( 'Drivers License' );
217 INSERT INTO config.identification_type ( name ) VALUES ( 'SSN' );
218 INSERT INTO config.identification_type ( name ) VALUES ( 'Other' );
220 CREATE TABLE config.rule_circ_duration (
221 id SERIAL PRIMARY KEY,
222 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
223 extended INTERVAL NOT NULL,
224 normal INTERVAL NOT NULL,
225 shrt INTERVAL NOT NULL,
226 max_renewals INT NOT NULL
228 COMMENT ON TABLE config.rule_circ_duration IS $$
230 * Copyright (C) 2005 Georgia Public Library Service
231 * Mike Rylander <mrylander@gmail.com>
233 * Circulation Duration rules
235 * Each circulation is given a duration based on one of these rules.
240 * This program is free software; you can redistribute it and/or
241 * modify it under the terms of the GNU General Public License
242 * as published by the Free Software Foundation; either version 2
243 * of the License, or (at your option) any later version.
245 * This program is distributed in the hope that it will be useful,
246 * but WITHOUT ANY WARRANTY; without even the implied warranty of
247 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
248 * GNU General Public License for more details.
252 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_0_renew', '7 days', '7 days', '7 days', 0);
253 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_2_renew', '28 days', '28 days', '28 days', 2);
254 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_months_0_renew', '3 mons', '3 mons', '3 mons', 0);
255 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_days_1_renew', '3 days', '3 days', '3 days', 1);
256 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '2_months_2_renew', '2 mons', '2 mons', '2 mons', 2);
257 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '35_days_1_renew', '35 days', '35 days', '35 days', 1);
258 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_2_renew', '7 days', '7 days', '7 days', 2);
259 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '1_hour_2_renew', '1 hour', '1 hour', '1 hour', 2);
260 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_0_renew', '28 days', '28 days', '28 days', 0);
261 INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '14_days_2_renew', '14 days', '14 days', '14 days', 2);
264 CREATE TABLE config.rule_max_fine (
265 id SERIAL PRIMARY KEY,
266 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
267 amount NUMERIC(6,2) NOT NULL
269 COMMENT ON TABLE config.rule_max_fine IS $$
271 * Copyright (C) 2005 Georgia Public Library Service
272 * Mike Rylander <mrylander@gmail.com>
274 * Circulation Max Fine rules
276 * Each circulation is given a maximum fine based on one of
282 * This program is free software; you can redistribute it and/or
283 * modify it under the terms of the GNU General Public License
284 * as published by the Free Software Foundation; either version 2
285 * of the License, or (at your option) any later version.
287 * This program is distributed in the hope that it will be useful,
288 * but WITHOUT ANY WARRANTY; without even the implied warranty of
289 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
290 * GNU General Public License for more details.
294 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00);
295 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00);
296 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00);
297 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_min', 25.00);
298 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_mid', 25.00);
299 INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_max', 100.00);
302 CREATE TABLE config.rule_recuring_fine (
303 id SERIAL PRIMARY KEY,
304 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
305 high NUMERIC(6,2) NOT NULL,
306 normal NUMERIC(6,2) NOT NULL,
307 low NUMERIC(6,2) NOT NULL,
308 recurance_interval INTERVAL NOT NULL DEFAULT '1 day'::INTERVAL
310 COMMENT ON TABLE config.rule_recuring_fine IS $$
312 * Copyright (C) 2005 Georgia Public Library Service
313 * Mike Rylander <mrylander@gmail.com>
315 * Circulation Recuring Fine rules
317 * Each circulation is given a recuring fine amount based on one of
318 * these rules. The recurance_interval should not be any shorter
319 * than the interval between runs of the fine_processor.pl script
320 * (which is run from CRON), or you could miss fines.
325 * This program is free software; you can redistribute it and/or
326 * modify it under the terms of the GNU General Public License
327 * as published by the Free Software Foundation; either version 2
328 * of the License, or (at your option) any later version.
330 * This program is distributed in the hope that it will be useful,
331 * but WITHOUT ANY WARRANTY; without even the implied warranty of
332 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
333 * GNU General Public License for more details.
337 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day');
338 INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day');
341 CREATE TABLE config.rule_age_hold_protect (
342 id SERIAL PRIMARY KEY,
343 name TEXT NOT NULL UNIQUE CHECK ( name ~ '^\\w+$' ),
344 age INTERVAL NOT NULL,
347 COMMENT ON TABLE config.rule_age_hold_protect IS $$
349 * Copyright (C) 2005 Georgia Public Library Service
350 * Mike Rylander <mrylander@gmail.com>
352 * Hold Item Age Protection rules
354 * A hold request can only capture new(ish) items when they are
355 * within a particular proximity of the home_ou of the requesting
356 * user. The proximity ('prox' column) is calculated by counting
357 * the number of tree edges beween the user's home_ou and the owning_lib
358 * of the copy that could fulfill the hold.
363 * This program is free software; you can redistribute it and/or
364 * modify it under the terms of the GNU General Public License
365 * as published by the Free Software Foundation; either version 2
366 * of the License, or (at your option) any later version.
368 * This program is distributed in the hope that it will be useful,
369 * but WITHOUT ANY WARRANTY; without even the implied warranty of
370 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
371 * GNU General Public License for more details.
375 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '3month', '3 mons', 0);
376 INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '6month', '6 mons', 2);
379 CREATE TABLE config.copy_status (
380 id SERIAL PRIMARY KEY,
381 name TEXT NOT NULL UNIQUE,
382 holdable BOOL NOT NULL DEFAULT FALSE
384 COMMENT ON TABLE config.copy_status IS $$
386 * Copyright (C) 2005 Georgia Public Library Service
387 * Mike Rylander <mrylander@gmail.com>
391 * The available copy statuses, and whether a copy in that
392 * status is available for hold request capture. 0 (zero) is
393 * the only special number in this set, meaning that the item
394 * is available for imediate checkout, and is counted as available
397 * Statuses with an ID below 100 are not removable, and have special
398 * meaning in the code. Do not change them except to translate the
401 * You may add and remove statuses above 100, and these can be used
402 * to remove items from normal circulation without affecting the rest
403 * of the copy's values or it's location.
407 * This program is free software; you can redistribute it and/or
408 * modify it under the terms of the GNU General Public License
409 * as published by the Free Software Foundation; either version 2
410 * of the License, or (at your option) any later version.
412 * This program is distributed in the hope that it will be useful,
413 * but WITHOUT ANY WARRANTY; without even the implied warranty of
414 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
415 * GNU General Public License for more details.
419 INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t');
420 INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t');
421 INSERT INTO config.copy_status (name) VALUES ('Bindery');
422 INSERT INTO config.copy_status (name) VALUES ('Lost');
423 INSERT INTO config.copy_status (name) VALUES ('Missing');
424 INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t');
425 INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t');
426 INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t');
427 INSERT INTO config.copy_status (name,holdable) VALUES ('On holds shelf','t');
428 INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t');
429 INSERT INTO config.copy_status (name) VALUES ('ILL');
430 INSERT INTO config.copy_status (name) VALUES ('Cataloging');
431 INSERT INTO config.copy_status (name) VALUES ('Reserves');
432 INSERT INTO config.copy_status (name) VALUES ('Discard/Weed');
433 INSERT INTO config.copy_status (name) VALUES ('Damaged');
435 SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100);
438 CREATE TABLE config.net_access_level (
439 id SERIAL PRIMARY KEY,
440 name TEXT NOT NULL UNIQUE
442 COMMENT ON TABLE config.net_access_level IS $$
444 * Copyright (C) 2005 Georgia Public Library Service
445 * Mike Rylander <mrylander@gmail.com>
447 * Patron Network Access level
449 * This will be used to inform the in-library firewall of how much
450 * internet access the using patron should be allowed.
454 * This program is free software; you can redistribute it and/or
455 * modify it under the terms of the GNU General Public License
456 * as published by the Free Software Foundation; either version 2
457 * of the License, or (at your option) any later version.
459 * This program is distributed in the hope that it will be useful,
460 * but WITHOUT ANY WARRANTY; without even the implied warranty of
461 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
462 * GNU General Public License for more details.
466 INSERT INTO config.net_access_level (name) VALUES ('Filtered');
467 INSERT INTO config.net_access_level (name) VALUES ('Unfiltered');
468 INSERT INTO config.net_access_level (name) VALUES ('No Access');
470 CREATE TABLE config.audience_map (
471 code TEXT PRIMARY KEY,
476 COPY config.audience_map FROM STDIN;
477 Unknown or unspecified The target audience for the item not known or not specified.
478 a Preschool The item is intended for children, approximate ages 0-5 years.
479 b Primary The item is intended for children, approximate ages 6-8 years.
480 c Pre-adolescent The item is intended for young people, approximate ages 9-13 years.
481 d Adolescent The item is intended for young people, approximate ages 14-17 years.
482 e Adult The item is intended for adults.
483 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.
484 g General The item is of general interest and not aimed at an audience of a particular intellectual level.
485 j Juvenile The item is intended for children and young people, approximate ages 0-15 years.
489 CREATE TABLE config.lit_form_map (
490 code TEXT PRIMARY KEY,
495 COPY config.lit_form_map FROM STDIN;
496 0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired
497 1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired
502 h Humor, satires, etc. The item is a humorous work, satire or of similar literary form.
503 i Letters The item is a single letter or collection of correspondence.
504 j Short stories The item is a short story or collection of short stories.
505 m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories).
506 p Poetry The item is a poem or collection of poems.
507 s Speeches The item is a speech or collection of speeches.
508 u Unknown The literary form of the item is unknown.
511 CREATE TABLE config.language_map (
512 code TEXT PRIMARY KEY,
516 COPY config.language_map FROM STDIN;
523 afa Afroasiatic (Other)
524 afh Afrihili (Artificial language)
531 alg Algonquian (Other)
533 ang English, Old (ca. 450-1100)
537 arg Aragonese Spanish
541 art Artificial (Other)
545 ath Athapascan (Other)
546 aus Australian languages
553 bai Bamileke languages
582 cai Central American Indian (Other)
586 cau Caucasian (Other)
607 cpe Creoles and Pidgins, English-based (Other)
608 cpf Creoles and Pidgins, French-based (Other)
609 cpp Creoles and Pidgins, Portuguese-based (Other)
612 crp Creoles and Pidgins (Other)
625 dra Dravidian (Other)
627 dum Dutch, Middle (ca. 1050-1350)
636 enm English, Middle (1100-1500)
638 -esk Eskimo languages
650 fiu Finno-Ugrian (Other)
654 frm French, Middle (ca. 1400-1600)
655 fro French, Old (ca. 842-1400)
674 gmh German, Middle High (ca. 1050-1500)
675 goh German, Old High (ca. 750-1050)
680 grc Greek, Ancient (to 1453)
681 gre Greek, Modern (1453- )
687 hat Haitian French Creole
709 ina Interlingua (International Auxiliary Language Association)
712 ine Indo-European (Other)
714 -int Interlingua (International Auxiliary Language Association)
718 iro Iroquoian (Other)
760 -lan Occitan (post-1500)
777 luo Luo (Kenya and Tanzania)
788 map Austronesian (Other)
795 mga Irish, Middle (ca. 1100-1550)
798 mis Miscellaneous languages
799 mkh Mon-Khmer (Other)
810 mul Multiple languages
816 nai North American Indian (Other)
817 nap Neapolitan Italian
820 nbl Ndebele (South Africa)
821 nde Ndebele (Zimbabwe)
827 nic Niger-Kordofanian (Other)
829 nno Norwegian (Nynorsk)
830 nob Norwegian (Bokmål)
841 oci Occitan (post-1500)
848 oto Otomian languages
856 peo Old Persian (ca. 600-400 B.C.)
858 phi Philippine (Other)
864 pra Prakrit languages
865 pro Provençal (to 1500)
878 sag Sango (Ubangi Creole)
880 sai South American Indian (Other)
881 sal Salishan languages
882 sam Samaritan Aramaic
892 sga Irish, Old (to 1100)
899 sit Sino-Tibetan (Other)
921 ssa Nilo-Saharan (Other)
982 wak Wakashan languages
987 wen Sorbian languages
1005 CREATE TABLE config.item_form_map (
1006 code TEXT PRIMARY KEY,
1010 COPY config.item_form_map FROM STDIN;
1016 r Regular print reproduction
1020 CREATE TABLE config.item_type_map (
1021 code TEXT PRIMARY KEY,
1025 COPY config.item_type_map FROM STDIN;
1027 t Manuscript language material
1029 k Two-dimensional nonprojectable graphic
1030 r Three-dimensional artifact or naturally occurring object
1033 e Cartographic material
1034 f Manuscript cartographic material
1036 d Manuscript notated music
1037 i Nonmusical sound recording
1038 j Musical sound recording