From 2abc61afd3fe11caadab5548e156447aab180236 Mon Sep 17 00:00:00 2001 From: Piotr Wejman Date: Tue, 8 Dec 2009 23:29:42 +0100 Subject: [PATCH] Adding pl-PL directory to installer/data/mysql. --- .../mysql/pl-PL/mandatory/class_sources.sql | 36 + .../mysql/pl-PL/mandatory/class_sources.txt | 1 + .../mandatory/message_transport_types.sql | 5 + .../mandatory/message_transport_types.txt | 1 + .../mysql/pl-PL/mandatory/sample_notices.sql | 14 + .../mysql/pl-PL/mandatory/sample_notices.txt | 1 + .../data/mysql/pl-PL/mandatory/stopwords.sql | 99 + .../data/mysql/pl-PL/mandatory/stopwords.txt | 1 + .../mysql/pl-PL/mandatory/subtag_registry.sql | 722 + .../mysql/pl-PL/mandatory/subtag_registry.txt | 5 + .../data/mysql/pl-PL/mandatory/sysprefs.sql | 275 + .../data/mysql/pl-PL/mandatory/sysprefs.txt | 1 + .../data/mysql/pl-PL/mandatory/userflags.sql | 17 + .../data/mysql/pl-PL/mandatory/userflags.txt | 1 + .../mysql/pl-PL/mandatory/userpermissions.sql | 36 + .../mysql/pl-PL/mandatory/userpermissions.txt | 1 + .../mandatory/authorities_normal_marc21.sql | 8826 +++++ .../mandatory/authorities_normal_marc21.txt | 11 + .../mandatory/marc21_framework_DEFAULT.sql | 3985 ++ .../mandatory/marc21_framework_DEFAULT.txt | 1 + .../marc21_default_matching_rules.sql | 38 + .../marc21_default_matching_rules.txt | 4 + .../optional/marc21_fastadd_framework.sql | 138 + .../optional/marc21_fastadd_framework.txt | 1 + .../optional/marc21_simple_bib_frameworks.sql | 31442 ++++++++++++++++ .../optional/marc21_simple_bib_frameworks.txt | 10 + .../mandatory/authorities_normal_unimarc.sql | 823 + .../mandatory/authorities_normal_unimarc.txt | 1 + .../mandatory/unimarc_framework_DEFAULT.sql | 1468 + .../mandatory/unimarc_framework_DEFAULT.txt | 1 + .../data/mysql/pl-PL/optional/auth_val.sql | 45 + .../data/mysql/pl-PL/optional/auth_val.txt | 1 + .../optional/marc21_holdings_coded_values.sql | 145 + .../optional/marc21_holdings_coded_values.txt | 2 + .../data/mysql/pl-PL/optional/parameters.sql | 6 + .../data/mysql/pl-PL/optional/parameters.txt | 1 + .../pl-PL/optional/patron_categories.sql | 23 + .../pl-PL/optional/patron_categories.txt | 25 + .../mysql/pl-PL/optional/sample_budgets.sql | 11 + .../mysql/pl-PL/optional/sample_budgets.txt | 1 + .../mysql/pl-PL/optional/sample_holidays.sql | 4 + .../mysql/pl-PL/optional/sample_holidays.txt | 4 + .../mysql/pl-PL/optional/sample_itemtypes.sql | 8 + .../mysql/pl-PL/optional/sample_itemtypes.txt | 1 + .../mysql/pl-PL/optional/sample_labels.sql | 21 + .../mysql/pl-PL/optional/sample_labels.txt | 9 + .../mysql/pl-PL/optional/sample_libraries.sql | 19 + .../mysql/pl-PL/optional/sample_libraries.txt | 1 + .../data/mysql/pl-PL/optional/sample_news.sql | 3 + .../data/mysql/pl-PL/optional/sample_news.txt | 1 + .../sample_notices_message_attributes.sql | 10 + .../sample_notices_message_attributes.txt | 1 + .../sample_notices_message_transports.sql | 19 + .../sample_notices_message_transports.txt | 1 + .../mysql/pl-PL/optional/sample_patrons.sql | 52 + .../mysql/pl-PL/optional/sample_patrons.txt | 1 + .../pl-PL/optional/sample_z3950_servers.sql | 7 + .../pl-PL/optional/sample_z3950_servers.txt | 5 + 58 files changed, 48392 insertions(+) create mode 100755 installer/data/mysql/pl-PL/mandatory/class_sources.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/class_sources.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/message_transport_types.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/message_transport_types.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/sample_notices.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/sample_notices.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/stopwords.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/stopwords.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/subtag_registry.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/subtag_registry.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/sysprefs.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/sysprefs.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/userflags.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/userflags.txt create mode 100755 installer/data/mysql/pl-PL/mandatory/userpermissions.sql create mode 100755 installer/data/mysql/pl-PL/mandatory/userpermissions.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/authorities_normal_marc21.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_fastadd_framework.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_simple_bib_frameworks.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/authorities_normal_unimarc.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/authorities_normal_unimarc.txt create mode 100755 installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql create mode 100755 installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.txt create mode 100755 installer/data/mysql/pl-PL/optional/auth_val.sql create mode 100755 installer/data/mysql/pl-PL/optional/auth_val.txt create mode 100755 installer/data/mysql/pl-PL/optional/marc21_holdings_coded_values.sql create mode 100755 installer/data/mysql/pl-PL/optional/marc21_holdings_coded_values.txt create mode 100755 installer/data/mysql/pl-PL/optional/parameters.sql create mode 100755 installer/data/mysql/pl-PL/optional/parameters.txt create mode 100755 installer/data/mysql/pl-PL/optional/patron_categories.sql create mode 100755 installer/data/mysql/pl-PL/optional/patron_categories.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_budgets.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_budgets.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_holidays.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_holidays.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_itemtypes.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_itemtypes.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_labels.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_labels.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_libraries.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_libraries.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_news.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_news.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_notices_message_attributes.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_notices_message_transports.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_notices_message_transports.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_patrons.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_patrons.txt create mode 100755 installer/data/mysql/pl-PL/optional/sample_z3950_servers.sql create mode 100755 installer/data/mysql/pl-PL/optional/sample_z3950_servers.txt diff --git a/installer/data/mysql/pl-PL/mandatory/class_sources.sql b/installer/data/mysql/pl-PL/mandatory/class_sources.sql new file mode 100755 index 0000000000..2dddb74f3b --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/class_sources.sql @@ -0,0 +1,36 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- +-- Copyright (C) 2007 LiblimeA +-- +-- This file is part of Koha. +-- +-- Koha 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. +-- +-- Koha 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. +-- +-- You should have received a copy of the GNU General Public License along with +-- Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place, +-- Suite 330, Boston, MA 02111-1307 USA + +-- class sorting (filing) rules +INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES + ('dewey', 'Default filing rules for DDC', 'Dewey'), + ('lcc', 'Default filing rules for LCC', 'LCC'), + ('generic', 'Generic call number filing rules', 'Generic'); + + +-- classification schemes or sources +INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES + ('ddc', 'Dewey Decimal Classification', 1, 'dewey'), + ('lcc', 'Library of Congress Classification', 1, 'lcc'), + ('udc', 'Universal Decimal Classification', 0, 'generic'), + ('sudocs', 'SuDoc Classification (U.S. GPO)', 0, 'generic'), + ('anscr', 'ANSCR (Sound Recordings)', 0, 'generic'), + ('z', 'Other/Generic Classification Scheme', 0, 'generic'); diff --git a/installer/data/mysql/pl-PL/mandatory/class_sources.txt b/installer/data/mysql/pl-PL/mandatory/class_sources.txt new file mode 100755 index 0000000000..02690cb1e5 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/class_sources.txt @@ -0,0 +1 @@ +Domyślne źródła klasyfikacji i reguły wypełniania diff --git a/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql b/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql new file mode 100755 index 0000000000..517f5cc96c --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/message_transport_types.sql @@ -0,0 +1,5 @@ +INSERT INTO message_transport_types +(message_transport_type) +values +('email'), +('sms'); diff --git a/installer/data/mysql/pl-PL/mandatory/message_transport_types.txt b/installer/data/mysql/pl-PL/mandatory/message_transport_types.txt new file mode 100755 index 0000000000..b74c092f60 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/message_transport_types.txt @@ -0,0 +1 @@ +Określa domyślne typy transportu wiadomości. diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.sql b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql new file mode 100755 index 0000000000..a8739dab04 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.sql @@ -0,0 +1,14 @@ +INSERT INTO `letter` (module, code, name, title, content) +VALUES ('circulation','ODUE','Overdue Notice','Item Overdue',"Dear <> <>,\r\n\r\nAccording to our records, you have items that are overdue. Your library does not charge late fines, but please return or renew them as soon as possible.\r\n\r\n<>\n<>\n<>\n<>\n<>\n<>\n<>\r\n\r\nIf you have registered a password with the library, you may use it with your library card number to renew online. If an item becomes more than 30 days overdue, you will be unable to use your library card until the item is returned. The following item is currently overdue:\r\n\r\n<>"), +('claimacquisition','ACQCLAIM','Acquisition Claim','Item Not Received',"<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n<>\r\n\r\nOrdernumber <> (<>) (<> ordered) ($<> each) has not been received."), +('serial','RLIST','Routing List','Serial is now available','<> <>,\r\n\r\nThe following issue is now available:\r\n\r\n<>, <> (<>)\r\n\r\nPlease pick it up at your convenience.'), +('members','ACCTDETAILS','Account Details Template - DEFAULT','Your new Koha account details.','Hello <> <> <>.\r\n\r\nYour new Koha account details are:\r\n\r\nUser: <>\r\nPassword: <>\r\n\r\nIf you have any problems or questions regarding your account, please contact your Koha Administrator.\r\n\r\nThank you,\r\nKoha Administrator\r\nkohaadmin@yoursite.org'), +('circulation','DUE','Item Due Reminder','Item Due Reminder','Dear <> <>,\r\n\r\nThe following item is now due:\r\n\r\n<>, <> (<>)'), +('circulation','DUEDGST','Item Due Reminder (Digest)','Item Due Reminder','You have <> items due'), +('circulation','PREDUE','Advance Notice of Item Due','Advance Notice of Item Due','Dear <> <>,\r\n\r\nThe following item will be due soon:\r\n\r\n<>, <> (<>)' +), +('circulation','PREDUEDGST','Advance Notice of Item Due (Digest)','Advance Notice of Item Due','You have <> items due soon'), +('circulation','EVENT','Upcoming Library Event','Upcoming Library Event','Dear <> <>,\r\n\r\nThis is a reminder of an upcoming library event in which you have expressed interest.'), +('reserves', 'HOLD', 'Hold Available for Pickup', 'Hold Available for Pickup at <>', 'Dear <> <>,\r\n\r\nYou have a hold available for pickup as of <>:\r\n\r\nTitle: <>\r\nAuthor: <>\r\nCopy: <>\r\nLocation: <>\r\n<>\r\n<>\r\n<>\r\n<> <>'), +('circulation','CHECKIN','Item Check-in (Digest)','Check-ins','The following items have been checked in:\r\n----\r\n<>\r\n----\r\nThank you.'), +('circulation','CHECKOUT','Item Check-out (Digest)','Checkouts','The following items have been checked out:\r\n----\r\n<>\r\n----\r\nThank you for visiting <>.'); diff --git a/installer/data/mysql/pl-PL/mandatory/sample_notices.txt b/installer/data/mysql/pl-PL/mandatory/sample_notices.txt new file mode 100755 index 0000000000..edc0201bc7 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/sample_notices.txt @@ -0,0 +1 @@ +Przykładowe powiadomienia diff --git a/installer/data/mysql/pl-PL/mandatory/stopwords.sql b/installer/data/mysql/pl-PL/mandatory/stopwords.sql new file mode 100755 index 0000000000..1bf4725b68 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/stopwords.sql @@ -0,0 +1,99 @@ +INSERT INTO stopwords VALUES +('a'), +('about'), +('also'), +('an'), +('and'), +('another'), +('any'), +('are'), +('as'), +('at'), +('back'), +('be'), +('because'), +('been'), +('being'), +('but'), +('by'), +('can'), +('could'), +('did'), +('do'), +('each'), +('end'), +('even'), +('for'), +('from'), +('get'), +('go'), +('had'), +('have'), +('he'), +('her'), +('here'), +('his'), +('how'), +('i'), +('if'), +('in'), +('into'), +('is'), +('it'), +('just'), +('may'), +('me'), +('might'), +('much'), +('must'), +('my'), +('no'), +('not'), +('of'), +('off'), +('on'), +('only'), +('or'), +('other'), +('our'), +('out'), +('should'), +('so'), +('some'), +('still'), +('such'), +('than'), +('that'), +('the'), +('their'), +('them'), +('then'), +('there'), +('these'), +('they'), +('this'), +('those'), +('to'), +('too'), +('try'), +('two'), +('under'), +('up'), +('us'), +('was'), +('we'), +('were'), +('what'), +('when'), +('where'), +('which'), +('while'), +('who'), +('why'), +('will'), +('with'), +('within'), +('without'), +('would'), +('you'), +('your'); diff --git a/installer/data/mysql/pl-PL/mandatory/stopwords.txt b/installer/data/mysql/pl-PL/mandatory/stopwords.txt new file mode 100755 index 0000000000..b4e17d8039 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/stopwords.txt @@ -0,0 +1 @@ +Angielskie stop words. Możesz je zmienić po intalacji. diff --git a/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql new file mode 100755 index 0000000000..3b63cd9726 --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/subtag_registry.sql @@ -0,0 +1,722 @@ +-- http://www.w3.org/International/articles/language-tags/ + +-- BIDI Stuff, Arabic and Hebrew +INSERT INTO language_script_bidi(rfc4646_subtag,bidi) +VALUES( 'Arab', 'rtl'); +INSERT INTO language_script_bidi(rfc4646_subtag,bidi) +VALUES( 'Hebr', 'rtl'); + +-- Default mappings between script and language subcodes +INSERT INTO language_script_mapping(language_subtag,script_subtag) +VALUES( 'ar', 'Arab'); +INSERT INTO language_script_mapping(language_subtag,script_subtag) +VALUES( 'he', 'Hebr'); + +-- EXTENSIONS +-- Interface (i) +-- SELECT * FROM language_subtag_registry WHERE type='i'; +-- OPAC +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'opac', 'i', 'OPAC','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'opac', 'i', 'en', 'OPAC'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'opac', 'i', 'fr', 'OPAC'); + +-- Staff Client +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'intranet', 'i', 'Staff Client','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'intranet', 'i', 'en', 'Staff Client'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'intranet', 'i', 'fr', '????'); + +-- Theme (t) +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'prog', 't', 'Prog','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'prog', 't', 'en', 'Prog'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'prog', 't', 'fr', 'Prog'); + +-- LANGUAGES + +-- Arabic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ar', 'language', 'Arabic','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ar','ara'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'ar', 'language', 'ar', 'العربية'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ar', 'language', 'en', 'Arabic'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ar', 'language', 'fr', 'Arabe'); + +-- Armenian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hy', 'language', 'Armenian','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hy','hy'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'hy', 'language', 'hy', 'Հայերէն'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hy', 'language', 'en', 'Armenian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hy', 'language', 'fr', 'Armenian'); + +-- Bulgarian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'bg', 'language', 'Bulgarian','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'bg','bul'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'bg', 'language', 'bg', 'Български'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'bg', 'language', 'en', 'Bulgarian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'bg', 'language', 'fr', 'Bulgare'); + +-- Chinese +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'zh', 'language', 'Chinese','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'zh','chi'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'zh', 'language', 'zh', '中文'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'zh', 'language', 'en', 'Chinese'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'zh', 'language', 'fr', 'Chinois'); + +-- Czech +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'cs', 'language', 'Czech','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'cs','cze'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'cs', 'language', 'cs', 'čeština'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'cs', 'language', 'en', 'Czech'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'cs', 'language', 'fr', 'Tchèque'); + +-- Danish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'da', 'language', 'Danish','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'da','dan'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'da', 'language', 'da', 'Dænsk'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'da', 'language', 'en', 'Danish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'da', 'language', 'fr', 'Danois'); + +-- Dutch, Flemish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'nl', 'language', 'Dutch','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'nl','dut'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'nl', 'language', 'nl', 'nedərlɑns'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'nl', 'language', 'en', 'Dutch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'nl', 'language', 'fr', 'Néerlandais'); + +-- English +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'en', 'language', 'English','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'en','en'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'en', 'language', 'en', 'English'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'en', 'language', 'fr', 'Anglais'); + +-- English +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'fi', 'language', 'Finnish','2005-10-16' ); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fi', 'language', 'fi', 'suomi'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fi', 'language', 'en', 'Finnish'); + +-- French +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'fr', 'language', 'French','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'fr','fr'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fr', 'language', 'en', 'French'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fr', 'language', 'fr', 'Français'); + +-- INSERT INTO language_descriptions(subtag, type, lang, description) +-- VALUES( 'fr-CA', 'language', 'fr-CA', 'français'); + +-- Lao +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'lo', 'language', 'Lao','2005-10-16' ); + +-- INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +-- VALUES( 'lo','nor'); ??? + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'lo', 'language', 'lo', 'ພາສາລາວ'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'lo', 'language', 'en', 'Lao'); + +-- German +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'de', 'language', 'German','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'de','ger'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'de', 'language', 'de', 'Deutsch'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'de', 'language', 'en', 'German'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'de', 'language', 'fr', 'Allemand'); + +-- Greek +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'el', 'language', 'Greek, Modern [1453- ]','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'el','gre'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'el', 'language', 'el', 'ελληνικά'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'el', 'language', 'en', 'Greek, Modern [1453- ]'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'el', 'language', 'fr', 'Grec Moderne (Après 1453)'); + +-- Hebrew +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'he', 'language', 'Hebrew','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'he','heb'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'he', 'language', 'he', 'עברית'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'he', 'language', 'en', 'Hebrew'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'he', 'language', 'fr', 'Hébreu'); + +-- Hindi +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hi', 'language', 'Hindi','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hi','hin'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hi', 'language', 'hi', 'हिन्दी'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hi', 'language', 'en', 'Hindi'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hi', 'language', 'fr', 'Hindi'); + +-- Hungarian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'hu', 'language', 'Hungarian','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'hu','hun'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hu', 'language', 'hu', 'Magyar'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hu', 'language', 'en', 'Hungarian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'hu', 'language', 'fr', 'Hongrois'); + +-- Indonesian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'id', 'language', 'Indonesian','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'id','ind'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'id', 'language', 'id', 'Bahasa Indonesia'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'id', 'language', 'en', 'Indonesian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'id', 'language', 'fr', 'Indonésien'); + +-- Italian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'it', 'language', 'Italian','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'it','ind'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'it', 'language', 'it', 'Italiano'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'it', 'language', 'en', 'Italian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'it', 'language', 'fr', 'Italien'); + +-- Japanese +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ja', 'language', 'Japanese','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ja','jpn'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ja', 'language', 'ja', '日本語'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ja', 'language', 'en', 'Japanese'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ja', 'language', 'fr', 'Japonais'); + +-- Korean +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ko', 'language', 'Korean','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ko','kor'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ko', 'language', 'ko', '한국어'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ko', 'language', 'en', 'Korean'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ko', 'language', 'fr', 'Coréen'); + +-- Latin +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'la', 'language', 'Latin','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'la','lat'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'la', 'language', 'la', 'Latina'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'la', 'language', 'en', 'Latin'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'la', 'language', 'fr', 'Latin'); + +-- Galacian + +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'gl', 'language', 'Galician','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'gl','glg'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'gl', 'language', 'gl', 'Galego'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'gl', 'language', 'en', 'Galician'); + +-- Norwegian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'nb', 'language', 'Norwegian','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'nb','nor'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'nb', 'language', 'nb', 'Norsk'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'nb', 'language', 'en', 'Norwegian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'nb', 'language', 'fr', 'Norvégien'); + +-- Persian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'fa', 'language', 'Persian','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'fa','per'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fa', 'language', 'fa', 'فارسى'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fa', 'language', 'en', 'Persian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'fa', 'language', 'fr', 'Persan'); + +-- Polish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'pl', 'language', 'Polish','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'pl','pol'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'pl', 'language', 'pl', 'Polski'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'pl', 'language', 'en', 'Polish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'pl', 'language', 'fr', 'Polonais'); + +-- Portuguese +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'pt', 'language', 'Portuguese','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'pt','pol'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'pt', 'language', 'pt', 'Português'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'pt', 'language', 'en', 'Portuguese'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'pt', 'language', 'fr', 'Portugais'); + +-- Romanian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ro', 'language', 'Romanian','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ro','rum'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ro', 'language', 'ro', 'Română'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ro', 'language', 'en', 'Romanian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ro', 'language', 'fr', 'Roumain'); + +-- Russian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ru', 'language', 'Russian','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'ru','rus'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ru', 'language', 'ru', 'Русский'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ru', 'language', 'en', 'Russian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ru', 'language', 'fr', 'Russe'); + +-- Serbian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sr', 'language', 'Serbian','2005-10-16' ); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'sr', 'language', 'sr', 'српски'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'sr', 'language', 'en', 'Serbian'); + +-- Spanish, Castilian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'es', 'language', 'Spanish','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'es','spa'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'es', 'language', 'es', 'Español'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'es', 'language', 'en', 'Spanish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'es', 'language', 'fr', 'Espagnol'); + +-- Swedish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'sv', 'language', 'Swedish','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'sv','swe'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'sv', 'language', 'sv', 'Svenska'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'sv', 'language', 'en', 'Swedish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'sv', 'language', 'fr', 'Suédois'); + +-- Tetum +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'tet', 'language', 'Tetum','2005-10-16' ); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'tet', 'language', 'tet', 'tetun'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'tet', 'language', 'en', 'Tetum'); + +-- Thai +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'th', 'language', 'Thai','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'th','tha'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'th', 'language', 'th', 'ภาษาไทย'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'th', 'language', 'en', 'Thai'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'th', 'language', 'fr', 'Thaï'); + +-- Turkish +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'tr', 'language', 'Turkish','2005-10-16' ); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'tr','tur'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'tr', 'language', 'tr', 'Türkçe'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'tr', 'language', 'en', 'Turkish'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'tr', 'language', 'fr', 'Turc'); + + +-- Ukranian +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'uk', 'language', 'Ukranian','2005-10-16'); + +INSERT INTO language_rfc4646_to_iso639(rfc4646_subtag,iso639_2_code) +VALUES( 'uk','ukr'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'uk', 'language', 'uk', 'Українська'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'uk', 'language', 'en', 'Ukranian'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'uk', 'language', 'fr', 'Ukrainien'); + +-- English +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'ur', 'language', 'Urdu','2005-10-16' ); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ur', 'language', 'en', 'Urdu'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'ur', 'language', 'ur', 'اردو'); + +-- SCRIPTS +-- Arabic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Arab', 'script', 'Arabic','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Arab','script', 'Arab', 'العربية'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Arab', 'script','en', 'Arabic'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Arab', 'script','fr', 'Arabic'); + +-- Cyrillic +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Cyrl', 'script', 'Cyrillic','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Cyrl', 'script', 'Cyrl', '????'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Cyrl', 'script', 'en', 'Cyrillic'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Cyrl', 'script', 'fr', 'Cyrillic'); + +-- Greek +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Grek', 'script', 'Greek','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Grek', 'script', 'Grek', '????'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Grek', 'script', 'en', 'Greek'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Grek', 'script', 'fr', 'Greek'); + +-- Han - Simplified +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Hans', 'script', 'Han (Simplified variant)','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Hans', 'script', 'Hans', 'Han (Simplified variant)'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hans', 'script', 'en', 'Han (Simplified variant)'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hans', 'script', 'fr', 'Han (Simplified variant)'); + +-- Han - Traditional +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Hant', 'script', 'Han (Traditional variant)','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Hant', 'script', 'Hant', 'Han (Traditional variant)'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hant', 'script', 'en', 'Han (Traditional variant)'); + +-- Hebrew +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Hebr', 'script', 'Hebrew','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Hebr', 'script', 'Hebr', 'Hebrew'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Hebr', 'script', 'en', 'Hebrew'); + +-- Lao +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'Laoo', 'script', 'Lao','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'Laoo', 'script', 'lo', 'Lao'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'Laoo', 'script', 'en', 'Lao'); + +-- REGIONS +-- Canada +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'CA', 'region', 'Canada','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'CA', 'region', 'en', 'Canada'); + +-- Denmark +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'DK', 'region', 'Denmark','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'DK', 'region', 'dk', 'Danmark'); + +-- France +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'FR', 'region', 'France','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES ( 'FR', 'region', 'fr', 'France'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'FR', 'region', 'en', 'France'); + +-- New Zealand +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'NZ', 'region', 'New Zealand','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'NZ', 'region', 'en', 'New Zealand'); + +-- United Kingdom +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'GB', 'region', 'United Kingdom','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'GB', 'region', 'en', 'United Kingdom'); + +-- United States +INSERT INTO language_subtag_registry( subtag, type, description, added) +VALUES ( 'US', 'region', 'United States','2005-10-16'); + +INSERT INTO language_descriptions(subtag, type, lang, description) +VALUES( 'US', 'region', 'en', 'United States'); diff --git a/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt b/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt new file mode 100755 index 0000000000..5d3c96d45e --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/subtag_registry.txt @@ -0,0 +1,5 @@ +Wsparcie Koha dla I18N + +Tłumaczenia dwukierunkowe, arabski i and hebrajski +Domyślne mapowania pomiędzy skryptem a subkodami języków +Rozszerzenia języków diff --git a/installer/data/mysql/pl-PL/mandatory/sysprefs.sql b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql new file mode 100755 index 0000000000..a0ca7a8c1e --- /dev/null +++ b/installer/data/mysql/pl-PL/mandatory/sysprefs.sql @@ -0,0 +1,275 @@ +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('acquisitions','normal','Choose Normal, budget-based acquisitions, or Simple bibliographic-data acquisitions','simple|normal','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('advancedMARCeditor',0,"If ON, the MARC editor won\'t display field/subfield descriptions",'','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('AllowHoldDateInFuture','0','If set a date field is displayed on the Hold screen of the Staff Interface, allowing the hold date to be set in the future.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACAllowHoldDateInFuture','0','If set, along with the AllowHoldDateInFuture system preference, OPAC users can set the date of a hold to be in the future.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonEnabled',0,'Turn ON Amazon Content - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonReviews',0,'Display Amazon review on staff interface - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonSimilarItems',0,'Turn ON Amazon Similar Items feature - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACAmazonEnabled',0,'Turn ON Amazon Content in the OPAC - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACAmazonSimilarItems',0,'Turn ON Amazon Similar Items feature - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US|CA|DE|FR|JP|UK','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('Babeltheque',0,'Turn ON Babeltheque content - See babeltheque.com to subscribe to this service','','YesNo'); + +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode','OFF','Used to autogenerate a barcode: incremental will be of the form 1, 2, 3; annual of the form 2007-0001, 2007-0002; hbyymmincr of the form HB08010001 where HB=Home Branch','incremental|annual|hbyymmincr|OFF','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutoLocation',0,'If ON, IP authentication is enabled, blocking access to the staff client from unauthorized IP addresses',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AutomaticItemReturn',1,'If ON, Koha will automatically set up a transfer of this item to its homebranch',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoMemberNum',1,'If ON, patron number is auto-calculated','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BiblioDefaultView','normal','Choose the default detail view in the catalog; choose between normal, marc or isbd','normal|marc|isbd','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BorrowerMandatoryField','zipcode|surname|cardnumber','Choose the mandatory fields for a patron\'s account',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('borrowerRelationship','father|mother','Define valid relationships between a guarantor & a guarantee (separated by | or ,)','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BorrowersLog',1,'If ON, log edit/create/delete actions on patron data',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('casAuthentication', '0', 'Enable or disable CAS authentication', '', 'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('casLogout', '0', 'Does a logout from Koha should also log the user out of CAS?', '', 'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('casServerUrl', 'https://localhost:8443/cas', 'URL of the cas server', '', 'Free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('CataloguingLog',1,'If ON, log edit/create/delete actions on bibliographic data. WARNING: this feature is very resource consuming.',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('checkdigit','none','If ON, enable checks on patron cardnumber: none or \"Katipo\" style checks','none|katipo','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('delimiter',';','Define the default separator character for exporting reports',';|tabulation|,|/|\\|#|\|','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('EnhancedMessagingPreferences',0,'If ON, allows patrons to select to receive additional messages about items due or nearly due.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('expandedSearchOption',0,'If ON, set advanced search to be expanded by default',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('FinesLog',1,'If ON, log fines',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('hidelostitems',0,'If ON, disables display of\"lost\" items in OPAC.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('hide_marc',0,'If ON, disables display of MARC fields, subfield codes & indicators (still shows data)',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IndependantBranches',0,'If ON, increases security between libraries',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('insecure',0,'If ON, bypasses all authentication. Be careful!',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetBiblioDefaultView','normal','Choose the default detail view in the staff interface; choose between normal, labeled_marc, marc or isbd','normal|marc|isbd|labeled_marc','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetcolorstylesheet','','Define the color stylesheet to use in the Staff Client','50','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetmainUserblock','','Add a block of HTML that will display on the intranet home page','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetNav','','Use HTML tabs to add navigational links to the top-hand navigational bar in the Staff Client','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetreadinghistory',1,'If ON, Reading History is enabled for all patrons','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetstylesheet','','Enter a complete URL to use an alternate layout stylesheet in Intranet','50','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetuserjs','','Custom javascript for inclusion in Intranet','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranet_includes','includes','The includes directory you want for specific look of Koha (includes or includes_npl for example)',NULL,'Free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ISBD','#100||{ 100a }{ 100b }{ 100c }{ 100d }{ 110a }{ 110b }{ 110c }{ 110d }{ 110e }{ 110f }{ 110g }{ 130a }{ 130d }{ 130f }{ 130g }{ 130h }{ 130k }{ 130l }{ 130m }{ 130n }{ 130o }{ 130p }{ 130r }{ 130s }{ 130t }|

