From 60177e62cf3a696a76c83ca4eebd889a0c730cc1 Mon Sep 17 00:00:00 2001 From: dbs Date: Tue, 4 Dec 2007 08:17:35 +0000 Subject: [PATCH] Enable translation of seed values stored in database. Moves all DML from schema files into a single file. db-seed-i18n.py will generate POT files and SQL for new localizations. Commit a new POT file for the database seed values. git-svn-id: svn://svn.open-ils.org/ILS/trunk@8134 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 650 +--- Open-ILS/src/sql/Pg/005.schema.actors.sql | 31 +- Open-ILS/src/sql/Pg/006.data.permissions.sql | 283 -- Open-ILS/src/sql/Pg/010.schema.biblio.sql | 2 - Open-ILS/src/sql/Pg/040.schema.asset.sql | 4 - Open-ILS/src/sql/Pg/950.data.seed-values.sql | 944 ++++++ Open-ILS/src/sql/Pg/build-db.sh | 2 +- build/i18n/Makefile | 5 +- build/i18n/po/db.seed.pot | 2844 ++++++++++++++++++ build/i18n/scripts/db-seed-i18n.py | 133 + 10 files changed, 3935 insertions(+), 963 deletions(-) delete mode 100644 Open-ILS/src/sql/Pg/006.data.permissions.sql create mode 100644 Open-ILS/src/sql/Pg/950.data.seed-values.sql create mode 100644 build/i18n/po/db.seed.pot create mode 100755 build/i18n/scripts/db-seed-i18n.py diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index f39500f412..e840715910 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -68,11 +68,6 @@ COMMENT ON TABLE config.bib_source IS $$ */ $$; - -INSERT INTO config.bib_source (quality, source) VALUES (90, 'oclc'); -INSERT INTO config.bib_source (quality, source) VALUES (10, 'System Local'); -INSERT INTO config.bib_source (quality, source, transcendant) VALUES (1, 'Project Gutenberg', TRUE); - CREATE TABLE config.standing ( id SERIAL PRIMARY KEY, value TEXT NOT NULL UNIQUE @@ -86,7 +81,7 @@ COMMENT ON TABLE config.standing IS $$ * * This table contains the values that can be applied to a patron * by a staff member. These values should not be changed, other - * that for translation, as the ID column is currently a "magic + * than for translation, as the ID column is currently a "magic * number" in the source. :( * * **** @@ -103,18 +98,12 @@ COMMENT ON TABLE config.standing IS $$ */ $$; -INSERT INTO config.standing (value) VALUES ('Good'); -INSERT INTO config.standing (value) VALUES ('Barred'); - - CREATE TABLE config.xml_transform ( name TEXT PRIMARY KEY, namespace_uri TEXT NOT NULL UNIQUE, prefix TEXT NOT NULL, xslt TEXT NOT NULL ); -INSERT INTO config.xml_transform VALUES ( 'marcxml', 'http://www.loc.gov/MARC21/slim', 'marc', '---' ); -INSERT INTO config.xml_transform VALUES ( 'mods', 'http://www.loc.gov/mods/', 'mods', '/home/miker/MARC21slim2MODS.xsl' ); CREATE TABLE config.metabib_field ( id SERIAL PRIMARY KEY, @@ -133,7 +122,7 @@ COMMENT ON TABLE config.metabib_field IS $$ * * XPath used for record indexing ingest * - * This table contains the XPath used to chop up MODS into it's + * This table contains the XPath used to chop up MODS into its * indexable parts. Each XPath entry is named and assigned to * a "class" of either title, subject, author, keyword or series. * @@ -154,23 +143,6 @@ $$; CREATE UNIQUE INDEX config_metabib_field_class_name_idx ON config.metabib_field (field_class, name); - -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abbreviated')]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'corporate', $$//mods:mods/mods:name[@type='corporate']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'personal', $$//mods:mods/mods:name[@type='personal']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'conference', $$//mods:mods/mods:name[@type='conference']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ ); --- INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ ); -INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */ - CREATE TABLE config.non_cataloged_type ( id SERIAL PRIMARY KEY, owning_lib INT NOT NULL, -- REFERENCES actor.org_unit (id), @@ -201,9 +173,6 @@ COMMENT ON TABLE config.non_cataloged_type IS $$ */ $$; - -INSERT INTO config.non_cataloged_type ( owning_lib, name ) VALUES ( 1, 'Paperback Book' ); - CREATE TABLE config.identification_type ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE @@ -233,11 +202,6 @@ COMMENT ON TABLE config.identification_type IS $$ */ $$; - -INSERT INTO config.identification_type ( name ) VALUES ( 'Drivers License' ); -INSERT INTO config.identification_type ( name ) VALUES ( 'SSN' ); -INSERT INTO config.identification_type ( name ) VALUES ( 'Other' ); - CREATE TABLE config.rule_circ_duration ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ), @@ -270,20 +234,6 @@ COMMENT ON TABLE config.rule_circ_duration IS $$ */ $$; -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_0_renew', '7 days', '7 days', '7 days', 0); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_2_renew', '28 days', '28 days', '28 days', 2); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_months_0_renew', '3 mons', '3 mons', '3 mons', 0); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '3_days_1_renew', '3 days', '3 days', '3 days', 1); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '2_months_2_renew', '2 mons', '2 mons', '2 mons', 2); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '35_days_1_renew', '35 days', '35 days', '35 days', 1); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '7_days_2_renew', '7 days', '7 days', '7 days', 2); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '1_hour_2_renew', '1 hour', '1 hour', '1 hour', 2); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_0_renew', '28 days', '28 days', '28 days', 0); -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '14_days_2_renew', '14 days', '14 days', '14 days', 2); - -INSERT INTO config.rule_circ_duration VALUES (DEFAULT, 'default', '21 days', '14 days', '7 days', 2); - - CREATE TABLE config.rule_max_fine ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ), @@ -314,16 +264,6 @@ COMMENT ON TABLE config.rule_max_fine IS $$ */ $$; -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'default', 5.00); - -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00); -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00); -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00); -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_min', 25.00); -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_mid', 25.00); -INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_equip_max', 100.00); - - CREATE TABLE config.rule_recuring_fine ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE CHECK ( name ~ E'^\\w+$' ), @@ -337,9 +277,9 @@ COMMENT ON TABLE config.rule_recuring_fine IS $$ * Copyright (C) 2005 Georgia Public Library Service * Mike Rylander * - * Circulation Recuring Fine rules + * Circulation Recurring Fine rules * - * Each circulation is given a recuring fine amount based on one of + * Each circulation is given a recurring fine amount based on one of * these rules. The recurance_interval should not be any shorter * than the interval between runs of the fine_processor.pl script * (which is run from CRON), or you could miss fines. @@ -359,10 +299,6 @@ COMMENT ON TABLE config.rule_recuring_fine IS $$ */ $$; -INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, 'default', 0.50, 0.10, 0.05, '1 day'); -INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day'); -INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day'); - CREATE TABLE config.rule_age_hold_protect ( id SERIAL PRIMARY KEY, @@ -380,7 +316,7 @@ COMMENT ON TABLE config.rule_age_hold_protect IS $$ * A hold request can only capture new(ish) items when they are * within a particular proximity of the home_ou of the requesting * user. The proximity ('prox' column) is calculated by counting - * the number of tree edges beween the user's home_ou and the owning_lib + * the number of tree edges between the user's home_ou and the owning_lib * of the copy that could fulfill the hold. * * @@ -398,10 +334,6 @@ COMMENT ON TABLE config.rule_age_hold_protect IS $$ */ $$; -INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '3month', '3 mons', 0); -INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, '6month', '6 mons', 2); - - CREATE TABLE config.copy_status ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE, @@ -417,7 +349,7 @@ COMMENT ON TABLE config.copy_status IS $$ * The available copy statuses, and whether a copy in that * status is available for hold request capture. 0 (zero) is * the only special number in this set, meaning that the item - * is available for imediate checkout, and is counted as available + * is available for immediate checkout, and is counted as available * in the OPAC. * * Statuses with an ID below 100 are not removable, and have special @@ -426,7 +358,7 @@ COMMENT ON TABLE config.copy_status IS $$ * * You may add and remove statuses above 100, and these can be used * to remove items from normal circulation without affecting the rest - * of the copy's values or it's location. + * of the copy's values or its location. * * **** * @@ -442,25 +374,6 @@ COMMENT ON TABLE config.copy_status IS $$ */ $$; -INSERT INTO config.copy_status (id,name,holdable) VALUES (0,'Available','t'); -INSERT INTO config.copy_status (name,holdable) VALUES ('Checked out','t'); -INSERT INTO config.copy_status (name) VALUES ('Bindery'); -INSERT INTO config.copy_status (name) VALUES ('Lost'); -INSERT INTO config.copy_status (name) VALUES ('Missing'); -INSERT INTO config.copy_status (name,holdable) VALUES ('In process','t'); -INSERT INTO config.copy_status (name,holdable) VALUES ('In transit','t'); -INSERT INTO config.copy_status (name,holdable) VALUES ('Reshelving','t'); -INSERT INTO config.copy_status (name,holdable) VALUES ('On holds shelf','t'); -INSERT INTO config.copy_status (name,holdable) VALUES ('On order','t'); -INSERT INTO config.copy_status (name) VALUES ('ILL'); -INSERT INTO config.copy_status (name) VALUES ('Cataloging'); -INSERT INTO config.copy_status (name) VALUES ('Reserves'); -INSERT INTO config.copy_status (name) VALUES ('Discard/Weed'); -INSERT INTO config.copy_status (name) VALUES ('Damaged'); - -SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100); - - CREATE TABLE config.net_access_level ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE @@ -489,581 +402,32 @@ COMMENT ON TABLE config.net_access_level IS $$ */ $$; -INSERT INTO config.net_access_level (name) VALUES ('Filtered'); -INSERT INTO config.net_access_level (name) VALUES ('Unfiltered'); -INSERT INTO config.net_access_level (name) VALUES ('No Access'); - CREATE TABLE config.audience_map ( code TEXT PRIMARY KEY, value TEXT NOT NULL, description TEXT ); -COPY config.audience_map FROM STDIN; - Unknown or unspecified The target audience for the item not known or not specified. -a Preschool The item is intended for children, approximate ages 0-5 years. -b Primary The item is intended for children, approximate ages 6-8 years. -c Pre-adolescent The item is intended for young people, approximate ages 9-13 years. -d Adolescent The item is intended for young people, approximate ages 14-17 years. -e Adult The item is intended for adults. -f Specialized The item is aimed at a particular audience and the nature of the presentation makes the item of little interest to another audience. -g General The item is of general interest and not aimed at an audience of a particular intellectual level. -j Juvenile The item is intended for children and young people, approximate ages 0-15 years. -\. - - CREATE TABLE config.lit_form_map ( code TEXT PRIMARY KEY, value TEXT NOT NULL, description TEXT ); -COPY config.lit_form_map FROM STDIN; -0 Not fiction (not further specified) The item is not a work of fiction and no further identification of the literary form is desired -1 Fiction (not further specified) The item is a work of fiction and no further identification of the literary form is desired -c Comic strips \N -d Dramas \N -e Essays \N -f Novels \N -h Humor, satires, etc. The item is a humorous work, satire or of similar literary form. -i Letters The item is a single letter or collection of correspondence. -j Short stories The item is a short story or collection of short stories. -m Mixed forms The item is a variety of literary forms (e.g., poetry and short stories). -p Poetry The item is a poem or collection of poems. -s Speeches The item is a speech or collection of speeches. -u Unknown The literary form of the item is unknown. -\. - CREATE TABLE config.language_map ( code TEXT PRIMARY KEY, value TEXT NOT NULL ); -COPY config.language_map FROM STDIN; -aar Afar -abk Abkhaz -ace Achinese -ach Acoli -ada Adangme -ady Adygei -afa Afroasiatic (Other) -afh Afrihili (Artificial language) -afr Afrikaans --ajm Aljamía -aka Akan -akk Akkadian -alb Albanian -ale Aleut -alg Algonquian (Other) -amh Amharic -ang English, Old (ca. 450-1100) -apa Apache languages -ara Arabic -arc Aramaic -arg Aragonese Spanish -arm Armenian -arn Mapuche -arp Arapaho -art Artificial (Other) -arw Arawak -asm Assamese -ast Bable -ath Athapascan (Other) -aus Australian languages -ava Avaric -ave Avestan -awa Awadhi -aym Aymara -aze Azerbaijani -bad Banda -bai Bamileke languages -bak Bashkir -bal Baluchi -bam Bambara -ban Balinese -baq Basque -bas Basa -bat Baltic (Other) -bej Beja -bel Belarusian -bem Bemba -ben Bengali -ber Berber (Other) -bho Bhojpuri -bih Bihari -bik Bikol -bin Edo -bis Bislama -bla Siksika -bnt Bantu (Other) -bos Bosnian -bra Braj -bre Breton -btk Batak -bua Buriat -bug Bugis -bul Bulgarian -bur Burmese -cad Caddo -cai Central American Indian (Other) --cam Khmer -car Carib -cat Catalan -cau Caucasian (Other) -ceb Cebuano -cel Celtic (Other) -cha Chamorro -chb Chibcha -che Chechen -chg Chagatai -chi Chinese -chk Truk -chm Mari -chn Chinook jargon -cho Choctaw -chp Chipewyan -chr Cherokee -chu Church Slavic -chv Chuvash -chy Cheyenne -cmc Chamic languages -cop Coptic -cor Cornish -cos Corsican -cpe Creoles and Pidgins, English-based (Other) -cpf Creoles and Pidgins, French-based (Other) -cpp Creoles and Pidgins, Portuguese-based (Other) -cre Cree -crh Crimean Tatar -crp Creoles and Pidgins (Other) -cus Cushitic (Other) -cze Czech -dak Dakota -dan Danish -dar Dargwa -day Dayak -del Delaware -den Slave -dgr Dogrib -din Dinka -div Divehi -doi Dogri -dra Dravidian (Other) -dua Duala -dum Dutch, Middle (ca. 1050-1350) -dut Dutch -dyu Dyula -dzo Dzongkha -efi Efik -egy Egyptian -eka Ekajuk -elx Elamite -eng English -enm English, Middle (1100-1500) -epo Esperanto --esk Eskimo languages --esp Esperanto -est Estonian --eth Ethiopic -ewe Ewe -ewo Ewondo -fan Fang -fao Faroese --far Faroese -fat Fanti -fij Fijian -fin Finnish -fiu Finno-Ugrian (Other) -fon Fon -fre French --fri Frisian -frm French, Middle (ca. 1400-1600) -fro French, Old (ca. 842-1400) -fry Frisian -ful Fula -fur Friulian -gaa Gã --gae Scottish Gaelic --gag Galician --gal Oromo -gay Gayo -gba Gbaya -gem Germanic (Other) -geo Georgian -ger German -gez Ethiopic -gil Gilbertese -gla Scottish Gaelic -gle Irish -glg Galician -glv Manx -gmh German, Middle High (ca. 1050-1500) -goh German, Old High (ca. 750-1050) -gon Gondi -gor Gorontalo -got Gothic -grb Grebo -grc Greek, Ancient (to 1453) -gre Greek, Modern (1453- ) -grn Guarani --gua Guarani -guj Gujarati -gwi Gwich'in -hai Haida -hat Haitian French Creole -hau Hausa -haw Hawaiian -heb Hebrew -her Herero -hil Hiligaynon -him Himachali -hin Hindi -hit Hittite -hmn Hmong -hmo Hiri Motu -hun Hungarian -hup Hupa -iba Iban -ibo Igbo -ice Icelandic -ido Ido -iii Sichuan Yi -ijo Ijo -iku Inuktitut -ile Interlingue -ilo Iloko -ina Interlingua (International Auxiliary Language Association) -inc Indic (Other) -ind Indonesian -ine Indo-European (Other) -inh Ingush --int Interlingua (International Auxiliary Language Association) -ipk Inupiaq -ira Iranian (Other) --iri Irish -iro Iroquoian (Other) -ita Italian -jav Javanese -jpn Japanese -jpr Judeo-Persian -jrb Judeo-Arabic -kaa Kara-Kalpak -kab Kabyle -kac Kachin -kal Kalâtdlisut -kam Kamba -kan Kannada -kar Karen -kas Kashmiri -kau Kanuri -kaw Kawi -kaz Kazakh -kbd Kabardian -kha Khasi -khi Khoisan (Other) -khm Khmer -kho Khotanese -kik Kikuyu -kin Kinyarwanda -kir Kyrgyz -kmb Kimbundu -kok Konkani -kom Komi -kon Kongo -kor Korean -kos Kusaie -kpe Kpelle -kro Kru -kru Kurukh -kua Kuanyama -kum Kumyk -kur Kurdish --kus Kusaie -kut Kutenai -lad Ladino -lah Lahnda -lam Lamba --lan Occitan (post-1500) -lao Lao --lap Sami -lat Latin -lav Latvian -lez Lezgian -lim Limburgish -lin Lingala -lit Lithuanian -lol Mongo-Nkundu -loz Lozi -ltz Letzeburgesch -lua Luba-Lulua -lub Luba-Katanga -lug Ganda -lui Luiseño -lun Lunda -luo Luo (Kenya and Tanzania) -lus Lushai -mac Macedonian -mad Madurese -mag Magahi -mah Marshallese -mai Maithili -mak Makasar -mal Malayalam -man Mandingo -mao Maori -map Austronesian (Other) -mar Marathi -mas Masai --max Manx -may Malay -mdr Mandar -men Mende -mga Irish, Middle (ca. 1100-1550) -mic Micmac -min Minangkabau -mis Miscellaneous languages -mkh Mon-Khmer (Other) --mla Malagasy -mlg Malagasy -mlt Maltese -mnc Manchu -mni Manipuri -mno Manobo languages -moh Mohawk -mol Moldavian -mon Mongolian -mos Mooré -mul Multiple languages -mun Munda (Other) -mus Creek -mwr Marwari -myn Mayan languages -nah Nahuatl -nai North American Indian (Other) -nap Neapolitan Italian -nau Nauru -nav Navajo -nbl Ndebele (South Africa) -nde Ndebele (Zimbabwe) -ndo Ndonga -nds Low German -nep Nepali -new Newari -nia Nias -nic Niger-Kordofanian (Other) -niu Niuean -nno Norwegian (Nynorsk) -nob Norwegian (Bokmål) -nog Nogai -non Old Norse -nor Norwegian -nso Northern Sotho -nub Nubian languages -nya Nyanja -nym Nyamwezi -nyn Nyankole -nyo Nyoro -nzi Nzima -oci Occitan (post-1500) -oji Ojibwa -ori Oriya -orm Oromo -osa Osage -oss Ossetic -ota Turkish, Ottoman -oto Otomian languages -paa Papuan (Other) -pag Pangasinan -pal Pahlavi -pam Pampanga -pan Panjabi -pap Papiamento -pau Palauan -peo Old Persian (ca. 600-400 B.C.) -per Persian -phi Philippine (Other) -phn Phoenician -pli Pali -pol Polish -pon Ponape -por Portuguese -pra Prakrit languages -pro Provençal (to 1500) -pus Pushto -que Quechua -raj Rajasthani -rap Rapanui -rar Rarotongan -roa Romance (Other) -roh Raeto-Romance -rom Romani -rum Romanian -run Rundi -rus Russian -sad Sandawe -sag Sango (Ubangi Creole) -sah Yakut -sai South American Indian (Other) -sal Salishan languages -sam Samaritan Aramaic -san Sanskrit --sao Samoan -sas Sasak -sat Santali -scc Serbian -sco Scots -scr Croatian -sel Selkup -sem Semitic (Other) -sga Irish, Old (to 1100) -sgn Sign languages -shn Shan --sho Shona -sid Sidamo -sin Sinhalese -sio Siouan (Other) -sit Sino-Tibetan (Other) -sla Slavic (Other) -slo Slovak -slv Slovenian -sma Southern Sami -sme Northern Sami -smi Sami -smj Lule Sami -smn Inari Sami -smo Samoan -sms Skolt Sami -sna Shona -snd Sindhi --snh Sinhalese -snk Soninke -sog Sogdian -som Somali -son Songhai -sot Sotho -spa Spanish -srd Sardinian -srr Serer -ssa Nilo-Saharan (Other) --sso Sotho -ssw Swazi -suk Sukuma -sun Sundanese -sus Susu -sux Sumerian -swa Swahili -swe Swedish --swz Swazi -syr Syriac --tag Tagalog -tah Tahitian -tai Tai (Other) --taj Tajik -tam Tamil --tar Tatar -tat Tatar -tel Telugu -tem Temne -ter Terena -tet Tetum -tgk Tajik -tgl Tagalog -tha Thai -tib Tibetan -tig Tigré -tir Tigrinya -tiv Tiv -tkl Tokelauan -tli Tlingit -tmh Tamashek -tog Tonga (Nyasa) -ton Tongan -tpi Tok Pisin --tru Truk -tsi Tsimshian -tsn Tswana -tso Tsonga --tsw Tswana -tuk Turkmen -tum Tumbuka -tup Tupi languages -tur Turkish -tut Altaic (Other) -tvl Tuvaluan -twi Twi -tyv Tuvinian -udm Udmurt -uga Ugaritic -uig Uighur -ukr Ukrainian -umb Umbundu -und Undetermined -urd Urdu -uzb Uzbek -vai Vai -ven Venda -vie Vietnamese -vol Volapük -vot Votic -wak Wakashan languages -wal Walamo -war Waray -was Washo -wel Welsh -wen Sorbian languages -wln Walloon -wol Wolof -xal Kalmyk -xho Xhosa -yao Yao (Africa) -yap Yapese -yid Yiddish -yor Yoruba -ypk Yupik languages -zap Zapotec -zen Zenaga -zha Zhuang -znd Zande -zul Zulu -zun Zuni -\. - CREATE TABLE config.item_form_map ( code TEXT PRIMARY KEY, value TEXT NOT NULL ); -COPY config.item_form_map FROM STDIN; -a Microfilm -b Microfiche -c Microopaque -d Large print -f Braille -r Regular print reproduction -s Electronic -\. - CREATE TABLE config.item_type_map ( code TEXT PRIMARY KEY, value TEXT NOT NULL ); -COPY config.item_type_map FROM STDIN; -a Language material -t Manuscript language material -g Projected medium -k Two-dimensional nonprojectable graphic -r Three-dimensional artifact or naturally occurring object -o Kit -p Mixed materials -e Cartographic material -f Manuscript cartographic material -c Notated music -d Manuscript notated music -i Nonmusical sound recording -j Musical sound recording -m Computer file -\. - COMMIT; diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index d783c5eef4..745435ce64 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -132,10 +132,6 @@ CREATE TRIGGER actor_crypt_pw_insert_trigger CREATE RULE protect_user_delete AS ON DELETE TO actor.usr DO INSTEAD UPDATE actor.usr SET deleted = TRUE WHERE OLD.id = actor.usr.id; --- Just so that there is a user... -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 ); - CREATE TABLE actor.usr_note ( id BIGSERIAL PRIMARY KEY, usr BIGINT NOT NULL REFERENCES actor.usr ON DELETE CASCADE, @@ -256,8 +252,8 @@ COMMENT ON TABLE actor.stat_cat_entry IS $$ * User Statistical Catagory Entries * * Local data collected about Users is placed into a Statistical - * Catagory. Each library can create entries into any of it's own - * stat_cats, it's anscestors stat_cats, or it's descendants' stat_cats. + * Catagory. Each library can create entries into any of its own + * stat_cats, its ancestors' stat_cats, or its descendants' stat_cats. * * * **** @@ -343,9 +339,6 @@ $$; CREATE INDEX actor_card_usr_idx ON actor.card (usr); -INSERT INTO actor.card (usr, barcode) VALUES (1,'101010101010101'); - - CREATE TABLE actor.org_unit_type ( id SERIAL PRIMARY KEY, name TEXT NOT NULL, @@ -357,13 +350,6 @@ CREATE TABLE actor.org_unit_type ( ); CREATE INDEX actor_org_unit_type_parent_idx ON actor.org_unit_type (parent); --- The PINES levels -INSERT INTO actor.org_unit_type (name, opac_label, depth, parent, can_have_users, can_have_vols) VALUES ( 'Consortium','Everywhere', 0, NULL, FALSE, FALSE ); -INSERT INTO actor.org_unit_type (name, opac_label, depth, parent, can_have_users, can_have_vols) VALUES ( 'System','Local Library System', 1, 1, FALSE, FALSE ); -INSERT INTO actor.org_unit_type (name, opac_label, depth, parent) VALUES ( 'Branch','This Branch', 2, 2 ); -INSERT INTO actor.org_unit_type (name, opac_label, depth, parent) VALUES ( 'Sub-lib','This Specialized Library', 3, 3 ); -INSERT INTO actor.org_unit_type (name, opac_label, depth, parent) VALUES ( 'Bookmobile','Your Bookmobile', 3, 3 ); - CREATE TABLE actor.org_unit ( id SERIAL PRIMARY KEY, parent_ou INT REFERENCES actor.org_unit (id), @@ -385,16 +371,6 @@ CREATE INDEX actor_org_unit_billing_address_idx ON actor.org_unit (billing_addre CREATE INDEX actor_org_unit_mailing_address_idx ON actor.org_unit (mailing_address); CREATE INDEX actor_org_unit_holds_address_idx ON actor.org_unit (holds_address); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (NULL, 1, 'CONS', 'Example Consortium'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (1, 2, 'SYS1', 'Example System 1'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (1, 2, 'SYS2', 'Example System 2'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (2, 3, 'BR1', 'Example Branch 1'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (2, 3, 'BR2', 'Example Branch 2'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (3, 3, 'BR3', 'Example Branch 3'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (3, 3, 'BR4', 'Example Branch 4'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (4, 4, 'SL1', 'Example Sub-lib 1'); -INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES (6, 5, 'BM1', 'Example Bookmobile 1'); - CREATE TABLE actor.org_unit_proximity ( id BIGSERIAL PRIMARY KEY, from_org INT, @@ -521,7 +497,4 @@ CREATE TABLE actor.org_address ( CREATE INDEX actor_org_address_org_unit_idx ON actor.org_address (org_unit); -INSERT INTO actor.org_address VALUES (DEFAULT,DEFAULT,DEFAULT,1,'123 Main St.',NULL,'Anywhere',NULL,'GA','US','30303'); -UPDATE actor.org_unit SET holds_address = 1, ill_address = 1, billing_address = 1, mailing_address = 1; - COMMIT; diff --git a/Open-ILS/src/sql/Pg/006.data.permissions.sql b/Open-ILS/src/sql/Pg/006.data.permissions.sql deleted file mode 100644 index f312cfdc4a..0000000000 --- a/Open-ILS/src/sql/Pg/006.data.permissions.sql +++ /dev/null @@ -1,283 +0,0 @@ -INSERT INTO permission.perm_list VALUES (-1, 'EVERYTHING', NULL); -INSERT INTO permission.perm_list VALUES (2, 'OPAC_LOGIN', NULL); -INSERT INTO permission.perm_list VALUES (4, 'STAFF_LOGIN', NULL); -INSERT INTO permission.perm_list VALUES (5, 'MR_HOLDS', NULL); -INSERT INTO permission.perm_list VALUES (6, 'TITLE_HOLDS', NULL); -INSERT INTO permission.perm_list VALUES (7, 'VOLUME_HOLDS', NULL); -INSERT INTO permission.perm_list VALUES (8, 'COPY_HOLDS', 'User is allowed to place a hold on a specific copy'); -INSERT INTO permission.perm_list VALUES (9, 'REQUEST_HOLDS', NULL); -INSERT INTO permission.perm_list VALUES (10, 'REQUEST_HOLDS_OVERRIDE', NULL); -INSERT INTO permission.perm_list VALUES (11, 'VIEW_HOLD', 'Allows a user to view another user''s holds'); -INSERT INTO permission.perm_list VALUES (13, 'DELETE_HOLDS', NULL); -INSERT INTO permission.perm_list VALUES (14, 'UPDATE_HOLD', 'Allows a user to update another user''s hold'); -INSERT INTO permission.perm_list VALUES (15, 'RENEW_CIRC', NULL); -INSERT INTO permission.perm_list VALUES (16, 'VIEW_USER_FINES_SUMMARY', NULL); -INSERT INTO permission.perm_list VALUES (17, 'VIEW_USER_TRANSACTIONS', NULL); -INSERT INTO permission.perm_list VALUES (18, 'UPDATE_MARC', NULL); -INSERT INTO permission.perm_list VALUES (19, 'CREATE_MARC', 'User is allowed to create new MARC records'); -INSERT INTO permission.perm_list VALUES (20, 'IMPORT_MARC', NULL); -INSERT INTO permission.perm_list VALUES (21, 'CREATE_VOLUME', NULL); -INSERT INTO permission.perm_list VALUES (22, 'UPDATE_VOLUME', NULL); -INSERT INTO permission.perm_list VALUES (23, 'DELETE_VOLUME', NULL); -INSERT INTO permission.perm_list VALUES (25, 'UPDATE_COPY', NULL); -INSERT INTO permission.perm_list VALUES (26, 'DELETE_COPY', NULL); -INSERT INTO permission.perm_list VALUES (27, 'RENEW_HOLD_OVERRIDE', NULL); -INSERT INTO permission.perm_list VALUES (28, 'CREATE_USER', NULL); -INSERT INTO permission.perm_list VALUES (29, 'UPDATE_USER', NULL); -INSERT INTO permission.perm_list VALUES (30, 'DELETE_USER', NULL); -INSERT INTO permission.perm_list VALUES (31, 'VIEW_USER', NULL); -INSERT INTO permission.perm_list VALUES (32, 'COPY_CHECKIN', NULL); -INSERT INTO permission.perm_list VALUES (33, 'CREATE_TRANSIT', NULL); -INSERT INTO permission.perm_list VALUES (34, 'VIEW_PERMISSION', NULL); -INSERT INTO permission.perm_list VALUES (35, 'CHECKIN_BYPASS_HOLD_FULFILL', NULL); -INSERT INTO permission.perm_list VALUES (36, 'CREATE_PAYMENT', NULL); -INSERT INTO permission.perm_list VALUES (37, 'SET_CIRC_LOST', NULL); -INSERT INTO permission.perm_list VALUES (38, 'SET_CIRC_MISSING', NULL); -INSERT INTO permission.perm_list VALUES (39, 'SET_CIRC_CLAIMS_RETURNED', NULL); -INSERT INTO permission.perm_list VALUES (41, 'CREATE_TRANSACTION', 'User may create new billable transactions'); -INSERT INTO permission.perm_list VALUES (43, 'CREATE_BILL', 'Allows a user to create a new bill on a transaction'); -INSERT INTO permission.perm_list VALUES (44, 'VIEW_CONTAINER', 'Allows a user to view another user''s containers (buckets)'); -INSERT INTO permission.perm_list VALUES (45, 'CREATE_CONTAINER', 'Allows a user to create a new container for another user'); -INSERT INTO permission.perm_list VALUES (24, 'CREATE_COPY', 'User is allowed to create a new copy object'); -INSERT INTO permission.perm_list VALUES (47, 'UPDATE_ORG_UNIT', 'Allows a user to change org unit settings'); -INSERT INTO permission.perm_list VALUES (48, 'VIEW_CIRCULATIONS', 'Allows a user to see what another use has checked out'); -INSERT INTO permission.perm_list VALUES (42, 'VIEW_TRANSACTION', 'User may view another user''s transactions'); -INSERT INTO permission.perm_list VALUES (49, 'DELETE_CONTAINER', 'Allows a user to delete another user container'); -INSERT INTO permission.perm_list VALUES (50, 'CREATE_CONTAINER_ITEM', 'Create a container item for another user'); -INSERT INTO permission.perm_list VALUES (51, 'CREATE_USER_GROUP_LINK', 'User can add other users to permission groups'); -INSERT INTO permission.perm_list VALUES (52, 'REMOVE_USER_GROUP_LINK', 'User can remove other users from permission groups'); -INSERT INTO permission.perm_list VALUES (53, 'VIEW_PERM_GROUPS', 'Allow user to view others'' permission groups'); -INSERT INTO permission.perm_list VALUES (54, 'VIEW_PERMIT_CHECKOUT', 'Allows a user to determine of another user can checkout an item'); -INSERT INTO permission.perm_list VALUES (55, 'UPDATE_BATCH_COPY', 'Allows a user to edit copies in batch'); -INSERT INTO permission.perm_list VALUES (56, 'CREATE_PATRON_STAT_CAT', 'User may create a new patron statistical category'); -INSERT INTO permission.perm_list VALUES (57, 'CREATE_COPY_STAT_CAT', 'User may create a copy stat cat'); -INSERT INTO permission.perm_list VALUES (58, 'CREATE_PATRON_STAT_CAT_ENTRY', 'User may create a new patron stat cat entry'); -INSERT INTO permission.perm_list VALUES (59, 'CREATE_COPY_STAT_CAT_ENTRY', 'User may create a new copy stat cat entry'); -INSERT INTO permission.perm_list VALUES (60, 'UPDATE_PATRON_STAT_CAT', 'User may update a patron stat cat'); -INSERT INTO permission.perm_list VALUES (61, 'UPDATE_COPY_STAT_CAT', 'User may update a copy stat cat'); -INSERT INTO permission.perm_list VALUES (62, 'UPDATE_PATRON_STAT_CAT_ENTRY', 'User may update a patron stat cat entry'); -INSERT INTO permission.perm_list VALUES (63, 'UPDATE_COPY_STAT_CAT_ENTRY', 'User may update a copy stat cat entry'); -INSERT INTO permission.perm_list VALUES (65, 'CREATE_COPY_STAT_CAT_ENTRY_MAP', 'User may link a copy to a stat cat entry'); -INSERT INTO permission.perm_list VALUES (64, 'CREATE_PATRON_STAT_CAT_ENTRY_MAP', 'User may link another user to a stat cat entry'); -INSERT INTO permission.perm_list VALUES (66, 'DELETE_PATRON_STAT_CAT', 'User may delete a patron stat cat'); -INSERT INTO permission.perm_list VALUES (67, 'DELETE_COPY_STAT_CAT', 'User may delete a copy stat cat'); -INSERT INTO permission.perm_list VALUES (68, 'DELETE_PATRON_STAT_CAT_ENTRY', 'User may delete a patron stat cat entry'); -INSERT INTO permission.perm_list VALUES (69, 'DELETE_COPY_STAT_CAT_ENTRY', 'User may delete a copy stat cat entry'); -INSERT INTO permission.perm_list VALUES (70, 'DELETE_PATRON_STAT_CAT_ENTRY_MAP', 'User may delete a patron stat cat entry map'); -INSERT INTO permission.perm_list VALUES (71, 'DELETE_COPY_STAT_CAT_ENTRY_MAP', 'User may delete a copy stat cat entry map'); -INSERT INTO permission.perm_list VALUES (72, 'CREATE_NON_CAT_TYPE', 'Allows a user to create a new non-cataloged item type'); -INSERT INTO permission.perm_list VALUES (73, 'UPDATE_NON_CAT_TYPE', 'Allows a user to update a non cataloged type'); -INSERT INTO permission.perm_list VALUES (74, 'CREATE_IN_HOUSE_USE', 'Allows a user to create a new in-house-use '); -INSERT INTO permission.perm_list VALUES (75, 'COPY_CHECKOUT', 'Allows a user to check out a copy'); -INSERT INTO permission.perm_list VALUES (76, 'CREATE_COPY_LOCATION', 'Allows a user to create a new copy location'); -INSERT INTO permission.perm_list VALUES (77, 'UPDATE_COPY_LOCATION', 'Allows a user to update a copy location'); -INSERT INTO permission.perm_list VALUES (78, 'DELETE_COPY_LOCATION', 'Allows a user to delete a copy location'); -INSERT INTO permission.perm_list VALUES (79, 'CREATE_COPY_TRANSIT', 'Allows a user to create a transit_copy object for transiting a copy'); -INSERT INTO permission.perm_list VALUES (80, 'COPY_TRANSIT_RECEIVE', 'Allows a user to close out a transit on a copy'); -INSERT INTO permission.perm_list VALUES (81, 'VIEW_HOLD_PERMIT', 'Allows a user to see if another user has permission to place a hold on a given copy'); -INSERT INTO permission.perm_list VALUES (82, 'VIEW_COPY_CHECKOUT_HISTORY', 'Allows a user to view which users have checked out a given copy'); -INSERT INTO permission.perm_list VALUES (83, 'REMOTE_Z3950_QUERY', 'Allows a user to perform z3950 queries against remote servers'); -INSERT INTO permission.perm_list VALUES (84, 'REGISTER_WORKSTATION', 'Allows a user to register a new workstation'); -INSERT INTO permission.perm_list VALUES (85, 'VIEW_COPY_NOTES', 'Allows a user to view all notes attached to a copy'); -INSERT INTO permission.perm_list VALUES (86, 'VIEW_VOLUME_NOTES', 'Allows a user to view all notes attached to a volume'); -INSERT INTO permission.perm_list VALUES (87, 'VIEW_TITLE_NOTES', 'Allows a user to view all notes attached to a title'); -INSERT INTO permission.perm_list VALUES (89, 'CREATE_VOLUME_NOTE', 'Allows a user to create a new volume note'); -INSERT INTO permission.perm_list VALUES (88, 'CREATE_COPY_NOTE', 'Allows a user to create a new copy note'); -INSERT INTO permission.perm_list VALUES (90, 'CREATE_TITLE_NOTE', 'Allows a user to create a new title note'); -INSERT INTO permission.perm_list VALUES (91, 'DELETE_COPY_NOTE', 'Allows a user to delete someone elses copy notes'); -INSERT INTO permission.perm_list VALUES (92, 'DELETE_VOLUME_NOTE', 'Allows a user to delete someone elses volume note'); -INSERT INTO permission.perm_list VALUES (93, 'DELETE_TITLE_NOTE', 'Allows a user to delete someone elses title note'); -INSERT INTO permission.perm_list VALUES (94, 'UPDATE_CONTAINER', 'Allows a user to update another users container'); -INSERT INTO permission.perm_list VALUES (95, 'CREATE_MY_CONTAINER', 'Allows a user to create a container for themselves'); -INSERT INTO permission.perm_list VALUES (96, 'VIEW_HOLD_NOTIFICATION', 'Allows a user to view notifications attached to a hold'); -INSERT INTO permission.perm_list VALUES (97, 'CREATE_HOLD_NOTIFICATION', 'Allows a user to create new hold notifications'); -INSERT INTO permission.perm_list VALUES (98, 'UPDATE_ORG_SETTING', 'Allows a user to update an org unit setting'); -INSERT INTO permission.perm_list VALUES (99, 'OFFLINE_UPLOAD', 'Allows a user to upload an offline script'); -INSERT INTO permission.perm_list VALUES (100, 'OFFLINE_VIEW', 'Allows a user to view uploaded offline script information'); -INSERT INTO permission.perm_list VALUES (101, 'OFFLINE_EXECUTE', 'Allows a user to execute an offline script batch'); -INSERT INTO permission.perm_list VALUES (102, 'CIRC_OVERRIDE_DUE_DATE', 'Allows a user to change set the due date on an item to any date'); -INSERT INTO permission.perm_list VALUES (103, 'CIRC_PERMIT_OVERRIDE', 'Allows a user to bypass the circ permit call for checkout'); -INSERT INTO permission.perm_list VALUES (104, 'COPY_IS_REFERENCE.override', 'Allows a user to override the copy_is_reference event'); -INSERT INTO permission.perm_list VALUES (105, 'VOID_BILLING', 'Allows a user to void a bill'); -INSERT INTO permission.perm_list VALUES (106, 'CIRC_CLAIMS_RETURNED.override', 'Allows a person to check in/out an item that is claims returned'); -INSERT INTO permission.perm_list VALUES (107, 'COPY_BAD_STATUS.override', 'Allows a user to check out an item in a non-circulatable status'); -INSERT INTO permission.perm_list VALUES (108, 'COPY_ALERT_MESSAGE.override', 'Allows a user to check in/out an item that has an alert message'); -INSERT INTO permission.perm_list VALUES (109, 'COPY_STATUS_LOST.override', 'Allows a user to remove the lost status from a copy'); -INSERT INTO permission.perm_list VALUES (110, 'COPY_STATUS_MISSING.override', 'Allows a user to change the missing status on a copy'); -INSERT INTO permission.perm_list VALUES (111, 'ABORT_TRANSIT', 'Allows a user to abort a copy transit if the user is at the transit destination or source'); -INSERT INTO permission.perm_list VALUES (112, 'ABORT_REMOTE_TRANIST', 'Allows a user to abort a copy transit if the user is not at the transit source or dest'); -INSERT INTO permission.perm_list VALUES (113, 'VIEW_ZIP_DATA', 'Allowsa user to query the zip code data method'); -INSERT INTO permission.perm_list VALUES (114, 'CANCEL_HOLDS', ''); -INSERT INTO permission.perm_list VALUES (115, 'CREATE_DUPLICATE_HOLDS', 'Allows a user to create duplicate holds (e.g. two holds on the same title)'); -INSERT INTO permission.perm_list VALUES (117, 'actor.org_unit.closed_date.update', 'Allows a user to update a closed date interval for a given location'); -INSERT INTO permission.perm_list VALUES (116, 'actor.org_unit.closed_date.delete', 'Allows a user to remove a closed date interval for a given location'); -INSERT INTO permission.perm_list VALUES (118, 'actor.org_unit.closed_date.create', 'Allows a user to create a new closed date for a location'); -INSERT INTO permission.perm_list VALUES (119, 'DELETE_NON_CAT_TYPE', 'Allows a user to delete a non cataloged type'); -INSERT INTO permission.perm_list VALUES (120, 'money.collections_tracker.create', 'Allows a user to put someone into collections'); -INSERT INTO permission.perm_list VALUES (121, 'money.collections_tracker.delete', 'Allows a user to remove someone from collections'); -INSERT INTO permission.perm_list VALUES (122, 'BAR_PATRON', 'Allows a user to bar a patron'); -INSERT INTO permission.perm_list VALUES (123, 'UNBAR_PATRON', 'Allows a user to un-bar a patron'); -INSERT INTO permission.perm_list VALUES (124, 'DELETE_WORKSTATION', 'Allows a user to remove an existing workstation so a new one can replace it'); -INSERT INTO permission.perm_list VALUES (125, 'group_application.user', 'Allows a user to add/remove users to/from the "User" group'); -INSERT INTO permission.perm_list VALUES (126, 'group_application.user.patron', 'Allows a user to add/remove users to/from the "Patron" group'); -INSERT INTO permission.perm_list VALUES (127, 'group_application.user.staff', 'Allows a user to add/remove users to/from the "Staff" group'); -INSERT INTO permission.perm_list VALUES (128, 'group_application.user.staff.circ', 'Allows a user to add/remove users to/from the "Circulator" group'); -INSERT INTO permission.perm_list VALUES (129, 'group_application.user.staff.cat', 'Allows a user to add/remove users to/from the "Cataloger" group'); -INSERT INTO permission.perm_list VALUES (130, 'group_application.user.staff.admin.global_admin', 'Allows a user to add/remove users to/from the "GlobalAdmin" group'); -INSERT INTO permission.perm_list VALUES (131, 'group_application.user.staff.admin.local_admin', 'Allows a user to add/remove users to/from the "LocalAdmin" group'); -INSERT INTO permission.perm_list VALUES (132, 'group_application.user.staff.admin.lib_manager', 'Allows a user to add/remove users to/from the "LibraryManager" group'); -INSERT INTO permission.perm_list VALUES (133, 'group_application.user.staff.cat.cat1', 'Allows a user to add/remove users to/from the "Cat1" group'); -INSERT INTO permission.perm_list VALUES (134, 'group_application.user.staff.supercat', 'Allows a user to add/remove users to/from the "Supercat" group'); -INSERT INTO permission.perm_list VALUES (135, 'group_application.user.sip_client', 'Allows a user to add/remove users to/from the "SIP-Client" group'); -INSERT INTO permission.perm_list VALUES (136, 'group_application.user.vendor', 'Allows a user to add/remove users to/from the "Vendor" group'); -INSERT INTO permission.perm_list VALUES (137, 'ITEM_AGE_PROTECTED.override', 'Allows a user to place a hold on an age-protected item'); -INSERT INTO permission.perm_list VALUES (138, 'MAX_RENEWALS_REACHED.override', 'Allows a user to renew an item past the maximun renewal count'); -INSERT INTO permission.perm_list VALUES (139, 'PATRON_EXCEEDS_CHECKOUT_COUNT.override', 'Allow staff to override checkout count failure'); -INSERT INTO permission.perm_list VALUES (140, 'PATRON_EXCEEDS_OVERDUE_COUNT.override', 'Allow staff to override overdue count failure'); -INSERT INTO permission.perm_list VALUES (141, 'PATRON_EXCEEDS_FINES.override', 'Allow staff to override fine amount checkout failure'); -INSERT INTO permission.perm_list VALUES (142, 'CIRC_EXCEEDS_COPY_RANGE.override', ''); -INSERT INTO permission.perm_list VALUES (143, 'ITEM_ON_HOLDS_SHELF.override', ''); -INSERT INTO permission.perm_list VALUES (144, 'COPY_NOT_AVAILABLE.override', 'Allow staff to force checkout of Missing/Lost type items'); -INSERT INTO permission.perm_list VALUES (146, 'HOLD_EXISTS.override', 'allows users to place multiple holds on a single title'); -INSERT INTO permission.perm_list VALUES (147, 'RUN_REPORTS', 'Allows a users to run reports'); -INSERT INTO permission.perm_list VALUES (148, 'SHARE_REPORT_FOLDER', 'Allows a user to share report his own folders'); -INSERT INTO permission.perm_list VALUES (149, 'VIEW_REPORT_OUTPUT', 'Allow user to view report output'); -INSERT INTO permission.perm_list VALUES (150, 'COPY_CIRC_NOT_ALLOWED.override', 'Allows a user to checkout an item that is marked as non-circ'); -INSERT INTO permission.perm_list VALUES (151, 'DELETE_CONTAINER_ITEM', 'Allows a user to delete an item out of another user''s container'); -INSERT INTO permission.perm_list VALUES (152, 'ASSIGN_WORK_ORG_UNIT', 'Allow a staff member to define where another staff member has their permissions'); - -SELECT SETVAL('permission.perm_list_id_seq'::TEXT, 152, TRUE); - - -INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) - VALUES (1, 'Users', NULL, NULL, '3 years', FALSE, 'group_application.user'); -INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) - VALUES (2, 'Patrons', 1, NULL, '3 years', TRUE, 'group_application.user.patron'); -INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) - VALUES (3, 'Staff', 1, NULL, '3 years', FALSE, 'group_application.user.staff'); -INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) - VALUES (4, 'Catalogers', 3, NULL, '3 years', TRUE, 'group_application.user.staff.cat'); -INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) - VALUES (5, 'Circulators', 3, NULL, '3 years', TRUE, 'group_application.user.staff.circ'); -INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) - VALUES (10, 'Local System Administrator', 3, 'System maintenance, configuration, etc.', '3 years', TRUE, 'group_application.user.staff.admin.local_admin'); - -SELECT SETVAL('permission.grp_tree_id_seq'::TEXT, 11); - - --- XXX Incomplete base permission setup. A patch would be appreciated. -INSERT INTO permission.grp_perm_map VALUES (57, 2, 15, 0, false); -INSERT INTO permission.grp_perm_map VALUES (109, 2, 95, 0, false); -INSERT INTO permission.grp_perm_map VALUES (1, 1, 2, 0, false); -INSERT INTO permission.grp_perm_map VALUES (12, 1, 5, 0, false); -INSERT INTO permission.grp_perm_map VALUES (13, 1, 6, 0, false); -INSERT INTO permission.grp_perm_map VALUES (51, 1, 32, 0, false); -INSERT INTO permission.grp_perm_map VALUES (111, 1, 95, 0, false); -INSERT INTO permission.grp_perm_map VALUES (11, 3, 4, 0, false); -INSERT INTO permission.grp_perm_map VALUES (14, 3, 7, 2, false); -INSERT INTO permission.grp_perm_map VALUES (16, 3, 9, 0, false); -INSERT INTO permission.grp_perm_map VALUES (19, 3, 15, 0, false); -INSERT INTO permission.grp_perm_map VALUES (20, 3, 16, 0, false); -INSERT INTO permission.grp_perm_map VALUES (21, 3, 17, 0, false); -INSERT INTO permission.grp_perm_map VALUES (116, 3, 18, 0, false); -INSERT INTO permission.grp_perm_map VALUES (117, 3, 20, 0, false); -INSERT INTO permission.grp_perm_map VALUES (118, 3, 21, 2, false); -INSERT INTO permission.grp_perm_map VALUES (119, 3, 22, 2, false); -INSERT INTO permission.grp_perm_map VALUES (120, 3, 23, 2, false); -INSERT INTO permission.grp_perm_map VALUES (121, 3, 25, 2, false); -INSERT INTO permission.grp_perm_map VALUES (26, 3, 27, 0, false); -INSERT INTO permission.grp_perm_map VALUES (27, 3, 28, 0, false); -INSERT INTO permission.grp_perm_map VALUES (28, 3, 29, 0, false); -INSERT INTO permission.grp_perm_map VALUES (29, 3, 30, 0, false); -INSERT INTO permission.grp_perm_map VALUES (44, 3, 31, 0, false); -INSERT INTO permission.grp_perm_map VALUES (31, 3, 33, 0, false); -INSERT INTO permission.grp_perm_map VALUES (32, 3, 34, 0, false); -INSERT INTO permission.grp_perm_map VALUES (33, 3, 35, 0, false); -INSERT INTO permission.grp_perm_map VALUES (41, 3, 36, 0, false); -INSERT INTO permission.grp_perm_map VALUES (45, 3, 37, 0, false); -INSERT INTO permission.grp_perm_map VALUES (46, 3, 38, 0, false); -INSERT INTO permission.grp_perm_map VALUES (47, 3, 39, 0, false); -INSERT INTO permission.grp_perm_map VALUES (122, 3, 41, 0, false); -INSERT INTO permission.grp_perm_map VALUES (123, 3, 43, 0, false); -INSERT INTO permission.grp_perm_map VALUES (60, 3, 44, 0, false); -INSERT INTO permission.grp_perm_map VALUES (110, 3, 45, 0, false); -INSERT INTO permission.grp_perm_map VALUES (124, 3, 8, 2, false); -INSERT INTO permission.grp_perm_map VALUES (125, 3, 24, 2, false); -INSERT INTO permission.grp_perm_map VALUES (126, 3, 19, 0, false); -INSERT INTO permission.grp_perm_map VALUES (61, 3, 47, 2, false); -INSERT INTO permission.grp_perm_map VALUES (95, 3, 48, 0, false); -INSERT INTO permission.grp_perm_map VALUES (17, 3, 11, 0, false); -INSERT INTO permission.grp_perm_map VALUES (62, 3, 42, 0, false); -INSERT INTO permission.grp_perm_map VALUES (63, 3, 49, 0, false); -INSERT INTO permission.grp_perm_map VALUES (64, 3, 50, 0, false); -INSERT INTO permission.grp_perm_map VALUES (127, 3, 53, 0, false); -INSERT INTO permission.grp_perm_map VALUES (65, 3, 54, 0, false); -INSERT INTO permission.grp_perm_map VALUES (128, 3, 55, 2, false); -INSERT INTO permission.grp_perm_map VALUES (67, 3, 56, 2, false); -INSERT INTO permission.grp_perm_map VALUES (68, 3, 57, 2, false); -INSERT INTO permission.grp_perm_map VALUES (69, 3, 58, 2, false); -INSERT INTO permission.grp_perm_map VALUES (70, 3, 59, 2, false); -INSERT INTO permission.grp_perm_map VALUES (71, 3, 60, 2, false); -INSERT INTO permission.grp_perm_map VALUES (72, 3, 61, 2, false); -INSERT INTO permission.grp_perm_map VALUES (73, 3, 62, 2, false); -INSERT INTO permission.grp_perm_map VALUES (74, 3, 63, 2, false); -INSERT INTO permission.grp_perm_map VALUES (81, 3, 72, 2, false); -INSERT INTO permission.grp_perm_map VALUES (82, 3, 73, 2, false); -INSERT INTO permission.grp_perm_map VALUES (83, 3, 74, 2, false); -INSERT INTO permission.grp_perm_map VALUES (84, 3, 75, 0, false); -INSERT INTO permission.grp_perm_map VALUES (85, 3, 76, 2, false); -INSERT INTO permission.grp_perm_map VALUES (86, 3, 77, 2, false); -INSERT INTO permission.grp_perm_map VALUES (89, 3, 79, 0, false); -INSERT INTO permission.grp_perm_map VALUES (90, 3, 80, 0, false); -INSERT INTO permission.grp_perm_map VALUES (91, 3, 81, 0, false); -INSERT INTO permission.grp_perm_map VALUES (92, 3, 82, 0, false); -INSERT INTO permission.grp_perm_map VALUES (98, 3, 83, 0, false); -INSERT INTO permission.grp_perm_map VALUES (115, 3, 84, 0, false); -INSERT INTO permission.grp_perm_map VALUES (100, 3, 85, 0, false); -INSERT INTO permission.grp_perm_map VALUES (101, 3, 86, 0, false); -INSERT INTO permission.grp_perm_map VALUES (102, 3, 87, 0, false); -INSERT INTO permission.grp_perm_map VALUES (103, 3, 89, 2, false); -INSERT INTO permission.grp_perm_map VALUES (104, 3, 88, 2, false); -INSERT INTO permission.grp_perm_map VALUES (108, 3, 94, 0, false); -INSERT INTO permission.grp_perm_map VALUES (112, 3, 96, 0, false); -INSERT INTO permission.grp_perm_map VALUES (113, 3, 97, 0, false); -INSERT INTO permission.grp_perm_map VALUES (130, 3, 99, 1, false); -INSERT INTO permission.grp_perm_map VALUES (131, 3, 100, 1, false); -INSERT INTO permission.grp_perm_map VALUES (22, 4, 18, 0, false); -INSERT INTO permission.grp_perm_map VALUES (24, 4, 20, 0, false); -INSERT INTO permission.grp_perm_map VALUES (38, 4, 21, 2, false); -INSERT INTO permission.grp_perm_map VALUES (34, 4, 22, 2, false); -INSERT INTO permission.grp_perm_map VALUES (39, 4, 23, 2, false); -INSERT INTO permission.grp_perm_map VALUES (35, 4, 25, 2, false); -INSERT INTO permission.grp_perm_map VALUES (129, 4, 26, 2, false); -INSERT INTO permission.grp_perm_map VALUES (15, 4, 8, 2, false); -INSERT INTO permission.grp_perm_map VALUES (40, 4, 24, 2, false); -INSERT INTO permission.grp_perm_map VALUES (23, 4, 19, 0, false); -INSERT INTO permission.grp_perm_map VALUES (66, 4, 55, 2, false); -INSERT INTO permission.grp_perm_map VALUES (134, 10, 51, 1, false); -INSERT INTO permission.grp_perm_map VALUES (75, 10, 66, 2, false); -INSERT INTO permission.grp_perm_map VALUES (76, 10, 67, 2, false); -INSERT INTO permission.grp_perm_map VALUES (77, 10, 68, 2, false); -INSERT INTO permission.grp_perm_map VALUES (78, 10, 69, 2, false); -INSERT INTO permission.grp_perm_map VALUES (79, 10, 70, 2, false); -INSERT INTO permission.grp_perm_map VALUES (80, 10, 71, 2, false); -INSERT INTO permission.grp_perm_map VALUES (87, 10, 78, 2, false); -INSERT INTO permission.grp_perm_map VALUES (105, 10, 91, 1, false); -INSERT INTO permission.grp_perm_map VALUES (106, 10, 92, 1, false); -INSERT INTO permission.grp_perm_map VALUES (107, 10, 93, 0, false); -INSERT INTO permission.grp_perm_map VALUES (114, 10, 98, 1, false); -INSERT INTO permission.grp_perm_map VALUES (132, 10, 101, 1, true); -INSERT INTO permission.grp_perm_map VALUES (136, 10, 102, 1, false); -INSERT INTO permission.grp_perm_map VALUES (137, 10, 103, 1, false); -INSERT INTO permission.grp_perm_map VALUES (97, 5, 41, 0, false); -INSERT INTO permission.grp_perm_map VALUES (96, 5, 43, 0, false); -INSERT INTO permission.grp_perm_map VALUES (93, 5, 48, 0, false); -INSERT INTO permission.grp_perm_map VALUES (94, 5, 53, 0, false); -INSERT INTO permission.grp_perm_map VALUES (133, 5, 102, 0, false); -INSERT INTO permission.grp_perm_map VALUES (138, 5, 104, 1, false); - -SELECT SETVAL('permission.grp_perm_map_id_seq'::TEXT, 139); - --- Admin user -INSERT INTO permission.usr_perm_map (usr,perm,depth) VALUES (1,-1,0); - diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql index f3637925a2..b727339303 100644 --- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql +++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql @@ -46,6 +46,4 @@ CREATE INDEX biblio_record_note_record_idx ON biblio.record_note ( record ); CREATE INDEX biblio_record_note_creator_idx ON biblio.record_note ( creator ); CREATE INDEX biblio_record_note_editor_idx ON biblio.record_note ( editor ); -INSERT INTO biblio.record_entry VALUES (-1,1,1,1,-1,NOW(),NOW(),FALSE,FALSE,'','AUTOGEN','-1','','FOO'); - COMMIT; diff --git a/Open-ILS/src/sql/Pg/040.schema.asset.sql b/Open-ILS/src/sql/Pg/040.schema.asset.sql index ecc93cd8e6..dcf57a0296 100644 --- a/Open-ILS/src/sql/Pg/040.schema.asset.sql +++ b/Open-ILS/src/sql/Pg/040.schema.asset.sql @@ -12,7 +12,6 @@ CREATE TABLE asset.copy_location ( opac_visible BOOL NOT NULL DEFAULT TRUE, circulate BOOL NOT NULL DEFAULT TRUE ); -INSERT INTO asset.copy_location (name,owning_lib) VALUES ('Stacks',1); CREATE TABLE asset.copy ( id BIGSERIAL PRIMARY KEY, @@ -134,8 +133,6 @@ CREATE INDEX asset_call_number_upper_label_id_owning_lib_idx ON asset.call_numbe CREATE UNIQUE INDEX asset_call_number_label_once_per_lib ON asset.call_number (record, owning_lib, label) WHERE deleted IS FALSE; CREATE RULE protect_cn_delete AS ON DELETE TO asset.call_number DO INSTEAD UPDATE asset.call_number SET deleted = TRUE WHERE OLD.id = asset.call_number.id; -INSERT INTO asset.call_number VALUES (-1,1,NOW(),1,NOW(),-1,1,'UNCATALOGED'); - CREATE TABLE asset.call_number_note ( id BIGSERIAL PRIMARY KEY, call_number BIGINT NOT NULL, @@ -146,7 +143,6 @@ CREATE TABLE asset.call_number_note ( value TEXT NOT NULL ); - CREATE VIEW stats.fleshed_copy AS SELECT cp.*, CAST(cp.create_date AS DATE) AS create_date_day, diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql new file mode 100644 index 0000000000..a2f04ca8ab --- /dev/null +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -0,0 +1,944 @@ +--002.schema.config.sql: +INSERT INTO config.bib_source (quality, source, transcendant) VALUES + (90, oils_i18n_gettext('oclc'), FALSE), + (10, oils_i18n_gettext('System Local'), FALSE), + (1, oils_i18n_gettext('Project Gutenberg'), TRUE); + +INSERT INTO config.standing (value) VALUES (oils_i18n_gettext('Good')); +INSERT INTO config.standing (value) VALUES (oils_i18n_gettext('Barred')); + +INSERT INTO config.xml_transform VALUES ( 'marcxml', 'http://www.loc.gov/MARC21/slim', 'marc', '---' ); +INSERT INTO config.xml_transform VALUES ( 'mods', 'http://www.loc.gov/mods/', 'mods', '/home/miker/MARC21slim2MODS.xsl' ); + +INSERT INTO config.metabib_field ( field_class, name, xpath ) VALUES + ( 'series', 'seriestitle', $$//mods:mods/mods:relatedItem[@type="series"]/mods:titleInfo$$ ), + ( 'title', 'abbreviated', $$//mods:mods/mods:titleInfo[mods:title and (@type='abbreviated')]$$ ), + ( 'title', 'translated', $$//mods:mods/mods:titleInfo[mods:title and (@type='translated')]$$ ), + ( 'title', 'uniform', $$//mods:mods/mods:titleInfo[mods:title and (@type='uniform')]$$ ), + ( 'title', 'proper', $$//mods:mods/mods:titleInfo[mods:title and not (@type)]$$ ), + ( 'author', 'corporate', $$//mods:mods/mods:name[@type='corporate']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ), + ( 'author', 'personal', $$//mods:mods/mods:name[@type='personal']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ), + ( 'author', 'conference', $$//mods:mods/mods:name[@type='conference']/mods:namePart[../mods:role/mods:text[text()='creator']]$$ ), + ( 'author', 'other', $$//mods:mods/mods:name[@type='personal']/mods:namePart[not(../mods:role)]$$ ), + ( 'subject', 'geographic', $$//mods:mods/mods:subject/mods:geographic$$ ), + ( 'subject', 'name', $$//mods:mods/mods:subject/mods:name$$ ), + ( 'subject', 'temporal', $$//mods:mods/mods:subject/mods:temporal$$ ), + ( 'subject', 'topic', $$//mods:mods/mods:subject/mods:topic$$ ), +-- ( field_class, name, xpath ) VALUES ( 'subject', 'genre', $$//mods:mods/mods:genre$$ ), + ( 'keyword', 'keyword', $$//mods:mods/*[not(local-name()='originInfo')]$$ ); -- /* to fool vim */ + +INSERT INTO config.non_cataloged_type ( owning_lib, name ) VALUES ( 1, oils_i18n_gettext('Paperback Book') ); + +INSERT INTO config.identification_type ( name ) VALUES + ( oils_i18n_gettext('Drivers License') ), + ( oils_i18n_gettext('SSN') ), + ( oils_i18n_gettext('Other') ); + +INSERT INTO config.rule_circ_duration VALUES + (DEFAULT, oils_i18n_gettext('7_days_0_renew'), '7 days', '7 days', '7 days', 0), + (DEFAULT, oils_i18n_gettext('28_days_2_renew'), '28 days', '28 days', '28 days', 2), + (DEFAULT, oils_i18n_gettext('3_months_0_renew'), '3 months', '3 months', '3 months', 0), + (DEFAULT, oils_i18n_gettext('3_days_1_renew'), '3 days', '3 days', '3 days', 1), + (DEFAULT, oils_i18n_gettext('2_months_2_renew'), '2 months', '2 months', '2 months', 2), + (DEFAULT, oils_i18n_gettext('35_days_1_renew'), '35 days', '35 days', '35 days', 1), + (DEFAULT, oils_i18n_gettext('7_days_2_renew'), '7 days', '7 days', '7 days', 2), + (DEFAULT, oils_i18n_gettext('1_hour_2_renew'), '1 hour', '1 hour', '1 hour', 2), + (DEFAULT, oils_i18n_gettext('28_days_0_renew'), '28 days', '28 days', '28 days', 0), + (DEFAULT, oils_i18n_gettext('14_days_2_renew'), '14 days', '14 days', '14 days', 2), + (DEFAULT, oils_i18n_gettext('default'), '21 days', '14 days', '7 days', 2); + +INSERT INTO config.rule_max_fine VALUES + (DEFAULT, oils_i18n_gettext('default'), 5.00), + (DEFAULT, oils_i18n_gettext('overdue_min'), 5.00), + (DEFAULT, oils_i18n_gettext('overdue_mid'), 10.00), + (DEFAULT, oils_i18n_gettext('overdue_max'), 100.00), + (DEFAULT, oils_i18n_gettext('overdue_equip_min'), 25.00), + (DEFAULT, oils_i18n_gettext('overdue_equip_mid'), 25.00), + (DEFAULT, oils_i18n_gettext('overdue_equip_max'), 100.00); + +INSERT INTO config.rule_recuring_fine VALUES + (DEFAULT, oils_i18n_gettext('default'), 0.50, 0.10, 0.05, '1 day'), + (DEFAULT, oils_i18n_gettext('10_cent_per_day'), 0.50, 0.10, 0.10, '1 day'), + (DEFAULT, oils_i18n_gettext('50_cent_per_day'), 0.50, 0.50, 0.50, '1 day'); + +INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, oils_i18n_gettext('3month'), '3 months', 0); +INSERT INTO config.rule_age_hold_protect VALUES (DEFAULT, oils_i18n_gettext('6month'), '6 months', 2); + +INSERT INTO config.copy_status (id,name,holdable) VALUES (0,oils_i18n_gettext('Available'),'t'); + +INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('Checked out'),'t'); + +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Bindery')); +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Lost')); +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Missing')); + +INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('In process'),'t'); +INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('In transit'),'t'); +INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('Reshelving'),'t'); +INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('On holds shelf'),'t'); +INSERT INTO config.copy_status (name,holdable) VALUES (oils_i18n_gettext('On order'),'t'); + +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('ILL')); +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Cataloging')); +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Reserves')); +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Discard/Weed')); +INSERT INTO config.copy_status (name) VALUES (oils_i18n_gettext('Damaged')); + +SELECT SETVAL('config.copy_status_id_seq'::TEXT, 100); + +INSERT INTO config.net_access_level (name) VALUES + (oils_i18n_gettext('Filtered')), + (oils_i18n_gettext('Unfiltered')), + (oils_i18n_gettext('No Access')); + +INSERT INTO config.audience_map (code, value, description) VALUES + ('', oils_i18n_gettext('Unknown or unspecified'), oils_i18n_gettext('The target audience for the item not known or not specified.')), + ('a', oils_i18n_gettext('Preschool'), oils_i18n_gettext('The item is intended for children, approximate ages 0-5 years.')), + ('b', oils_i18n_gettext('Primary'), oils_i18n_gettext('The item is intended for children, approximate ages 6-8 years.')), + ('c', oils_i18n_gettext('Pre-adolescent'), oils_i18n_gettext('The item is intended for young people, approximate ages 9-13 years.')), + ('d', oils_i18n_gettext('Adolescent'), oils_i18n_gettext('The item is intended for young people, approximate ages 14-17 years.')), + ('e', oils_i18n_gettext('Adult'), oils_i18n_gettext('The item is intended for adults.')), + ('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.')), + ('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.')), + ('j', oils_i18n_gettext('Juvenile'), oils_i18n_gettext('The item is intended for children and young people, approximate ages 0-15 years.')); + +INSERT INTO config.lit_form_map (code, value, description) VALUES + ('0', oils_i18n_gettext('Not fiction (not further specified)'), oils_i18n_gettext('The item is not a work of fiction and no further identification of the literary form is desired')), + ('1', oils_i18n_gettext('Fiction (not further specified)'), oils_i18n_gettext('The item is a work of fiction and no further identification of the literary form is desired')), + ('c', oils_i18n_gettext('Comic strips'), NULL), + ('d', oils_i18n_gettext('Dramas'), NULL), + ('e', oils_i18n_gettext('Essays'), NULL), + ('f', oils_i18n_gettext('Novels'), NULL), + ('h', oils_i18n_gettext('Humor, satires, etc.'), oils_i18n_gettext('The item is a humorous work, satire or of similar literary form.')), + ('i', oils_i18n_gettext('Letters'), oils_i18n_gettext('The item is a single letter or collection of correspondence.')), + ('j', oils_i18n_gettext('Short stories'), oils_i18n_gettext('The item is a short story or collection of short stories.')), + ('m', oils_i18n_gettext('Mixed forms'), oils_i18n_gettext('The item is a variety of literary forms (e.g., poetry and short stories).')), + ('p', oils_i18n_gettext('Poetry'), oils_i18n_gettext('The item is a poem or collection of poems.')), + ('s', oils_i18n_gettext('Speeches'), oils_i18n_gettext('The item is a speech or collection of speeches.')), + ('u', oils_i18n_gettext('Unknown'), oils_i18n_gettext('The literary form of the item is unknown.')); + +-- TO-DO: Auto-generate these values from CLDR +INSERT INTO config.language_map (code, value) VALUES + ('aar', oils_i18n_gettext('Afar')), + ('abk', oils_i18n_gettext('Abkhaz')), + ('ace', oils_i18n_gettext('Achinese')), + ('ach', oils_i18n_gettext('Acoli')), + ('ada', oils_i18n_gettext('Adangme')), + ('ady', oils_i18n_gettext('Adygei')), + ('afa', oils_i18n_gettext('Afroasiatic (Other)')), + ('afh', oils_i18n_gettext('Afrihili (Artificial language)')), + ('afr', oils_i18n_gettext('Afrikaans')), + ('-ajm', oils_i18n_gettext('Aljamía')), + ('aka', oils_i18n_gettext('Akan')), + ('akk', oils_i18n_gettext('Akkadian')), + ('alb', oils_i18n_gettext('Albanian')), + ('ale', oils_i18n_gettext('Aleut')), + ('alg', oils_i18n_gettext('Algonquian (Other)')), + ('amh', oils_i18n_gettext('Amharic')), + ('ang', oils_i18n_gettext('English, Old (ca. 450-1100)')), + ('apa', oils_i18n_gettext('Apache languages')), + ('ara', oils_i18n_gettext('Arabic')), + ('arc', oils_i18n_gettext('Aramaic')), + ('arg', oils_i18n_gettext('Aragonese Spanish')), + ('arm', oils_i18n_gettext('Armenian')), + ('arn', oils_i18n_gettext('Mapuche')), + ('arp', oils_i18n_gettext('Arapaho')), + ('art', oils_i18n_gettext('Artificial (Other)')), + ('arw', oils_i18n_gettext('Arawak')), + ('asm', oils_i18n_gettext('Assamese')), + ('ast', oils_i18n_gettext('Bable')), + ('ath', oils_i18n_gettext('Athapascan (Other)')), + ('aus', oils_i18n_gettext('Australian languages')), + ('ava', oils_i18n_gettext('Avaric')), + ('ave', oils_i18n_gettext('Avestan')), + ('awa', oils_i18n_gettext('Awadhi')), + ('aym', oils_i18n_gettext('Aymara')), + ('aze', oils_i18n_gettext('Azerbaijani')), + ('bad', oils_i18n_gettext('Banda')), + ('bai', oils_i18n_gettext('Bamileke languages')), + ('bak', oils_i18n_gettext('Bashkir')), + ('bal', oils_i18n_gettext('Baluchi')), + ('bam', oils_i18n_gettext('Bambara')), + ('ban', oils_i18n_gettext('Balinese')), + ('baq', oils_i18n_gettext('Basque')), + ('bas', oils_i18n_gettext('Basa')), + ('bat', oils_i18n_gettext('Baltic (Other)')), + ('bej', oils_i18n_gettext('Beja')), + ('bel', oils_i18n_gettext('Belarusian')), + ('bem', oils_i18n_gettext('Bemba')), + ('ben', oils_i18n_gettext('Bengali')), + ('ber', oils_i18n_gettext('Berber (Other)')), + ('bho', oils_i18n_gettext('Bhojpuri')), + ('bih', oils_i18n_gettext('Bihari')), + ('bik', oils_i18n_gettext('Bikol')), + ('bin', oils_i18n_gettext('Edo')), + ('bis', oils_i18n_gettext('Bislama')), + ('bla', oils_i18n_gettext('Siksika')), + ('bnt', oils_i18n_gettext('Bantu (Other)')), + ('bos', oils_i18n_gettext('Bosnian')), + ('bra', oils_i18n_gettext('Braj')), + ('bre', oils_i18n_gettext('Breton')), + ('btk', oils_i18n_gettext('Batak')), + ('bua', oils_i18n_gettext('Buriat')), + ('bug', oils_i18n_gettext('Bugis')), + ('bul', oils_i18n_gettext('Bulgarian')), + ('bur', oils_i18n_gettext('Burmese')), + ('cad', oils_i18n_gettext('Caddo')), + ('cai', oils_i18n_gettext('Central American Indian (Other)')), + ('-cam', oils_i18n_gettext('Khmer')), + ('car', oils_i18n_gettext('Carib')), + ('cat', oils_i18n_gettext('Catalan')), + ('cau', oils_i18n_gettext('Caucasian (Other)')), + ('ceb', oils_i18n_gettext('Cebuano')), + ('cel', oils_i18n_gettext('Celtic (Other)')), + ('cha', oils_i18n_gettext('Chamorro')), + ('chb', oils_i18n_gettext('Chibcha')), + ('che', oils_i18n_gettext('Chechen')), + ('chg', oils_i18n_gettext('Chagatai')), + ('chi', oils_i18n_gettext('Chinese')), + ('chk', oils_i18n_gettext('Truk')), + ('chm', oils_i18n_gettext('Mari')), + ('chn', oils_i18n_gettext('Chinook jargon')), + ('cho', oils_i18n_gettext('Choctaw')), + ('chp', oils_i18n_gettext('Chipewyan')), + ('chr', oils_i18n_gettext('Cherokee')), + ('chu', oils_i18n_gettext('Church Slavic')), + ('chv', oils_i18n_gettext('Chuvash')), + ('chy', oils_i18n_gettext('Cheyenne')), + ('cmc', oils_i18n_gettext('Chamic languages')), + ('cop', oils_i18n_gettext('Coptic')), + ('cor', oils_i18n_gettext('Cornish')), + ('cos', oils_i18n_gettext('Corsican')), + ('cpe', oils_i18n_gettext('Creoles and Pidgins, English-based (Other)')), + ('cpf', oils_i18n_gettext('Creoles and Pidgins, French-based (Other)')), + ('cpp', oils_i18n_gettext('Creoles and Pidgins, Portuguese-based (Other)')), + ('cre', oils_i18n_gettext('Cree')), + ('crh', oils_i18n_gettext('Crimean Tatar')), + ('crp', oils_i18n_gettext('Creoles and Pidgins (Other)')), + ('cus', oils_i18n_gettext('Cushitic (Other)')), + ('cze', oils_i18n_gettext('Czech')), + ('dak', oils_i18n_gettext('Dakota')), + ('dan', oils_i18n_gettext('Danish')), + ('dar', oils_i18n_gettext('Dargwa')), + ('day', oils_i18n_gettext('Dayak')), + ('del', oils_i18n_gettext('Delaware')), + ('den', oils_i18n_gettext('Slave')), + ('dgr', oils_i18n_gettext('Dogrib')), + ('din', oils_i18n_gettext('Dinka')), + ('div', oils_i18n_gettext('Divehi')), + ('doi', oils_i18n_gettext('Dogri')), + ('dra', oils_i18n_gettext('Dravidian (Other)')), + ('dua', oils_i18n_gettext('Duala')), + ('dum', oils_i18n_gettext('Dutch, Middle (ca. 1050-1350)')), + ('dut', oils_i18n_gettext('Dutch')), + ('dyu', oils_i18n_gettext('Dyula')), + ('dzo', oils_i18n_gettext('Dzongkha')), + ('efi', oils_i18n_gettext('Efik')), + ('egy', oils_i18n_gettext('Egyptian')), + ('eka', oils_i18n_gettext('Ekajuk')), + ('elx', oils_i18n_gettext('Elamite')), + ('eng', oils_i18n_gettext('English')), + ('enm', oils_i18n_gettext('English, Middle (1100-1500)')), + ('epo', oils_i18n_gettext('Esperanto')), + ('-esk', oils_i18n_gettext('Eskimo languages')), + ('-esp', oils_i18n_gettext('Esperanto')), + ('est', oils_i18n_gettext('Estonian')), + ('-eth', oils_i18n_gettext('Ethiopic')), + ('ewe', oils_i18n_gettext('Ewe')), + ('ewo', oils_i18n_gettext('Ewondo')), + ('fan', oils_i18n_gettext('Fang')), + ('fao', oils_i18n_gettext('Faroese')), + ('-far', oils_i18n_gettext('Faroese')), + ('fat', oils_i18n_gettext('Fanti')), + ('fij', oils_i18n_gettext('Fijian')), + ('fin', oils_i18n_gettext('Finnish')), + ('fiu', oils_i18n_gettext('Finno-Ugrian (Other)')), + ('fon', oils_i18n_gettext('Fon')), + ('fre', oils_i18n_gettext('French')), + ('-fri', oils_i18n_gettext('Frisian')), + ('frm', oils_i18n_gettext('French, Middle (ca. 1400-1600)')), + ('fro', oils_i18n_gettext('French, Old (ca. 842-1400)')), + ('fry', oils_i18n_gettext('Frisian')), + ('ful', oils_i18n_gettext('Fula')), + ('fur', oils_i18n_gettext('Friulian')), + ('gaa', oils_i18n_gettext('Gã')), + ('-gae', oils_i18n_gettext('Scottish Gaelic')), + ('-gag', oils_i18n_gettext('Galician')), + ('-gal', oils_i18n_gettext('Oromo')), + ('gay', oils_i18n_gettext('Gayo')), + ('gba', oils_i18n_gettext('Gbaya')), + ('gem', oils_i18n_gettext('Germanic (Other)')), + ('geo', oils_i18n_gettext('Georgian')), + ('ger', oils_i18n_gettext('German')), + ('gez', oils_i18n_gettext('Ethiopic')), + ('gil', oils_i18n_gettext('Gilbertese')), + ('gla', oils_i18n_gettext('Scottish Gaelic')), + ('gle', oils_i18n_gettext('Irish')), + ('glg', oils_i18n_gettext('Galician')), + ('glv', oils_i18n_gettext('Manx')), + ('gmh', oils_i18n_gettext('German, Middle High (ca. 1050-1500)')), + ('goh', oils_i18n_gettext('German, Old High (ca. 750-1050)')), + ('gon', oils_i18n_gettext('Gondi')), + ('gor', oils_i18n_gettext('Gorontalo')), + ('got', oils_i18n_gettext('Gothic')), + ('grb', oils_i18n_gettext('Grebo')), + ('grc', oils_i18n_gettext('Greek, Ancient (to 1453)')), + ('gre', oils_i18n_gettext('Greek, Modern (1453- )')), + ('grn', oils_i18n_gettext('Guarani')), + ('-gua', oils_i18n_gettext('Guarani')), + ('guj', oils_i18n_gettext('Gujarati')), + ('gwi', oils_i18n_gettext('Gwich''in')), + ('hai', oils_i18n_gettext('Haida')), + ('hat', oils_i18n_gettext('Haitian French Creole')), + ('hau', oils_i18n_gettext('Hausa')), + ('haw', oils_i18n_gettext('Hawaiian')), + ('heb', oils_i18n_gettext('Hebrew')), + ('her', oils_i18n_gettext('Herero')), + ('hil', oils_i18n_gettext('Hiligaynon')), + ('him', oils_i18n_gettext('Himachali')), + ('hin', oils_i18n_gettext('Hindi')), + ('hit', oils_i18n_gettext('Hittite')), + ('hmn', oils_i18n_gettext('Hmong')), + ('hmo', oils_i18n_gettext('Hiri Motu')), + ('hun', oils_i18n_gettext('Hungarian')), + ('hup', oils_i18n_gettext('Hupa')), + ('iba', oils_i18n_gettext('Iban')), + ('ibo', oils_i18n_gettext('Igbo')), + ('ice', oils_i18n_gettext('Icelandic')), + ('ido', oils_i18n_gettext('Ido')), + ('iii', oils_i18n_gettext('Sichuan Yi')), + ('ijo', oils_i18n_gettext('Ijo')), + ('iku', oils_i18n_gettext('Inuktitut')), + ('ile', oils_i18n_gettext('Interlingue')), + ('ilo', oils_i18n_gettext('Iloko')), + ('ina', oils_i18n_gettext('Interlingua (International Auxiliary Language Association)')), + ('inc', oils_i18n_gettext('Indic (Other)')), + ('ind', oils_i18n_gettext('Indonesian')), + ('ine', oils_i18n_gettext('Indo-European (Other)')), + ('inh', oils_i18n_gettext('Ingush')), + ('-int', oils_i18n_gettext('Interlingua (International Auxiliary Language Association)')), + ('ipk', oils_i18n_gettext('Inupiaq')), + ('ira', oils_i18n_gettext('Iranian (Other)')), + ('-iri', oils_i18n_gettext('Irish')), + ('iro', oils_i18n_gettext('Iroquoian (Other)')), + ('ita', oils_i18n_gettext('Italian')), + ('jav', oils_i18n_gettext('Javanese')), + ('jpn', oils_i18n_gettext('Japanese')), + ('jpr', oils_i18n_gettext('Judeo-Persian')), + ('jrb', oils_i18n_gettext('Judeo-Arabic')), + ('kaa', oils_i18n_gettext('Kara-Kalpak')), + ('kab', oils_i18n_gettext('Kabyle')), + ('kac', oils_i18n_gettext('Kachin')), + ('kal', oils_i18n_gettext('Kalâtdlisut')), + ('kam', oils_i18n_gettext('Kamba')), + ('kan', oils_i18n_gettext('Kannada')), + ('kar', oils_i18n_gettext('Karen')), + ('kas', oils_i18n_gettext('Kashmiri')), + ('kau', oils_i18n_gettext('Kanuri')), + ('kaw', oils_i18n_gettext('Kawi')), + ('kaz', oils_i18n_gettext('Kazakh')), + ('kbd', oils_i18n_gettext('Kabardian')), + ('kha', oils_i18n_gettext('Khasi')), + ('khi', oils_i18n_gettext('Khoisan (Other)')), + ('khm', oils_i18n_gettext('Khmer')), + ('kho', oils_i18n_gettext('Khotanese')), + ('kik', oils_i18n_gettext('Kikuyu')), + ('kin', oils_i18n_gettext('Kinyarwanda')), + ('kir', oils_i18n_gettext('Kyrgyz')), + ('kmb', oils_i18n_gettext('Kimbundu')), + ('kok', oils_i18n_gettext('Konkani')), + ('kom', oils_i18n_gettext('Komi')), + ('kon', oils_i18n_gettext('Kongo')), + ('kor', oils_i18n_gettext('Korean')), + ('kos', oils_i18n_gettext('Kusaie')), + ('kpe', oils_i18n_gettext('Kpelle')), + ('kro', oils_i18n_gettext('Kru')), + ('kru', oils_i18n_gettext('Kurukh')), + ('kua', oils_i18n_gettext('Kuanyama')), + ('kum', oils_i18n_gettext('Kumyk')), + ('kur', oils_i18n_gettext('Kurdish')), + ('-kus', oils_i18n_gettext('Kusaie')), + ('kut', oils_i18n_gettext('Kutenai')), + ('lad', oils_i18n_gettext('Ladino')), + ('lah', oils_i18n_gettext('Lahnda')), + ('lam', oils_i18n_gettext('Lamba')), + ('-lan', oils_i18n_gettext('Occitan (post-1500)')), + ('lao', oils_i18n_gettext('Lao')), + ('-lap', oils_i18n_gettext('Sami')), + ('lat', oils_i18n_gettext('Latin')), + ('lav', oils_i18n_gettext('Latvian')), + ('lez', oils_i18n_gettext('Lezgian')), + ('lim', oils_i18n_gettext('Limburgish')), + ('lin', oils_i18n_gettext('Lingala')), + ('lit', oils_i18n_gettext('Lithuanian')), + ('lol', oils_i18n_gettext('Mongo-Nkundu')), + ('loz', oils_i18n_gettext('Lozi')), + ('ltz', oils_i18n_gettext('Letzeburgesch')), + ('lua', oils_i18n_gettext('Luba-Lulua')), + ('lub', oils_i18n_gettext('Luba-Katanga')), + ('lug', oils_i18n_gettext('Ganda')), + ('lui', oils_i18n_gettext('Luiseño')), + ('lun', oils_i18n_gettext('Lunda')), + ('luo', oils_i18n_gettext('Luo (Kenya and Tanzania)')), + ('lus', oils_i18n_gettext('Lushai')), + ('mac', oils_i18n_gettext('Macedonian')), + ('mad', oils_i18n_gettext('Madurese')), + ('mag', oils_i18n_gettext('Magahi')), + ('mah', oils_i18n_gettext('Marshallese')), + ('mai', oils_i18n_gettext('Maithili')), + ('mak', oils_i18n_gettext('Makasar')), + ('mal', oils_i18n_gettext('Malayalam')), + ('man', oils_i18n_gettext('Mandingo')), + ('mao', oils_i18n_gettext('Maori')), + ('map', oils_i18n_gettext('Austronesian (Other)')), + ('mar', oils_i18n_gettext('Marathi')), + ('mas', oils_i18n_gettext('Masai')), + ('-max', oils_i18n_gettext('Manx')), + ('may', oils_i18n_gettext('Malay')), + ('mdr', oils_i18n_gettext('Mandar')), + ('men', oils_i18n_gettext('Mende')), + ('mga', oils_i18n_gettext('Irish, Middle (ca. 1100-1550)')), + ('mic', oils_i18n_gettext('Micmac')), + ('min', oils_i18n_gettext('Minangkabau')), + ('mis', oils_i18n_gettext('Miscellaneous languages')), + ('mkh', oils_i18n_gettext('Mon-Khmer (Other)')), + ('-mla', oils_i18n_gettext('Malagasy')), + ('mlg', oils_i18n_gettext('Malagasy')), + ('mlt', oils_i18n_gettext('Maltese')), + ('mnc', oils_i18n_gettext('Manchu')), + ('mni', oils_i18n_gettext('Manipuri')), + ('mno', oils_i18n_gettext('Manobo languages')), + ('moh', oils_i18n_gettext('Mohawk')), + ('mol', oils_i18n_gettext('Moldavian')), + ('mon', oils_i18n_gettext('Mongolian')), + ('mos', oils_i18n_gettext('Mooré')), + ('mul', oils_i18n_gettext('Multiple languages')), + ('mun', oils_i18n_gettext('Munda (Other)')), + ('mus', oils_i18n_gettext('Creek')), + ('mwr', oils_i18n_gettext('Marwari')), + ('myn', oils_i18n_gettext('Mayan languages')), + ('nah', oils_i18n_gettext('Nahuatl')), + ('nai', oils_i18n_gettext('North American Indian (Other)')), + ('nap', oils_i18n_gettext('Neapolitan Italian')), + ('nau', oils_i18n_gettext('Nauru')), + ('nav', oils_i18n_gettext('Navajo')), + ('nbl', oils_i18n_gettext('Ndebele (South Africa)')), + ('nde', oils_i18n_gettext('Ndebele (Zimbabwe) ')), + ('ndo', oils_i18n_gettext('Ndonga')), + ('nds', oils_i18n_gettext('Low German')), + ('nep', oils_i18n_gettext('Nepali')), + ('new', oils_i18n_gettext('Newari')), + ('nia', oils_i18n_gettext('Nias')), + ('nic', oils_i18n_gettext('Niger-Kordofanian (Other)')), + ('niu', oils_i18n_gettext('Niuean')), + ('nno', oils_i18n_gettext('Norwegian (Nynorsk)')), + ('nob', oils_i18n_gettext('Norwegian (Bokmål)')), + ('nog', oils_i18n_gettext('Nogai')), + ('non', oils_i18n_gettext('Old Norse')), + ('nor', oils_i18n_gettext('Norwegian')), + ('nso', oils_i18n_gettext('Northern Sotho')), + ('nub', oils_i18n_gettext('Nubian languages')), + ('nya', oils_i18n_gettext('Nyanja')), + ('nym', oils_i18n_gettext('Nyamwezi')), + ('nyn', oils_i18n_gettext('Nyankole')), + ('nyo', oils_i18n_gettext('Nyoro')), + ('nzi', oils_i18n_gettext('Nzima')), + ('oci', oils_i18n_gettext('Occitan (post-1500)')), + ('oji', oils_i18n_gettext('Ojibwa')), + ('ori', oils_i18n_gettext('Oriya')), + ('orm', oils_i18n_gettext('Oromo')), + ('osa', oils_i18n_gettext('Osage')), + ('oss', oils_i18n_gettext('Ossetic')), + ('ota', oils_i18n_gettext('Turkish, Ottoman')), + ('oto', oils_i18n_gettext('Otomian languages')), + ('paa', oils_i18n_gettext('Papuan (Other)')), + ('pag', oils_i18n_gettext('Pangasinan')), + ('pal', oils_i18n_gettext('Pahlavi')), + ('pam', oils_i18n_gettext('Pampanga')), + ('pan', oils_i18n_gettext('Panjabi')), + ('pap', oils_i18n_gettext('Papiamento')), + ('pau', oils_i18n_gettext('Palauan')), + ('peo', oils_i18n_gettext('Old Persian (ca. 600-400 B.C.)')), + ('per', oils_i18n_gettext('Persian')), + ('phi', oils_i18n_gettext('Philippine (Other)')), + ('phn', oils_i18n_gettext('Phoenician')), + ('pli', oils_i18n_gettext('Pali')), + ('pol', oils_i18n_gettext('Polish')), + ('pon', oils_i18n_gettext('Ponape')), + ('por', oils_i18n_gettext('Portuguese')), + ('pra', oils_i18n_gettext('Prakrit languages')), + ('pro', oils_i18n_gettext('Provençal (to 1500)')), + ('pus', oils_i18n_gettext('Pushto')), + ('que', oils_i18n_gettext('Quechua')), + ('raj', oils_i18n_gettext('Rajasthani')), + ('rap', oils_i18n_gettext('Rapanui')), + ('rar', oils_i18n_gettext('Rarotongan')), + ('roa', oils_i18n_gettext('Romance (Other)')), + ('roh', oils_i18n_gettext('Raeto-Romance')), + ('rom', oils_i18n_gettext('Romani')), + ('rum', oils_i18n_gettext('Romanian')), + ('run', oils_i18n_gettext('Rundi')), + ('rus', oils_i18n_gettext('Russian')), + ('sad', oils_i18n_gettext('Sandawe')), + ('sag', oils_i18n_gettext('Sango (Ubangi Creole)')), + ('sah', oils_i18n_gettext('Yakut')), + ('sai', oils_i18n_gettext('South American Indian (Other)')), + ('sal', oils_i18n_gettext('Salishan languages')), + ('sam', oils_i18n_gettext('Samaritan Aramaic')), + ('san', oils_i18n_gettext('Sanskrit')), + ('-sao', oils_i18n_gettext('Samoan')), + ('sas', oils_i18n_gettext('Sasak')), + ('sat', oils_i18n_gettext('Santali')), + ('scc', oils_i18n_gettext('Serbian')), + ('sco', oils_i18n_gettext('Scots')), + ('scr', oils_i18n_gettext('Croatian')), + ('sel', oils_i18n_gettext('Selkup')), + ('sem', oils_i18n_gettext('Semitic (Other)')), + ('sga', oils_i18n_gettext('Irish, Old (to 1100)')), + ('sgn', oils_i18n_gettext('Sign languages')), + ('shn', oils_i18n_gettext('Shan')), + ('-sho', oils_i18n_gettext('Shona')), + ('sid', oils_i18n_gettext('Sidamo')), + ('sin', oils_i18n_gettext('Sinhalese')), + ('sio', oils_i18n_gettext('Siouan (Other)')), + ('sit', oils_i18n_gettext('Sino-Tibetan (Other)')), + ('sla', oils_i18n_gettext('Slavic (Other)')), + ('slo', oils_i18n_gettext('Slovak')), + ('slv', oils_i18n_gettext('Slovenian')), + ('sma', oils_i18n_gettext('Southern Sami')), + ('sme', oils_i18n_gettext('Northern Sami')), + ('smi', oils_i18n_gettext('Sami')), + ('smj', oils_i18n_gettext('Lule Sami')), + ('smn', oils_i18n_gettext('Inari Sami')), + ('smo', oils_i18n_gettext('Samoan')), + ('sms', oils_i18n_gettext('Skolt Sami')), + ('sna', oils_i18n_gettext('Shona')), + ('snd', oils_i18n_gettext('Sindhi')), + ('-snh', oils_i18n_gettext('Sinhalese')), + ('snk', oils_i18n_gettext('Soninke')), + ('sog', oils_i18n_gettext('Sogdian')), + ('som', oils_i18n_gettext('Somali')), + ('son', oils_i18n_gettext('Songhai')), + ('sot', oils_i18n_gettext('Sotho')), + ('spa', oils_i18n_gettext('Spanish')), + ('srd', oils_i18n_gettext('Sardinian')), + ('srr', oils_i18n_gettext('Serer')), + ('ssa', oils_i18n_gettext('Nilo-Saharan (Other)')), + ('-sso', oils_i18n_gettext('Sotho')), + ('ssw', oils_i18n_gettext('Swazi')), + ('suk', oils_i18n_gettext('Sukuma')), + ('sun', oils_i18n_gettext('Sundanese')), + ('sus', oils_i18n_gettext('Susu')), + ('sux', oils_i18n_gettext('Sumerian')), + ('swa', oils_i18n_gettext('Swahili')), + ('swe', oils_i18n_gettext('Swedish')), + ('-swz', oils_i18n_gettext('Swazi')), + ('syr', oils_i18n_gettext('Syriac')), + ('-tag', oils_i18n_gettext('Tagalog')), + ('tah', oils_i18n_gettext('Tahitian')), + ('tai', oils_i18n_gettext('Tai (Other)')), + ('-taj', oils_i18n_gettext('Tajik')), + ('tam', oils_i18n_gettext('Tamil')), + ('-tar', oils_i18n_gettext('Tatar')), + ('tat', oils_i18n_gettext('Tatar')), + ('tel', oils_i18n_gettext('Telugu')), + ('tem', oils_i18n_gettext('Temne')), + ('ter', oils_i18n_gettext('Terena')), + ('tet', oils_i18n_gettext('Tetum')), + ('tgk', oils_i18n_gettext('Tajik')), + ('tgl', oils_i18n_gettext('Tagalog')), + ('tha', oils_i18n_gettext('Thai')), + ('tib', oils_i18n_gettext('Tibetan')), + ('tig', oils_i18n_gettext('Tigré')), + ('tir', oils_i18n_gettext('Tigrinya')), + ('tiv', oils_i18n_gettext('Tiv')), + ('tkl', oils_i18n_gettext('Tokelauan')), + ('tli', oils_i18n_gettext('Tlingit')), + ('tmh', oils_i18n_gettext('Tamashek')), + ('tog', oils_i18n_gettext('Tonga (Nyasa)')), + ('ton', oils_i18n_gettext('Tongan')), + ('tpi', oils_i18n_gettext('Tok Pisin')), + ('-tru', oils_i18n_gettext('Truk')), + ('tsi', oils_i18n_gettext('Tsimshian')), + ('tsn', oils_i18n_gettext('Tswana')), + ('tso', oils_i18n_gettext('Tsonga')), + ('-tsw', oils_i18n_gettext('Tswana')), + ('tuk', oils_i18n_gettext('Turkmen')), + ('tum', oils_i18n_gettext('Tumbuka')), + ('tup', oils_i18n_gettext('Tupi languages')), + ('tur', oils_i18n_gettext('Turkish')), + ('tut', oils_i18n_gettext('Altaic (Other)')), + ('tvl', oils_i18n_gettext('Tuvaluan')), + ('twi', oils_i18n_gettext('Twi')), + ('tyv', oils_i18n_gettext('Tuvinian')), + ('udm', oils_i18n_gettext('Udmurt')), + ('uga', oils_i18n_gettext('Ugaritic')), + ('uig', oils_i18n_gettext('Uighur')), + ('ukr', oils_i18n_gettext('Ukrainian')), + ('umb', oils_i18n_gettext('Umbundu')), + ('und', oils_i18n_gettext('Undetermined')), + ('urd', oils_i18n_gettext('Urdu')), + ('uzb', oils_i18n_gettext('Uzbek')), + ('vai', oils_i18n_gettext('Vai')), + ('ven', oils_i18n_gettext('Venda')), + ('vie', oils_i18n_gettext('Vietnamese')), + ('vol', oils_i18n_gettext('Volapük')), + ('vot', oils_i18n_gettext('Votic')), + ('wak', oils_i18n_gettext('Wakashan languages')), + ('wal', oils_i18n_gettext('Walamo')), + ('war', oils_i18n_gettext('Waray')), + ('was', oils_i18n_gettext('Washo')), + ('wel', oils_i18n_gettext('Welsh')), + ('wen', oils_i18n_gettext('Sorbian languages')), + ('wln', oils_i18n_gettext('Walloon')), + ('wol', oils_i18n_gettext('Wolof')), + ('xal', oils_i18n_gettext('Kalmyk')), + ('xho', oils_i18n_gettext('Xhosa')), + ('yao', oils_i18n_gettext('Yao (Africa)')), + ('yap', oils_i18n_gettext('Yapese')), + ('yid', oils_i18n_gettext('Yiddish')), + ('yor', oils_i18n_gettext('Yoruba')), + ('ypk', oils_i18n_gettext('Yupik languages')), + ('zap', oils_i18n_gettext('Zapotec')), + ('zen', oils_i18n_gettext('Zenaga')), + ('zha', oils_i18n_gettext('Zhuang')), + ('znd', oils_i18n_gettext('Zande')), + ('zul', oils_i18n_gettext('Zulu')), + ('zun', oils_i18n_gettext('Zuni')); + +INSERT INTO config.item_form_map (code, value) VALUES + ('a', oils_i18n_gettext('Microfilm')), + ('b', oils_i18n_gettext('Microfiche')), + ('c', oils_i18n_gettext('Microopaque')), + ('d', oils_i18n_gettext('Large print')), + ('f', oils_i18n_gettext('Braille')), + ('r', oils_i18n_gettext('Regular print reproduction')), + ('s', oils_i18n_gettext('Electronic')); + +INSERT INTO config.item_type_map (code, value) VALUES + ('a', oils_i18n_gettext('Language material')), + ('t', oils_i18n_gettext('Manuscript language material')), + ('g', oils_i18n_gettext('Projected medium')), + ('k', oils_i18n_gettext('Two-dimensional nonprojectable graphic')), + ('r', oils_i18n_gettext('Three-dimensional artifact or naturally occurring object')), + ('o', oils_i18n_gettext('Kit')), + ('p', oils_i18n_gettext('Mixed materials')), + ('e', oils_i18n_gettext('Cartographic material')), + ('f', oils_i18n_gettext('Manuscript cartographic material')), + ('c', oils_i18n_gettext('Notated music')), + ('d', oils_i18n_gettext('Manuscript notated music')), + ('i', oils_i18n_gettext('Nonmusical sound recording')), + ('j', oils_i18n_gettext('Musical sound recording')), + ('m', oils_i18n_gettext('Computer file')); + +--005.schema.actors.sql: + +-- Just so that there is a user... +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', oils_i18n_gettext('Administrator'), oils_i18n_gettext('System Account'), '1979-01-22', TRUE, TRUE, 1, 'identification', 1 ); + +INSERT INTO actor.card (usr, barcode) VALUES (1,'101010101010101'); + +-- The PINES levels +INSERT INTO actor.org_unit_type (name, opac_label, depth, parent, can_have_users, can_have_vols) VALUES + ( oils_i18n_gettext('Consortium'),oils_i18n_gettext('Everywhere'), 0, NULL, FALSE, FALSE ), + ( oils_i18n_gettext('System'),oils_i18n_gettext('Local Library System'), 1, 1, FALSE, FALSE ); +INSERT INTO actor.org_unit_type (name, opac_label, depth, parent) VALUES + ( oils_i18n_gettext('Branch'),oils_i18n_gettext('This Branch'), 2, 2 ), + ( oils_i18n_gettext('Sub-lib'),oils_i18n_gettext('This Specialized Library'), 3, 3 ), + ( oils_i18n_gettext('Bookmobile'),oils_i18n_gettext('Your Bookmobile'), 3, 3 ); + +INSERT INTO actor.org_unit (parent_ou, ou_type, shortname, name) VALUES + (NULL, 1, 'CONS', oils_i18n_gettext('Example Consortium')), + (1, 2, 'SYS1', oils_i18n_gettext('Example System 1')), + (1, 2, 'SYS2', oils_i18n_gettext('Example System 2')), + (2, 3, 'BR1', oils_i18n_gettext('Example Branch 1')), + (2, 3, 'BR2', oils_i18n_gettext('Example Branch 2')), + (3, 3, 'BR3', oils_i18n_gettext('Example Branch 3')), + (3, 3, 'BR4', oils_i18n_gettext('Example Branch 4')), + (4, 4, 'SL1', oils_i18n_gettext('Example Sub-lib 1')), + (6, 5, 'BM1', oils_i18n_gettext('Example Bookmobile 1')); + +INSERT INTO actor.org_address VALUES (DEFAULT,DEFAULT,DEFAULT,1,oils_i18n_gettext('123 Main St.'),NULL,oils_i18n_gettext('Anywhere'),NULL,oils_i18n_gettext('GA'),oils_i18n_gettext('US'),oils_i18n_gettext('30303')); + +UPDATE actor.org_unit SET holds_address = 1, ill_address = 1, billing_address = 1, mailing_address = 1; + +--006.data.permissions.sql: +INSERT INTO permission.perm_list VALUES + (-1, 'EVERYTHING', NULL), + (2, 'OPAC_LOGIN', NULL), + (4, 'STAFF_LOGIN', NULL), + (5, 'MR_HOLDS', NULL), + (6, 'TITLE_HOLDS', NULL), + (7, 'VOLUME_HOLDS', NULL), + (8, 'COPY_HOLDS', oils_i18n_gettext('User is allowed to place a hold on a specific copy')), + (9, 'REQUEST_HOLDS', NULL), + (10, 'REQUEST_HOLDS_OVERRIDE', NULL), + (11, 'VIEW_HOLD', oils_i18n_gettext('Allows a user to view another user''s holds')), + (13, 'DELETE_HOLDS', NULL), + (14, 'UPDATE_HOLD', oils_i18n_gettext('Allows a user to update another user''s hold')), + (15, 'RENEW_CIRC', NULL), + (16, 'VIEW_USER_FINES_SUMMARY', NULL), + (17, 'VIEW_USER_TRANSACTIONS', NULL), + (18, 'UPDATE_MARC', NULL), + (19, 'CREATE_MARC', oils_i18n_gettext('User is allowed to create new MARC records')), + (20, 'IMPORT_MARC', NULL), + (21, 'CREATE_VOLUME', NULL), + (22, 'UPDATE_VOLUME', NULL), + (23, 'DELETE_VOLUME', NULL), + (25, 'UPDATE_COPY', NULL), + (26, 'DELETE_COPY', NULL), + (27, 'RENEW_HOLD_OVERRIDE', NULL), + (28, 'CREATE_USER', NULL), + (29, 'UPDATE_USER', NULL), + (30, 'DELETE_USER', NULL), + (31, 'VIEW_USER', NULL), + (32, 'COPY_CHECKIN', NULL), + (33, 'CREATE_TRANSIT', NULL), + (34, 'VIEW_PERMISSION', NULL), + (35, 'CHECKIN_BYPASS_HOLD_FULFILL', NULL), + (36, 'CREATE_PAYMENT', NULL), + (37, 'SET_CIRC_LOST', NULL), + (38, 'SET_CIRC_MISSING', NULL), + (39, 'SET_CIRC_CLAIMS_RETURNED', NULL), + (41, 'CREATE_TRANSACTION', oils_i18n_gettext('User may create new billable transactions')), + (43, 'CREATE_BILL', oils_i18n_gettext('Allows a user to create a new bill on a transaction')), + (44, 'VIEW_CONTAINER', oils_i18n_gettext('Allows a user to view another user')'s containers (buckets)'), + (45, 'CREATE_CONTAINER', oils_i18n_gettext('Allows a user to create a new container for another user')), + (24, 'CREATE_COPY', oils_i18n_gettext('User is allowed to create a new copy object')), + (47, 'UPDATE_ORG_UNIT', oils_i18n_gettext('Allows a user to change org unit settings')), + (48, 'VIEW_CIRCULATIONS', oils_i18n_gettext('Allows a user to see what another use has checked out')), + (42, 'VIEW_TRANSACTION', oils_i18n_gettext('User may view another user')'s transactions'), + (49, 'DELETE_CONTAINER', oils_i18n_gettext('Allows a user to delete another user container')), + (50, 'CREATE_CONTAINER_ITEM', oils_i18n_gettext('Create a container item for another user')), + (51, 'CREATE_USER_GROUP_LINK', oils_i18n_gettext('User can add other users to permission groups')), + (52, 'REMOVE_USER_GROUP_LINK', oils_i18n_gettext('User can remove other users from permission groups')), + (53, 'VIEW_PERM_GROUPS', oils_i18n_gettext('Allow user to view others')' permission groups'), + (54, 'VIEW_PERMIT_CHECKOUT', oils_i18n_gettext('Allows a user to determine of another user can checkout an item')), + (55, 'UPDATE_BATCH_COPY', oils_i18n_gettext('Allows a user to edit copies in batch')), + (56, 'CREATE_PATRON_STAT_CAT', oils_i18n_gettext('User may create a new patron statistical category')), + (57, 'CREATE_COPY_STAT_CAT', oils_i18n_gettext('User may create a copy stat cat')), + (58, 'CREATE_PATRON_STAT_CAT_ENTRY', oils_i18n_gettext('User may create a new patron stat cat entry')), + (59, 'CREATE_COPY_STAT_CAT_ENTRY', oils_i18n_gettext('User may create a new copy stat cat entry')), + (60, 'UPDATE_PATRON_STAT_CAT', oils_i18n_gettext('User may update a patron stat cat')), + (61, 'UPDATE_COPY_STAT_CAT', oils_i18n_gettext('User may update a copy stat cat')), + (62, 'UPDATE_PATRON_STAT_CAT_ENTRY', oils_i18n_gettext('User may update a patron stat cat entry')), + (63, 'UPDATE_COPY_STAT_CAT_ENTRY', oils_i18n_gettext('User may update a copy stat cat entry')), + (65, 'CREATE_COPY_STAT_CAT_ENTRY_MAP', oils_i18n_gettext('User may link a copy to a stat cat entry')), + (64, 'CREATE_PATRON_STAT_CAT_ENTRY_MAP', oils_i18n_gettext('User may link another user to a stat cat entry')), + (66, 'DELETE_PATRON_STAT_CAT', oils_i18n_gettext('User may delete a patron stat cat')), + (67, 'DELETE_COPY_STAT_CAT', oils_i18n_gettext('User may delete a copy stat cat')), + (68, 'DELETE_PATRON_STAT_CAT_ENTRY', oils_i18n_gettext('User may delete a patron stat cat entry')), + (69, 'DELETE_COPY_STAT_CAT_ENTRY', oils_i18n_gettext('User may delete a copy stat cat entry')), + (70, 'DELETE_PATRON_STAT_CAT_ENTRY_MAP', oils_i18n_gettext('User may delete a patron stat cat entry map')), + (71, 'DELETE_COPY_STAT_CAT_ENTRY_MAP', oils_i18n_gettext('User may delete a copy stat cat entry map')), + (72, 'CREATE_NON_CAT_TYPE', oils_i18n_gettext('Allows a user to create a new non-cataloged item type')), + (73, 'UPDATE_NON_CAT_TYPE', oils_i18n_gettext('Allows a user to update a non cataloged type')), + (74, 'CREATE_IN_HOUSE_USE', oils_i18n_gettext('Allows a user to create a new in-house-use ')), + (75, 'COPY_CHECKOUT', oils_i18n_gettext('Allows a user to check out a copy')), + (76, 'CREATE_COPY_LOCATION', oils_i18n_gettext('Allows a user to create a new copy location')), + (77, 'UPDATE_COPY_LOCATION', oils_i18n_gettext('Allows a user to update a copy location')), + (78, 'DELETE_COPY_LOCATION', oils_i18n_gettext('Allows a user to delete a copy location')), + (79, 'CREATE_COPY_TRANSIT', oils_i18n_gettext('Allows a user to create a transit_copy object for transiting a copy')), + (80, 'COPY_TRANSIT_RECEIVE', oils_i18n_gettext('Allows a user to close out a transit on a copy')), + (81, 'VIEW_HOLD_PERMIT', oils_i18n_gettext('Allows a user to see if another user has permission to place a hold on a given copy')), + (82, 'VIEW_COPY_CHECKOUT_HISTORY', oils_i18n_gettext('Allows a user to view which users have checked out a given copy')), + (83, 'REMOTE_Z3950_QUERY', oils_i18n_gettext('Allows a user to perform z3950 queries against remote servers')), + (84, 'REGISTER_WORKSTATION', oils_i18n_gettext('Allows a user to register a new workstation')), + (85, 'VIEW_COPY_NOTES', oils_i18n_gettext('Allows a user to view all notes attached to a copy')), + (86, 'VIEW_VOLUME_NOTES', oils_i18n_gettext('Allows a user to view all notes attached to a volume')), + (87, 'VIEW_TITLE_NOTES', oils_i18n_gettext('Allows a user to view all notes attached to a title')), + (89, 'CREATE_VOLUME_NOTE', oils_i18n_gettext('Allows a user to create a new volume note')), + (88, 'CREATE_COPY_NOTE', oils_i18n_gettext('Allows a user to create a new copy note')), + (90, 'CREATE_TITLE_NOTE', oils_i18n_gettext('Allows a user to create a new title note')), + (91, 'DELETE_COPY_NOTE', oils_i18n_gettext('Allows a user to delete someone elses copy notes')), + (92, 'DELETE_VOLUME_NOTE', oils_i18n_gettext('Allows a user to delete someone elses volume note')), + (93, 'DELETE_TITLE_NOTE', oils_i18n_gettext('Allows a user to delete someone elses title note')), + (94, 'UPDATE_CONTAINER', oils_i18n_gettext('Allows a user to update another users container')), + (95, 'CREATE_MY_CONTAINER', oils_i18n_gettext('Allows a user to create a container for themselves')), + (96, 'VIEW_HOLD_NOTIFICATION', oils_i18n_gettext('Allows a user to view notifications attached to a hold')), + (97, 'CREATE_HOLD_NOTIFICATION', oils_i18n_gettext('Allows a user to create new hold notifications')), + (98, 'UPDATE_ORG_SETTING', oils_i18n_gettext('Allows a user to update an org unit setting')), + (99, 'OFFLINE_UPLOAD', oils_i18n_gettext('Allows a user to upload an offline script')), + (100, 'OFFLINE_VIEW', oils_i18n_gettext('Allows a user to view uploaded offline script information')), + (101, 'OFFLINE_EXECUTE', oils_i18n_gettext('Allows a user to execute an offline script batch')), + (102, 'CIRC_OVERRIDE_DUE_DATE', oils_i18n_gettext('Allows a user to change set the due date on an item to any date')), + (103, 'CIRC_PERMIT_OVERRIDE', oils_i18n_gettext('Allows a user to bypass the circ permit call for checkout')), + (104, 'COPY_IS_REFERENCE.override', oils_i18n_gettext('Allows a user to override the copy_is_reference event')), + (105, 'VOID_BILLING', oils_i18n_gettext('Allows a user to void a bill')), + (106, 'CIRC_CLAIMS_RETURNED.override', oils_i18n_gettext('Allows a person to check in/out an item that is claims returned')), + (107, 'COPY_BAD_STATUS.override', oils_i18n_gettext('Allows a user to check out an item in a non-circulatable status')), + (108, 'COPY_ALERT_MESSAGE.override', oils_i18n_gettext('Allows a user to check in/out an item that has an alert message')), + (109, 'COPY_STATUS_LOST.override', oils_i18n_gettext('Allows a user to remove the lost status from a copy')), + (110, 'COPY_STATUS_MISSING.override', oils_i18n_gettext('Allows a user to change the missing status on a copy')), + (111, 'ABORT_TRANSIT', oils_i18n_gettext('Allows a user to abort a copy transit if the user is at the transit destination or source')), + (112, 'ABORT_REMOTE_TRANIST', oils_i18n_gettext('Allows a user to abort a copy transit if the user is not at the transit source or dest')), + (113, 'VIEW_ZIP_DATA', oils_i18n_gettext('Allowsa user to query the zip code data method')), + (114, 'CANCEL_HOLDS', oils_i18n_gettext('')), + (115, 'CREATE_DUPLICATE_HOLDS', oils_i18n_gettext('Allows a user to create duplicate holds (e.g. two holds on the same title)')), + (117, 'actor.org_unit.closed_date.update', oils_i18n_gettext('Allows a user to update a closed date interval for a given location')), + (116, 'actor.org_unit.closed_date.delete', oils_i18n_gettext('Allows a user to remove a closed date interval for a given location')), + (118, 'actor.org_unit.closed_date.create', oils_i18n_gettext('Allows a user to create a new closed date for a location')), + (119, 'DELETE_NON_CAT_TYPE', oils_i18n_gettext('Allows a user to delete a non cataloged type')), + (120, 'money.collections_tracker.create', oils_i18n_gettext('Allows a user to put someone into collections')), + (121, 'money.collections_tracker.delete', oils_i18n_gettext('Allows a user to remove someone from collections')), + (122, 'BAR_PATRON', oils_i18n_gettext('Allows a user to bar a patron')), + (123, 'UNBAR_PATRON', oils_i18n_gettext('Allows a user to un-bar a patron')), + (124, 'DELETE_WORKSTATION', oils_i18n_gettext('Allows a user to remove an existing workstation so a new one can replace it')), + (125, 'group_application.user', oils_i18n_gettext('Allows a user to add/remove users to/from the "User" group')), + (126, 'group_application.user.patron', oils_i18n_gettext('Allows a user to add/remove users to/from the "Patron" group')), + (127, 'group_application.user.staff', oils_i18n_gettext('Allows a user to add/remove users to/from the "Staff" group')), + (128, 'group_application.user.staff.circ', oils_i18n_gettext('Allows a user to add/remove users to/from the "Circulator" group')), + (129, 'group_application.user.staff.cat', oils_i18n_gettext('Allows a user to add/remove users to/from the "Cataloger" group')), + (130, 'group_application.user.staff.admin.global_admin', oils_i18n_gettext('Allows a user to add/remove users to/from the "GlobalAdmin" group')), + (131, 'group_application.user.staff.admin.local_admin', oils_i18n_gettext('Allows a user to add/remove users to/from the "LocalAdmin" group')), + (132, 'group_application.user.staff.admin.lib_manager', oils_i18n_gettext('Allows a user to add/remove users to/from the "LibraryManager" group')), + (133, 'group_application.user.staff.cat.cat1', oils_i18n_gettext('Allows a user to add/remove users to/from the "Cat1" group')), + (134, 'group_application.user.staff.supercat', oils_i18n_gettext('Allows a user to add/remove users to/from the "Supercat" group')), + (135, 'group_application.user.sip_client', oils_i18n_gettext('Allows a user to add/remove users to/from the "SIP-Client" group')), + (136, 'group_application.user.vendor', oils_i18n_gettext('Allows a user to add/remove users to/from the "Vendor" group')), + (137, 'ITEM_AGE_PROTECTED.override', oils_i18n_gettext('Allows a user to place a hold on an age-protected item')), + (138, 'MAX_RENEWALS_REACHED.override', oils_i18n_gettext('Allows a user to renew an item past the maximun renewal count')), + (139, 'PATRON_EXCEEDS_CHECKOUT_COUNT.override', oils_i18n_gettext('Allow staff to override checkout count failure')), + (140, 'PATRON_EXCEEDS_OVERDUE_COUNT.override', oils_i18n_gettext('Allow staff to override overdue count failure')), + (141, 'PATRON_EXCEEDS_FINES.override', oils_i18n_gettext('Allow staff to override fine amount checkout failure')), + (142, 'CIRC_EXCEEDS_COPY_RANGE.override', oils_i18n_gettext('')), + (143, 'ITEM_ON_HOLDS_SHELF.override', oils_i18n_gettext('')), + (144, 'COPY_NOT_AVAILABLE.override', oils_i18n_gettext('Allow staff to force checkout of Missing/Lost type items')), + (146, 'HOLD_EXISTS.override', oils_i18n_gettext('allows users to place multiple holds on a single title')), + (147, 'RUN_REPORTS', oils_i18n_gettext('Allows a users to run reports')), + (148, 'SHARE_REPORT_FOLDER', oils_i18n_gettext('Allows a user to share report his own folders')), + (149, 'VIEW_REPORT_OUTPUT', oils_i18n_gettext('Allow user to view report output')), + (150, 'COPY_CIRC_NOT_ALLOWED.override', oils_i18n_gettext('Allows a user to checkout an item that is marked as non-circ')), + (151, 'DELETE_CONTAINER_ITEM', oils_i18n_gettext('Allows a user to delete an item out of another user''s container')), + (152, 'ASSIGN_WORK_ORG_UNIT', oils_i18n_gettext('Allow a staff member to define where another staff member has their permissions')); + +INSERT INTO permission.grp_tree (id, name, parent, description, perm_interval, usergroup, application_perm) VALUES + (1, 'Users', NULL, NULL, '3 years', FALSE, 'group_application.user'), + (2, 'Patrons', 1, NULL, '3 years', TRUE, 'group_application.user.patron'), + (3, 'Staff', 1, NULL, '3 years', FALSE, 'group_application.user.staff'), + (4, 'Catalogers', 3, NULL, '3 years', TRUE, 'group_application.user.staff.cat'), + (5, 'Circulators', 3, NULL, '3 years', TRUE, 'group_application.user.staff.circ'), + (10, 'Local System Administrator', 3, 'System maintenance, configuration, etc.', '3 years', TRUE, 'group_application.user.staff.admin.local_admin'); + + +-- XXX Incomplete base permission setup. A patch would be appreciated. +INSERT INTO permission.grp_perm_map VALUES + (57, 2, 15, 0, false), + (109, 2, 95, 0, false), + (1, 1, 2, 0, false), + (12, 1, 5, 0, false), + (13, 1, 6, 0, false), + (51, 1, 32, 0, false), + (111, 1, 95, 0, false), + (11, 3, 4, 0, false), + (14, 3, 7, 2, false), + (16, 3, 9, 0, false), + (19, 3, 15, 0, false), + (20, 3, 16, 0, false), + (21, 3, 17, 0, false), + (116, 3, 18, 0, false), + (117, 3, 20, 0, false), + (118, 3, 21, 2, false), + (119, 3, 22, 2, false), + (120, 3, 23, 2, false), + (121, 3, 25, 2, false), + (26, 3, 27, 0, false), + (27, 3, 28, 0, false), + (28, 3, 29, 0, false), + (29, 3, 30, 0, false), + (44, 3, 31, 0, false), + (31, 3, 33, 0, false), + (32, 3, 34, 0, false), + (33, 3, 35, 0, false), + (41, 3, 36, 0, false), + (45, 3, 37, 0, false), + (46, 3, 38, 0, false), + (47, 3, 39, 0, false), + (122, 3, 41, 0, false), + (123, 3, 43, 0, false), + (60, 3, 44, 0, false), + (110, 3, 45, 0, false), + (124, 3, 8, 2, false), + (125, 3, 24, 2, false), + (126, 3, 19, 0, false), + (61, 3, 47, 2, false), + (95, 3, 48, 0, false), + (17, 3, 11, 0, false), + (62, 3, 42, 0, false), + (63, 3, 49, 0, false), + (64, 3, 50, 0, false), + (127, 3, 53, 0, false), + (65, 3, 54, 0, false), + (128, 3, 55, 2, false), + (67, 3, 56, 2, false), + (68, 3, 57, 2, false), + (69, 3, 58, 2, false), + (70, 3, 59, 2, false), + (71, 3, 60, 2, false), + (72, 3, 61, 2, false), + (73, 3, 62, 2, false), + (74, 3, 63, 2, false), + (81, 3, 72, 2, false), + (82, 3, 73, 2, false), + (83, 3, 74, 2, false), + (84, 3, 75, 0, false), + (85, 3, 76, 2, false), + (86, 3, 77, 2, false), + (89, 3, 79, 0, false), + (90, 3, 80, 0, false), + (91, 3, 81, 0, false), + (92, 3, 82, 0, false), + (98, 3, 83, 0, false), + (115, 3, 84, 0, false), + (100, 3, 85, 0, false), + (101, 3, 86, 0, false), + (102, 3, 87, 0, false), + (103, 3, 89, 2, false), + (104, 3, 88, 2, false), + (108, 3, 94, 0, false), + (112, 3, 96, 0, false), + (113, 3, 97, 0, false), + (130, 3, 99, 1, false), + (131, 3, 100, 1, false), + (22, 4, 18, 0, false), + (24, 4, 20, 0, false), + (38, 4, 21, 2, false), + (34, 4, 22, 2, false), + (39, 4, 23, 2, false), + (35, 4, 25, 2, false), + (129, 4, 26, 2, false), + (15, 4, 8, 2, false), + (40, 4, 24, 2, false), + (23, 4, 19, 0, false), + (66, 4, 55, 2, false), + (134, 10, 51, 1, false), + (75, 10, 66, 2, false), + (76, 10, 67, 2, false), + (77, 10, 68, 2, false), + (78, 10, 69, 2, false), + (79, 10, 70, 2, false), + (80, 10, 71, 2, false), + (87, 10, 78, 2, false), + (105, 10, 91, 1, false), + (106, 10, 92, 1, false), + (107, 10, 93, 0, false), + (114, 10, 98, 1, false), + (132, 10, 101, 1, true), + (136, 10, 102, 1, false), + (137, 10, 103, 1, false), + (97, 5, 41, 0, false), + (96, 5, 43, 0, false), + (93, 5, 48, 0, false), + (94, 5, 53, 0, false), + (133, 5, 102, 0, false), + (138, 5, 104, 1, false); + +-- Admin user +INSERT INTO permission.usr_perm_map (usr,perm,depth) VALUES (1,-1,0); + +--010.schema.biblio.sql: +INSERT INTO biblio.record_entry VALUES (-1,1,1,1,-1,NOW(),NOW(),FALSE,FALSE,'','AUTOGEN','-1','','FOO'); + +--040.schema.asset.sql: +INSERT INTO asset.copy_location (name,owning_lib) VALUES (oils_i18n_gettext('Stacks'),1); +INSERT INTO asset.call_number VALUES (-1,1,NOW(),1,NOW(),-1,1,'UNCATALOGED'); diff --git a/Open-ILS/src/sql/Pg/build-db.sh b/Open-ILS/src/sql/Pg/build-db.sh index 2c83e98830..7d328baa88 100755 --- a/Open-ILS/src/sql/Pg/build-db.sh +++ b/Open-ILS/src/sql/Pg/build-db.sh @@ -9,7 +9,6 @@ PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 002.schema.con PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 002.functions.config.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 005.schema.actors.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 006.schema.permissions.sql -PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 006.data.permissions.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 010.schema.biblio.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 011.schema.authority.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 020.schema.functions.sql @@ -24,5 +23,6 @@ PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 500.view.cross PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 800.fkeys.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 900.audit-functions.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 901.audit-tables.sql +PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f 950.data.seed-values.sql PGPASSWORD=$5 PGUSER=$4 PGHOST=$1 PGPORT=$2 PGDATABASE=$3 psql -f reporter-schema.sql diff --git a/build/i18n/Makefile b/build/i18n/Makefile index 0c154c4cc5..3f918de390 100644 --- a/build/i18n/Makefile +++ b/build/i18n/Makefile @@ -22,7 +22,7 @@ PROGRESS=--progress none newpo: dtds2po props2po @echo "Generated new PO files for locale $(LOCALE)" -newpot: dtds2pot props2pot +newpot: dtds2pot props2pot sql2pot @echo "Generated new POT files" newproject: po2dtds po2props @@ -53,6 +53,9 @@ po2dtds: po2props: @po2moz $(PROGRESS) -o locale/$(LOCALE) -t $(PROPSDIR)/en-US/ -i $(POINDIR)/$(LOCALE) 2>&1 +sql2pot: + @scripts/db-seed-i18n.py + update_moz_dtds: @po2moz $(PROGRESS) -o locale/$(LOCALE) -t $(DTDDIR)/en-US/ -i $(POINDIR)/$(LOCALE) 2>&1 diff --git a/build/i18n/po/db.seed.pot b/build/i18n/po/db.seed.pot new file mode 100644 index 0000000000..09ac3bdcc9 --- /dev/null +++ b/build/i18n/po/db.seed.pot @@ -0,0 +1,2844 @@ +# +msgid "" +msgstr "" +"Project-Id-Version: Evergreen 1.4" +"Report-Msgid-Bugs-To: open-ils-dev@list.georgialibraries.org" +"POT-Creation-Date: 2007-12-04 02:50:56 -0400" +"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE" +"Last-Translator: FULL NAME " +"Language-Team: LANGUAGE " +"MIME-Version: 1.0" +"Content-Type: text/plain; charset=utf-8" +"Content-Transfer-Encoding: 8-bit" + +#: config.bib_source:3 +msgid "oclc" +msgstr "" + +#: config.bib_source:4 +msgid "System Local" +msgstr "" + +#: config.bib_source:5 +msgid "Project Gutenberg" +msgstr "" + +#: config.standing:7 +msgid "Good" +msgstr "" + +#: config.standing:8 +msgid "Barred" +msgstr "" + +#: config.non_cataloged_type:30 +msgid "Paperback Book" +msgstr "" + +#: config.identification_type:33 +msgid "Drivers License" +msgstr "" + +#: config.identification_type:34 +msgid "SSN" +msgstr "" + +#: config.identification_type:35 +msgid "Other" +msgstr "" + +#: config.rule_circ_duration:38 +msgid "7_days_0_renew" +msgstr "" + +#: config.rule_circ_duration:39 +msgid "28_days_2_renew" +msgstr "" + +#: config.rule_circ_duration:40 +msgid "3_months_0_renew" +msgstr "" + +#: config.rule_circ_duration:41 +msgid "3_days_1_renew" +msgstr "" + +#: config.rule_circ_duration:42 +msgid "2_months_2_renew" +msgstr "" + +#: config.rule_circ_duration:43 +msgid "35_days_1_renew" +msgstr "" + +#: config.rule_circ_duration:44 +msgid "7_days_2_renew" +msgstr "" + +#: config.rule_circ_duration:45 +msgid "1_hour_2_renew" +msgstr "" + +#: config.rule_circ_duration:46 +msgid "28_days_0_renew" +msgstr "" + +#: config.rule_circ_duration:47 +msgid "14_days_2_renew" +msgstr "" + +#: config.rule_circ_duration:48 +msgid "default" +msgstr "" + +#: config.rule_max_fine:51 +msgid "default" +msgstr "" + +#: config.rule_max_fine:52 +msgid "overdue_min" +msgstr "" + +#: config.rule_max_fine:53 +msgid "overdue_mid" +msgstr "" + +#: config.rule_max_fine:54 +msgid "overdue_max" +msgstr "" + +#: config.rule_max_fine:55 +msgid "overdue_equip_min" +msgstr "" + +#: config.rule_max_fine:56 +msgid "overdue_equip_mid" +msgstr "" + +#: config.rule_max_fine:57 +msgid "overdue_equip_max" +msgstr "" + +#: config.rule_recuring_fine:60 +msgid "default" +msgstr "" + +#: config.rule_recuring_fine:61 +msgid "10_cent_per_day" +msgstr "" + +#: config.rule_recuring_fine:62 +msgid "50_cent_per_day" +msgstr "" + +#: config.rule_age_hold_protect:64 +msgid "3month" +msgstr "" + +#: config.rule_age_hold_protect:65 +msgid "6month" +msgstr "" + +#: config.copy_status:67 +msgid "Available" +msgstr "" + +#: config.copy_status:69 +msgid "Checked out" +msgstr "" + +#: config.copy_status:71 +msgid "Bindery" +msgstr "" + +#: config.copy_status:72 +msgid "Lost" +msgstr "" + +#: config.copy_status:73 +msgid "Missing" +msgstr "" + +#: config.copy_status:75 +msgid "In process" +msgstr "" + +#: config.copy_status:76 +msgid "In transit" +msgstr "" + +#: config.copy_status:77 +msgid "Reshelving" +msgstr "" + +#: config.copy_status:78 +msgid "On holds shelf" +msgstr "" + +#: config.copy_status:79 +msgid "On order" +msgstr "" + +#: config.copy_status:81 +msgid "ILL" +msgstr "" + +#: config.copy_status:82 +msgid "Cataloging" +msgstr "" + +#: config.copy_status:83 +msgid "Reserves" +msgstr "" + +#: config.copy_status:84 +msgid "Discard/Weed" +msgstr "" + +#: config.copy_status:85 +msgid "Damaged" +msgstr "" + +#: config.net_access_level:90 +msgid "Filtered" +msgstr "" + +#: config.net_access_level:91 +msgid "Unfiltered" +msgstr "" + +#: config.net_access_level:92 +msgid "No Access" +msgstr "" + +#: config.audience_map:95 +msgid "Unknown or unspecified" +msgstr "" + +#: config.audience_map:96 +msgid "Preschool" +msgstr "" + +#: config.audience_map:97 +msgid "Primary" +msgstr "" + +#: config.audience_map:98 +msgid "Pre-adolescent" +msgstr "" + +#: config.audience_map:99 +msgid "Adolescent" +msgstr "" + +#: config.audience_map:100 +msgid "Adult" +msgstr "" + +#: config.audience_map:101 +msgid "Specialized" +msgstr "" + +#: config.audience_map:102 +msgid "General" +msgstr "" + +#: config.audience_map:103 +msgid "Juvenile" +msgstr "" + +#: config.lit_form_map:106 +msgid "Not fiction (not further specified)" +msgstr "" + +#: config.lit_form_map:107 +msgid "Fiction (not further specified)" +msgstr "" + +#: config.lit_form_map:108 +msgid "Comic strips" +msgstr "" + +#: config.lit_form_map:109 +msgid "Dramas" +msgstr "" + +#: config.lit_form_map:110 +msgid "Essays" +msgstr "" + +#: config.lit_form_map:111 +msgid "Novels" +msgstr "" + +#: config.lit_form_map:112 +msgid "Humor, satires, etc." +msgstr "" + +#: config.lit_form_map:113 +msgid "Letters" +msgstr "" + +#: config.lit_form_map:114 +msgid "Short stories" +msgstr "" + +#: config.lit_form_map:115 +msgid "Mixed forms" +msgstr "" + +#: config.lit_form_map:116 +msgid "Poetry" +msgstr "" + +#: config.lit_form_map:117 +msgid "Speeches" +msgstr "" + +#: config.lit_form_map:118 +msgid "Unknown" +msgstr "" + +#: config.language_map:122 +msgid "Afar" +msgstr "" + +#: config.language_map:123 +msgid "Abkhaz" +msgstr "" + +#: config.language_map:124 +msgid "Achinese" +msgstr "" + +#: config.language_map:125 +msgid "Acoli" +msgstr "" + +#: config.language_map:126 +msgid "Adangme" +msgstr "" + +#: config.language_map:127 +msgid "Adygei" +msgstr "" + +#: config.language_map:128 +msgid "Afroasiatic (Other)" +msgstr "" + +#: config.language_map:129 +msgid "Afrihili (Artificial language)" +msgstr "" + +#: config.language_map:130 +msgid "Afrikaans" +msgstr "" + +#: config.language_map:131 +msgid "Aljamía" +msgstr "" + +#: config.language_map:132 +msgid "Akan" +msgstr "" + +#: config.language_map:133 +msgid "Akkadian" +msgstr "" + +#: config.language_map:134 +msgid "Albanian" +msgstr "" + +#: config.language_map:135 +msgid "Aleut" +msgstr "" + +#: config.language_map:136 +msgid "Algonquian (Other)" +msgstr "" + +#: config.language_map:137 +msgid "Amharic" +msgstr "" + +#: config.language_map:138 +msgid "English, Old (ca. 450-1100)" +msgstr "" + +#: config.language_map:139 +msgid "Apache languages" +msgstr "" + +#: config.language_map:140 +msgid "Arabic" +msgstr "" + +#: config.language_map:141 +msgid "Aramaic" +msgstr "" + +#: config.language_map:142 +msgid "Aragonese Spanish" +msgstr "" + +#: config.language_map:143 +msgid "Armenian" +msgstr "" + +#: config.language_map:144 +msgid "Mapuche" +msgstr "" + +#: config.language_map:145 +msgid "Arapaho" +msgstr "" + +#: config.language_map:146 +msgid "Artificial (Other)" +msgstr "" + +#: config.language_map:147 +msgid "Arawak" +msgstr "" + +#: config.language_map:148 +msgid "Assamese" +msgstr "" + +#: config.language_map:149 +msgid "Bable" +msgstr "" + +#: config.language_map:150 +msgid "Athapascan (Other)" +msgstr "" + +#: config.language_map:151 +msgid "Australian languages" +msgstr "" + +#: config.language_map:152 +msgid "Avaric" +msgstr "" + +#: config.language_map:153 +msgid "Avestan" +msgstr "" + +#: config.language_map:154 +msgid "Awadhi" +msgstr "" + +#: config.language_map:155 +msgid "Aymara" +msgstr "" + +#: config.language_map:156 +msgid "Azerbaijani" +msgstr "" + +#: config.language_map:157 +msgid "Banda" +msgstr "" + +#: config.language_map:158 +msgid "Bamileke languages" +msgstr "" + +#: config.language_map:159 +msgid "Bashkir" +msgstr "" + +#: config.language_map:160 +msgid "Baluchi" +msgstr "" + +#: config.language_map:161 +msgid "Bambara" +msgstr "" + +#: config.language_map:162 +msgid "Balinese" +msgstr "" + +#: config.language_map:163 +msgid "Basque" +msgstr "" + +#: config.language_map:164 +msgid "Basa" +msgstr "" + +#: config.language_map:165 +msgid "Baltic (Other)" +msgstr "" + +#: config.language_map:166 +msgid "Beja" +msgstr "" + +#: config.language_map:167 +msgid "Belarusian" +msgstr "" + +#: config.language_map:168 +msgid "Bemba" +msgstr "" + +#: config.language_map:169 +msgid "Bengali" +msgstr "" + +#: config.language_map:170 +msgid "Berber (Other)" +msgstr "" + +#: config.language_map:171 +msgid "Bhojpuri" +msgstr "" + +#: config.language_map:172 +msgid "Bihari" +msgstr "" + +#: config.language_map:173 +msgid "Bikol" +msgstr "" + +#: config.language_map:174 +msgid "Edo" +msgstr "" + +#: config.language_map:175 +msgid "Bislama" +msgstr "" + +#: config.language_map:176 +msgid "Siksika" +msgstr "" + +#: config.language_map:177 +msgid "Bantu (Other)" +msgstr "" + +#: config.language_map:178 +msgid "Bosnian" +msgstr "" + +#: config.language_map:179 +msgid "Braj" +msgstr "" + +#: config.language_map:180 +msgid "Breton" +msgstr "" + +#: config.language_map:181 +msgid "Batak" +msgstr "" + +#: config.language_map:182 +msgid "Buriat" +msgstr "" + +#: config.language_map:183 +msgid "Bugis" +msgstr "" + +#: config.language_map:184 +msgid "Bulgarian" +msgstr "" + +#: config.language_map:185 +msgid "Burmese" +msgstr "" + +#: config.language_map:186 +msgid "Caddo" +msgstr "" + +#: config.language_map:187 +msgid "Central American Indian (Other)" +msgstr "" + +#: config.language_map:188 +msgid "Khmer" +msgstr "" + +#: config.language_map:189 +msgid "Carib" +msgstr "" + +#: config.language_map:190 +msgid "Catalan" +msgstr "" + +#: config.language_map:191 +msgid "Caucasian (Other)" +msgstr "" + +#: config.language_map:192 +msgid "Cebuano" +msgstr "" + +#: config.language_map:193 +msgid "Celtic (Other)" +msgstr "" + +#: config.language_map:194 +msgid "Chamorro" +msgstr "" + +#: config.language_map:195 +msgid "Chibcha" +msgstr "" + +#: config.language_map:196 +msgid "Chechen" +msgstr "" + +#: config.language_map:197 +msgid "Chagatai" +msgstr "" + +#: config.language_map:198 +msgid "Chinese" +msgstr "" + +#: config.language_map:199 +msgid "Truk" +msgstr "" + +#: config.language_map:200 +msgid "Mari" +msgstr "" + +#: config.language_map:201 +msgid "Chinook jargon" +msgstr "" + +#: config.language_map:202 +msgid "Choctaw" +msgstr "" + +#: config.language_map:203 +msgid "Chipewyan" +msgstr "" + +#: config.language_map:204 +msgid "Cherokee" +msgstr "" + +#: config.language_map:205 +msgid "Church Slavic" +msgstr "" + +#: config.language_map:206 +msgid "Chuvash" +msgstr "" + +#: config.language_map:207 +msgid "Cheyenne" +msgstr "" + +#: config.language_map:208 +msgid "Chamic languages" +msgstr "" + +#: config.language_map:209 +msgid "Coptic" +msgstr "" + +#: config.language_map:210 +msgid "Cornish" +msgstr "" + +#: config.language_map:211 +msgid "Corsican" +msgstr "" + +#: config.language_map:212 +msgid "Creoles and Pidgins, English-based (Other)" +msgstr "" + +#: config.language_map:213 +msgid "Creoles and Pidgins, French-based (Other)" +msgstr "" + +#: config.language_map:214 +msgid "Creoles and Pidgins, Portuguese-based (Other)" +msgstr "" + +#: config.language_map:215 +msgid "Cree" +msgstr "" + +#: config.language_map:216 +msgid "Crimean Tatar" +msgstr "" + +#: config.language_map:217 +msgid "Creoles and Pidgins (Other)" +msgstr "" + +#: config.language_map:218 +msgid "Cushitic (Other)" +msgstr "" + +#: config.language_map:219 +msgid "Czech" +msgstr "" + +#: config.language_map:220 +msgid "Dakota" +msgstr "" + +#: config.language_map:221 +msgid "Danish" +msgstr "" + +#: config.language_map:222 +msgid "Dargwa" +msgstr "" + +#: config.language_map:223 +msgid "Dayak" +msgstr "" + +#: config.language_map:224 +msgid "Delaware" +msgstr "" + +#: config.language_map:225 +msgid "Slave" +msgstr "" + +#: config.language_map:226 +msgid "Dogrib" +msgstr "" + +#: config.language_map:227 +msgid "Dinka" +msgstr "" + +#: config.language_map:228 +msgid "Divehi" +msgstr "" + +#: config.language_map:229 +msgid "Dogri" +msgstr "" + +#: config.language_map:230 +msgid "Dravidian (Other)" +msgstr "" + +#: config.language_map:231 +msgid "Duala" +msgstr "" + +#: config.language_map:232 +msgid "Dutch, Middle (ca. 1050-1350)" +msgstr "" + +#: config.language_map:233 +msgid "Dutch" +msgstr "" + +#: config.language_map:234 +msgid "Dyula" +msgstr "" + +#: config.language_map:235 +msgid "Dzongkha" +msgstr "" + +#: config.language_map:236 +msgid "Efik" +msgstr "" + +#: config.language_map:237 +msgid "Egyptian" +msgstr "" + +#: config.language_map:238 +msgid "Ekajuk" +msgstr "" + +#: config.language_map:239 +msgid "Elamite" +msgstr "" + +#: config.language_map:240 +msgid "English" +msgstr "" + +#: config.language_map:241 +msgid "English, Middle (1100-1500)" +msgstr "" + +#: config.language_map:242 +msgid "Esperanto" +msgstr "" + +#: config.language_map:243 +msgid "Eskimo languages" +msgstr "" + +#: config.language_map:244 +msgid "Esperanto" +msgstr "" + +#: config.language_map:245 +msgid "Estonian" +msgstr "" + +#: config.language_map:246 +msgid "Ethiopic" +msgstr "" + +#: config.language_map:247 +msgid "Ewe" +msgstr "" + +#: config.language_map:248 +msgid "Ewondo" +msgstr "" + +#: config.language_map:249 +msgid "Fang" +msgstr "" + +#: config.language_map:250 +msgid "Faroese" +msgstr "" + +#: config.language_map:251 +msgid "Faroese" +msgstr "" + +#: config.language_map:252 +msgid "Fanti" +msgstr "" + +#: config.language_map:253 +msgid "Fijian" +msgstr "" + +#: config.language_map:254 +msgid "Finnish" +msgstr "" + +#: config.language_map:255 +msgid "Finno-Ugrian (Other)" +msgstr "" + +#: config.language_map:256 +msgid "Fon" +msgstr "" + +#: config.language_map:257 +msgid "French" +msgstr "" + +#: config.language_map:258 +msgid "Frisian" +msgstr "" + +#: config.language_map:259 +msgid "French, Middle (ca. 1400-1600)" +msgstr "" + +#: config.language_map:260 +msgid "French, Old (ca. 842-1400)" +msgstr "" + +#: config.language_map:261 +msgid "Frisian" +msgstr "" + +#: config.language_map:262 +msgid "Fula" +msgstr "" + +#: config.language_map:263 +msgid "Friulian" +msgstr "" + +#: config.language_map:264 +msgid "Gã" +msgstr "" + +#: config.language_map:265 +msgid "Scottish Gaelic" +msgstr "" + +#: config.language_map:266 +msgid "Galician" +msgstr "" + +#: config.language_map:267 +msgid "Oromo" +msgstr "" + +#: config.language_map:268 +msgid "Gayo" +msgstr "" + +#: config.language_map:269 +msgid "Gbaya" +msgstr "" + +#: config.language_map:270 +msgid "Germanic (Other)" +msgstr "" + +#: config.language_map:271 +msgid "Georgian" +msgstr "" + +#: config.language_map:272 +msgid "German" +msgstr "" + +#: config.language_map:273 +msgid "Ethiopic" +msgstr "" + +#: config.language_map:274 +msgid "Gilbertese" +msgstr "" + +#: config.language_map:275 +msgid "Scottish Gaelic" +msgstr "" + +#: config.language_map:276 +msgid "Irish" +msgstr "" + +#: config.language_map:277 +msgid "Galician" +msgstr "" + +#: config.language_map:278 +msgid "Manx" +msgstr "" + +#: config.language_map:279 +msgid "German, Middle High (ca. 1050-1500)" +msgstr "" + +#: config.language_map:280 +msgid "German, Old High (ca. 750-1050)" +msgstr "" + +#: config.language_map:281 +msgid "Gondi" +msgstr "" + +#: config.language_map:282 +msgid "Gorontalo" +msgstr "" + +#: config.language_map:283 +msgid "Gothic" +msgstr "" + +#: config.language_map:284 +msgid "Grebo" +msgstr "" + +#: config.language_map:285 +msgid "Greek, Ancient (to 1453)" +msgstr "" + +#: config.language_map:286 +msgid "Greek, Modern (1453- )" +msgstr "" + +#: config.language_map:287 +msgid "Guarani" +msgstr "" + +#: config.language_map:288 +msgid "Guarani" +msgstr "" + +#: config.language_map:289 +msgid "Gujarati" +msgstr "" + +#: config.language_map:290 +msgid "Gwich\'in" +msgstr "" + +#: config.language_map:291 +msgid "Haida" +msgstr "" + +#: config.language_map:292 +msgid "Haitian French Creole" +msgstr "" + +#: config.language_map:293 +msgid "Hausa" +msgstr "" + +#: config.language_map:294 +msgid "Hawaiian" +msgstr "" + +#: config.language_map:295 +msgid "Hebrew" +msgstr "" + +#: config.language_map:296 +msgid "Herero" +msgstr "" + +#: config.language_map:297 +msgid "Hiligaynon" +msgstr "" + +#: config.language_map:298 +msgid "Himachali" +msgstr "" + +#: config.language_map:299 +msgid "Hindi" +msgstr "" + +#: config.language_map:300 +msgid "Hittite" +msgstr "" + +#: config.language_map:301 +msgid "Hmong" +msgstr "" + +#: config.language_map:302 +msgid "Hiri Motu" +msgstr "" + +#: config.language_map:303 +msgid "Hungarian" +msgstr "" + +#: config.language_map:304 +msgid "Hupa" +msgstr "" + +#: config.language_map:305 +msgid "Iban" +msgstr "" + +#: config.language_map:306 +msgid "Igbo" +msgstr "" + +#: config.language_map:307 +msgid "Icelandic" +msgstr "" + +#: config.language_map:308 +msgid "Ido" +msgstr "" + +#: config.language_map:309 +msgid "Sichuan Yi" +msgstr "" + +#: config.language_map:310 +msgid "Ijo" +msgstr "" + +#: config.language_map:311 +msgid "Inuktitut" +msgstr "" + +#: config.language_map:312 +msgid "Interlingue" +msgstr "" + +#: config.language_map:313 +msgid "Iloko" +msgstr "" + +#: config.language_map:314 +msgid "Interlingua (International Auxiliary Language Association)" +msgstr "" + +#: config.language_map:315 +msgid "Indic (Other)" +msgstr "" + +#: config.language_map:316 +msgid "Indonesian" +msgstr "" + +#: config.language_map:317 +msgid "Indo-European (Other)" +msgstr "" + +#: config.language_map:318 +msgid "Ingush" +msgstr "" + +#: config.language_map:319 +msgid "Interlingua (International Auxiliary Language Association)" +msgstr "" + +#: config.language_map:320 +msgid "Inupiaq" +msgstr "" + +#: config.language_map:321 +msgid "Iranian (Other)" +msgstr "" + +#: config.language_map:322 +msgid "Irish" +msgstr "" + +#: config.language_map:323 +msgid "Iroquoian (Other)" +msgstr "" + +#: config.language_map:324 +msgid "Italian" +msgstr "" + +#: config.language_map:325 +msgid "Javanese" +msgstr "" + +#: config.language_map:326 +msgid "Japanese" +msgstr "" + +#: config.language_map:327 +msgid "Judeo-Persian" +msgstr "" + +#: config.language_map:328 +msgid "Judeo-Arabic" +msgstr "" + +#: config.language_map:329 +msgid "Kara-Kalpak" +msgstr "" + +#: config.language_map:330 +msgid "Kabyle" +msgstr "" + +#: config.language_map:331 +msgid "Kachin" +msgstr "" + +#: config.language_map:332 +msgid "Kalâtdlisut" +msgstr "" + +#: config.language_map:333 +msgid "Kamba" +msgstr "" + +#: config.language_map:334 +msgid "Kannada" +msgstr "" + +#: config.language_map:335 +msgid "Karen" +msgstr "" + +#: config.language_map:336 +msgid "Kashmiri" +msgstr "" + +#: config.language_map:337 +msgid "Kanuri" +msgstr "" + +#: config.language_map:338 +msgid "Kawi" +msgstr "" + +#: config.language_map:339 +msgid "Kazakh" +msgstr "" + +#: config.language_map:340 +msgid "Kabardian" +msgstr "" + +#: config.language_map:341 +msgid "Khasi" +msgstr "" + +#: config.language_map:342 +msgid "Khoisan (Other)" +msgstr "" + +#: config.language_map:343 +msgid "Khmer" +msgstr "" + +#: config.language_map:344 +msgid "Khotanese" +msgstr "" + +#: config.language_map:345 +msgid "Kikuyu" +msgstr "" + +#: config.language_map:346 +msgid "Kinyarwanda" +msgstr "" + +#: config.language_map:347 +msgid "Kyrgyz" +msgstr "" + +#: config.language_map:348 +msgid "Kimbundu" +msgstr "" + +#: config.language_map:349 +msgid "Konkani" +msgstr "" + +#: config.language_map:350 +msgid "Komi" +msgstr "" + +#: config.language_map:351 +msgid "Kongo" +msgstr "" + +#: config.language_map:352 +msgid "Korean" +msgstr "" + +#: config.language_map:353 +msgid "Kusaie" +msgstr "" + +#: config.language_map:354 +msgid "Kpelle" +msgstr "" + +#: config.language_map:355 +msgid "Kru" +msgstr "" + +#: config.language_map:356 +msgid "Kurukh" +msgstr "" + +#: config.language_map:357 +msgid "Kuanyama" +msgstr "" + +#: config.language_map:358 +msgid "Kumyk" +msgstr "" + +#: config.language_map:359 +msgid "Kurdish" +msgstr "" + +#: config.language_map:360 +msgid "Kusaie" +msgstr "" + +#: config.language_map:361 +msgid "Kutenai" +msgstr "" + +#: config.language_map:362 +msgid "Ladino" +msgstr "" + +#: config.language_map:363 +msgid "Lahnda" +msgstr "" + +#: config.language_map:364 +msgid "Lamba" +msgstr "" + +#: config.language_map:365 +msgid "Occitan (post-1500)" +msgstr "" + +#: config.language_map:366 +msgid "Lao" +msgstr "" + +#: config.language_map:367 +msgid "Sami" +msgstr "" + +#: config.language_map:368 +msgid "Latin" +msgstr "" + +#: config.language_map:369 +msgid "Latvian" +msgstr "" + +#: config.language_map:370 +msgid "Lezgian" +msgstr "" + +#: config.language_map:371 +msgid "Limburgish" +msgstr "" + +#: config.language_map:372 +msgid "Lingala" +msgstr "" + +#: config.language_map:373 +msgid "Lithuanian" +msgstr "" + +#: config.language_map:374 +msgid "Mongo-Nkundu" +msgstr "" + +#: config.language_map:375 +msgid "Lozi" +msgstr "" + +#: config.language_map:376 +msgid "Letzeburgesch" +msgstr "" + +#: config.language_map:377 +msgid "Luba-Lulua" +msgstr "" + +#: config.language_map:378 +msgid "Luba-Katanga" +msgstr "" + +#: config.language_map:379 +msgid "Ganda" +msgstr "" + +#: config.language_map:380 +msgid "Luiseño" +msgstr "" + +#: config.language_map:381 +msgid "Lunda" +msgstr "" + +#: config.language_map:382 +msgid "Luo (Kenya and Tanzania)" +msgstr "" + +#: config.language_map:383 +msgid "Lushai" +msgstr "" + +#: config.language_map:384 +msgid "Macedonian" +msgstr "" + +#: config.language_map:385 +msgid "Madurese" +msgstr "" + +#: config.language_map:386 +msgid "Magahi" +msgstr "" + +#: config.language_map:387 +msgid "Marshallese" +msgstr "" + +#: config.language_map:388 +msgid "Maithili" +msgstr "" + +#: config.language_map:389 +msgid "Makasar" +msgstr "" + +#: config.language_map:390 +msgid "Malayalam" +msgstr "" + +#: config.language_map:391 +msgid "Mandingo" +msgstr "" + +#: config.language_map:392 +msgid "Maori" +msgstr "" + +#: config.language_map:393 +msgid "Austronesian (Other)" +msgstr "" + +#: config.language_map:394 +msgid "Marathi" +msgstr "" + +#: config.language_map:395 +msgid "Masai" +msgstr "" + +#: config.language_map:396 +msgid "Manx" +msgstr "" + +#: config.language_map:397 +msgid "Malay" +msgstr "" + +#: config.language_map:398 +msgid "Mandar" +msgstr "" + +#: config.language_map:399 +msgid "Mende" +msgstr "" + +#: config.language_map:400 +msgid "Irish, Middle (ca. 1100-1550)" +msgstr "" + +#: config.language_map:401 +msgid "Micmac" +msgstr "" + +#: config.language_map:402 +msgid "Minangkabau" +msgstr "" + +#: config.language_map:403 +msgid "Miscellaneous languages" +msgstr "" + +#: config.language_map:404 +msgid "Mon-Khmer (Other)" +msgstr "" + +#: config.language_map:405 +msgid "Malagasy" +msgstr "" + +#: config.language_map:406 +msgid "Malagasy" +msgstr "" + +#: config.language_map:407 +msgid "Maltese" +msgstr "" + +#: config.language_map:408 +msgid "Manchu" +msgstr "" + +#: config.language_map:409 +msgid "Manipuri" +msgstr "" + +#: config.language_map:410 +msgid "Manobo languages" +msgstr "" + +#: config.language_map:411 +msgid "Mohawk" +msgstr "" + +#: config.language_map:412 +msgid "Moldavian" +msgstr "" + +#: config.language_map:413 +msgid "Mongolian" +msgstr "" + +#: config.language_map:414 +msgid "Mooré" +msgstr "" + +#: config.language_map:415 +msgid "Multiple languages" +msgstr "" + +#: config.language_map:416 +msgid "Munda (Other)" +msgstr "" + +#: config.language_map:417 +msgid "Creek" +msgstr "" + +#: config.language_map:418 +msgid "Marwari" +msgstr "" + +#: config.language_map:419 +msgid "Mayan languages" +msgstr "" + +#: config.language_map:420 +msgid "Nahuatl" +msgstr "" + +#: config.language_map:421 +msgid "North American Indian (Other)" +msgstr "" + +#: config.language_map:422 +msgid "Neapolitan Italian" +msgstr "" + +#: config.language_map:423 +msgid "Nauru" +msgstr "" + +#: config.language_map:424 +msgid "Navajo" +msgstr "" + +#: config.language_map:425 +msgid "Ndebele (South Africa)" +msgstr "" + +#: config.language_map:426 +msgid "Ndebele (Zimbabwe) " +msgstr "" + +#: config.language_map:427 +msgid "Ndonga" +msgstr "" + +#: config.language_map:428 +msgid "Low German" +msgstr "" + +#: config.language_map:429 +msgid "Nepali" +msgstr "" + +#: config.language_map:430 +msgid "Newari" +msgstr "" + +#: config.language_map:431 +msgid "Nias" +msgstr "" + +#: config.language_map:432 +msgid "Niger-Kordofanian (Other)" +msgstr "" + +#: config.language_map:433 +msgid "Niuean" +msgstr "" + +#: config.language_map:434 +msgid "Norwegian (Nynorsk)" +msgstr "" + +#: config.language_map:435 +msgid "Norwegian (Bokmål)" +msgstr "" + +#: config.language_map:436 +msgid "Nogai" +msgstr "" + +#: config.language_map:437 +msgid "Old Norse" +msgstr "" + +#: config.language_map:438 +msgid "Norwegian" +msgstr "" + +#: config.language_map:439 +msgid "Northern Sotho" +msgstr "" + +#: config.language_map:440 +msgid "Nubian languages" +msgstr "" + +#: config.language_map:441 +msgid "Nyanja" +msgstr "" + +#: config.language_map:442 +msgid "Nyamwezi" +msgstr "" + +#: config.language_map:443 +msgid "Nyankole" +msgstr "" + +#: config.language_map:444 +msgid "Nyoro" +msgstr "" + +#: config.language_map:445 +msgid "Nzima" +msgstr "" + +#: config.language_map:446 +msgid "Occitan (post-1500)" +msgstr "" + +#: config.language_map:447 +msgid "Ojibwa" +msgstr "" + +#: config.language_map:448 +msgid "Oriya" +msgstr "" + +#: config.language_map:449 +msgid "Oromo" +msgstr "" + +#: config.language_map:450 +msgid "Osage" +msgstr "" + +#: config.language_map:451 +msgid "Ossetic" +msgstr "" + +#: config.language_map:452 +msgid "Turkish, Ottoman" +msgstr "" + +#: config.language_map:453 +msgid "Otomian languages" +msgstr "" + +#: config.language_map:454 +msgid "Papuan (Other)" +msgstr "" + +#: config.language_map:455 +msgid "Pangasinan" +msgstr "" + +#: config.language_map:456 +msgid "Pahlavi" +msgstr "" + +#: config.language_map:457 +msgid "Pampanga" +msgstr "" + +#: config.language_map:458 +msgid "Panjabi" +msgstr "" + +#: config.language_map:459 +msgid "Papiamento" +msgstr "" + +#: config.language_map:460 +msgid "Palauan" +msgstr "" + +#: config.language_map:461 +msgid "Old Persian (ca. 600-400 B.C.)" +msgstr "" + +#: config.language_map:462 +msgid "Persian" +msgstr "" + +#: config.language_map:463 +msgid "Philippine (Other)" +msgstr "" + +#: config.language_map:464 +msgid "Phoenician" +msgstr "" + +#: config.language_map:465 +msgid "Pali" +msgstr "" + +#: config.language_map:466 +msgid "Polish" +msgstr "" + +#: config.language_map:467 +msgid "Ponape" +msgstr "" + +#: config.language_map:468 +msgid "Portuguese" +msgstr "" + +#: config.language_map:469 +msgid "Prakrit languages" +msgstr "" + +#: config.language_map:470 +msgid "Provençal (to 1500)" +msgstr "" + +#: config.language_map:471 +msgid "Pushto" +msgstr "" + +#: config.language_map:472 +msgid "Quechua" +msgstr "" + +#: config.language_map:473 +msgid "Rajasthani" +msgstr "" + +#: config.language_map:474 +msgid "Rapanui" +msgstr "" + +#: config.language_map:475 +msgid "Rarotongan" +msgstr "" + +#: config.language_map:476 +msgid "Romance (Other)" +msgstr "" + +#: config.language_map:477 +msgid "Raeto-Romance" +msgstr "" + +#: config.language_map:478 +msgid "Romani" +msgstr "" + +#: config.language_map:479 +msgid "Romanian" +msgstr "" + +#: config.language_map:480 +msgid "Rundi" +msgstr "" + +#: config.language_map:481 +msgid "Russian" +msgstr "" + +#: config.language_map:482 +msgid "Sandawe" +msgstr "" + +#: config.language_map:483 +msgid "Sango (Ubangi Creole)" +msgstr "" + +#: config.language_map:484 +msgid "Yakut" +msgstr "" + +#: config.language_map:485 +msgid "South American Indian (Other)" +msgstr "" + +#: config.language_map:486 +msgid "Salishan languages" +msgstr "" + +#: config.language_map:487 +msgid "Samaritan Aramaic" +msgstr "" + +#: config.language_map:488 +msgid "Sanskrit" +msgstr "" + +#: config.language_map:489 +msgid "Samoan" +msgstr "" + +#: config.language_map:490 +msgid "Sasak" +msgstr "" + +#: config.language_map:491 +msgid "Santali" +msgstr "" + +#: config.language_map:492 +msgid "Serbian" +msgstr "" + +#: config.language_map:493 +msgid "Scots" +msgstr "" + +#: config.language_map:494 +msgid "Croatian" +msgstr "" + +#: config.language_map:495 +msgid "Selkup" +msgstr "" + +#: config.language_map:496 +msgid "Semitic (Other)" +msgstr "" + +#: config.language_map:497 +msgid "Irish, Old (to 1100)" +msgstr "" + +#: config.language_map:498 +msgid "Sign languages" +msgstr "" + +#: config.language_map:499 +msgid "Shan" +msgstr "" + +#: config.language_map:500 +msgid "Shona" +msgstr "" + +#: config.language_map:501 +msgid "Sidamo" +msgstr "" + +#: config.language_map:502 +msgid "Sinhalese" +msgstr "" + +#: config.language_map:503 +msgid "Siouan (Other)" +msgstr "" + +#: config.language_map:504 +msgid "Sino-Tibetan (Other)" +msgstr "" + +#: config.language_map:505 +msgid "Slavic (Other)" +msgstr "" + +#: config.language_map:506 +msgid "Slovak" +msgstr "" + +#: config.language_map:507 +msgid "Slovenian" +msgstr "" + +#: config.language_map:508 +msgid "Southern Sami" +msgstr "" + +#: config.language_map:509 +msgid "Northern Sami" +msgstr "" + +#: config.language_map:510 +msgid "Sami" +msgstr "" + +#: config.language_map:511 +msgid "Lule Sami" +msgstr "" + +#: config.language_map:512 +msgid "Inari Sami" +msgstr "" + +#: config.language_map:513 +msgid "Samoan" +msgstr "" + +#: config.language_map:514 +msgid "Skolt Sami" +msgstr "" + +#: config.language_map:515 +msgid "Shona" +msgstr "" + +#: config.language_map:516 +msgid "Sindhi" +msgstr "" + +#: config.language_map:517 +msgid "Sinhalese" +msgstr "" + +#: config.language_map:518 +msgid "Soninke" +msgstr "" + +#: config.language_map:519 +msgid "Sogdian" +msgstr "" + +#: config.language_map:520 +msgid "Somali" +msgstr "" + +#: config.language_map:521 +msgid "Songhai" +msgstr "" + +#: config.language_map:522 +msgid "Sotho" +msgstr "" + +#: config.language_map:523 +msgid "Spanish" +msgstr "" + +#: config.language_map:524 +msgid "Sardinian" +msgstr "" + +#: config.language_map:525 +msgid "Serer" +msgstr "" + +#: config.language_map:526 +msgid "Nilo-Saharan (Other)" +msgstr "" + +#: config.language_map:527 +msgid "Sotho" +msgstr "" + +#: config.language_map:528 +msgid "Swazi" +msgstr "" + +#: config.language_map:529 +msgid "Sukuma" +msgstr "" + +#: config.language_map:530 +msgid "Sundanese" +msgstr "" + +#: config.language_map:531 +msgid "Susu" +msgstr "" + +#: config.language_map:532 +msgid "Sumerian" +msgstr "" + +#: config.language_map:533 +msgid "Swahili" +msgstr "" + +#: config.language_map:534 +msgid "Swedish" +msgstr "" + +#: config.language_map:535 +msgid "Swazi" +msgstr "" + +#: config.language_map:536 +msgid "Syriac" +msgstr "" + +#: config.language_map:537 +msgid "Tagalog" +msgstr "" + +#: config.language_map:538 +msgid "Tahitian" +msgstr "" + +#: config.language_map:539 +msgid "Tai (Other)" +msgstr "" + +#: config.language_map:540 +msgid "Tajik" +msgstr "" + +#: config.language_map:541 +msgid "Tamil" +msgstr "" + +#: config.language_map:542 +msgid "Tatar" +msgstr "" + +#: config.language_map:543 +msgid "Tatar" +msgstr "" + +#: config.language_map:544 +msgid "Telugu" +msgstr "" + +#: config.language_map:545 +msgid "Temne" +msgstr "" + +#: config.language_map:546 +msgid "Terena" +msgstr "" + +#: config.language_map:547 +msgid "Tetum" +msgstr "" + +#: config.language_map:548 +msgid "Tajik" +msgstr "" + +#: config.language_map:549 +msgid "Tagalog" +msgstr "" + +#: config.language_map:550 +msgid "Thai" +msgstr "" + +#: config.language_map:551 +msgid "Tibetan" +msgstr "" + +#: config.language_map:552 +msgid "Tigré" +msgstr "" + +#: config.language_map:553 +msgid "Tigrinya" +msgstr "" + +#: config.language_map:554 +msgid "Tiv" +msgstr "" + +#: config.language_map:555 +msgid "Tokelauan" +msgstr "" + +#: config.language_map:556 +msgid "Tlingit" +msgstr "" + +#: config.language_map:557 +msgid "Tamashek" +msgstr "" + +#: config.language_map:558 +msgid "Tonga (Nyasa)" +msgstr "" + +#: config.language_map:559 +msgid "Tongan" +msgstr "" + +#: config.language_map:560 +msgid "Tok Pisin" +msgstr "" + +#: config.language_map:561 +msgid "Truk" +msgstr "" + +#: config.language_map:562 +msgid "Tsimshian" +msgstr "" + +#: config.language_map:563 +msgid "Tswana" +msgstr "" + +#: config.language_map:564 +msgid "Tsonga" +msgstr "" + +#: config.language_map:565 +msgid "Tswana" +msgstr "" + +#: config.language_map:566 +msgid "Turkmen" +msgstr "" + +#: config.language_map:567 +msgid "Tumbuka" +msgstr "" + +#: config.language_map:568 +msgid "Tupi languages" +msgstr "" + +#: config.language_map:569 +msgid "Turkish" +msgstr "" + +#: config.language_map:570 +msgid "Altaic (Other)" +msgstr "" + +#: config.language_map:571 +msgid "Tuvaluan" +msgstr "" + +#: config.language_map:572 +msgid "Twi" +msgstr "" + +#: config.language_map:573 +msgid "Tuvinian" +msgstr "" + +#: config.language_map:574 +msgid "Udmurt" +msgstr "" + +#: config.language_map:575 +msgid "Ugaritic" +msgstr "" + +#: config.language_map:576 +msgid "Uighur" +msgstr "" + +#: config.language_map:577 +msgid "Ukrainian" +msgstr "" + +#: config.language_map:578 +msgid "Umbundu" +msgstr "" + +#: config.language_map:579 +msgid "Undetermined" +msgstr "" + +#: config.language_map:580 +msgid "Urdu" +msgstr "" + +#: config.language_map:581 +msgid "Uzbek" +msgstr "" + +#: config.language_map:582 +msgid "Vai" +msgstr "" + +#: config.language_map:583 +msgid "Venda" +msgstr "" + +#: config.language_map:584 +msgid "Vietnamese" +msgstr "" + +#: config.language_map:585 +msgid "Volapük" +msgstr "" + +#: config.language_map:586 +msgid "Votic" +msgstr "" + +#: config.language_map:587 +msgid "Wakashan languages" +msgstr "" + +#: config.language_map:588 +msgid "Walamo" +msgstr "" + +#: config.language_map:589 +msgid "Waray" +msgstr "" + +#: config.language_map:590 +msgid "Washo" +msgstr "" + +#: config.language_map:591 +msgid "Welsh" +msgstr "" + +#: config.language_map:592 +msgid "Sorbian languages" +msgstr "" + +#: config.language_map:593 +msgid "Walloon" +msgstr "" + +#: config.language_map:594 +msgid "Wolof" +msgstr "" + +#: config.language_map:595 +msgid "Kalmyk" +msgstr "" + +#: config.language_map:596 +msgid "Xhosa" +msgstr "" + +#: config.language_map:597 +msgid "Yao (Africa)" +msgstr "" + +#: config.language_map:598 +msgid "Yapese" +msgstr "" + +#: config.language_map:599 +msgid "Yiddish" +msgstr "" + +#: config.language_map:600 +msgid "Yoruba" +msgstr "" + +#: config.language_map:601 +msgid "Yupik languages" +msgstr "" + +#: config.language_map:602 +msgid "Zapotec" +msgstr "" + +#: config.language_map:603 +msgid "Zenaga" +msgstr "" + +#: config.language_map:604 +msgid "Zhuang" +msgstr "" + +#: config.language_map:605 +msgid "Zande" +msgstr "" + +#: config.language_map:606 +msgid "Zulu" +msgstr "" + +#: config.language_map:607 +msgid "Zuni" +msgstr "" + +#: config.item_form_map:610 +msgid "Microfilm" +msgstr "" + +#: config.item_form_map:611 +msgid "Microfiche" +msgstr "" + +#: config.item_form_map:612 +msgid "Microopaque" +msgstr "" + +#: config.item_form_map:613 +msgid "Large print" +msgstr "" + +#: config.item_form_map:614 +msgid "Braille" +msgstr "" + +#: config.item_form_map:615 +msgid "Regular print reproduction" +msgstr "" + +#: config.item_form_map:616 +msgid "Electronic" +msgstr "" + +#: config.item_type_map:619 +msgid "Language material" +msgstr "" + +#: config.item_type_map:620 +msgid "Manuscript language material" +msgstr "" + +#: config.item_type_map:621 +msgid "Projected medium" +msgstr "" + +#: config.item_type_map:622 +msgid "Two-dimensional nonprojectable graphic" +msgstr "" + +#: config.item_type_map:623 +msgid "Three-dimensional artifact or naturally occurring object" +msgstr "" + +#: config.item_type_map:624 +msgid "Kit" +msgstr "" + +#: config.item_type_map:625 +msgid "Mixed materials" +msgstr "" + +#: config.item_type_map:626 +msgid "Cartographic material" +msgstr "" + +#: config.item_type_map:627 +msgid "Manuscript cartographic material" +msgstr "" + +#: config.item_type_map:628 +msgid "Notated music" +msgstr "" + +#: config.item_type_map:629 +msgid "Manuscript notated music" +msgstr "" + +#: config.item_type_map:630 +msgid "Nonmusical sound recording" +msgstr "" + +#: config.item_type_map:631 +msgid "Musical sound recording" +msgstr "" + +#: config.item_type_map:632 +msgid "Computer file" +msgstr "" + +#: actor.usr:637 +msgid "Administrator" +msgstr "" + +#: actor.org_unit_type:643 +msgid "Consortium" +msgstr "" + +#: actor.org_unit_type:644 +msgid "System" +msgstr "" + +#: actor.org_unit_type:646 +msgid "Branch" +msgstr "" + +#: actor.org_unit_type:647 +msgid "Sub-lib" +msgstr "" + +#: actor.org_unit_type:648 +msgid "Bookmobile" +msgstr "" + +#: actor.org_unit:651 +msgid "Example Consortium" +msgstr "" + +#: actor.org_unit:652 +msgid "Example System 1" +msgstr "" + +#: actor.org_unit:653 +msgid "Example System 2" +msgstr "" + +#: actor.org_unit:654 +msgid "Example Branch 1" +msgstr "" + +#: actor.org_unit:655 +msgid "Example Branch 2" +msgstr "" + +#: actor.org_unit:656 +msgid "Example Branch 3" +msgstr "" + +#: actor.org_unit:657 +msgid "Example Branch 4" +msgstr "" + +#: actor.org_unit:658 +msgid "Example Sub-lib 1" +msgstr "" + +#: actor.org_unit:659 +msgid "Example Bookmobile 1" +msgstr "" + +#: actor.org_address:661 +msgid "123 Main St." +msgstr "" + +#: permission.perm_list:673 +msgid "User is allowed to place a hold on a specific copy" +msgstr "" + +#: permission.perm_list:676 +msgid "Allows a user to view another user\'s holds" +msgstr "" + +#: permission.perm_list:678 +msgid "Allows a user to update another user\'s hold" +msgstr "" + +#: permission.perm_list:683 +msgid "User is allowed to create new MARC records" +msgstr "" + +#: permission.perm_list:703 +msgid "User may create new billable transactions" +msgstr "" + +#: permission.perm_list:704 +msgid "Allows a user to create a new bill on a transaction" +msgstr "" + +#: permission.perm_list:705 +msgid "Allows a user to view another user" +msgstr "" + +#: permission.perm_list:706 +msgid "Allows a user to create a new container for another user" +msgstr "" + +#: permission.perm_list:707 +msgid "User is allowed to create a new copy object" +msgstr "" + +#: permission.perm_list:708 +msgid "Allows a user to change org unit settings" +msgstr "" + +#: permission.perm_list:709 +msgid "Allows a user to see what another use has checked out" +msgstr "" + +#: permission.perm_list:710 +msgid "User may view another user" +msgstr "" + +#: permission.perm_list:711 +msgid "Allows a user to delete another user container" +msgstr "" + +#: permission.perm_list:712 +msgid "Create a container item for another user" +msgstr "" + +#: permission.perm_list:713 +msgid "User can add other users to permission groups" +msgstr "" + +#: permission.perm_list:714 +msgid "User can remove other users from permission groups" +msgstr "" + +#: permission.perm_list:715 +msgid "Allow user to view others" +msgstr "" + +#: permission.perm_list:716 +msgid "Allows a user to determine of another user can checkout an item" +msgstr "" + +#: permission.perm_list:717 +msgid "Allows a user to edit copies in batch" +msgstr "" + +#: permission.perm_list:718 +msgid "User may create a new patron statistical category" +msgstr "" + +#: permission.perm_list:719 +msgid "User may create a copy stat cat" +msgstr "" + +#: permission.perm_list:720 +msgid "User may create a new patron stat cat entry" +msgstr "" + +#: permission.perm_list:721 +msgid "User may create a new copy stat cat entry" +msgstr "" + +#: permission.perm_list:722 +msgid "User may update a patron stat cat" +msgstr "" + +#: permission.perm_list:723 +msgid "User may update a copy stat cat" +msgstr "" + +#: permission.perm_list:724 +msgid "User may update a patron stat cat entry" +msgstr "" + +#: permission.perm_list:725 +msgid "User may update a copy stat cat entry" +msgstr "" + +#: permission.perm_list:726 +msgid "User may link a copy to a stat cat entry" +msgstr "" + +#: permission.perm_list:727 +msgid "User may link another user to a stat cat entry" +msgstr "" + +#: permission.perm_list:728 +msgid "User may delete a patron stat cat" +msgstr "" + +#: permission.perm_list:729 +msgid "User may delete a copy stat cat" +msgstr "" + +#: permission.perm_list:730 +msgid "User may delete a patron stat cat entry" +msgstr "" + +#: permission.perm_list:731 +msgid "User may delete a copy stat cat entry" +msgstr "" + +#: permission.perm_list:732 +msgid "User may delete a patron stat cat entry map" +msgstr "" + +#: permission.perm_list:733 +msgid "User may delete a copy stat cat entry map" +msgstr "" + +#: permission.perm_list:734 +msgid "Allows a user to create a new non-cataloged item type" +msgstr "" + +#: permission.perm_list:735 +msgid "Allows a user to update a non cataloged type" +msgstr "" + +#: permission.perm_list:736 +msgid "Allows a user to create a new in-house-use " +msgstr "" + +#: permission.perm_list:737 +msgid "Allows a user to check out a copy" +msgstr "" + +#: permission.perm_list:738 +msgid "Allows a user to create a new copy location" +msgstr "" + +#: permission.perm_list:739 +msgid "Allows a user to update a copy location" +msgstr "" + +#: permission.perm_list:740 +msgid "Allows a user to delete a copy location" +msgstr "" + +#: permission.perm_list:741 +msgid "Allows a user to create a transit_copy object for transiting a copy" +msgstr "" + +#: permission.perm_list:742 +msgid "Allows a user to close out a transit on a copy" +msgstr "" + +#: permission.perm_list:743 +msgid "Allows a user to see if another user has permission to place a hold on a given copy" +msgstr "" + +#: permission.perm_list:744 +msgid "Allows a user to view which users have checked out a given copy" +msgstr "" + +#: permission.perm_list:745 +msgid "Allows a user to perform z3950 queries against remote servers" +msgstr "" + +#: permission.perm_list:746 +msgid "Allows a user to register a new workstation" +msgstr "" + +#: permission.perm_list:747 +msgid "Allows a user to view all notes attached to a copy" +msgstr "" + +#: permission.perm_list:748 +msgid "Allows a user to view all notes attached to a volume" +msgstr "" + +#: permission.perm_list:749 +msgid "Allows a user to view all notes attached to a title" +msgstr "" + +#: permission.perm_list:750 +msgid "Allows a user to create a new volume note" +msgstr "" + +#: permission.perm_list:751 +msgid "Allows a user to create a new copy note" +msgstr "" + +#: permission.perm_list:752 +msgid "Allows a user to create a new title note" +msgstr "" + +#: permission.perm_list:753 +msgid "Allows a user to delete someone elses copy notes" +msgstr "" + +#: permission.perm_list:754 +msgid "Allows a user to delete someone elses volume note" +msgstr "" + +#: permission.perm_list:755 +msgid "Allows a user to delete someone elses title note" +msgstr "" + +#: permission.perm_list:756 +msgid "Allows a user to update another users container" +msgstr "" + +#: permission.perm_list:757 +msgid "Allows a user to create a container for themselves" +msgstr "" + +#: permission.perm_list:758 +msgid "Allows a user to view notifications attached to a hold" +msgstr "" + +#: permission.perm_list:759 +msgid "Allows a user to create new hold notifications" +msgstr "" + +#: permission.perm_list:760 +msgid "Allows a user to update an org unit setting" +msgstr "" + +#: permission.perm_list:761 +msgid "Allows a user to upload an offline script" +msgstr "" + +#: permission.perm_list:762 +msgid "Allows a user to view uploaded offline script information" +msgstr "" + +#: permission.perm_list:763 +msgid "Allows a user to execute an offline script batch" +msgstr "" + +#: permission.perm_list:764 +msgid "Allows a user to change set the due date on an item to any date" +msgstr "" + +#: permission.perm_list:765 +msgid "Allows a user to bypass the circ permit call for checkout" +msgstr "" + +#: permission.perm_list:766 +msgid "Allows a user to override the copy_is_reference event" +msgstr "" + +#: permission.perm_list:767 +msgid "Allows a user to void a bill" +msgstr "" + +#: permission.perm_list:768 +msgid "Allows a person to check in/out an item that is claims returned" +msgstr "" + +#: permission.perm_list:769 +msgid "Allows a user to check out an item in a non-circulatable status" +msgstr "" + +#: permission.perm_list:770 +msgid "Allows a user to check in/out an item that has an alert message" +msgstr "" + +#: permission.perm_list:771 +msgid "Allows a user to remove the lost status from a copy" +msgstr "" + +#: permission.perm_list:772 +msgid "Allows a user to change the missing status on a copy" +msgstr "" + +#: permission.perm_list:773 +msgid "Allows a user to abort a copy transit if the user is at the transit destination or source" +msgstr "" + +#: permission.perm_list:774 +msgid "Allows a user to abort a copy transit if the user is not at the transit source or dest" +msgstr "" + +#: permission.perm_list:775 +msgid "Allowsa user to query the zip code data method" +msgstr "" + +#: permission.perm_list:777 +msgid "Allows a user to create duplicate holds (e.g. two holds on the same title)" +msgstr "" + +#: permission.perm_list:778 +msgid "Allows a user to update a closed date interval for a given location" +msgstr "" + +#: permission.perm_list:779 +msgid "Allows a user to remove a closed date interval for a given location" +msgstr "" + +#: permission.perm_list:780 +msgid "Allows a user to create a new closed date for a location" +msgstr "" + +#: permission.perm_list:781 +msgid "Allows a user to delete a non cataloged type" +msgstr "" + +#: permission.perm_list:782 +msgid "Allows a user to put someone into collections" +msgstr "" + +#: permission.perm_list:783 +msgid "Allows a user to remove someone from collections" +msgstr "" + +#: permission.perm_list:784 +msgid "Allows a user to bar a patron" +msgstr "" + +#: permission.perm_list:785 +msgid "Allows a user to un-bar a patron" +msgstr "" + +#: permission.perm_list:786 +msgid "Allows a user to remove an existing workstation so a new one can replace it" +msgstr "" + +#: permission.perm_list:787 +msgid "Allows a user to add/remove users to/from the "User" group" +msgstr "" + +#: permission.perm_list:788 +msgid "Allows a user to add/remove users to/from the "Patron" group" +msgstr "" + +#: permission.perm_list:789 +msgid "Allows a user to add/remove users to/from the "Staff" group" +msgstr "" + +#: permission.perm_list:790 +msgid "Allows a user to add/remove users to/from the "Circulator" group" +msgstr "" + +#: permission.perm_list:791 +msgid "Allows a user to add/remove users to/from the "Cataloger" group" +msgstr "" + +#: permission.perm_list:792 +msgid "Allows a user to add/remove users to/from the "GlobalAdmin" group" +msgstr "" + +#: permission.perm_list:793 +msgid "Allows a user to add/remove users to/from the "LocalAdmin" group" +msgstr "" + +#: permission.perm_list:794 +msgid "Allows a user to add/remove users to/from the "LibraryManager" group" +msgstr "" + +#: permission.perm_list:795 +msgid "Allows a user to add/remove users to/from the "Cat1" group" +msgstr "" + +#: permission.perm_list:796 +msgid "Allows a user to add/remove users to/from the "Supercat" group" +msgstr "" + +#: permission.perm_list:797 +msgid "Allows a user to add/remove users to/from the "SIP-Client" group" +msgstr "" + +#: permission.perm_list:798 +msgid "Allows a user to add/remove users to/from the "Vendor" group" +msgstr "" + +#: permission.perm_list:799 +msgid "Allows a user to place a hold on an age-protected item" +msgstr "" + +#: permission.perm_list:800 +msgid "Allows a user to renew an item past the maximun renewal count" +msgstr "" + +#: permission.perm_list:801 +msgid "Allow staff to override checkout count failure" +msgstr "" + +#: permission.perm_list:802 +msgid "Allow staff to override overdue count failure" +msgstr "" + +#: permission.perm_list:803 +msgid "Allow staff to override fine amount checkout failure" +msgstr "" + +#: permission.perm_list:806 +msgid "Allow staff to force checkout of Missing/Lost type items" +msgstr "" + +#: permission.perm_list:807 +msgid "allows users to place multiple holds on a single title" +msgstr "" + +#: permission.perm_list:808 +msgid "Allows a users to run reports" +msgstr "" + +#: permission.perm_list:809 +msgid "Allows a user to share report his own folders" +msgstr "" + +#: permission.perm_list:810 +msgid "Allow user to view report output" +msgstr "" + +#: permission.perm_list:811 +msgid "Allows a user to checkout an item that is marked as non-circ" +msgstr "" + +#: permission.perm_list:812 +msgid "Allows a user to delete an item out of another user\'s container" +msgstr "" + +#: permission.perm_list:813 +msgid "Allow a staff member to define where another staff member has their permissions" +msgstr "" + +#: asset.copy_location:943 +msgid "Stacks" +msgstr "" diff --git a/build/i18n/scripts/db-seed-i18n.py b/build/i18n/scripts/db-seed-i18n.py new file mode 100755 index 0000000000..89abbc8447 --- /dev/null +++ b/build/i18n/scripts/db-seed-i18n.py @@ -0,0 +1,133 @@ +#/usr/bin/env python +# +# Copyright 2007 Dan Scott +# +# This class enables translation of Evergreen's seed database strings. +# +# Requires polib from http://polib.googlecode.com +# +# #### +# +# This program is free software; you can redistribute it and/or +# modify it under the terms of the GNU General Public License +# as published by the Free Software Foundation; either version 2 +# of the License, or (at your option) any later version. +# +# This program is distributed in the hope that it will be useful, +# but WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. + +import polib +import re +import time + +class EvergreenSQL: + """ + This class provides methods for extracting translatable strings from + Evergreen's database seed values, generating a translatable POT file, + reading translated PO files, and generating SQL for inserting the + translated values into the Evergreen database. + """ + + def getstrings(self, source): + """ + Each INSERT statement contains a schema and tablename which we need to + insert into the config.i18n table. We'll push this into our + POEntry.occurences attribute. + + Each INSERT statement also contains 0 or more oils_i18n_gettext() + markers for the en-US string that we'll use for our msgid attribute. + + A sample INSERT string that we'll scan is as follows: + + INSERT INTO foo.bar (key, value) VALUES + (99, oils_i18n_gettext('string')); + """ + date = time.strftime("%Y-%m-%d %H:%M:%S") + self.pot = polib.POFile() + + # We should be smarter about the Project-Id-Version attribute + self.pot.metadata['Project-Id-Version'] = 'Evergreen 1.4' + self.pot.metadata['Report-Msgid-Bugs-To'] = 'open-ils-dev@list.georgialibraries.org' + # Cheat and hard-code the time zone offset + self.pot.metadata['POT-Creation-Date'] = "%s %s" % (date, '-0400') + self.pot.metadata['PO-Revision-Date'] = 'YEAR-MO-DA HO:MI+ZONE' + self.pot.metadata['Last-Translator'] = 'FULL NAME ' + self.pot.metadata['Language-Team'] = 'LANGUAGE ' + self.pot.metadata['MIME-Version'] = '1.0' + self.pot.metadata['Content-Type'] = 'text/plain; charset=utf-8' + self.pot.metadata['Content-Transfer-Encoding'] = '8-bit' + + # table holds the fully-qualified table name (schema.table) + # The source SQL may use multi-row VALUES clauses for a single + # insert statement, so we need to remember the fq-table for + # multiple lines + table = '' + n = 1 + findtable = re.compile(r'\s*INSERT\s+INTO\s+(\S+).*?$') + findi18n = re.compile(r'.*?oils_i18n_gettext\(\'(.+?)\'\)') + + # Iterate through the source SQL grabbing table names and l10n strings + sourcefile = open(source) + for line in sourcefile: + ftable = findtable.search(line) + if ftable is not None: + table = ftable.group(1) + fi18n = findi18n.search(line) + if fi18n is not None: + for i18n in fi18n.groups(): + # Unescape escaped SQL single-quotes for translators' sanity + i18n = re.compile(r'\'\'').sub(r'\'', i18n) + poe = polib.POEntry() + poe.occurences = [(table, n)] + poe.msgid = i18n + self.pot.append(poe) + n = n + 1 + + def savepot(self, destination): + """ + Saves the POT file to a specified file. + """ + self.pot.save(destination) + + def loadpo(self, source): + """ + Loads a translated PO file so we can generate the corresponding SQL. + """ + self.pot = polib.pofile(source) + + def createsql(self, locale): + """ + Creates a set of INSERT statements that place translated strings + into the config.i18n_core table. + """ + + insert = "INSERT INTO config.i18n_core (fq_field, identity_value, translation, string) VALUES ('%s', '%s', '%s', '%s');" + self.sql = [] + for entry in self.pot: + for table in entry.occurences: + # Escape SQL single-quotes to avoid b0rkage + msgid = re.compile(r'\'').sub("''", entry.msgid) + msgstr = re.compile(r'\'').sub("''", entry.msgstr) + if msgstr == '': + # Don't generate a stmt for an untranslated string + break + self.sql.append(insert % (table[0], msgid, locale, msgstr)) + + def __str__(self): + """ + Returns the PO representation of the strings. + """ + return self.pot.__str__() + +if __name__ == '__main__': + pot = EvergreenSQL() + pot.getstrings('../../Open-ILS/src/sql/Pg/950.data.seed-values.sql') + pot.savepot('po/db.seed.pot') + +# test = EvergreenSQL() +# test.loadpo('po/db.seed.pot') +# test.createsql('fr-CA') +# for insert in test.sql: +# print insert -- 2.43.2