Bugzilla – Attachment 53617 Details for
Bug 16954
Add the diff view to authorities in staged MARC records
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16954: Add the "record matching rules" for all languages
Bug-16954-Add-the-record-matching-rules-for-all-la.patch (text/plain), 54.85 KB, created by
Héctor Eduardo Castro Avalos
on 2016-07-21 20:50:40 UTC
(
hide
)
Description:
Bug 16954: Add the "record matching rules" for all languages
Filename:
MIME Type:
Creator:
Héctor Eduardo Castro Avalos
Created:
2016-07-21 20:50:40 UTC
Size:
54.85 KB
patch
obsolete
>From eea8a013345692fa037a3e656de9fd3b152096f4 Mon Sep 17 00:00:00 2001 >From: Hector Castro <hector.hecaxmmx@gmail.com> >Date: Thu, 21 Jul 2016 14:17:16 -0600 >Subject: [PATCH] Bug 16954: Add the "record matching rules" for all languages > >This patch add the matching rules for all languages so diff tool >works properly in all languages for new installations > >To test: >Execute the sql: >SET FOREIGN_KEY_CHECKS=0; >truncate marc_matchers; truncate matchpoints; truncate matcher_matchpoints; >truncate matchpoint_components; truncate matchpoint_component_norms; >SET FOREIGN_KEY_CHECKS=1; > >mysql -ukohauser -ppassword koha < kohaclone/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql > >Go to Tool -> Record matching rules. You will see the new data in Spanish > >Sponsored-by: Universidad de El Salvador >--- > .../optional/marc21_default_matching_rules.sql | 71 +++++++++++++++++++ > .../optional/marc21_default_matching_rules.sql | 72 ++++++++++++++++++++ > .../facultatif/marc21_default_matching_rules.sql | 72 ++++++++++++++++++++ > .../Optionnel/marc21_default_matching_rules.sql | 71 +++++++++++++++++++ > .../optional/marc21_default_matching_rules.sql | 72 ++++++++++++++++++++ > .../optional/marc21_default_matching_rules.sql | 71 +++++++++++++++++++ > .../optional/marc21_default_matching_rules.sql | 71 +++++++++++++++++++ > .../optional/marc21_default_matching_rules.sql | 72 ++++++++++++++++++++ > .../optional/marc21_default_matching_rules.sql | 72 ++++++++++++++++++++ > 9 files changed, 644 insertions(+) > >diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index b863911..4be2297 100644 >--- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -36,3 +36,74 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; > >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index 2e538a4..e002dd3 100644 >--- a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -44,3 +44,75 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints; > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Nombre de persona', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Nombre de entidad', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Nombre de congreso', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'TÃtulo uniforme', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Término cronológico', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Término de materia', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Nombre geográfico', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Género/forma', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/fr-CA/marcflavour/marc21/facultatif/marc21_default_matching_rules.sql b/installer/data/mysql/fr-CA/marcflavour/marc21/facultatif/marc21_default_matching_rules.sql >index 5192044..e2e8a90 100644 >--- a/installer/data/mysql/fr-CA/marcflavour/marc21/facultatif/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/fr-CA/marcflavour/marc21/facultatif/marc21_default_matching_rules.sql >@@ -44,3 +44,75 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints; > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_default_matching_rules.sql b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_default_matching_rules.sql >index b863911..4be2297 100644 >--- a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_default_matching_rules.sql >@@ -36,3 +36,74 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; > >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index 2e538a4..ad987b0 100644 >--- a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -44,3 +44,75 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints; > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index b863911..4be2297 100644 >--- a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -36,3 +36,74 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; > >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index 083efdf..ef372b3 100644 >--- a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -36,3 +36,74 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; > >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index 5415075..ef372b3 100644 >--- a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -35,3 +35,75 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints; > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >diff --git a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_default_matching_rules.sql >index 5415075..ef372b3 100644 >--- a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_default_matching_rules.sql >+++ b/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_default_matching_rules.sql >@@ -35,3 +35,75 @@ INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) > SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints; > INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) > SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('100$a', 'Personal name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('110$a', 'Corporate name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('111$a', 'Meeting name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('130$a', 'Uniform title', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('148$a', 'Chronological term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('150$a', 'Topical term', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('151$a', 'Geographic name', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >+ >+INSERT INTO marc_matchers (code, description, record_type, threshold) >+ VALUES ('155$a', 'Genre form', 'authority', 1000); >+INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers; >+INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; >+INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) >+ SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints; >+INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) >+ SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components; >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 16954
:
53610
|
53611
|
53613
| 53617