\r\n#245||{ 245a }{ 245b }{245f }{ 245g }{ 245k }{ 245n }{ 245p }{ 245s }{ 245h }|\r\n#246||{ : 246i }{ 246a }{ 246b }{ 246f }{ 246g }{ 246n }{ 246p }{ 246h }|\r\n#242||{ = 242a }{ 242b }{ 242n }{ 242p }{ 242h }|\r\n#245||{ 245c }|\r\n#242||{ = 242c }|\r\n#250| - |{ 250a }{ 250b }|\r\n#254|, |{ 254a }|\r\n#255|, |{ 255a }{ 255b }{ 255c }{ 255d }{ 255e }{ 255f }{ 255g }|\r\n#256|, |{ 256a }|\r\n#257|, |{ 257a }|\r\n#258|, |{ 258a }{ 258b }|\r\n#260| - |{ 260a }{ 260b }{ 260c }|\r\n#300| - |{ 300a }{ 300b }{ 300c }{ 300d }{ 300e }{ 300f }{ 300g }|\r\n#306| - |{ 306a }|\r\n#307| - |{ 307a }{ 307b }|\r\n#310| - |{ 310a }{ 310b }|\r\n#321| - |{ 321a }{ 321b }|\r\n#340| - |{ 3403 }{ 340a }{ 340b }{ 340c }{ 340d }{ 340e }{ 340f }{ 340h }{ 340i }|\r\n#342| - |{ 342a }{ 342b }{ 342c }{ 342d }{ 342e }{ 342f }{ 342g }{ 342h }{ 342i }{ 342j }{ 342k }{ 342l }{ 342m }{ 342n }{ 342o }{ 342p }{ 342q }{ 342r }{ 342s }{ 342t }{ 342u }{ 342v }{ 342w }|\r\n#343| - |{ 343a }{ 343b }{ 343c }{ 343d }{ 343e }{ 343f }{ 343g }{ 343h }{ 343i }|\r\n#351| - |{ 3513 }{ 351a }{ 351b }{ 351c }|\r\n#352| - |{ 352a }{ 352b }{ 352c }{ 352d }{ 352e }{ 352f }{ 352g }{ 352i }{ 352q }|\r\n#362| - |{ 362a }{ 351z }|\r\n#440| - |{ 440a }{ 440n }{ 440p }{ 440v }{ 440x }|.\r\n#490| - |{ 490a }{ 490v }{ 490x }|.\r\n#800| - |{ 800a }{ 800b }{ 800c }{ 800d }{ 800e }{ 800f }{ 800g }{ 800h }{ 800j }{ 800k }{ 800l }{ 800m }{ 800n }{ 800o }{ 800p }{ 800q }{ 800r }{ 800s }{ 800t }{ 800u }{ 800v }|.\r\n#810| - |{ 810a }{ 810b }{ 810c }{ 810d }{ 810e }{ 810f }{ 810g }{ 810h }{ 810k }{ 810l }{ 810m }{ 810n }{ 810o }{ 810p }{ 810r }{ 810s }{ 810t }{ 810u }{ 810v }|.\r\n#811| - |{ 811a }{ 811c }{ 811d }{ 811e }{ 811f }{ 811g }{ 811h }{ 811k }{ 811l }{ 811n }{ 811p }{ 811q }{ 811s }{ 811t }{ 811u }{ 811v }|.\r\n#830| - |{ 830a }{ 830d }{ 830f }{ 830g }{ 830h }{ 830k }{ 830l }{ 830m }{ 830n }{ 830o }{ 830p }{ 830r }{ 830s }{ 830t }{ 830v }|.\r\n#500|

