From da8a4ca991b1ef1fe3ade259be802c125d7ec261 Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Wed, 26 Dec 2007 21:22:14 -0500 Subject: [PATCH] BIG COMMIT: minimal fix to authorities search This is a minimal fix -- pname authorities work propertly, but nothing else has been tested yet Signed-off-by: Joshua Ferraro --- C4/AuthoritiesMarc.pm | 158 +----------------- authorities/auth_finder.pl | 1 - .../marc21_field_008_authorities.pl | 50 +++--- .../marc21_leader_authorities.pl | 12 +- etc/zebradb/authorities/etc/bib1.att | 2 +- etc/zebradb/ccl.properties | 3 +- .../mandatory/authorities_normal_marc21.sql | 108 ++++++------ .../optional/marc21_simple_bib_frameworks.sql | 128 +++++++------- .../prog/en/includes/auth-finder-search.inc | 59 +++++++ .../en/modules/authorities/auth_finder.tmpl | 71 +------- .../modules/authorities/authorities-home.tmpl | 6 +- .../authorities/searchresultlist-auth.tmpl | 83 ++------- .../modules/authorities/searchresultlist.tmpl | 6 +- .../en/modules/opac-authorities-home.tmpl | 8 +- 14 files changed, 250 insertions(+), 445 deletions(-) create mode 100644 koha-tmpl/intranet-tmpl/prog/en/includes/auth-finder-search.inc diff --git a/C4/AuthoritiesMarc.pm b/C4/AuthoritiesMarc.pm index e910e0bedc..26c3640a93 100644 --- a/C4/AuthoritiesMarc.pm +++ b/C4/AuthoritiesMarc.pm @@ -243,8 +243,11 @@ sub SearchAuthorities { $query=$q2; } ## Adding order - $query=' @or @attr 7=1 @attr 1=Heading 0 @or @attr 7=1 @attr 1=Heading-Entity 1'.$query if ($sortby eq "HeadingAsc"); - $query=' @or @attr 7=2 @attr 1=Heading 0 @or @attr 7=1 @attr 1=Heading-Entity 1'.$query if ($sortby eq "HeadingDsc"); + # I get an error 207 from zebra 'cannot sort according to sequence', so I'm modifying as below - JF + #$query=' @or @attr 7=1 @attr 1=Heading 0 @or @attr 7=1 @attr 1=Heading-Entity 1'.$query if ($sortby eq "HeadingAsc"); + #$query=' @or @attr 7=2 @attr 1=Heading 0 @or @attr 7=1 @attr 1=Heading-Entity 1'.$query if ($sortby eq "HeadingDsc"); + $query=' @or @attr 7=1 @attr 1=Heading 0'.$query if ($sortby eq "HeadingAsc"); + $query=' @or @attr 7=2 @attr 1=Heading 0'.$query if ($sortby eq "HeadingDsc"); $offset=0 unless $offset; my $counter = $offset; @@ -1227,154 +1230,3 @@ Koha Developement team Paul POULAIN paul.poulain@free.fr =cut - -# Revision 1.50 2007/07/26 15:14:05 toins -# removing warn compilation. -# -# Revision 1.49 2007/07/16 15:45:28 hdl -# Adding Summary for UNIMARC authorities -# -# Revision 1.48 2007/06/25 15:01:45 tipaul -# bugfixes on unimarc 100 handling (the field used for encoding) -# -# Revision 1.47 2007/06/06 13:08:35 tipaul -# bugfixes (various), handling utf-8 without guessencoding (as suggested by joshua, fixing some zebra config files -for french but should be interesting for other languages- -# -# Revision 1.46 2007/05/10 14:45:15 tipaul -# Koha NoZebra : -# - support for authorities -# - some bugfixes in ordering and "CCL" parsing -# - support for authorities <=> biblios walking -# -# Seems I can do what I want now, so I consider its done, except for bugfixes that will be needed i m sure ! -# -# Revision 1.45 2007/04/06 14:48:45 hdl -# Code Cleaning : AuthoritiesMARC. -# -# Revision 1.44 2007/04/05 12:17:55 btoumi -# add "sort by" with heading-entity in authorities search -# -# Revision 1.43 2007/03/30 11:59:16 tipaul -# some cleaning (minor, the main one will come later) : removing some unused subs -# -# Revision 1.42 2007/03/29 16:45:53 tipaul -# Code cleaning of Biblio.pm (continued) -# -# All subs have be cleaned : -# - removed useless -# - merged some -# - reordering Biblio.pm completly -# - using only naming conventions -# -# Seems to have broken nothing, but it still has to be heavily tested. -# Note that Biblio.pm is now much more efficient than previously & probably more reliable as well. -# -# Revision 1.41 2007/03/29 13:30:31 tipaul -# Code cleaning : -# == Biblio.pm cleaning (useless) == -# * some sub declaration dropped -# * removed modbiblio sub -# * removed moditem sub -# * removed newitems. It was used only in finishrecieve. Replaced by a TransformKohaToMarc+AddItem, that is better. -# * removed MARCkoha2marcItem -# * removed MARCdelsubfield declaration -# * removed MARCkoha2marcBiblio -# -# == Biblio.pm cleaning (naming conventions) == -# * MARCgettagslib renamed to GetMarcStructure -# * MARCgetitems renamed to GetMarcItem -# * MARCfind_frameworkcode renamed to GetFrameworkCode -# * MARCmarc2koha renamed to TransformMarcToKoha -# * MARChtml2marc renamed to TransformHtmlToMarc -# * MARChtml2xml renamed to TranformeHtmlToXml -# * zebraop renamed to ModZebra -# -# == MARC=OFF == -# * removing MARC=OFF related scripts (in cataloguing directory) -# * removed checkitems (function related to MARC=off feature, that is completly broken in head. If someone want to reintroduce it, hard work coming...) -# * removed getitemsbybiblioitem (used only by MARC=OFF scripts, that is removed as well) -# -# Revision 1.40 2007/03/28 10:39:16 hdl -# removing $dbh as a parameter in AuthoritiesMarc functions -# And reporting all differences into the scripts taht relies on those functions. -# -# Revision 1.39 2007/03/16 01:25:08 kados -# Using my precrash CVS copy I did the following: -# -# cvs -z3 -d:ext:kados@cvs.savannah.nongnu.org:/sources/koha co -P koha -# find koha.precrash -type d -name "CVS" -exec rm -v {} \; -# cp -r koha.precrash/* koha/ -# cd koha/ -# cvs commit -# -# This should in theory put us right back where we were before the crash -# -# Revision 1.39 2007/03/12 22:16:31 kados -# chcking for field before calling subfields -# -# Revision 1.38 2007/03/09 14:31:47 tipaul -# rel_3_0 moved to HEAD -# -# Revision 1.28.2.17 2007/02/05 13:16:08 hdl -# Removing Link from AuthoritiesMARC summary (caused a problem owed to the API differences between opac and intranet) -# + removing $dbh in SearchAuthorities -# + adding links in templates on summaries to go to full view. -# (no more links in popup authorities. or should we add it ?) -# -# Revision 1.28.2.16 2007/02/02 18:07:42 hdl -# Sorting and searching for exact term now works. -# -# Revision 1.28.2.15 2007/01/24 10:17:47 hdl -# FindDuplicate Now works. -# Be AWARE that it needs a change ccl.properties. -# -# Revision 1.28.2.14 2007/01/10 14:40:11 hdl -# Adding Authorities tree. -# -# Revision 1.28.2.13 2007/01/09 15:18:09 hdl -# Adding an to ccl.properties to allow ccl search for authority-numbers. -# Fixing Some problems with the previous modification to allow pqf search to work for more than one page. -# Using search for an= for an authority-Number. -# -# Revision 1.28.2.12 2007/01/09 13:51:31 hdl -# Bug Fixing : CountUsage used *synchronous* connection where biblio used ****asynchronous**** one. -# First try to get it work. -# -# Revision 1.28.2.11 2007/01/05 14:37:26 btoumi -# bug fix : remove wrong field in sql syntaxe from auth_subfield_structure table -# -# Revision 1.28.2.10 2007/01/04 13:11:08 tipaul -# commenting 2 zconn destroy -# -# Revision 1.28.2.9 2006/12/22 15:09:53 toins -# removing C4::Database; -# -# Revision 1.28.2.8 2006/12/20 17:13:19 hdl -# modifying use of GILS into use of @attr 1=Koha-Auth-Number -# -# Revision 1.28.2.7 2006/12/18 16:45:38 tipaul -# FIXME upcased -# -# Revision 1.28.2.6 2006/12/07 16:45:43 toins -# removing warn compilation. (perl -wc) -# -# Revision 1.28.2.5 2006/12/06 14:19:59 hdl -# ABugFixing : Authority count Management. -# -# Revision 1.28.2.4 2006/11/17 13:18:58 tipaul -# code cleaning : removing use of "bib", and replacing with "biblionumber" -# -# WARNING : I tried to do carefully, but there are probably some mistakes. -# So if you encounter a problem you didn't have before, look for this change !!! -# anyway, I urge everybody to use only "biblionumber", instead of "bib", "bi", "biblio" or anything else. will be easier to maintain !!! -# -# Revision 1.28.2.3 2006/11/17 11:17:30 tipaul -# code cleaning : removing use of "bib", and replacing with "biblionumber" -# -# WARNING : I tried to do carefully, but there are probably some mistakes. -# So if you encounter a problem you didn't have before, look for this change !!! -# anyway, I urge everybody to use only "biblionumber", instead of "bib", "bi", "biblio" or anything else. will be easier to maintain !!! -# -# Revision 1.28.2.2 2006/10/12 22:04:47 hdl -# Authorities working with zebra. -# zebra Configuration files are comitted next. diff --git a/authorities/auth_finder.pl b/authorities/auth_finder.pl index ba12b29ace..22330e24b0 100755 --- a/authorities/auth_finder.pl +++ b/authorities/auth_finder.pl @@ -69,7 +69,6 @@ if ( $op eq "do_search" ) { SearchAuthorities( \@marclist, \@and_or, \@excluding, \@operator, \@value, $startfrom * $resultsperpage, $resultsperpage, $authtypecode, $orderby); - # multi page display gestion my $displaynext = 0; my $displayprev = $startfrom; diff --git a/cataloguing/value_builder/marc21_field_008_authorities.pl b/cataloguing/value_builder/marc21_field_008_authorities.pl index 9da4ae2cc3..6ad1082a96 100755 --- a/cataloguing/value_builder/marc21_field_008_authorities.pl +++ b/cataloguing/value_builder/marc21_field_008_authorities.pl @@ -1,3 +1,4 @@ + #!/usr/bin/perl @@ -31,33 +32,27 @@ use C4::Output; plugin_parameters : other parameters added when the plugin is called by the dopop function =cut + # find today's date -my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time); -$year = substr($year,1,2); -$mon +=1; -my $date = "$year-$mon-$mday"; -my $res = ""; -if (length($mon)==1) { - $mon='0'.$mon; -} -if (length($mday)==1) { - $mday='0'.$mday; -} -my $dateentered = "$year$mon$mday"; +my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime(time); + +$year +=1900; $mon +=1; +my $dateentered = substr($year,2,2).sprintf ("%0.2d", $mon).sprintf ("%0.2d",$mday); sub plugin_parameters { -my ($dbh,$record,$tagslib,$i,$tabloop) = @_; -return ""; + my ($dbh,$record,$tagslib,$i,$tabloop) = @_; + return ""; } sub plugin_javascript { -my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_; -my $function_name= $field_number; -my $res=" + my ($dbh,$record,$tagslib,$field_number,$tabloop) = @_; + my $function_name= $field_number; + my $res=" "; -return ($function_name,$res); + return ($function_name,$res); } sub plugin { -my ($input) = @_; + my ($input) = @_; my $index= $input->param('index'); my $result= $input->param('result'); my $dbh = C4::Context->dbh; -my ($template, $loggedinuser, $cookie) - = get_template_and_user({template_name => "cataloguing/value_builder/marc21_field_008_authorities.tmpl", + my ($template, $loggedinuser, $cookie) + = get_template_and_user({template_name => "cataloguing/value_builder/marc21_field_008.tmpl", query => $input, type => "intranet", authnotrequired => 0, @@ -92,7 +87,8 @@ my ($template, $loggedinuser, $cookie) debug => 1, }); # $result = " t xxu 00 0 eng d" unless $result; - $result = " t xxu||||| |||| 00| 0 eng d" unless $result; + $result = "$dateentered"."t xxu||||| |||| 00| 0 eng d" unless $result; + my $f1 = substr($result,0,6); my $f6 = substr($result,6,1); my $f710 = substr($result,7,4); my $f1114 = substr($result,11,4); @@ -111,8 +107,12 @@ my ($template, $loggedinuser, $cookie) my $f38 = substr($result,38,1); my $f39 = substr($result,39,1); +if ((!$f1) ||($f1 =~ m/ /)){ + $f1=$dateentered; +} + $template->param( index => $index, - dateentered => $dateentered, + f1 => $f1, f6 => $f6, "f6$f6" => $f6, f710 => $f710, diff --git a/cataloguing/value_builder/marc21_leader_authorities.pl b/cataloguing/value_builder/marc21_leader_authorities.pl index a55384f81b..f9491b1cae 100755 --- a/cataloguing/value_builder/marc21_leader_authorities.pl +++ b/cataloguing/value_builder/marc21_leader_authorities.pl @@ -1,3 +1,4 @@ + #!/usr/bin/perl @@ -44,7 +45,10 @@ my $res=" // @@ -71,14 +75,14 @@ my ($input) = @_; my $dbh = C4::Context->dbh; my ($template, $loggedinuser, $cookie) - = get_template_and_user({template_name => "cataloguing/value_builder/marc21_leader_authorities.tmpl", + = get_template_and_user({template_name => "cataloguing/value_builder/marc21_leader.tmpl", query => $input, type => "intranet", authnotrequired => 0, flagsrequired => {editcatalogue => 1}, debug => 1, }); - $result = " nam 22 7a 4500" unless $result; + $result = " nam a22 7a 4500" unless $result; my $f5 = substr($result,5,1); my $f6 = substr($result,6,1); my $f7 = substr($result,7,1); diff --git a/etc/zebradb/authorities/etc/bib1.att b/etc/zebradb/authorities/etc/bib1.att index 1797cc203d..26f5c29c9c 100644 --- a/etc/zebradb/authorities/etc/bib1.att +++ b/etc/zebradb/authorities/etc/bib1.att @@ -2,7 +2,7 @@ # Bib-1 Attribute Set name bib1 reference Bib-1 -include gils.att +#include gils.att att 1 Personal-name diff --git a/etc/zebradb/ccl.properties b/etc/zebradb/ccl.properties index ebd2ea7caa..2fb866cb59 100644 --- a/etc/zebradb/ccl.properties +++ b/etc/zebradb/ccl.properties @@ -793,7 +793,8 @@ ut Title-uniform # for an authority to be searched subfield $9 in the # for cataloging purposes. following: 700,701,702,710, # 711,712 and some 6XX fields (Unimarc) -Authority-Number 1=8910 +# 8910 +Authority-Number 1=Koha-Auth-Number an Authority-Number Koha-Auth-Number Authority-Number diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql index 8614555ecf..4c6397d96d 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql @@ -266,11 +266,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -338,7 +338,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1749,11 +1749,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -1803,7 +1803,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('PERSO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('PERSO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('PERSO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2671,11 +2671,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -2725,7 +2725,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CORPO_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('CORPO_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CORPO_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3569,11 +3569,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -3641,7 +3641,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('MEETI_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('MEETI_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('MEETI_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4489,11 +4489,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -4561,7 +4561,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('UNIF_TITLE', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('UNIF_TITLE', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('UNIF_TITLE', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5431,11 +5431,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -5472,7 +5472,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('CHRON_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('CHRON_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('CHRON_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6297,11 +6297,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -6338,7 +6338,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('TOPIC_TERM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('TOPIC_TERM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('TOPIC_TERM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7167,11 +7167,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -7208,7 +7208,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GEOGR_NAME', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('GEOGR_NAME', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GEOGR_NAME', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8036,11 +8036,11 @@ INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `tab`, `authorised_value`, `value_builder`, `seealso`, `isurl`, `hidden`, `linkid`, `kohafield`, `frameworkcode`) VALUES - ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '000', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_leader_authorities.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '001', '@', 'control field', 'control field', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '003', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '005', '@', 'control field', 'control field', 0, 1, 0, NULL, 'marc21_field_005.pl', NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '008', '@', 'fixed length control field', 'fixed length control field', 0, 1, 0, NULL, 'marc21_field_008_authorities.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'a', 'LC control number', 'LC control number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), @@ -8059,7 +8059,7 @@ INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` ('GENRE/FORM', '035', 'z', 'Canceled/invalid control number', 'Canceled/invalid control number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '035', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), - ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, NULL, NULL, 0, 0, '', '', ''), + ('GENRE/FORM', '040', 'a', 'Original cataloging agency', 'Original cataloging agency', 0, 1, 0, NULL, 'marc21_field_003.pl', NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'b', 'Language of cataloging', 'Language of cataloging', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'c', 'Transcribing agency', 'Transcribing agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), ('GENRE/FORM', '040', 'd', 'Modifying agency', 'Modifying agency', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''), diff --git a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql index f73a0c4ca8..da8d4b2b91 100644 --- a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql +++ b/installer/data/mysql/en/marcflavour/marc21/optional/marc21_simple_bib_frameworks.sql @@ -856,8 +856,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'BKS', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'BKS', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'BKS', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, 0, 'BKS', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'BKS', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, 0, 'BKS', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'BKS', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'BKS', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, 'BKS', '', '', NULL), @@ -1723,7 +1723,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'BKS', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'BKS', '', '', NULL), @@ -1969,7 +1969,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'BKS', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'BKS', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'BKS', '', '', NULL), @@ -2078,7 +2078,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'BKS', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'BKS', '', '', NULL), @@ -2621,7 +2621,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'BKS', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'BKS', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'BKS', '', '', NULL), @@ -2717,7 +2717,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'BKS', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'BKS', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), @@ -3188,7 +3188,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'BKS', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'BKS', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'BKS', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'BKS', '', '', NULL), @@ -4775,8 +4775,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'CF', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'CF', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'CF', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'CF', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, -1, 'CF', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'CF', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, -1, 'CF', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'CF', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'CF', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, -1, 'CF', '', '', NULL), @@ -5642,7 +5642,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'CF', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'CF', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'CF', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'CF', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'CF', '', '', NULL), @@ -5888,7 +5888,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'CF', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'CF', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'CF', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'CF', '', '', NULL), @@ -5997,7 +5997,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'CF', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'CF', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'CF', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'CF', '', '', NULL), @@ -6540,7 +6540,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'CF', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'CF', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'CF', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'CF', '', '', NULL), @@ -6636,7 +6636,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'CF', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'CF', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'CF', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), @@ -7107,7 +7107,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'CF', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'CF', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'CF', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'CF', '', '', NULL), @@ -8693,8 +8693,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'SR', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'SR', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'SR', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'SR', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, -1, 'SR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'SR', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, -1, 'SR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'SR', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'SR', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, -1, 'SR', '', '', NULL), @@ -9560,7 +9560,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'SR', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'SR', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'SR', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'SR', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'SR', '', '', NULL), @@ -9806,7 +9806,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'SR', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'SR', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'SR', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'SR', '', '', NULL), @@ -9915,7 +9915,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'SR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SR', '', '', NULL), @@ -10458,7 +10458,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SR', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'SR', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'SR', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'SR', '', '', NULL), @@ -10554,7 +10554,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'SR', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'SR', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'SR', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), @@ -11025,7 +11025,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'SR', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'SR', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'SR', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'SR', '', '', NULL), @@ -12611,8 +12611,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'VR', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'VR', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'VR', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'VR', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, -1, 'VR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'VR', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, -1, 'VR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'VR', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'VR', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, -1, 'VR', '', '', NULL), @@ -13478,7 +13478,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'VR', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'VR', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'VR', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'VR', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'VR', '', '', NULL), @@ -13724,7 +13724,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'VR', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'VR', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'VR', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'VR', '', '', NULL), @@ -13833,7 +13833,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'VR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'VR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'VR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'VR', '', '', NULL), @@ -14376,7 +14376,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'VR', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'VR', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'VR', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'VR', '', '', NULL), @@ -14472,7 +14472,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'VR', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'VR', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'VR', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), @@ -14943,7 +14943,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'VR', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'VR', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'VR', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'VR', '', '', NULL), @@ -16527,8 +16527,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'AR', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'AR', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'AR', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'AR', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, 0, 'AR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'AR', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, 0, 'AR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'AR', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'AR', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, 'AR', '', '', NULL), @@ -17394,7 +17394,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'AR', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'AR', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'AR', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'AR', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'AR', '', '', NULL), @@ -17640,7 +17640,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'AR', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'AR', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'AR', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'AR', '', '', NULL), @@ -17749,7 +17749,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'AR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'AR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'AR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'AR', '', '', NULL), @@ -18292,7 +18292,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'AR', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'AR', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'AR', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'AR', '', '', NULL), @@ -18388,7 +18388,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'AR', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'AR', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'AR', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), @@ -18859,7 +18859,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'AR', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'AR', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'AR', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'AR', '', '', NULL), @@ -20443,8 +20443,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'KT', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'KT', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'KT', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'KT', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, 0, 'KT', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'KT', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, 0, 'KT', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'KT', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'KT', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, 'KT', '', '', NULL), @@ -21310,7 +21310,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'KT', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'KT', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'KT', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'KT', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'KT', '', '', NULL), @@ -21556,7 +21556,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'KT', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'KT', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'KT', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'KT', '', '', NULL), @@ -21665,7 +21665,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'KT', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'KT', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'KT', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'KT', '', '', NULL), @@ -22208,7 +22208,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'KT', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'KT', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'KT', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'KT', '', '', NULL), @@ -22304,7 +22304,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'KT', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'KT', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'KT', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), @@ -22775,7 +22775,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'KT', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'KT', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'KT', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'KT', '', '', NULL), @@ -24361,8 +24361,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'IR', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'IR', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'IR', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'IR', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, 0, 'IR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'IR', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, 0, 'IR', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'IR', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'IR', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, 0, 'IR', '', '', NULL), @@ -25227,7 +25227,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'IR', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'IR', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'IR', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'IR', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'IR', '', '', NULL), @@ -25473,7 +25473,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'IR', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'IR', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'IR', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'IR', '', '', NULL), @@ -25582,7 +25582,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'IR', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'IR', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'IR', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'IR', '', '', NULL), @@ -26125,7 +26125,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'IR', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'IR', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'IR', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'IR', '', '', NULL), @@ -26221,7 +26221,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'IR', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'IR', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'IR', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), @@ -26692,7 +26692,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'IR', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'IR', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'IR', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'IR', '', '', NULL), @@ -28274,8 +28274,8 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 1, '', '', '', 0, -6, 'SER', '', '', NULL), ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 1, '', '', '', 0, -6, 'SER', '', '', NULL), ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 1, '', '', '', 0, -6, 'SER', '', '', NULL), - ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'SER', '', '', NULL), - ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERS0_NAME', '', 0, -1, 'SER', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), + ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 1, '', '', '', 0, 0, 'SER', '', '', NULL), + ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 1, '', 'PERSO_NAME', '', 0, -1, 'SER', '''100b'',''100c'',''100q'',''100d'',''100e'',''110a'',''110b'',''110c'',''110d'',''110e'',''111a'',''111e'',''111c'',''111d'',''130a'',''700a'',''700b'',''700c'',''700q'',''700d'',''700e'',''710a'',''710b'',''710c'',''710d'',''710e'',''711a'',''711e'',''711c'',''711d'',''720a'',''720e'',''796a'',''796b'',''796c'',''796q'',''796d'',''796e'',''797a'',''797b'',''797c'',''797d'',''797e'',''798a'',''798e'',''798c'',''798d'',''800a'',''800b'',''800c'',''800q'',''800d'',''800e'',''810a'',''810b'',''810c'',''810d'',''810e'',''811a'',''811e'',''811c'',''811d'',''896a'',''896b'',''896c'',''896q'',''896d'',''896e'',''897a'',''897b'',''897c'',''897d'',''897e'',''898a'',''898e'',''898c'',''898d'',''505r''', '', NULL), ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 1, '', '', '', 0, -1, 'SER', '', '', NULL), ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 1, '', '', '', 0, -1, 'SER', '', '', NULL), ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 1, '', '', '', 0, -1, 'SER', '', '', NULL), @@ -29140,7 +29140,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('600', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), ('600', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), ('600', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'SER', '', '', NULL), - ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -1, 'SER', '', '', NULL), + ('600', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), ('600', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -1, 'SER', '', '', NULL), ('600', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -1, 'SER', '', '', NULL), ('600', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -1, 'SER', '', '', NULL), @@ -29386,7 +29386,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('696', '6', 'Linkage', 'Linkage', 0, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), ('696', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), ('696', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 6, '', '', '', 0, -5, 'SER', '', '', NULL), - ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERS0_NAME', '', NULL, -6, 'SER', '', '', NULL), + ('696', 'a', 'Personal name', 'Personal name', 0, 0, '', 6, '', 'PERSO_NAME', '', NULL, -6, 'SER', '', '', NULL), ('696', 'b', 'Numeration', 'Numeration', 0, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), ('696', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), ('696', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 6, '', '', '', NULL, -6, 'SER', '', '', NULL), @@ -29495,7 +29495,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('700', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('700', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SER', '', '', NULL), - ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERS0_NAME', '', NULL, -1, 'SER', '', '', NULL), + ('700', 'a', 'Personal name', 'Personal name', 0, 0, 'additionalauthors.author', 7, '', 'PERSO_NAME', '', NULL, -1, 'SER', '', '', NULL), ('700', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), ('700', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -1, 'SER', '', '', NULL), @@ -30038,7 +30038,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('796', '6', 'Linkage', 'Linkage', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('796', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('796', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 7, '', '', '', 0, -5, 'SER', '', '', NULL), - ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERS0_NAME', '', NULL, -6, 'SER', '', '', NULL), + ('796', 'a', 'Personal name', 'Personal name', 0, 0, '', 7, '', 'PERSO_NAME', '', NULL, -6, 'SER', '', '', NULL), ('796', 'b', 'Numeration', 'Numeration', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('796', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), ('796', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 7, '', '', '', NULL, -6, 'SER', '', '', NULL), @@ -30134,7 +30134,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('800', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('800', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('800', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'SER', '', '', NULL), - ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'SER', '', '', NULL), + ('800', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'SER', '', '', NULL), ('800', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('800', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('800', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), @@ -30605,7 +30605,7 @@ INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` ('896', '6', 'Linkage', 'Linkage', 0, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('896', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('896', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 8, '', '', '', 0, -5, 'SER', '', '', NULL), - ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERS0_NAME', '', NULL, -6, 'SER', '', '', NULL), + ('896', 'a', 'Personal name', 'Personal name', 0, 0, '', 8, '', 'PERSO_NAME', '', NULL, -6, 'SER', '', '', NULL), ('896', 'b', 'Numeration', 'Numeration', 0, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('896', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), ('896', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 8, '', '', '', NULL, -6, 'SER', '', '', NULL), diff --git a/koha-tmpl/intranet-tmpl/prog/en/includes/auth-finder-search.inc b/koha-tmpl/intranet-tmpl/prog/en/includes/auth-finder-search.inc new file mode 100644 index 0000000000..c175172f91 --- /dev/null +++ b/koha-tmpl/intranet-tmpl/prog/en/includes/auth-finder-search.inc @@ -0,0 +1,59 @@ +
+ + + " /> + " /> +

