Lines 7-13
WHERE frameworkcode = '' AND
Link Here
|
7 |
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); |
7 |
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); |
8 |
|
8 |
|
9 |
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) |
9 |
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) |
10 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, 0, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue |
10 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue |
11 |
FROM marc_subfield_structure |
11 |
FROM marc_subfield_structure |
12 |
WHERE frameworkcode = '' AND |
12 |
WHERE frameworkcode = '' AND |
13 |
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); |
13 |
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999'); |
Lines 16-21
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100
Link Here
|
16 |
-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES |
16 |
-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES |
17 |
-- ************************************************** |
17 |
-- ************************************************** |
18 |
|
18 |
|
|
|
19 |
UPDATE marc_subfield_structure SET tab = 0 WHERE tagfield IN ('100','245','250','260','300','500','942') AND frameworkcode = 'FA'; |
19 |
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; |
20 |
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA'; |
20 |
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; |
21 |
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA'; |
21 |
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; |
22 |
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA'; |
22 |
- |
|
|