Lines 7-13
Link Here
|
7 |
-- guided by Paul POULAIN |
7 |
-- guided by Paul POULAIN |
8 |
-- by thd for LibLime |
8 |
-- by thd for LibLime |
9 |
-- |
9 |
-- |
10 |
-- Revised to Update No. 26 (April 2018) |
10 |
-- Revised to Update No. 27 (November 2018) |
11 |
-- ************************************************************* |
11 |
-- ************************************************************* |
12 |
|
12 |
|
13 |
|
13 |
|
Lines 255-260
INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
Link Here
|
255 |
('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL, ''), |
255 |
('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL, ''), |
256 |
('247', 'FORMER TITLE', 'FORMER TITLE', 1, 0, NULL, ''), |
256 |
('247', 'FORMER TITLE', 'FORMER TITLE', 1, 0, NULL, ''), |
257 |
('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 1, 0, NULL, ''), |
257 |
('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 1, 0, NULL, ''), |
|
|
258 |
('251', 'VERSION INFORMATION', 'VERSION INFORMATION', 1, 0, NULL, ''), |
258 |
('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''), |
259 |
('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''), |
259 |
('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''), |
260 |
('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''), |
260 |
('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''), |
261 |
('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''), |
Lines 283-288
INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
Link Here
|
283 |
('337', 'MEDIA TYPE', 'MEDIA TYPE', 1, 0, NULL, ''), |
284 |
('337', 'MEDIA TYPE', 'MEDIA TYPE', 1, 0, NULL, ''), |
284 |
('338', 'CARRIER TYPE', 'CARRIER TYPE', 1, 0, NULL, ''), |
285 |
('338', 'CARRIER TYPE', 'CARRIER TYPE', 1, 0, NULL, ''), |
285 |
('340', 'PHYSICAL MEDIUM', 'PHYSICAL MEDIUM', 1, 0, NULL, ''), |
286 |
('340', 'PHYSICAL MEDIUM', 'PHYSICAL MEDIUM', 1, 0, NULL, ''), |
|
|
287 |
('341', 'ACCESSIBILITY CONTENT', 'ACCESSIBILITY CONTENT', 1, 0, NULL, ''), |
286 |
('342', 'GEOSPATIAL REFERENCE DATA', 'GEOSPATIAL REFERENCE DATA', 1, 0, NULL, ''), |
288 |
('342', 'GEOSPATIAL REFERENCE DATA', 'GEOSPATIAL REFERENCE DATA', 1, 0, NULL, ''), |
287 |
('343', 'PLANAR COORDINATE DATA', 'PLANAR COORDINATE DATA', 1, 0, NULL, ''), |
289 |
('343', 'PLANAR COORDINATE DATA', 'PLANAR COORDINATE DATA', 1, 0, NULL, ''), |
288 |
('344', 'SOUND CHARACTERISTICS', 'SOUND CHARACTERISTICS', 1, 0, NULL, ''), |
290 |
('344', 'SOUND CHARACTERISTICS', 'SOUND CHARACTERISTICS', 1, 0, NULL, ''), |
Lines 343-348
INSERT IGNORE INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`,
Link Here
|
343 |
('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 1, 0, NULL, ''), |
345 |
('526', 'STUDY PROGRAM INFORMATION NOTE', 'STUDY PROGRAM INFORMATION NOTE', 1, 0, NULL, ''), |
344 |
('527', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 1, 0, NULL, ''), |
346 |
('527', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 'CENSORSHIP NOTE (VM) [OBSOLETE]', 1, 0, NULL, ''), |
345 |
('530', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 1, 0, NULL, ''), |
347 |
('530', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 'ADDITIONAL PHYSICAL FORM AVAILABLE NOTE', 1, 0, NULL, ''), |
|
|
348 |
('532', 'ACCESSIBILITY NOTE', 'ACCESSIBILITY NOTE', 1, 0, NULL, ''), |
346 |
('533', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, ''), |
349 |
('533', 'REPRODUCTION NOTE', 'REPRODUCTION NOTE', 1, 0, NULL, ''), |
347 |
('534', 'ORIGINAL VERSION NOTE', 'ORIGINAL VERSION NOTE', 1, 0, NULL, ''), |
350 |
('534', 'ORIGINAL VERSION NOTE', 'ORIGINAL VERSION NOTE', 1, 0, NULL, ''), |
348 |
('535', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 1, 0, NULL, ''), |
351 |
('535', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 'LOCATION OF ORIGINALS/DUPLICATES NOTE', 1, 0, NULL, ''), |
Lines 713-722
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
Link Here
|
713 |
('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
716 |
('041', 'f', 'Language code of table of contents', 'Language code of table of contents', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
714 |
('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
717 |
('041', 'g', 'Language code of accompanying material other than librettos', 'Language code of accompanying material other than librettos', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
715 |
('041', 'h', 'Language code of original', 'Language code of original', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
718 |
('041', 'h', 'Language code of original', 'Language code of original', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
716 |
('041', 'j', 'Language code of subtitles or captions', 'Language code of subtitles or captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
719 |
('041', 'j', 'Language code of subtitles', 'Language code of subtitles', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
717 |
('041', 'k', 'Language code of intermediate translations', 'Language code of intermediate translations', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
720 |
('041', 'k', 'Language code of intermediate translations', 'Language code of intermediate translations', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
718 |
('041', 'm', 'Language code of original accompanying materials other than librettos', 'Language code of original accompanying materials other than librettos', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
721 |
('041', 'm', 'Language code of original accompanying materials other than librettos', 'Language code of original accompanying materials other than librettos', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
719 |
('041', 'n', 'Language code of original libretto', 'Language code of original libretto', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
722 |
('041', 'n', 'Language code of original libretto', 'Language code of original libretto', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
|
|
723 |
('041', 'p', 'Language code of captions', 'Language code of captions', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
724 |
('041', 'q', 'Language code of accessible audio', 'Language code of accessible audio', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
725 |
('041', 'r', 'Language code of accessible visual language', 'Language code of accessible visual language', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
720 |
('042', 'a', 'Authentication code', 'Authentication code', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
726 |
('042', 'a', 'Authentication code', 'Authentication code', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
721 |
('043', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
727 |
('043', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
722 |
('043', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
728 |
('043', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 0, '', '', '', NULL, -6, '', '', '', NULL), |
Lines 1107-1112
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
Link Here
|
1107 |
('250', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1113 |
('250', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1108 |
('250', 'a', 'Edition statement', 'Edition statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', NULL, 0, '', '', '', NULL), |
1114 |
('250', 'a', 'Edition statement', 'Edition statement', 0, 0, 'biblioitems.editionstatement', 2, '', '', '', NULL, 0, '', '', '', NULL), |
1109 |
('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), |
1115 |
('250', 'b', 'Remainder of edition statement', 'Remainder of edition statement', 0, 0, '', 2, '', '', '', NULL, 0, '', '', '', NULL), |
|
|
1116 |
('251', '0', 'Authority record control number or standard number', 'Authority record control number or standard number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1117 |
('251', '1', 'Real World Object URI', 'Real World Object URI', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1118 |
('251', '2', 'Source', 'Source', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1119 |
('251', '3', 'Materials specified', 'Materials specified', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1120 |
('251', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1121 |
('251', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1122 |
('251', 'a', 'Version', 'Version', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1110 |
('254', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1123 |
('254', '6', 'Linkage', 'Linkage', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1111 |
('254', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1124 |
('254', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1112 |
('254', 'a', 'Musical presentation statement', 'Musical presentation statement', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
1125 |
('254', 'a', 'Musical presentation statement', 'Musical presentation statement', 0, 0, '', 2, '', '', '', NULL, -6, '', '', '', NULL), |
Lines 1292-1297
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
Link Here
|
1292 |
('340', 'm', 'Book format', 'Book format', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1305 |
('340', 'm', 'Book format', 'Book format', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1293 |
('340', 'n', 'Font size', 'Font size', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1306 |
('340', 'n', 'Font size', 'Font size', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1294 |
('340', 'o', 'Polarity', 'Polarity', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1307 |
('340', 'o', 'Polarity', 'Polarity', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
|
|
1308 |
('341', '2', 'Source', 'Source', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1309 |
('341', '3', 'Materials specified', 'Materials specified', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1310 |
('341', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1311 |
('341', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1312 |
('341', 'a', 'Content access mode', 'Content access mode', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1313 |
('341', 'b', 'Textual assistive features', 'Textual assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1314 |
('341', 'c', 'Visual assistive features', 'Visual assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1315 |
('341', 'd', 'Auditory assistive features', 'Auditory assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1316 |
('341', 'e', 'Tactile assistive features', 'Tactile assistive features', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1295 |
('342', '2', 'Reference method used', 'Reference method used', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1317 |
('342', '2', 'Reference method used', 'Reference method used', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1296 |
('342', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1318 |
('342', '6', 'Linkage', 'Linkage', 0, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1297 |
('342', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
1319 |
('342', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 3, '', '', '', NULL, -6, '', '', '', NULL), |
Lines 1798-1803
INSERT IGNORE INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblib
Link Here
|
1798 |
('530', 'd', 'Order number', 'Order number', 0, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL), |
1820 |
('530', 'd', 'Order number', 'Order number', 0, 0, NULL, 5, NULL, NULL, '', NULL, -1, '', '', '', NULL), |
1799 |
('530', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, 5, NULL, NULL, '', 1, -1, '', '', '', NULL), |
1821 |
('530', 'u', 'Uniform Resource Identifier', 'Uniform Resource Identifier', 1, 0, NULL, 5, NULL, NULL, '', 1, -1, '', '', '', NULL), |
1800 |
('530', 'z', 'Source of note information (AM CF VM SE) [OBSOLETE]', 'Source of note information (AM CF VM SE) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), |
1822 |
('530', 'z', 'Source of note information (AM CF VM SE) [OBSOLETE]', 'Source of note information (AM CF VM SE) [OBSOLETE]', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), |
|
|
1823 |
('532', '6', 'Linkage', 'Linkage', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), |
1824 |
('532', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), |
1825 |
('532', 'a', 'Summary of accessibility', 'Summary of accessibility', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), |
1801 |
('533', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), |
1826 |
('533', '3', 'Materials specified', 'Materials specified', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), |
1802 |
('533', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), |
1827 |
('533', '5', 'Institution to which field applies', 'Institution to which field applies', 0, 0, '', 5, '', '', '', NULL, -6, '', '', '', NULL), |
1803 |
('533', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), |
1828 |
('533', '6', 'Linkage', 'Linkage', 0, 0, NULL, 5, NULL, NULL, '', NULL, -6, '', '', '', NULL), |
1804 |
- |
|
|