From 78ce2bcb9f2217d5142a3257ff02ca647dd0ecac Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 27 Sep 2016 10:52:17 +0100 Subject: [PATCH] Bug 17357: Replace WTHDRAWN with WITHDRAWN in installer files MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Some installer files still use WTHDRAWN instead of WITHDRAWN as an AV category. Test plan: git grep WTHDRAWN installer should not return any results Signed-off-by: Marc Véron Signed-off-by: Katrin Fischer Signed-off-by: Brendan Gallagher (cherry picked from commit ce076e0e757ff812eba21ee6102e6c44076e5595) Signed-off-by: Frédéric Demians --- installer/data/mysql/atomicupdate/bug_17357.sql | 1 + .../unimarc/mandatory/unimarc_framework_DEFAULT.sql | 2 +- .../unimarc/mandatory/unimarc_framework_DEFAULT.sql | 2 +- .../unimarc/mandatory/unimarc_framework_DEFAULT.sql | 4 ++-- .../mandatory/unimarc_bibliographic_DEFAULT_local_995.sql | 2 +- .../unimarc_bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- .../mandatory/unimarc_bibliographic_DEFAULT_local_995.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_AN_local.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_AUD_local.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_BOOK_local.sql | 2 +- .../unimarc_bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_EL_local.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_MIN_local.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_NOTE_local.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_PER_local.sql | 2 +- .../unimarc/optional/unimarc_bibliographic_TECH_local.sql | 2 +- 16 files changed, 17 insertions(+), 16 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_17357.sql diff --git a/installer/data/mysql/atomicupdate/bug_17357.sql b/installer/data/mysql/atomicupdate/bug_17357.sql new file mode 100644 index 0000000000..9cd6b102d4 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_17357.sql @@ -0,0 +1 @@ +UPDATE marc_subfield_structure SET authorised_value="WITHDRAWN" WHERE authorised_value="WTHDRAWN"; diff --git a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql index f93af2cbbb..94ccaa9f96 100644 --- a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql @@ -128,7 +128,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES - ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), + ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), ('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL), ('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL), diff --git a/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql index 2aedc4aec3..8b0353debf 100644 --- a/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql +++ b/installer/data/mysql/es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql @@ -121,7 +121,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES - ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), + ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), ('995', '2', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL), ('995', '5', 'Date acquired', 'Coded location qualifier', 0, 0, 'items.dateaccessioned', 10, '', '', '', NULL, 0, '', '', '', NULL), diff --git a/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql index 412cc5e915..5ec0a2fe1e 100644 --- a/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql +++ b/installer/data/mysql/pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql @@ -118,7 +118,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` -- ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); -- INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES --- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), +-- ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), -- ('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), -- ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', 'unimarc_en_classcodes.pl', NULL, 0, '', '', '', NULL), -- ('995', '3', 'Classification part', 'Classification part', 0, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL), @@ -171,7 +171,7 @@ INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat ('995', 'Location and Item Information (Koha)', 'Location and Item Information (Koha)', 0, 0, '', ''); INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `kohafield`, `tab`, `authorised_value`, `authtypecode`, `value_builder`, `isurl`, `hidden`, `frameworkcode`, `seealso`, `link`, `defaultvalue`) VALUES - ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WTHDRAWN', '', '', 0, 0, '', '', '', NULL), + ('995', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', 0, 0, '', '', '', NULL), ('995', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', 0, 0, '', '', '', NULL), ('995', '2', 'System code (specific classification or other scheme and edition)', 'System code (specific classification or other scheme and edition)', 0, 0, '', 10, '', '', '', NULL, 0, '', '', '', NULL), ('995', '3', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', 0, 0, '', '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql index 2f39c572a9..c6aad46de1 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql @@ -315,7 +315,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '995', '', '', 'Данные о экземплярах и расположение (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '995', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('', '', '995', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('', '', '995', '1', 0, 0, 'Статус повреждения', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('', '', '995', '2', 0, 0, 'Статус потери/отсутствия', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('', '', '995', '3', 0, 0, 'Статус ограничения доступа', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql index bb0d9bc7d3..2086895536 100644 --- a/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql +++ b/installer/data/mysql/ru-RU/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql @@ -95,7 +95,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '952', '', '', 'Данные о экземплярах и расположение (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('', '', '952', '0', 0, 0, 'Статус изъятия', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('', '', '952', '1', 0, 0, 'Статус доступности', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('', '', '952', '2', 0, 0, 'Источник классификации или схема полочного расположения', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), ('', '', '952', '3', 0, 0, 'Идентификация описываемого материала (объединенный том или иная часть)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql index eed5b69cf1..60909769a7 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql index 3b688b2af4..04c80a48a2 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AN', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('AN', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('AN', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('AN', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('AN', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('AN', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql index e488812461..cda04e274c 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('AUD', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('AUD', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('AUD', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('AUD', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('AUD', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('AUD', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql index 961bcddf40..25acef152c 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('BOOK', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('BOOK', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('BOOK', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('BOOK', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('BOOK', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('BOOK', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql index 295c0bc96f..3c5b3970e5 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql @@ -101,7 +101,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('', '952', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('', '', '952', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('', '', '952', '1', 0, 0, 'Статус доступності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('', '', '952', '2', 0, 0, 'Джерело класифікації чи схема поличного розташування', '', 10, 0, 'items.cn_source', 'cn_source', '', NULL, '', '', NULL), ('', '', '952', '3', 0, 0, 'Ідентифікація описуваного матеріалу (об’єднаний том чи інша частина)', '', 10, -1, 'items.materials', '', '', NULL, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql index 57a02c3298..071747b451 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('EL', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('EL', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('EL', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('EL', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('EL', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('EL', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql index c183f919c6..1501e12a89 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('MIN', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('MIN', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('MIN', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('MIN', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('MIN', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('MIN', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql index cdfe6d0ddb..25719b99d0 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('NOTE', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('NOTE', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('NOTE', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('NOTE', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('NOTE', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('NOTE', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql index 9d3eab8566..98d02bf016 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('PER', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('PER', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('PER', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('PER', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('PER', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('PER', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), diff --git a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql index 0729296643..54cee9c6bf 100644 --- a/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/unimarc/optional/unimarc_bibliographic_TECH_local.sql @@ -285,7 +285,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES ('TECH', '995', '', '', 'Дані про примірники та розташування (Koha)', '', ''); INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tagsubfield, mandatory, repeatable, liblibrarian, libopac, tab, hidden, kohafield, authorised_value, value_builder, isurl, seealso, link, defaultvalue) VALUES - ('TECH', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WTHDRAWN', '', 0, '', '', NULL), + ('TECH', '', '995', '0', 0, 0, 'Статус вилучення', '', 10, 0, 'items.withdrawn', 'WITHDRAWN', '', 0, '', '', NULL), ('TECH', '', '995', '1', 0, 0, 'Стан пошкодження', '', 10, 0, 'items.damaged', 'DAMAGED', '', 0, '', '', NULL), ('TECH', '', '995', '2', 0, 0, 'Статус втрати/відсутності', '', 10, 0, 'items.itemlost', 'LOST', '', 0, '', '', NULL), ('TECH', '', '995', '3', 0, 0, 'Статус обмеження доступу', '', 10, 0, 'items.restricted','RESTRICTED', '', 0, '', '', NULL), -- 2.20.1