|
Lines 20-38
Link Here
|
| 20 |
|
20 |
|
| 21 |
INSERT INTO marc_matchers (code, description, record_type, threshold) |
21 |
INSERT INTO marc_matchers (code, description, record_type, threshold) |
| 22 |
VALUES ('ISBN', '020$a', 'biblio', 1000); |
22 |
VALUES ('ISBN', '020$a', 'biblio', 1000); |
|
|
23 |
-- start_ignore |
| 23 |
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers; |
24 |
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers; |
| 24 |
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; |
25 |
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; |
| 25 |
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
26 |
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
| 26 |
SELECT MAX(matchpoint_id), 1, '020', 'a' FROM matchpoints; |
27 |
SELECT MAX(matchpoint_id), 1, '020', 'a' FROM matchpoints; |
| 27 |
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
28 |
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
| 28 |
SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components; |
29 |
SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components; |
|
|
30 |
-- end_ignore |
| 29 |
|
31 |
|
| 30 |
INSERT INTO marc_matchers (code, description, record_type, threshold) |
32 |
INSERT INTO marc_matchers (code, description, record_type, threshold) |
| 31 |
VALUES ('ISSN', '022$a', 'biblio', 1000); |
33 |
VALUES ('ISSN', '022$a', 'biblio', 1000); |
|
|
34 |
-- start_ignore |
| 32 |
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers; |
35 |
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers; |
| 33 |
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; |
36 |
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints; |
| 34 |
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
37 |
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) |
| 35 |
SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints; |
38 |
SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints; |
| 36 |
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
39 |
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) |
| 37 |
SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; |
40 |
SELECT MAX(matchpoint_component_id), 1, 'ISSN' FROM matchpoint_components; |
|
|
41 |
-- end_ignore |
| 38 |
|
42 |
|