|{ 5003 }{ 500a }|\r\n#501|\

|{ 501a }|\r\n#502|

|{ 502a }|\r\n#504|

|{ 504a }|\r\n#505|

|{ 505a }{ 505t }{ 505r }{ 505g }{ 505u }|\r\n#506|

|{ 5063 }{ 506a }{ 506b }{ 506c }{ 506d }{ 506u }|\r\n#507|

|{ 507a }{ 507b }|\r\n#508|

|{ 508a }{ 508a }|\r\n#510|

|{ 5103 }{ 510a }{ 510x }{ 510c }{ 510b }|\r\n#511|

|{ 511a }|\r\n#513|

|{ 513a }{513b }|\r\n#514|

|{ 514z }{ 514a }{ 514b }{ 514c }{ 514d }{ 514e }{ 514f }{ 514g }{ 514h }{ 514i }{ 514j }{ 514k }{ 514m }{ 514u }|\r\n#515|

|{ 515a }|\r\n#516|

|{ 516a }|\r\n#518|

|{ 5183 }{ 518a }|\r\n#520|

|{ 5203 }{ 520a }{ 520b }{ 520u }|\r\n#521|

|{ 5213 }{ 521a }{ 521b }|\r\n#522|

|{ 522a }|\r\n#524|

|{ 524a }|\r\n#525|

