From faca2db25de46821bbca088530ec20b2fe032e99 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Mon, 15 Dec 2014 07:02:13 -0500 Subject: [PATCH] Bug 13023 [QA Followup] - Add db mapping to default marc21 frameworks --- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../Obligatoire/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21/mandatory/marc21_framework_DEFAULT.sql | 2 +- .../marc21_bibliographic_DEFAULT_local.sql | 2 +- .../marc21_bibliographic_DEFAULT_local.sql | 2 +- 9 files changed, 9 insertions(+), 9 deletions(-) diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 8907e1b..314c7b8 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'URL', 'URL', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Preis bei Buchersatz', 'Preis bei Buchersatz', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Preis gültig von', 'Preis gültig von', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Interne Notiz', 'Interne Notiz', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Interne Notiz', 'Interne Notiz', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha-Medientyp', 'Koha-Medientyp', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'OPAC-Notiz', 'OPAC-Notiz', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index e388649..f7d94d6 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index e2ebfd3..06d497e 100644 --- a/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/es-ES/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'Identificador Uniforme del Recurso', 'Identificador Uniforme del Recurso', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Coste, precio de reemplazo', 'Coste, precio de reemplazo', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Precio válido a partir de', 'Precio válido a partir de', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Nota no pública', 'Nota no pública', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Nota no pública', 'Nota no pública', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Tipo de ítem Koha', 'Tipo de ítem Koha', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Nota pública', 'Nota pública', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql index adab600..c5d201b 100644 --- a/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Obligatoire/marc21_framework_DEFAULT.sql @@ -135,7 +135,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index a1c99d8..9e82630 100644 --- a/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/it-IT/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -119,7 +119,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib ('952', 'u', 'URI (Uniform Resource Identifier)', 'URI (Uniform Resource Identifier)', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Costo, costo di riacquisto', 'Costo, costo di riacquisto', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Prezzo in vigore dal', 'Prezzo in vigore dal', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Nota non pubblica', 'Nota non pubblica', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Tipo copia default (Koha)', 'Tipo copia default (Koha)', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Nota pubblica', 'Nota pubblica', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index ac32486..549f445 100644 --- a/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/nb-NO/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -135,7 +135,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql index 81262a6..0b38ba3 100644 --- a/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql +++ b/installer/data/mysql/pl-PL/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql @@ -135,7 +135,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', 1, 0, '', '', '', NULL), ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', 0, 0, '', '', '', NULL), ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', 0, 0, '', '', '', NULL), - ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, '', 10, '', '', '', NULL, 1, '', '', '', NULL), + ('952', 'x', 'Non-public note', 'Non-public note', 0, 0, 'items.itemnotes_nonpublic', 10, '', '', '', NULL, 1, '', '', '', NULL), ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, '', '', '', NULL), ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, '', '', '', NULL); diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql index 7ef66e5..6d972e8 100644 --- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql +++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql @@ -818,7 +818,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '952', 'u', 0, 0, 'Унифицированный идентификатор ресурсов', '', 10, 0, 'items.uri', '', '', 1, '', '', NULL), ('', '', '952', 'v', 0, 0, 'Стоимость, цена замены', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('', '', '952', 'w', 0, 0, 'Дата, для которой действительна цена замены', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), - ('', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, '', '', '', NULL, '', '', NULL), + ('', '', '952', 'x', 0, 0, 'Служебное (необщедоступное) примечание', '', 10, 1, 'items.itemnotes_nonpublic', '', '', NULL, '', '', NULL), ('', '', '952', 'y', 0, 0, 'Тип единицы (уровень экземпляра)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('', '', '952', 'z', 0, 0, 'Общедоступное примечание о экземпляре', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql index ba5d4e7..38b2cd3 100644 --- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql +++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_local.sql @@ -818,7 +818,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag ('', '', '952', 'u', 0, 0, 'Уніфікований ідентифікатор ресурсів', '', 10, 0, 'items.uri', '', '', 1, '', '', NULL), ('', '', '952', 'v', 0, 0, 'Вартість, ціна заміни', '', 10, 0, 'items.replacementprice', '', '', 0, '', '', NULL), ('', '', '952', 'w', 0, 0, 'Дата, для якої чинна ціна заміни', '', 10, 0, 'items.replacementpricedate', '', '', 0, '', '', NULL), - ('', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, '', '', '', NULL, '', '', NULL), + ('', '', '952', 'x', 0, 0, 'Службова (незагальнодоступна) примітка', '', 10, 1, 'items.itemnotes_nonpublic', '', '', NULL, '', '', NULL), ('', '', '952', 'y', 0, 0, 'Тип одиниці (рівень примірника)', '', 10, 0, 'items.itype', 'itemtypes', '', NULL, '', '', NULL), ('', '', '952', 'z', 0, 0, 'Загальнодоступна примітка щодо примірника', '', 10, 0, 'items.itemnotes', '', '', NULL, '', '', NULL); -- 1.7.2.5