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

(-)a/installer/data/mysql/en/marcflavour/unimarc/mandatory/unimarc_framework_DEFAULT.sql (-1 / +37 lines)
Lines 235-243 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here
235
		('015', 'International Standard Technical Report Number (ISRN)', 'International Standard Technical Report Number (ISRN)', 1, 0, '', ''),
235
		('015', 'International Standard Technical Report Number (ISRN)', 'International Standard Technical Report Number (ISRN)', 1, 0, '', ''),
236
		('016', 'International Standard Recording Code (ISRC)', 'International Standard Recording Code (ISRC)', 1, 0, '', ''),
236
		('016', 'International Standard Recording Code (ISRC)', 'International Standard Recording Code (ISRC)', 1, 0, '', ''),
237
		('017', 'Other Standard Identifier', 'Other Standard Identifier', 1, 0, '', ''),
237
		('017', 'Other Standard Identifier', 'Other Standard Identifier', 1, 0, '', ''),
238
		('018', '[Reserved for other International Standard Numbers]', '[Reserved for other International Standard Numbers]', 1, 0, '', ''),
238
		('020', 'National Bibliography Number', 'National Bibliography Number', 1, 0, '', ''),
239
		('020', 'National Bibliography Number', 'National Bibliography Number', 1, 0, '', ''),
239
		('021', 'Legal Deposit Number', 'Legal Deposit Number', 1, 0, '', ''),
240
		('021', 'Legal Deposit Number', 'Legal Deposit Number', 1, 0, '', ''),
240
		('022', 'Government Publication Number', 'Government Publication Number', 1, 0, '', ''),
241
		('022', 'Government Publication Number', 'Government Publication Number', 1, 0, '', ''),
242
		('033', 'Other system persistent record identifier', 'Other system persistent record identifier', 1, 0, '', ''),
241
		('035', 'Other System Control Numbers', 'Other System Control Numbers', 1, 0, '', ''),
243
		('035', 'Other System Control Numbers', 'Other System Control Numbers', 1, 0, '', ''),
242
		('036', 'Music Incipit', 'Music Incipit', 1, 0, '', ''),
244
		('036', 'Music Incipit', 'Music Incipit', 1, 0, '', ''),
243
		('040', 'CODEN (Serials)', 'CODEN (Serials)', 1, 0, '', ''),
245
		('040', 'CODEN (Serials)', 'CODEN (Serials)', 1, 0, '', ''),
Lines 271-277 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here
271
		('146', 'Coded Data Field: Medium of Performance', 'Coded Data Field: Medium of Performance', 1, 0, '', ''),
273
		('146', 'Coded Data Field: Medium of Performance', 'Coded Data Field: Medium of Performance', 1, 0, '', ''),
272
		('181', 'Coded Data Field: content form', '', 1, 0, '', ''),
274
		('181', 'Coded Data Field: content form', '', 1, 0, '', ''),
273
		('182', 'Coded Data Field: media type', '', 1, 0, '', ''),
275
		('182', 'Coded Data Field: media type', '', 1, 0, '', ''),
276
		('183', 'Coded Data Field: Type of Carrier', 'Coded Data Field: Type of Carrier', 1, 0, '', ''),
274
		('200', 'Title and Statement of Responsibility', 'Title and Statement of Responsibility', 0, 1, '', ''),
277
		('200', 'Title and Statement of Responsibility', 'Title and Statement of Responsibility', 0, 1, '', ''),
278
		('203', 'Coded Data Field: Content Form', 'Coded Data Field: Content Form', 1, 0, '', ''),
275
		('204', 'General Material Designation [Obsolete]', 'General Material Designation [Obsolete]', 1, 0, '', ''),
279
		('204', 'General Material Designation [Obsolete]', 'General Material Designation [Obsolete]', 1, 0, '', ''),
276
		('205', 'Edition Statement', 'Edition Statement', 1, 0, '', ''),
280
		('205', 'Edition Statement', 'Edition Statement', 1, 0, '', ''),
277
		('206', 'Material Specific Area: Cartographic Resources - Mathematical Data', 'Material Specific Area: Cartographic Resources - Mathematical Data', 1, 0, '', ''),