|{ 525a }|\r\n#526|

|{\\n510i }{\\n510a }{ 510b }{ 510c }{ 510d }{\\n510x }|\r\n#530|

|{\\n5063 }{\\n506a }{ 506b }{ 506c }{ 506d }{\\n506u }|\r\n#533|

|{\\n5333 }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }|\r\n#534|

|{\\n533p }{\\n533a }{\\n533b }{\\n533c }{\\n533d }{\\n533e }{\\n533f }{\\n533m }{\\n533n }{\\n533t }{\\n533x }{\\n533z }|\r\n#535|

|{\\n5353 }{\\n535a }{\\n535b }{\\n535c }{\\n535d }|\r\n#538|

|{\\n5383 }{\\n538a }{\\n538i }{\\n538u }|\r\n#540|

|{\\n5403 }{\\n540a }{ 540b }{ 540c }{ 540d }{\\n520u }|\r\n#544|

|{\\n5443 }{\\n544a }{\\n544b }{\\n544c }{\\n544d }{\\n544e }{\\n544n }|\r\n#545|

|{\\n545a }{ 545b }{\\n545u }|\r\n#546|

|{\\n5463 }{\\n546a }{ 546b }|\r\n#547|

|{\\n547a }|\r\n#550|

|{ 550a }|\r\n#552|

