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

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_default_matching_rules.yml (-13 / +13 lines)
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
- 

Return to bug 24593