1 --002.schema.config.sql:
2 INSERT INTO config.bib_source (quality, source, transcendant) VALUES
3 (90, oils_i18n_gettext('oclc'), FALSE),
4 (10, oils_i18n_gettext('System Local'), FALSE),
5 (1, oils_i18n_gettext('Project Gutenberg'), TRUE);
7 INSERT INTO config.standing (value) VALUES (oils_i18n_gettext('Good'));
8 INSERT INTO config.standing (value) VALUES (oils_i18n_gettext('Barred'));
10 INSERT INTO config.xml_transform VALUES ( 'marcxml', 'http://www.loc.gov/MARC21/slim', 'marc', '---' );
11 INSERT INTO config.xml_transform VALUES ( 'mods', 'http://www.loc.gov/mods/', 'mods', '/home/miker/MARC21slim2MODS.xsl' );
13 INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES
14 ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ ),
15 ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abbreviated')]$$ ),
16 ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ ),
17 ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ ),
18 ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ ),
19 ( 'author', 'corporate', $$//mods:mods/mods:name[@type='corporate']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ),
20 ( 'author', 'personal', $$//mods:mods/mods:name[@type='personal']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ),
21 ( 'author', 'conference', $$//mods:mods/mods:name[@type='conference']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ),
22 ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ ),
23 ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ ),
24 ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ ),
25 ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ ),
26 ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ ),
27 -- ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ ),
28 ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */
30 INSERT INTO config.audience_map (code, value, description) VALUES
31 ('', oils_i18n_gettext('Unknown or unspecified'), oils_i18n_gettext('The target audience for the item not known or not specified.')),
32 ('a', oils_i18n_gettext('Preschool'), oils_i18n_gettext('The item is intended for children, approximate ages 0-5 years.')),
33 ('b', oils_i18n_gettext('Primary'), oils_i18n_gettext('The item is intended for children, approximate ages 6-8 years.')),
34 ('c', oils_i18n_gettext('Pre-adolescent'), oils_i18n_gettext('The item is intended for young people, approximate ages 9-13 years.')),
35 ('d', oils_i18n_gettext('Adolescent'), oils_i18n_gettext('The item is intended for young people, approximate ages 14-17 years.')),
36 ('e', oils_i18n_gettext('Adult'), oils_i18n_gettext('The item is intended for adults.')),
37 ('f', oils_i18n_gettext('Specialized'), oils_i18n_gettext('The item is aimed at a particular audience and the nature of the presentation makes the item of little interest to another audience.')),
38 ('g', oils_i18n_gettext('General'), oils_i18n_gettext('The item is of general interest and not aimed at an audience of a particular intellectual level.')),
39 ('j', oils_i18n_gettext('Juvenile'), oils_i18n_gettext('The item is intended for children and young people, approximate ages 0-15 years.'));
42 INSERT INTO permission.usr_perm_map (usr,perm,depth) VALUES (1,-1,0);
44 --010.schema.biblio.sql:
45 INSERT INTO biblio.record_entry VALUES (-1,1,1,1,-1,NOW(),NOW(),FALSE,FALSE,'','AUTOGEN','-1','','FOO');
47 --040.schema.asset.sql:
48 INSERT INTO asset.copy_location (name,owning_lib) VALUES (oils_i18n_gettext('Stacks'),1);
49 INSERT INTO asset.call_number VALUES (-1,1,NOW(),1,NOW(),-1,1,'UNCATALOGED');