|{ 552z }{ 552a }{ 552b }{ 552c }{ 552d }{ 552e }{ 552f }{ 552g }{ 552h }{ 552i }{ 552j }{ 552k }{ 552l }{ 552m }{ 552n }{ 562o }{ 552p }{ 552u }|\r\n#555|

|{ 5553 }{ 555a }{ 555b }{ 555c }{ 555d }{ 555u }|\r\n#556|

|{ 556a }{ 506z }|\r\n#563|

|{ 5633 }{ 563a }{ 563u }|\r\n#565|

|{ 5653 }{ 565a }{ 565b }{ 565c }{ 565d }{ 565e }|\r\n#567|

|{ 567a }|\r\n#580|

|{ 580a }|\r\n#581|

|{ 5633 }{ 581a }{ 581z }|\r\n#584|

|{ 5843 }{ 584a }{ 584b }|\r\n#585|

|{ 5853 }{ 585a }|\r\n#586|

|{ 5863 }{ 586a }|\r\n#020|

|{ 020a }{ 020c }|\r\n#022|\ +

|{ 022a }|\r\n#222| = |{ 222a }{ 222b }|\r\n#210| = |{ 210a }{ 210b }|\r\n#024|

|{ 024a }{ 024c }{ 024d }{ 0242 }|\r\n#027|

