Bugzilla – Attachment 34417 Details for
Bug 13023
Nonpublic note for items should be mapped to a database column like itemnotes
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 13023 [QA Followup] - Add db mapping to default marc21 frameworks
Bug-13023-QA-Followup---Add-db-mapping-to-default-.patch (text/plain), 13.72 KB, created by
Kyle M Hall (khall)
on 2014-12-15 13:17:35 UTC
(
hide
)
Description:
Bug 13023 [QA Followup] - Add db mapping to default marc21 frameworks
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2014-12-15 13:17:35 UTC
Size:
13.72 KB
patch
obsolete
>From 5130c33128e1444eff4a2823f45c5bcd11239c1a Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >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..d610ba2 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, '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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 13023
:
31979
|
31980
|
32400
|
32401
|
32513
|
32663
|
33501
|
34361
|
34366
|
34416
|
34417
|
34418
|
34427
|
34428
|
35611
|
38428