From 4fdbc3a89cfc63d2c68e998e3453ad96ffc2ecc1 Mon Sep 17 00:00:00 2001 From: Chris Cormack Date: Thu, 8 Oct 2009 19:45:11 +1300 Subject: [PATCH] =?utf8?q?Ukranian=20and=20Russian=20sql=20updates=20court?= =?utf8?q?esy=20of=20=D0=A1=D0=B5=D1=80=D0=B3=D1=96=D0=B9=20=D0=94=D1=83?= =?utf8?q?=D0=B1=D0=B8=D0=BA?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- .../authorised_values_[CCODE].sql | 6 + .../authorised_values_[CCODE].txt | 1 + .../authorised_values_[COUNTRY].sql | 2 + .../authorised_values_[COUNTRY].txt | 1 + .../authorised_values_[DAMAGED].sql | 6 + .../authorised_values_[DAMAGED].txt | 1 + .../authorised_values_[LANG].sql | 3 + .../authorised_values_[LANG].txt | 1 + .../authorised_values_[LOC].sql | 15 + .../authorised_values_[LOC].txt | 1 + .../authorised_values_[LOST].sql | 14 + .../authorised_values_[LOST].txt | 1 + .../authorised_values_[NOT_LOAN].sql | 9 + .../authorised_values_[NOT_LOAN].txt | 1 + .../authorised_values_[RESTRICTED].sql | 7 + .../authorised_values_[RESTRICTED].txt | 1 + .../authorised_values_[STACK].sql | 7 + .../authorised_values_[STACK].txt | 1 + .../authorised_values_[SUGGEST].sql | 7 + .../authorised_values_[SUGGEST].txt | 1 + .../authorised_values_[WITHDRAWN].sql | 7 + .../authorised_values_[WITHDRAWN].txt | 1 + .../authorised_values_[rusmarc856].sql | 2 + .../authorised_values_[rusmarc856].txt | 1 + .../mysql/ru-RU/mandatory/class_sources.sql | 16 +- .../mandatory/permissions_and_user_flags.sql | 52 + .../mandatory/permissions_and_user_flags.txt | 1 + .../data/mysql/ru-RU/mandatory/stopwords.txt | 2 +- .../mysql/ru-RU/mandatory/subtag_registry.sql | 2 +- .../mysql/ru-RU/mandatory/subtag_registry.txt | 5 +- ...ferences_full_optimal_for_install_only.sql | 261 ++ ...ferences_full_optimal_for_install_only.txt | 1 + ..._preferences_only_translation_updating.sql | 650 +++++ ..._preferences_only_translation_updating.txt | 1 + ...preferences_optimal_values_insert_only.sql | 86 + ...preferences_optimal_values_insert_only.txt | 1 + .../unimarc_bibliographic_[DEFAULT].sql | 1748 ++++++++++++ .../unimarc_bibliographic_[DEFAULT].txt | 1 + .../mysql/ru-RU/optional/example_branches.sql | 36 +- .../mysql/ru-RU/optional/example_branches.txt | 2 +- .../mysql/ru-RU/optional/patron_atributes.sql | 17 + .../mysql/ru-RU/optional/patron_atributes.txt | 1 + .../data/mysql/ru-RU/optional/sample_news.sql | 20 +- .../mysql/ru-RU/optional/sample_notices.sql | 11 +- .../sample_notices_message_attributes.sql | 4 +- .../sample_notices_message_transports.sql | 8 +- .../authorised_values_[CCODE].sql | 6 + .../authorised_values_[CCODE].txt | 1 + .../authorised_values_[COUNTRY].sql | 473 ++++ .../authorised_values_[COUNTRY].txt | 1 + .../authorised_values_[DAMAGED].sql | 5 + .../authorised_values_[DAMAGED].txt | 1 + .../authorised_values_[IND_852].sql | 65 + .../authorised_values_[IND_852].txt | 1 + .../authorised_values_[LANG].sql | 861 ++++++ .../authorised_values_[LANG].txt | 1 + .../authorised_values_[LOC].sql | 12 + .../authorised_values_[LOC].txt | 1 + .../authorised_values_[LOST].sql | 13 + .../authorised_values_[LOST].txt | 1 + .../authorised_values_[NOT_LOAN].sql | 9 + .../authorised_values_[NOT_LOAN].txt | 1 + .../authorised_values_[RESTRICTED].sql | 5 + .../authorised_values_[RESTRICTED].txt | 1 + .../authorised_values_[STACK].sql | 5 + .../authorised_values_[STACK].txt | 1 + .../authorised_values_[SUGGEST].sql | 7 + .../authorised_values_[SUGGEST].txt | 1 + .../authorised_values_[WITHDRAWN].sql | 5 + .../authorised_values_[WITHDRAWN].txt | 1 + .../mysql/uk-UA/mandatory/class_sources.sql | 96 +- .../mandatory/message_transport_types.txt | 3 +- .../mandatory/permissions_and_user_flags.sql | 52 + .../mandatory/permissions_and_user_flags.txt | 1 + .../data/mysql/uk-UA/mandatory/stopwords.txt | 2 +- .../mysql/uk-UA/mandatory/subtag_registry.sql | 2 +- .../mysql/uk-UA/mandatory/subtag_registry.txt | 9 +- ...ferences_full_optimal_for_install_only.sql | 287 ++ ...ferences_full_optimal_for_install_only.txt | 1 + ..._preferences_only_translation_updating.sql | 650 +++++ ..._preferences_only_translation_updating.txt | 1 + ...preferences_optimal_values_insert_only.sql | 115 + ...preferences_optimal_values_insert_only.txt | 1 + .../unimarc_authorities_[DEFAULT].sql | 768 ++++++ .../unimarc_authorities_[DEFAULT].txt | 1 + .../unimarc_bibliographic_[DEFAULT].sql | 2357 +++++++++++++++++ .../unimarc_bibliographic_[DEFAULT].txt | 1 + .../optional/biblio_framework_codes.sql | 26 +- .../optional/unimarc_bibliographic_[AN].sql | 1173 ++++++++ .../optional/unimarc_bibliographic_[AN].txt | 1 + .../optional/unimarc_bibliographic_[AUD].sql | 968 +++++++ .../optional/unimarc_bibliographic_[AUD].txt | 1 + .../optional/unimarc_bibliographic_[BOOK].sql | 1161 ++++++++ .../optional/unimarc_bibliographic_[BOOK].txt | 1 + .../optional/unimarc_bibliographic_[EL].sql | 952 +++++++ .../optional/unimarc_bibliographic_[EL].txt | 1 + .../optional/unimarc_bibliographic_[MIN].sql | 803 ++++++ .../optional/unimarc_bibliographic_[MIN].txt | 1 + .../optional/unimarc_bibliographic_[NOTE].sql | 1305 +++++++++ .../optional/unimarc_bibliographic_[NOTE].txt | 1 + .../optional/unimarc_bibliographic_[PER].sql | 967 +++++++ .../optional/unimarc_bibliographic_[PER].txt | 1 + .../optional/unimarc_bibliographic_[TECH].sql | 1892 +++++++++++++ .../optional/unimarc_bibliographic_[TECH].txt | 1 + .../uk-UA/optional/acqusion_book_funds.txt | 2 +- .../mysql/uk-UA/optional/example_branches.sql | 37 +- .../mysql/uk-UA/optional/example_branches.txt | 2 +- .../data/mysql/uk-UA/optional/holidays.sql | 46 +- .../data/mysql/uk-UA/optional/holidays.txt | 2 +- .../uk-UA/optional/library_item_types.sql | 111 +- .../uk-UA/optional/library_item_types.txt | 2 +- .../mysql/uk-UA/optional/patron_atributes.sql | 17 + .../mysql/uk-UA/optional/patron_atributes.txt | 1 + .../uk-UA/optional/patron_categories.sql | 88 +- .../uk-UA/optional/patron_categories.txt | 2 +- .../mysql/uk-UA/optional/print_labels.sql | 3 + .../mysql/uk-UA/optional/print_labels.txt | 1 - .../mysql/uk-UA/optional/sample_cities.txt | 2 +- .../data/mysql/uk-UA/optional/sample_news.sql | 12 +- .../mysql/uk-UA/optional/sample_notices.sql | 13 +- .../sample_notices_message_attributes.sql | 12 +- .../sample_notices_message_transports.sql | 2 + .../optional/sample_user_suggestions.txt | 2 +- .../optional/z39-50servers_collection.sql | 11 +- .../optional/z39-50servers_collection.txt | 2 +- 125 files changed, 18335 insertions(+), 138 deletions(-) create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].sql create mode 100755 installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].txt create mode 100755 installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_only_translation_updating.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_only_translation_updating.txt create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_optimal_values_insert_only.sql create mode 100755 installer/data/mysql/ru-RU/mandatory/system_preferences_optimal_values_insert_only.txt create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_[DEFAULT].sql create mode 100755 installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_[DEFAULT].txt create mode 100755 installer/data/mysql/ru-RU/optional/patron_atributes.sql create mode 100755 installer/data/mysql/ru-RU/optional/patron_atributes.txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[CCODE].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[CCODE].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[COUNTRY].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[COUNTRY].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[DAMAGED].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[IND_852].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[IND_852].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LANG].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LANG].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOC].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOC].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[LOST].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[NOT_LOAN].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[RESTRICTED].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[STACK].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[STACK].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[SUGGEST].txt create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].sql create mode 100755 installer/data/mysql/uk-UA/authorised_values/authorised_values_[WITHDRAWN].txt create mode 100755 installer/data/mysql/uk-UA/mandatory/permissions_and_user_flags.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/permissions_and_user_flags.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_full_optimal_for_install_only.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_only_translation_updating.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_only_translation_updating.txt create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_optimal_values_insert_only.sql create mode 100755 installer/data/mysql/uk-UA/mandatory/system_preferences_optimal_values_insert_only.txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_authorities_[DEFAULT].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_authorities_[DEFAULT].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_[DEFAULT].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_[DEFAULT].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[AN].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[AN].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[AUD].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[AUD].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[BOOK].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[BOOK].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[EL].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[EL].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[MIN].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[MIN].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[NOTE].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[NOTE].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[PER].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[PER].txt create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[TECH].sql create mode 100755 installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_[TECH].txt create mode 100755 installer/data/mysql/uk-UA/optional/patron_atributes.sql create mode 100755 installer/data/mysql/uk-UA/optional/patron_atributes.txt diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].sql new file mode 100755 index 0000000000..618a168f61 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].sql @@ -0,0 +1,6 @@ +DELETE FROM authorised_values WHERE category='CCODE'; + +INSERT INTO `authorised_values` (category, authorised_value, lib, imageurl) VALUES +('CCODE','FIC', 'Художественная литература', NULL), +('CCODE','REF', 'Справочник' , NULL), +('CCODE','NFIC','Научная литература' , NULL); \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].txt new file mode 100755 index 0000000000..6d5b404fe7 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[CCODE].txt @@ -0,0 +1 @@ +Коды типов коллекций для экземпляра. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].sql new file mode 100755 index 0000000000..ce5729f5f4 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].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].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].txt new file mode 100755 index 0000000000..faa1e50990 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[COUNTRY].txt @@ -0,0 +1 @@ +Список стран. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql new file mode 100755 index 0000000000..8bccb69fe9 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].sql @@ -0,0 +1,6 @@ +DELETE FROM authorised_values WHERE category='DAMAGED'; + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES +('DAMAGED','0',''), +('DAMAGED','1','Повреждено'); + diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].txt new file mode 100755 index 0000000000..f2961cb39b --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[DAMAGED].txt @@ -0,0 +1 @@ +Статус повреждения экземпляра. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].sql new file mode 100755 index 0000000000..081b48e15e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].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].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].txt new file mode 100755 index 0000000000..a38269b871 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LANG].txt @@ -0,0 +1 @@ +Список языков. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].sql new file mode 100755 index 0000000000..c0450a7d14 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].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].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].txt new file mode 100755 index 0000000000..4ef6814ce1 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOC].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].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql new file mode 100755 index 0000000000..17aff3b210 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].sql @@ -0,0 +1,14 @@ +DELETE FROM authorised_values WHERE category='LOST'; + +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].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].txt new file mode 100755 index 0000000000..ca6e6722fa --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[LOST].txt @@ -0,0 +1 @@ +Статусы доступности. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql new file mode 100755 index 0000000000..138cba7d6b --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].sql @@ -0,0 +1,9 @@ +DELETE FROM authorised_values WHERE category='NOT_LOAN'; + +INSERT INTO authorised_values (category, authorised_value, lib) VALUES +('NOT_LOAN','0', ' Для займа'), +('NOT_LOAN','-1','Заказано'), +('NOT_LOAN','1', 'Не для займа'), +('NOT_LOAN','2', 'Собрание работника библиотеки'), +('NOT_LOAN','3', 'В переплете с другими'), +('NOT_LOAN','4', 'Недоступно'); diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].txt new file mode 100755 index 0000000000..fabc55b30d --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[NOT_LOAN].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].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql new file mode 100755 index 0000000000..e96bcefa54 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].sql @@ -0,0 +1,7 @@ +DELETE FROM authorised_values WHERE category='RESTRICTED'; + +INSERT INTO `authorised_values` (`category`, `authorised_value`, `lib`) VALUES +('RESTRICTED','0',''), +('RESTRICTED','1','Ограниченный доступ'); + + diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].txt new file mode 100755 index 0000000000..ae520a77e4 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[RESTRICTED].txt @@ -0,0 +1 @@ +Статус ограничения доступа к экземпляру, связан с items.restricted diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].sql new file mode 100755 index 0000000000..e70853b03e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].sql @@ -0,0 +1,7 @@ +DELETE FROM authorised_values WHERE category='STACK'; + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES +('STACK','0',''), +('STACK','1','Особое собрание'); + + diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].txt new file mode 100755 index 0000000000..d391e7bb57 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[STACK].txt @@ -0,0 +1 @@ +Список STACK. diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].sql new file mode 100755 index 0000000000..16b77b4af2 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].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].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].txt new file mode 100755 index 0000000000..1ec8a9c71e --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[SUGGEST].txt @@ -0,0 +1 @@ +Основания для принятия или отклонения предложений на приобретение. \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql new file mode 100755 index 0000000000..e442303656 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].sql @@ -0,0 +1,7 @@ +DELETE FROM authorised_values WHERE category='WITHDRAWN'; + +INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES +('WITHDRAWN','0',''), +('WITHDRAWN','1','Изъято'); + + diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt new file mode 100755 index 0000000000..7a0e78a7bf --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[WITHDRAWN].txt @@ -0,0 +1 @@ +Статус изъятия экземпляра, связан с items.wthdrawn \ No newline at end of file diff --git a/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].sql b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].sql new file mode 100755 index 0000000000..4951a05c96 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].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].txt b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].txt new file mode 100755 index 0000000000..6854529939 --- /dev/null +++ b/installer/data/mysql/ru-RU/authorised_values/authorised_values_[rusmarc856].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 index bda35b2895..9a5f43f33b 100644 --- a/installer/data/mysql/ru-RU/mandatory/class_sources.sql +++ b/installer/data/mysql/ru-RU/mandatory/class_sources.sql @@ -3,12 +3,26 @@ -- for Koha. -- -TRUNCATE class_sort_rules; +-- 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'); +*/ + +INSERT INTO class_sort_rules (class_sort_rule, description, sort_routine) VALUES +('dewey', 'Типовые правила заполнения для ДКД', 'Dewey') +ON DUPLICATE KEY UPDATE description='Типовые правила заполнения для ДКД',sort_routine='Dewey'; + +INSERT INTO class_sort_rules (class_sort_rule, description, sort_routine) VALUES +('lcc', 'Типовые правила заполнения для КБК', 'LCC') +ON DUPLICATE KEY UPDATE description='Типовые правила заполнения для КБК',sort_routine='LCC'; + +INSERT INTO class_sort_rules (class_sort_rule, description, sort_routine) VALUES +('generic', 'Правила заполнения для обобщённого библиотечного шифра', 'Generic') +ON DUPLICATE KEY UPDATE description='Правила заполнения для обобщённого библиотечного шифра',sort_routine='Generic'; TRUNCATE class_sources; diff --git a/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql b/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql new file mode 100755 index 0000000000..c87d407d29 --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.sql @@ -0,0 +1,52 @@ +TRUNCATE userflags; + +INSERT INTO userflags (bit, flag, flagdesc, defaulton) VALUES + (0, 'superlibrarian', 'Доступ ко всем библиотечным функциям',0), + (1, 'circulate', 'Оборот книг',0), + (2, 'catalogue', 'Просмотр каталога (интерфейс библиотекаря)',0), + (3, 'parameters', 'Установка системных настроек Koha',0), + (4, 'borrowers', 'Внесение и изменение посетителей',0), + (5, 'permissions', 'Установка привилегий пользователя',0), + (6, 'reserveforothers','Резервирование книжек для посетителей',0), + (7, 'borrow', 'Заем книг',1), + (9, 'editcatalogue', 'Изменение каталога (изменение библиографических/локальных данных)',0), + (10,'updatecharges', 'Обновление оплат пользователей',0), + (11,'acquisition', 'Управление поступлениями и/или предложениями',0), + (12,'management', 'Установка параметров управления библиотекой',0), + (13,'tools', 'Использование инструментов (экспорт, импорт, штрих-коды)',0), + (14,'editauthorities', 'Разрешение на изменение авторитетных источников',0), + (15,'serials', 'Разрешение на управление подпиской периодических изданий',0), + (16,'reports', 'Разрешение на доступ к модулю отчетов',0), + (17,'staffaccess', 'Смена имени(логина)/привилегий для работников библиотеки',0) +; + +TRUNCATE permissions; + +INSERT INTO permissions (module_bit, code, description) VALUES + ( 1, 'circulate_remaining_permissions', 'Remaining circulation permissions'), + ( 1, 'override_renewals', 'Override blocked renewals'), + (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', 'Планирование задач к выполнению'), + (15, 'check_expiration', 'Check the expiration of a serial'), + (15, 'claim_serials', 'Claim missing serials'), + (15, 'create_subscription', 'Create a new subscription'), + (15, 'delete_subscription', 'Delete an existing subscription'), + (15, 'edit_subscription', 'Edit an existing subscription'), + (15, 'receive_serials', 'Serials receiving'), + (15, 'renew_subscription', 'Renew a subscription'), + (15, 'routing', 'Routing') +; + diff --git a/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.txt b/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.txt new file mode 100755 index 0000000000..a9224c312a --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/permissions_and_user_flags.txt @@ -0,0 +1 @@ +Типовые отметки о привилегиях пользователя и детализированные привилегии для сотрудников библиотеки. diff --git a/installer/data/mysql/ru-RU/mandatory/stopwords.txt b/installer/data/mysql/ru-RU/mandatory/stopwords.txt index 0dc1831df8..f66cef3cd5 100644 --- a/installer/data/mysql/ru-RU/mandatory/stopwords.txt +++ b/installer/data/mysql/ru-RU/mandatory/stopwords.txt @@ -1 +1 @@ -Несущественные русские слова. Вы можете корректировать их после установки. +Несущественные для поиска русские слова. Вы можете корректировать их после установки. diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql index d96e6a6641..bb7274aac3 100644 --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql +++ b/installer/data/mysql/ru-RU/mandatory/subtag_registry.sql @@ -496,7 +496,7 @@ 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'); +VALUES( 'es','spa'); INSERT INTO language_descriptions(subtag, type, lang, description) VALUES( 'es', 'language', 'es', 'Español'); diff --git a/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt b/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt index e23e73e995..8a5db01599 100644 --- a/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt +++ b/installer/data/mysql/ru-RU/mandatory/subtag_registry.txt @@ -1,5 +1,4 @@ -Поддержка интернационализации(I18N) в Koha - -Поддержка двунаправленности(BIDI); арабский и иврит. +Поддержка интернационализации (I18N) в Koha +Поддержка двунаправленности (BIDI); арабский и иврит. Стандартное отображение между письмом и подкодами языка. Расширения языка. diff --git a/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql b/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql new file mode 100755 index 0000000000..29d366790f --- /dev/null +++ b/installer/data/mysql/ru-RU/mandatory/system_preferences_full_optimal_for_install_only.sql @@ -0,0 +1,261 @@ +TRUNCATE systempreferences; + +-- Admin - Управление +-- Acquisitions - Поступления +-- EnhancedContent - Расширенное содержимое +-- Authorities - Авторитетные источники +-- Cataloguing - Каталогизация +-- Circulation - Оборот +-- I18N/L10N +-- Logs - Протоколы +-- OAI-PMH +-- OPAC - Электронный каталог +-- Patrons - Посетители +-- Searching - Искание +-- StaffClient - Клиент для библиотекарей +-- Local Use - Местное использование + +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('AmazonEnabled',0,'Turn ON Amazon Content - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonReviews',0,'Display Amazon review on staff interface - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonSimilarItems',0,'Turn ON Amazon Similar Items feature - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACAmazonEnabled',0,'Turn ON Amazon Content in the OPAC - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACAmazonSimilarItems',0,'Turn ON Amazon Similar Items feature - You MUST set AWSAccessKeyID, AWSPrivateKey, and AmazonAssocTag if enabled','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonLocale','US','Use to set the Locale of your Amazon.com Web Services','US|CA|DE|FR|JP|UK','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AWSAccessKeyID','','See: http://aws.amazon.com','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AmazonAssocTag','','See: http://aws.amazon.com','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('AnonSuggestions',0,'Set to anonymous borrowernumber to enable Anonymous suggestions',NULL,'free'); + + +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('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','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','normal|marc|isbd|labeled_marc','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('intranetcolorstylesheet','','Define the color stylesheet to use in the Staff Client','','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','#942||{942j}|
+#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 }| +#952|
|{\n952b}{ - 952o}{ [952p]}|
+#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','942hv','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','udc','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'); +-- OEGO: фактически не было добавлено установщиком + +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',1,'Enable patron images for the Staff Client',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('printcirculationslips',1,'If ON, enable printing circulation receipts','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('RequestOnOpac',1,'If ON, globally enables patron holds on OPAC',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReservesMaxPickUpDelay',7,'Define the Maximum delay to pick up an item on hold','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReturnBeforeExpiry',0,'If ON, checkout will be prevented if returndate is after patron card expiry',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReturnLog',1,'If ON, enables the circulation (returns) log',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('reviewson',1,'If ON, enables patron reviews of bibliographic records in the OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('sortbynonfiling',0,'Sort search results by MARC nonfiling characters (deprecated)',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SpecifyDueDate',1,'Define whether to display \"Specify Due Date\" form in Circulation','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SubscriptionHistory',';','Define the display preference for serials issue history in OPAC','simplified|full','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('SubscriptionLog',1,'If ON, enables subscriptions log',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('suggestion',1,'If ON, enables patron suggestions feature in OPAC','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('template','prog','Define the preferred staff interface template','','Themes'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('TemplateEncoding','utf-8','Globally define the default character encoding','iso-8859-1|utf-8','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('timeout',12000000,'Inactivity timeout for cookies authentication (in seconds)',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('TransfersMaxDaysWarning',3,'Define the days before a transfer is suspected of having a problem',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('useDaysMode','Calendar','Choose the method for calculating due date: select Calendar to use the holidays module, and Days to ignore the holidays module','Calendar|Days|Datedue','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('virtualshelves',1,'If ON, enables Lists management','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('z3950AuthorAuthFields','701,702,700','Define the MARC biblio fields for Personal Name Authorities to fill biblio.author',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('z3950NormalizeAuthor',0,'If ON, Personal Name Authorities will replace authors in biblio.author','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('ReservesNeedReturns',1,'If ON, a hold placed on an item available in this library must be checked-in, otherwise, a hold on a specific item, that is in the library & available is considered available','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('DebugLevel',2,'Define the level of debugging information sent to the browser when errors are encountered (set to 0 in production). 0=none, 1=some, 2=most','0|1|2','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('NoZebra',1,'If ON, Zebra indexing is turned off, simpler setup, but slower searches. WARNING: using NoZebra on even modest sized collections is very slow.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('SessionStorage','mysql','Use database or a temporary file for storing session data','mysql|Pg|tmp','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('CircAutocompl',1,'If ON, autocompletion is enabled for the Circulation input',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('RoutingSerials',1,'If ON, serials routing is enabled',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('SearchMyLibraryFirst',0,'If ON, OPAC searches return results limited by the user\'s library by default if they are logged in',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('dontmerge',1,'If ON, modifying an authority record will not update all associated bibliographic records immediately, ask your system administrator to enable the merge_authorities.pl cron job',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('BiblioAddsAuthorities',0,'If ON, adding a new biblio will check for an existing authority record and create one on the fly if one doesn\'t exist',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('QueryStemming',1,'If ON, enables query stemming',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('QueryFuzzy',1,'If ON, enables fuzzy option for searches',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('QueryWeightFields',1,'If ON, enables field weighting',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('yuipath','local','Insert the path to YUI libraries, choose local if you use koha offline',"local|http://yui.yahooapis.com/2.5.1/build",'Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('canreservefromotherbranches',1,'With Independent branches on, can a user from one library place a hold on an item from another library','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('FRBRizeEditions',0,'If ON, Koha will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OPACFRBRizeEditions',0,'If ON, the OPAC will query one or more ISBN web services for associated ISBNs and display an Editions tab on the details pages','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('XISBN',0,'Use with FRBRizeEditions. If ON, Koha will use the OCLC xISBN web service in the Editions tab on the detail pages. See: http://www.worldcat.org/affiliate/webservices/xisbn/app.jsp','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('OCLCAffiliateID','','Use with FRBRizeEditions and XISBN. You can sign up for an AffiliateID here: http://www.worldcat.org/wcpa/do/AffiliateUserServices?method=initSelfRegister','','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('XISBNDailyLimit',499,'The xISBN Web service is free for non-commercial use when usage does not exceed 500 requests per day','','Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('PINESISBN',0,'Use with FRBRizeEditions. If ON, Koha will use PINES OISBN web service in the Editions tab on the detail pages.','','YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES ('ThingISBN',0,'Use with FRBRizeEditions. If ON, Koha will use the ThingISBN web service in the Editions tab on the detail pages.','','YesNo'); + +-- I18N/L10N +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('dateformat','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','','Integer'); +-- need AddressType to distinguish between US and other, telephone numbers, maori stuff, sex, nationality, etc. +-- LDAP ? required fields? +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('WebBasedSelfCheck',0,'If ON, enables the web-based self-check system',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('numSearchResults',20,'Specify the maximum number of results to display on a page of results',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACnumSearchResults',20,'Specify the maximum number of results to display on a page of results',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('defaultSortField',NULL,'Specify the default field used for sorting','relevance|popularity|call_number|pubdate|acqdate|title|author','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('defaultSortOrder',NULL,'Specify the default sort order','asc|dsc|az|za','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACdefaultSortField',NULL,'Specify the default field used for sorting','relevance|popularity|call_number|pubdate|acqdate|title|author','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('OPACdefaultSortOrder',NULL,'Specify the default sort order','asc|dsc|za|az','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('staffClientBaseURL','','Specify the base URL of the staff client',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('minPasswordLength',3,'Specify the minimum length of a patron/staff password',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('noItemTypeImages',0,'If ON, disables item-type images',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('emailLibrarianWhenHoldIsPlaced',0,'If ON, emails the librarian whenever a hold is placed',NULL,'YesNo'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('holdCancelLength','','Specify how many days before a hold is canceled',NULL,'Integer'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('libraryAddress','','The address to use for printing receipts, overdues, etc. if different than physical address',NULL,'free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('finesMode','test','Choose the fines mode, \'off\', \'test\' (emails admin report) or \'production\' (accrue overdue fines). Requires accruefines cronjob.','off|test|production','Choice'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('globalDueDate','','If set, allows a global static due date for all checkouts','10','free'); +INSERT INTO `systempreferences` (variable,value,explanation,options,type) VALUES('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