1 --002.schema.config.sql:
2 INSERT INTO config.bib_source (id, quality, source, transcendant) VALUES
3 (1, 90, oils_i18n_gettext(1, 'oclc', 'cbs', 'source'), FALSE);
4 INSERT INTO config.bib_source (id, quality, source, transcendant) VALUES
5 (2, 10, oils_i18n_gettext(2, 'System Local', 'cbs', 'source'), FALSE);
6 INSERT INTO config.bib_source (id, quality, source, transcendant) VALUES
7 (3, 1, oils_i18n_gettext(3, 'Project Gutenberg', 'cbs', 'source'), TRUE);
8 SELECT SETVAL('config.bib_source_id_seq'::TEXT, 100);
10 INSERT INTO config.standing (id, value) VALUES (1, oils_i18n_gettext(1, 'Good', 'cst', 'value'));
11 INSERT INTO config.standing (id, value) VALUES (2, oils_i18n_gettext(2, 'Barred', 'cst', 'value'));
12 SELECT SETVAL('config.standing_id_seq'::TEXT, 100);
14 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
15 ( 'series', 'seriestitle', 'mods32', $$//mods32:mods/mods32:relatedItem[@type="series"]/mods32:titleInfo$$ );
16 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
17 ( 'title', 'abbreviated', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='abbreviated')]$$ );
18 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
19 ( 'title', 'translated', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='translated')]$$ );
20 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
21 ( 'title', 'alternative', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='alternative')]$$ );
22 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
23 ( 'title', 'uniform', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and (@type='uniform')]$$ );
24 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
25 ( 'title', 'proper', 'mods32', $$//mods32:mods/mods32:titleInfo[mods32:title and not (@type)]$$ );
26 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
27 ( 'author', 'corporate', 'mods32', $$//mods32:mods/mods32:name[@type='corporate']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']]$$ );
28 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
29 ( 'author', 'personal', 'mods32', $$//mods32:mods/mods32:name[@type='personal']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']]$$ );
30 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
31 ( 'author', 'conference', 'mods32', $$//mods32:mods/mods32:name[@type='conference']/mods32:namePart[../mods32:role/mods32:roleTerm[text()='creator']]$$ );
32 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
33 ( 'author', 'other', 'mods32', $$//mods32:mods/mods32:name[@type='personal']/mods32:namePart[not(../mods32:role)]$$ );
34 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
35 ( 'subject', 'geographic', 'mods32', $$//mods32:mods/mods32:subject/mods32:geographic$$ );
36 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
37 ( 'subject', 'name', 'mods32', $$//mods32:mods/mods32:subject/mods32:name$$ );
38 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
39 ( 'subject', 'temporal', 'mods32', $$//mods32:mods/mods32:subject/mods32:temporal$$ );
40 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
41 ( 'subject', 'topic', 'mods32', $$//mods32:mods/mods32:subject/mods32:topic$$ );
42 --INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
43 -- ( field_class, name, xpath ) VALUES ( 'subject', 'genre', 'mods32', $$//mods32:mods/mods32:genre$$ );
44 INSERT INTO config.metabib_field ( field_class, name, format, xpath ) VALUES
45 ( 'keyword', 'keyword', 'mods32', $$//mods32:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */;
47 INSERT INTO config.non_cataloged_type ( id, owning_lib, name ) VALUES ( 1, 1, oils_i18n_gettext(1, 'Paperback Book', 'cnct', 'name') );
48 SELECT SETVAL('config.non_cataloged_type_id_seq'::TEXT, 100);
50 INSERT INTO config.identification_type ( id, name ) VALUES
51 ( 1, oils_i18n_gettext(1, 'Drivers License', 'cit', 'name') );
52 INSERT INTO config.identification_type ( id, name ) VALUES
53 ( 2, oils_i18n_gettext(2, 'SSN', 'cit', 'name') );
54 INSERT INTO config.identification_type ( id, name ) VALUES
55 ( 3, oils_i18n_gettext(3, 'Other', 'cit', 'name') );
56 SELECT SETVAL('config.identification_type_id_seq'::TEXT, 100);
58 INSERT INTO config.rule_circ_duration VALUES
59 (1, oils_i18n_gettext(1, '7_days_0_renew', 'crcd', 'name'), '7 days', '7 days', '7 days', 0);
60 INSERT INTO config.rule_circ_duration VALUES
61 (2, oils_i18n_gettext(2, '28_days_2_renew', 'crcd', 'name'), '28 days', '28 days', '28 days', 2);
62 INSERT INTO config.rule_circ_duration VALUES
63 (3, oils_i18n_gettext(3, '3_months_0_renew', 'crcd', 'name'), '3 months', '3 months', '3 months', 0);
64 INSERT INTO config.rule_circ_duration VALUES
65 (4, oils_i18n_gettext(4, '3_days_1_renew', 'crcd', 'name'), '3 days', '3 days', '3 days', 1);
66 INSERT INTO config.rule_circ_duration VALUES
67 (5, oils_i18n_gettext(5, '2_months_2_renew', 'crcd', 'name'), '2 months', '2 months', '2 months', 2);
68 INSERT INTO config.rule_circ_duration VALUES
69 (6, oils_i18n_gettext(6, '35_days_1_renew', 'crcd', 'name'), '35 days', '35 days', '35 days', 1);
70 INSERT INTO config.rule_circ_duration VALUES
71 (7, oils_i18n_gettext(7, '7_days_2_renew', 'crcd', 'name'), '7 days', '7 days', '7 days', 2);
72 INSERT INTO config.rule_circ_duration VALUES
73 (8, oils_i18n_gettext(8, '1_hour_2_renew', 'crcd', 'name'), '1 hour', '1 hour', '1 hour', 2);
74 INSERT INTO config.rule_circ_duration VALUES
75 (9, oils_i18n_gettext(9, '28_days_0_renew', 'crcd', 'name'), '28 days', '28 days', '28 days', 0);
76 INSERT INTO config.rule_circ_duration VALUES
77 (10, oils_i18n_gettext(10, '14_days_2_renew', 'crcd', 'name'), '14 days', '14 days', '14 days', 2);
78 INSERT INTO config.rule_circ_duration VALUES
79 (11, oils_i18n_gettext(11, 'default', 'crcd', 'name'), '21 days', '14 days', '7 days', 2);
80 SELECT SETVAL('config.rule_circ_duration_id_seq'::TEXT, 100);
82 INSERT INTO config.rule_max_fine VALUES
83 (1, oils_i18n_gettext(1, 'default', 'crmf', 'name'), 5.00);
84 INSERT INTO config.rule_max_fine VALUES
85 (2, oils_i18n_gettext(2, 'overdue_min', 'crmf', 'name'), 5.00);
86 INSERT INTO config.rule_max_fine VALUES
87 (3, oils_i18n_gettext(3, 'overdue_mid', 'crmf', 'name'), 10.00);
88 INSERT INTO config.rule_max_fine VALUES
89 (4, oils_i18n_gettext(4, 'overdue_max', 'crmf', 'name'), 100.00);
90 INSERT INTO config.rule_max_fine VALUES
91 (5, oils_i18n_gettext(5, 'overdue_equip_min', 'crmf', 'name'), 25.00);
92 INSERT INTO config.rule_max_fine VALUES
93 (6, oils_i18n_gettext(6, 'overdue_equip_mid', 'crmf', 'name'), 25.00);
94 INSERT INTO config.rule_max_fine VALUES
95 (7, oils_i18n_gettext(7, 'overdue_equip_max', 'crmf', 'name'), 100.00);
96 SELECT SETVAL('config.rule_max_fine_id_seq'::TEXT, 100);
98 INSERT INTO config.rule_recuring_fine VALUES
99 (1, oils_i18n_gettext(1, 'default', 'crrf', 'name'), 0.50, 0.10, 0.05, '1 day');
100 INSERT INTO config.rule_recuring_fine VALUES
101 (2, oils_i18n_gettext(2, '10_cent_per_day', 'crrf', 'name'), 0.50, 0.10, 0.10, '1 day');
102 INSERT INTO config.rule_recuring_fine VALUES
103 (3, oils_i18n_gettext(3, '50_cent_per_day', 'crrf', 'name'), 0.50, 0.50, 0.50, '1 day');
104 SELECT SETVAL('config.rule_recuring_fine_id_seq'::TEXT, 100);
106 INSERT INTO config.rule_age_hold_protect VALUES
107 (1, oils_i18n_gettext(1, '3month', 'crahp', 'name'), '3 months', 0);
108 INSERT INTO config.rule_age_hold_protect VALUES
109 (2, oils_i18n_gettext(2, '6month', 'crahp', 'name'), '6 months', 2);
110 SELECT SETVAL('config.rule_age_hold_protect_id_seq'::TEXT, 100);
112 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (0,oils_i18n_gettext(0, 'Available', 'ccs', 'name'),'t','t');
113 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (1,oils_i18n_gettext(1, 'Checked out', 'ccs', 'name'),'t','t');
114 INSERT INTO config.copy_status (id,name) VALUES (2,oils_i18n_gettext(2, 'Bindery', 'ccs', 'name'));
115 INSERT INTO config.copy_status (id,name) VALUES (3,oils_i18n_gettext(3, 'Lost', 'ccs', 'name'));
116 INSERT INTO config.copy_status (id,name) VALUES (4,oils_i18n_gettext(4, 'Missing', 'ccs', 'name'));
117 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (5,oils_i18n_gettext(5, 'In process', 'ccs', 'name'),'t','t');
118 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (6,oils_i18n_gettext(6, 'In transit', 'ccs', 'name'),'t','t');
119 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (7,oils_i18n_gettext(7, 'Reshelving', 'ccs', 'name'),'t','t');
120 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (8,oils_i18n_gettext(8, 'On holds shelf', 'ccs', 'name'),'t','t');
121 INSERT INTO config.copy_status (id,name,holdable,opac_visible) VALUES (9,oils_i18n_gettext(9, 'On order', 'ccs', 'name'),'t','t');
122 INSERT INTO config.copy_status (id,name) VALUES (10,oils_i18n_gettext(10, 'ILL', 'ccs', 'name'));
123 INSERT INTO config.copy_status (id,name) VALUES (11,oils_i18n_gettext(11, 'Cataloging', 'ccs', 'name'));
124 INSERT INTO config.copy_status (id,name,opac_visible) VALUES (12,oils_i18n_gettext(12, 'Reserves', 'ccs', 'name'),'t');
125 INSERT INTO config.copy_status (id,name) VALUES (13,oils_i18n_gettext(13, 'Discard/Weed', 'ccs', 'name'));
126 INSERT INTO config.copy_status (id,name) VALUES (14,oils_i18n_gettext(14, 'Damaged', 'ccs', 'name'));
128 SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100);
130 INSERT INTO config.net_access_level (id, name) VALUES
131 (1, oils_i18n_gettext(1, 'Filtered', 'cnal', 'name'));
132 INSERT INTO config.net_access_level (id, name) VALUES
133 (2, oils_i18n_gettext(2, 'Unfiltered', 'cnal', 'name'));
134 INSERT INTO config.net_access_level (id, name) VALUES
135 (3, oils_i18n_gettext(3, 'No Access', 'cnal', 'name'));
136 SELECT SETVAL('config.net_access_level_id_seq'::TEXT, 100);
138 INSERT INTO config.audience_map (code, value, description) VALUES
139 ('', oils_i18n_gettext('', 'Unknown or unspecified', 'cam', 'value'),
140 oils_i18n_gettext('', 'The target audience for the item not known or not specified.', 'cam', 'description'));
141 INSERT INTO config.audience_map (code, value, description) VALUES
142 ('a', oils_i18n_gettext('a', 'Preschool', 'cam', 'value'),
143 oils_i18n_gettext('a', 'The item is intended for children, approximate ages 0-5 years.', 'cam', 'description'));
144 INSERT INTO config.audience_map (code, value, description) VALUES
145 ('b', oils_i18n_gettext('b', 'Primary', 'cam', 'value'),
146 oils_i18n_gettext('b', 'The item is intended for children, approximate ages 6-8 years.', 'cam', 'description'));
147 INSERT INTO config.audience_map (code, value, description) VALUES
148 ('c', oils_i18n_gettext('c', 'Pre-adolescent', 'cam', 'value'),
149 oils_i18n_gettext('c', 'The item is intended for young people, approximate ages 9-13 years.', 'cam', 'description'));
150 INSERT INTO config.audience_map (code, value, description) VALUES
151 ('d', oils_i18n_gettext('d', 'Adolescent', 'cam', 'value'),
152 oils_i18n_gettext('d', 'The item is intended for young people, approximate ages 14-17 years.', 'cam', 'description'));
153 INSERT INTO config.audience_map (code, value, description) VALUES
154 ('e', oils_i18n_gettext('e', 'Adult', 'cam', 'value'),
155 oils_i18n_gettext('e', 'The item is intended for adults.', 'cam', 'description'));
156 INSERT INTO config.audience_map (code, value, description) VALUES
157 ('f', oils_i18n_gettext('f', 'Specialized', 'cam', 'value'),
158 oils_i18n_gettext('f', 'The item is aimed at a particular audience and the nature of the presentation makes the item of little interest to another audience.', 'cam', 'description'));
159 INSERT INTO config.audience_map (code, value, description) VALUES
160 ('g', oils_i18n_gettext('g', 'General', 'cam', 'value'),
161 oils_i18n_gettext('g', 'The item is of general interest and not aimed at an audience of a particular intellectual level.', 'cam', 'description'));
162 INSERT INTO config.audience_map (code, value, description) VALUES
163 ('j', oils_i18n_gettext('j', 'Juvenile', 'cam', 'value'),
164 oils_i18n_gettext('j', 'The item is intended for children and young people, approximate ages 0-15 years.', 'cam', 'description'));
166 INSERT INTO config.lit_form_map (code, value, description) VALUES
167 ('0', oils_i18n_gettext('0', 'Not fiction (not further specified)', 'clfm', 'value'),
168 oils_i18n_gettext('0', 'The item is not a work of fiction and no further identification of the literary form is desired', 'clfm', 'description'));
169 INSERT INTO config.lit_form_map (code, value, description) VALUES
170 ('1', oils_i18n_gettext('1', 'Fiction (not further specified)', 'clfm', 'value'),
171 oils_i18n_gettext('1', 'The item is a work of fiction and no further identification of the literary form is desired', 'clfm', 'description'));
172 INSERT INTO config.lit_form_map (code, value, description) VALUES
173 ('c', oils_i18n_gettext('c', 'Comic strips', 'clfm', 'value'), NULL);
174 INSERT INTO config.lit_form_map (code, value, description) VALUES
175 ('d', oils_i18n_gettext('d', 'Dramas', 'clfm', 'value'), NULL);
176 INSERT INTO config.lit_form_map (code, value, description) VALUES
177 ('e', oils_i18n_gettext('e', 'Essays', 'clfm', 'value'), NULL);
178 INSERT INTO config.lit_form_map (code, value, description) VALUES
179 ('f', oils_i18n_gettext('f', 'Novels', 'clfm', 'value'), NULL);
180 INSERT INTO config.lit_form_map (code, value, description) VALUES
181 ('h', oils_i18n_gettext('h', 'Humor, satires, etc.', 'clfm', 'value'),
182 oils_i18n_gettext('h', 'The item is a humorous work, satire or of similar literary form.', 'clfm', 'description'));
183 INSERT INTO config.lit_form_map (code, value, description) VALUES
184 ('i', oils_i18n_gettext('i', 'Letters', 'clfm', 'value'),
185 oils_i18n_gettext('i', 'The item is a single letter or collection of correspondence.', 'clfm', 'description'));
186 INSERT INTO config.lit_form_map (code, value, description) VALUES
187 ('j', oils_i18n_gettext('j', 'Short stories', 'clfm', 'value'),
188 oils_i18n_gettext('j', 'The item is a short story or collection of short stories.', 'clfm', 'description'));
189 INSERT INTO config.lit_form_map (code, value, description) VALUES
190 ('m', oils_i18n_gettext('m', 'Mixed forms', 'clfm', 'value'),
191 oils_i18n_gettext('m', 'The item is a variety of literary forms (e.g., poetry and short stories).', 'clfm', 'description'));
192 INSERT INTO config.lit_form_map (code, value, description) VALUES
193 ('p', oils_i18n_gettext('p', 'Poetry', 'clfm', 'value'),
194 oils_i18n_gettext('p', 'The item is a poem or collection of poems.', 'clfm', 'description'));
195 INSERT INTO config.lit_form_map (code, value, description) VALUES
196 ('s', oils_i18n_gettext('s', 'Speeches', 'clfm', 'value'),
197 oils_i18n_gettext('s', 'The item is a speech or collection of speeches.', 'clfm', 'description'));
198 INSERT INTO config.lit_form_map (code, value, description) VALUES
199 ('u', oils_i18n_gettext('u', 'Unknown', 'clfm', 'value'),
200 oils_i18n_gettext('u', 'The literary form of the item is unknown.', 'clfm', 'description'));
202 -- TO-DO: Auto-generate these values from CLDR
203 -- XXX These are the values used in MARC records ... does that match CLDR, including deprecated languages?
204 INSERT INTO config.language_map (code, value) VALUES ('aar', oils_i18n_gettext('aar', 'Afar', 'clm', 'value'));
205 INSERT INTO config.language_map (code, value) VALUES ('abk', oils_i18n_gettext('abk', 'Abkhaz', 'clm', 'value'));
206 INSERT INTO config.language_map (code, value) VALUES ('ace', oils_i18n_gettext('ace', 'Achinese', 'clm', 'value'));
207 INSERT INTO config.language_map (code, value) VALUES ('ach', oils_i18n_gettext('ach', 'Acoli', 'clm', 'value'));
208 INSERT INTO config.language_map (code, value) VALUES ('ada', oils_i18n_gettext('ada', 'Adangme', 'clm', 'value'));
209 INSERT INTO config.language_map (code, value) VALUES ('ady', oils_i18n_gettext('ady', 'Adygei', 'clm', 'value'));
210 INSERT INTO config.language_map (code, value) VALUES ('afa', oils_i18n_gettext('afa', 'Afroasiatic (Other)', 'clm', 'value'));
211 INSERT INTO config.language_map (code, value) VALUES ('afh', oils_i18n_gettext('afh', 'Afrihili (Artificial language)', 'clm', 'value'));
212 INSERT INTO config.language_map (code, value) VALUES ('afr', oils_i18n_gettext('afr', 'Afrikaans', 'clm', 'value'));
213 INSERT INTO config.language_map (code, value) VALUES ('-ajm', oils_i18n_gettext('-ajm', 'AljamÃa', 'clm', 'value'));
214 INSERT INTO config.language_map (code, value) VALUES ('aka', oils_i18n_gettext('aka', 'Akan', 'clm', 'value'));
215 INSERT INTO config.language_map (code, value) VALUES ('akk', oils_i18n_gettext('akk', 'Akkadian', 'clm', 'value'));
216 INSERT INTO config.language_map (code, value) VALUES ('alb', oils_i18n_gettext('alb', 'Albanian', 'clm', 'value'));
217 INSERT INTO config.language_map (code, value) VALUES ('ale', oils_i18n_gettext('ale', 'Aleut', 'clm', 'value'));
218 INSERT INTO config.language_map (code, value) VALUES ('alg', oils_i18n_gettext('alg', 'Algonquian (Other)', 'clm', 'value'));
219 INSERT INTO config.language_map (code, value) VALUES ('amh', oils_i18n_gettext('amh', 'Amharic', 'clm', 'value'));
220 INSERT INTO config.language_map (code, value) VALUES ('ang', oils_i18n_gettext('ang', 'English, Old (ca. 450-1100)', 'clm', 'value'));
221 INSERT INTO config.language_map (code, value) VALUES ('apa', oils_i18n_gettext('apa', 'Apache languages', 'clm', 'value'));
222 INSERT INTO config.language_map (code, value) VALUES ('ara', oils_i18n_gettext('ara', 'Arabic', 'clm', 'value'));
223 INSERT INTO config.language_map (code, value) VALUES ('arc', oils_i18n_gettext('arc', 'Aramaic', 'clm', 'value'));
224 INSERT INTO config.language_map (code, value) VALUES ('arg', oils_i18n_gettext('arg', 'Aragonese Spanish', 'clm', 'value'));
225 INSERT INTO config.language_map (code, value) VALUES ('arm', oils_i18n_gettext('arm', 'Armenian', 'clm', 'value'));
226 INSERT INTO config.language_map (code, value) VALUES ('arn', oils_i18n_gettext('arn', 'Mapuche', 'clm', 'value'));
227 INSERT INTO config.language_map (code, value) VALUES ('arp', oils_i18n_gettext('arp', 'Arapaho', 'clm', 'value'));
228 INSERT INTO config.language_map (code, value) VALUES ('art', oils_i18n_gettext('art', 'Artificial (Other)', 'clm', 'value'));
229 INSERT INTO config.language_map (code, value) VALUES ('arw', oils_i18n_gettext('arw', 'Arawak', 'clm', 'value'));
230 INSERT INTO config.language_map (code, value) VALUES ('asm', oils_i18n_gettext('asm', 'Assamese', 'clm', 'value'));
231 INSERT INTO config.language_map (code, value) VALUES ('ast', oils_i18n_gettext('ast', 'Bable', 'clm', 'value'));
232 INSERT INTO config.language_map (code, value) VALUES ('ath', oils_i18n_gettext('ath', 'Athapascan (Other)', 'clm', 'value'));
233 INSERT INTO config.language_map (code, value) VALUES ('aus', oils_i18n_gettext('aus', 'Australian languages', 'clm', 'value'));
234 INSERT INTO config.language_map (code, value) VALUES ('ava', oils_i18n_gettext('ava', 'Avaric', 'clm', 'value'));
235 INSERT INTO config.language_map (code, value) VALUES ('ave', oils_i18n_gettext('ave', 'Avestan', 'clm', 'value'));
236 INSERT INTO config.language_map (code, value) VALUES ('awa', oils_i18n_gettext('awa', 'Awadhi', 'clm', 'value'));
237 INSERT INTO config.language_map (code, value) VALUES ('aym', oils_i18n_gettext('aym', 'Aymara', 'clm', 'value'));
238 INSERT INTO config.language_map (code, value) VALUES ('aze', oils_i18n_gettext('aze', 'Azerbaijani', 'clm', 'value'));
239 INSERT INTO config.language_map (code, value) VALUES ('bad', oils_i18n_gettext('bad', 'Banda', 'clm', 'value'));
240 INSERT INTO config.language_map (code, value) VALUES ('bai', oils_i18n_gettext('bai', 'Bamileke languages', 'clm', 'value'));
241 INSERT INTO config.language_map (code, value) VALUES ('bak', oils_i18n_gettext('bak', 'Bashkir', 'clm', 'value'));
242 INSERT INTO config.language_map (code, value) VALUES ('bal', oils_i18n_gettext('bal', 'Baluchi', 'clm', 'value'));
243 INSERT INTO config.language_map (code, value) VALUES ('bam', oils_i18n_gettext('bam', 'Bambara', 'clm', 'value'));
244 INSERT INTO config.language_map (code, value) VALUES ('ban', oils_i18n_gettext('ban', 'Balinese', 'clm', 'value'));
245 INSERT INTO config.language_map (code, value) VALUES ('baq', oils_i18n_gettext('baq', 'Basque', 'clm', 'value'));
246 INSERT INTO config.language_map (code, value) VALUES ('bas', oils_i18n_gettext('bas', 'Basa', 'clm', 'value'));
247 INSERT INTO config.language_map (code, value) VALUES ('bat', oils_i18n_gettext('bat', 'Baltic (Other)', 'clm', 'value'));
248 INSERT INTO config.language_map (code, value) VALUES ('bej', oils_i18n_gettext('bej', 'Beja', 'clm', 'value'));
249 INSERT INTO config.language_map (code, value) VALUES ('bel', oils_i18n_gettext('bel', 'Belarusian', 'clm', 'value'));
250 INSERT INTO config.language_map (code, value) VALUES ('bem', oils_i18n_gettext('bem', 'Bemba', 'clm', 'value'));
251 INSERT INTO config.language_map (code, value) VALUES ('ben', oils_i18n_gettext('ben', 'Bengali', 'clm', 'value'));
252 INSERT INTO config.language_map (code, value) VALUES ('ber', oils_i18n_gettext('ber', 'Berber (Other)', 'clm', 'value'));
253 INSERT INTO config.language_map (code, value) VALUES ('bho', oils_i18n_gettext('bho', 'Bhojpuri', 'clm', 'value'));
254 INSERT INTO config.language_map (code, value) VALUES ('bih', oils_i18n_gettext('bih', 'Bihari', 'clm', 'value'));
255 INSERT INTO config.language_map (code, value) VALUES ('bik', oils_i18n_gettext('bik', 'Bikol', 'clm', 'value'));
256 INSERT INTO config.language_map (code, value) VALUES ('bin', oils_i18n_gettext('bin', 'Edo', 'clm', 'value'));
257 INSERT INTO config.language_map (code, value) VALUES ('bis', oils_i18n_gettext('bis', 'Bislama', 'clm', 'value'));
258 INSERT INTO config.language_map (code, value) VALUES ('bla', oils_i18n_gettext('bla', 'Siksika', 'clm', 'value'));
259 INSERT INTO config.language_map (code, value) VALUES ('bnt', oils_i18n_gettext('bnt', 'Bantu (Other)', 'clm', 'value'));
260 INSERT INTO config.language_map (code, value) VALUES ('bos', oils_i18n_gettext('bos', 'Bosnian', 'clm', 'value'));
261 INSERT INTO config.language_map (code, value) VALUES ('bra', oils_i18n_gettext('bra', 'Braj', 'clm', 'value'));
262 INSERT INTO config.language_map (code, value) VALUES ('bre', oils_i18n_gettext('bre', 'Breton', 'clm', 'value'));
263 INSERT INTO config.language_map (code, value) VALUES ('btk', oils_i18n_gettext('btk', 'Batak', 'clm', 'value'));
264 INSERT INTO config.language_map (code, value) VALUES ('bua', oils_i18n_gettext('bua', 'Buriat', 'clm', 'value'));
265 INSERT INTO config.language_map (code, value) VALUES ('bug', oils_i18n_gettext('bug', 'Bugis', 'clm', 'value'));
266 INSERT INTO config.language_map (code, value) VALUES ('bul', oils_i18n_gettext('bul', 'Bulgarian', 'clm', 'value'));
267 INSERT INTO config.language_map (code, value) VALUES ('bur', oils_i18n_gettext('bur', 'Burmese', 'clm', 'value'));
268 INSERT INTO config.language_map (code, value) VALUES ('cad', oils_i18n_gettext('cad', 'Caddo', 'clm', 'value'));
269 INSERT INTO config.language_map (code, value) VALUES ('cai', oils_i18n_gettext('cai', 'Central American Indian (Other)', 'clm', 'value'));
270 INSERT INTO config.language_map (code, value) VALUES ('-cam', oils_i18n_gettext('-cam', 'Khmer', 'clm', 'value'));
271 INSERT INTO config.language_map (code, value) VALUES ('car', oils_i18n_gettext('car', 'Carib', 'clm', 'value'));
272 INSERT INTO config.language_map (code, value) VALUES ('cat', oils_i18n_gettext('cat', 'Catalan', 'clm', 'value'));
273 INSERT INTO config.language_map (code, value) VALUES ('cau', oils_i18n_gettext('cau', 'Caucasian (Other)', 'clm', 'value'));
274 INSERT INTO config.language_map (code, value) VALUES ('ceb', oils_i18n_gettext('ceb', 'Cebuano', 'clm', 'value'));
275 INSERT INTO config.language_map (code, value) VALUES ('cel', oils_i18n_gettext('cel', 'Celtic (Other)', 'clm', 'value'));
276 INSERT INTO config.language_map (code, value) VALUES ('cha', oils_i18n_gettext('cha', 'Chamorro', 'clm', 'value'));
277 INSERT INTO config.language_map (code, value) VALUES ('chb', oils_i18n_gettext('chb', 'Chibcha', 'clm', 'value'));
278 INSERT INTO config.language_map (code, value) VALUES ('che', oils_i18n_gettext('che', 'Chechen', 'clm', 'value'));
279 INSERT INTO config.language_map (code, value) VALUES ('chg', oils_i18n_gettext('chg', 'Chagatai', 'clm', 'value'));
280 INSERT INTO config.language_map (code, value) VALUES ('chi', oils_i18n_gettext('chi', 'Chinese', 'clm', 'value'));
281 INSERT INTO config.language_map (code, value) VALUES ('chk', oils_i18n_gettext('chk', 'Truk', 'clm', 'value'));
282 INSERT INTO config.language_map (code, value) VALUES ('chm', oils_i18n_gettext('chm', 'Mari', 'clm', 'value'));
283 INSERT INTO config.language_map (code, value) VALUES ('chn', oils_i18n_gettext('chn', 'Chinook jargon', 'clm', 'value'));
284 INSERT INTO config.language_map (code, value) VALUES ('cho', oils_i18n_gettext('cho', 'Choctaw', 'clm', 'value'));
285 INSERT INTO config.language_map (code, value) VALUES ('chp', oils_i18n_gettext('chp', 'Chipewyan', 'clm', 'value'));
286 INSERT INTO config.language_map (code, value) VALUES ('chr', oils_i18n_gettext('chr', 'Cherokee', 'clm', 'value'));
287 INSERT INTO config.language_map (code, value) VALUES ('chu', oils_i18n_gettext('chu', 'Church Slavic', 'clm', 'value'));
288 INSERT INTO config.language_map (code, value) VALUES ('chv', oils_i18n_gettext('chv', 'Chuvash', 'clm', 'value'));
289 INSERT INTO config.language_map (code, value) VALUES ('chy', oils_i18n_gettext('chy', 'Cheyenne', 'clm', 'value'));
290 INSERT INTO config.language_map (code, value) VALUES ('cmc', oils_i18n_gettext('cmc', 'Chamic languages', 'clm', 'value'));
291 INSERT INTO config.language_map (code, value) VALUES ('cop', oils_i18n_gettext('cop', 'Coptic', 'clm', 'value'));
292 INSERT INTO config.language_map (code, value) VALUES ('cor', oils_i18n_gettext('cor', 'Cornish', 'clm', 'value'));
293 INSERT INTO config.language_map (code, value) VALUES ('cos', oils_i18n_gettext('cos', 'Corsican', 'clm', 'value'));
294 INSERT INTO config.language_map (code, value) VALUES ('cpe', oils_i18n_gettext('cpe', 'Creoles and Pidgins, English-based (Other)', 'clm', 'value'));
295 INSERT INTO config.language_map (code, value) VALUES ('cpf', oils_i18n_gettext('cpf', 'Creoles and Pidgins, French-based (Other)', 'clm', 'value'));
296 INSERT INTO config.language_map (code, value) VALUES ('cpp', oils_i18n_gettext('cpp', 'Creoles and Pidgins, Portuguese-based (Other)', 'clm', 'value'));
297 INSERT INTO config.language_map (code, value) VALUES ('cre', oils_i18n_gettext('cre', 'Cree', 'clm', 'value'));
298 INSERT INTO config.language_map (code, value) VALUES ('crh', oils_i18n_gettext('crh', 'Crimean Tatar', 'clm', 'value'));
299 INSERT INTO config.language_map (code, value) VALUES ('crp', oils_i18n_gettext('crp', 'Creoles and Pidgins (Other)', 'clm', 'value'));
300 INSERT INTO config.language_map (code, value) VALUES ('cus', oils_i18n_gettext('cus', 'Cushitic (Other)', 'clm', 'value'));
301 INSERT INTO config.language_map (code, value) VALUES ('cze', oils_i18n_gettext('cze', 'Czech', 'clm', 'value'));
302 INSERT INTO config.language_map (code, value) VALUES ('dak', oils_i18n_gettext('dak', 'Dakota', 'clm', 'value'));
303 INSERT INTO config.language_map (code, value) VALUES ('dan', oils_i18n_gettext('dan', 'Danish', 'clm', 'value'));
304 INSERT INTO config.language_map (code, value) VALUES ('dar', oils_i18n_gettext('dar', 'Dargwa', 'clm', 'value'));
305 INSERT INTO config.language_map (code, value) VALUES ('day', oils_i18n_gettext('day', 'Dayak', 'clm', 'value'));
306 INSERT INTO config.language_map (code, value) VALUES ('del', oils_i18n_gettext('del', 'Delaware', 'clm', 'value'));
307 INSERT INTO config.language_map (code, value) VALUES ('den', oils_i18n_gettext('den', 'Slave', 'clm', 'value'));
308 INSERT INTO config.language_map (code, value) VALUES ('dgr', oils_i18n_gettext('dgr', 'Dogrib', 'clm', 'value'));
309 INSERT INTO config.language_map (code, value) VALUES ('din', oils_i18n_gettext('din', 'Dinka', 'clm', 'value'));
310 INSERT INTO config.language_map (code, value) VALUES ('div', oils_i18n_gettext('div', 'Divehi', 'clm', 'value'));
311 INSERT INTO config.language_map (code, value) VALUES ('doi', oils_i18n_gettext('doi', 'Dogri', 'clm', 'value'));
312 INSERT INTO config.language_map (code, value) VALUES ('dra', oils_i18n_gettext('dra', 'Dravidian (Other)', 'clm', 'value'));
313 INSERT INTO config.language_map (code, value) VALUES ('dua', oils_i18n_gettext('dua', 'Duala', 'clm', 'value'));
314 INSERT INTO config.language_map (code, value) VALUES ('dum', oils_i18n_gettext('dum', 'Dutch, Middle (ca. 1050-1350)', 'clm', 'value'));
315 INSERT INTO config.language_map (code, value) VALUES ('dut', oils_i18n_gettext('dut', 'Dutch', 'clm', 'value'));
316 INSERT INTO config.language_map (code, value) VALUES ('dyu', oils_i18n_gettext('dyu', 'Dyula', 'clm', 'value'));
317 INSERT INTO config.language_map (code, value) VALUES ('dzo', oils_i18n_gettext('dzo', 'Dzongkha', 'clm', 'value'));
318 INSERT INTO config.language_map (code, value) VALUES ('efi', oils_i18n_gettext('efi', 'Efik', 'clm', 'value'));
319 INSERT INTO config.language_map (code, value) VALUES ('egy', oils_i18n_gettext('egy', 'Egyptian', 'clm', 'value'));
320 INSERT INTO config.language_map (code, value) VALUES ('eka', oils_i18n_gettext('eka', 'Ekajuk', 'clm', 'value'));
321 INSERT INTO config.language_map (code, value) VALUES ('elx', oils_i18n_gettext('elx', 'Elamite', 'clm', 'value'));
322 INSERT INTO config.language_map (code, value) VALUES ('eng', oils_i18n_gettext('eng', 'English', 'clm', 'value'));
323 INSERT INTO config.language_map (code, value) VALUES ('enm', oils_i18n_gettext('enm', 'English, Middle (1100-1500)', 'clm', 'value'));
324 INSERT INTO config.language_map (code, value) VALUES ('epo', oils_i18n_gettext('epo', 'Esperanto', 'clm', 'value'));
325 INSERT INTO config.language_map (code, value) VALUES ('-esk', oils_i18n_gettext('-esk', 'Eskimo languages', 'clm', 'value'));
326 INSERT INTO config.language_map (code, value) VALUES ('-esp', oils_i18n_gettext('-esp', 'Esperanto', 'clm', 'value'));
327 INSERT INTO config.language_map (code, value) VALUES ('est', oils_i18n_gettext('est', 'Estonian', 'clm', 'value'));
328 INSERT INTO config.language_map (code, value) VALUES ('-eth', oils_i18n_gettext('-eth', 'Ethiopic', 'clm', 'value'));
329 INSERT INTO config.language_map (code, value) VALUES ('ewe', oils_i18n_gettext('ewe', 'Ewe', 'clm', 'value'));
330 INSERT INTO config.language_map (code, value) VALUES ('ewo', oils_i18n_gettext('ewo', 'Ewondo', 'clm', 'value'));
331 INSERT INTO config.language_map (code, value) VALUES ('fan', oils_i18n_gettext('fan', 'Fang', 'clm', 'value'));
332 INSERT INTO config.language_map (code, value) VALUES ('fao', oils_i18n_gettext('fao', 'Faroese', 'clm', 'value'));
333 INSERT INTO config.language_map (code, value) VALUES ('-far', oils_i18n_gettext('-far', 'Faroese', 'clm', 'value'));
334 INSERT INTO config.language_map (code, value) VALUES ('fat', oils_i18n_gettext('fat', 'Fanti', 'clm', 'value'));
335 INSERT INTO config.language_map (code, value) VALUES ('fij', oils_i18n_gettext('fij', 'Fijian', 'clm', 'value'));
336 INSERT INTO config.language_map (code, value) VALUES ('fin', oils_i18n_gettext('fin', 'Finnish', 'clm', 'value'));
337 INSERT INTO config.language_map (code, value) VALUES ('fiu', oils_i18n_gettext('fiu', 'Finno-Ugrian (Other)', 'clm', 'value'));
338 INSERT INTO config.language_map (code, value) VALUES ('fon', oils_i18n_gettext('fon', 'Fon', 'clm', 'value'));
339 INSERT INTO config.language_map (code, value) VALUES ('fre', oils_i18n_gettext('fre', 'French', 'clm', 'value'));
340 INSERT INTO config.language_map (code, value) VALUES ('-fri', oils_i18n_gettext('-fri', 'Frisian', 'clm', 'value'));
341 INSERT INTO config.language_map (code, value) VALUES ('frm', oils_i18n_gettext('frm', 'French, Middle (ca. 1400-1600)', 'clm', 'value'));
342 INSERT INTO config.language_map (code, value) VALUES ('fro', oils_i18n_gettext('fro', 'French, Old (ca. 842-1400)', 'clm', 'value'));
343 INSERT INTO config.language_map (code, value) VALUES ('fry', oils_i18n_gettext('fry', 'Frisian', 'clm', 'value'));
344 INSERT INTO config.language_map (code, value) VALUES ('ful', oils_i18n_gettext('ful', 'Fula', 'clm', 'value'));
345 INSERT INTO config.language_map (code, value) VALUES ('fur', oils_i18n_gettext('fur', 'Friulian', 'clm', 'value'));
346 INSERT INTO config.language_map (code, value) VALUES ('gaa', oils_i18n_gettext('gaa', 'Gã', 'clm', 'value'));
347 INSERT INTO config.language_map (code, value) VALUES ('-gae', oils_i18n_gettext('-gae', 'Scottish Gaelic', 'clm', 'value'));
348 INSERT INTO config.language_map (code, value) VALUES ('-gag', oils_i18n_gettext('-gag', 'Galician', 'clm', 'value'));
349 INSERT INTO config.language_map (code, value) VALUES ('-gal', oils_i18n_gettext('-gal', 'Oromo', 'clm', 'value'));
350 INSERT INTO config.language_map (code, value) VALUES ('gay', oils_i18n_gettext('gay', 'Gayo', 'clm', 'value'));
351 INSERT INTO config.language_map (code, value) VALUES ('gba', oils_i18n_gettext('gba', 'Gbaya', 'clm', 'value'));
352 INSERT INTO config.language_map (code, value) VALUES ('gem', oils_i18n_gettext('gem', 'Germanic (Other)', 'clm', 'value'));
353 INSERT INTO config.language_map (code, value) VALUES ('geo', oils_i18n_gettext('geo', 'Georgian', 'clm', 'value'));
354 INSERT INTO config.language_map (code, value) VALUES ('ger', oils_i18n_gettext('ger', 'German', 'clm', 'value'));
355 INSERT INTO config.language_map (code, value) VALUES ('gez', oils_i18n_gettext('gez', 'Ethiopic', 'clm', 'value'));
356 INSERT INTO config.language_map (code, value) VALUES ('gil', oils_i18n_gettext('gil', 'Gilbertese', 'clm', 'value'));
357 INSERT INTO config.language_map (code, value) VALUES ('gla', oils_i18n_gettext('gla', 'Scottish Gaelic', 'clm', 'value'));
358 INSERT INTO config.language_map (code, value) VALUES ('gle', oils_i18n_gettext('gle', 'Irish', 'clm', 'value'));
359 INSERT INTO config.language_map (code, value) VALUES ('glg', oils_i18n_gettext('glg', 'Galician', 'clm', 'value'));
360 INSERT INTO config.language_map (code, value) VALUES ('glv', oils_i18n_gettext('glv', 'Manx', 'clm', 'value'));
361 INSERT INTO config.language_map (code, value) VALUES ('gmh', oils_i18n_gettext('gmh', 'German, Middle High (ca. 1050-1500)', 'clm', 'value'));
362 INSERT INTO config.language_map (code, value) VALUES ('goh', oils_i18n_gettext('goh', 'German, Old High (ca. 750-1050)', 'clm', 'value'));
363 INSERT INTO config.language_map (code, value) VALUES ('gon', oils_i18n_gettext('gon', 'Gondi', 'clm', 'value'));
364 INSERT INTO config.language_map (code, value) VALUES ('gor', oils_i18n_gettext('gor', 'Gorontalo', 'clm', 'value'));
365 INSERT INTO config.language_map (code, value) VALUES ('got', oils_i18n_gettext('got', 'Gothic', 'clm', 'value'));
366 INSERT INTO config.language_map (code, value) VALUES ('grb', oils_i18n_gettext('grb', 'Grebo', 'clm', 'value'));
367 INSERT INTO config.language_map (code, value) VALUES ('grc', oils_i18n_gettext('grc', 'Greek, Ancient (to 1453)', 'clm', 'value'));
368 INSERT INTO config.language_map (code, value) VALUES ('gre', oils_i18n_gettext('gre', 'Greek, Modern (1453- )', 'clm', 'value'));
369 INSERT INTO config.language_map (code, value) VALUES ('grn', oils_i18n_gettext('grn', 'Guarani', 'clm', 'value'));
370 INSERT INTO config.language_map (code, value) VALUES ('-gua', oils_i18n_gettext('-gua', 'Guarani', 'clm', 'value'));
371 INSERT INTO config.language_map (code, value) VALUES ('guj', oils_i18n_gettext('guj', 'Gujarati', 'clm', 'value'));
372 INSERT INTO config.language_map (code, value) VALUES ('gwi', oils_i18n_gettext('gwi', 'Gwich', 'clm', 'value''in'));
373 INSERT INTO config.language_map (code, value) VALUES ('hai', oils_i18n_gettext('hai', 'Haida', 'clm', 'value'));
374 INSERT INTO config.language_map (code, value) VALUES ('hat', oils_i18n_gettext('hat', 'Haitian French Creole', 'clm', 'value'));
375 INSERT INTO config.language_map (code, value) VALUES ('hau', oils_i18n_gettext('hau', 'Hausa', 'clm', 'value'));
376 INSERT INTO config.language_map (code, value) VALUES ('haw', oils_i18n_gettext('haw', 'Hawaiian', 'clm', 'value'));
377 INSERT INTO config.language_map (code, value) VALUES ('heb', oils_i18n_gettext('heb', 'Hebrew', 'clm', 'value'));
378 INSERT INTO config.language_map (code, value) VALUES ('her', oils_i18n_gettext('her', 'Herero', 'clm', 'value'));
379 INSERT INTO config.language_map (code, value) VALUES ('hil', oils_i18n_gettext('hil', 'Hiligaynon', 'clm', 'value'));
380 INSERT INTO config.language_map (code, value) VALUES ('him', oils_i18n_gettext('him', 'Himachali', 'clm', 'value'));
381 INSERT INTO config.language_map (code, value) VALUES ('hin', oils_i18n_gettext('hin', 'Hindi', 'clm', 'value'));
382 INSERT INTO config.language_map (code, value) VALUES ('hit', oils_i18n_gettext('hit', 'Hittite', 'clm', 'value'));
383 INSERT INTO config.language_map (code, value) VALUES ('hmn', oils_i18n_gettext('hmn', 'Hmong', 'clm', 'value'));
384 INSERT INTO config.language_map (code, value) VALUES ('hmo', oils_i18n_gettext('hmo', 'Hiri Motu', 'clm', 'value'));
385 INSERT INTO config.language_map (code, value) VALUES ('hun', oils_i18n_gettext('hun', 'Hungarian', 'clm', 'value'));
386 INSERT INTO config.language_map (code, value) VALUES ('hup', oils_i18n_gettext('hup', 'Hupa', 'clm', 'value'));
387 INSERT INTO config.language_map (code, value) VALUES ('iba', oils_i18n_gettext('iba', 'Iban', 'clm', 'value'));
388 INSERT INTO config.language_map (code, value) VALUES ('ibo', oils_i18n_gettext('ibo', 'Igbo', 'clm', 'value'));
389 INSERT INTO config.language_map (code, value) VALUES ('ice', oils_i18n_gettext('ice', 'Icelandic', 'clm', 'value'));
390 INSERT INTO config.language_map (code, value) VALUES ('ido', oils_i18n_gettext('ido', 'Ido', 'clm', 'value'));
391 INSERT INTO config.language_map (code, value) VALUES ('iii', oils_i18n_gettext('iii', 'Sichuan Yi', 'clm', 'value'));
392 INSERT INTO config.language_map (code, value) VALUES ('ijo', oils_i18n_gettext('ijo', 'Ijo', 'clm', 'value'));
393 INSERT INTO config.language_map (code, value) VALUES ('iku', oils_i18n_gettext('iku', 'Inuktitut', 'clm', 'value'));
394 INSERT INTO config.language_map (code, value) VALUES ('ile', oils_i18n_gettext('ile', 'Interlingue', 'clm', 'value'));
395 INSERT INTO config.language_map (code, value) VALUES ('ilo', oils_i18n_gettext('ilo', 'Iloko', 'clm', 'value'));
396 INSERT INTO config.language_map (code, value) VALUES ('ina', oils_i18n_gettext('ina', 'Interlingua (International Auxiliary Language Association)', 'clm', 'value'));
397 INSERT INTO config.language_map (code, value) VALUES ('inc', oils_i18n_gettext('inc', 'Indic (Other)', 'clm', 'value'));
398 INSERT INTO config.language_map (code, value) VALUES ('ind', oils_i18n_gettext('ind', 'Indonesian', 'clm', 'value'));
399 INSERT INTO config.language_map (code, value) VALUES ('ine', oils_i18n_gettext('ine', 'Indo-European (Other)', 'clm', 'value'));
400 INSERT INTO config.language_map (code, value) VALUES ('inh', oils_i18n_gettext('inh', 'Ingush', 'clm', 'value'));
401 INSERT INTO config.language_map (code, value) VALUES ('-int', oils_i18n_gettext('-int', 'Interlingua (International Auxiliary Language Association)', 'clm', 'value'));
402 INSERT INTO config.language_map (code, value) VALUES ('ipk', oils_i18n_gettext('ipk', 'Inupiaq', 'clm', 'value'));
403 INSERT INTO config.language_map (code, value) VALUES ('ira', oils_i18n_gettext('ira', 'Iranian (Other)', 'clm', 'value'));
404 INSERT INTO config.language_map (code, value) VALUES ('-iri', oils_i18n_gettext('-iri', 'Irish', 'clm', 'value'));
405 INSERT INTO config.language_map (code, value) VALUES ('iro', oils_i18n_gettext('iro', 'Iroquoian (Other)', 'clm', 'value'));
406 INSERT INTO config.language_map (code, value) VALUES ('ita', oils_i18n_gettext('ita', 'Italian', 'clm', 'value'));
407 INSERT INTO config.language_map (code, value) VALUES ('jav', oils_i18n_gettext('jav', 'Javanese', 'clm', 'value'));
408 INSERT INTO config.language_map (code, value) VALUES ('jpn', oils_i18n_gettext('jpn', 'Japanese', 'clm', 'value'));
409 INSERT INTO config.language_map (code, value) VALUES ('jpr', oils_i18n_gettext('jpr', 'Judeo-Persian', 'clm', 'value'));
410 INSERT INTO config.language_map (code, value) VALUES ('jrb', oils_i18n_gettext('jrb', 'Judeo-Arabic', 'clm', 'value'));
411 INSERT INTO config.language_map (code, value) VALUES ('kaa', oils_i18n_gettext('kaa', 'Kara-Kalpak', 'clm', 'value'));
412 INSERT INTO config.language_map (code, value) VALUES ('kab', oils_i18n_gettext('kab', 'Kabyle', 'clm', 'value'));
413 INSERT INTO config.language_map (code, value) VALUES ('kac', oils_i18n_gettext('kac', 'Kachin', 'clm', 'value'));
414 INSERT INTO config.language_map (code, value) VALUES ('kal', oils_i18n_gettext('kal', 'Kalâtdlisut', 'clm', 'value'));
415 INSERT INTO config.language_map (code, value) VALUES ('kam', oils_i18n_gettext('kam', 'Kamba', 'clm', 'value'));
416 INSERT INTO config.language_map (code, value) VALUES ('kan', oils_i18n_gettext('kan', 'Kannada', 'clm', 'value'));
417 INSERT INTO config.language_map (code, value) VALUES ('kar', oils_i18n_gettext('kar', 'Karen', 'clm', 'value'));
418 INSERT INTO config.language_map (code, value) VALUES ('kas', oils_i18n_gettext('kas', 'Kashmiri', 'clm', 'value'));
419 INSERT INTO config.language_map (code, value) VALUES ('kau', oils_i18n_gettext('kau', 'Kanuri', 'clm', 'value'));
420 INSERT INTO config.language_map (code, value) VALUES ('kaw', oils_i18n_gettext('kaw', 'Kawi', 'clm', 'value'));
421 INSERT INTO config.language_map (code, value) VALUES ('kaz', oils_i18n_gettext('kaz', 'Kazakh', 'clm', 'value'));
422 INSERT INTO config.language_map (code, value) VALUES ('kbd', oils_i18n_gettext('kbd', 'Kabardian', 'clm', 'value'));
423 INSERT INTO config.language_map (code, value) VALUES ('kha', oils_i18n_gettext('kha', 'Khasi', 'clm', 'value'));
424 INSERT INTO config.language_map (code, value) VALUES ('khi', oils_i18n_gettext('khi', 'Khoisan (Other)', 'clm', 'value'));
425 INSERT INTO config.language_map (code, value) VALUES ('khm', oils_i18n_gettext('khm', 'Khmer', 'clm', 'value'));
426 INSERT INTO config.language_map (code, value) VALUES ('kho', oils_i18n_gettext('kho', 'Khotanese', 'clm', 'value'));
427 INSERT INTO config.language_map (code, value) VALUES ('kik', oils_i18n_gettext('kik', 'Kikuyu', 'clm', 'value'));
428 INSERT INTO config.language_map (code, value) VALUES ('kin', oils_i18n_gettext('kin', 'Kinyarwanda', 'clm', 'value'));
429 INSERT INTO config.language_map (code, value) VALUES ('kir', oils_i18n_gettext('kir', 'Kyrgyz', 'clm', 'value'));
430 INSERT INTO config.language_map (code, value) VALUES ('kmb', oils_i18n_gettext('kmb', 'Kimbundu', 'clm', 'value'));
431 INSERT INTO config.language_map (code, value) VALUES ('kok', oils_i18n_gettext('kok', 'Konkani', 'clm', 'value'));
432 INSERT INTO config.language_map (code, value) VALUES ('kom', oils_i18n_gettext('kom', 'Komi', 'clm', 'value'));
433 INSERT INTO config.language_map (code, value) VALUES ('kon', oils_i18n_gettext('kon', 'Kongo', 'clm', 'value'));
434 INSERT INTO config.language_map (code, value) VALUES ('kor', oils_i18n_gettext('kor', 'Korean', 'clm', 'value'));
435 INSERT INTO config.language_map (code, value) VALUES ('kos', oils_i18n_gettext('kos', 'Kusaie', 'clm', 'value'));
436 INSERT INTO config.language_map (code, value) VALUES ('kpe', oils_i18n_gettext('kpe', 'Kpelle', 'clm', 'value'));
437 INSERT INTO config.language_map (code, value) VALUES ('kro', oils_i18n_gettext('kro', 'Kru', 'clm', 'value'));
438 INSERT INTO config.language_map (code, value) VALUES ('kru', oils_i18n_gettext('kru', 'Kurukh', 'clm', 'value'));
439 INSERT INTO config.language_map (code, value) VALUES ('kua', oils_i18n_gettext('kua', 'Kuanyama', 'clm', 'value'));
440 INSERT INTO config.language_map (code, value) VALUES ('kum', oils_i18n_gettext('kum', 'Kumyk', 'clm', 'value'));
441 INSERT INTO config.language_map (code, value) VALUES ('kur', oils_i18n_gettext('kur', 'Kurdish', 'clm', 'value'));
442 INSERT INTO config.language_map (code, value) VALUES ('-kus', oils_i18n_gettext('-kus', 'Kusaie', 'clm', 'value'));
443 INSERT INTO config.language_map (code, value) VALUES ('kut', oils_i18n_gettext('kut', 'Kutenai', 'clm', 'value'));
444 INSERT INTO config.language_map (code, value) VALUES ('lad', oils_i18n_gettext('lad', 'Ladino', 'clm', 'value'));
445 INSERT INTO config.language_map (code, value) VALUES ('lah', oils_i18n_gettext('lah', 'Lahnda', 'clm', 'value'));
446 INSERT INTO config.language_map (code, value) VALUES ('lam', oils_i18n_gettext('lam', 'Lamba', 'clm', 'value'));
447 INSERT INTO config.language_map (code, value) VALUES ('-lan', oils_i18n_gettext('-lan', 'Occitan (post-1500)', 'clm', 'value'));
448 INSERT INTO config.language_map (code, value) VALUES ('lao', oils_i18n_gettext('lao', 'Lao', 'clm', 'value'));
449 INSERT INTO config.language_map (code, value) VALUES ('-lap', oils_i18n_gettext('-lap', 'Sami', 'clm', 'value'));
450 INSERT INTO config.language_map (code, value) VALUES ('lat', oils_i18n_gettext('lat', 'Latin', 'clm', 'value'));
451 INSERT INTO config.language_map (code, value) VALUES ('lav', oils_i18n_gettext('lav', 'Latvian', 'clm', 'value'));
452 INSERT INTO config.language_map (code, value) VALUES ('lez', oils_i18n_gettext('lez', 'Lezgian', 'clm', 'value'));
453 INSERT INTO config.language_map (code, value) VALUES ('lim', oils_i18n_gettext('lim', 'Limburgish', 'clm', 'value'));
454 INSERT INTO config.language_map (code, value) VALUES ('lin', oils_i18n_gettext('lin', 'Lingala', 'clm', 'value'));
455 INSERT INTO config.language_map (code, value) VALUES ('lit', oils_i18n_gettext('lit', 'Lithuanian', 'clm', 'value'));
456 INSERT INTO config.language_map (code, value) VALUES ('lol', oils_i18n_gettext('lol', 'Mongo-Nkundu', 'clm', 'value'));
457 INSERT INTO config.language_map (code, value) VALUES ('loz', oils_i18n_gettext('loz', 'Lozi', 'clm', 'value'));
458 INSERT INTO config.language_map (code, value) VALUES ('ltz', oils_i18n_gettext('ltz', 'Letzeburgesch', 'clm', 'value'));
459 INSERT INTO config.language_map (code, value) VALUES ('lua', oils_i18n_gettext('lua', 'Luba-Lulua', 'clm', 'value'));
460 INSERT INTO config.language_map (code, value) VALUES ('lub', oils_i18n_gettext('lub', 'Luba-Katanga', 'clm', 'value'));
461 INSERT INTO config.language_map (code, value) VALUES ('lug', oils_i18n_gettext('lug', 'Ganda', 'clm', 'value'));
462 INSERT INTO config.language_map (code, value) VALUES ('lui', oils_i18n_gettext('lui', 'Luiseño', 'clm', 'value'));
463 INSERT INTO config.language_map (code, value) VALUES ('lun', oils_i18n_gettext('lun', 'Lunda', 'clm', 'value'));
464 INSERT INTO config.language_map (code, value) VALUES ('luo', oils_i18n_gettext('luo', 'Luo (Kenya and Tanzania)', 'clm', 'value'));
465 INSERT INTO config.language_map (code, value) VALUES ('lus', oils_i18n_gettext('lus', 'Lushai', 'clm', 'value'));
466 INSERT INTO config.language_map (code, value) VALUES ('mac', oils_i18n_gettext('mac', 'Macedonian', 'clm', 'value'));
467 INSERT INTO config.language_map (code, value) VALUES ('mad', oils_i18n_gettext('mad', 'Madurese', 'clm', 'value'));
468 INSERT INTO config.language_map (code, value) VALUES ('mag', oils_i18n_gettext('mag', 'Magahi', 'clm', 'value'));
469 INSERT INTO config.language_map (code, value) VALUES ('mah', oils_i18n_gettext('mah', 'Marshallese', 'clm', 'value'));
470 INSERT INTO config.language_map (code, value) VALUES ('mai', oils_i18n_gettext('mai', 'Maithili', 'clm', 'value'));
471 INSERT INTO config.language_map (code, value) VALUES ('mak', oils_i18n_gettext('mak', 'Makasar', 'clm', 'value'));
472 INSERT INTO config.language_map (code, value) VALUES ('mal', oils_i18n_gettext('mal', 'Malayalam', 'clm', 'value'));
473 INSERT INTO config.language_map (code, value) VALUES ('man', oils_i18n_gettext('man', 'Mandingo', 'clm', 'value'));
474 INSERT INTO config.language_map (code, value) VALUES ('mao', oils_i18n_gettext('mao', 'Maori', 'clm', 'value'));
475 INSERT INTO config.language_map (code, value) VALUES ('map', oils_i18n_gettext('map', 'Austronesian (Other)', 'clm', 'value'));
476 INSERT INTO config.language_map (code, value) VALUES ('mar', oils_i18n_gettext('mar', 'Marathi', 'clm', 'value'));
477 INSERT INTO config.language_map (code, value) VALUES ('mas', oils_i18n_gettext('mas', 'Masai', 'clm', 'value'));
478 INSERT INTO config.language_map (code, value) VALUES ('-max', oils_i18n_gettext('-max', 'Manx', 'clm', 'value'));
479 INSERT INTO config.language_map (code, value) VALUES ('may', oils_i18n_gettext('may', 'Malay', 'clm', 'value'));
480 INSERT INTO config.language_map (code, value) VALUES ('mdr', oils_i18n_gettext('mdr', 'Mandar', 'clm', 'value'));
481 INSERT INTO config.language_map (code, value) VALUES ('men', oils_i18n_gettext('men', 'Mende', 'clm', 'value'));
482 INSERT INTO config.language_map (code, value) VALUES ('mga', oils_i18n_gettext('mga', 'Irish, Middle (ca. 1100-1550)', 'clm', 'value'));
483 INSERT INTO config.language_map (code, value) VALUES ('mic', oils_i18n_gettext('mic', 'Micmac', 'clm', 'value'));
484 INSERT INTO config.language_map (code, value) VALUES ('min', oils_i18n_gettext('min', 'Minangkabau', 'clm', 'value'));
485 INSERT INTO config.language_map (code, value) VALUES ('mis', oils_i18n_gettext('mis', 'Miscellaneous languages', 'clm', 'value'));
486 INSERT INTO config.language_map (code, value) VALUES ('mkh', oils_i18n_gettext('mkh', 'Mon-Khmer (Other)', 'clm', 'value'));
487 INSERT INTO config.language_map (code, value) VALUES ('-mla', oils_i18n_gettext('-mla', 'Malagasy', 'clm', 'value'));
488 INSERT INTO config.language_map (code, value) VALUES ('mlg', oils_i18n_gettext('mlg', 'Malagasy', 'clm', 'value'));
489 INSERT INTO config.language_map (code, value) VALUES ('mlt', oils_i18n_gettext('mlt', 'Maltese', 'clm', 'value'));
490 INSERT INTO config.language_map (code, value) VALUES ('mnc', oils_i18n_gettext('mnc', 'Manchu', 'clm', 'value'));
491 INSERT INTO config.language_map (code, value) VALUES ('mni', oils_i18n_gettext('mni', 'Manipuri', 'clm', 'value'));
492 INSERT INTO config.language_map (code, value) VALUES ('mno', oils_i18n_gettext('mno', 'Manobo languages', 'clm', 'value'));
493 INSERT INTO config.language_map (code, value) VALUES ('moh', oils_i18n_gettext('moh', 'Mohawk', 'clm', 'value'));
494 INSERT INTO config.language_map (code, value) VALUES ('mol', oils_i18n_gettext('mol', 'Moldavian', 'clm', 'value'));
495 INSERT INTO config.language_map (code, value) VALUES ('mon', oils_i18n_gettext('mon', 'Mongolian', 'clm', 'value'));
496 INSERT INTO config.language_map (code, value) VALUES ('mos', oils_i18n_gettext('mos', 'Mooré', 'clm', 'value'));
497 INSERT INTO config.language_map (code, value) VALUES ('mul', oils_i18n_gettext('mul', 'Multiple languages', 'clm', 'value'));
498 INSERT INTO config.language_map (code, value) VALUES ('mun', oils_i18n_gettext('mun', 'Munda (Other)', 'clm', 'value'));
499 INSERT INTO config.language_map (code, value) VALUES ('mus', oils_i18n_gettext('mus', 'Creek', 'clm', 'value'));
500 INSERT INTO config.language_map (code, value) VALUES ('mwr', oils_i18n_gettext('mwr', 'Marwari', 'clm', 'value'));
501 INSERT INTO config.language_map (code, value) VALUES ('myn', oils_i18n_gettext('myn', 'Mayan languages', 'clm', 'value'));
502 INSERT INTO config.language_map (code, value) VALUES ('nah', oils_i18n_gettext('nah', 'Nahuatl', 'clm', 'value'));
503 INSERT INTO config.language_map (code, value) VALUES ('nai', oils_i18n_gettext('nai', 'North American Indian (Other)', 'clm', 'value'));
504 INSERT INTO config.language_map (code, value) VALUES ('nap', oils_i18n_gettext('nap', 'Neapolitan Italian', 'clm', 'value'));
505 INSERT INTO config.language_map (code, value) VALUES ('nau', oils_i18n_gettext('nau', 'Nauru', 'clm', 'value'));
506 INSERT INTO config.language_map (code, value) VALUES ('nav', oils_i18n_gettext('nav', 'Navajo', 'clm', 'value'));
507 INSERT INTO config.language_map (code, value) VALUES ('nbl', oils_i18n_gettext('nbl', 'Ndebele (South Africa)', 'clm', 'value'));
508 INSERT INTO config.language_map (code, value) VALUES ('nde', oils_i18n_gettext('nde', 'Ndebele (Zimbabwe) ', 'clm', 'value'));
509 INSERT INTO config.language_map (code, value) VALUES ('ndo', oils_i18n_gettext('ndo', 'Ndonga', 'clm', 'value'));
510 INSERT INTO config.language_map (code, value) VALUES ('nds', oils_i18n_gettext('nds', 'Low German', 'clm', 'value'));
511 INSERT INTO config.language_map (code, value) VALUES ('nep', oils_i18n_gettext('nep', 'Nepali', 'clm', 'value'));
512 INSERT INTO config.language_map (code, value) VALUES ('new', oils_i18n_gettext('new', 'Newari', 'clm', 'value'));
513 INSERT INTO config.language_map (code, value) VALUES ('nia', oils_i18n_gettext('nia', 'Nias', 'clm', 'value'));
514 INSERT INTO config.language_map (code, value) VALUES ('nic', oils_i18n_gettext('nic', 'Niger-Kordofanian (Other)', 'clm', 'value'));
515 INSERT INTO config.language_map (code, value) VALUES ('niu', oils_i18n_gettext('niu', 'Niuean', 'clm', 'value'));
516 INSERT INTO config.language_map (code, value) VALUES ('nno', oils_i18n_gettext('nno', 'Norwegian (Nynorsk)', 'clm', 'value'));
517 INSERT INTO config.language_map (code, value) VALUES ('nob', oils_i18n_gettext('nob', 'Norwegian (Bokmål)', 'clm', 'value'));
518 INSERT INTO config.language_map (code, value) VALUES ('nog', oils_i18n_gettext('nog', 'Nogai', 'clm', 'value'));
519 INSERT INTO config.language_map (code, value) VALUES ('non', oils_i18n_gettext('non', 'Old Norse', 'clm', 'value'));
520 INSERT INTO config.language_map (code, value) VALUES ('nor', oils_i18n_gettext('nor', 'Norwegian', 'clm', 'value'));
521 INSERT INTO config.language_map (code, value) VALUES ('nso', oils_i18n_gettext('nso', 'Northern Sotho', 'clm', 'value'));
522 INSERT INTO config.language_map (code, value) VALUES ('nub', oils_i18n_gettext('nub', 'Nubian languages', 'clm', 'value'));
523 INSERT INTO config.language_map (code, value) VALUES ('nya', oils_i18n_gettext('nya', 'Nyanja', 'clm', 'value'));
524 INSERT INTO config.language_map (code, value) VALUES ('nym', oils_i18n_gettext('nym', 'Nyamwezi', 'clm', 'value'));
525 INSERT INTO config.language_map (code, value) VALUES ('nyn', oils_i18n_gettext('nyn', 'Nyankole', 'clm', 'value'));
526 INSERT INTO config.language_map (code, value) VALUES ('nyo', oils_i18n_gettext('nyo', 'Nyoro', 'clm', 'value'));
527 INSERT INTO config.language_map (code, value) VALUES ('nzi', oils_i18n_gettext('nzi', 'Nzima', 'clm', 'value'));
528 INSERT INTO config.language_map (code, value) VALUES ('oci', oils_i18n_gettext('oci', 'Occitan (post-1500)', 'clm', 'value'));
529 INSERT INTO config.language_map (code, value) VALUES ('oji', oils_i18n_gettext('oji', 'Ojibwa', 'clm', 'value'));
530 INSERT INTO config.language_map (code, value) VALUES ('ori', oils_i18n_gettext('ori', 'Oriya', 'clm', 'value'));
531 INSERT INTO config.language_map (code, value) VALUES ('orm', oils_i18n_gettext('orm', 'Oromo', 'clm', 'value'));
532 INSERT INTO config.language_map (code, value) VALUES ('osa', oils_i18n_gettext('osa', 'Osage', 'clm', 'value'));
533 INSERT INTO config.language_map (code, value) VALUES ('oss', oils_i18n_gettext('oss', 'Ossetic', 'clm', 'value'));
534 INSERT INTO config.language_map (code, value) VALUES ('ota', oils_i18n_gettext('ota', 'Turkish, Ottoman', 'clm', 'value'));
535 INSERT INTO config.language_map (code, value) VALUES ('oto', oils_i18n_gettext('oto', 'Otomian languages', 'clm', 'value'));
536 INSERT INTO config.language_map (code, value) VALUES ('paa', oils_i18n_gettext('paa', 'Papuan (Other)', 'clm', 'value'));
537 INSERT INTO config.language_map (code, value) VALUES ('pag', oils_i18n_gettext('pag', 'Pangasinan', 'clm', 'value'));
538 INSERT INTO config.language_map (code, value) VALUES ('pal', oils_i18n_gettext('pal', 'Pahlavi', 'clm', 'value'));
539 INSERT INTO config.language_map (code, value) VALUES ('pam', oils_i18n_gettext('pam', 'Pampanga', 'clm', 'value'));
540 INSERT INTO config.language_map (code, value) VALUES ('pan', oils_i18n_gettext('pan', 'Panjabi', 'clm', 'value'));
541 INSERT INTO config.language_map (code, value) VALUES ('pap', oils_i18n_gettext('pap', 'Papiamento', 'clm', 'value'));
542 INSERT INTO config.language_map (code, value) VALUES ('pau', oils_i18n_gettext('pau', 'Palauan', 'clm', 'value'));
543 INSERT INTO config.language_map (code, value) VALUES ('peo', oils_i18n_gettext('peo', 'Old Persian (ca. 600-400 B.C.)', 'clm', 'value'));
544 INSERT INTO config.language_map (code, value) VALUES ('per', oils_i18n_gettext('per', 'Persian', 'clm', 'value'));
545 INSERT INTO config.language_map (code, value) VALUES ('phi', oils_i18n_gettext('phi', 'Philippine (Other)', 'clm', 'value'));
546 INSERT INTO config.language_map (code, value) VALUES ('phn', oils_i18n_gettext('phn', 'Phoenician', 'clm', 'value'));
547 INSERT INTO config.language_map (code, value) VALUES ('pli', oils_i18n_gettext('pli', 'Pali', 'clm', 'value'));
548 INSERT INTO config.language_map (code, value) VALUES ('pol', oils_i18n_gettext('pol', 'Polish', 'clm', 'value'));
549 INSERT INTO config.language_map (code, value) VALUES ('pon', oils_i18n_gettext('pon', 'Ponape', 'clm', 'value'));
550 INSERT INTO config.language_map (code, value) VALUES ('por', oils_i18n_gettext('por', 'Portuguese', 'clm', 'value'));
551 INSERT INTO config.language_map (code, value) VALUES ('pra', oils_i18n_gettext('pra', 'Prakrit languages', 'clm', 'value'));
552 INSERT INTO config.language_map (code, value) VALUES ('pro', oils_i18n_gettext('pro', 'Provençal (to 1500)', 'clm', 'value'));
553 INSERT INTO config.language_map (code, value) VALUES ('pus', oils_i18n_gettext('pus', 'Pushto', 'clm', 'value'));
554 INSERT INTO config.language_map (code, value) VALUES ('que', oils_i18n_gettext('que', 'Quechua', 'clm', 'value'));
555 INSERT INTO config.language_map (code, value) VALUES ('raj', oils_i18n_gettext('raj', 'Rajasthani', 'clm', 'value'));
556 INSERT INTO config.language_map (code, value) VALUES ('rap', oils_i18n_gettext('rap', 'Rapanui', 'clm', 'value'));
557 INSERT INTO config.language_map (code, value) VALUES ('rar', oils_i18n_gettext('rar', 'Rarotongan', 'clm', 'value'));
558 INSERT INTO config.language_map (code, value) VALUES ('roa', oils_i18n_gettext('roa', 'Romance (Other)', 'clm', 'value'));
559 INSERT INTO config.language_map (code, value) VALUES ('roh', oils_i18n_gettext('roh', 'Raeto-Romance', 'clm', 'value'));
560 INSERT INTO config.language_map (code, value) VALUES ('rom', oils_i18n_gettext('rom', 'Romani', 'clm', 'value'));
561 INSERT INTO config.language_map (code, value) VALUES ('rum', oils_i18n_gettext('rum', 'Romanian', 'clm', 'value'));
562 INSERT INTO config.language_map (code, value) VALUES ('run', oils_i18n_gettext('run', 'Rundi', 'clm', 'value'));
563 INSERT INTO config.language_map (code, value) VALUES ('rus', oils_i18n_gettext('rus', 'Russian', 'clm', 'value'));
564 INSERT INTO config.language_map (code, value) VALUES ('sad', oils_i18n_gettext('sad', 'Sandawe', 'clm', 'value'));
565 INSERT INTO config.language_map (code, value) VALUES ('sag', oils_i18n_gettext('sag', 'Sango (Ubangi Creole)', 'clm', 'value'));
566 INSERT INTO config.language_map (code, value) VALUES ('sah', oils_i18n_gettext('sah', 'Yakut', 'clm', 'value'));
567 INSERT INTO config.language_map (code, value) VALUES ('sai', oils_i18n_gettext('sai', 'South American Indian (Other)', 'clm', 'value'));
568 INSERT INTO config.language_map (code, value) VALUES ('sal', oils_i18n_gettext('sal', 'Salishan languages', 'clm', 'value'));
569 INSERT INTO config.language_map (code, value) VALUES ('sam', oils_i18n_gettext('sam', 'Samaritan Aramaic', 'clm', 'value'));
570 INSERT INTO config.language_map (code, value) VALUES ('san', oils_i18n_gettext('san', 'Sanskrit', 'clm', 'value'));
571 INSERT INTO config.language_map (code, value) VALUES ('-sao', oils_i18n_gettext('-sao', 'Samoan', 'clm', 'value'));
572 INSERT INTO config.language_map (code, value) VALUES ('sas', oils_i18n_gettext('sas', 'Sasak', 'clm', 'value'));
573 INSERT INTO config.language_map (code, value) VALUES ('sat', oils_i18n_gettext('sat', 'Santali', 'clm', 'value'));
574 INSERT INTO config.language_map (code, value) VALUES ('scc', oils_i18n_gettext('scc', 'Serbian', 'clm', 'value'));
575 INSERT INTO config.language_map (code, value) VALUES ('sco', oils_i18n_gettext('sco', 'Scots', 'clm', 'value'));
576 INSERT INTO config.language_map (code, value) VALUES ('scr', oils_i18n_gettext('scr', 'Croatian', 'clm', 'value'));
577 INSERT INTO config.language_map (code, value) VALUES ('sel', oils_i18n_gettext('sel', 'Selkup', 'clm', 'value'));
578 INSERT INTO config.language_map (code, value) VALUES ('sem', oils_i18n_gettext('sem', 'Semitic (Other)', 'clm', 'value'));
579 INSERT INTO config.language_map (code, value) VALUES ('sga', oils_i18n_gettext('sga', 'Irish, Old (to 1100)', 'clm', 'value'));
580 INSERT INTO config.language_map (code, value) VALUES ('sgn', oils_i18n_gettext('sgn', 'Sign languages', 'clm', 'value'));
581 INSERT INTO config.language_map (code, value) VALUES ('shn', oils_i18n_gettext('shn', 'Shan', 'clm', 'value'));
582 INSERT INTO config.language_map (code, value) VALUES ('-sho', oils_i18n_gettext('-sho', 'Shona', 'clm', 'value'));
583 INSERT INTO config.language_map (code, value) VALUES ('sid', oils_i18n_gettext('sid', 'Sidamo', 'clm', 'value'));
584 INSERT INTO config.language_map (code, value) VALUES ('sin', oils_i18n_gettext('sin', 'Sinhalese', 'clm', 'value'));
585 INSERT INTO config.language_map (code, value) VALUES ('sio', oils_i18n_gettext('sio', 'Siouan (Other)', 'clm', 'value'));
586 INSERT INTO config.language_map (code, value) VALUES ('sit', oils_i18n_gettext('sit', 'Sino-Tibetan (Other)', 'clm', 'value'));
587 INSERT INTO config.language_map (code, value) VALUES ('sla', oils_i18n_gettext('sla', 'Slavic (Other)', 'clm', 'value'));
588 INSERT INTO config.language_map (code, value) VALUES ('slo', oils_i18n_gettext('slo', 'Slovak', 'clm', 'value'));
589 INSERT INTO config.language_map (code, value) VALUES ('slv', oils_i18n_gettext('slv', 'Slovenian', 'clm', 'value'));
590 INSERT INTO config.language_map (code, value) VALUES ('sma', oils_i18n_gettext('sma', 'Southern Sami', 'clm', 'value'));
591 INSERT INTO config.language_map (code, value) VALUES ('sme', oils_i18n_gettext('sme', 'Northern Sami', 'clm', 'value'));
592 INSERT INTO config.language_map (code, value) VALUES ('smi', oils_i18n_gettext('smi', 'Sami', 'clm', 'value'));
593 INSERT INTO config.language_map (code, value) VALUES ('smj', oils_i18n_gettext('smj', 'Lule Sami', 'clm', 'value'));
594 INSERT INTO config.language_map (code, value) VALUES ('smn', oils_i18n_gettext('smn', 'Inari Sami', 'clm', 'value'));
595 INSERT INTO config.language_map (code, value) VALUES ('smo', oils_i18n_gettext('smo', 'Samoan', 'clm', 'value'));
596 INSERT INTO config.language_map (code, value) VALUES ('sms', oils_i18n_gettext('sms', 'Skolt Sami', 'clm', 'value'));
597 INSERT INTO config.language_map (code, value) VALUES ('sna', oils_i18n_gettext('sna', 'Shona', 'clm', 'value'));
598 INSERT INTO config.language_map (code, value) VALUES ('snd', oils_i18n_gettext('snd', 'Sindhi', 'clm', 'value'));
599 INSERT INTO config.language_map (code, value) VALUES ('-snh', oils_i18n_gettext('-snh', 'Sinhalese', 'clm', 'value'));
600 INSERT INTO config.language_map (code, value) VALUES ('snk', oils_i18n_gettext('snk', 'Soninke', 'clm', 'value'));
601 INSERT INTO config.language_map (code, value) VALUES ('sog', oils_i18n_gettext('sog', 'Sogdian', 'clm', 'value'));
602 INSERT INTO config.language_map (code, value) VALUES ('som', oils_i18n_gettext('som', 'Somali', 'clm', 'value'));
603 INSERT INTO config.language_map (code, value) VALUES ('son', oils_i18n_gettext('son', 'Songhai', 'clm', 'value'));
604 INSERT INTO config.language_map (code, value) VALUES ('sot', oils_i18n_gettext('sot', 'Sotho', 'clm', 'value'));
605 INSERT INTO config.language_map (code, value) VALUES ('spa', oils_i18n_gettext('spa', 'Spanish', 'clm', 'value'));
606 INSERT INTO config.language_map (code, value) VALUES ('srd', oils_i18n_gettext('srd', 'Sardinian', 'clm', 'value'));
607 INSERT INTO config.language_map (code, value) VALUES ('srr', oils_i18n_gettext('srr', 'Serer', 'clm', 'value'));
608 INSERT INTO config.language_map (code, value) VALUES ('ssa', oils_i18n_gettext('ssa', 'Nilo-Saharan (Other)', 'clm', 'value'));
609 INSERT INTO config.language_map (code, value) VALUES ('-sso', oils_i18n_gettext('-sso', 'Sotho', 'clm', 'value'));
610 INSERT INTO config.language_map (code, value) VALUES ('ssw', oils_i18n_gettext('ssw', 'Swazi', 'clm', 'value'));
611 INSERT INTO config.language_map (code, value) VALUES ('suk', oils_i18n_gettext('suk', 'Sukuma', 'clm', 'value'));
612 INSERT INTO config.language_map (code, value) VALUES ('sun', oils_i18n_gettext('sun', 'Sundanese', 'clm', 'value'));
613 INSERT INTO config.language_map (code, value) VALUES ('sus', oils_i18n_gettext('sus', 'Susu', 'clm', 'value'));
614 INSERT INTO config.language_map (code, value) VALUES ('sux', oils_i18n_gettext('sux', 'Sumerian', 'clm', 'value'));
615 INSERT INTO config.language_map (code, value) VALUES ('swa', oils_i18n_gettext('swa', 'Swahili', 'clm', 'value'));
616 INSERT INTO config.language_map (code, value) VALUES ('swe', oils_i18n_gettext('swe', 'Swedish', 'clm', 'value'));
617 INSERT INTO config.language_map (code, value) VALUES ('-swz', oils_i18n_gettext('-swz', 'Swazi', 'clm', 'value'));
618 INSERT INTO config.language_map (code, value) VALUES ('syr', oils_i18n_gettext('syr', 'Syriac', 'clm', 'value'));
619 INSERT INTO config.language_map (code, value) VALUES ('-tag', oils_i18n_gettext('-tag', 'Tagalog', 'clm', 'value'));
620 INSERT INTO config.language_map (code, value) VALUES ('tah', oils_i18n_gettext('tah', 'Tahitian', 'clm', 'value'));
621 INSERT INTO config.language_map (code, value) VALUES ('tai', oils_i18n_gettext('tai', 'Tai (Other)', 'clm', 'value'));
622 INSERT INTO config.language_map (code, value) VALUES ('-taj', oils_i18n_gettext('-taj', 'Tajik', 'clm', 'value'));
623 INSERT INTO config.language_map (code, value) VALUES ('tam', oils_i18n_gettext('tam', 'Tamil', 'clm', 'value'));
624 INSERT INTO config.language_map (code, value) VALUES ('-tar', oils_i18n_gettext('-tar', 'Tatar', 'clm', 'value'));
625 INSERT INTO config.language_map (code, value) VALUES ('tat', oils_i18n_gettext('tat', 'Tatar', 'clm', 'value'));
626 INSERT INTO config.language_map (code, value) VALUES ('tel', oils_i18n_gettext('tel', 'Telugu', 'clm', 'value'));
627 INSERT INTO config.language_map (code, value) VALUES ('tem', oils_i18n_gettext('tem', 'Temne', 'clm', 'value'));
628 INSERT INTO config.language_map (code, value) VALUES ('ter', oils_i18n_gettext('ter', 'Terena', 'clm', 'value'));
629 INSERT INTO config.language_map (code, value) VALUES ('tet', oils_i18n_gettext('tet', 'Tetum', 'clm', 'value'));
630 INSERT INTO config.language_map (code, value) VALUES ('tgk', oils_i18n_gettext('tgk', 'Tajik', 'clm', 'value'));
631 INSERT INTO config.language_map (code, value) VALUES ('tgl', oils_i18n_gettext('tgl', 'Tagalog', 'clm', 'value'));
632 INSERT INTO config.language_map (code, value) VALUES ('tha', oils_i18n_gettext('tha', 'Thai', 'clm', 'value'));
633 INSERT INTO config.language_map (code, value) VALUES ('tib', oils_i18n_gettext('tib', 'Tibetan', 'clm', 'value'));
634 INSERT INTO config.language_map (code, value) VALUES ('tig', oils_i18n_gettext('tig', 'Tigré', 'clm', 'value'));
635 INSERT INTO config.language_map (code, value) VALUES ('tir', oils_i18n_gettext('tir', 'Tigrinya', 'clm', 'value'));
636 INSERT INTO config.language_map (code, value) VALUES ('tiv', oils_i18n_gettext('tiv', 'Tiv', 'clm', 'value'));
637 INSERT INTO config.language_map (code, value) VALUES ('tkl', oils_i18n_gettext('tkl', 'Tokelauan', 'clm', 'value'));
638 INSERT INTO config.language_map (code, value) VALUES ('tli', oils_i18n_gettext('tli', 'Tlingit', 'clm', 'value'));
639 INSERT INTO config.language_map (code, value) VALUES ('tmh', oils_i18n_gettext('tmh', 'Tamashek', 'clm', 'value'));
640 INSERT INTO config.language_map (code, value) VALUES ('tog', oils_i18n_gettext('tog', 'Tonga (Nyasa)', 'clm', 'value'));
641 INSERT INTO config.language_map (code, value) VALUES ('ton', oils_i18n_gettext('ton', 'Tongan', 'clm', 'value'));
642 INSERT INTO config.language_map (code, value) VALUES ('tpi', oils_i18n_gettext('tpi', 'Tok Pisin', 'clm', 'value'));
643 INSERT INTO config.language_map (code, value) VALUES ('-tru', oils_i18n_gettext('-tru', 'Truk', 'clm', 'value'));
644 INSERT INTO config.language_map (code, value) VALUES ('tsi', oils_i18n_gettext('tsi', 'Tsimshian', 'clm', 'value'));
645 INSERT INTO config.language_map (code, value) VALUES ('tsn', oils_i18n_gettext('tsn', 'Tswana', 'clm', 'value'));
646 INSERT INTO config.language_map (code, value) VALUES ('tso', oils_i18n_gettext('tso', 'Tsonga', 'clm', 'value'));
647 INSERT INTO config.language_map (code, value) VALUES ('-tsw', oils_i18n_gettext('-tsw', 'Tswana', 'clm', 'value'));
648 INSERT INTO config.language_map (code, value) VALUES ('tuk', oils_i18n_gettext('tuk', 'Turkmen', 'clm', 'value'));
649 INSERT INTO config.language_map (code, value) VALUES ('tum', oils_i18n_gettext('tum', 'Tumbuka', 'clm', 'value'));
650 INSERT INTO config.language_map (code, value) VALUES ('tup', oils_i18n_gettext('tup', 'Tupi languages', 'clm', 'value'));
651 INSERT INTO config.language_map (code, value) VALUES ('tur', oils_i18n_gettext('tur', 'Turkish', 'clm', 'value'));
652 INSERT INTO config.language_map (code, value) VALUES ('tut', oils_i18n_gettext('tut', 'Altaic (Other)', 'clm', 'value'));
653 INSERT INTO config.language_map (code, value) VALUES ('tvl', oils_i18n_gettext('tvl', 'Tuvaluan', 'clm', 'value'));
654 INSERT INTO config.language_map (code, value) VALUES ('twi', oils_i18n_gettext('twi', 'Twi', 'clm', 'value'));
655 INSERT INTO config.language_map (code, value) VALUES ('tyv', oils_i18n_gettext('tyv', 'Tuvinian', 'clm', 'value'));
656 INSERT INTO config.language_map (code, value) VALUES ('udm', oils_i18n_gettext('udm', 'Udmurt', 'clm', 'value'));
657 INSERT INTO config.language_map (code, value) VALUES ('uga', oils_i18n_gettext('uga', 'Ugaritic', 'clm', 'value'));
658 INSERT INTO config.language_map (code, value) VALUES ('uig', oils_i18n_gettext('uig', 'Uighur', 'clm', 'value'));
659 INSERT INTO config.language_map (code, value) VALUES ('ukr', oils_i18n_gettext('ukr', 'Ukrainian', 'clm', 'value'));
660 INSERT INTO config.language_map (code, value) VALUES ('umb', oils_i18n_gettext('umb', 'Umbundu', 'clm', 'value'));
661 INSERT INTO config.language_map (code, value) VALUES ('und', oils_i18n_gettext('und', 'Undetermined', 'clm', 'value'));
662 INSERT INTO config.language_map (code, value) VALUES ('urd', oils_i18n_gettext('urd', 'Urdu', 'clm', 'value'));
663 INSERT INTO config.language_map (code, value) VALUES ('uzb', oils_i18n_gettext('uzb', 'Uzbek', 'clm', 'value'));
664 INSERT INTO config.language_map (code, value) VALUES ('vai', oils_i18n_gettext('vai', 'Vai', 'clm', 'value'));
665 INSERT INTO config.language_map (code, value) VALUES ('ven', oils_i18n_gettext('ven', 'Venda', 'clm', 'value'));
666 INSERT INTO config.language_map (code, value) VALUES ('vie', oils_i18n_gettext('vie', 'Vietnamese', 'clm', 'value'));
667 INSERT INTO config.language_map (code, value) VALUES ('vol', oils_i18n_gettext('vol', 'Volapük', 'clm', 'value'));
668 INSERT INTO config.language_map (code, value) VALUES ('vot', oils_i18n_gettext('vot', 'Votic', 'clm', 'value'));
669 INSERT INTO config.language_map (code, value) VALUES ('wak', oils_i18n_gettext('wak', 'Wakashan languages', 'clm', 'value'));
670 INSERT INTO config.language_map (code, value) VALUES ('wal', oils_i18n_gettext('wal', 'Walamo', 'clm', 'value'));
671 INSERT INTO config.language_map (code, value) VALUES ('war', oils_i18n_gettext('war', 'Waray', 'clm', 'value'));
672 INSERT INTO config.language_map (code, value) VALUES ('was', oils_i18n_gettext('was', 'Washo', 'clm', 'value'));
673 INSERT INTO config.language_map (code, value) VALUES ('wel', oils_i18n_gettext('wel', 'Welsh', 'clm', 'value'));
674 INSERT INTO config.language_map (code, value) VALUES ('wen', oils_i18n_gettext('wen', 'Sorbian languages', 'clm', 'value'));
675 INSERT INTO config.language_map (code, value) VALUES ('wln', oils_i18n_gettext('wln', 'Walloon', 'clm', 'value'));
676 INSERT INTO config.language_map (code, value) VALUES ('wol', oils_i18n_gettext('wol', 'Wolof', 'clm', 'value'));
677 INSERT INTO config.language_map (code, value) VALUES ('xal', oils_i18n_gettext('xal', 'Kalmyk', 'clm', 'value'));
678 INSERT INTO config.language_map (code, value) VALUES ('xho', oils_i18n_gettext('xho', 'Xhosa', 'clm', 'value'));
679 INSERT INTO config.language_map (code, value) VALUES ('yao', oils_i18n_gettext('yao', 'Yao (Africa)', 'clm', 'value'));
680 INSERT INTO config.language_map (code, value) VALUES ('yap', oils_i18n_gettext('yap', 'Yapese', 'clm', 'value'));
681 INSERT INTO config.language_map (code, value) VALUES ('yid', oils_i18n_gettext('yid', 'Yiddish', 'clm', 'value'));
682 INSERT INTO config.language_map (code, value) VALUES ('yor', oils_i18n_gettext('yor', 'Yoruba', 'clm', 'value'));
683 INSERT INTO config.language_map (code, value) VALUES ('ypk', oils_i18n_gettext('ypk', 'Yupik languages', 'clm', 'value'));
684 INSERT INTO config.language_map (code, value) VALUES ('zap', oils_i18n_gettext('zap', 'Zapotec', 'clm', 'value'));
685 INSERT INTO config.language_map (code, value) VALUES ('zen', oils_i18n_gettext('zen', 'Zenaga', 'clm', 'value'));
686 INSERT INTO config.language_map (code, value) VALUES ('zha', oils_i18n_gettext('zha', 'Zhuang', 'clm', 'value'));
687 INSERT INTO config.language_map (code, value) VALUES ('znd', oils_i18n_gettext('znd', 'Zande', 'clm', 'value'));
688 INSERT INTO config.language_map (code, value) VALUES ('zul', oils_i18n_gettext('zul', 'Zulu', 'clm', 'value'));
689 INSERT INTO config.language_map (code, value) VALUES ('zun', oils_i18n_gettext('zun', 'Zuni', 'clm', 'value'));
691 INSERT INTO config.item_form_map (code, value) VALUES ('a', oils_i18n_gettext('a', 'Microfilm', 'cifm', 'value'));
692 INSERT INTO config.item_form_map (code, value) VALUES ('b', oils_i18n_gettext('b', 'Microfiche', 'cifm', 'value'));
693 INSERT INTO config.item_form_map (code, value) VALUES ('c', oils_i18n_gettext('c', 'Microopaque', 'cifm', 'value'));
694 INSERT INTO config.item_form_map (code, value) VALUES ('d', oils_i18n_gettext('d', 'Large print', 'cifm', 'value'));
695 INSERT INTO config.item_form_map (code, value) VALUES ('f', oils_i18n_gettext('f', 'Braille', 'cifm', 'value'));
696 INSERT INTO config.item_form_map (code, value) VALUES ('r', oils_i18n_gettext('r', 'Regular print reproduction', 'cifm', 'value'));
697 INSERT INTO config.item_form_map (code, value) VALUES ('s', oils_i18n_gettext('s', 'Electronic', 'cifm', 'value'));
699 INSERT INTO config.item_type_map (code, value) VALUES ('a', oils_i18n_gettext('a', 'Language material', 'citm', 'value'));
700 INSERT INTO config.item_type_map (code, value) VALUES ('t', oils_i18n_gettext('t', 'Manuscript language material', 'citm', 'value'));
701 INSERT INTO config.item_type_map (code, value) VALUES ('g', oils_i18n_gettext('g', 'Projected medium', 'citm', 'value'));
702 INSERT INTO config.item_type_map (code, value) VALUES ('k', oils_i18n_gettext('k', 'Two-dimensional nonprojectable graphic', 'citm', 'value'));
703 INSERT INTO config.item_type_map (code, value) VALUES ('r', oils_i18n_gettext('r', 'Three-dimensional artifact or naturally occurring object', 'citm', 'value'));
704 INSERT INTO config.item_type_map (code, value) VALUES ('o', oils_i18n_gettext('o', 'Kit', 'citm', 'value'));
705 INSERT INTO config.item_type_map (code, value) VALUES ('p', oils_i18n_gettext('p', 'Mixed materials', 'citm', 'value'));
706 INSERT INTO config.item_type_map (code, value) VALUES ('e', oils_i18n_gettext('e', 'Cartographic material', 'citm', 'value'));
707 INSERT INTO config.item_type_map (code, value) VALUES ('f', oils_i18n_gettext('f', 'Manuscript cartographic material', 'citm', 'value'));
708 INSERT INTO config.item_type_map (code, value) VALUES ('c', oils_i18n_gettext('c', 'Notated music', 'citm', 'value'));
709 INSERT INTO config.item_type_map (code, value) VALUES ('d', oils_i18n_gettext('d', 'Manuscript notated music', 'citm', 'value'));
710 INSERT INTO config.item_type_map (code, value) VALUES ('i', oils_i18n_gettext('i', 'Nonmusical sound recording', 'citm', 'value'));
711 INSERT INTO config.item_type_map (code, value) VALUES ('j', oils_i18n_gettext('j', 'Musical sound recording', 'citm', 'value'));
712 INSERT INTO config.item_type_map (code, value) VALUES ('m', oils_i18n_gettext('m', 'Computer file', 'citm', 'value'));
714 INSERT INTO config.bib_level_map (code, value) VALUES ('a', oils_i18n_gettext('a', 'Monographic component part', 'cblvl', 'value'));
715 INSERT INTO config.bib_level_map (code, value) VALUES ('b', oils_i18n_gettext('b', 'Serial component part', 'cblvl', 'value'));
716 INSERT INTO config.bib_level_map (code, value) VALUES ('c', oils_i18n_gettext('c', 'Collection', 'cblvl', 'value'));
717 INSERT INTO config.bib_level_map (code, value) VALUES ('d', oils_i18n_gettext('d', 'Subunit', 'cblvl', 'value'));
718 INSERT INTO config.bib_level_map (code, value) VALUES ('i', oils_i18n_gettext('i', 'Integrating resource', 'cblvl', 'value'));
719 INSERT INTO config.bib_level_map (code, value) VALUES ('m', oils_i18n_gettext('m', 'Monograph/Item', 'cblvl', 'value'));
720 INSERT INTO config.bib_level_map (code, value) VALUES ('s', oils_i18n_gettext('s', 'Serial', 'cblvl', 'value'));
723 INSERT INTO config.i18n_locale (code,marc_code,name,description)
724 VALUES ('en-US', 'eng', oils_i18n_gettext('en-US', 'English (US)', 'i18n_l', 'name'),
725 oils_i18n_gettext('en-US', 'American English', 'i18n_l', 'description'));
726 INSERT INTO config.i18n_locale (code,marc_code,name,description)
727 VALUES ('en-CA', 'eng', oils_i18n_gettext('en-CA', 'English (Canada)', 'i18n_l', 'name'),
728 oils_i18n_gettext('en-CA', 'Canadian English', 'i18n_l', 'description'));
729 INSERT INTO config.i18n_locale (code,marc_code,name,description)
730 VALUES ('fr-CA', 'fre', oils_i18n_gettext('fr-CA', 'French (Canada)', 'i18n_l', 'name'),
731 oils_i18n_gettext('fr-CA', 'Canadian French', 'i18n_l', 'description'));
732 INSERT INTO config.i18n_locale (code,marc_code,name,description)
733 VALUES ('es-US', 'spa', oils_i18n_gettext('es-US', 'Spanish (US)', 'i18n_l', 'name'),
734 oils_i18n_gettext('es-US', 'American Spanish', 'i18n_l', 'description'));
735 INSERT INTO config.i18n_locale (code,marc_code,name,description)
736 VALUES ('es-MX', 'spa', oils_i18n_gettext('es-MX', 'Spanish (Mexico)', 'i18n_l', 'name'),
737 oils_i18n_gettext('es-MX', 'Mexican Spanish', 'i18n_l', 'description'));
738 INSERT INTO config.i18n_locale (code,marc_code,name,description)
739 VALUES ('hy-AM', 'arm', oils_i18n_gettext('hy-AM', 'Armenian', 'i18n_l', 'name'),
740 oils_i18n_gettext('hy-AM', 'Armenian', 'i18n_l', 'description'));
742 -- Z39.50 server attributes
744 INSERT INTO config.z3950_source (name, label, host, port, db, auth)
745 VALUES ('loc', oils_i18n_gettext('loc', 'Library of Congress', 'czs', 'label'), 'z3950.loc.gov', 7090, 'Voyager', FALSE);
746 INSERT INTO config.z3950_source (name, label, host, port, db, auth)
747 VALUES ('oclc', oils_i18n_gettext('oclc', 'OCLC', 'czs', 'label'), 'zcat.oclc.org', 210, 'OLUCWorldCat', TRUE);
748 INSERT INTO config.z3950_source (name, label, host, port, db, auth)
749 VALUES ('biblios', oils_i18n_gettext('biblios','‡biblios.net', 'czs', 'label'), 'z3950.biblios.net', 210, 'bibliographic', FALSE);
751 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
752 VALUES (1, 'loc','tcn', oils_i18n_gettext(1, 'Title Control Number', 'cza', 'label'), 12, 1);
753 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
754 VALUES (2, 'loc', 'isbn', oils_i18n_gettext(2, 'ISBN', 'cza', 'label'), 7, 6);
755 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
756 VALUES (3, 'loc', 'lccn', oils_i18n_gettext(3, 'LCCN', 'cza', 'label'), 9, 1);
757 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
758 VALUES (4, 'loc', 'author', oils_i18n_gettext(4, 'Author', 'cza', 'label'), 1003, 6);
759 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
760 VALUES (5, 'loc', 'title', oils_i18n_gettext(5, 'Title', 'cza', 'label'), 4, 6);
761 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
762 VALUES (6, 'loc', 'issn', oils_i18n_gettext(6, 'ISSN', 'cza', 'label'), 8, 1);
763 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
764 VALUES (7, 'loc', 'publisher', oils_i18n_gettext(7, 'Publisher', 'cza', 'label'), 1018, 6);
765 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
766 VALUES (8, 'loc', 'pubdate', oils_i18n_gettext(8, 'Publication Date', 'cza', 'label'), 31, 1);
767 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
768 VALUES (9, 'loc', 'item_type', oils_i18n_gettext(9, 'Item Type', 'cza', 'label'), 1001, 1);
770 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
771 VALUES (10, 'oclc', 'tcn', oils_i18n_gettext(10, 'Title Control Number', 'cza', 'label'), 12, 1);
772 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
773 VALUES (11, 'oclc', 'isbn', oils_i18n_gettext(11, 'ISBN', 'cza', 'label'), 7, 6);
774 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
775 VALUES (12, 'oclc', 'lccn', oils_i18n_gettext(12, 'LCCN', 'cza', 'label'), 9, 1);
776 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
777 VALUES (13, 'oclc', 'author', oils_i18n_gettext(13, 'Author', 'cza', 'label'), 1003, 6);
778 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
779 VALUES (14, 'oclc', 'title', oils_i18n_gettext(14, 'Title', 'cza', 'label'), 4, 6);
780 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
781 VALUES (15, 'oclc', 'issn', oils_i18n_gettext(15, 'ISSN', 'cza', 'label'), 8, 1);
782 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
783 VALUES (16, 'oclc', 'publisher', oils_i18n_gettext(16, 'Publisher', 'cza', 'label'), 1018, 6);
784 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
785 VALUES (17, 'oclc', 'pubdate', oils_i18n_gettext(17, 'Publication Date', 'cza', 'label'), 31, 1);
786 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
787 VALUES (18, 'oclc', 'item_type', oils_i18n_gettext(18, 'Item Type', 'cza', 'label'), 1001, 1);
789 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
790 VALUES (19, 'biblios','tcn', oils_i18n_gettext(19, 'Title Control Number', 'cza', 'label'), 12, 1);
791 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
792 VALUES (20, 'biblios', 'isbn', oils_i18n_gettext(20, 'ISBN', 'cza', 'label'), 7, 6);
793 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
794 VALUES (21, 'biblios', 'lccn', oils_i18n_gettext(21, 'LCCN', 'cza', 'label'), 9, 1);
795 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
796 VALUES (22, 'biblios', 'author', oils_i18n_gettext(22, 'Author', 'cza', 'label'), 1003, 6);
797 INSERT INTO config.z3950_attr (id, source, name, label, code, format, truncation)
798 VALUES (23, 'biblios', 'title', oils_i18n_gettext(23, 'Title', 'cza', 'label'), 4, 6, 1);
799 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
800 VALUES (24, 'biblios', 'issn', oils_i18n_gettext(24, 'ISSN', 'cza', 'label'), 8, 1);
801 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
802 VALUES (25, 'biblios', 'publisher', oils_i18n_gettext(25, 'Publisher', 'cza', 'label'), 1018, 6);
803 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
804 VALUES (26, 'biblios', 'pubdate', oils_i18n_gettext(26, 'Publication Date', 'cza', 'label'), 31, 1);
805 INSERT INTO config.z3950_attr (id, source, name, label, code, format)
806 VALUES (27, 'biblios', 'item_type', oils_i18n_gettext(27, 'Item Type', 'cza', 'label'), 1001, 1);
809 SELECT SETVAL('config.z3950_attr_id_seq'::TEXT, 100);
811 --005.schema.actors.sql:
814 INSERT INTO actor.org_unit_type (id, name, opac_label, depth, parent, can_have_users, can_have_vols) VALUES
815 ( 1, oils_i18n_gettext(1, 'Consortium', 'aout', 'name'),
816 oils_i18n_gettext(1, 'Everywhere', 'aout', 'opac_label'), 0, NULL, FALSE, FALSE );
817 INSERT INTO actor.org_unit_type (id, name, opac_label, depth, parent, can_have_users, can_have_vols) VALUES
818 ( 2, oils_i18n_gettext(2, 'System', 'aout', 'name'),
819 oils_i18n_gettext(2, 'Local Library System', 'aout', 'opac_label'), 1, 1, FALSE, FALSE );
820 INSERT INTO actor.org_unit_type (id, name, opac_label, depth, parent) VALUES
821 ( 3, oils_i18n_gettext(3, 'Branch', 'aout', 'name'),
822 oils_i18n_gettext(3, 'This Branch', 'aout', 'opac_label'), 2, 2 );
823 INSERT INTO actor.org_unit_type (id, name, opac_label, depth, parent) VALUES
824 ( 4, oils_i18n_gettext(4, 'Sub-library', 'aout', 'name'),
825 oils_i18n_gettext(4, 'This Specialized Library', 'aout', 'opac_label'), 3, 3 );
826 INSERT INTO actor.org_unit_type (id, name, opac_label, depth, parent) VALUES
827 ( 5, oils_i18n_gettext(5, 'Bookmobile', 'aout', 'name'),
828 oils_i18n_gettext(5, 'Your Bookmobile', 'aout', 'opac_label'), 3, 3 );
829 SELECT SETVAL('actor.org_unit_type_id_seq'::TEXT, 100);
831 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
832 (1, NULL, 1, 'CONS', oils_i18n_gettext(1, 'Example Consortium', 'aou', 'name'));
833 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
834 (2, 1, 2, 'SYS1', oils_i18n_gettext(2, 'Example System 1', 'aou', 'name'));
835 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
836 (3, 1, 2, 'SYS2', oils_i18n_gettext(3, 'Example System 2', 'aou', 'name'));
837 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
838 (4, 2, 3, 'BR1', oils_i18n_gettext(4, 'Example Branch 1', 'aou', 'name'));
839 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
840 (5, 2, 3, 'BR2', oils_i18n_gettext(5, 'Example Branch 2', 'aou', 'name'));
841 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
842 (6, 3, 3, 'BR3', oils_i18n_gettext(6, 'Example Branch 3', 'aou', 'name'));
843 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
844 (7, 3, 3, 'BR4', oils_i18n_gettext(7, 'Example Branch 4', 'aou', 'name'));
845 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
846 (8, 4, 4, 'SL1', oils_i18n_gettext(8, 'Example Sub-library 1', 'aou', 'name'));
847 INSERT INTO actor.org_unit (id, parent_ou, ou_type, shortname, name) VALUES
848 (9, 6, 5, 'BM1', oils_i18n_gettext(9, 'Example Bookmobile 1', 'aou', 'name'));
849 SELECT SETVAL('actor.org_unit_id_seq'::TEXT, 100);
851 INSERT INTO actor.org_address VALUES (DEFAULT,DEFAULT,DEFAULT,1,'123 Main St.',NULL,'Anywhere',NULL,'GA','US','30303');
853 UPDATE actor.org_unit SET holds_address = 1, ill_address = 1, billing_address = 1, mailing_address = 1;
855 INSERT INTO config.billing_type (id, name, owner) VALUES
856 ( 1, oils_i18n_gettext(1, 'Overdue Materials', 'cbt', 'name'), 1);
857 INSERT INTO config.billing_type (id, name, owner) VALUES
858 ( 2, oils_i18n_gettext(2, 'Long Overdue Collection Fee', 'cbt', 'name'), 1);
859 INSERT INTO config.billing_type (id, name, owner) VALUES
860 ( 3, oils_i18n_gettext(3, 'Lost Materials', 'cbt', 'name'), 1);
861 INSERT INTO config.billing_type (id, name, owner) VALUES
862 ( 4, oils_i18n_gettext(4, 'Lost Materials Processing Fee', 'cbt', 'name'), 1);
863 INSERT INTO config.billing_type (id, name, owner) VALUES
864 ( 5, oils_i18n_gettext(5, 'System: Deposit', 'cbt', 'name'), 1);
865 INSERT INTO config.billing_type (id, name, owner) VALUES
866 ( 6, oils_i18n_gettext(6, 'System: Rental', 'cbt', 'name'), 1);
867 INSERT INTO config.billing_type (id, name, owner) VALUES
868 ( 7, oils_i18n_gettext(7, 'Damaged Item', 'cbt', 'name'), 1);
869 INSERT INTO config.billing_type (id, name, owner) VALUES
870 ( 8, oils_i18n_gettext(8, 'Damaged Item Processing Fee', 'cbt', 'name'), 1);
871 INSERT INTO config.billing_type (id, name, owner) VALUES
872 ( 9, oils_i18n_gettext(9, 'Notification Fee', 'cbt', 'name'), 1);
874 SELECT SETVAL('config.billing_type_id_seq'::TEXT, 100);
876 INSERT INTO config.billing_type (name, owner) VALUES ( oils_i18n_gettext('Misc', 'Misc', 'cbt', 'name'), 1);
878 --006.data.permissions.sql:
879 INSERT INTO permission.perm_list VALUES
880 (-1, 'EVERYTHING', NULL);
881 INSERT INTO permission.perm_list VALUES
882 (2, 'OPAC_LOGIN', oils_i18n_gettext(2, 'Allow a user to log in to the OPAC', 'ppl', 'description'));
883 INSERT INTO permission.perm_list VALUES
884 (4, 'STAFF_LOGIN', oils_i18n_gettext(4, 'Allow a user to log in to the staff client', 'ppl', 'description'));
885 INSERT INTO permission.perm_list VALUES
886 (5, 'MR_HOLDS', oils_i18n_gettext(5, 'Allow a user to create a metarecord holds', 'ppl', 'description'));
887 INSERT INTO permission.perm_list VALUES
888 (6, 'TITLE_HOLDS', oils_i18n_gettext(6, 'Allow a user to place a hold at the title level', 'ppl', 'description'));
889 INSERT INTO permission.perm_list VALUES
890 (7, 'VOLUME_HOLDS', oils_i18n_gettext(7, 'Allow a user to place a volume level hold', 'ppl', 'description'));
891 INSERT INTO permission.perm_list VALUES
892 (8, 'COPY_HOLDS', oils_i18n_gettext(8, 'Allow a user to place a hold on a specific copy', 'ppl', 'description'));
893 INSERT INTO permission.perm_list VALUES
894 (9, 'REQUEST_HOLDS', oils_i18n_gettext(9, 'Allow a user to create holds for another user (if true, we still check to make sure they have permission to make the type of hold they are requesting, for example, COPY_HOLDS)', 'ppl', 'description'));
895 INSERT INTO permission.perm_list VALUES
896 (10, 'REQUEST_HOLDS_OVERRIDE', oils_i18n_gettext(10, '* no longer applicable', 'ppl', 'description'));
897 INSERT INTO permission.perm_list VALUES
898 (11, 'VIEW_HOLD', oils_i18n_gettext(11, 'Allow a user to view another user''s holds', 'ppl', 'description'));
899 INSERT INTO permission.perm_list VALUES
900 (13, 'DELETE_HOLDS', oils_i18n_gettext(13, '* no longer applicable', 'ppl', 'description'));
901 INSERT INTO permission.perm_list VALUES
902 (14, 'UPDATE_HOLD', oils_i18n_gettext(14, 'Allow a user to update another user''s hold', 'ppl', 'description'));
903 INSERT INTO permission.perm_list VALUES
904 (15, 'RENEW_CIRC', oils_i18n_gettext(15, 'Allow a user to renew items', 'ppl', 'description'));
905 INSERT INTO permission.perm_list VALUES
906 (16, 'VIEW_USER_FINES_SUMMARY', oils_i18n_gettext(16, 'Allow a user to view bill details', 'ppl', 'description'));
907 INSERT INTO permission.perm_list VALUES
908 (17, 'VIEW_USER_TRANSACTIONS', oils_i18n_gettext(17, 'Allow a user to see another user''s grocery or circulation transactions in the Bills Interface; duplicate of VIEW_TRANSACTION', 'ppl', 'description'));
909 INSERT INTO permission.perm_list VALUES
910 (18, 'UPDATE_MARC', oils_i18n_gettext(18, 'Allow a user to edit a MARC record', 'ppl', 'description'));
911 INSERT INTO permission.perm_list VALUES
912 (19, 'CREATE_MARC', oils_i18n_gettext(19, 'Allow a user to create new MARC records', 'ppl', 'description'));
913 INSERT INTO permission.perm_list VALUES
914 (20, 'IMPORT_MARC', oils_i18n_gettext(20, 'Allow a user to import a MARC record via the Z39.50 interface', 'ppl', 'description'));
915 INSERT INTO permission.perm_list VALUES
916 (21, 'CREATE_VOLUME', oils_i18n_gettext(21, 'Allow a user to create a volume', 'ppl', 'description'));
917 INSERT INTO permission.perm_list VALUES
918 (22, 'UPDATE_VOLUME', oils_i18n_gettext(22, 'Allow a user to edit volumes - needed for merging records. This is a duplicate of VOLUME_UPDATE; user must have both permissions at appropriate level to merge records.', 'ppl', 'description'));
919 INSERT INTO permission.perm_list VALUES
920 (23, 'DELETE_VOLUME', oils_i18n_gettext(23, 'Allow a user to delete a volume', 'ppl', 'description'));
921 INSERT INTO permission.perm_list VALUES
922 (25, 'UPDATE_COPY', oils_i18n_gettext(25, 'Allow a user to edit a copy', 'ppl', 'description'));
923 INSERT INTO permission.perm_list VALUES
924 (26, 'DELETE_COPY', oils_i18n_gettext(26, 'Allow a user to delete a copy', 'ppl', 'description'));
925 INSERT INTO permission.perm_list VALUES
926 (27, 'RENEW_HOLD_OVERRIDE', oils_i18n_gettext(27, 'Allow a user to continue to renew an item even if it is required for a hold', 'ppl', 'description'));
927 INSERT INTO permission.perm_list VALUES
928 (28, 'CREATE_USER', oils_i18n_gettext(28, 'Allow a user to create another user', 'ppl', 'description'));
929 INSERT INTO permission.perm_list VALUES
930 (29, 'UPDATE_USER', oils_i18n_gettext(29, 'Allow a user to edit a user''s record', 'ppl', 'description'));
931 INSERT INTO permission.perm_list VALUES
932 (30, 'DELETE_USER', oils_i18n_gettext(30, 'Allow a user to delete another user, including all associated transactions', 'ppl', 'description'));
933 INSERT INTO permission.perm_list VALUES
934 (31, 'VIEW_USER', oils_i18n_gettext(31, 'Allow a user to view another user''s Patron Record', 'ppl', 'description'));
935 INSERT INTO permission.perm_list VALUES
936 (32, 'COPY_CHECKIN', oils_i18n_gettext(32, 'Allow a user to check in a copy', 'ppl', 'description'));
937 INSERT INTO permission.perm_list VALUES
938 (33, 'CREATE_TRANSIT', oils_i18n_gettext(33, 'Allow a user to place an item in transit', 'ppl', 'description'));
939 INSERT INTO permission.perm_list VALUES
940 (34, 'VIEW_PERMISSION', oils_i18n_gettext(34, 'Allow a user to view user permissions within the user permissions editor', 'ppl', 'description'));
941 INSERT INTO permission.perm_list VALUES
942 (35, 'CHECKIN_BYPASS_HOLD_FULFILL', oils_i18n_gettext(35, '* no longer applicable', 'ppl', 'description'));
943 INSERT INTO permission.perm_list VALUES
944 (36, 'CREATE_PAYMENT', oils_i18n_gettext(36, 'Allow a user to record payments in the Billing Interface', 'ppl', 'description'));
945 INSERT INTO permission.perm_list VALUES
946 (37, 'SET_CIRC_LOST', oils_i18n_gettext(37, 'Allow a user to mark an item as ''lost''', 'ppl', 'description'));
947 INSERT INTO permission.perm_list VALUES
948 (38, 'SET_CIRC_MISSING', oils_i18n_gettext(38, 'Allow a user to mark an item as ''missing''', 'ppl', 'description'));
949 INSERT INTO permission.perm_list VALUES
950 (39, 'SET_CIRC_CLAIMS_RETURNED', oils_i18n_gettext(39, 'Allow a user to mark an item as ''claims returned''', 'ppl', 'description'));
951 INSERT INTO permission.perm_list VALUES
952 (41, 'CREATE_TRANSACTION', oils_i18n_gettext(41, 'Allow a user to create a new billable transaction', 'ppl', 'description'));
953 INSERT INTO permission.perm_list VALUES
954 (43, 'CREATE_BILL', oils_i18n_gettext(43, 'Allow a user to create a new bill on a transaction', 'ppl', 'description'));
955 INSERT INTO permission.perm_list VALUES
956 (44, 'VIEW_CONTAINER', oils_i18n_gettext(44, 'Allow a user to view another user''s containers (buckets)', 'ppl', 'description'));
957 INSERT INTO permission.perm_list VALUES
958 (45, 'CREATE_CONTAINER', oils_i18n_gettext(45, 'Allow a user to create a new container for another user', 'ppl', 'description'));
959 INSERT INTO permission.perm_list VALUES
960 (24, 'CREATE_COPY', oils_i18n_gettext(24, 'Allow a user to create a new copy object', 'ppl', 'description'));
961 INSERT INTO permission.perm_list VALUES
962 (47, 'UPDATE_ORG_UNIT', oils_i18n_gettext(47, 'Allow a user to change the settings for an organization unit', 'ppl', 'description'));
963 INSERT INTO permission.perm_list VALUES
964 (48, 'VIEW_CIRCULATIONS', oils_i18n_gettext(48, 'Allow a user to see what another user has checked out', 'ppl', 'description'));
965 INSERT INTO permission.perm_list VALUES
966 (42, 'VIEW_TRANSACTION', oils_i18n_gettext(42, 'Allow a user may view another user''s transactions', 'ppl', 'description'));
967 INSERT INTO permission.perm_list VALUES
968 (49, 'DELETE_CONTAINER', oils_i18n_gettext(49, 'Allow a user to delete another user''s container', 'ppl', 'description'));
969 INSERT INTO permission.perm_list VALUES
970 (50, 'CREATE_CONTAINER_ITEM', oils_i18n_gettext(50, 'Allow a user to create a container item for another user', 'ppl', 'description'));
971 INSERT INTO permission.perm_list VALUES
972 (51, 'CREATE_USER_GROUP_LINK', oils_i18n_gettext(51, 'Allow a user to add other users to permission groups', 'ppl', 'description'));
973 INSERT INTO permission.perm_list VALUES
974 (52, 'REMOVE_USER_GROUP_LINK', oils_i18n_gettext(52, 'Allow a user to remove other users from permission groups', 'ppl', 'description'));
975 INSERT INTO permission.perm_list VALUES
976 (53, 'VIEW_PERM_GROUPS', oils_i18n_gettext(53, 'Allow a user to view other users'' permission groups', 'ppl', 'description'));
977 INSERT INTO permission.perm_list VALUES
978 (54, 'VIEW_PERMIT_CHECKOUT', oils_i18n_gettext(54, 'Allow a user to determine whether another user can check out an item', 'ppl', 'description'));
979 INSERT INTO permission.perm_list VALUES
980 (55, 'UPDATE_BATCH_COPY', oils_i18n_gettext(55, 'Allow a user to edit copies in batch', 'ppl', 'description'));
981 INSERT INTO permission.perm_list VALUES
982 (56, 'CREATE_PATRON_STAT_CAT', oils_i18n_gettext(56, 'User may create a new patron statistical category', 'ppl', 'description'));
983 INSERT INTO permission.perm_list VALUES
984 (57, 'CREATE_COPY_STAT_CAT', oils_i18n_gettext(57, 'User may create a copy statistical category', 'ppl', 'description'));
985 INSERT INTO permission.perm_list VALUES
986 (58, 'CREATE_PATRON_STAT_CAT_ENTRY', oils_i18n_gettext(58, 'User may create an entry in a patron statistical category', 'ppl', 'description'));
987 INSERT INTO permission.perm_list VALUES
988 (59, 'CREATE_COPY_STAT_CAT_ENTRY', oils_i18n_gettext(59, 'User may create an entry in a copy statistical category', 'ppl', 'description'));
989 INSERT INTO permission.perm_list VALUES
990 (60, 'UPDATE_PATRON_STAT_CAT', oils_i18n_gettext(60, 'User may update a patron statistical category', 'ppl', 'description'));
991 INSERT INTO permission.perm_list VALUES
992 (61, 'UPDATE_COPY_STAT_CAT', oils_i18n_gettext(61, 'User may update a copy statistical category', 'ppl', 'description'));
993 INSERT INTO permission.perm_list VALUES
994 (62, 'UPDATE_PATRON_STAT_CAT_ENTRY', oils_i18n_gettext(62, 'User may update an entry in a patron statistical category', 'ppl', 'description'));
995 INSERT INTO permission.perm_list VALUES
996 (63, 'UPDATE_COPY_STAT_CAT_ENTRY', oils_i18n_gettext(63, 'User may update an entry in a copy statistical category', 'ppl', 'description'));
997 INSERT INTO permission.perm_list VALUES
998 (65, 'CREATE_COPY_STAT_CAT_ENTRY_MAP', oils_i18n_gettext(65, 'User may link a copy to an entry in a statistical category', 'ppl', 'description'));
999 INSERT INTO permission.perm_list VALUES
1000 (64, 'CREATE_PATRON_STAT_CAT_ENTRY_MAP', oils_i18n_gettext(64, 'User may link another user to an entry in a statistical category', 'ppl', 'description'));
1001 INSERT INTO permission.perm_list VALUES
1002 (66, 'DELETE_PATRON_STAT_CAT', oils_i18n_gettext(66, 'User may delete a patron statistical category', 'ppl', 'description'));
1003 INSERT INTO permission.perm_list VALUES
1004 (67, 'DELETE_COPY_STAT_CAT', oils_i18n_gettext(67, 'User may delete a copy statistical category', 'ppl', 'description'));
1005 INSERT INTO permission.perm_list VALUES
1006 (68, 'DELETE_PATRON_STAT_CAT_ENTRY', oils_i18n_gettext(68, 'User may delete an entry from a patron statistical category', 'ppl', 'description'));
1007 INSERT INTO permission.perm_list VALUES
1008 (69, 'DELETE_COPY_STAT_CAT_ENTRY', oils_i18n_gettext(69, 'User may delete an entry from a copy statistical category', 'ppl', 'description'));
1009 INSERT INTO permission.perm_list VALUES
1010 (70, 'DELETE_PATRON_STAT_CAT_ENTRY_MAP', oils_i18n_gettext(70, 'User may delete a patron statistical category entry map', 'ppl', 'description'));
1011 INSERT INTO permission.perm_list VALUES
1012 (71, 'DELETE_COPY_STAT_CAT_ENTRY_MAP', oils_i18n_gettext(71, 'User may delete a copy statistical category entry map', 'ppl', 'description'));
1013 INSERT INTO permission.perm_list VALUES
1014 (72, 'CREATE_NON_CAT_TYPE', oils_i18n_gettext(72, 'Allow a user to create a new non-cataloged item type', 'ppl', 'description'));
1015 INSERT INTO permission.perm_list VALUES
1016 (73, 'UPDATE_NON_CAT_TYPE', oils_i18n_gettext(73, 'Allow a user to update a non-cataloged item type', 'ppl', 'description'));
1017 INSERT INTO permission.perm_list VALUES
1018 (74, 'CREATE_IN_HOUSE_USE', oils_i18n_gettext(74, 'Allow a user to create a new in-house-use ', 'ppl', 'description'));
1019 INSERT INTO permission.perm_list VALUES
1020 (75, 'COPY_CHECKOUT', oils_i18n_gettext(75, 'Allow a user to check out a copy', 'ppl', 'description'));
1021 INSERT INTO permission.perm_list VALUES
1022 (76, 'CREATE_COPY_LOCATION', oils_i18n_gettext(76, 'Allow a user to create a new copy location', 'ppl', 'description'));
1023 INSERT INTO permission.perm_list VALUES
1024 (77, 'UPDATE_COPY_LOCATION', oils_i18n_gettext(77, 'Allow a user to update a copy location', 'ppl', 'description'));
1025 INSERT INTO permission.perm_list VALUES
1026 (78, 'DELETE_COPY_LOCATION', oils_i18n_gettext(78, 'Allow a user to delete a copy location', 'ppl', 'description'));
1027 INSERT INTO permission.perm_list VALUES
1028 (79, 'CREATE_COPY_TRANSIT', oils_i18n_gettext(79, 'Allow a user to create a transit_copy object for transiting a copy', 'ppl', 'description'));
1029 INSERT INTO permission.perm_list VALUES
1030 (80, 'COPY_TRANSIT_RECEIVE', oils_i18n_gettext(80, 'Allow a user to close out a transit on a copy', 'ppl', 'description'));
1031 INSERT INTO permission.perm_list VALUES
1032 (81, 'VIEW_HOLD_PERMIT', oils_i18n_gettext(81, 'Allow a user to see if another user has permission to place a hold on a given copy', 'ppl', 'description'));
1033 INSERT INTO permission.perm_list VALUES
1034 (82, 'VIEW_COPY_CHECKOUT_HISTORY', oils_i18n_gettext(82, 'Allow a user to view which users have checked out a given copy', 'ppl', 'description'));
1035 INSERT INTO permission.perm_list VALUES
1036 (83, 'REMOTE_Z3950_QUERY', oils_i18n_gettext(83, 'Allow a user to perform Z39.50 queries against remote servers', 'ppl', 'description'));
1037 INSERT INTO permission.perm_list VALUES
1038 (84, 'REGISTER_WORKSTATION', oils_i18n_gettext(84, 'Allow a user to register a new workstation', 'ppl', 'description'));
1039 INSERT INTO permission.perm_list VALUES
1040 (85, 'VIEW_COPY_NOTES', oils_i18n_gettext(85, 'Allow a user to view all notes attached to a copy', 'ppl', 'description'));
1041 INSERT INTO permission.perm_list VALUES
1042 (86, 'VIEW_VOLUME_NOTES', oils_i18n_gettext(86, 'Allow a user to view all notes attached to a volume', 'ppl', 'description'));
1043 INSERT INTO permission.perm_list VALUES
1044 (87, 'VIEW_TITLE_NOTES', oils_i18n_gettext(87, 'Allow a user to view all notes attached to a title', 'ppl', 'description'));
1045 INSERT INTO permission.perm_list VALUES
1046 (89, 'CREATE_VOLUME_NOTE', oils_i18n_gettext(89, 'Allow a user to create a new volume note', 'ppl', 'description'));
1047 INSERT INTO permission.perm_list VALUES
1048 (88, 'CREATE_COPY_NOTE', oils_i18n_gettext(88, 'Allow a user to create a new copy note', 'ppl', 'description'));
1049 INSERT INTO permission.perm_list VALUES
1050 (90, 'CREATE_TITLE_NOTE', oils_i18n_gettext(90, 'Allow a user to create a new title note', 'ppl', 'description'));
1051 INSERT INTO permission.perm_list VALUES
1052 (91, 'DELETE_COPY_NOTE', oils_i18n_gettext(91, 'Allow a user to delete another user''s copy notes', 'ppl', 'description'));
1053 INSERT INTO permission.perm_list VALUES
1054 (92, 'DELETE_VOLUME_NOTE', oils_i18n_gettext(92, 'Allow a user to delete another user''s volume note', 'ppl', 'description'));
1055 INSERT INTO permission.perm_list VALUES
1056 (93, 'DELETE_TITLE_NOTE', oils_i18n_gettext(93, 'Allow a user to delete another user''s title note', 'ppl', 'description'));
1057 INSERT INTO permission.perm_list VALUES
1058 (94, 'UPDATE_CONTAINER', oils_i18n_gettext(94, 'Allow a user to update another user''s container', 'ppl', 'description'));
1059 INSERT INTO permission.perm_list VALUES
1060 (95, 'CREATE_MY_CONTAINER', oils_i18n_gettext(95, 'Allow a user to create a container for themselves', 'ppl', 'description'));
1061 INSERT INTO permission.perm_list VALUES
1062 (96, 'VIEW_HOLD_NOTIFICATION', oils_i18n_gettext(96, 'Allow a user to view notifications attached to a hold', 'ppl', 'description'));
1063 INSERT INTO permission.perm_list VALUES
1064 (97, 'CREATE_HOLD_NOTIFICATION', oils_i18n_gettext(97, 'Allow a user to create new hold notifications', 'ppl', 'description'));
1065 INSERT INTO permission.perm_list VALUES
1066 (98, 'UPDATE_ORG_SETTING', oils_i18n_gettext(98, 'Allow a user to update an organization unit setting', 'ppl', 'description'));
1067 INSERT INTO permission.perm_list VALUES
1068 (99, 'OFFLINE_UPLOAD', oils_i18n_gettext(99, 'Allow a user to upload an offline script', 'ppl', 'description'));
1069 INSERT INTO permission.perm_list VALUES
1070 (100, 'OFFLINE_VIEW', oils_i18n_gettext(100, 'Allow a user to view uploaded offline script information', 'ppl', 'description'));
1071 INSERT INTO permission.perm_list VALUES
1072 (101, 'OFFLINE_EXECUTE', oils_i18n_gettext(101, 'Allow a user to execute an offline script batch', 'ppl', 'description'));
1073 INSERT INTO permission.perm_list VALUES
1074 (102, 'CIRC_OVERRIDE_DUE_DATE', oils_i18n_gettext(102, 'Allow a user to change the due date on an item to any date', 'ppl', 'description'));
1075 INSERT INTO permission.perm_list VALUES
1076 (103, 'CIRC_PERMIT_OVERRIDE', oils_i18n_gettext(103, 'Allow a user to bypass the circulation permit call for check out', 'ppl', 'description'));
1077 INSERT INTO permission.perm_list VALUES
1078 (104, 'COPY_IS_REFERENCE.override', oils_i18n_gettext(104, 'Allow a user to override the copy_is_reference event', 'ppl', 'description'));
1079 INSERT INTO permission.perm_list VALUES
1080 (105, 'VOID_BILLING', oils_i18n_gettext(105, 'Allow a user to void a bill', 'ppl', 'description'));
1081 INSERT INTO permission.perm_list VALUES
1082 (106, 'CIRC_CLAIMS_RETURNED.override', oils_i18n_gettext(106, 'Allow a user to check in or check out an item that has a status of ''claims returned''', 'ppl', 'description'));
1083 INSERT INTO permission.perm_list VALUES
1084 (107, 'COPY_BAD_STATUS.override', oils_i18n_gettext(107, 'Allow a user to check out an item in a non-circulatable status', 'ppl', 'description'));
1085 INSERT INTO permission.perm_list VALUES
1086 (108, 'COPY_ALERT_MESSAGE.override', oils_i18n_gettext(108, 'Allow a user to check in/out an item that has an alert message', 'ppl', 'description'));
1087 INSERT INTO permission.perm_list VALUES
1088 (109, 'COPY_STATUS_LOST.override', oils_i18n_gettext(109, 'Allow a user to remove the lost status from a copy', 'ppl', 'description'));
1089 INSERT INTO permission.perm_list VALUES
1090 (110, 'COPY_STATUS_MISSING.override', oils_i18n_gettext(110, 'Allow a user to change the missing status on a copy', 'ppl', 'description'));
1091 INSERT INTO permission.perm_list VALUES
1092 (111, 'ABORT_TRANSIT', oils_i18n_gettext(111, 'Allow a user to abort a copy transit if the user is at the transit destination or source', 'ppl', 'description'));
1093 INSERT INTO permission.perm_list VALUES
1094 (112, 'ABORT_REMOTE_TRANSIT', oils_i18n_gettext(112, 'Allow a user to abort a copy transit if the user is not at the transit source or dest', 'ppl', 'description'));
1095 INSERT INTO permission.perm_list VALUES
1096 (113, 'VIEW_ZIP_DATA', oils_i18n_gettext(113, 'Allow a user to query the ZIP code data method', 'ppl', 'description'));
1097 INSERT INTO permission.perm_list VALUES
1098 (114, 'CANCEL_HOLDS', oils_i18n_gettext(114, 'Allow a user to cancel holds', 'ppl', 'description'));
1099 INSERT INTO permission.perm_list VALUES
1100 (115, 'CREATE_DUPLICATE_HOLDS', oils_i18n_gettext(115, 'Allow a user to create duplicate holds (two or more holds on the same title)', 'ppl', 'description'));
1101 INSERT INTO permission.perm_list VALUES
1102 (117, 'actor.org_unit.closed_date.update', oils_i18n_gettext(117, 'Allow a user to update a closed date interval for a given location', 'ppl', 'description'));
1103 INSERT INTO permission.perm_list VALUES
1104 (116, 'actor.org_unit.closed_date.delete', oils_i18n_gettext(116, 'Allow a user to remove a closed date interval for a given location', 'ppl', 'description'));
1105 INSERT INTO permission.perm_list VALUES
1106 (118, 'actor.org_unit.closed_date.create', oils_i18n_gettext(118, 'Allow a user to create a new closed date for a location', 'ppl', 'description'));
1107 INSERT INTO permission.perm_list VALUES
1108 (119, 'DELETE_NON_CAT_TYPE', oils_i18n_gettext(119, 'Allow a user to delete a non cataloged type', 'ppl', 'description'));
1109 INSERT INTO permission.perm_list VALUES
1110 (120, 'money.collections_tracker.create', oils_i18n_gettext(120, 'Allow a user to put someone into collections', 'ppl', 'description'));
1111 INSERT INTO permission.perm_list VALUES
1112 (121, 'money.collections_tracker.delete', oils_i18n_gettext(121, 'Allow a user to remove someone from collections', 'ppl', 'description'));
1113 INSERT INTO permission.perm_list VALUES
1114 (122, 'BAR_PATRON', oils_i18n_gettext(122, 'Allow a user to bar a patron', 'ppl', 'description'));
1115 INSERT INTO permission.perm_list VALUES
1116 (123, 'UNBAR_PATRON', oils_i18n_gettext(123, 'Allow a user to un-bar a patron', 'ppl', 'description'));
1117 INSERT INTO permission.perm_list VALUES
1118 (124, 'DELETE_WORKSTATION', oils_i18n_gettext(124, 'Allow a user to remove an existing workstation so a new one can replace it', 'ppl', 'description'));
1119 INSERT INTO permission.perm_list VALUES
1120 (125, 'group_application.user', oils_i18n_gettext(125, 'Allow a user to add/remove users to/from the "User" group', 'ppl', 'description'));
1121 INSERT INTO permission.perm_list VALUES
1122 (126, 'group_application.user.patron', oils_i18n_gettext(126, 'Allow a user to add/remove users to/from the "Patron" group', 'ppl', 'description'));
1123 INSERT INTO permission.perm_list VALUES
1124 (127, 'group_application.user.staff', oils_i18n_gettext(127, 'Allow a user to add/remove users to/from the "Staff" group', 'ppl', 'description'));
1125 INSERT INTO permission.perm_list VALUES
1126 (128, 'group_application.user.staff.circ', oils_i18n_gettext(128, 'Allow a user to add/remove users to/from the "Circulator" group', 'ppl', 'description'));
1127 INSERT INTO permission.perm_list VALUES
1128 (129, 'group_application.user.staff.cat', oils_i18n_gettext(129, 'Allow a user to add/remove users to/from the "Cataloger" group', 'ppl', 'description'));
1129 INSERT INTO permission.perm_list VALUES
1130 (130, 'group_application.user.staff.admin.global_admin', oils_i18n_gettext(130, 'Allow a user to add/remove users to/from the "GlobalAdmin" group', 'ppl', 'description'));
1131 INSERT INTO permission.perm_list VALUES
1132 (131, 'group_application.user.staff.admin.local_admin', oils_i18n_gettext(131, 'Allow a user to add/remove users to/from the "LocalAdmin" group', 'ppl', 'description'));
1133 INSERT INTO permission.perm_list VALUES
1134 (132, 'group_application.user.staff.admin.lib_manager', oils_i18n_gettext(132, 'Allow a user to add/remove users to/from the "LibraryManager" group', 'ppl', 'description'));
1135 INSERT INTO permission.perm_list VALUES
1136 (133, 'group_application.user.staff.cat.cat1', oils_i18n_gettext(133, 'Allow a user to add/remove users to/from the "Cat1" group', 'ppl', 'description'));
1137 INSERT INTO permission.perm_list VALUES
1138 (134, 'group_application.user.staff.supercat', oils_i18n_gettext(134, 'Allow a user to add/remove users to/from the "Supercat" group', 'ppl', 'description'));
1139 INSERT INTO permission.perm_list VALUES
1140 (135, 'group_application.user.sip_client', oils_i18n_gettext(135, 'Allow a user to add/remove users to/from the "SIP-Client" group', 'ppl', 'description'));
1141 INSERT INTO permission.perm_list VALUES
1142 (136, 'group_application.user.vendor', oils_i18n_gettext(136, 'Allow a user to add/remove users to/from the "Vendor" group', 'ppl', 'description'));
1143 INSERT INTO permission.perm_list VALUES
1144 (137, 'ITEM_AGE_PROTECTED.override', oils_i18n_gettext(137, 'Allow a user to place a hold on an age-protected item', 'ppl', 'description'));
1145 INSERT INTO permission.perm_list VALUES
1146 (138, 'MAX_RENEWALS_REACHED.override', oils_i18n_gettext(138, 'Allow a user to renew an item past the maximum renewal count', 'ppl', 'description'));
1147 INSERT INTO permission.perm_list VALUES
1148 (139, 'PATRON_EXCEEDS_CHECKOUT_COUNT.override', oils_i18n_gettext(139, 'Allow staff to override checkout count failure', 'ppl', 'description'));
1149 INSERT INTO permission.perm_list VALUES
1150 (140, 'PATRON_EXCEEDS_OVERDUE_COUNT.override', oils_i18n_gettext(140, 'Allow staff to override overdue count failure', 'ppl', 'description'));
1151 INSERT INTO permission.perm_list VALUES
1152 (141, 'PATRON_EXCEEDS_FINES.override', oils_i18n_gettext(141, 'Allow staff to override fine amount checkout failure', 'ppl', 'description'));
1153 INSERT INTO permission.perm_list VALUES
1154 (142, 'CIRC_EXCEEDS_COPY_RANGE.override', oils_i18n_gettext(142, 'Allow staff to override circulation copy range failure', 'ppl', 'description'));
1155 INSERT INTO permission.perm_list VALUES
1156 (143, 'ITEM_ON_HOLDS_SHELF.override', oils_i18n_gettext(143, 'Allow staff to override item on holds shelf failure', 'ppl', 'description'));
1157 INSERT INTO permission.perm_list VALUES
1158 (144, 'COPY_NOT_AVAILABLE.override', oils_i18n_gettext(144, 'Allow staff to force checkout of Missing/Lost type items', 'ppl', 'description'));
1159 INSERT INTO permission.perm_list VALUES
1160 (146, 'HOLD_EXISTS.override', oils_i18n_gettext(146, 'Allow a user to place multiple holds on a single title', 'ppl', 'description'));
1161 INSERT INTO permission.perm_list VALUES
1162 (147, 'RUN_REPORTS', oils_i18n_gettext(147, 'Allow a user to run reports', 'ppl', 'description'));
1163 INSERT INTO permission.perm_list VALUES
1164 (148, 'SHARE_REPORT_FOLDER', oils_i18n_gettext(148, 'Allow a user to share report his own folders', 'ppl', 'description'));
1165 INSERT INTO permission.perm_list VALUES
1166 (149, 'VIEW_REPORT_OUTPUT', oils_i18n_gettext(149, 'Allow a user to view report output', 'ppl', 'description'));
1167 INSERT INTO permission.perm_list VALUES
1168 (150, 'COPY_CIRC_NOT_ALLOWED.override', oils_i18n_gettext(150, 'Allow a user to checkout an item that is marked as non-circ', 'ppl', 'description'));
1169 INSERT INTO permission.perm_list VALUES
1170 (151, 'DELETE_CONTAINER_ITEM', oils_i18n_gettext(151, 'Allow a user to delete an item out of another user''s container', 'ppl', 'description'));
1171 INSERT INTO permission.perm_list VALUES
1172 (152, 'ASSIGN_WORK_ORG_UNIT', oils_i18n_gettext(152, 'Allow a staff member to define where another staff member has their permissions', 'ppl', 'description'));
1173 INSERT INTO permission.perm_list VALUES
1174 (153, 'CREATE_FUNDING_SOURCE', oils_i18n_gettext(153, 'Allow a user to create a new funding source', 'ppl', 'description')),
1175 (154, 'DELETE_FUNDING_SOURCE', oils_i18n_gettext(154, 'Allow a user to delete a funding source', 'ppl', 'description')),
1176 (155, 'VIEW_FUNDING_SOURCE', oils_i18n_gettext(155, 'Allow a user to view a funding source', 'ppl', 'description')),
1177 (156, 'UPDATE_FUNDING_SOURCE', oils_i18n_gettext(156, 'Allow a user to update a funding source', 'ppl', 'description')),
1178 (157, 'CREATE_FUND', oils_i18n_gettext(157, 'Allow a user to create a new fund', 'ppl', 'description')),
1179 (158, 'DELETE_FUND', oils_i18n_gettext(158, 'Allow a user to delete a fund', 'ppl', 'description')),
1180 (159, 'VIEW_FUND', oils_i18n_gettext(159, 'Allow a user to view a fund', 'ppl', 'description')),
1181 (160, 'UPDATE_FUND', oils_i18n_gettext(160, 'Allow a user to update a fund', 'ppl', 'description')),
1182 (161, 'CREATE_FUND_ALLOCATION', oils_i18n_gettext(161, 'Allow a user to create a new fund allocation', 'ppl', 'description')),
1183 (162, 'DELETE_FUND_ALLOCATION', oils_i18n_gettext(162, 'Allow a user to delete a fund allocation', 'ppl', 'description')),
1184 (163, 'VIEW_FUND_ALLOCATION', oils_i18n_gettext(163, 'Allow a user to view a fund allocation', 'ppl', 'description')),
1185 (164, 'UPDATE_FUND_ALLOCATION', oils_i18n_gettext(164, 'Allow a user to update a fund allocation', 'ppl', 'description')),
1186 (165, 'GENERAL_ACQ', oils_i18n_gettext(165, 'Lowest level permission required to access the ACQ interface', 'ppl', 'description')),
1187 (166, 'CREATE_PROVIDER', oils_i18n_gettext(166, 'Allow a user to create a new provider', 'ppl', 'description')),
1188 (167, 'DELETE_PROVIDER', oils_i18n_gettext(167, 'Allow a user to delate a provider', 'ppl', 'description')),
1189 (168, 'VIEW_PROVIDER', oils_i18n_gettext(168, 'Allow a user to view a provider', 'ppl', 'description')),
1190 (169, 'UPDATE_PROVIDER', oils_i18n_gettext(169, 'Allow a user to update a provider', 'ppl', 'description')),
1191 (170, 'ADMIN_FUNDING_SOURCE', oils_i18n_gettext(170, 'Allow a user to create/view/update/delete a funding source', 'ppl', 'description')),
1192 (171, 'ADMIN_FUND', oils_i18n_gettext(171, '(Deprecated) Allow a user to create/view/update/delete a fund', 'ppl', 'description')),
1193 (172, 'MANAGE_FUNDING_SOURCE', oils_i18n_gettext(172, 'Allow a user to view/credit/debit a funding source', 'ppl', 'description')),
1194 (173, 'MANAGE_FUND', oils_i18n_gettext(173, 'Allow a user to view/credit/debit a fund', 'ppl', 'description')),
1195 (174, 'CREATE_PICKLIST', oils_i18n_gettext(174, 'Allows a user to create a picklist', 'ppl', 'description')),
1196 (175, 'ADMIN_PROVIDER', oils_i18n_gettext(175, 'Allow a user to create/view/update/delete a provider', 'ppl', 'description')),
1197 (176, 'MANAGE_PROVIDER', oils_i18n_gettext(176, 'Allow a user to view and purchase from a provider', 'ppl', 'description')),
1198 (177, 'VIEW_PICKLIST', oils_i18n_gettext(177, 'Allow a user to view another users picklist', 'ppl', 'description')),
1199 (178, 'DELETE_RECORD', oils_i18n_gettext(178, 'Allow a staff member to directly remove a bibliographic record', 'ppl', 'description')),
1200 (179, 'ADMIN_CURRENCY_TYPE', oils_i18n_gettext(179, 'Allow a user to create/view/update/delete a currency_type', 'ppl', 'description')),
1201 (180, 'MARK_BAD_DEBT', oils_i18n_gettext(180, 'Allow a user to mark a transaction as bad (unrecoverable) debt', 'ppl', 'description')),
1202 (181, 'VIEW_BILLING_TYPE', oils_i18n_gettext(181, 'Allow a user to view billing types', 'ppl', 'description')),
1203 (182, 'MARK_ITEM_AVAILABLE', oils_i18n_gettext(182, 'Allow a user to mark an item status as ''available''', 'ppl', 'description')),
1204 (183, 'MARK_ITEM_CHECKED_OUT', oils_i18n_gettext(183, 'Allow a user to mark an item status as ''checked out''', 'ppl', 'description')),
1205 (184, 'MARK_ITEM_BINDERY', oils_i18n_gettext(184, 'Allow a user to mark an item status as ''bindery''', 'ppl', 'description')),
1206 (185, 'MARK_ITEM_LOST', oils_i18n_gettext(185, 'Allow a user to mark an item status as ''lost''', 'ppl', 'description')),
1207 (186, 'MARK_ITEM_MISSING', oils_i18n_gettext(186, 'Allow a user to mark an item status as ''missing''', 'ppl', 'description')),
1208 (187, 'MARK_ITEM_IN_PROCESS', oils_i18n_gettext(187, 'Allow a user to mark an item status as ''in process''', 'ppl', 'description')),
1209 (188, 'MARK_ITEM_IN_TRANSIT', oils_i18n_gettext(188, 'Allow a user to mark an item status as ''in transit''', 'ppl', 'description')),
1210 (189, 'MARK_ITEM_RESHELVING', oils_i18n_gettext(189, 'Allow a user to mark an item status as ''reshelving''', 'ppl', 'description')),
1211 (190, 'MARK_ITEM_ON_HOLDS_SHELF', oils_i18n_gettext(190, 'Allow a user to mark an item status as ''on holds shelf''', 'ppl', 'description')),
1212 (191, 'MARK_ITEM_ON_ORDER', oils_i18n_gettext(191, 'Allow a user to mark an item status as ''on order''', 'ppl', 'description')),
1213 (192, 'MARK_ITEM_ILL', oils_i18n_gettext(192, 'Allow a user to mark an item status as ''inter-library loan''', 'ppl', 'description')),
1214 (193, 'group_application.user.staff.acq', oils_i18n_gettext(193, 'Allows a user to add/remove/edit users in the "ACQ" group', 'ppl', 'description')),
1215 (194, 'CREATE_PURCHASE_ORDER', oils_i18n_gettext(194, 'Allows a user to create a purchase order', 'ppl', 'description')),
1216 (195, 'VIEW_PURCHASE_ORDER', oils_i18n_gettext(195, 'Allows a user to view a purchase order', 'ppl', 'description')),
1217 (196, 'IMPORT_ACQ_LINEITEM_BIB_RECORD', oils_i18n_gettext(196, 'Allows a user to import a bib record from the acq staging area (on-order record) into the ILS bib data set', 'ppl', 'description')),
1218 (197, 'RECEIVE_PURCHASE_ORDER', oils_i18n_gettext(197, 'Allows a user to mark a purchase order, lineitem, or individual copy as received', 'ppl', 'description')),
1219 (198, 'VIEW_ORG_SETTINGS', oils_i18n_gettext(198, 'Allows a user to view all org settings at the specified level', 'ppl', 'description')),
1220 (199, 'CREATE_MFHD_RECORD', oils_i18n_gettext(199, 'Allows a user to create a new MFHD record', 'ppl', 'description')),
1221 (200, 'UPDATE_MFHD_RECORD', oils_i18n_gettext(200, 'Allows a user to update an MFHD record', 'ppl', 'description')),
1222 (201, 'DELETE_MFHD_RECORD', oils_i18n_gettext(201, 'Allows a user to delete an MFHD record', 'ppl', 'description')),
1223 (202, 'ADMIN_ACQ_FUND', oils_i18n_gettext(171, 'Allow a user to create/view/update/delete a fund', 'ppl', 'description')),
1224 (203, 'group_application.user.staff.acq_admin', oils_i18n_gettext(193, 'Allows a user to add/remove/edit users in the "Acquisitions Administrators" group', 'ppl', 'description'))
1227 SELECT SETVAL('permission.perm_list_id_seq'::TEXT, (SELECT MAX(id) FROM permission.perm_list));
1229 INSERT INTO permission.perm_list (code) VALUES ('ASSIGN_GROUP_PERM');
1230 INSERT INTO permission.perm_list (code) VALUES ('CREATE_AUDIENCE');
1231 INSERT INTO permission.perm_list (code) VALUES ('CREATE_BIB_LEVEL');
1232 INSERT INTO permission.perm_list (code) VALUES ('CREATE_CIRC_DURATION');
1233 INSERT INTO permission.perm_list (code) VALUES ('CREATE_CIRC_MOD');
1234 INSERT INTO permission.perm_list (code) VALUES ('CREATE_COPY_STATUS');
1235 INSERT INTO permission.perm_list (code) VALUES ('CREATE_HOURS_OF_OPERATION');
1236 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ITEM_FORM');
1237 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ITEM_TYPE');
1238 INSERT INTO permission.perm_list (code) VALUES ('CREATE_LANGUAGE');
1239 INSERT INTO permission.perm_list (code) VALUES ('CREATE_LASSO');
1240 INSERT INTO permission.perm_list (code) VALUES ('CREATE_LASSO_MAP');
1241 INSERT INTO permission.perm_list (code) VALUES ('CREATE_LIT_FORM');
1242 INSERT INTO permission.perm_list (code) VALUES ('CREATE_METABIB_FIELD');
1243 INSERT INTO permission.perm_list (code) VALUES ('CREATE_NET_ACCESS_LEVEL');
1244 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ORG_ADDRESS');
1245 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ORG_TYPE');
1246 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ORG_UNIT');
1247 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ORG_UNIT_CLOSING');
1248 INSERT INTO permission.perm_list (code) VALUES ('CREATE_PERM');
1249 INSERT INTO permission.perm_list (code) VALUES ('CREATE_RELEVANCE_ADJUSTMENT');
1250 INSERT INTO permission.perm_list (code) VALUES ('CREATE_SURVEY');
1251 INSERT INTO permission.perm_list (code) VALUES ('CREATE_VR_FORMAT');
1252 INSERT INTO permission.perm_list (code) VALUES ('CREATE_XML_TRANSFORM');
1253 INSERT INTO permission.perm_list (code) VALUES ('DELETE_AUDIENCE');
1254 INSERT INTO permission.perm_list (code) VALUES ('DELETE_BIB_LEVEL');
1255 INSERT INTO permission.perm_list (code) VALUES ('DELETE_CIRC_DURATION');
1256 INSERT INTO permission.perm_list (code) VALUES ('DELETE_CIRC_MOD');
1257 INSERT INTO permission.perm_list (code) VALUES ('DELETE_COPY_STATUS');
1258 INSERT INTO permission.perm_list (code) VALUES ('DELETE_HOURS_OF_OPERATION');
1259 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ITEM_FORM');
1260 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ITEM_TYPE');
1261 INSERT INTO permission.perm_list (code) VALUES ('DELETE_LANGUAGE');
1262 INSERT INTO permission.perm_list (code) VALUES ('DELETE_LASSO');
1263 INSERT INTO permission.perm_list (code) VALUES ('DELETE_LASSO_MAP');
1264 INSERT INTO permission.perm_list (code) VALUES ('DELETE_LIT_FORM');
1265 INSERT INTO permission.perm_list (code) VALUES ('DELETE_METABIB_FIELD');
1266 INSERT INTO permission.perm_list (code) VALUES ('DELETE_NET_ACCESS_LEVEL');
1267 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ORG_ADDRESS');
1268 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ORG_TYPE');
1269 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ORG_UNIT');
1270 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ORG_UNIT_CLOSING');
1271 INSERT INTO permission.perm_list (code) VALUES ('DELETE_PERM');
1272 INSERT INTO permission.perm_list (code) VALUES ('DELETE_RELEVANCE_ADJUSTMENT');
1273 INSERT INTO permission.perm_list (code) VALUES ('DELETE_SURVEY');
1274 INSERT INTO permission.perm_list (code) VALUES ('DELETE_TRANSIT');
1275 INSERT INTO permission.perm_list (code) VALUES ('DELETE_VR_FORMAT');
1276 INSERT INTO permission.perm_list (code) VALUES ('DELETE_XML_TRANSFORM');
1277 INSERT INTO permission.perm_list (code) VALUES ('REMOVE_GROUP_PERM');
1278 INSERT INTO permission.perm_list (code) VALUES ('TRANSIT_COPY');
1279 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_AUDIENCE');
1280 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_BIB_LEVEL');
1281 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_CIRC_DURATION');
1282 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_CIRC_MOD');
1283 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_COPY_NOTE');
1284 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_COPY_STATUS');
1285 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_GROUP_PERM');
1286 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_HOURS_OF_OPERATION');
1287 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ITEM_FORM');
1288 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ITEM_TYPE');
1289 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_LANGUAGE');
1290 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_LASSO');
1291 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_LASSO_MAP');
1292 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_LIT_FORM');
1293 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_METABIB_FIELD');
1294 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_NET_ACCESS_LEVEL');
1295 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_ADDRESS');
1296 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_TYPE');
1297 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_CLOSING');
1298 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_PERM');
1299 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_RELEVANCE_ADJUSTMENT');
1300 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_SURVEY');
1301 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_TRANSIT');
1302 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_VOLUME_NOTE');
1303 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_VR_FORMAT');
1304 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_XML_TRANSFORM');
1305 INSERT INTO permission.perm_list (code) VALUES ('MERGE_BIB_RECORDS');
1306 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_PICKUP_LIB_FROM_HOLDS_SHELF');
1307 INSERT INTO permission.perm_list (code) VALUES ('CREATE_ACQ_FUNDING_SOURCE');
1308 INSERT INTO permission.perm_list (code) VALUES ('CREATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF');
1309 INSERT INTO permission.perm_list (code) VALUES ('CREATE_AUTHORITY_IMPORT_QUEUE');
1310 INSERT INTO permission.perm_list (code) VALUES ('CREATE_AUTHORITY_RECORD_NOTE');
1311 INSERT INTO permission.perm_list (code) VALUES ('CREATE_BIB_IMPORT_FIELD_DEF');
1312 INSERT INTO permission.perm_list (code) VALUES ('CREATE_BIB_IMPORT_QUEUE');
1313 INSERT INTO permission.perm_list (code) VALUES ('CREATE_LOCALE');
1314 INSERT INTO permission.perm_list (code) VALUES ('CREATE_MARC_CODE');
1315 INSERT INTO permission.perm_list (code) VALUES ('CREATE_TRANSLATION');
1316 INSERT INTO permission.perm_list (code) VALUES ('DELETE_ACQ_FUNDING_SOURCE');
1317 INSERT INTO permission.perm_list (code) VALUES ('DELETE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF');
1318 INSERT INTO permission.perm_list (code) VALUES ('DELETE_AUTHORITY_IMPORT_QUEUE');
1319 INSERT INTO permission.perm_list (code) VALUES ('DELETE_AUTHORITY_RECORD_NOTE');
1320 INSERT INTO permission.perm_list (code) VALUES ('DELETE_BIB_IMPORT_IMPORT_FIELD_DEF');
1321 INSERT INTO permission.perm_list (code) VALUES ('DELETE_BIB_IMPORT_QUEUE');
1322 INSERT INTO permission.perm_list (code) VALUES ('DELETE_LOCALE');
1323 INSERT INTO permission.perm_list (code) VALUES ('DELETE_MARC_CODE');
1324 INSERT INTO permission.perm_list (code) VALUES ('DELETE_TRANSLATION');
1325 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ACQ_FUNDING_SOURCE');
1326 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF');
1327 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_AUTHORITY_IMPORT_QUEUE');
1328 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_AUTHORITY_RECORD_NOTE');
1329 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_BIB_IMPORT_IMPORT_FIELD_DEF');
1330 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_BIB_IMPORT_QUEUE');
1331 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_LOCALE');
1332 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_MARC_CODE');
1333 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_TRANSLATION');
1334 INSERT INTO permission.perm_list (code) VALUES ('VIEW_ACQ_FUNDING_SOURCE');
1335 INSERT INTO permission.perm_list (code) VALUES ('VIEW_AUTHORITY_RECORD_NOTES');
1336 INSERT INTO permission.perm_list (code) VALUES ('CREATE_IMPORT_ITEM');
1337 INSERT INTO permission.perm_list (code) VALUES ('CREATE_IMPORT_ITEM_ATTR_DEF');
1338 INSERT INTO permission.perm_list (code) VALUES ('CREATE_IMPORT_TRASH_FIELD');
1339 INSERT INTO permission.perm_list (code) VALUES ('DELETE_IMPORT_ITEM');
1340 INSERT INTO permission.perm_list (code) VALUES ('DELETE_IMPORT_ITEM_ATTR_DEF');
1341 INSERT INTO permission.perm_list (code) VALUES ('DELETE_IMPORT_TRASH_FIELD');
1342 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_IMPORT_ITEM');
1343 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_IMPORT_ITEM_ATTR_DEF');
1344 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_IMPORT_TRASH_FIELD');
1346 -- ORG UNIT Settings
1347 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING_ALL');
1348 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.lost_materials_processing_fee');
1349 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.cat.default_item_price');
1350 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.auth.opac_timeout');
1351 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.auth.staff_timeout');
1352 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.org.bounced_emails');
1353 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.hold_expire_alert_interval');
1354 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.hold_expire_interval');
1355 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.global.credit.allow');
1356 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.void_overdue_on_lost');
1357 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.hold_stalling.soft');
1358 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.hard');
1359 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.soft');
1360 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.opac.barcode_regex');
1361 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.global.password_regex');
1362 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.item_checkout_history.max');
1363 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.reshelving_complete.interval');
1364 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.selfcheck.patron_login_timeout');
1365 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.selfcheck.alert_on_checkout_event');
1366 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password');
1367 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.global.juvenile_age_threshold');
1368 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.cat.bib.keep_on_empty');
1369 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.cat.bib.alert_on_empty');
1370 INSERT INTO permission.perm_list (code) VALUES ('UPDATE_ORG_UNIT_SETTING.patron.password.use_phone');
1374 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1375 (1, oils_i18n_gettext(1, 'Users', 'pgt', 'name'), NULL, NULL, '3 years', FALSE, 'group_application.user');
1376 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1377 (2, oils_i18n_gettext(2, 'Patrons', 'pgt', 'name'), 1, NULL, '3 years', TRUE, 'group_application.user.patron');
1378 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1379 (3, oils_i18n_gettext(3, 'Staff', 'pgt', 'name'), 1, NULL, '3 years', FALSE, 'group_application.user.staff');
1380 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1381 (4, oils_i18n_gettext(4, 'Catalogers', 'pgt', 'name'), 3, NULL, '3 years', TRUE, 'group_application.user.staff.cat');
1382 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1383 (5, oils_i18n_gettext(5, 'Circulators', 'pgt', 'name'), 3, NULL, '3 years', TRUE, 'group_application.user.staff.circ');
1384 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1385 (6, oils_i18n_gettext(6, 'Acquisitions', 'pgt', 'name'), 3, NULL, '3 years', TRUE, 'group_application.user.staff.acq');
1386 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1387 (7, oils_i18n_gettext(6, 'Acquisitions Administrator', 'pgt', 'name'), 3, NULL, '3 years', TRUE, 'group_application.user.staff.acq_admin');
1388 INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES
1389 (10, oils_i18n_gettext(10, 'Local System Administrator', 'pgt', 'name'), 3,
1390 oils_i18n_gettext(10, 'System maintenance, configuration, etc.', 'pgt', 'description'), '3 years', TRUE, 'group_application.user.staff.admin.local_admin');
1392 SELECT SETVAL('permission.grp_tree_id_seq'::TEXT, (SELECT MAX(id) FROM permission.grp_tree));
1394 INSERT INTO permission.grp_penalty_threshold (grp,org_unit,penalty,threshold)
1395 VALUES (1,1,1,10.0);
1396 INSERT INTO permission.grp_penalty_threshold (grp,org_unit,penalty,threshold)
1397 VALUES (1,1,2,10.0);
1398 INSERT INTO permission.grp_penalty_threshold (grp,org_unit,penalty,threshold)
1399 VALUES (1,1,3,10.0);
1401 SELECT SETVAL('permission.grp_penalty_threshold_id_seq'::TEXT, (SELECT MAX(id) FROM permission.grp_penalty_threshold));
1403 -- XXX Incomplete base permission setup. A patch would be appreciated.
1404 INSERT INTO permission.grp_perm_map VALUES (57, 2, 15, 0, false);
1405 INSERT INTO permission.grp_perm_map VALUES (109, 2, 95, 0, false);
1406 INSERT INTO permission.grp_perm_map VALUES (1, 1, 2, 0, false);
1407 INSERT INTO permission.grp_perm_map VALUES (12, 1, 5, 0, false);
1408 INSERT INTO permission.grp_perm_map VALUES (13, 1, 6, 0, false);
1409 INSERT INTO permission.grp_perm_map VALUES (51, 1, 32, 0, false);
1410 INSERT INTO permission.grp_perm_map VALUES (111, 1, 95, 0, false);
1411 INSERT INTO permission.grp_perm_map VALUES (11, 3, 4, 0, false);
1412 INSERT INTO permission.grp_perm_map VALUES (14, 3, 7, 2, false);
1413 INSERT INTO permission.grp_perm_map VALUES (16, 3, 9, 0, false);
1414 INSERT INTO permission.grp_perm_map VALUES (19, 3, 15, 0, false);
1415 INSERT INTO permission.grp_perm_map VALUES (20, 3, 16, 0, false);
1416 INSERT INTO permission.grp_perm_map VALUES (21, 3, 17, 0, false);
1417 INSERT INTO permission.grp_perm_map VALUES (116, 3, 18, 0, false);
1418 INSERT INTO permission.grp_perm_map VALUES (117, 3, 20, 0, false);
1419 INSERT INTO permission.grp_perm_map VALUES (118, 3, 21, 2, false);
1420 INSERT INTO permission.grp_perm_map VALUES (119, 3, 22, 2, false);
1421 INSERT INTO permission.grp_perm_map VALUES (120, 3, 23, 2, false);
1422 INSERT INTO permission.grp_perm_map VALUES (121, 3, 25, 2, false);
1423 INSERT INTO permission.grp_perm_map VALUES (26, 3, 27, 0, false);
1424 INSERT INTO permission.grp_perm_map VALUES (27, 3, 28, 0, false);
1425 INSERT INTO permission.grp_perm_map VALUES (28, 3, 29, 0, false);
1426 INSERT INTO permission.grp_perm_map VALUES (29, 3, 30, 0, false);
1427 INSERT INTO permission.grp_perm_map VALUES (44, 3, 31, 0, false);
1428 INSERT INTO permission.grp_perm_map VALUES (31, 3, 33, 0, false);
1429 INSERT INTO permission.grp_perm_map VALUES (32, 3, 34, 0, false);
1430 INSERT INTO permission.grp_perm_map VALUES (33, 3, 35, 0, false);
1431 INSERT INTO permission.grp_perm_map VALUES (41, 3, 36, 0, false);
1432 INSERT INTO permission.grp_perm_map VALUES (45, 3, 37, 0, false);
1433 INSERT INTO permission.grp_perm_map VALUES (46, 3, 38, 0, false);
1434 INSERT INTO permission.grp_perm_map VALUES (47, 3, 39, 0, false);
1435 INSERT INTO permission.grp_perm_map VALUES (122, 3, 41, 0, false);
1436 INSERT INTO permission.grp_perm_map VALUES (123, 3, 43, 0, false);
1437 INSERT INTO permission.grp_perm_map VALUES (60, 3, 44, 0, false);
1438 INSERT INTO permission.grp_perm_map VALUES (110, 3, 45, 0, false);
1439 INSERT INTO permission.grp_perm_map VALUES (124, 3, 8, 2, false);
1440 INSERT INTO permission.grp_perm_map VALUES (125, 3, 24, 2, false);
1441 INSERT INTO permission.grp_perm_map VALUES (126, 3, 19, 0, false);
1442 INSERT INTO permission.grp_perm_map VALUES (61, 3, 47, 2, false);
1443 INSERT INTO permission.grp_perm_map VALUES (95, 3, 48, 0, false);
1444 INSERT INTO permission.grp_perm_map VALUES (17, 3, 11, 0, false);
1445 INSERT INTO permission.grp_perm_map VALUES (62, 3, 42, 0, false);
1446 INSERT INTO permission.grp_perm_map VALUES (63, 3, 49, 0, false);
1447 INSERT INTO permission.grp_perm_map VALUES (64, 3, 50, 0, false);
1448 INSERT INTO permission.grp_perm_map VALUES (127, 3, 53, 0, false);
1449 INSERT INTO permission.grp_perm_map VALUES (65, 3, 54, 0, false);
1450 INSERT INTO permission.grp_perm_map VALUES (128, 3, 55, 2, false);
1451 INSERT INTO permission.grp_perm_map VALUES (67, 3, 56, 2, false);
1452 INSERT INTO permission.grp_perm_map VALUES (68, 3, 57, 2, false);
1453 INSERT INTO permission.grp_perm_map VALUES (69, 3, 58, 2, false);
1454 INSERT INTO permission.grp_perm_map VALUES (70, 3, 59, 2, false);
1455 INSERT INTO permission.grp_perm_map VALUES (71, 3, 60, 2, false);
1456 INSERT INTO permission.grp_perm_map VALUES (72, 3, 61, 2, false);
1457 INSERT INTO permission.grp_perm_map VALUES (73, 3, 62, 2, false);
1458 INSERT INTO permission.grp_perm_map VALUES (74, 3, 63, 2, false);
1459 INSERT INTO permission.grp_perm_map VALUES (81, 3, 72, 2, false);
1460 INSERT INTO permission.grp_perm_map VALUES (82, 3, 73, 2, false);
1461 INSERT INTO permission.grp_perm_map VALUES (83, 3, 74, 2, false);
1462 INSERT INTO permission.grp_perm_map VALUES (84, 3, 75, 0, false);
1463 INSERT INTO permission.grp_perm_map VALUES (85, 3, 76, 2, false);
1464 INSERT INTO permission.grp_perm_map VALUES (86, 3, 77, 2, false);
1465 INSERT INTO permission.grp_perm_map VALUES (89, 3, 79, 0, false);
1466 INSERT INTO permission.grp_perm_map VALUES (90, 3, 80, 0, false);
1467 INSERT INTO permission.grp_perm_map VALUES (91, 3, 81, 0, false);
1468 INSERT INTO permission.grp_perm_map VALUES (92, 3, 82, 0, false);
1469 INSERT INTO permission.grp_perm_map VALUES (98, 3, 83, 0, false);
1470 INSERT INTO permission.grp_perm_map VALUES (115, 3, 84, 0, false);
1471 INSERT INTO permission.grp_perm_map VALUES (100, 3, 85, 0, false);
1472 INSERT INTO permission.grp_perm_map VALUES (101, 3, 86, 0, false);
1473 INSERT INTO permission.grp_perm_map VALUES (102, 3, 87, 0, false);
1474 INSERT INTO permission.grp_perm_map VALUES (103, 3, 89, 2, false);
1475 INSERT INTO permission.grp_perm_map VALUES (104, 3, 88, 2, false);
1476 INSERT INTO permission.grp_perm_map VALUES (108, 3, 94, 0, false);
1477 INSERT INTO permission.grp_perm_map VALUES (112, 3, 96, 0, false);
1478 INSERT INTO permission.grp_perm_map VALUES (113, 3, 97, 0, false);
1479 INSERT INTO permission.grp_perm_map VALUES (130, 3, 99, 1, false);
1480 INSERT INTO permission.grp_perm_map VALUES (131, 3, 100, 1, false);
1481 INSERT INTO permission.grp_perm_map VALUES (139, 3, 181, 0, false);
1482 INSERT INTO permission.grp_perm_map VALUES (22, 4, 18, 0, false);
1483 INSERT INTO permission.grp_perm_map VALUES (24, 4, 20, 0, false);
1484 INSERT INTO permission.grp_perm_map VALUES (38, 4, 21, 2, false);
1485 INSERT INTO permission.grp_perm_map VALUES (34, 4, 22, 2, false);
1486 INSERT INTO permission.grp_perm_map VALUES (39, 4, 23, 2, false);
1487 INSERT INTO permission.grp_perm_map VALUES (35, 4, 25, 2, false);
1488 INSERT INTO permission.grp_perm_map VALUES (129, 4, 26, 2, false);
1489 INSERT INTO permission.grp_perm_map VALUES (15, 4, 8, 2, false);
1490 INSERT INTO permission.grp_perm_map VALUES (40, 4, 24, 2, false);
1491 INSERT INTO permission.grp_perm_map VALUES (23, 4, 19, 0, false);
1492 INSERT INTO permission.grp_perm_map VALUES (66, 4, 55, 2, false);
1493 INSERT INTO permission.grp_perm_map VALUES (134, 10, 51, 1, false);
1494 INSERT INTO permission.grp_perm_map VALUES (75, 10, 66, 2, false);
1495 INSERT INTO permission.grp_perm_map VALUES (76, 10, 67, 2, false);
1496 INSERT INTO permission.grp_perm_map VALUES (77, 10, 68, 2, false);
1497 INSERT INTO permission.grp_perm_map VALUES (78, 10, 69, 2, false);
1498 INSERT INTO permission.grp_perm_map VALUES (79, 10, 70, 2, false);
1499 INSERT INTO permission.grp_perm_map VALUES (80, 10, 71, 2, false);
1500 INSERT INTO permission.grp_perm_map VALUES (87, 10, 78, 2, false);
1501 INSERT INTO permission.grp_perm_map VALUES (105, 10, 91, 1, false);
1502 INSERT INTO permission.grp_perm_map VALUES (106, 10, 92, 1, false);
1503 INSERT INTO permission.grp_perm_map VALUES (107, 10, 93, 0, false);
1504 INSERT INTO permission.grp_perm_map VALUES (114, 10, 98, 1, false);
1505 INSERT INTO permission.grp_perm_map VALUES (132, 10, 101, 1, true);
1506 INSERT INTO permission.grp_perm_map VALUES (136, 10, 102, 1, false);
1507 INSERT INTO permission.grp_perm_map VALUES (137, 10, 103, 1, false);
1508 INSERT INTO permission.grp_perm_map VALUES (140, 10, 147, 1, false);
1509 INSERT INTO permission.grp_perm_map VALUES (141, 10, 148, 1, false);
1510 INSERT INTO permission.grp_perm_map VALUES (142, 10, 149, 1, false);
1511 INSERT INTO permission.grp_perm_map VALUES (97, 5, 41, 0, false);
1512 INSERT INTO permission.grp_perm_map VALUES (96, 5, 43, 0, false);
1513 INSERT INTO permission.grp_perm_map VALUES (93, 5, 48, 0, false);
1514 INSERT INTO permission.grp_perm_map VALUES (94, 5, 53, 0, false);
1515 INSERT INTO permission.grp_perm_map VALUES (133, 5, 102, 0, false);
1516 INSERT INTO permission.grp_perm_map VALUES (138, 5, 104, 1, false);
1517 INSERT INTO permission.grp_perm_map VALUES (143, 3, 198, 1, false);
1518 INSERT INTO permission.grp_perm_map VALUES (144, 4, 199, 1, false);
1519 INSERT INTO permission.grp_perm_map VALUES (145, 4, 200, 1, false);
1520 INSERT INTO permission.grp_perm_map VALUES (146, 4, 201, 1, false);
1522 -- Add basic acquisitions permissions to the Acquisitions group
1523 SELECT SETVAL('permission.grp_perm_map_id_seq'::TEXT, (SELECT MAX(id) FROM permission.grp_perm_map));
1524 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'GENERAL_ACQ'), 1, false);
1525 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'VIEW_PICKLIST'), 1, false);
1526 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'CREATE_PICKLIST'), 1, false);
1527 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'CREATE_PURCHASE_ORDER'), 1, false);
1528 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'VIEW_PURCHASE_ORDER'), 1, false);
1529 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'RECEIVE_PURCHASE_ORDER'), 1, false);
1530 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'VIEW_PROVIDER'), 1, false);
1531 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'UPDATE_COPY'), 1, false);
1532 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (6, (SELECT id FROM permission.perm_list WHERE code = 'UPDATE_VOLUME'), 1, false);
1534 -- Add acquisitions administration permissions to the Acquisitions group
1535 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (7, (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_PROVIDER'), 1, false);
1536 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (7, (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_FUNDING_SOURCE'), 1, false);
1537 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (7, (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_ACQ_FUND'), 1, false);
1538 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (7, (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_FUND'), 1, false);
1539 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) VALUES (7, (SELECT id FROM permission.perm_list WHERE code = 'ADMIN_CURRENCY_TYPE'), 1, false);
1541 -- Admin user account
1542 INSERT INTO actor.usr ( profile, card, usrname, passwd, first_given_name, family_name, dob, master_account, super_user, ident_type, ident_value, home_ou ) VALUES ( 1, 1, 'admin', 'open-ils', 'Administrator', 'System Account', '1979-01-22', TRUE, TRUE, 1, 'identification', 1 );
1544 -- Admin user barcode
1545 INSERT INTO actor.card (usr, barcode) VALUES (1,'101010101010101');
1546 UPDATE actor.usr SET card = (SELECT id FROM actor.card WHERE barcode = '101010101010101') WHERE id = 1;
1548 -- Admin user permissions
1549 INSERT INTO permission.usr_perm_map (usr,perm,depth) VALUES (1,-1,0);
1551 -- Set a work_ou for the Administrator user
1552 INSERT INTO permission.usr_work_ou_map (usr, work_ou) VALUES (1, 1);
1554 --010.schema.biblio.sql:
1555 INSERT INTO biblio.record_entry VALUES (-1,1,1,1,-1,NOW(),NOW(),FALSE,FALSE,'','AUTOGEN','-1','','FOO');
1557 --040.schema.asset.sql:
1558 INSERT INTO asset.copy_location (id, name,owning_lib) VALUES (1, oils_i18n_gettext(1, 'Stacks', 'acpl', 'name'),1);
1559 SELECT SETVAL('asset.copy_location_id_seq'::TEXT, 100);
1561 INSERT INTO asset.call_number VALUES (-1,1,NOW(),1,NOW(),-1,1,'UNCATALOGED');
1563 -- some more from 002.schema.config.sql:
1564 INSERT INTO config.xml_transform VALUES ( 'marcxml', 'http://www.loc.gov/MARC21/slim', 'marc', '---' );
1565 INSERT INTO config.xml_transform VALUES ( 'mods', 'http://www.loc.gov/mods/', 'mods', '');
1566 INSERT INTO config.xml_transform VALUES ( 'mods3', 'http://www.loc.gov/mods/v3', 'mods3', '');
1567 INSERT INTO config.xml_transform VALUES ( 'mods32', 'http://www.loc.gov/mods/v3', 'mods32', '');
1568 INSERT INTO config.xml_transform VALUES ( 'mods33', 'http://www.loc.gov/mods/v3', 'mods33', '');
1571 INSERT INTO config.circ_matrix_matchpoint (org_unit,grp,duration_rule,recurring_fine_rule,max_fine_rule) VALUES (1,1,11,1,1);
1574 -- hold matrix - 110.hold_matrix.sql:
1575 INSERT INTO config.hold_matrix_matchpoint (requestor_grp) VALUES (1);
1577 -- org_unit setting types
1578 INSERT into config.org_unit_setting_type
1579 ( name, label, description, datatype ) VALUES
1581 ( 'auth.opac_timeout',
1582 'OPAC Inactivity Timeout (in seconds)',
1586 ( 'auth.staff_timeout',
1587 'Staff Login Inactivity Timeout (in seconds)',
1591 ( 'circ.lost_materials_processing_fee',
1592 'Lost Materials Processing Fee',
1596 ( 'cat.default_item_price',
1597 'Default Item Price',
1601 ( 'org.bounced_emails',
1602 'Sending email address for patron notices',
1606 ( 'circ.hold_expire_alert_interval',
1607 'Holds: Expire Alert Interval',
1608 'Amount of time before a hold expires at which point the patron should be alerted',
1611 ( 'circ.hold_expire_interval',
1612 'Holds: Expire Interval',
1613 'Amount of time after a hold is placed before the hold expires. Example "100 days"',
1616 ( 'global.credit.allow',
1618 'If enabled, patrons will be able to pay fines accrued at this location via credit card',
1621 ( 'global.default_locale',
1622 'Allow Credit Card Payments',
1626 ( 'circ.void_overdue_on_lost',
1627 'Void overdue fines when items are marked lost',
1631 ( 'circ.hold_stalling.soft',
1632 'Holds: Soft stalling interval',
1633 'How long to wait before allowing remote items to be opportunisticaly captured for a hold. Example "5 days"',
1636 ( 'circ.hold_stalling_hard',
1637 'Holds: Hard stalling interval',
1641 ( 'circ.hold_boundary.hard',
1642 'Holds: Hard boundary',
1646 ( 'circ.hold_boundary.soft',
1647 'Holds: Soft boundary',
1651 ( 'opac.barcode_regex',
1652 'Patron barcode format',
1653 'Regular expression defining the patron barcode format',
1656 ( 'global.password_regex',
1658 'Regular expression defining the password format',
1661 ( 'circ.item_checkout_history.max',
1662 'Maximum previous checkouts displayed',
1663 'This is maximum number of previous circulations the staff client will display when investigating item details',
1666 ( 'circ.reshelving_complete.interval',
1667 'Change reshelving status interval',
1668 'Amount of time to wait before changing an item from "reshelving" status to "available". Examples "1 day", "6 hours"',
1671 ( 'circ.hold_estimate_wait_interval',
1672 'Holds: Estimated Wait (Days)',
1673 'When predicting the amount of time a patron will be waiting for a hold to be fulfilled, this is the default/average number of days to assume an item will be checked out.',
1676 ( 'circ.selfcheck.patron_login_timeout',
1677 'Selfcheck: Patron Login Timeout (in seconds)',
1678 'Number of seconds of inactivity before the patron is logged out of the selfcheck interfacer',
1681 ( 'circ.selfcheck.alert_on_checkout_event',
1682 'Selfcheck: Pop-up alert for errors',
1683 'If true, checkout/renewal errors will cause a pop-up window in addition to the on-screen message',
1686 ( 'circ.selfcheck.require_patron_password',
1687 'Selfcheck: Require patron password',
1688 'If true, patrons will be required to enter their password in addition to their username/barcode to log into the selfcheck interface',
1691 ( 'global.juvenile_age_threshold',
1692 'Juvenile Age Threshold',
1693 'The age at which a user is no long considered a juvenile. For example, "18 years".',
1696 ( 'cat.bib.keep_on_empty',
1697 'Retain empty bib records',
1698 'Retain a bib record even when all attached copies are deleted',
1701 ( 'cat.bib.alert_on_empty',
1702 'Alert on empty bib records',
1703 'Alert staff when the last copy for a record is being deleted',
1706 ( 'patron.password.use_phone',
1707 'Patron: password from phone #',
1708 'Use the last 4 digits of the patrons phone number as the default password when creating new users',
1711 ( 'circ.charge_on_damaged',
1712 'Charge item price when marked damaged',
1713 'Charge item price when marked damaged',
1716 ( 'circ.charge_lost_on_zero',
1717 'Charge lost on zero',
1721 ( 'circ.damaged_item_processing_fee',
1722 'Charge processing fee for damaged items',
1723 'Charge processing fee for damaged items',
1726 ( 'circ.void_lost_on_checkin',
1727 'Circ: Void lost item billing when returned',
1728 'Void lost item billing when returned',
1731 ( 'circ.max_accept_return_of_lost',
1732 'Circ: Void lost max interval',
1733 'Items that have been lost this long will not result in voided billings when returned. E.g. ''6 months''',
1736 ( 'circ.void_lost_proc_fee_on_checkin',
1737 'Circ: Void processing fee on lost item return',
1738 'Void processing fee when lost item returned',
1741 ( 'circ.restore_overdue_on_lost_return',
1742 'Circ: Restore overdues on lost item return',
1743 'Restore overdue fines on lost item return',
1746 ( 'circ.lost_immediately_available',
1747 'Circ: Lost items usable on checkin',
1748 'Lost items are usable on checkin instead of going ''home'' first',
1751 ( 'opac.allow_pending_address',
1752 'OPAC: Allow pending addresses',
1753 'If enabled, patrons can create and edit existing addresses. Addresses are kept in a pending state until staff approves the changes',
1756 ( 'ui.circ.show_billing_tab_on_bills',
1757 'Show billing tab first when bills are present',
1758 'If enabled and a patron has outstanding bills and the alert page is not required, show the billing tab by default, instead of the checkout tab, when a patron is loaded',
1761 ( 'ui.circ.patron_display_timeout_interval',
1762 'GUI: Patron display timeout interval',
1763 'Set this if you would like patron displays in the staff client to be closed after a certain interval of inactivity. Example ''5 minutes''',
1766 ( 'acq.default_circ_modifier',
1767 'Default circulation modifier',
1771 ( 'acq.tmp_barcode_prefix',
1772 'Temporary barcode prefix',
1776 ( 'acq.tmp_callnumber_prefix',
1777 'Temporary call number prefix',
1781 ( 'ui.circ.patron_summary.horizontal',
1782 'Patron circulation summary is horizontal',
1786 ( 'ui.circ.standing_penalty.require_initials',
1787 'Require staff initials for entry/edit of standing penalties.',
1791 ( 'ui.general.button_bar',
1796 ( 'circ.hold_shelf_status_delay',
1797 'Hold Shelf Status Delay',
1798 'The purpose is to provide an interval of time after an item goes into the on-holds-shelf status before it appears to patrons that it is actually on the holds shelf. This gives staff time to process the item before it shows as ready-for-pickup.',
1801 ( 'circ.patron_invalid_address_apply_penalty',
1802 'Invalid patron address penalty',
1803 'When set, if a patron address is set to invalid, a penalty is applied.',
1806 ( 'circ.checkout_fills_related_hold',
1807 'Checkout Fills Related Hold',
1808 'When a patron checks out an item and they have no holds that directly target the item, the system will attempt to find a hold for the patron that could be fulfilled by the checked out item and fulfills it',
1811 ( 'circ.selfcheck.auto_override_checkout_events',
1812 'Selfcheck override events list',
1813 'List of checkout/renewal events that the selfcheck interface should automatically override instead instead of alerting and stopping the transaction',
1816 ( 'circ.staff_client.do_not_auto_attempt_print',
1817 'Disable Automatic Print Attempt Type List',
1818 'Disable automatic print attempts from staff client interfaces for the receipt types in this list. Possible values: "Checkout", "Bill Pay", "Hold Slip", "Transit Slip", and "Hold/Transit Slip". This is different from the Auto-Print checkbox in the pertinent interfaces in that it disables automatic print attempts altogether, rather than encouraging silent printing by suppressing the print dialog. The Auto-Print checkbox in these interfaces have no effect on the behavior for this setting. In the case of the Hold, Transit, and Hold/Transit slips, this also suppresses the alert dialogs that precede the print dialog (the ones that offer Print and Do Not Print as options).',
1821 ( 'ui.patron.default_inet_access_level',
1822 'Default level of patrons'' internet access',
1826 ( 'circ.max_patron_claim_return_count',
1827 'Max Patron Claims Returned Count',
1828 'When this count is exceeded, a staff override is required to mark the item as claims returned',
1831 ( 'circ.obscure_dob',
1832 'Obscure the Date of Birth field',
1833 'When true, the Date of Birth column in patron lists will default to Not Visible, and in the Patron Summary sidebar the value will display as <Hidden> unless the field label is clicked.',
1836 -- Org_unit_setting_type(s) that need an fm_class:
1837 INSERT into config.org_unit_setting_type
1838 ( name, label, description, datatype, fm_class ) VALUES
1839 ( 'acq.default_copy_location',
1840 'Default copy location',
1845 -- Staged Search (for default matchpoints)
1846 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(1, 'first_word', 1.5);
1847 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(1, 'full_match', 20);
1849 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(2, 'first_word', 1.5);
1850 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(2, 'word_order', 10);
1851 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(2, 'full_match', 20);
1853 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(3, 'first_word', 1.5);
1854 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(3, 'word_order', 10);
1855 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(3, 'full_match', 20);
1857 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(4, 'first_word', 1.5);
1858 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(4, 'word_order', 10);
1859 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(4, 'full_match', 20);
1861 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(5, 'first_word', 1.5);
1862 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(5, 'word_order', 10);
1863 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(5, 'full_match', 20);
1865 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(6, 'first_word', 1.5);
1866 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(6, 'word_order', 10);
1867 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(6, 'full_match', 20);
1869 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(7, 'first_word', 1.5);
1871 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(8, 'first_word', 1.5);
1873 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(9, 'first_word', 1.5);
1875 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(10, 'first_word', 1.5);
1877 INSERT INTO search.relevance_adjustment (field, bump_type, multiplier) VALUES(15, 'word_order', 10);
1879 -- Vandelay (for importing and exporting records) 012.schema.vandelay.sql
1880 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (1, 'title', oils_i18n_gettext(1, 'Title of work', 'vqbrad', 'description'),'//*[@tag="245"]/*[contains("abcmnopr",@code)]');
1881 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (2, 'author', oils_i18n_gettext(2, 'Author of work', 'vqbrad', 'description'),'//*[@tag="100" or @tag="110" or @tag="113"]/*[contains("ad",@code)]');
1882 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (3, 'language', oils_i18n_gettext(3, 'Language of work', 'vqbrad', 'description'),'//*[@tag="240"]/*[@code="l"][1]');
1883 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (4, 'pagination', oils_i18n_gettext(4, 'Pagination', 'vqbrad', 'description'),'//*[@tag="300"]/*[@code="a"][1]');
1884 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, ident, remove ) VALUES (5, 'isbn',oils_i18n_gettext(5, 'ISBN', 'vqbrad', 'description'),'//*[@tag="020"]/*[@code="a"]', TRUE, $r$(?:-|\s.+$)$r$);
1885 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, ident, remove ) VALUES (6, 'issn',oils_i18n_gettext(6, 'ISSN', 'vqbrad', 'description'),'//*[@tag="022"]/*[@code="a"]', TRUE, $r$(?:-|\s.+$)$r$);
1886 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (7, 'price',oils_i18n_gettext(7, 'Price', 'vqbrad', 'description'),'//*[@tag="020" or @tag="022"]/*[@code="c"][1]');
1887 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, ident ) VALUES (8, 'rec_identifier',oils_i18n_gettext(8, 'Accession Number', 'vqbrad', 'description'),'//*[@tag="001"]', TRUE);
1888 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, ident ) VALUES (9, 'eg_tcn',oils_i18n_gettext(9, 'TCN Value', 'vqbrad', 'description'),'//*[@tag="901"]/*[@code="a"]', TRUE);
1889 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, ident ) VALUES (10, 'eg_tcn_source',oils_i18n_gettext(10, 'TCN Source', 'vqbrad', 'description'),'//*[@tag="901"]/*[@code="b"]', TRUE);
1890 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, ident ) VALUES (11, 'eg_identifier',oils_i18n_gettext(11, 'Internal ID', 'vqbrad', 'description'),'//*[@tag="901"]/*[@code="c"]', TRUE);
1891 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (12, 'publisher',oils_i18n_gettext(12, 'Publisher', 'vqbrad', 'description'),'//*[@tag="260"]/*[@code="b"][1]');
1892 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath, remove ) VALUES (13, 'pubdate',oils_i18n_gettext(13, 'Publication Date', 'vqbrad', 'description'),'//*[@tag="260"]/*[@code="c"][1]',$r$\D$r$);
1893 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (14, 'edition',oils_i18n_gettext(14, 'Edition', 'vqbrad', 'description'),'//*[@tag="250"]/*[@code="a"][1]');
1894 INSERT INTO vandelay.bib_attr_definition ( id, code, description, xpath ) VALUES (15, 'item_barcode',oils_i18n_gettext(15, 'Item Barcode', 'vqbrad', 'description'),'//*[@tag="852p"]/*[@code="a"][1]');
1895 SELECT SETVAL('vandelay.bib_attr_definition_id_seq'::TEXT, 100);
1897 INSERT INTO vandelay.import_item_attr_definition (
1898 owner, name, tag, owning_lib, circ_lib, location,
1899 call_number, circ_modifier, barcode, price, copy_number,
1900 circulate, ref, holdable, opac_visible, status
1903 'Evergreen 852 export format',
1913 '[@code = "x" and text() = "circulating"]',
1914 '[@code = "x" and text() = "reference"]',
1915 '[@code = "x" and text() = "holdable"]',
1916 '[@code = "x" and text() = "visible"]',
1920 INSERT INTO vandelay.import_item_attr_definition (
1933 'Unicorn Import format -- 999',
1944 INSERT INTO vandelay.authority_attr_definition (id, code, description, xpath, ident ) VALUES (1, 'rec_identifier',oils_i18n_gettext(1, 'Identifier', 'vqarad', 'description'),'//*[@tag="001"]', TRUE);
1945 SELECT SETVAL('vandelay.authority_attr_definition_id_seq'::TEXT, 100);
1948 INSERT INTO container.copy_bucket_type (code,label) VALUES ('misc', oils_i18n_gettext('misc', 'Miscellaneous', 'ccpbt', 'label'));
1949 INSERT INTO container.copy_bucket_type (code,label) VALUES ('staff_client', oils_i18n_gettext('staff_client', 'General Staff Client container', 'ccpbt', 'label'));
1950 INSERT INTO container.copy_bucket_type (code,label) VALUES ( 'circ_history', 'Circulation History' );
1951 INSERT INTO container.call_number_bucket_type (code,label) VALUES ('misc', oils_i18n_gettext('misc', 'Miscellaneous', 'ccnbt', 'label'));
1952 INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('misc', oils_i18n_gettext('misc', 'Miscellaneous', 'cbrebt', 'label'));
1953 INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('staff_client', oils_i18n_gettext('staff_client', 'General Staff Client container', 'cbrebt', 'label'));
1954 INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('bookbag', oils_i18n_gettext('bookbag', 'Book Bag', 'cbrebt', 'label'));
1955 INSERT INTO container.biblio_record_entry_bucket_type (code,label) VALUES ('reading_list', oils_i18n_gettext('reading_list', 'Reading List', 'cbrebt', 'label'));
1957 INSERT INTO container.user_bucket_type (code,label) VALUES ('misc', oils_i18n_gettext('misc', 'Miscellaneous', 'cubt', 'label'));
1958 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks', oils_i18n_gettext('folks', 'Friends', 'cubt', 'label'));
1959 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:pub_book_bags.view', oils_i18n_gettext('folks:pub_book_bags.view', 'List Published Book Bags', 'cubt', 'label'));
1960 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:pub_book_bags.add', oils_i18n_gettext('folks:pub_book_bags.add', 'Add to Published Book Bags', 'cubt', 'label'));
1961 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:circ.view', oils_i18n_gettext('folks:circ.view', 'View Circulations', 'cubt', 'label'));
1962 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:circ.renew', oils_i18n_gettext('folks:circ.renew', 'Renew Circulations', 'cubt', 'label'));
1963 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:circ.checkout', oils_i18n_gettext('folks:circ.checkout', 'Checkout Items', 'cubt', 'label'));
1964 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:hold.view', oils_i18n_gettext('folks:hold.view', 'View Holds', 'cubt', 'label'));
1965 INSERT INTO container.user_bucket_type (code,label) VALUES ('folks:hold.cancel', oils_i18n_gettext('folks:hold.cancel', 'Cancel Holds', 'cubt', 'label'));
1968 -- Trigger Event Definitions -------------------------------------------------
1970 -- Sample Overdue Notice --
1972 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, template)
1973 VALUES (1, 'f', 1, '7 Day Overdue Email Notification', 'checkout.due', 'CircIsOverdue', 'SendEmail', '7 days', 'due_date', 'usr',
1976 [%- user = target.0.usr -%]
1977 To: [%- params.recipient_email || user.email %]
1978 From: [%- params.sender_email || default_sender %]
1979 Subject: Overdue Notification
1981 Dear [% user.family_name %], [% user.first_given_name %]
1982 Our records indicate the following items are overdue.
1984 [% FOR circ IN target %]
1985 Title: [% circ.target_copy.call_number.record.simple_record.title %]
1986 Barcode: [% circ.target_copy.barcode %]
1987 Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
1988 Item Cost: [% helpers.get_copy_price(circ.target_copy) %]
1989 Total Owed For Transaction: [% circ.billable_transaction.summary.total_owed %]
1990 Library: [% circ.circ_lib.name %]
1995 INSERT INTO action_trigger.environment (event_def, path) VALUES
1996 (1, 'target_copy.call_number.record.simple_record'),
1998 (1, 'billable_transaction.summary'),
1999 (1, 'circ_lib.billing_address');
2002 -- Sample Mark Long-Overdue Item Lost --
2004 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field)
2005 VALUES (2, 'f', 1, '90 Day Overdue Mark Lost', 'checkout.due', 'CircIsOverdue', 'MarkItemLost', '90 days', 'due_date');
2007 -- Sample Auto Mark Lost Notice --
2009 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, group_field, template)
2010 VALUES (3, 'f', 1, '90 Day Overdue Mark Lost Notice', 'lost.auto', 'NOOP_True', 'SendEmail', 'usr',
2013 [%- user = target.0.usr -%]
2014 To: [%- params.recipient_email || user.email %]
2015 From: [%- params.sender_email || default_sender %]
2016 Subject: Overdue Items Marked Lost
2018 Dear [% user.family_name %], [% user.first_given_name %]
2019 The following items are 90 days overdue and have been marked LOST.
2021 [% FOR circ IN target %]
2022 Title: [% circ.target_copy.call_number.record.simple_record.title %]
2023 Barcode: [% circ.target_copy.barcode %]
2024 Due: [% date.format(helpers.format_date(circ.due_date), '%Y-%m-%d') %]
2025 Item Cost: [% helpers.get_copy_price(circ.target_copy) %]
2026 Total Owed For Transaction: [% circ.billable_transaction.summary.total_owed %]
2027 Library: [% circ.circ_lib.name %]
2033 INSERT INTO action_trigger.environment (event_def, path) VALUES
2034 (3, 'target_copy.call_number.record.simple_record'),
2036 (3, 'billable_transaction.summary'),
2037 (3, 'circ_lib.billing_address');
2039 -- Sample Purchase Order HTML Template --
2041 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, template)
2042 VALUES (4, 't', 1, 'PO HTML', 'format.po.html', 'NOOP_True', 'ProcessTemplate',
2046 # find a lineitem attribute by name and optional type
2048 FOR attr IN li.attributes;
2049 IF attr.attr_name == attr_name;
2050 IF !attr_type OR attr_type == attr.attr_type;
2059 <h2>Purchase Order [% target.id %]</h2>
2061 date <b>[% date.format(date.now, '%Y%m%d') %]</b>
2065 table td { padding:5px; border:1px solid #aaa;}
2066 table { width:95%; border-collapse:collapse; }
2068 <table id='vendor-table'>
2070 <td valign='top'>Vendor</td>
2072 <div>[% target.provider.name %]</div>
2073 <div>[% target.provider.addresses.0.street1 %]</div>
2074 <div>[% target.provider.addresses.0.street2 %]</div>
2075 <div>[% target.provider.addresses.0.city %]</div>
2076 <div>[% target.provider.addresses.0.state %]</div>
2077 <div>[% target.provider.addresses.0.country %]</div>
2078 <div>[% target.provider.addresses.0.post_code %]</div>
2080 <td valign='top'>Ship to / Bill to</td>
2082 <div>[% target.ordering_agency.name %]</div>
2083 <div>[% target.ordering_agency.billing_address.street1 %]</div>
2084 <div>[% target.ordering_agency.billing_address.street2 %]</div>
2085 <div>[% target.ordering_agency.billing_address.city %]</div>
2086 <div>[% target.ordering_agency.billing_address.state %]</div>
2087 <div>[% target.ordering_agency.billing_address.country %]</div>
2088 <div>[% target.ordering_agency.billing_address.post_code %]</div>
2099 <th>ISBN or Item #</th>
2109 [% FOR li IN target.lineitems %]
2112 [% count = li.lineitem_details.size %]
2113 [% price = PROCESS get_li_attr attr_name = 'estimated_price' %]
2114 [% litotal = (price * count) %]
2115 [% subtotal = subtotal + litotal %]
2116 [% isbn = PROCESS get_li_attr attr_name = 'isbn' %]
2117 [% ident = PROCESS get_li_attr attr_name = 'identifier' %]
2119 <td>[% target.id %]</td>
2120 <td>[% isbn || ident %]</td>
2121 <td>[% PROCESS get_li_attr attr_name = 'title' %]</td>
2122 <td>[% count %]</td>
2123 <td>[% price %]</td>
2124 <td>[% litotal %]</td>
2128 <td/><td/><td/><td/>
2130 <td>[% subtotal %]</td>
2137 Total Line Item Count: [% target.lineitems.size %]
2140 INSERT INTO action_trigger.environment (event_def, path) VALUES
2141 (4, 'lineitems.lineitem_details.fund'),
2142 (4, 'lineitems.lineitem_details.location'),
2143 (4, 'lineitems.lineitem_details.owning_lib'),
2144 (4, 'ordering_agency.mailing_address'),
2145 (4, 'ordering_agency.billing_address'),
2146 (4, 'provider.addresses'),
2147 (4, 'lineitems.attributes');
2150 INSERT INTO action_trigger.event_definition (id, active, owner, name, hook, validator, reactor, delay, delay_field, group_field, template)
2151 VALUES (5, 'f', 1, 'Hold Ready for Pickup Email Notification', 'hold.available', 'HoldIsAvailable', 'SendEmail', '30 minutes', 'shelf_time', 'usr',
2154 [%- user = target.0.usr -%]
2155 To: [%- params.recipient_email || user.email %]
2156 From: [%- params.sender_email || default_sender %]
2157 Subject: Hold Available Notification
2159 Dear [% user.family_name %], [% user.first_given_name %]
2160 The item(s) you requested are available for pickup from the Library.
2162 [% FOR hold IN target %]
2163 Title: [% hold.current_copy.call_number.record.simple_record.title %]
2164 Author: [% hold.current_copy.call_number.record.simple_record.author %]
2165 Call Number: [% hold.current_copy.call_number.label %]
2166 Barcode: [% hold.current_copy.barcode %]
2167 Library: [% hold.pickup_lib.name %]
2172 INSERT INTO action_trigger.environment (event_def, path) VALUES
2173 (5, 'current_copy.call_number.record.simple_record'),
2175 (5, 'pickup_lib.billing_address');
2178 SELECT SETVAL('action_trigger.event_definition_id_seq'::TEXT, 100);
2180 -- Org Unit Settings for configuring org unit weights and org unit max-loops for hold targeting
2182 INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VALUES (
2183 'circ.holds.org_unit_target_weight',
2184 'Holds: Org Unit Target Weight',
2185 'Org Units can be organized into hold target groups based on a weight. Potential copies from org units with the same weight are chosen at random.',
2189 INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VALUES (
2190 'circ.holds.target_holds_by_org_unit_weight',
2191 'Holds: Use weight-based hold targeting',
2192 'Use library weight based hold targeting',
2196 INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VALUES (
2197 'circ.holds.max_org_unit_target_loops',
2198 'Holds: Maximum library target attempts',
2199 'When this value is set and greater than 0, the system will only attempt to find a copy at each possible branch the configured number of times',
2204 -- Org setting for overriding the circ lib of a precat copy
2205 INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VALUES (
2206 'circ.pre_cat_copy_circ_lib',
2207 'Pre-cat Item Circ Lib',
2208 'Override the default circ lib of "here" with a pre-configured circ lib for pre-cat items. The value should be the "shortname" (aka policy name) of the org unit',
2212 -- perm to override max claims returned
2213 INSERT INTO permission.perm_list (code, description) VALUES (
2214 'SET_CIRC_CLAIMS_RETURNED.override',
2215 'Allows staff to override the max claims returned value for a patron'
2218 -- Circ auto-renew interval setting
2219 INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VALUES (
2220 'circ.checkout_auto_renew_age',
2221 'Checkout auto renew age',
2222 'When an item has been checked out for at least this amount of time, an attempt to check out the item to the patron that it is already checked out to will simply renew the circulation',
2226 -- Setting for behind the desk hold pickups
2227 INSERT INTO config.org_unit_setting_type (name, label, description, datatype) VALUES (
2228 'circ.holds.behind_desk_pickup_supported',
2229 'Holds: Behind Desk Pickup Supported',
2230 'If a branch supports both a public holds shelf and behind-the-desk pickups, set this value to true. This gives the patron the option to enable behind-the-desk pickups for their holds',
2234 -- Hold cancel action/trigger hooks
2236 INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
2237 'hold_request.cancel.expire_no_target',
2239 'A hold is cancelled because no copies were found'
2242 INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
2243 'hold_request.cancel.expire_holds_shelf',
2245 'A hold is cancelled becuase it was on the holds shelf too long'
2248 INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
2249 'hold_request.cancel.staff',
2251 'A hold is cancelled becuase it was cancelled by staff'
2254 INSERT INTO action_trigger.hook (key,core_type,description) VALUES (
2255 'hold_request.cancel.patron',
2257 'A hold is cancelled by the patron'