|{ 027a }|\r\n#028|

|{ 028a }{ 028b }|\r\n#013|

|{ 013a }{ 013b }{ 013c }{ 013d }{ 013e }{ 013f }|\r\n#030|

|{ 030a }|\r\n#037|

|{ 037a }{ 037b }{ 037c }{ 037f }{ 037g }{ 037n }|\r\n#010|

|{ 010a }|\r\n#015|

|{ 015a }{ 0152 }|\r\n#016|

|{ 016a }{ 0162 }|\r\n#600|

|{\\n6003 }{\\n600a}{ 600b }{ 600c }{ 600d }{ 600e }{ 600f }{ 600g }{ 600h }{--600k}{ 600l }{ 600m }{ 600n }{ 600o }{--600p}{ 600r }{ 600s }{ 600t }{ 600u }{--600x}{--600z}{--600y}{--600v}|\r\n#610|

|{\\n6103 }{\\n610a}{ 610b }{ 610c }{ 610d }{ 610e }{ 610f }{ 610g }{ 610h }{--610k}{ 610l }{ 610m }{ 610n }{ 610o }{--610p}{ 610r }{ 610s }{ 610t }{ 610u }{--610x}{--610z}{--610y}{--610v}|\r\n#611|

|{\\n6113 }{\\n611a}{ 611b }{ 611c }{ 611d }{ 611e }{ 611f }{ 611g }{ 611h }{--611k}{ 611l }{ 611m }{ 611n }{ 611o }{--611p}{ 611r }{ 611s }{ 611t }{ 611u }{--611x}{--611z}{--611y}{--611v}|\r\n#630|

