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

(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_fastadd_framework.sql (-140 / +84 lines)
Lines 1-141 Link Here
1
INSERT IGNORE INTO biblio_framework VALUES
1
INSERT IGNORE INTO biblio_framework VALUES ('FA', 'Fast Add Framework');
2
             ('FA', 'Fast Add Framework');
3
2
4
INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeatable`, `mandatory`, `authorised_value`, `frameworkcode`) VALUES
3
INSERT IGNORE INTO marc_tag_structure (tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
5
          ('000', 'LEADER', 'LEADER', 0, 1, '', 'FA'),
4
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'FA'
6
           ('008', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 'FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION', 0, 1, '', 'FA'),
5
FROM marc_tag_structure
7
         ('010', 'LIBRARY OF CONGRESS CONTROL NUMBER', 'LIBRARY OF CONGRESS CONTROL NUMBER', 0, 0, '', 'FA'),
6
WHERE frameworkcode = '' AND
8
           ('020', 'INTERNATIONAL STANDARD BOOK NUMBER', 'INTERNATIONAL STANDARD BOOK NUMBER', 1, 0, NULL, 'FA'),
7
tagfield IN ('000', '008', '010', '020', '022', '050', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');
9
         ('022', 'INTERNATIONAL STANDARD SERIAL NUMBER', 'INTERNATIONAL STANDARD SERIAL NUMBER', 1, 0, NULL, 'FA'),
10
             ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, 'FA'),
11
               ('090', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 'LOCALLY ASSIGNED LC-TYPE CALL NUMBER (OCLC); LOCAL CALL NUMBER (RLIN)', 1, 0, '', 'FA'),
12
             ('099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, '', 'FA'),
13
           ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'FA'),
14
           ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', 'FA'),
15
         ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, 'FA'),
16
           ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, 'FA'),
17
           ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, 'FA'),
18
             ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'FA'),
19
             ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'FA'),
20
         ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'FA'),
21
               ('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', 'FA');
22
8
23
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`) VALUES
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)
24
              ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', NULL, 0, 'FA', '', NULL, NULL),
