Lines 48-69
tables:
Link Here
|
48 |
threshold: 1000 |
48 |
threshold: 1000 |
49 |
|
49 |
|
50 |
sql_statements: |
50 |
sql_statements: |
51 |
- "INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;" |
51 |
- "INSERT INTO matchpoints (matcher_id, search_index, score) SELECT matcher_id, 'isbn', 1000 FROM marc_matchers WHERE code = 'ISBN';" |
52 |
- "INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;" |
52 |
- "INSERT INTO matcher_matchpoints SELECT matcher_id, matchpoint_id FROM matchpoints WHERE search_index = 'isbn';" |
53 |
- "INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) SELECT MAX(matchpoint_id), 1, '020', 'a' FROM matchpoints;" |
53 |
- "INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
|
|
54 |
SELECT matchpoint_id, 1, '020', 'a' FROM matchpoints WHERE search_index = 'isbn';" |
54 |
- "INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
55 |
- "INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
55 |
SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components;" |
56 |
SELECT matchpoint_component_id, 1, 'ISBN' FROM matchpoint_components WHERE tag = '020';" |
56 |
|
57 |
|
57 |
- "INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;" |
58 |
- "INSERT INTO matchpoints (matcher_id, search_index, score) SELECT matcher_id, 'issn', 1000 FROM marc_matchers WHERE code = 'ISSN';" |
58 |
- "INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;" |
59 |
- "INSERT INTO matcher_matchpoints SELECT matcher_id, matchpoint_id FROM matchpoints WHERE search_index = 'issn';" |
59 |
- "INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
60 |
- "INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
60 |
SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;" |
61 |
SELECT matchpoint_id, 1, '022', 'a' FROM matchpoints WHERE search_index = 'issn';" |
61 |
- "INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
62 |
- "INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
62 |
SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components;" |
63 |
SELECT matchpoint_component_id, 1, 'ISSN' FROM matchpoint_components WHERE tag = '022';" |
63 |
|
64 |
|
64 |
- "INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'local-number', 1000 FROM marc_matchers;" |
65 |
- "INSERT INTO matchpoints (matcher_id, search_index, score) SELECT matcher_id, 'local-number', 1000 FROM marc_matchers WHERE code = 'KohaBiblio';" |
65 |
- "INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;" |
66 |
- "INSERT INTO matcher_matchpoints SELECT matcher_id, matchpoint_id FROM matchpoints WHERE search_index = 'local-number';" |
66 |
- "INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
67 |
- "INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
67 |
SELECT MAX(matchpoint_id), 1, '999', 'c' FROM matchpoints;" |
68 |
SELECT matchpoint_id, 1, '999', 'c' FROM matchpoints WHERE search_index = 'local-number';" |
68 |
- "INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
69 |
- "INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
69 |
SELECT MAX(matchpoint_component_id), 1, 'Biblionumber' FROM matchpoint_components;" |
70 |
SELECT matchpoint_component_id, 1, 'Biblionumber' FROM matchpoint_components WHERE tag = '999';" |
70 |
- |
|
|