From 422d997da189fcefe82ae74c6d6f64ddebf56e2f Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Thu, 8 Aug 2013 10:41:55 +0200 Subject: [PATCH] Bug 10521: Prepare de-DE marc21/optional files for conversion Content-Type: text/plain; charset=utf-8 Makes some manual changes to .sql files before converting them to new format for use with i18n function. Default matching rules: added only some comment lines to skip a few INSERT..SELECT constructs during conversion. Fastadd framework: Add column names. Test plan: See next patch for de-DE marc21/optional files. --- .../optional/marc21_default_matching_rules.sql | 4 ++++ .../marc21/optional/marc21_fastadd_framework.sql | 2 +- 2 files changed, 5 insertions(+), 1 deletions(-) diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql index 4d39a5e..699eaf5 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql @@ -20,19 +20,23 @@ 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 diff --git a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql index ac7634a..df5e66b 100644 --- a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql +++ b/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_fastadd_framework.sql @@ -1,4 +1,4 @@ -INSERT IGNORE INTO biblio_framework VALUES ( 'FA','Schnellaufnahme' ); +INSERT IGNORE INTO biblio_framework (frameworkcode, frameworktext) VALUES ( 'FA','Schnellaufnahme' ); INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES ('000', 'Satzkennung', 'Satzkennung', 0, 1, '', 'FA'), ('008', 'Feld mit fester Länge zur physischen Beschreibung - Allgemeine Angaben', 'Feld mit fester Länge zur physischen Beschreibung - Allgemeine Angaben', 0, 1, '', 'FA'), -- 1.7.7.6