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 / +85 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', '082', '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'),
8
10
             ('050', 'LIBRARY OF CONGRESS CALL NUMBER', 'LIBRARY OF CONGRESS CALL NUMBER', 1, 0, NULL, 'FA'),
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)
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'),
10
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, 0, authorised_value, authtypecode, value_builder, isurl, hidden, 'FA', seealso, link, defaultvalue
12
             ('099', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 'LOCAL FREE-TEXT CALL NUMBER (OCLC)', 1, 0, '', 'FA'),
11
FROM marc_subfield_structure
13
           ('100', 'MAIN ENTRY--PERSONAL NAME', 'MAIN ENTRY--PERSONAL NAME', 0, 0, NULL, 'FA'),
12
WHERE frameworkcode = '' AND
14
           ('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', 'FA'),
13
tagfield IN ('000', '008', '010', '020', '022', '050', '082', '090', '099', '100', '245', '250', '260', '300', '500', '942', '952', '999');
15
         ('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, 'FA'),
14
16
           ('260', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 'PUBLICATION, DISTRIBUTION, ETC. (IMPRINT)', 1, 0, NULL, 'FA'),
15
-- **************************************************
17
           ('300', 'PHYSICAL DESCRIPTION', 'PHYSICAL DESCRIPTION', 1, 0, NULL, 'FA'),
16
-- REVERT HIDDEN FIELD TO ORIGINAL (pre copy ) VALUES
18
             ('500', 'GENERAL NOTE', 'GENERAL NOTE', 1, 0, NULL, 'FA'),
17
-- **************************************************
19
             ('942', 'ADDED ENTRY ELEMENTS (KOHA)', 'ADDED ENTRY ELEMENTS (KOHA)', 0, 0, '', 'FA'),
18
20
         ('952', 'LOCATION AND ITEM INFORMATION (KOHA)', 'LOCATION AND ITEM INFORMATION (KOHA)', 1, 0, '', 'FA'),
19
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '010' AND tagsubfield = '8' AND frameworkcode = 'FA';
21
               ('999', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', '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 = 'z' AND frameworkcode = 'FA';
22
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '6' AND frameworkcode = 'FA';
23
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = '8' AND frameworkcode = 'FA';
24
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '020' AND tagsubfield = 'z' AND frameworkcode = 'FA';
25
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '6' AND frameworkcode = 'FA';
26
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '082' AND tagsubfield = '8' AND frameworkcode = 'FA';
27
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'a' AND frameworkcode = 'FA';
28
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '090' AND tagsubfield = 'b' AND frameworkcode = 'FA';
29
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '6' AND frameworkcode = 'FA';
30
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '8' AND frameworkcode = 'FA';
31
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = '9' AND frameworkcode = 'FA';
32
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'b' AND frameworkcode = 'FA';
33
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'c' AND frameworkcode = 'FA';
34
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'f' AND frameworkcode = 'FA';
35
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'g' AND frameworkcode = 'FA';
36
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'j' AND frameworkcode = 'FA';
37
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'k' AND frameworkcode = 'FA';
38
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'l' AND frameworkcode = 'FA';
39
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'n' AND frameworkcode = 'FA';
40
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'p' AND frameworkcode = 'FA';
41
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 't' AND frameworkcode = 'FA';
42
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '100' AND tagsubfield = 'u' AND frameworkcode = 'FA';
43
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '6' AND frameworkcode = 'FA';
44
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = '8' AND frameworkcode = 'FA';
45
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'd' AND frameworkcode = 'FA';
46
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'e' AND frameworkcode = 'FA';
47
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'f' AND frameworkcode = 'FA';
48
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'g' AND frameworkcode = 'FA';
49
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'k' AND frameworkcode = 'FA';
50
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'n' AND frameworkcode = 'FA';
51
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 'p' AND frameworkcode = 'FA';
52
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '245' AND tagsubfield = 's' AND frameworkcode = 'FA';
53
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '6' AND frameworkcode = 'FA';
54
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '250' AND tagsubfield = '8' AND frameworkcode = 'FA';
55
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '6' AND frameworkcode = 'FA';
56
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = '8' AND frameworkcode = 'FA';
57
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'd' AND frameworkcode = 'FA';
58
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'e' AND frameworkcode = 'FA';
59
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'f' AND frameworkcode = 'FA';
60
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'g' AND frameworkcode = 'FA';
61
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'k' AND frameworkcode = 'FA';
62
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '260' AND tagsubfield = 'l' AND frameworkcode = 'FA';
63
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '3' AND frameworkcode = 'FA';
64
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '5' AND frameworkcode = 'FA';
65
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '6' AND frameworkcode = 'FA';
66
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = '8' AND frameworkcode = 'FA';
67
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'l' AND frameworkcode = 'FA';
68
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'n' AND frameworkcode = 'FA';
69
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'x' AND frameworkcode = 'FA';
70
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '500' AND tagsubfield = 'z' AND frameworkcode = 'FA';
71
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = '0' AND frameworkcode = 'FA';
72
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'c' AND frameworkcode = 'FA';
73
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 'n' AND frameworkcode = 'FA';
74
UPDATE marc_subfield_structure SET hidden ='5' WHERE tagfield = '942' AND tagsubfield = 's' AND frameworkcode = 'FA';
75
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '1' AND frameworkcode = 'FA';
76
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '3' AND frameworkcode = 'FA';
77
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '6' AND frameworkcode = 'FA';
78
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = '9' AND frameworkcode = 'FA';
79
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'j' AND frameworkcode = 'FA';
80
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'l' AND frameworkcode = 'FA';
81
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'm' AND frameworkcode = 'FA';
82
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'n' AND frameworkcode = 'FA';
83
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'q' AND frameworkcode = 'FA';
84
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'r' AND frameworkcode = 'FA';
85
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 's' AND frameworkcode = 'FA';
86
UPDATE marc_subfield_structure SET hidden ='0' WHERE tagfield = '952' AND tagsubfield = 'x' AND frameworkcode = 'FA';
22
87
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
24
              ('000', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_leader.pl', NULL, 0, 'FA', '', NULL, NULL),
25
              ('008', '@', 'fixed length control field', 'fixed length control field', 0, 1, '', 0, '', '', 'marc21_field_008.pl', NULL, 0, 'FA', '', NULL, NULL),
26
           ('010', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
27
           ('010', 'a', 'LC control number', 'LC control number', 0, 0, 'biblioitems.lccn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
28
             ('010', 'b', 'NUCMC control number', 'NUCMC control number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
29
               ('010', 'z', 'Canceled/invalid LC control number', 'Canceled/invalid LC control number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
30
           ('020', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
31
         ('020', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
32
           ('020', 'a', 'International Standard Book Number', 'International Standard Book Number', 0, 0, 'biblioitems.isbn', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
33
           ('020', 'c', 'Terms of availability', 'Terms of availability', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
34
             ('020', 'z', 'Canceled/invalid ISBN', 'Canceled/invalid ISBN', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
35
             ('050', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL),
36
             ('050', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', 0, 0, 'FA', '', '', NULL),
37
         ('082', '2', 'Edition number', 'Edition number', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
38
              ('082', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
39
            ('082', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
40
              ('082', 'a', 'Classification number', 'Classification number', 1, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
41
                ('082', 'b', 'Item number', 'Item number', 0, 0, '', 0, '', '', '', NULL, 0, 'FA', '', NULL, NULL),
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),
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),
44
         ('100', '4', 'Relator code', 'Relator code', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
45
               ('100', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
46
         ('100', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
47
           ('100', '9', '9 (RLIN)', '9 (RLIN)', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
48
               ('100', 'a', 'Personal name', 'Personal name', 0, 0, 'biblio.author', 0, '', 'PERSO_NAME', '', 0, 0, 'FA', NULL, '', ''),
49
          ('100', 'b', 'Numeration', 'Numeration', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
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, '', ''),
51
             ('100', 'd', 'Dates associated with a name', 'Dates associated with a name', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
52
               ('100', 'e', 'Relator term', 'Relator term', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
53
               ('100', 'f', 'Date of a work', 'Date of a work', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
54
           ('100', 'g', 'Miscellaneous information', 'Miscellaneous information', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
55
             ('100', 'j', 'Attribution qualifier', 'Attribution qualifier', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
56
             ('100', 'k', 'Form subheading', 'Form subheading', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
57
         ('100', 'l', 'Language of a work', 'Language of a work', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
58
           ('100', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
59
               ('100', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
60
           ('100', 'q', 'Fuller form of name', 'Fuller form of name', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
61
         ('100', 't', 'Title of a work', 'Title of a work', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
62
         ('100', 'u', 'Affiliation', 'Affiliation', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
63
         ('245', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
64
         ('245', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
65
           ('245', 'a', 'Title', 'Title', 0, 1, 'biblio.title', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
66
         ('245', 'b', 'Remainder of title', 'Remainder of title', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
67
           ('245', 'c', 'Statement of responsibility, etc.', 'Statement of responsibility, etc.', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
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, '', ''),
69
          ('245', 'e', 'Name of part/section/series (SE) [OBSOLETE]', 'Name of part/section/series (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
70
         ('245', 'f', 'Inclusive dates', 'Inclusive dates', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
71
         ('245', 'g', 'Bulk dates', 'Bulk dates', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
72
           ('245', 'h', 'Medium', 'Medium', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
73
           ('245', 'k', 'Form', 'Form', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
74
               ('245', 'n', 'Number of part/section of a work', 'Number of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
75
               ('245', 'p', 'Name of part/section of a work', 'Name of part/section of a work', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
76
           ('245', 's', 'Version', 'Version', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
77
         ('250', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
78
         ('250', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
79
           ('250', 'a', 'Edition statement', 'Edition statement', 0, 0, 'biblioitems.editionstatement', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
80
         ('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
81
           ('260', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
82
         ('260', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
83
           ('260', 'a', 'Place of publication, distribution, etc.', 'Place of publication, distribution, etc.', 1, 0, 'biblioitems.place', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
84
              ('260', 'b', 'Name of publisher, distributor, etc.', 'Name of publisher, distributor, etc.', 1, 0, 'biblioitems.publishercode', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
85
              ('260', 'c', 'Date of publication, distribution, etc.', 'Date of publication, distribution, etc.', 1, 0, 'biblio.copyrightdate', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
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, '', ''),
87
           ('260', 'e', 'Place of manufacture', 'Place of manufacture', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
88
               ('260', 'f', 'Manufacturer', 'Manufacturer', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
89
               ('260', 'g', 'Date of manufacture', 'Date of manufacture', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
90
         ('260', 'k', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 'Identification/manufacturer number [OBSOLETE, CAN/MARC]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
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, '', ''),
92
           ('500', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
93
         ('500', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
94
           ('500', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
95
         ('500', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
96
           ('500', 'a', 'General note', 'General note', 0, 0, 'biblio.notes', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
97
           ('500', 'l', 'Library of Congress call number (SE) [OBSOLETE]', 'Library of Congress call number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
98
         ('500', 'n', 'n (RLIN) [OBSOLETE]', 'n (RLIN) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
99
         ('500', 'x', 'International Standard Serial Number (SE) [OBSOLETE]', 'International Standard Serial Number (SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
100
               ('500', 'z', 'Source of note information (AM SE) [OBSOLETE]', 'Source of note information (AM SE) [OBSOLETE]', 0, 0, '', 0, '', '', '', 0, 0, 'FA', NULL, '', ''),
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.itemnotes_nonpublic', 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