Search on

+

+ + + " /> +

+

+ + + + + + " /> +

+

+ + + + + + " /> +

+

+ + + + + + + " /> +

+

+ Sort by + +

+ +

+
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/auth_finder.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/auth_finder.tmpl index 20e7fd963b..fc42cd7768 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/auth_finder.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/auth_finder.tmpl @@ -1,10 +1,8 @@ -Koha › Cataloguing Authority Report +Koha › Cataloguing Authority Plugin - -
@@ -12,67 +10,10 @@

Authority search

+ -
- - - " /> -

Search on

-

- - - " /> - " /> -

-

- - - - - - " /> -

-

- - - - - - " /> -

-

- - - - - - " /> -

-

- Sort by - -

-
- -
+
+
+
- - - - + diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/authorities-home.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/authorities-home.tmpl index 7499167d09..9ba53f543f 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/authorities-home.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/authorities-home.tmpl @@ -57,7 +57,7 @@ function searchauthority() { " /> @@ -69,7 +69,7 @@ function searchauthority() { " /> @@ -80,7 +80,7 @@ function searchauthority() { " /> diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist-auth.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist-auth.tmpl index ef3b92904f..271d6bfc4a 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist-auth.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist-auth.tmpl @@ -1,5 +1,5 @@ -Koha › Cataloguing Authority Selection +Koha › Cataloguing Authority Plugin - +
-
-
-
+
+
-

Authority search results

-
- - - " /> - " /> -

Search on

-

- - - " /> -

-

- - - - - - " /> -

-

- - - - - - " /> -

-

- - - - - - " /> -

-

- -

-
-
-

+

Authority search results

+ +
@@ -125,7 +74,7 @@ function jumpfull(page) - - - + + + diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist.tmpl index fa49b98648..750bac5f1f 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/authorities/searchresultlist.tmpl @@ -107,7 +107,7 @@ function searchauthority() { " /> @@ -119,7 +119,7 @@ function searchauthority() { " /> @@ -130,7 +130,7 @@ function searchauthority() { " /> diff --git a/koha-tmpl/opac-tmpl/prog/en/modules/opac-authorities-home.tmpl b/koha-tmpl/opac-tmpl/prog/en/modules/opac-authorities-home.tmpl index d6347b0c33..8fe0658cd9 100644 --- a/koha-tmpl/opac-tmpl/prog/en/modules/opac-authorities-home.tmpl +++ b/koha-tmpl/opac-tmpl/prog/en/modules/opac-authorities-home.tmpl @@ -26,7 +26,7 @@ " /> @@ -38,7 +38,7 @@ " /> @@ -50,7 +50,7 @@ @@ -79,4 +79,4 @@ - \ No newline at end of file + -- 2.39.5