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

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_sample_fastadd_framework.yml (-69 / +50 lines)
Lines 48-118 sql_statements: Link Here
48
48
49
  # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
49
  # REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
50
  - "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 tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA';"
51
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA';"
51
  - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '010' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
52
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
52
  - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
53
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
53
  - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
54
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA';"
54
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '020' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
55
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA';"
55
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '020' AND tagsubfield = 'q' AND frameworkcode = 'FA';"
56
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
56
  - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
57
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA';"
57
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '022' AND tagsubfield = '2' AND frameworkcode = 'FA';"
58
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA';"
58
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '022' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
59
  - "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 = '022' AND tagsubfield = 'y' AND frameworkcode = 'FA';"
60
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
60
  - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '022' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
61
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA';"
61
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '050' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
62
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA';"
62
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '050' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
63
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA';"
63
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '082' AND tagsubfield = '2' AND frameworkcode = 'FA';"
64
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
64
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '082' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
65
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
65
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '082' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
66
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
66
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '100' AND tagsubfield = 'd' AND frameworkcode = 'FA';"
67
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
67
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '100' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
68
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA';"
68
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '100' AND tagsubfield = 'q' AND frameworkcode = 'FA';"
69
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
69
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '245' AND tagsubfield = 'h' AND frameworkcode = 'FA';"
70
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
70
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
71
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
71
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';"
72
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA';"
72
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '250' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
73
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA';"
73
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '250' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
74
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA';"
74
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '260' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
75
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA';"
75
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '260' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
76
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA';"
76
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '260' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
77
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA';"
77
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
78
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
78
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
79
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
79
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'b' AND frameworkcode = 'FA';"
80
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
80
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
81
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
81
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
82
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
82
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
83
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';"
83
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '300' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
84
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA';"
84
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '500' AND tagsubfield = 'a' AND frameworkcode = 'FA';"
85
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA';"
85
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
86
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA';"
86
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'h' AND frameworkcode = 'FA';"
87
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA';"
87
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'i' AND frameworkcode = 'FA';"
88
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA';"
88
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
89
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA';"
89
  - "UPDATE marc_subfield_structure SET hidden ='-1' WHERE tagfield = '942' AND tagsubfield = 'm' AND frameworkcode = 'FA';"
90
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
90
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = '0' AND frameworkcode = 'FA';"
91
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
91
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = '4' AND frameworkcode = 'FA';"
92
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
92
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = '5' AND frameworkcode = 'FA';"
93
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA';"
93
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'e' AND frameworkcode = 'FA';"
94
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
94
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'f' AND frameworkcode = 'FA';"
95
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA';"
95
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'g' AND frameworkcode = 'FA';"
96
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA';"
96
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'i' AND frameworkcode = 'FA';"
97
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA';"
97
  - "UPDATE marc_subfield_structure SET hidden ='-5' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';"
98
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA';"
98
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 't' AND frameworkcode = 'FA';"
99
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
99
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'u' AND frameworkcode = 'FA';"
100
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
100
  - "UPDATE marc_subfield_structure SET hidden ='-6' WHERE tagfield = '952' AND tagsubfield = 'w' AND frameworkcode = 'FA';"
101
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA';"
102
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA';"
103
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA';"
104
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA';"
105
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
106
  - "UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA';"
107
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA';"
108
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA';"
109
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA';"
110
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA';"
111
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';"
112
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA';"
113
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA';"
114
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA';"
115
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA';"
116
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA';"
117
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA';"
118
  - "UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA';"
119
- 

Return to bug 36055