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

(-)a/installer/data/mysql/en/marcflavour/unimarc/optional/unimarc_sample_fastadd_framework.yml (+63 lines)
Line 0 Link Here
1
---
2
#
3
#  Copyright 2020 Koha Development Team
4
#
5
#  This file is part of Koha.
6
#
7
# Koha is free software; you can redistribute it and/or modify it
8
# under the terms of the GNU General Public License as published by
9
# the Free Software Foundation; either version 3 of the License, or
10
# (at your option) any later version.
11
#
12
# Koha is distributed in the hope that it will be useful, but
13
# WITHOUT ANY WARRANTY; without even the implied warranty of
14
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15
# GNU General Public License for more details.
16
#
17
# You should have received a copy of the GNU General Public License
18
# along with Koha; if not, see <http://www.gnu.org/licenses>.
19
20
#
21
# *************************************************************
22
#      FASTADD KOHA UNIMARC BIBLIOGRAPHIC FRAMEWORK
23
# *************************************************************
24
25
description:
26
  - "'FA', a 'Fast Add' minimal UNIMARC framework suitable for ILL or on-the-fly cataloguing."
27
28
tables:
29
  - biblio_framework:
30
      translatable: [ frameworktext ]
31
      multiline: []
32
      rows:
33
        - frameworkcode: FA
34
          frameworktext: "Fast Add Framework"
35
36
sql_statements:
37
  - "INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
38
    SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA'
39
    FROM marc_tag_structure
40
    WHERE frameworkcode = '' AND
41
    tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225', '995');"
42
43
  - "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)
44
    SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue
45
    FROM marc_subfield_structure
46
    WHERE frameworkcode = '' AND
47
    tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225')
48
    OR ( tagfield = '995' AND tagsubfield IN ('9', 'b', 'c', 'e', 'f', 'j', 'k') );"
49
50
  # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
51
  - "UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('000', '001', '090', '100', '200', '205', '210', '225') AND frameworkcode = 'FA';"
52
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = '9' AND frameworkcode = 'FA';"
53
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
54
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '090' AND tagsubfield = 't' AND frameworkcode = 'FA';"
55
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
56
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '200' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
57
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '200' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
58
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '205' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
59
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '210' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
60
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '210' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
61
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '210' AND tagsubfield = 'd' AND frameworkcode = 'FA';"
62
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '225' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
63
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '995' frameworkcode = 'FA';"
(-)a/installer/data/mysql/localization/fr-FR/custom.sql (-1 / +26 lines)
Line 0 Link Here
0
- 
1
UPDATE systempreferences SET value = 'Père|Mère|grand-parent|Tuteur légal|Autre' WHERE variable = 'borrowerRelationship';
2
UPDATE systempreferences SET value = 'M|Mme|Mlle' WHERE variable = 'BorrowersTitles';
3
UPDATE systempreferences SET value = '676a' WHERE variable = 'itemcallnumber';
4
UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'language';
5
UPDATE systempreferences SET value = 'Ma bibliothèque' WHERE variable = 'LibraryName';
6
UPDATE systempreferences SET value = 'fr-FR' WHERE variable = 'OPACLanguages';
7
UPDATE systempreferences SET value = 1 WHERE variable = 'opaclanguagesdisplay';
8
UPDATE systempreferences SET value = 'bibtex,dc,marcxml,marc8,utf8,marcstd,ris' WHERE variable = 'OpacExportOptions';
9
10
INSERT INTO `z3950servers`
11
(`host`, `port`, `db`, `userid`, `password`, `servername`, `id`, `checked`, `rank`, `syntax`, `servertype`, `encoding`) VALUES
12
('z3950.bnf.fr', 2211, 'TOUT-UTF8', 'Z3950', 'Z3950_BNF', 'BNF2', 2, 1, 2, 'UNIMARC', 'zed', 'utf8');
13
14
DELETE FROM `itemtypes`;
15
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LIVR', ' Livre', 0.0000, 0, '', '');
16
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('BD', 'BD', 0.0000, 0, '', '');
17
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('LOC', 'Fonds Local', 0.0000, 0, '', '');
18
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('PERI', 'Périodique', 0.0000, 0, '', '');
19
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('USUE', 'Usuel', 0.0000, 1, '', '');
20
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ARTI', 'Article', 0.0000, 1, '', '');
21
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CD', 'CD musique', 0.0000, 0, '', '');
22
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('CDR', 'CD-ROM', 0.0000, 0, '', '');
23
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('DVD', 'DVD', 0.0000, 0, '', '');
24
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('WEB', 'Ressource Web', 0.0000, 1, '', '');
25
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('ADAP', 'Document Adapté', 0.0000, 0, '', '');
26
INSERT INTO `itemtypes` (`itemtype`, `description`, `rentalcharge`, `notforloan`, `imageurl`, `summary`) VALUES ('VHS', 'VHS', 0.0000, 0, '', '');

Return to bug 27619