Lines 1-29
Link Here
|
1 |
-- ************************************************************* |
1 |
-- ************************************************************* |
2 |
-- KOHA 3.0 MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK |
|
|
3 |
-- |
4 |
-- PRETEST VERSION 0.1.7 |
5 |
-- 2007-11-05 |
6 |
-- |
7 |
-- edited |
8 |
-- by thd |
9 |
-- |
10 |
-- BASED UPON |
11 |
-- |
12 |
-- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK |
2 |
-- KOHA MARC 21 STANDARD DEFAULT BIBLIOGRAPHIC FRAMEWORK |
13 |
-- |
3 |
-- |
14 |
-- PRETEST VERSION 0.2.8 |
|
|
15 |
-- 2007-11-05 |
16 |
-- |
4 |
-- |
17 |
-- original default requiring greater user customisation |
5 |
-- original default requiring greater user customisation |
18 |
-- created by a few Koha Hands |
6 |
-- created by a few Koha Hands |
19 |
-- guided by Paul POULAIN |
7 |
-- guided by Paul POULAIN |
20 |
-- |
|
|
21 |
-- revised and greatly enlarged to completion, |
22 |
-- well not quite complete yet today |
23 |
-- but close enough for someone to have use, |
24 |
-- by thd for LibLime |
8 |
-- by thd for LibLime |
25 |
-- |
9 |
-- |
26 |
-- Revised to Update No. 15 (September 2012) |
10 |
-- Revised to Update No. 16 (April 2013) |
27 |
-- ************************************************************* |
11 |
-- ************************************************************* |
28 |
|
12 |
|
29 |
|
13 |
|
Lines 272-278
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat
Link Here
|
272 |
('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', ''), |
256 |
('245', 'TITLE STATEMENT', 'TITLE STATEMENT', 0, 1, '', ''), |
273 |
('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL, ''), |
257 |
('246', 'VARYING FORM OF TITLE', 'VARYING FORM OF TITLE', 1, 0, NULL, ''), |
274 |
('247', 'FORMER TITLE', 'FORMER TITLE', 1, 0, NULL, ''), |
258 |
('247', 'FORMER TITLE', 'FORMER TITLE', 1, 0, NULL, ''), |
275 |
('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 0, 0, NULL, ''), |
259 |
('250', 'EDITION STATEMENT', 'EDITION STATEMENT', 1, 0, NULL, ''), |
276 |
('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''), |
260 |
('254', 'MUSICAL PRESENTATION STATEMENT', 'MUSICAL PRESENTATION STATEMENT', 0, 0, NULL, ''), |
277 |
('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''), |
261 |
('255', 'CARTOGRAPHIC MATHEMATICAL DATA', 'CARTOGRAPHIC MATHEMATICAL DATA', 1, 0, NULL, ''), |
278 |
('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''), |
262 |
('256', 'COMPUTER FILE CHARACTERISTICS', 'COMPUTER FILE CHARACTERISTICS', 0, 0, NULL, ''), |
Lines 322-327
INSERT INTO `marc_tag_structure` (`tagfield`, `liblibrarian`, `libopac`, `repeat
Link Here
|
322 |
('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 0, 1, NULL, ''), |
306 |
('381', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 'OTHER DISTINGUISHING CHARACTERISTICS OF WORK OR EXPRESSION', 0, 1, NULL, ''), |
323 |
('382', 'MEDIUM OF PERFORMANCE', 'MEDIUM OF PERFORMANCE', 0, 1, NULL, ''), |
307 |
('382', 'MEDIUM OF PERFORMANCE', 'MEDIUM OF PERFORMANCE', 0, 1, NULL, ''), |
324 |
('383', 'NUMERIC DESIGNATION OF MUSICAL WORK', 'NUMERIC DESIGNATION OF MUSICAL WORK', 0, 1, NULL, ''), |
308 |
('383', 'NUMERIC DESIGNATION OF MUSICAL WORK', 'NUMERIC DESIGNATION OF MUSICAL WORK', 0, 1, NULL, ''), |
|
|
309 |
('385', 'AUDIENCE CHARACTERISTICS', 'AUDIENCE CHARACTERISTICS', 1, 0, NULL, ''), |
310 |
('386', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 'CREATOR/CONTRIBUTOR CHARACTERISTICS', 1, 0, NULL, ''), |
325 |
('384', 'KEY', 'KEY', 0, 0, NULL, ''), |
311 |
('384', 'KEY', 'KEY', 0, 0, NULL, ''), |
326 |
('400', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), |
312 |
('400', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--PERSONAL NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), |
327 |
('410', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), |
313 |
('410', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 'SERIES STATEMENT/ADDED ENTRY--CORPORATE NAME [OBSOLETE, CAN/MARC], [LOCAL, USA]', 1, 0, NULL, ''), |
Lines 738-743
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
Link Here
|
738 |
('045', 'b', 'Formatted 9999 B.C. through C.E. time period', 'Formatted 9999 B.C. through C.E. time period', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
724 |
('045', 'b', 'Formatted 9999 B.C. through C.E. time period', 'Formatted 9999 B.C. through C.E. time period', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
739 |
('045', 'c', 'Formatted pre-9999 B.C. time period', 'Formatted pre-9999 B.C. time period', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
725 |
('045', 'c', 'Formatted pre-9999 B.C. time period', 'Formatted pre-9999 B.C. time period', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
740 |
('046', '2', 'Source of date', 'Source of date', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
726 |
('046', '2', 'Source of date', 'Source of date', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
|
|
727 |
('046', '3', 'Materials specified', 'Materials specified', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
741 |
('046', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
728 |
('046', '6', 'Linkage', 'Linkage', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
742 |
('046', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
729 |
('046', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
743 |
('046', 'a', 'Type of date code', 'Type of date code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
730 |
('046', 'a', 'Type of date code', 'Type of date code', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
Lines 750-755
INSERT INTO `marc_subfield_structure` (`tagfield`, `tagsubfield`, `liblibrarian`
Link Here
|
750 |
('046', 'l', 'Ending date created', 'Ending date created', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
737 |
('046', 'l', 'Ending date created', 'Ending date created', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
751 |
('046', 'm', 'Beginning of date valid', 'Beginning of date valid', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
738 |
('046', 'm', 'Beginning of date valid', 'Beginning of date valid', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
752 |
('046', 'n', 'End of date valid', 'End of date valid', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
739 |
('046', 'n', 'End of date valid', 'End of date valid', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
|
|
740 |
('046', 'o', 'Single or starting date for aggregated content', 'Single or starting date for aggregated content', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
741 |
('046', 'p', 'Ending date for aggregated content', 'Ending date for aggregated content', 0, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
753 |
('047', '2', 'Source of code', 'Source of code', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
742 |
('047', '2', 'Source of code', 'Source of code', 0, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
754 |
('047', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
743 |
('047', '8', 'Field link and sequence number', 'Field link and sequence number', 1, 0, '', 0, '', '', '', 0, -6, '', '', '', NULL), |
755 |
('047', 'a', 'Form of musical composition code', 'Form of musical composition code', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
744 |
('047', 'a', 'Form of musical composition code', 'Form of musical composition code', 1, 0, '', 0, '', '', '', 0, -1, '', '', '', NULL), |
756 |
- |
|
|