From ee2919c51509bc3fd3b68dd407f7c547563721e0 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 27 Sep 2016 10:52:17 +0100 Subject: [PATCH] [PASSED QA] Bug 17357: Replace WTHDRAWN with WITHDRAWN in installer files MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 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 --- installer/data/mysql/atomicupdate/bug_17357.sql | 1 + .../en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql | 2 +- .../es-ES/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql | 2 +- .../pl-PL/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql | 4 ++-- .../unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql | 2 +- .../optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- .../unimarc/mandatory/unimarc_bibliographic_DEFAULT_local_995.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_AN_local.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_AUD_local.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_BOOK_local.sql | 2 +- .../optional/unimarc_bibliographic_DEFAULT_local_952_obsolete.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_EL_local.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_MIN_local.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_NOTE_local.sql | 2 +- .../marcflavour/unimarc/optional/unimarc_bibliographic_PER_local.sql | 2 +- .../marcflavour/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 0000000..9cd6b10 --- /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 b93956b..99d81be 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 ea630bb..e565ff0 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 f355884..5686c0d 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 2f39c57..c6aad46 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 bb0d9bc..2086895 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 eed5b69..6090976 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 3b688b2..04c80a4 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 e488812..cda04e2 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 961bcdd..25acef1 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 295c0bc..3c5b397 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 57a02c3..071747b 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 c183f91..1501e12 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 cdfe6d0..25719b9 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 9d3eab8..98d02bf 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 0729296..54cee9c 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.7.4