View | Details | Raw Unified | Return to bug 16954
Collapse All | Expand All

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+71 lines)
Lines 36-38 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
40
    VALUES ('100$a', 'Personal name', 'authority', 1000);
41
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
42
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
43
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
44
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('150$a', 'Topical term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('155$a', 'Genre form', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+72 lines)
Lines 44-46 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
44
    SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;
44
    SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;
46
    SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('100$a', 'Nombre de persona', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('110$a', 'Nombre de entidad', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('111$a', 'Nombre de congreso', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('130$a', 'Título uniforme', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('148$a', 'Término cronológico', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('150$a', 'Término de materia', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('151$a', 'Nombre geográfico', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
110
111
INSERT INTO marc_matchers (code, description, record_type, threshold)
112
    VALUES ('155$a', 'Género/forma', 'authority', 1000);
113
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
114
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
115
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
116
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
117
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
118
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/fr-CA/marcflavour/marc21/facultatif/marc21_default_matching_rules.sql (+72 lines)
Lines 44-46 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
44
    SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;
44
    SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;
46
    SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('100$a', 'Personal name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('150$a', 'Topical term', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
110
111
INSERT INTO marc_matchers (code, description, record_type, threshold)
112
    VALUES ('155$a', 'Genre form', 'authority', 1000);
113
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
114
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
115
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
116
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
117
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
118
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_default_matching_rules.sql (+71 lines)
Lines 36-38 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
40
    VALUES ('100$a', 'Personal name', 'authority', 1000);
41
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
42
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
43
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
44
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('150$a', 'Topical term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('155$a', 'Genre form', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+72 lines)
Lines 44-46 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
44
    SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;
44
    SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;
46
    SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('100$a', 'Personal name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('150$a', 'Topical term', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
110
111
INSERT INTO marc_matchers (code, description, record_type, threshold)
112
    VALUES ('155$a', 'Genre form', 'authority', 1000);
113
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
114
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
115
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
116
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
117
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
118
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+71 lines)
Lines 36-38 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
40
    VALUES ('100$a', 'Personal name', 'authority', 1000);
41
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
42
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
43
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
44
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('150$a', 'Topical term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('155$a', 'Genre form', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+71 lines)
Lines 36-38 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
40
    VALUES ('100$a', 'Personal name', 'authority', 1000);
41
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
42
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
43
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
44
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('150$a', 'Topical term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('155$a', 'Genre form', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+72 lines)
Lines 35-37 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
40
    VALUES ('100$a', 'Personal name', 'authority', 1000);
41
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
42
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
43
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
44
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('150$a', 'Topical term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('155$a', 'Genre form', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +72 lines)
Lines 35-37 INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) Link Here
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
36
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
37
    SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;
38
- 
38
39
INSERT INTO marc_matchers (code, description, record_type, threshold)
40
    VALUES ('100$a', 'Personal name', 'authority', 1000);
41
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Personal-name-heading', 1000 FROM marc_matchers;
42
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
43
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
44
    SELECT MAX(matchpoint_id), 1, '100', 'a' FROM matchpoints;
45
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
46
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
47
48
INSERT INTO marc_matchers (code, description, record_type, threshold)
49
    VALUES ('110$a', 'Corporate name', 'authority', 1000);
50
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Corporate-name-heading', 1000 FROM marc_matchers;
51
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
52
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
53
    SELECT MAX(matchpoint_id), 1, '110', 'a' FROM matchpoints;
54
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
55
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
56
57
INSERT INTO marc_matchers (code, description, record_type, threshold)
58
    VALUES ('111$a', 'Meeting name', 'authority', 1000);
59
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Meeting-name-heading', 1000 FROM marc_matchers;
60
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
61
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
62
    SELECT MAX(matchpoint_id), 1, '111', 'a' FROM matchpoints;
63
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
64
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
65
66
INSERT INTO marc_matchers (code, description, record_type, threshold)
67
    VALUES ('130$a', 'Uniform title', 'authority', 1000);
68
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Title-uniform-heading', 1000 FROM marc_matchers;
69
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
70
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
71
    SELECT MAX(matchpoint_id), 1, '130', 'a' FROM matchpoints;
72
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
73
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
74
75
INSERT INTO marc_matchers (code, description, record_type, threshold)
76
    VALUES ('148$a', 'Chronological term', 'authority', 1000);
77
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Chronological-term-heading', 1000 FROM marc_matchers;
78
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
79
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
80
    SELECT MAX(matchpoint_id), 1, '148', 'a' FROM matchpoints;
81
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
82
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
83
84
INSERT INTO marc_matchers (code, description, record_type, threshold)
85
    VALUES ('150$a', 'Topical term', 'authority', 1000);
86
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Subject-topical-heading', 1000 FROM marc_matchers;
87
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
88
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
89
    SELECT MAX(matchpoint_id), 1, '150', 'a' FROM matchpoints;
90
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
91
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
92
93
INSERT INTO marc_matchers (code, description, record_type, threshold)
94
    VALUES ('151$a', 'Geographic name', 'authority', 1000);
95
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Name-geographic-heading', 1000 FROM marc_matchers;
96
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
97
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
98
    SELECT MAX(matchpoint_id), 1, '151', 'a' FROM matchpoints;
99
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
100
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;
101
102
INSERT INTO marc_matchers (code, description, record_type, threshold)
103
    VALUES ('155$a', 'Genre form', 'authority', 1000);
104
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'Term-genre-form-heading', 1000 FROM marc_matchers;
105
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
106
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
107
    SELECT MAX(matchpoint_id), 1, '155', 'a' FROM matchpoints;
108
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine)
109
    SELECT MAX(matchpoint_component_id), 1, '' FROM matchpoint_components;

Return to bug 16954