|{\\n630a}{ 630b }{ 630c }{ 630d }{ 630e }{ 630f }{ 630g }{ 630h }{--630k }{ 630l }{ 630m }{ 630n }{ 630o }{--630p}{ 630r }{ 630s }{ 630t }{--630x}{--630z}{--630y}{--630v}|\r\n#648|

|{\\n6483 }{\\n648a }{--648x}{--648z}{--648y}{--648v}|\r\n#650|

|{\\n6503 }{\\n650a}{ 650b }{ 650c }{ 650d }{ 650e }{--650x}{--650z}{--650y}{--650v}|\r\n#651|

|{\\n6513 }{\\n651a}{ 651b }{ 651c }{ 651d }{ 651e }{--651x}{--651z}{--651y}{--651v}|\r\n#653|

|{ 653a }|\r\n#654|

|{\\n6543 }{\\n654a}{--654b}{--654x}{--654z}{--654y}{--654v}|\r\n#655|

|{\\n6553 }{\\n655a}{--655b}{--655x }{--655z}{--655y}{--655v}|\r\n#656|

|{\\n6563 }{\\n656a}{--656k}{--656x}{--656z}{--656y}{--656v}|\r\n#657|

|{\\n6573 }{\\n657a}{--657x}{--657z}{--657y}{--657v}|\r\n#658|

|{\\n658a}{--658b}{--658c}{--658d}{--658v}|\r\n#050|

|{ 050a }{ / 050b }|\r\n#082|

|{ 082a }{ / 082b }|\r\n#080|

|{ 080a }{ 080x }{ / 080b }|\r\n#070|

|{ 070a }{ / 070b }|\r\n#060|

|{ 060a }{ / 060b }|\r\n#074|

|{ 074a }|\r\n#086|

|{ 086a }|\r\n#088|