10
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, 0, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue
25
              ('008', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_field_008.pl', NULL, 0, 'FA', '', NULL, NULL),
11
FROM marc_subfield_structure
26
           ('010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
12
WHERE frameworkcode = '' AND
27
           ('010', 'a', 'LC control number', 'LC control number', 0, 0, 'biblioitems.lccn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
13
tagfield IN ('000', '008', '010', '020', '022', '050', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');
28
             ('010', 'b', 'NUCMC control number', 'NUCMC control number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
14
29
               ('010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
15
-- **************************************************
30
           ('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
16
-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
31
         ('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
17
-- **************************************************
32
           ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
18
33
           ('020', 'c', 'Terms of availability', 'Terms of availability', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
19
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA';
34
             ('020', 'z', 'Canceled/invalid ISBN', 'Canceled/invalid ISBN', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
20
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'b' AND frameworkcode = 'FA';
35
             ('050', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL),
21
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = 'z' AND frameworkcode = 'FA';
36
             ('050', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL),
22
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA';
37
         ('082', '2', 'Edition number', 'Edition number', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
23
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA';
38
              ('082', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
24
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';
39
            ('082', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
25
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA';
40
              ('082', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
26
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA';
41
                ('082', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
27
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';
42
            ('090', 'a', 'Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR)', 'Classification number (OCLC) (R) ; Classification number, CALL (RLIN) (NR)', 1, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL),
28
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA';
43
           ('090', 'b', 'Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN)', 'Local cutter number (OCLC) ; Book number/undivided call number, CALL (RLIN)', 0, 0, '', 0, '', '', '', 0, 5, 'FA', '', '', NULL),
29
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA';
44
         ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
30
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA';
45
               ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
31
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA';
46
         ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
32
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA';
47
           ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
33
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA';
48
               ('100', 'c', 'Titles and words associated with a name', 'Titles and words associated with a name', 0, 0, 'biblio.author', 0, '', 'PERSO_NAME', '', 0, 0, 'FA', NULL, '', ''),
34
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA';
49
          ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
35
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA';
50
           ('100', 'c', 'Titles and other words associated with a name', 'Titles and other words associated with a name', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
36
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA';
51
             ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
37
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA';
52
               ('100', 'e', 'Relator term', 'Relator term', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
38
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA';
53
               ('100', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
39
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA';
54
           ('100', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
40
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA';
55
             ('100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
41
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA';
56
             ('100', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
42
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA';
57
         ('100', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
43
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA';
58
           ('100', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
44
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA';
59
               ('100', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
45
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA';
60
           ('100', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
46
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA';
61
         ('100', 't', 'Title of a work', 'Title of a work', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
47
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA';
62
         ('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
48
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA';
63
         ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
49
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA';
64
         ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
50
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';
65
           ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
51
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';
66
         ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
52
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA';
67
           ('245', 'c', 'Statement of responsibility, etc.', 'Statement of responsibility, etc.', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
53
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA';
68
             ('245', 'd', 'Designation of section/part/series (SE) [OBSOLETE]', 'Designation of section section/part/series: (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
54
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA';
69
          ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
55
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA';
70
         ('245', 'f', 'Inclusive dates', 'Inclusive dates', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
56
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA';
71
         ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
57
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA';
72
           ('245', 'h', 'Medium', 'Medium', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
58
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA';
73
           ('245', 'k', 'Form', 'Form', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
59
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA';
74
               ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
60
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA';
75
               ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
61
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA';
76
           ('245', 's', 'Version', 'Version', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
62
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA';
77
         ('250', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
63
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA';
78
         ('250', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
64
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA';
79
           ('250', 'a', 'Edition statement', 'Edition statement', 0, 0, 'biblioitems.editionstatement', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
65
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA';
80
         ('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
66
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA';
81
           ('260', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
67
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA';
82
         ('260', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
68
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA';
83
           ('260', 'a', 'Place of publication, distribution, etc.', 'Place of publication, distribution, etc.', 1, 0, 'biblioitems.place', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
69
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA';
84
              ('260', 'b', 'Name of publisher, distributor, etc.', 'Name of publisher, distributor, etc.', 1, 0, 'biblioitems.publishercode', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
70
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA';
85
              ('260', 'c', 'Date of publication, distribution, etc.', 'Date of publication, distribution, etc.', 1, 0, 'biblio.copyrightdate', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
71
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA';
86
             ('260', 'd', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'Plate or publisher\'s number for music (Pre-AACR 2) [OBSOLETE, CAN/MARC], [LOCAL, USA]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
72
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA';
87
           ('260', 'e', 'Place of manufacture', 'Place of manufacture', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
73
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA';
88
               ('260', 'f', 'Manufacturer', 'Manufacturer', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
74
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA';
89
               ('260', 'g', 'Date of manufacture', 'Date of manufacture', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
75
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA';
90
         ('260', 'k', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
76
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA';
91
         ('260', 'l', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 'Matrix and/or take number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
77
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA';
92
           ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
78
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA';
93
         ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
79
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';
94
           ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
80
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA';
95
         ('500', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
81
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA';
96
           ('500', 'a', 'General note', 'General note', 0, 0, 'biblio.notes', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
82
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA';
97
           ('500', 'l', 'Library of Congress call number (SE) [OBSOLETE]', 'Library of Congress call number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
83
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA';
98
         ('500', 'n', 'n (RLIN) [OBSOLETE]', 'n (RLIN) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
84
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA';
99
         ('500', 'x', 'International Standard Serial Number (SE) [OBSOLETE]', 'International Standard Serial Number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
85
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA';
100
               ('500', 'z', 'Source of note information (AM SE) [OBSOLETE]', 'Source of note information (AM SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
86
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA';
101
             ('942', '0', 'Koha issues (borrowed), all copies', 'Koha issues (borrowed), all copies', 0, 0, 'biblioitems.totalissues', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
102
         ('942', 'c', 'Koha item type', 'Koha item type', 0, 1, 'biblioitems.itemtype', 9, 'itemtypes', '', '', NULL, 5, 'FA', '', '', NULL),
103
           ('942', 'n', 'Suppress in OPAC', 'Suppress in OPAC', 0, 0, NULL, 9, '', '', '', 0, 5, 'FA', '', '', NULL),
104
             ('942', 's', 'Serial record flag', 'Serial record', 0, 0, 'biblio.serial', 9, '', '', '', NULL, 5, 'FA', '', '', NULL),
105
                ('952', '0', 'Withdrawn status', 'Withdrawn status', 0, 0, 'items.withdrawn', 10, 'WITHDRAWN', '', '', NULL, 0, 'FA', '', NULL, NULL),
106
         ('952', '1', 'Lost status', 'Lost status', 0, 0, 'items.itemlost', 10, 'LOST', '', '', NULL, 0, 'FA', '', NULL, NULL),
107
         ('952', '2', 'Source of classification or shelving scheme', 'Source of classification or shelving scheme', 0, 0, 'items.cn_source', 10, 'cn_source', '', '', NULL, 0, 'FA', '', NULL, NULL),
108
           ('952', '3', 'Materials specified (bound volume or other part)', 'Materials specified (bound volume or other part)', 0, 0, 'items.materials', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
109
          ('952', '4', 'Damaged status', 'Damaged status', 0, 0, 'items.damaged', 10, 'DAMAGED', '', '', NULL, 0, 'FA', '', NULL, NULL),
110
         ('952', '5', 'Use restrictions', 'Use restrictions', 0, 0, 'items.restricted', 10, 'RESTRICTED', '', '', NULL, 0, 'FA', '', NULL, NULL),
111
               ('952', '6', 'Koha normalized classification for sorting', 'Koha normalized classification for sorting', 0, 0, 'items.cn_sort', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
112
                ('952', '7', 'Not for loan', 'Not for loan', 0, 0, 'items.notforloan', 10, 'NOT_LOAN', '', '', NULL, 0, 'FA', '', NULL, NULL),
113
         ('952', '8', 'Collection code', 'Collection code', 0, 0, 'items.ccode', 10, 'CCODE', '', '', NULL, 0, 'FA', '', NULL, NULL),
114
           ('952', '9', 'Koha itemnumber (autogenerated)', 'Koha itemnumber', 0, 0, 'items.itemnumber', -1, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
115
           ('952', 'a', 'Permanent location', 'Permanent Location', 0, 0, 'items.homebranch', 10, 'branches', '', '', NULL, 0, 'FA', '', NULL, NULL),
116
             ('952', 'b', 'Current location', 'Current Location', 0, 0, 'items.holdingbranch', 10, 'branches', '', '', NULL, 0, 'FA', '', NULL, NULL),
117
              ('952', 'c', 'Shelving location', 'Shelving location', 0, 0, 'items.location', 10, 'LOC', '', '', NULL, 0, 'FA', '', NULL, NULL),
118
              ('952', 'd', 'Date acquired', 'Date acquired', 0, 0, 'items.dateaccessioned', 10, '', '', 'dateaccessioned.pl', NULL, 0, 'FA', '', NULL, NULL),
119
                ('952', 'e', 'Source of acquisition', 'Source of acquisition', 0, 0, 'items.booksellerid', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
120
             ('952', 'f', 'Coded location qualifier', 'Coded location qualifier', 0, 0, 'items.coded_location_qualifier', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
121
           ('952', 'g', 'Cost, normal purchase price', 'Cost, normal purchase price', 0, 0, 'items.price', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
122
                ('952', 'h', 'Serial Enumeration / chronology', 'Serial Enumeration / chronology', 0, 0, 'items.enumchron', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
123
            ('952', 'i', 'Inventory number', 'Inventory number', 0, 0, 'items.stocknumber', 10, '', '', '', 0, 0, 'FA', '', NULL, NULL),
124
           ('952', 'j', 'Shelving control number', 'Shelving control number', 0, 0, 'items.stack', 10, 'STACK', '', '', NULL, 0, 'FA', '', NULL, NULL),
125
           ('952', 'l', 'Total Checkouts', 'Total Checkouts', 0, 0, 'items.issues', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
126
               ('952', 'm', 'Total Renewals', 'Total Renewals', 0, 0, 'items.renewals', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
127
               ('952', 'n', 'Total Holds', 'Total Holds', 0, 0, 'items.reserves', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
128
             ('952', 'o', 'Full call number', 'Full call number', 0, 0, 'items.itemcallnumber', 10, '', '', NULL, NULL, 0, 'FA', '', NULL, NULL),
129
           ('952', 'p', 'Barcode', 'Barcode', 0, 0, 'items.barcode', 10, '', '', 'barcode.pl', NULL, 0, 'FA', '', NULL, NULL),
130
            ('952', 'q', 'Checked out', 'Checked out', 0, 0, 'items.onloan', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
131
               ('952', 'r', 'Date last seen', 'Date last seen', 0, 0, 'items.datelastseen', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
132
           ('952', 's', 'Date last checked out', 'Date last checked out', 0, 0, 'items.datelastborrowed', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
133
         ('952', 't', 'Copy number', 'Copy number', 0, 0, 'items.copynumber', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
134
           ('952', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 0, 0, 'items.uri', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
135
          ('952', 'v', 'Cost, replacement price', 'Cost, replacement price', 0, 0, 'items.replacementprice', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
136
             ('952', 'w', 'Price effective from', 'Price effective from', 0, 0, 'items.replacementpricedate', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
137
               ('952', 'x', 'Non-public note', 'Non-public note', 1, 0, 'items.paidfor', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
138
              ('952', 'y', 'Koha item type', 'Koha item type', 0, 0, 'items.itype', 10, 'itemtypes', '', '', NULL, 0, 'FA', '', NULL, NULL),
139
         ('952', 'z', 'Public note', 'Public note', 0, 0, 'items.itemnotes', 10, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
140
            ('999', 'c', 'Koha biblionumber', 'Koha biblionumber', 0, 0, 'biblio.biblionumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL),
141
         ('999', 'd', 'Koha biblioitemnumber', 'Koha biblioitemnumber', 0, 0, 'biblioitems.biblioitemnumber', -1, NULL, NULL, '', NULL, -5, 'FA', '', '', NULL);
142
- 

Return to bug 10963