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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.sql (-19 / +7 lines)
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
- 

Return to bug 5858