|{ 088a }|','ISBD','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IssueLog',1,'If ON, log checkout activity',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IssuingInProcess',0,'If ON, disables fines if the patron is issuing item that accumulate debt',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('item-level_itypes',1,'If ON, enables Item-level Itemtype / Issuing Rules','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('itemcallnumber','082ab','The MARC field/subfield that is used to calculate the itemcallnumber (Dewey would be 082ab or 092ab; LOC would be 050ab or 090ab) could be 852hi from an item record',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('DefaultClassificationSource','ddc','Default classification scheme used by the collection. E.g., Dewey, LCC, etc.', NULL,'ClassSources'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('KohaAdminEmailAddress','root@localhost','Define the email address where patron modification requests are sent','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('kohaspsuggest','','Track search queries, turn on by defining host:dbname:user:pass','',''); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('LabelMARCView','standard','Define how a MARC record will display','standard|economical','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('LetterLog',1,'If ON, log all notices sent',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('LibraryName','','Podaj nazwę biblioteki która ma być wyświetlana w OPAC','',''); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('marc',1,'Turn on MARC support',NULL,'YesNo'); + +-- this is selected by the web installer now +-- INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('marcflavour','MARC21','Define global MARC flavor (MARC21 or UNIMARC) used for character encoding','MARC21|UNIMARC','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MARCOrgCode','OSt','Define MARC Organization Code - http://www.loc.gov/marc/organizations/orgshome.html','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MaxFine',9999,'Maximum fine a patron can have for a single late return','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('maxoutstanding',5,'maximum amount withstanding to be able make holds','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('maxreserves',50,'Define maximum number of holds a patron can place','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('memberofinstitution',0,'If ON, patrons can be linked to institutions',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('MIME','EXCEL','Define the default application for exporting report data','EXCEL|OPENOFFICE.ORG','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('noissuescharge',5,'Define maximum amount withstanding before check outs are blocked','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('NotifyBorrowerDeparture',30,'Define number of days before expiry where circulation is warned about patron account expiry',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacAuthorities',1,'If ON, enables the search authorities link on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacbookbag',1,'If ON, enables display of Cart feature','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacBrowser',0,'If ON, enables subject authorities browser on OPAC (needs to set misc/cronjob/sbuild_browser_and_cloud.pl)',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacCloud',0,'If ON, enables subject cloud on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaccolorstylesheet','colors.css','Define the color stylesheet to use in the OPAC','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaccredits','','Define HTML Credits at the bottom of the OPAC page','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacSerialDefaultTab', 'subscriptions', 'Define the default tab for serials in OPAC.', 'holdings|serialcollection|subscriptions', 'Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacheader','','Add HTML to be included as a custom header in the OPAC','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclayoutstylesheet','opac.css','Enter the name of the layout CSS stylesheet to use in the OPAC','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMaintenance',0,'If ON, enables maintenance warning in OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacMainUserBlock','Welcome to Koha...\r\n
','A user-defined block of HTML in the main content area of the opac main page','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Important links here.','Use HTML tags to add navigational links to the left-hand navigational bar in OPAC','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacPasswordChange',1,'If ON, enables patron-initiated password change in OPAC (disable it when using LDAP auth)',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacreadinghistory',1,'If ON, enables display of Patron Circulation History in OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacsmallimage','','Enter a complete URL to an image to replace the default Koha logo','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacstylesheet','','Enter a complete URL to use an alternate layout stylesheet in OPAC','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacthemes','prog','Define the current theme for the OPAC interface.','','Themes'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacTopissue',0,'If ON, enables the \'most popular items\' link on OPAC. Warning, this is an EXPERIMENTAL feature, turning ON may overload your server',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacuserjs','','Define custom javascript for inclusion in OPAC','70|10','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opacuserlogin',1,'Enable or disable display of user login features',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('patronimages',0,'Enable patron images for the Staff Client',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('printcirculationslips',1,'If ON, enable printing circulation receipts','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('RequestOnOpac',1,'If ON, globally enables patron holds on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReservesMaxPickUpDelay',7,'Define the Maximum delay to pick up an item on hold','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReturnBeforeExpiry',0,'If ON, checkout will be prevented if returndate is after patron card expiry',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReturnLog',1,'If ON, enables the circulation (returns) log',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('reviewson',1,'If ON, enables patron reviews of bibliographic records in the OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('sortbynonfiling',0,'Sort search results by MARC nonfiling characters (deprecated)',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SpecifyDueDate',1,'Define whether to display \"Specify Due Date\" form in Circulation','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SubscriptionHistory',';','Define the display preference for serials issue history in OPAC','simplified|full','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SubscriptionLog',1,'If ON, enables subscriptions log',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('suggestion',1,'If ON, enables patron suggestions feature in OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('template','prog','Define the preferred staff interface template','','Themes'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('TemplateEncoding','utf-8','Globally define the default character encoding','iso-8859-1|utf-8','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('timeout',12000000,'Inactivity timeout for cookies authentication (in seconds)',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('TransfersMaxDaysWarning',3,'Define the days before a transfer is suspected of having a problem',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('useDaysMode','Calendar','Choose the method for calculating due date: select Calendar to use the holidays module, and Days to ignore the holidays module','Calendar|Days|Datedue','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('virtualshelves',1,'If ON, enables Lists management','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('z3950AuthorAuthFields','701,702,700','Define the MARC biblio fields for Personal Name Authorities to fill biblio.author',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('z3950NormalizeAuthor',0,'If ON, Personal Name Authorities will replace authors in biblio.author','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReservesNeedReturns',1,'If ON, a hold placed on an item available in this library must be checked-in, otherwise, a hold on a specific item, that is in the library & available is considered available','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DebugLevel',2,'Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','0|1|2','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('NoZebra',1,'If ON, Zebra indexing is turned off, simpler setup, but slower searches. WARNING: using NoZebra on even modest sized collections is very slow.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('SessionStorage','mysql','Use database or a temporary file for storing session data','mysql|Pg|tmp','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CircAutocompl',1,'If ON, autocompletion is enabled for the Circulation input',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('RoutingSerials',1,'If ON, serials routing is enabled',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('SearchMyLibraryFirst',0,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('dontmerge',1,'If ON, modifying an authority record will not update all associated bibliographic records immediately, ask your system administrator to enable the merge_authorities.pl cron job',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('BiblioAddsAuthorities',0,'If ON, adding a new biblio will check for an existing authority record and create one on the fly if one doesn\'t exist',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('QueryStemming',1,'If ON, enables query stemming',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('QueryFuzzy',1,'If ON, enables fuzzy option for searches',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('QueryWeightFields',1,'If ON, enables field weighting',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('yuipath','local','Insert the path to YUI libraries, choose local if you use koha offline',"local|http://yui.yahooapis.com/2.5.1/build",'Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('canreservefromotherbranches',1,'With Independent branches on, can a user from one library place a hold on an item from another library','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('FRBRizeEditions',0,'If ON, Koha will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACFRBRizeEditions',0,'If ON, the OPAC will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('XISBN',0,'Use with FRBRizeEditions. If ON, Koha will use the OCLC xISBN web service in the Editions tab on the detail pages. See: http://www.worldcat.org/affiliate/webservices/xisbn/app.jsp','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OCLCAffiliateID','','Use with FRBRizeEditions and XISBN. You can sign up for an AffiliateID here: http://www.worldcat.org/wcpa/do/AffiliateUserServices?method=initSelfRegister','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('XISBNDailyLimit',499,'The xISBN Web service is free for non-commercial use when usage does not exceed 500 requests per day','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('PINESISBN',0,'Use with FRBRizeEditions. If ON, Koha will use PINES OISBN web service in the Editions tab on the detail pages.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('ThingISBN',0,'Use with FRBRizeEditions. If ON, Koha will use the ThingISBN web service in the Editions tab on the detail pages.','','YesNo'); + +-- I18N/L10N +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('dateformat','us','Define global date format (us mm/dd/yyyy, metric dd/mm/yyy, ISO yyyy/mm/dd)','metric|us|iso','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclanguages','en','Set the default language in the OPAC.',NULL,'Languages'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('opaclanguagesdisplay',0,'If ON, enables display of Change Language feature on OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('BorrowersTitles','Mr|Mrs|Miss|Ms','Define appropriate Titles for patrons',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('gist',0,'Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST','','Integer'); +-- need AddressType to distinguish between US and other, telephone numbers, maori stuff, sex, nationality, etc. +-- LDAP ? required fields? +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('WebBasedSelfCheck',0,'If ON, enables the web-based self-check system',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('numSearchResults',20,'Specify the maximum number of results to display on a page of results',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACnumSearchResults',20,'Specify the maximum number of results to display on a page of results',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('defaultSortField',NULL,'Specify the default field used for sorting','relevance|popularity|call_number|pubdate|acqdate|title|author','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('defaultSortOrder',NULL,'Specify the default sort order','asc|dsc|az|za','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACdefaultSortField',NULL,'Specify the default field used for sorting','relevance|popularity|call_number|pubdate|acqdate|title|author','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACdefaultSortOrder',NULL,'Specify the default sort order','asc|dsc|za|az','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('staffClientBaseURL','','Specify the base URL of the staff client',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('minPasswordLength',3,'Specify the minimum length of a patron/staff password',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('noItemTypeImages',0,'If ON, disables item-type images',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('emailLibrarianWhenHoldIsPlaced',0,'If ON, emails the librarian whenever a hold is placed',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('holdCancelLength','','Specify how many days before a hold is canceled',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('libraryAddress','','The address to use for printing receipts, overdues, etc. if different than physical address',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('numReturnedItemsToShow','20','Number of returned items to show on the check-in page',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('finesMode','test','Choose the fines mode, \'off\', \'test\' (emails admin report) or \'production\' (accrue overdue fines). Requires accruefines cronjob.','off|test|production','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('globalDueDate','','If set, allows a global static due date for all checkouts','10','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ceilingDueDate','','If set, date due will not be past this date. Enter date according to the dateformat System Preference',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('itemBarcodeInputFilter','','If set, allows specification of a item barcode input filter','whitespace|T-prefix|cuecat','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('singleBranchMode',0,'Operate in Single-branch mode, hide branch selection in the OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('URLLinkText','','Text to display as the link anchor in the OPAC',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACSubscriptionDisplay','economical','Specify how to display subscription information in the OPAC','economical|off|full','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACDisplayExtendedSubInfo',1,'If ON, extended subscription information is displayed in the OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACViewOthersSuggestions',0,'If ON, allows all suggestions to be displayed in the OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACURLOpenInNewWindow',0,'If ON, URLs in the OPAC open in a new window',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACUserCSS','','Add CSS to be included in the OPAC in an embedded