Bugzilla – Attachment 81930 Details for
Bug 11529
Add subtitle, medium and part fields to biblio table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11529: Add new fields to biblio table
Bug-11529-Add-new-fields-to-biblio-table.patch (text/plain), 69.16 KB, created by
Ere Maijala
on 2018-11-05 12:23:09 UTC
(
hide
)
Description:
Bug 11529: Add new fields to biblio table
Filename:
MIME Type:
Creator:
Ere Maijala
Created:
2018-11-05 12:23:09 UTC
Size:
69.16 KB
patch
obsolete
>From a36aa659806292e6aa60828547cfaf80c55c1a58 Mon Sep 17 00:00:00 2001 >From: Ere Maijala <ere.maijala@helsinki.fi> >Date: Mon, 5 Nov 2018 14:22:01 +0200 >Subject: [PATCH] Bug 11529: Add new fields to biblio table > >--- > C4/Biblio.pm | 20 +++++-- > installer/data/mysql/atomicupdate/bug_11529.perl | 34 ++++++++++++ > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 6 +-- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 6 +-- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 6 +-- > .../obligatoire/marc21_framework_DEFAULT.sql | 2 +- > .../Obligatoire/marc21_framework_DEFAULT.sql | 6 +-- > .../Optionnel/marc21_simple_bib_frameworks.sql | 44 +++++++-------- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 6 +-- > installer/data/mysql/kohastructure.sql | 8 +++ > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 6 +-- > .../marcflavour/normarc/Obligatorisk/normarc.sql | 6 +-- > .../marc21/mandatory/marc21_framework_DEFAULT.sql | 6 +-- > .../marc21_bibliographic_DEFAULT_general.sql | 6 +-- > .../marc21_bibliographic_DEFAULT_general.sql | 6 +-- > t/db_dependent/Biblio.t | 62 ++++++++++++++++++++-- > 16 files changed, 170 insertions(+), 60 deletions(-) > create mode 100644 installer/data/mysql/atomicupdate/bug_11529.perl > >diff --git a/C4/Biblio.pm b/C4/Biblio.pm >index 50c7c4c..57b2413 100644 >--- a/C4/Biblio.pm >+++ b/C4/Biblio.pm >@@ -2895,6 +2895,10 @@ sub _koha_add_biblio { > SET frameworkcode = ?, > author = ?, > title = ?, >+ subtitle = ?, >+ medium = ?, >+ part_number = ?, >+ part_name = ?, > unititle =?, > notes = ?, > serial = ?, >@@ -2905,8 +2909,10 @@ sub _koha_add_biblio { > "; > my $sth = $dbh->prepare($query); > $sth->execute( >- $frameworkcode, $biblio->{'author'}, $biblio->{'title'}, $biblio->{'unititle'}, $biblio->{'notes'}, >- $biblio->{'serial'}, $biblio->{'seriestitle'}, $biblio->{'copyrightdate'}, $biblio->{'abstract'} >+ $frameworkcode, $biblio->{'author'}, $biblio->{'title'}, $biblio->{'subtitle'}, >+ $biblio->{'medium'}, $biblio->{'part_number'}, $biblio->{'part_name'}, $biblio->{'unititle'}, >+ $biblio->{'notes'}, $biblio->{'serial'}, $biblio->{'seriestitle'}, $biblio->{'copyrightdate'}, >+ $biblio->{'abstract'} > ); > > my $biblionumber = $dbh->{'mysql_insertid'}; >@@ -2938,6 +2944,10 @@ sub _koha_modify_biblio { > SET frameworkcode = ?, > author = ?, > title = ?, >+ subtitle = ?, >+ medium = ?, >+ part_number = ?, >+ part_name = ?, > unititle = ?, > notes = ?, > serial = ?, >@@ -2950,8 +2960,10 @@ sub _koha_modify_biblio { > my $sth = $dbh->prepare($query); > > $sth->execute( >- $frameworkcode, $biblio->{'author'}, $biblio->{'title'}, $biblio->{'unititle'}, $biblio->{'notes'}, >- $biblio->{'serial'}, $biblio->{'seriestitle'}, $biblio->{'copyrightdate'}, $biblio->{'abstract'}, $biblio->{'biblionumber'} >+ $frameworkcode, $biblio->{'author'}, $biblio->{'title'}, $biblio->{'subtitle'}, >+ $biblio->{'medium'}, $biblio->{'part_number'}, $biblio->{'part_name'}, $biblio->{'unititle'}, >+ $biblio->{'notes'}, $biblio->{'serial'}, $biblio->{'seriestitle'}, $biblio->{'copyrightdate'}, >+ $biblio->{'abstract'}, $biblio->{'biblionumber'} > ) if $biblio->{'biblionumber'}; > > if ( $dbh->errstr || !$biblio->{'biblionumber'} ) { >diff --git a/installer/data/mysql/atomicupdate/bug_11529.perl b/installer/data/mysql/atomicupdate/bug_11529.perl >new file mode 100644 >index 0000000..6f96fc2 >--- /dev/null >+++ b/installer/data/mysql/atomicupdate/bug_11529.perl >@@ -0,0 +1,34 @@ >+$DBversion = 'XXX'; # will be replaced by the RM >+if( CheckVersion( $DBversion ) ) { >+ if( !column_exists( 'biblio', 'subtitle' ) ) { >+ $dbh->do( "ALTER TABLE biblio ADD COLUMN medium LONGTEXT AFTER title" ); >+ $dbh->do( "ALTER TABLE biblio ADD COLUMN subtitle LONGTEXT AFTER medium" ); >+ $dbh->do( "ALTER TABLE biblio ADD COLUMN part_number LONGTEXT AFTER subtitle" ); >+ $dbh->do( "ALTER TABLE biblio ADD COLUMN part_name LONGTEXT AFTER part_number" ); >+ >+ $dbh->do( "ALTER TABLE deletedbiblio ADD COLUMN medium LONGTEXT AFTER title" ); >+ $dbh->do( "ALTER TABLE deletedbiblio ADD COLUMN subtitle LONGTEXT AFTER medium" ); >+ $dbh->do( "ALTER TABLE deletedbiblio ADD COLUMN part_number LONGTEXT AFTER subtitle" ); >+ $dbh->do( "ALTER TABLE deletedbiblio ADD COLUMN part_name LONGTEXT AFTER part_number" ); >+ } >+ >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.subtitle' WHERE kohafield='bibliosubtitle.subtitle'" ); >+ >+ my $marcflavour = C4::Context->preference('marcflavour'); >+ >+ if ( $marcflavour eq 'MARC21' || $marcflavour eq 'NORMARC' ) { >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.medium' WHERE frameworkcode='' AND tagfield='245' AND tagsubfield='h'" ); >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.subtitle' WHERE frameworkcode='' AND tagfield='245' AND tagsubfield='b'" ); >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.part_number' WHERE frameworkcode='' AND tagfield='245' AND tagsubfield='n'" ); >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.part_name' WHERE frameworkcode='' AND tagfield='245' AND tagsubfield='p'" ); >+ } elsif ( $marcflavour eq 'UNIMARC' ) { >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.medium' WHERE frameworkcode='' AND tagfield='200' AND tagsubfield='b'" ); >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.subtitle' WHERE frameworkcode='' AND tagfield='200' AND tagsubfield='e'" ); >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.part_number' WHERE frameworkcode='' AND tagfield='200' AND tagsubfield='h'" ); >+ $dbh->do( "UPDATE marc_subfield_structure SET kohafield='biblio.part_name' WHERE frameworkcode='' AND tagfield='200' AND tagsubfield='i'" ); >+ } >+ >+ # Always end with this (adjust the bug info) >+ SetVersion( $DBversion ); >+ print "Upgrade to $DBversion done (Bug 11529 - Add medium, subtitle and part information to biblio table)\n"; >+} >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 45a94b8..9e73bcd 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 >@@ -1066,7 +1066,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Feldverknüpfung und Reihenfolge', 'Feldverknüpfung und Reihenfolge', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'Titel', 'Titel', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Zusatz zum Titel', 'Zusatz zum Titel', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Zusatz zum Titel', 'Zusatz zum Titel', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Verfasserangabe etc.', 'Verfasserangabe etc.', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section/part/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -1074,8 +1074,8 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', 'g', 'Zeitabschnitt', 'Zeitabschnitt', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Zählung des Teils/der Abteilung eines Werkes', 'Zählung des Teils/der Abteilung eines Werkes', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Titel eines Teils/einer Abteilung eines Werkes', 'Titel eines Teils/einer Abteilung eines Werkes', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Zählung des Teils/der Abteilung eines Werkes', 'Zählung des Teils/der Abteilung eines Werkes', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Titel eines Teils/einer Abteilung eines Werkes', 'Titel eines Teils/einer Abteilung eines Werkes', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Das Unterfeld gibt die Institution an, auf die sich das Feld bezieht', 'Das Unterfeld gibt die Institution an, auf die sich das Feld bezieht', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Verknüpfung', 'Verknüpfung', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', 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 4b77adf..6d3cb1d 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 >@@ -1066,7 +1066,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc.', 'Statement of responsibility, etc.', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -1074,8 +1074,8 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', 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 fdf4e66..2fc830a0 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 >@@ -1037,7 +1037,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Enlace entre campo y número de secuencia', 'Enlace entre campo y número de secuencia', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'TÃtulo', 'TÃtulo', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Resto del tÃtulo', 'Resto del tÃtulo', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Resto del tÃtulo', 'Resto del tÃtulo', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Mención de responsabilidad, etc.', 'Mención de responsabilidad, etc.', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designación de sección/parte/serie (SE) [OBSOLETO]', 'Designación de sección/parte/serie (SE) [OBSOLETO]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Nombre de parte/sección/serie', 'Nombre de parte/sección/serie', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -1045,8 +1045,8 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', 'g', 'Fechas predominantes', 'Fechas predominantes', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Medio', 'Medio', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Forma', 'Forma', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Número de parte o sección de la obra', 'Número de parte o sección de la obra', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Nombre de parte o sección de la obra', 'Nombre de parte o sección de la obra', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Número de parte o sección de la obra', 'Número de parte o sección de la obra', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Nombre de parte o sección de la obra', 'Nombre de parte o sección de la obra', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Versión', 'Versión', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Institución que aplica el campo', 'Institución que aplica el campo', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Enlace', 'Enlace', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >diff --git a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql >index 737d4ea..b73eb1c 100644 >--- a/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql >+++ b/installer/data/mysql/fr-CA/marcflavour/marc21/obligatoire/marc21_framework_DEFAULT.sql >@@ -849,7 +849,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ("245","6","Liaison","Liaison","0","0","","2","","","","0","-6","","","","","9999"), > ("245","8","Numéro de liaison de zone et de séquence","Numéro de liaison de zone et de séquence","1","0","","2","","","","0","-6","","","","","9999"), > ("245","a","Titre","Titre","0","1","biblio.title","2","","","","0","0","","'245b','245f','245g','245k','245n','245p','245s','245h','246i','246a','246b','246f','246g','246n','246p','246h','242a','242b','242n','242p','242h','505t'","","","9999"), >-("245","b","Reste du titre","Reste du titre","0","0","bibliosubtitle.subtitle","2","","","","0","0","","","","","9999"), >+("245","b","Reste du titre","Reste du titre","0","0","biblio.subtitle","2","","","","0","0","","","","","9999"), > ("245","c","Mention de responsabilité, etc.","Mention de responsabilité, etc.","0","0","","2","","","","0","0","","","","","9999"), > ("245","f","Dates extrêmes","Dates extrêmes","0","0","","2","","","","0","-6","","","","","9999"), > ("245","g","Dates générales","Dates générales","0","0","","2","","","","0","-6","","","","","9999"), >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 8f447bb..14b1e0c 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 >@@ -967,7 +967,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -975,8 +975,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >index c7c6be6..1249e67 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_simple_bib_frameworks.sql >@@ -992,7 +992,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'BKS', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'BKS', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'BKS', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'BKS', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), >@@ -1000,8 +1000,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, 'BKS', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'BKS', '', '', NULL), >@@ -4919,7 +4919,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'CF', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'CF', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'CF', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'CF', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), >@@ -4927,8 +4927,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, 'CF', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'CF', '', '', NULL), >@@ -8845,7 +8845,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'SR', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'SR', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'SR', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'SR', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), >@@ -8853,8 +8853,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, 'SR', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'SR', '', '', NULL), >@@ -12771,7 +12771,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'VR', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'VR', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'VR', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'VR', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), >@@ -12779,8 +12779,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, 'VR', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'VR', '', '', NULL), >@@ -16695,7 +16695,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'AR', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'AR', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'AR', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'AR', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), >@@ -16703,8 +16703,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, 'AR', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'AR', '', '', NULL), >@@ -20619,7 +20619,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'KT', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'KT', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'KT', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'KT', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), >@@ -20627,8 +20627,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, 'KT', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'KT', '', '', NULL), >@@ -24545,7 +24545,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'IR', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'IR', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'IR', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'IR', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), >@@ -24553,8 +24553,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, -1, 'IR', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'IR', '', '', NULL), >@@ -28466,7 +28466,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, 'SER', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, 'SER', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, 'SER', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, 'SER', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, 'SER', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, 'SER', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'SER', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, 'SER', '', '', 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 d22c1b7..c7bc9d4 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 >@@ -1037,7 +1037,7 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Numero di collegamento e di sequenza di campi', 'Numero di collegamento e di sequenza di campi', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'Titolo', 'Titolo', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Complemento del titolo', 'Complemento del titolo', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Complemento del titolo', 'Complemento del titolo', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Formulazione di responsabilità , ecc.', 'Formulazione di responsabilità , ecc.', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section/part/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -1045,8 +1045,8 @@ INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib > ('245', 'g', 'Date preponderanti', 'Date preponderanti', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Supporto', 'Supporto', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Forma', 'Forma', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Numero di parte/sezione dell\'opera', 'Numero di parte/sezione dell\'opera', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Nome di parte/sezione dell\'opera', 'Nome di parte/sezione dell\'opera', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Numero di parte/sezione dell\'opera', 'Numero di parte/sezione dell\'opera', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Nome di parte/sezione dell\'opera', 'Nome di parte/sezione dell\'opera', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Versione', 'Versione', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Istituzione a cui si applica il campo', 'Istituzione a cui si applica il campo', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Collegamento', 'Collegamento', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 62c0dce..f69f18d 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -132,6 +132,10 @@ CREATE TABLE `biblio` ( -- table that stores bibliographic information > `frameworkcode` varchar(4) NOT NULL default '', -- foreign key from the biblio_framework table to identify which framework was used in cataloging this record > `author` LONGTEXT, -- statement of responsibility from MARC record (100$a in MARC21) > `title` LONGTEXT, -- title (without the subtitle) from the MARC record (245$a in MARC21) >+ `medium` LONGTEXT, -- medium from the MARC record (245$h in MARC21) >+ `subtitle` LONGTEXT, -- remainder of the title from the MARC record (245$b in MARC21) >+ `part_number` LONGTEXT, -- part number from the MARC record (245$n in MARC21) >+ `part_name` LONGTEXT, -- part name from the MARC record (245$p in MARC21) > `unititle` LONGTEXT, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) > `notes` LONGTEXT, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) > `serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial >@@ -485,6 +489,10 @@ CREATE TABLE `deletedbiblio` ( -- stores information about bibliographic records > `frameworkcode` varchar(4) NOT NULL default '', -- foriegn key from the biblio_framework table to identify which framework was used in cataloging this record > `author` LONGTEXT, -- statement of responsibility from MARC record (100$a in MARC21) > `title` LONGTEXT, -- title (without the subtitle) from the MARC record (245$a in MARC21) >+ `medium` LONGTEXT, -- medium from the MARC record (245$h in MARC21) >+ `subtitle` LONGTEXT, -- remainder of the title from the MARC record (245$b in MARC21) >+ `part_number` LONGTEXT, -- part number from the MARC record (245$n in MARC21) >+ `part_name` LONGTEXT, -- part name from the MARC record (245$p in MARC21) > `unititle` LONGTEXT, -- uniform title (without the subtitle) from the MARC record (240$a in MARC21) > `notes` LONGTEXT, -- values from the general notes field in the MARC record (500$a in MARC21) split by bar (|) > `serial` tinyint(1) default NULL, -- Boolean indicating whether biblio is for a serial >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 f88da8b..3e5e360 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 >@@ -967,7 +967,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -975,8 +975,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >diff --git a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql >index 7956a3f..ef645c7 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/normarc/Obligatorisk/normarc.sql >@@ -263,11 +263,11 @@ INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,r > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('240','s','Versjon','Versjon','0','0','0','2','','','','0','-1','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('240','w','Sorteringsdelfelt for delfelt $a','Sorteringsdelfelt for delfelt $a','0','0','0','2','','','','0','-1','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','a','Tittel','Tittel','0','0','biblio.title','2','','','','0','0','','','',NULL,'9999'); >-INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','b','Annen tittelinformasjon','Annen tittelinformasjon','0','0','bibliosubtitle.subtitle','2','','','','0','0','','','',NULL,'9999'); >+INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','b','Annen tittelinformasjon','Annen tittelinformasjon','0','0','biblio.subtitle','2','','','','0','0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','c','Ansvarsangivelse','Ansvarsangivelse','0','0','0','2','','','','0','0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','h','Generell materialbetegnelse','Generell materialbetegnelse','0','0','0','2','','','','0','0','','','',NULL,'9999'); >-INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','n','Nummer for del av verk','Nummer for del av verk','0','0','0','2','','','','0','0','','','',NULL,'9999'); >-INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','p','Tittel for del av verk','Tittel for del av verk','0','0','0','2','','','','0','0','','','',NULL,'9999'); >+INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','n','Nummer for del av verk','Nummer for del av verk','0','0','biblio.part_number','2','','','','0','0','','','',NULL,'9999'); >+INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','p','Tittel for del av verk','Tittel for del av verk','0','0','biblio.part_name','2','','','','0','0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('245','w','Sorteringsdelfelt for delfelt $a','Sorteringsdelfelt for delfelt $a','0','0','0','2','','','','0','0','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('246','a','Parallelltittel','Parallelltittel','0','0','0','2','','','','0','-1','','','',NULL,'9999'); > INSERT INTO marc_subfield_structure (tagfield,tagsubfield,liblibrarian,libopac,repeatable,mandatory,kohafield,tab,authorised_value,authtypecode,value_builder,isurl,hidden,frameworkcode,seealso,link,defaultvalue,maxlength) VALUES ('246','b','Annen tittelinformasjon','Annen tittelinformasjon','0','0','0','2','','','','0','-1','','','',NULL,'9999'); >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 15b7db6..4c7ac79 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 >@@ -966,7 +966,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 2, '', '', '', NULL, 0, '', '''245b'',''245f'',''245g'',''245k'',''245n'',''245p'',''245s'',''245h'',''246i'',''246a'',''246b'',''246f'',''246g'',''246n'',''246p'',''246h'',''242a'',''242b'',''242n'',''242p'',''242h'',''505t''', '', NULL), >- ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'bibliosubtitle.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), >+ ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, 'biblio.subtitle', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'c', 'Statement of responsibility, etc', 'Statement of responsibility, etc', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >@@ -974,8 +974,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` > ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 'h', 'Medium', 'Medium', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), > ('245', 'k', 'Form', 'Form', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >- ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, 'biblio.part_number', 2, '', '', '', NULL, -6, '', '', '', NULL), >+ ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, 'biblio.part_name', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('245', 's', 'Version', 'Version', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), > ('246', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >index 183378d..d0f4066 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >@@ -792,7 +792,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > ('', '', '245', '6', 0, 0, 'ÐÐ»ÐµÐ¼ÐµÐ½Ñ ÑвÑзи', '', 2, -6, '', '', '', NULL, '', '', NULL), > ('', '', '245', '8', 0, 1, 'СвÑÐ·Ñ Ð¿Ð¾Ð»Ñ Ð¸ ее поÑÑдковÑй номеÑ', '', 2, -6, '', '', '', NULL, '', '', NULL), > ('', '', '245', 'a', 0, 0, 'Ðаглавие', '', 2, 0, 'biblio.title', '', '', NULL, '\'245b\',\'245f\',\'245g\',\'245k\',\'245n\',\'245p\',\'245s\',\'245h\',\'246i\',\'246a\',\'246b\',\'246f\',\'246g\',\'246n\',\'246p\',\'246h\',\'242a\',\'242b\',\'242n\',\'242p\',\'242h\',\'505t\'', '', NULL), >- ('', '', '245', 'b', 0, 0, 'ÐÑодолж. заглавиÑ', '', 2, 0, 'bibliosubtitle.subtitle', '', '', NULL, '', '', NULL), >+ ('', '', '245', 'b', 0, 0, 'ÐÑодолж. заглавиÑ', '', 2, 0, 'biblio.subtitle', '', '', NULL, '', '', NULL), > ('', '', '245', 'c', 0, 0, 'ÐÑвеÑÑÑвенноÑÑÑ', '', 2, 0, '', '', '', NULL, '', '', NULL), > ('', '', '245', 'd', 0, 0, 'Designation of section/part/series (SE) (ÑÑÑаÑевÑее)', 'Designation of section section/part/series: (SE) (ÑÑÑаÑевÑее)', 2, -6, '', '', '', NULL, '', '', NULL), > ('', '', '245', 'e', 0, 0, 'Name of part/section/series (SE) (ÑÑÑаÑевÑее)', 'Name of part/section/series (SE) (ÑÑÑаÑевÑее)', 2, -6, '', '', '', NULL, '', '', NULL), >@@ -800,8 +800,8 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > ('', '', '245', 'g', 0, 0, 'ÐаÑÑ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ Ð¾Ñн. ÑаÑÑи пÑоизв.', '', 2, -6, '', '', '', NULL, '', '', NULL), > ('', '', '245', 'h', 0, 0, 'ФизиÑеÑкий ноÑиÑелÑ', '', 2, 0, '', '', '', NULL, '', '', NULL), > ('', '', '245', 'k', 0, 1, 'ФоÑма, вид, жанÑ', '', 2, -6, '', '', '', NULL, '', '', NULL), >- ('', '', '245', 'n', 0, 1, 'ÐÐ¾Ð¼ÐµÑ ÑаÑÑи/Ñаздела', '', 2, -6, '', '', '', NULL, '', '', NULL), >- ('', '', '245', 'p', 0, 1, 'Ðазвание ÑаÑÑи/Ñаздела', '', 2, -6, '', '', '', NULL, '', '', NULL), >+ ('', '', '245', 'n', 0, 1, 'ÐÐ¾Ð¼ÐµÑ ÑаÑÑи/Ñаздела', '', 2, -6, 'biblio.part_number', '', '', NULL, '', '', NULL), >+ ('', '', '245', 'p', 0, 1, 'Ðазвание ÑаÑÑи/Ñаздела', '', 2, -6, 'biblio.part_name', '', '', NULL, '', '', NULL), > ('', '', '245', 's', 0, 0, 'ÐеÑÑиÑ', '', 2, -6, '', '', '', NULL, '', '', NULL); > > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >index 74eb9df..fe7d602 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/mandatory/marc21_bibliographic_DEFAULT_general.sql >@@ -833,7 +833,7 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > ('', '', '245', '6', 0, 0, 'ÐÐ»ÐµÐ¼ÐµÐ½Ñ Ð·Ð²âÑзкÑ', '', 2, -6, '', '', '', 0, NULL, '', ''), > ('', '', '245', '8', 0, 1, 'ÐвâÑзок Ð¿Ð¾Ð»Ñ Ñа його поÑÑдковий номеÑ', '', 2, -6, '', '', '', 0, NULL, '', ''), > ('', '', '245', 'a', 0, 0, 'Ðазва', '', 2, 0, 'biblio.title', '', '', 0, NULL, '', ''), >- ('', '', '245', 'b', 0, 0, 'ÐÑодовж. назви', '', 2, 0, '', '', '', 0, NULL, '', ''), >+ ('', '', '245', 'b', 0, 0, 'ÐÑодовж. назви', '', 2, 0, 'biblio.subtitle', '', '', 0, NULL, '', ''), > ('', '', '245', 'c', 0, 0, 'ÐÑдповÑдалÑнÑÑÑÑ', '', 2, 0, '', '', '', 0, NULL, '', ''), > ('', '', '245', 'd', 0, 0, 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 2, -6, '', '', '', 0, NULL, '', ''), > ('', '', '245', 'e', 0, 0, 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 2, -6, '', '', '', 0, NULL, '', ''), >@@ -841,8 +841,8 @@ INSERT INTO marc_subfield_structure (frameworkcode, authtypecode, tagfield, tag > ('', '', '245', 'g', 0, 0, 'ÐаÑи ÑÑвоÑÐµÐ½Ð½Ñ Ð¾Ñн. ÑаÑÑини ÑвоÑÑ', '', 2, -6, '', '', '', 0, NULL, '', ''), > ('', '', '245', 'h', 0, 0, 'ФÑзиÑний ноÑÑй', '', 2, 0, '', '', '', 0, NULL, '', ''), > ('', '', '245', 'k', 0, 1, 'ФоÑма, вид, жанÑ', '', 2, -6, '', '', '', 0, NULL, '', ''), >- ('', '', '245', 'n', 0, 1, 'ÐÐ¾Ð¼ÐµÑ ÑаÑÑини/ÑоздÑлÑ', '', 2, -6, '', '', '', 0, NULL, '', ''), >- ('', '', '245', 'p', 0, 1, 'Ðазва ÑаÑÑини/ÑоздÑлÑ', '', 2, -6, '', '', '', 0, NULL, '', ''), >+ ('', '', '245', 'n', 0, 1, 'ÐÐ¾Ð¼ÐµÑ ÑаÑÑини/ÑоздÑлÑ', '', 2, -6, 'biblio.part_number', '', '', 0, NULL, '', ''), >+ ('', '', '245', 'p', 0, 1, 'Ðазва ÑаÑÑини/ÑоздÑлÑ', '', 2, -6, 'biblio.part_name', '', '', 0, NULL, '', ''), > ('', '', '245', 's', 0, 0, 'ÐеÑÑÑÑ', '', 2, -6, '', '', '', 0, NULL, '', ''); > > INSERT INTO marc_tag_structure (frameworkcode, tagfield, mandatory, repeatable, liblibrarian, libopac, authorised_value) VALUES >diff --git a/t/db_dependent/Biblio.t b/t/db_dependent/Biblio.t >index bb43bb1..10d94a0 100755 >--- a/t/db_dependent/Biblio.t >+++ b/t/db_dependent/Biblio.t >@@ -130,6 +130,10 @@ $biblio_module->mock( > my ($self) = shift; > > my ( $title_field, $title_subfield ) = get_title_field(); >+ my ( $subtitle_field, $subtitle_subfield ) = get_subtitle_field(); >+ my ( $medium_field, $medium_subfield ) = get_medium_field(); >+ my ( $part_number_field, $part_number_subfield ) = get_part_number_field(); >+ my ( $part_name_field, $part_name_subfield ) = get_part_name_field(); > my ( $isbn_field, $isbn_subfield ) = get_isbn_field(); > my ( $issn_field, $issn_subfield ) = get_issn_field(); > my ( $biblionumber_field, $biblionumber_subfield ) = ( '999', 'c' ); >@@ -138,6 +142,10 @@ $biblio_module->mock( > > return { > 'biblio.title' => [ { tagfield => $title_field, tagsubfield => $title_subfield } ], >+ 'biblio.subtitle' => [ { tagfield => $subtitle_field, tagsubfield => $subtitle_subfield } ], >+ 'biblio.medium' => [ { tagfield => $medium_field, tagsubfield => $medium_subfield } ], >+ 'biblio.part_number' => [ { tagfield => $part_number_field, tagsubfield => $part_number_subfield } ], >+ 'biblio.part_name' => [ { tagfield => $part_name_field, tagsubfield => $part_name_subfield } ], > 'biblio.biblionumber' => [ { tagfield => $biblionumber_field, tagsubfield => $biblionumber_subfield } ], > 'biblioitems.isbn' => [ { tagfield => $isbn_field, tagsubfield => $isbn_subfield } ], > 'biblioitems.issn' => [ { tagfield => $issn_field, tagsubfield => $issn_subfield } ], >@@ -168,6 +176,11 @@ sub run_tests { > > my $isbn = '0590353403'; > my $title = 'Foundation'; >+ my $subtitle1 = 'Research'; >+ my $subtitle2 = 'Conclusions'; >+ my $medium = 'Medium'; >+ my $part_number = '123'; >+ my $part_name = 'First years'; > > # Generate a record with just the ISBN > my $marc_record = MARC::Record->new; >@@ -197,6 +210,23 @@ sub run_tests { > my ( $title_field, $title_subfield ) = get_title_field(); > is( $marc->subfield( $title_field, $title_subfield ), $title, ); > >+ # Add other fields >+ $marc_record->append_fields( create_field( $subtitle1, $marcflavour, get_subtitle_field() ) ); >+ $marc_record->append_fields( create_field( $subtitle2, $marcflavour, get_subtitle_field() ) ); >+ $marc_record->append_fields( create_field( $medium, $marcflavour, get_medium_field() ) ); >+ $marc_record->append_fields( create_field( $part_number, $marcflavour, get_part_number_field() ) ); >+ $marc_record->append_fields( create_field( $part_name, $marcflavour, get_part_name_field() ) ); >+ >+ ModBiblio( $marc_record, $biblionumber ,'' ); >+ $data = GetBiblioData( $biblionumber ); >+ is( $data->{ title }, $title, '(ModBiblio) still there after adding other fields.' ); >+ is( $data->{ isbn }, $isbn, '(ModBiblio) ISBN is still there after adding other fields.' ); >+ >+ is( $data->{ subtitle }, "$subtitle1 | $subtitle2", '(ModBiblio) subtitles correctly added and returned in GetBiblioData.' ); >+ is( $data->{ medium }, $medium, '(ModBiblio) medium correctly added and returned in GetBiblioData.' ); >+ is( $data->{ part_number }, $part_number, '(ModBiblio) part_number correctly added and returned in GetBiblioData.' ); >+ is( $data->{ part_name }, $part_name, '(ModBiblio) part_name correctly added and returned in GetBiblioData.' ); >+ > my $biblioitem = Koha::Biblioitems->find( $biblioitemnumber ); > is( $biblioitem->_result->biblio->title, $title, # Should be $biblioitem->biblio instead, but not needed elsewhere for now > 'Do not know if this makes sense - compare result of previous two GetBiblioData tests.'); >@@ -355,6 +385,26 @@ sub get_title_field { > return ( $marc_flavour eq 'UNIMARC' ) ? ( '200', 'a' ) : ( '245', 'a' ); > } > >+sub get_medium_field { >+ my $marc_flavour = C4::Context->preference('marcflavour'); >+ return ( $marc_flavour eq 'UNIMARC' ) ? ( '200', 'b' ) : ( '245', 'h' ); >+} >+ >+sub get_subtitle_field { >+ my $marc_flavour = C4::Context->preference('marcflavour'); >+ return ( $marc_flavour eq 'UNIMARC' ) ? ( '200', 'e' ) : ( '245', 'b' ); >+} >+ >+sub get_part_number_field { >+ my $marc_flavour = C4::Context->preference('marcflavour'); >+ return ( $marc_flavour eq 'UNIMARC' ) ? ( '200', 'h' ) : ( '245', 'n' ); >+} >+ >+sub get_part_name_field { >+ my $marc_flavour = C4::Context->preference('marcflavour'); >+ return ( $marc_flavour eq 'UNIMARC' ) ? ( '200', 'i' ) : ( '245', 'p' ); >+} >+ > sub get_isbn_field { > my $marc_flavour = C4::Context->preference('marcflavour'); > return ( $marc_flavour eq 'UNIMARC' ) ? ( '010', 'a' ) : ( '020', 'a' ); >@@ -379,6 +429,12 @@ sub create_title_field { > return $field; > } > >+sub create_field { >+ my ( $content, $marcflavour, $field, $subfield ) = @_; >+ >+ return MARC::Field->new( $field, '', '', $subfield => $content ); >+} >+ > sub create_isbn_field { > my ( $isbn, $marcflavour ) = @_; > >@@ -402,21 +458,21 @@ sub create_issn_field { > } > > subtest 'MARC21' => sub { >- plan tests => 34; >+ plan tests => 40; > run_tests('MARC21'); > $schema->storage->txn_rollback; > $schema->storage->txn_begin; > }; > > subtest 'UNIMARC' => sub { >- plan tests => 34; >+ plan tests => 40; > run_tests('UNIMARC'); > $schema->storage->txn_rollback; > $schema->storage->txn_begin; > }; > > subtest 'NORMARC' => sub { >- plan tests => 34; >+ plan tests => 40; > run_tests('NORMARC'); > $schema->storage->txn_rollback; > $schema->storage->txn_begin; >-- >2.7.4
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 11529
:
81930
|
81931
|
82024
|
82025
|
82026
|
82027
|
82028
|
82029
|
82088
|
82089
|
82090
|
82428
|
82429
|
82430
|
82431
|
82538
|
82539
|
82540
|
82541
|
82542
|
83103
|
83104
|
83105
|
83106
|
83107
|
83108
|
83961
|
83962
|
83963
|
83964
|
83965
|
83966
|
85587
|
85588
|
85589
|
85590
|
85591
|
85592
|
86677
|
86678
|
86679
|
86680
|
86681
|
86682
|
87248
|
87249
|
87250
|
87251
|
87252
|
87253
|
87256
|
87257
|
87258
|
87259
|
87260
|
87261
|
87911
|
87912
|
87913
|
87914
|
87915
|
87916
|
87917
|
87918
|
87919
|
88247
|
88248
|
88249
|
88250
|
88251
|
88252
|
88253
|
88254
|
88255
|
88256
|
88406
|
88407
|
88408
|
88409
|
88410
|
88411
|
88412
|
88413
|
88414
|
88415
|
88416
|
88433
|
88434
|
88435
|
88436
|
88437
|
88438
|
88439
|
88440
|
88441
|
88442
|
88443
|
88762
|
88763
|
88764
|
88765
|
88766
|
88767
|
88768
|
88769
|
88770
|
88771
|
88772
|
88851
|
88852
|
88853
|
88854
|
88855
|
88856
|
88857
|
88858
|
88859
|
88860
|
88861
|
88862
|
89096
|
89097
|
89098
|
89099
|
89100
|
89101
|
89102
|
89103
|
89104
|
89105
|
89106
|
89107
|
89234
|
89235
|
89236
|
89237
|
89238
|
89239
|
89240
|
89241
|
89242
|
89243
|
89244
|
89245
|
89246
|
91680
|
91681
|
91682
|
91683
|
91684
|
91685
|
91686
|
91687
|
91688
|
91689
|
91690
|
91691
|
91692
|
91824
|
91825
|
91826
|
91827
|
91828
|
91829
|
91830
|
91831
|
91832
|
91833
|
91834
|
91835
|
91836
|
91837
|
92016
|
92019
|
92020
|
105667
|
105672