Bugzilla – Attachment 121625 Details for
Bug 27619
Remove fr-FR installer data
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 27619: FA for UNIMARC and custom for fr-FR
Bug-27619-FA-for-UNIMARC-and-custom-for-fr-FR.patch (text/plain), 7.83 KB, created by
Jonathan Druart
on 2021-06-04 09:56:46 UTC
(
hide
)
Description:
Bug 27619: FA for UNIMARC and custom for fr-FR
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2021-06-04 09:56:46 UTC
Size:
7.83 KB
patch
obsolete
>From 3441b72eea451f1d0b51345956edd6ea4ff9aa8d Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 4 Jun 2021 11:56:18 +0200 >Subject: [PATCH] Bug 27619: FA for UNIMARC and custom for fr-FR > >--- > .../unimarc_sample_fastadd_framework.yml | 63 +++++++++++++++++++ > .../data/mysql/localization/fr-FR/custom.sql | 26 ++++++++ > 2 files changed, 89 insertions(+) > create mode 100644 installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml > create mode 100644 installer/data/mysql/localization/fr-FR/custom.sql > >diff --git a/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml b/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml >new file mode 100644 >index 00000000000..77ab841b771 >--- /dev/null >+++ b/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml >@@ -0,0 +1,63 @@ >+--- >+# >+# Copyright 2020 Koha Development Team >+# >+# This file is part of Koha. >+# >+# Koha is free software; you can redistribute it and/or modify it >+# under the terms of the GNU General Public License as published by >+# the Free Software Foundation; either version 3 of the License, or >+# (at your option) any later version. >+# >+# Koha is distributed in the hope that it will be useful, but >+# WITHOUT ANY WARRANTY; without even the implied warranty of >+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the >+# GNU General Public License for more details. >+# >+# You should have received a copy of the GNU General Public License >+# along with Koha; if not, see <http://www.gnu.org/licenses>. >+ >+# >+# ************************************************************* >+# FASTADD KOHA UNIMARC BIBLIOGRAPHIC FRAMEWORK >+# ************************************************************* >+ >+description: >+ - "'FA', a 'Fast Add' minimal UNIMARC framework suitable for ILL or on-the-fly cataloguing." >+ >+tables: >+ - biblio_framework: >+ translatable: [ frameworktext ] >+ multiline: [] >+ rows: >+ - frameworkcode: FA >+ frameworktext: "Fast Add Framework" >+ >+sql_statements: >+ - "INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) >+ SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA' >+ FROM marc_tag_structure >+ WHERE frameworkcode = '' AND >+ tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225', '995');" >+ >+ - "INSERT IGNORE INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue) >+ SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue >+ FROM marc_subfield_structure >+ WHERE frameworkcode = '' AND >+ tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225') >+ OR ( tagfield = '995' AND tagsubfield IN ('9', 'b', 'c', 'e', 'f', 'j', 'k') );" >+ >+ # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES >+ - "UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225') AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = '9' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = 't' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'a' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '200' AND tagsubfield = 'a' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '200' AND tagsubfield = 'f' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '205' AND tagsubfield = 'a' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '210' AND tagsubfield = 'a' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '210' AND tagsubfield = 'c' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '210' AND tagsubfield = 'd' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '225' AND tagsubfield = 'a' AND frameworkcode = 'FA';" >+ - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '995' frameworkcode = 'FA';" >diff --git a/installer/data/mysql/localization/fr-FR/custom.sql b/installer/data/mysql/localization/fr-FR/custom.sql >new file mode 100644 >index 00000000000..b429980adc7 >--- /dev/null >+++ b/installer/data/mysql/localization/fr-FR/custom.sql >@@ -0,0 +1,26 @@ >+UPDATE systempreferences SET value = 'Père|Mère|grand-parent|Tuteur légal|Autre' WHERE variable = 'borrowerRelationship'; >+UPDATE systempreferences SET value = 'M|Mme|Mlle' WHERE variable = 'BorrowersTitles'; >+UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber'; >+UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'language'; >+UPDATE systempreferences SET value = 'Ma bibliothèque' WHERE variable = 'LibraryName'; >+UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'OPACLanguages'; >+UPDATE systempreferences SET value = 1 WHERE variable = 'opaclanguagesdisplay'; >+UPDATE systempreferences SET value = 'bibtex,dc,marcxml,marc8,utf8,marcstd,ris' WHERE variable = 'OpacExportOptions'; >+ >+INSERT INTO `z3950servers` >+(`host`, `port`, `db`, `userid`, `password`, `servername`, `id`, `checked`, `rank`, `syntax`, `servertype`, `encoding`) VALUES >+('z3950.bnf.fr', 2211, 'TOUT-UTF8', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 2, 'UNIMARC', 'zed', 'utf8'); >+ >+DELETE FROM `itemtypes`; >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0.0000, 1, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 1, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0.0000, 1, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 0.0000, 0, '', ''); >+INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 0.0000, 0, '', ''); >-- >2.20.1
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 27619
:
121625
|
134213
|
134553
|
134554
|
134861