281
		('206', 'Material Specific Area: Cartographic Resources - Mathematical Data', 'Material Specific Area: Cartographic Resources - Mathematical Data', 1, 0, '', ''),
Lines 283-289 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here
283
		('215', 'Physical Description', 'Physical Description', 1, 0, '', ''),
287
		('215', 'Physical Description', 'Physical Description', 1, 0, '', ''),
284
		('225', 'Series', 'Series', 1, 0, '', ''),
288
		('225', 'Series', 'Series', 1, 0, '', ''),
285
		('230', 'Material Specific Area: Electronic Resource Characteristics', 'Material Specific Area: Electronic Resource Characteristics', 1, 0, '', ''),
289
		('230', 'Material Specific Area: Electronic Resource Characteristics', 'Material Specific Area: Electronic Resource Characteristics', 1, 0, '', ''),
290
		('231', 'Digital File Characteristics', 'Digital File Characteristics', 1, 0, '', ''),
286
		('251', 'Organization and Arrangement of Materials', 'Organization and Arrangement of Materials', 1, 0, '', ''),
291
		('251', 'Organization and Arrangement of Materials', 'Organization and Arrangement of Materials', 1, 0, '', ''),
292
		('283', 'Carrier Type', 'Carrier Type', 1, 0, '', ''),
287
		('300', 'General Notes', 'General Notes', 1, 0, '', ''),
293
		('300', 'General Notes', 'General Notes', 1, 0, '', ''),
288
		('301', 'Notes Pertaining to Identification Numbers', 'Notes Pertaining to Identification Numbers', 1, 0, '', ''),
294
		('301', 'Notes Pertaining to Identification Numbers', 'Notes Pertaining to Identification Numbers', 1, 0, '', ''),
289
		('302', 'Notes Pertaining to Coded Information', 'Notes Pertaining to Coded Information', 1, 0, '', ''),
295
		('302', 'Notes Pertaining to Coded Information', 'Notes Pertaining to Coded Information', 1, 0, '', ''),
Lines 318-323 INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat Link Here
318
		('335', 'Location of Originals/ Reproductions', 'Location of Originals/ Reproductions', 1, 0, '', ''),
324
		('335', 'Location of Originals/ Reproductions', 'Location of Originals/ Reproductions', 1, 0, '', ''),
319
		('336', 'Type of Electronic Resource Note', 'Type of Electronic Resource Note', 1, 0, '', ''),
325
		('336', 'Type of Electronic Resource Note', 'Type of Electronic Resource Note', 1, 0, '', ''),
320
		('337', 'System Requirements Note (Electronic Resources)', 'System Requirements Note (Electronic Resources)', 1, 0, '', ''),
326
		('337', 'System Requirements Note (Electronic Resources)', 'System Requirements Note (Electronic Resources)', 1, 0, '', ''),
327
		('338', 'Funding Information Note', 'Funding Information Note', 1, 0, '', ''),
321
		('345', 'Acquisition Information Note', 'Acquisition Information Note', 0, 0, '', ''),
328
		('345', 'Acquisition Information Note', 'Acquisition Information Note', 0, 0, '', ''),
322
		('371', 'Notes on Information Service Policy', 'Notes on Information Service Policy', 1, 0, '', ''),
329
		('371', 'Notes on Information Service Policy', 'Notes on Information Service Policy', 1, 0, '', ''),
323
		('410', 'Series', 'Series', 0, 0, '', ''),
330
		('410', 'Series', 'Series', 0, 0, '', ''),
Lines 484-489 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
484
		('022', 'a', 'Country Code', 'Country Code', 0, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL),
491
		('022', 'a', 'Country Code', 'Country Code', 0, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL),
485
		('022', 'b', 'Number', 'Number', 0, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL),
492
		('022', 'b', 'Number', 'Number', 0, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL),
486
		('022', 'z', 'Erroneous Number', 'Erroneous Number', 1, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL),
493
		('022', 'z', 'Erroneous Number', 'Erroneous Number', 1, 0, '', 0, '', '', '', 0, -5, '', '', '', NULL),
