Attachment #20171 for bug #10521

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





INSERT INTO marc_matchers (code, description, record_type, threshold) 
    VALUES ('ISBN', '020$a', 'biblio', 1000);
-- start_ignore
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 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, '020', 'a' FROM matchpoints;
INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_routine) 
    SELECT MAX(matchpoint_component_id), 1, 'ISBN' FROM matchpoint_components;
-- end_ignore

INSERT INTO marc_matchers (code, description, record_type, threshold) 
    VALUES ('ISSN', '022$a', 'biblio', 1000);
-- start_ignore
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 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, '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;
-- end_ignore


Lines 1-4 Link Here

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-2 / +1 lines)
1	INSERT IGNORE INTO biblio_framework VALUES ( 'FA','Schnellaufnahme' );	1	INSERT IGNORE INTO biblio_framework (frameworkcode, frameworktext) VALUES ( 'FA','Schnellaufnahme' );
2	INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES	2	INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
3	('000', 'Satzkennung', 'Satzkennung', 0, 1, '', 'FA'),	3	('000', 'Satzkennung', 'Satzkennung', 0, 1, '', 'FA'),
4	('008', 'Feld mit fester Länge zur physischen Beschreibung - Allgemeine Angaben', 'Feld mit fester Länge zur physischen Beschreibung - Allgemeine Angaben', 0, 1, '', 'FA'),	4	('008', 'Feld mit fester Länge zur physischen Beschreibung - Allgemeine Angaben', 'Feld mit fester Länge zur physischen Beschreibung - Allgemeine Angaben', 0, 1, '', 'FA'),
5	-

Return to bug 10521

Lines 20-38 Link Here

(-)a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql (+4 lines)
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