From af505046afd9fa20d299e002645bd6517e31a971 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Wed, 11 Feb 2009 21:24:19 +1300 Subject: [PATCH] Russian and Ukranian SQL files --- .../authorised_values_[CCODE].csv.sql | 8 + .../authorised_values_[CCODE].csv.txt | 1 + .../authorised_values_[COUNTRY].csv.sql | 2 + .../authorised_values_[COUNTRY].csv.txt | 1 + .../authorised_values_[DAMAGED].csv.sql | 3 + .../authorised_values_[DAMAGED].csv.txt | 1 + .../authorised_values_[LANG].csv.sql | 3 + .../authorised_values_[LANG].csv.txt | 1 + .../authorised_values_[LOC].csv.sql | 15 + .../authorised_values_[LOC].csv.txt | 1 + .../authorised_values_[LOST].csv.sql | 12 + .../authorised_values_[LOST].csv.txt | 1 + .../authorised_values_[NOT_LOAN].csv.sql | 7 + .../authorised_values_[NOT_LOAN].csv.txt | 1 + .../authorised_values_[RESTRICTED].csv.sql | 3 + .../authorised_values_[RESTRICTED].csv.txt | 1 + .../authorised_values_[STACK].csv.sql | 2 + .../authorised_values_[STACK].csv.txt | 1 + .../authorised_values_[SUGGEST].csv.sql | 7 + .../authorised_values_[SUGGEST].csv.txt | 1 + .../authorised_values_[WITHDRAWN].csv.sql | 3 + .../authorised_values_[WITHDRAWN].csv.txt | 1 + .../authorised_values_[classif].csv.sql | 38 + .../authorised_values_[classif].csv.txt | 1 + .../authorised_values_[rusmarc856].csv.sql | 2 + .../authorised_values_[rusmarc856].csv.txt | 1 + .../mysql/ru-RU/mandatory/class_sources.sql | 32 + .../mysql/ru-RU/mandatory/class_sources.txt | 1 + .../mandatory/message_transport_types.sql | 7 + .../mandatory/message_transport_types.txt | 2 + .../mysql/ru-RU/mandatory/permissions.sql | 19 + .../mysql/ru-RU/mandatory/permissions.txt | 1 + .../data/mysql/ru-RU/mandatory/stopwords.sql | 21 + .../data/mysql/ru-RU/mandatory/stopwords.txt | 1 + .../mysql/ru-RU/mandatory/subtag_registry.sql | 722 +++++++ .../mysql/ru-RU/mandatory/subtag_registry.txt | 5 + .../mandatory/system_preferences_optimal.sql | 239 +++ .../mandatory/system_preferences_optimal.txt | 1 + .../data/mysql/ru-RU/mandatory/user_flags.sql | 19 + .../data/mysql/ru-RU/mandatory/user_flags.txt | 1 + .../authorities_subfields_[DEFAULT].csv | 685 +++++++ .../authorities_subfields_[DEFAULT].csv.txt | 1 + .../mandatory/authorities_tags_[DEFAULT].csv | 82 + .../authorities_tags_[DEFAULT].csv.txt | 1 + ..._bibliographic_subfields_[DEFAULT].csv.sql | 1467 ++++++++++++++ ..._bibliographic_subfields_[DEFAULT].csv.txt | 1 + ...imarc_bibliographic_tags_[DEFAULT].csv.sql | 214 +++ ...imarc_bibliographic_tags_[DEFAULT].csv.txt | 1 + .../ru-RU/optional/acqusion_book_funds.sql | 12 + .../ru-RU/optional/acqusion_book_funds.txt | 1 + .../mysql/ru-RU/optional/example_branches.sql | 6 + .../mysql/ru-RU/optional/example_branches.txt | 1 + .../data/mysql/ru-RU/optional/holidays.sql | 23 + .../data/mysql/ru-RU/optional/holidays.txt | 1 + .../ru-RU/optional/library_item_types.sql | 17 + .../ru-RU/optional/library_item_types.txt | 1 + .../ru-RU/optional/patron_categories.sql | 25 + .../ru-RU/optional/patron_categories.txt | 1 + .../mysql/ru-RU/optional/print_labels.sql | 28 + .../mysql/ru-RU/optional/print_labels.txt | 8 + .../mysql/ru-RU/optional/sample_cities.sql | 48 + .../mysql/ru-RU/optional/sample_cities.txt | 1 + .../mysql/ru-RU/optional/sample_currency.sql | 13 + .../mysql/ru-RU/optional/sample_currency.txt | 1 + .../data/mysql/ru-RU/optional/sample_news.sql | 19 + .../data/mysql/ru-RU/optional/sample_news.txt | 1 + .../mysql/ru-RU/optional/sample_notices.sql | 22 + .../mysql/ru-RU/optional/sample_notices.txt | 1 + .../sample_notices_message_attributes.sql | 7 + .../sample_notices_message_attributes.txt | 1 + .../sample_notices_message_transports.sql | 14 + .../sample_notices_message_transports.txt | 1 + .../optional/sample_user_suggestions.sql | 4 + .../optional/sample_user_suggestions.txt | 1 + .../optional/z39-50servers_collection.sql | 4 + .../optional/z39-50servers_collection.txt | 1 + .../authorised_values_[CCODE].csv.sql | 8 + .../authorised_values_[CCODE].csv.txt | 1 + .../authorised_values_[COUNTRY].csv.sql | 471 +++++ .../authorised_values_[COUNTRY].csv.txt | 1 + .../authorised_values_[DAMAGED].csv.sql | 2 + .../authorised_values_[DAMAGED].csv.txt | 1 + .../authorised_values_[LANG].csv.sql | 859 +++++++++ .../authorised_values_[LANG].csv.txt | 1 + .../authorised_values_[LOC].csv.sql | 15 + .../authorised_values_[LOC].csv.txt | 1 + .../authorised_values_[LOST].csv.sql | 11 + .../authorised_values_[LOST].csv.txt | 1 + .../authorised_values_[NOT_LOAN].csv.sql | 7 + .../authorised_values_[NOT_LOAN].csv.txt | 1 + .../authorised_values_[RESTRICTED].csv.sql | 3 + .../authorised_values_[RESTRICTED].csv.txt | 1 + .../authorised_values_[STACK].csv.sql | 3 + .../authorised_values_[STACK].csv.txt | 1 + .../authorised_values_[SUGGEST].csv.sql | 7 + .../authorised_values_[SUGGEST].csv.txt | 1 + .../authorised_values_[WITHDRAWN].csv.sql | 3 + .../authorised_values_[WITHDRAWN].csv.txt | 1 + .../authorised_values_[classif].csv.sql | 176 ++ .../authorised_values_[classif].csv.txt | 1 + .../mysql/uk-UA/mandatory/class_sources.sql | 32 + .../mysql/uk-UA/mandatory/class_sources.txt | 1 + .../mandatory/message_transport_types.sql | 7 + .../mandatory/message_transport_types.txt | 2 + .../mysql/uk-UA/mandatory/permissions.sql | 19 + .../mysql/uk-UA/mandatory/permissions.txt | 1 + .../data/mysql/uk-UA/mandatory/stopwords.sql | 29 + .../data/mysql/uk-UA/mandatory/stopwords.txt | 1 + .../mysql/uk-UA/mandatory/subtag_registry.sql | 722 +++++++ .../mysql/uk-UA/mandatory/subtag_registry.txt | 5 + .../mandatory/system_preferences_optimal.sql | 239 +++ .../mandatory/system_preferences_optimal.txt | 1 + .../data/mysql/uk-UA/mandatory/user_flags.sql | 19 + .../data/mysql/uk-UA/mandatory/user_flags.txt | 1 + .../authorities_subfields_[DEFAULT].csv.sql | 680 +++++++ .../authorities_subfields_[DEFAULT].csv.txt | 1 + .../authorities_tags_[DEFAULT].csv.sql | 81 + .../authorities_tags_[DEFAULT].csv.txt | 1 + ..._bibliographic_subfields_[DEFAULT].csv.sql | 1686 +++++++++++++++++ ..._bibliographic_subfields_[DEFAULT].csv.txt | 1 + ...imarc_bibliographic_tags_[DEFAULT].csv.sql | 203 ++ ...imarc_bibliographic_tags_[DEFAULT].csv.txt | 1 + .../optional/biblio_framework_codes.sql | 16 + .../optional/biblio_framework_codes.txt | 1 + ...imarc_bibliographic_subfields_[AN].csv.sql | 1188 ++++++++++++ ...imarc_bibliographic_subfields_[AN].csv.txt | 1 + ...marc_bibliographic_subfields_[AUD].csv.sql | 859 +++++++++ ...marc_bibliographic_subfields_[AUD].csv.txt | 1 + ...arc_bibliographic_subfields_[BOOK].csv.sql | 1044 ++++++++++ ...arc_bibliographic_subfields_[BOOK].csv.txt | 1 + ...imarc_bibliographic_subfields_[EL].csv.sql | 849 +++++++++ ...imarc_bibliographic_subfields_[EL].csv.txt | 1 + ...marc_bibliographic_subfields_[MIN].csv.sql | 713 +++++++ ...marc_bibliographic_subfields_[MIN].csv.txt | 1 + ...arc_bibliographic_subfields_[NOTE].csv.sql | 1164 ++++++++++++ ...arc_bibliographic_subfields_[NOTE].csv.txt | 1 + ...marc_bibliographic_subfields_[PER].csv.sql | 870 +++++++++ ...marc_bibliographic_subfields_[PER].csv.txt | 1 + ...arc_bibliographic_subfields_[TECH].csv.sql | 1685 ++++++++++++++++ ...arc_bibliographic_subfields_[TECH].csv.txt | 1 + .../unimarc_bibliographic_tags_[AN].csv.sql | 117 ++ .../unimarc_bibliographic_tags_[AN].csv.txt | 1 + .../unimarc_bibliographic_tags_[AUD].csv.sql | 106 ++ .../unimarc_bibliographic_tags_[AUD].csv.txt | 1 + .../unimarc_bibliographic_tags_[BOOK].csv.sql | 115 ++ .../unimarc_bibliographic_tags_[BOOK].csv.txt | 1 + .../unimarc_bibliographic_tags_[EL].csv.sql | 101 + .../unimarc_bibliographic_tags_[EL].csv.txt | 1 + .../unimarc_bibliographic_tags_[MIN].csv.sql | 89 + .../unimarc_bibliographic_tags_[MIN].csv.txt | 1 + .../unimarc_bibliographic_tags_[NOTE].csv.sql | 138 ++ .../unimarc_bibliographic_tags_[NOTE].csv.txt | 1 + .../unimarc_bibliographic_tags_[PER].csv.sql | 95 + .../unimarc_bibliographic_tags_[PER].csv.txt | 1 + .../unimarc_bibliographic_tags_[TECH].csv.sql | 203 ++ .../unimarc_bibliographic_tags_[TECH].csv.txt | 1 + .../uk-UA/optional/acqusion_book_funds.sql | 12 + .../uk-UA/optional/acqusion_book_funds.txt | 1 + .../mysql/uk-UA/optional/example_branches.sql | 6 + .../mysql/uk-UA/optional/example_branches.txt | 1 + .../data/mysql/uk-UA/optional/holidays.sql | 28 + .../data/mysql/uk-UA/optional/holidays.txt | 1 + .../uk-UA/optional/library_item_types.sql | 17 + .../uk-UA/optional/library_item_types.txt | 1 + .../uk-UA/optional/patron_categories.sql | 25 + .../uk-UA/optional/patron_categories.txt | 1 + .../mysql/uk-UA/optional/print_labels.sql | 28 + .../mysql/uk-UA/optional/print_labels.txt | 8 + .../mysql/uk-UA/optional/sample_cities.sql | 48 + .../mysql/uk-UA/optional/sample_cities.txt | 1 + .../mysql/uk-UA/optional/sample_currency.sql | 13 + .../mysql/uk-UA/optional/sample_currency.txt | 1 + .../data/mysql/uk-UA/optional/sample_news.sql | 19 + .../data/mysql/uk-UA/optional/sample_news.txt | 1 + .../mysql/uk-UA/optional/sample_notices.sql | 21 + .../mysql/uk-UA/optional/sample_notices.txt | 1 + .../sample_notices_message_attributes.sql | 7 + .../sample_notices_message_attributes.txt | 1 + .../sample_notices_message_transports.sql | 14 + .../sample_notices_message_transports.txt | 1 + .../optional/sample_user_suggestions.sql | 4 + .../optional/sample_user_suggestions.txt | 1 + .../optional/z39-50servers_collection.sql | 4 + .../optional/z39-50servers_collection.txt | 1 + 184 files changed, 18850 insertions(+) create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/class_sources.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/class_sources.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/message_transport_types.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/message_transport_types.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/permissions.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/permissions.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/stopwords.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/stopwords.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/subtag_registry.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/subtag_registry.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/user_flags.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/user_flags.txt create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/authorities_subfields_[DEFAULT].csv create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/authorities_subfields_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/authorities_tags_[DEFAULT].csv create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/authorities_tags_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_subfields_[DEFAULT].csv.sql create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_subfields_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_tags_[DEFAULT].csv.sql create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_tags_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/ru-RU/optional/acqusion_book_funds.sql create mode 100755 installer/data/mysql/ru-RU/optional/acqusion_book_funds.txt create mode 100755 installer/data/mysql/ru-RU/optional/example_branches.sql create mode 100755 installer/data/mysql/ru-RU/optional/example_branches.txt create mode 100755 installer/data/mysql/ru-RU/optional/holidays.sql create mode 100755 installer/data/mysql/ru-RU/optional/holidays.txt create mode 100755 installer/data/mysql/ru-RU/optional/library_item_types.sql create mode 100755 installer/data/mysql/ru-RU/optional/library_item_types.txt create mode 100755 installer/data/mysql/ru-RU/optional/patron_categories.sql create mode 100755 installer/data/mysql/ru-RU/optional/patron_categories.txt create mode 100755 installer/data/mysql/ru-RU/optional/print_labels.sql create mode 100755 installer/data/mysql/ru-RU/optional/print_labels.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_cities.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_cities.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_currency.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_currency.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_news.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_news.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_notices.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_notices.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_notices_message_attributes.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_notices_message_transports.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_notices_message_transports.txt create mode 100755 installer/data/mysql/ru-RU/optional/sample_user_suggestions.sql create mode 100755 installer/data/mysql/ru-RU/optional/sample_user_suggestions.txt create mode 100755 installer/data/mysql/ru-RU/optional/z39-50servers_collection.sql create mode 100755 installer/data/mysql/ru-RU/optional/z39-50servers_collection.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[CCODE].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[CCODE].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[COUNTRY].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[COUNTRY].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LANG].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LANG].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOC].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOC].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[STACK].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[STACK].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].csv.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[classif].csv.sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[classif].csv.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/class_sources.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/class_sources.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/message_transport_types.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/message_transport_types.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/permissions.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/permissions.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/stopwords.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/stopwords.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/subtag_registry.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/subtag_registry.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_optimal.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/user_flags.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/user_flags.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/authorities_subfields_[DEFAULT].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/authorities_subfields_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/authorities_tags_[DEFAULT].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/authorities_tags_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_subfields_[DEFAULT].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_subfields_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_tags_[DEFAULT].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_tags_[DEFAULT].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/biblio_framework_codes.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/biblio_framework_codes.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[AN].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[AN].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[AUD].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[AUD].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[BOOK].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[BOOK].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[EL].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[EL].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[MIN].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[MIN].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[NOTE].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[NOTE].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[PER].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[PER].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[TECH].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_subfields_[TECH].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[AN].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[AN].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[AUD].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[AUD].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[BOOK].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[BOOK].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[EL].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[EL].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[MIN].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[MIN].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[NOTE].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[NOTE].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[PER].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[PER].csv.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[TECH].csv.sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_tags_[TECH].csv.txt create mode 100755 installer/data/mysql/uk-UA/optional/acqusion_book_funds.sql create mode 100755 installer/data/mysql/uk-UA/optional/acqusion_book_funds.txt create mode 100755 installer/data/mysql/uk-UA/optional/example_branches.sql create mode 100755 installer/data/mysql/uk-UA/optional/example_branches.txt create mode 100755 installer/data/mysql/uk-UA/optional/holidays.sql create mode 100755 installer/data/mysql/uk-UA/optional/holidays.txt create mode 100755 installer/data/mysql/uk-UA/optional/library_item_types.sql create mode 100755 installer/data/mysql/uk-UA/optional/library_item_types.txt create mode 100755 installer/data/mysql/uk-UA/optional/patron_categories.sql create mode 100755 installer/data/mysql/uk-UA/optional/patron_categories.txt create mode 100755 installer/data/mysql/uk-UA/optional/print_labels.sql create mode 100755 installer/data/mysql/uk-UA/optional/print_labels.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_cities.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_cities.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_currency.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_currency.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_news.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_news.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_notices.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_notices.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_notices_message_attributes.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_notices_message_transports.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_notices_message_transports.txt create mode 100755 installer/data/mysql/uk-UA/optional/sample_user_suggestions.sql create mode 100755 installer/data/mysql/uk-UA/optional/sample_user_suggestions.txt create mode 100755 installer/data/mysql/uk-UA/optional/z39-50servers_collection.sql create mode 100755 installer/data/mysql/uk-UA/optional/z39-50servers_collection.txt diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.sql new file mode 100755 index 0000000000..b27aa11b8e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.sql @@ -0,0 +1,8 @@ +INSERT INTO `authorised_values` (category, authorised_value, lib) +VALUES ('CCODE','FIC','Художественная литература'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) +VALUES ('CCODE','REF','Справочник'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) +VALUES ('CCODE','NFIC','Научная литература'); \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.txt new file mode 100755 index 0000000000..4d0acd8235 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].csv.txt @@ -0,0 +1 @@ +Коды коллекции для экземпляра. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.sql new file mode 100755 index 0000000000..ce5729f5f4 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.sql @@ -0,0 +1,2 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 0,'COUNTRY','RU','Росия','NULL'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 1,'COUNTRY','UA','Украина','NULL'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.txt new file mode 100755 index 0000000000..faa1e50990 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].csv.txt @@ -0,0 +1 @@ +Список стран. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql new file mode 100755 index 0000000000..efb59f9652 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.sql @@ -0,0 +1,3 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'DAMAGED','0'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'DAMAGED','1','Повреждено'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.txt new file mode 100755 index 0000000000..f2961cb39b --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].csv.txt @@ -0,0 +1 @@ +Статус повреждения экземпляра. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.sql new file mode 100755 index 0000000000..081b48e15e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.sql @@ -0,0 +1,3 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 0,'LANG','eng','Английский','NULL'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 1,'LANG','rus','Русский','NULL'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 2,'LANG','ukr','Украинский','NULL'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.txt new file mode 100755 index 0000000000..a38269b871 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].csv.txt @@ -0,0 +1 @@ +Список языков. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.sql new file mode 100755 index 0000000000..c0450a7d14 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.sql @@ -0,0 +1,15 @@ +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','FIC','Художественная литература'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','CHILD','Детская область'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','DISPLAY','На демонстрации'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','NEW','Новая полочка материалов'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','STAFF','Офис работников библиотеки'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','GEN','Общие фонды'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','AV','Аудио-визуальные материалы'); + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOC','REF','Справочник'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.txt new file mode 100755 index 0000000000..4ef6814ce1 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].csv.txt @@ -0,0 +1 @@ +Квалификации размещения экземпляров, областей связанные по умочаннванню с items.location \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql new file mode 100755 index 0000000000..85bc393013 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.sql @@ -0,0 +1,12 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'LOST','0'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'LOST','2','Длительная просрочка (утрачено)'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'LOST','1','Утрачено'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'LOST','3','Потеряны и заплачено за экземпляр'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 4,'LOST','5','Отсутствует при запросе на резервирование'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 5,'LOST','4','Отсутствует при инвентиризации'); + diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.txt new file mode 100755 index 0000000000..ca6e6722fa --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].csv.txt @@ -0,0 +1 @@ +Статусы доступности. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql new file mode 100755 index 0000000000..95a725e171 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.sql @@ -0,0 +1,7 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'NOT_LOAN','0'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'NOT_LOAN','1','Не для ссуды'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 2,'NOT_LOAN','-1','Заказано'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 3,'NOT_LOAN','2','Собрание работника библиотеки'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.txt new file mode 100755 index 0000000000..fabc55b30d --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].csv.txt @@ -0,0 +1 @@ +Статус возможности одалживания экземпляра, связанный с items.notforloan \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql new file mode 100755 index 0000000000..36bb437bd2 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.sql @@ -0,0 +1,3 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'RESTRICTED','0'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'RESTRICTED','1','Ограниченный доступ'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.txt new file mode 100755 index 0000000000..ae520a77e4 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].csv.txt @@ -0,0 +1 @@ +Статус ограничения доступа к экземпляру, связан с items.restricted diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql new file mode 100755 index 0000000000..8493dc1443 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.sql @@ -0,0 +1,2 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'STACK','0'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'STACK','1','Особое собрание'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.txt new file mode 100755 index 0000000000..d391e7bb57 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].csv.txt @@ -0,0 +1 @@ +Список STACK. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.sql new file mode 100755 index 0000000000..16b77b4af2 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.sql @@ -0,0 +1,7 @@ +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','BSELL','Бестселлер'); + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','SCD','Экземпляр с полки поврежден'); + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','LCL','Библиотечный экземпляр утерян'); + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES ('SUGGEST','AVILL','Доступный через межбиблиотечный обмен'); \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.txt new file mode 100755 index 0000000000..1ec8a9c71e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].csv.txt @@ -0,0 +1 @@ +Основания для принятия или отклонения предложений на приобретение. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql new file mode 100755 index 0000000000..3cefe81c9e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.sql @@ -0,0 +1,3 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 0,'WITHDRAWN','0'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (LAST_INSERT_ID( ) + 1,'WITHDRAWN','1','Изъято'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.txt new file mode 100755 index 0000000000..7a0e78a7bf --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].csv.txt @@ -0,0 +1 @@ +Статус изъятия экземпляра, связан с items.wthdrawn \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.sql new file mode 100755 index 0000000000..3b1f35d6d6 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.sql @@ -0,0 +1,38 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 0,'classif','rubbks','Средние таблицы ББК','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 1,'classif','rubbk','Таблицы ББК для научных библиотек в 30-ти томах','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 2,'classif','ddc','Десятичная классификация Дьюи и относительный показатель (ДКД)','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 3,'classif','lcc','Классификация Библиотеки Конгресса (КБК)','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 4,'classif','rugasnti','Рубрикатор ГАСНТИ','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 5,'classif','rubbkd','Таблицы ББК для детских библиотек в 1 т.','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 6,'classif','rubbkm','Таблицы ББК для массовых библиотек в 1 т.','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 7,'classif','rubbko','Таблицы ББК для областных библиотек в 4-х томах','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 8,'classif','udc','Универсальная десятичная классификация (УДК)','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 9,'classif','rubbknp','Переиздания таблиц ББК для научных библиотек в 30-ти томах','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 10,'classif','rubbkn','Таблицы ББК для научных библиотек в 5-ти томах','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 11,'classif','rubbkmv','Таблицы ББК для массовых военных библиотек','NULL'); + +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) +VALUES (LAST_INSERT_ID( ) + 12,'classif','rubbkk','Таблицы ББК для краеведческих каталогов библиотек','NULL'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.txt new file mode 100755 index 0000000000..286ebfa102 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[classif].csv.txt @@ -0,0 +1 @@ +Список названий классификационных схем. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.sql new file mode 100755 index 0000000000..4951a05c96 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.sql @@ -0,0 +1,2 @@ +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 0,'rusmarc856','1#','FTP','NULL'); +INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`, `imageurl`) VALUES (LAST_INSERT_ID( ) + 1,'rusmarc856','0#','Электронная почта','NULL'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.txt new file mode 100755 index 0000000000..6854529939 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].csv.txt @@ -0,0 +1 @@ +Список индикаторов для поля 856 (rusmarc). diff --git a/installer/data/mysql/ru-RU/mandatory/class_sources.sql b/installer/data/mysql/ru-RU/mandatory/class_sources.sql new file mode 100755 index 0000000000..bda35b2895 --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/class_sources.sql @@ -0,0 +1,32 @@ +-- +-- Default classification sources and filing rules +-- for Koha. +-- + +TRUNCATE class_sort_rules; +-- class sorting (filing) rules +INSERT INTO `class_sort_rules` (`class_sort_rule`, `description`, `sort_routine`) VALUES + ('dewey', 'Типовые правила заполнения для ДКД', 'Dewey'), + ('lcc', 'Типовые правила заполнения для КБК', 'LCC'), + ('generic', 'Правила заполнения для обобщённого библиотечного шифра', 'Generic'); + + +TRUNCATE class_sources; +-- classification schemes or sources +INSERT INTO `class_sources` (`cn_source`, `description`, `used`, `class_sort_rule`) VALUES + ('ddc', 'Десятичная классификация Дьюи (ДКД)', 1, 'dewey'), + ('lcc', 'Классификация Библиотеки Конгресса (КБК)', 1, 'lcc'), + ('udc', 'Универсальная десятичная классификация', 0, 'generic'), + ('sudocs', 'Классификация SuDoc (U.S. GPO)', 0, 'generic'), + ('anscr', 'ANSCR (звукозаписи)', 0, 'generic'), + ('rubbk', 'Таблицы ББК для научных библиотек в 30-ти томах', 0, 'generic'), + ('rugasnti','Рубрикатор ГАСНТИ', 0, 'generic'), + ('rubbkd', 'Таблицы ББК для детских библиотек в 1 т.', 0, 'generic'), + ('rubbkm', 'Таблицы ББК для массовых библиотек в 1 т.', 0, 'generic'), + ('rubbko', 'Таблицы ББК для областных библиотек в 4-х томах', 0, 'generic'), + ('rubbknp', 'Переиздания таблиц ББК для научных библиотек в 30-ти томах', 0, 'generic'), + ('rubbkn', 'Таблицы ББК для научных библиотек в 5-ти томах', 0, 'generic'), + ('rubbkmv', 'Таблицы ББК для массовых военных библиотек', 0, 'generic'), + ('rubbkk', 'Таблицы ББК для краеведческих каталогов библиотек', 0, 'generic'), + ('z', 'Другие/типовые схемы классификации', 0, 'generic'); + diff --git a/installer/data/mysql/ru-RU/mandatory/class_sources.txt b/installer/data/mysql/ru-RU/mandatory/class_sources.txt new file mode 100755 index 0000000000..121d78c3dc --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/class_sources.txt @@ -0,0 +1 @@ +Типовые классификационные источники и правила заполнения. diff --git a/installer/data/mysql/ru-RU/mandatory/message_transport_types.sql b/installer/data/mysql/ru-RU/mandatory/message_transport_types.sql new file mode 100755 index 0000000000..aceb0bc2fa --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/message_transport_types.sql @@ -0,0 +1,7 @@ +TRUNCATE message_transport_types; + +INSERT INTO message_transport_types +(message_transport_type) +values +('email'), +('sms'); diff --git a/installer/data/mysql/ru-RU/mandatory/message_transport_types.txt b/installer/data/mysql/ru-RU/mandatory/message_transport_types.txt new file mode 100755 index 0000000000..89dc5ed2b7 --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/message_transport_types.txt @@ -0,0 +1,2 @@ +Определяет типовые способы сообщений с помощью электронной почты и SMS. + diff --git a/installer/data/mysql/ru-RU/mandatory/permissions.sql b/installer/data/mysql/ru-RU/mandatory/permissions.sql new file mode 100755 index 0000000000..c58bc933a6 --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/permissions.sql @@ -0,0 +1,19 @@ +TRUNCATE permissions; + +INSERT INTO permissions (module_bit, code, description) VALUES + (13, 'edit_news', 'Написание новостей для электронного каталога и интерфейса библиотекарей'), + (13, 'label_creator', 'Создание печатных наклеек и штрихкодов из каталога и с данными о пользователях'), + (13, 'edit_calendar', 'Определение дней, когда библиотека закрыта'), + (13, 'moderate_comments', 'Регулировка комментариев от посетителей'), + (13, 'edit_notices', 'Определение сообщений'), + (13, 'edit_notice_status_triggers', 'Установка триггеров сообщений/статусов для просроченных экземпляров'), + (13, 'view_system_logs', 'Просмотр протоколов системы'), + (13, 'inventory', 'Проведение инвентаризации(анализа) Вашего каталога'), + (13, 'stage_marc_import', 'Заготовка МАРК-записей в хранилище'), + (13, 'manage_staged_marc', 'Управление заготовленными МАРК-записями, в том числе дополнения и обратный импорт'), + (13, 'export_catalog', 'Экспортирование библиографической информации и данных о единицах хранения'), + (13, 'import_patrons', 'Импорт данных о посетителях'), + (13, 'delete_anonymize_patrons', 'Удаление пользователей с протерминованим периодом регистрации и анонимизация истории обращения (изъятие история чтения пользователей)'), + (13, 'batch_upload_patron_images', 'Загрузка изображений посетителей партиями или всех сразу'), + (13, 'schedule_tasks', 'Планирование задач к выполнению') +; diff --git a/installer/data/mysql/ru-RU/mandatory/permissions.txt b/installer/data/mysql/ru-RU/mandatory/permissions.txt new file mode 100755 index 0000000000..af20b83a5c --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/permissions.txt @@ -0,0 +1 @@ +Детализированные привилегии для сотрудников библиотеки. diff --git a/installer/data/mysql/ru-RU/mandatory/stopwords.sql b/installer/data/mysql/ru-RU/mandatory/stopwords.sql new file mode 100755 index 0000000000..3610a84a6e --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/stopwords.sql @@ -0,0 +1,21 @@ +TRUNCATE stopwords; + +INSERT INTO stopwords VALUES +( 'к'), +( 'и'), +( 'в'), +( 'на'), +( 'да'), +( 'то'), +( 'где'), +( 'еле'), +( 'это'), +( 'что'), +( 'ведь'), +( 'даже'), +( 'почти'), +( 'такой'), +( 'также'), +( 'значит'), +( 'немного'), +( 'который'); \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/mandatory/stopwords.txt b/installer/data/mysql/ru-RU/mandatory/stopwords.txt new file mode 100755 index 0000000000..0dc1831df8 --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/stopwords.txt @@ -0,0 +1 @@ +Несущественные русские слова. Вы можете корректировать их после установки. diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql new file mode 100755 index 0000000000..d96e6a6641 --- /dev/null +++ b/installer/data/mysql/ru-RU/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','rus'); + +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/ru-RU/mandatory/subtag_registry.txt b/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt new file mode 100755 index 0000000000..e23e73e995 --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt @@ -0,0 +1,5 @@ +Поддержка интернационализации(I18N) в Koha + +Поддержка двунаправленности(BIDI); арабский и иврит. +Стандартное отображение между письмом и подкодами языка. +Расширения языка. diff --git a/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql new file mode 100755 index 0000000000..d3954c446f --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/system_preferences_optimal.sql @@ -0,0 +1,239 @@ +TRUNCATE systempreferences; + +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('AmazonContent',0,'Turn ON Amazon Content - You MUST set AWSAccessKeyID 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 and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACAmazonContent',0,'Turn ON Amazon Content in the OPAC - You MUST set AWSAccessKeyID 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 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('authoritysep','--','Used to separate a list of authorities in a display. Usually --',10,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('autoBarcode','incremental','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('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','IntranetBiblioDefaultView','',''); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetcolorstylesheet','','Define the color stylesheet to use in the Staff Client','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetmainUserblock','','Add a block of HTML that will display on the intranet home page','50|20','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('IntranetNav','','Use HTML tabs to add navigational links to the left-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',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetuserjs','','Custom javascript for inclusion in Intranet','50|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','#910||{910e/}{910f }|
+#930||{930a}|
+#900||{900a }|
+#700||{700a }{ 700g, }|; +#701||{701a }{ 701g, }|; +#702||{702a }{ 702g, }|; +#200||{200a}{ [200b] }{. 200c}{: 200e}{. 200h}{. 200i}{ / 200f}{; 200g}| +#230||{; 230a}| +#205||{; 205a}{, 205b}{ = 205d}{ / 205f}{; 205g}| +#210|
|{; 210a}{ (210b) }{: 210c}{, 210d}|. - +#210|(|{ 210e}{(210f)}{: 210g}{, 210h}|) +#215||{; 215a}{: 215c}{; 215d}{ + 215e}| +#225|
(|{ 225a}{ = 225d}{: 225e}{. 225h}{. 225i}{ / 225f}{, I225x}{; 225v}|) +#010|
   ISBN |{010a}{: 010d}| +#606|
   |{- 606a }| +#686|
   Ð‘БК |{686a }| +#675|
   Ð£Ð”К |{675a }| +#676|
   Ð”КД |{676a }| +#995|
|{\n995b}{ - 995k}{ [995j]}|
+#910|
   |{910a }{ /910d/ }|
+#300|
   ÐŸÑ€Ð¸Ð¼Ñ–тки:
|{300a }| +#327|
   Ð—міст:
|{327a }| +#330|
   ÐÐ½Ð¾Ñ‚ація:
|{330a }|','ISBD','80|20','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','','Define the library name as displayed on the 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','UNIMARC','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','OPENOFFICE.ORG','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('opacheader','','Add HTML to be included as a custom header in the OPAC','30|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','Вітаємо у АБІС Koha...\r\n
','A user-defined block of HTML in the main content area of the opac main page','50|20','Textarea'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OpacNav','Тут будуть важливі посилання.','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','50|20','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','','free'); +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,'free'); +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','','free'); +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','metric','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','ru-RU,uk-UA,en,fr-FR,de-DE','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','Пане|Пані|Містер|Міссіс|Шановний|Шановна|Товариш|Добродій|Добродійка','Define appropriate Titles for patrons',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('gist',0.20 ,'Default Goods and Services tax rate NOT in %, but in numeric form (0.12 for 12%), set to 0 to disable GST','','free'); +-- 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,'free'); +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,'free'); +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,'free'); +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('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',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