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

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.sql (-88 lines)
Lines 1-88 Link Here
1
INSERT IGNORE INTO biblio_framework VALUES
2
		('FA', 'Fast Add Framework');
3
4
INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
5
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA'
6
FROM marc_tag_structure
7
WHERE frameworkcode = '' AND
8
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');
9
10
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)
11
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue
12
FROM marc_subfield_structure
13
WHERE frameworkcode = '' AND
14
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');
15
16
-- **************************************************
17
-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
18
-- **************************************************
19
20
UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA';
21
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA';
22
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';
23
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';
24
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA';
25
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA';
26
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';
27
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA';
28
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA';
29
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';
30
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA';
31
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA';
32
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA';
33
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA';
34
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA';
35
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA';
36
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA';
37
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA';
38
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA';
39
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA';
40
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA';
41
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA';
42
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA';
43
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA';
44
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA';
45
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA';
46
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA';
47
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA';
48
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA';
49
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA';
50
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA';
51
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA';
52
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';
53
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';
54
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA';
55
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA';
56
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA';
57
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA';
58
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA';
59
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA';
60
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA';
61
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA';
62
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA';
63
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA';
64
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA';
65
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA';
66
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA';
67
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA';
68
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA';
69
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA';
70
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA';
71
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA';
72
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA';
73
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA';
74
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA';
75
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA';
76
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA';
77
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA';
78
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA';
79
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA';
80
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA';
81
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';
82
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA';
83
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA';
84
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA';
85
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA';
86
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA';
87
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA';
88
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA';
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.txt (-1 lines)
Line 1 Link Here
1
'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing.
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.yml (-1 / +117 lines)
Line 0 Link Here
0
- 
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 under the
8
#  terms of the GNU General Public License as published by the Free Software
9
#  Foundation; either version 2 of the License, or (at your option) any later
10
#  version.
11
#
12
#  Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13
#  WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14
#  A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
15
#
16
#  You should have received a copy of the GNU General Public License along
17
#  with Koha; if not, write to the Free Software Foundation, Inc.,
18
#  51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
19
#
20
# *************************************************************
21
#      FASTADD KOHA MARC 21 BIBLIOGRAPHIC FRAMEWORK
22
# *************************************************************
23
24
description:
25
  - "'FA', a 'Fast Add' minimal MARC21 framework suitable for ILL or on-the-fly cataloguing."
26
27
tables:
28
  - biblio_framework:
29
      translatable: [ frameworktext ]
30
      multiline: []
31
      rows:
32
        - frameworkcode: FA
33
          frameworktext: "Fast Add Framework"
34
35
sql_statements:
36
  - "INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
37
    SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA'
38
    FROM marc_tag_structure
39
    WHERE frameworkcode = '' AND
40
    tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');"
41
42
  - "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)
43
    SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue
44
    FROM marc_subfield_structure
45
    WHERE frameworkcode = '' AND
46
    tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');"
47
48
  # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
49
  - "UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA';"
50
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA';"
51
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
52
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
53
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA';"
54
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA';"
55
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
56
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA';"
57
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA';"
58
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
59
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
60
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA';"
61
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA';"
62
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA';"
63
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
64
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
65
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
66
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
67
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA';"
68
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
69
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
70
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
71
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA';"
72
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA';"
73
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA';"
74
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA';"
75
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA';"
76
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA';"
77
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
78
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
79
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
80
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
81
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
82
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';"
83
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA';"
84
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA';"
85
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA';"
86
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA';"
87
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA';"
88
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA';"
89
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
90
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
91
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
92
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
93
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
94
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA';"
95
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA';"
96
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA';"
97
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA';"
98
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
99
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
100
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA';"
101
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
102
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA';"
103
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
104
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
105
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA';"
106
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA';"
107
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA';"
108
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA';"
109
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA';"
110
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';"
111
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
112
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA';"
113
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
114
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA';"
115
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA';"
116
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA';"
117
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA';"

Return to bug 24593