494
		('033', 'a', 'Persistent Record Identifier', 'Persistent Record Identifier', 0, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
495
		('033', 'z', 'Cancelled or Invalid Persistent Record Identifier', 'Cancelled or Invalid Persistent Record Identifier', 1, 0, '', 0, '', '', '', 0, 0, '', '', '', NULL),
487
		('035', 'a', 'System Control Number', 'System Control Number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
496
		('035', 'a', 'System Control Number', 'System Control Number', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
488
		('035', 'z', 'Cancelled or Invalid Control Number', 'Cancelled or Invalid Control Number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
497
		('035', 'z', 'Cancelled or Invalid Control Number', 'Cancelled or Invalid Control Number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
489
		('036', '2', 'System Code for Musical Notation', 'System Code for Musical Notation', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
498
		('036', '2', 'System Code for Musical Notation', 'System Code for Musical Notation', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL),
Lines 621-626 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
621
		('182', '6', 'Interfield Linking Data', '', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', ''),
630
		('182', '6', 'Interfield Linking Data', '', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', ''),
622
		('182', 'a', 'ISBD Media Type Code', '', 0, 0, '', 1, 'unimarc_182a', '', '', 0, 0, '', '', '', ''),
631
		('182', 'a', 'ISBD Media Type Code', '', 0, 0, '', 1, 'unimarc_182a', '', '', 0, 0, '', '', '', ''),
623
		('182', 'c', 'Other Coding for Media Type', '', 1, 0, '', 1, 'unimarc_182c', '', '', 0, 0, '', '', '', ''),
632
		('182', 'c', 'Other Coding for Media Type', '', 1, 0, '', 1, 'unimarc_182c', '', '', 0, 0, '', '', '', ''),
633
		('183', 'a', 'Type of Carrier Code', 'Type of Carrier Code', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
634
		('183', '2', 'System code', 'System code', 0, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
635
		('183', '6', 'Interfield Linking Data', 'Interfield Linking Data', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
636
		('183', '8', 'Materials specified', 'Materials specified', 1, 0, '', 1, '', '', '', 0, 0, '', '', '', NULL),
624
		('200', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
637
		('200', '5', 'Institution to Which the Field Applies', 'Institution to Which the Field Applies', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
625
		('200', 'a', 'Title Proper', 'Title Proper', 1, 0, 'biblio.title', 2, '', '', '', 0, 0, '', '', '', NULL),
638
		('200', 'a', 'Title Proper', 'Title Proper', 1, 0, 'biblio.title', 2, '', '', '', 0, 0, '', '', '', NULL),
626
		('200', 'b', 'General Material Designation', 'General Material Designation', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
639
		('200', 'b', 'General Material Designation', 'General Material Designation', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
Lines 636-641 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
636
		('200', 'r', 'Title Page Information Following the Title Proper', 'Title Page Information Following the Title Proper', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
649
		('200', 'r', 'Title Page Information Following the Title Proper', 'Title Page Information Following the Title Proper', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
637
		('200', 'v', 'Volume Designation', 'Volume Designation', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
650
		('200', 'v', 'Volume Designation', 'Volume Designation', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
638
		('200', 'z', 'Language of Parallel Title Proper', 'Language of Parallel Title Proper', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
651
		('200', 'z', 'Language of Parallel Title Proper', 'Language of Parallel Title Proper', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
652
		('203', 'a', 'Content form', 'Content form', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
653
		('203', 'b', 'Content qualification', 'Content qualification', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
654
		('203', 'c', 'Media type', 'Media type', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
639
		('204', 'a', 'GMD', 'GMD', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
655
		('204', 'a', 'GMD', 'GMD', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
640
		('205', 'a', 'Edition Statement', 'Edition Statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', 0, 0, '', '', '', NULL),
656
		('205', 'a', 'Edition Statement', 'Edition Statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', 0, 0, '', '', '', NULL),
641
		('205', 'b', 'Issue Statement', 'Issue Statement', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
657
		('205', 'b', 'Issue Statement', 'Issue Statement', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
Lines 684-692 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
684
		('225', 'x', 'ISSN of Series', 'ISSN of Series', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
700
		('225', 'x', 'ISSN of Series', 'ISSN of Series', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
685
		('225', 'z', 'Language of Parallel Title', 'Language of Parallel Title', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
701
		('225', 'z', 'Language of Parallel Title', 'Language of Parallel Title', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
686
		('230', 'a', 'Designation and Extent of File', 'Designation and Extent of File', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
702
		('230', 'a', 'Designation and Extent of File', 'Designation and Extent of File', 0, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
703
		('231', 'a', 'File type', 'File type', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
704
		('231', 'b', 'Encoding standard', 'Encoding standard', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
705
		('231', 'c', 'Version of encoding standard', 'Version of encoding standard', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
706
		('231', 'd', 'Details of encoding standard', 'Details of encoding standard', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
707
		('231', 'e', 'File size', 'File size', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
708
		('231', 'f', 'Resolution', 'Resolution', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
709
		('231', 'g', 'Regional encoding', 'Regional encoding', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
710
		('231', 'h', 'Encoded bitrate', 'Encoded bitrate', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
711
		('231', '2', 'Source', 'Source', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
712
		('231', '6', 'Interfield linking data', 'Interfield linking data', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
687
		('251', 'a', 'Organization', 'Organization', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
713
		('251', 'a', 'Organization', 'Organization', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
688
		('251', 'b', 'Arrangement', 'Arrangement', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
714
		('251', 'b', 'Arrangement', 'Arrangement', 1, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
689
		('251', 'c', 'Level', 'Level', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
715
		('251', 'c', 'Level', 'Level', 0, 0, '', 2, '', '', '', 0, -6, '', '', '', NULL),
716
		('283', 'a', 'Carrier Type Designation', 'Carrier Type Designation', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
717
		('283', '2', 'System code', 'System code', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
718
		('283', '6', 'Interfield Linking Data', 'Interfield Linking Data', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
719
		('283', '8', 'Materials specified', 'Materials specified', 1, 0, '', 2, '', '', '', 0, 0, '', '', '', NULL),
690
		('300', 'a', 'Text of Note', 'Text of Note', 0, 0, 'biblio.notes', 3, '', '', '', 0, 0, '', '', '', NULL),
720
		('300', 'a', 'Text of Note', 'Text of Note', 0, 0, 'biblio.notes', 3, '', '', '', 0, 0, '', '', '', NULL),
691
		('301', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
721
		('301', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
692
		('302', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
722
		('302', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
Lines 790-795 INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian` Link Here
790
		('336', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
820
		('336', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
791
		('337', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
821
		('337', 'a', 'Text of Note', 'Text of Note', 0, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
792
		('337', 'u', 'Uniform Resource Identifier (Uri)', 'Uniform Resource Identifier (Uri)', 1, 0, '', 3, '', '', '', 0, -6, '', '', '', NULL),
822
		('337', 'u', 'Uniform Resource Identifier (Uri)', 'Uniform Resource Identifier (Uri)', 1, 0, '', 3, '', '', '', 0, -6, '', '', '', NULL),
823
		('338', 'a', 'Text of Unstructured Note', 'Text of Unstructured Note', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
824
		('338', 'b', 'Funding Organization', 'Funding Organization', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
825
		('338', 'c', 'Program', 'Program', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
826
		('338', 'd', 'Project Number', 'Project Number', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
827
		('338', 'e', 'Jurisdiction', 'Jurisdiction', 1, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
828
		('338', 'f', 'Project Name', 'Project Name', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
829
		('338', 'g', 'Project Acronym', 'Project Acronym', 0, 0, '', 3, '', '', '', 0, 0, '', '', '', NULL),
793
		('345', 'a', 'Source for Acquisition/Subscription Address', 'Source for Acquisition/Subscription Address', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
830
		('345', 'a', 'Source for Acquisition/Subscription Address', 'Source for Acquisition/Subscription Address', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
794
		('345', 'b', 'Stock Number', 'Stock Number', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
831
		('345', 'b', 'Stock Number', 'Stock Number', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
795
		('345', 'c', 'Medium', 'Medium', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
832
		('345', 'c', 'Medium', 'Medium', 1, 0, '', 3, '', '', '', 0, -5, '', '', '', NULL),
796
- 

Return to bug 18309