Bugzilla – Attachment 20171 Details for
Bug 10521
Add i18n function to German mysql files for webinstaller (de-DE)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 10521: Prepare de-DE marc21/optional files for conversion
Bug-10521-Prepare-de-DE-marc21optional-files-for-c.patch (text/plain), 3.49 KB, created by
Marcel de Rooy
on 2013-08-08 13:17:59 UTC
(
hide
)
Description:
Bug 10521: Prepare de-DE marc21/optional files for conversion
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2013-08-08 13:17:59 UTC
Size:
3.49 KB
patch
obsolete
>From 422d997da189fcefe82ae74c6d6f64ddebf56e2f Mon Sep 17 00:00:00 2001 >From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 10521
:
20166
|
20167
|
20168
|
20169
|
20170
| 20171 |
20172
|
20173