From 0fc83a081f10ad2856ba67a7eaa285c9c7fabbd8 Mon Sep 17 00:00:00 2001 From: rych Date: Tue, 20 Mar 2007 05:05:22 +0000 Subject: [PATCH] adding 001 tag/subfield --- .../en/mandatory/02_authorities_normal_marc21.sql | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/misc/sql-datas/en/mandatory/02_authorities_normal_marc21.sql b/misc/sql-datas/en/mandatory/02_authorities_normal_marc21.sql index c5d23efc63..44047810ba 100644 --- a/misc/sql-datas/en/mandatory/02_authorities_normal_marc21.sql +++ b/misc/sql-datas/en/mandatory/02_authorities_normal_marc21.sql @@ -78,8 +78,8 @@ INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblib INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','060','5','Institution to which field applies','',1,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','060','6','Linkage','',0,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','060','8','Field link and sequence number','',1,0,0,NULL,NULL,NULL); -INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','a','Classification number element–single number or beginning of span','',0,0,0,NULL,NULL,NULL); -INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','b','Classification number element–ending number of span','',0,0,0,NULL,NULL,NULL); +INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','a','Classification number element-single number or beginning of span','',0,0,0,NULL,NULL,NULL); +INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','b','Classification number element-ending number of span','',0,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','c','Explanatory term','',0,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','2','Number source','',0,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','065','5','Institution to which field applies','',1,0,0,NULL,NULL,NULL); @@ -1185,6 +1185,9 @@ INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblib INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','880','7','Same as associated field','',1,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','880','8','Same as associated field','',1,0,0,NULL,NULL,NULL); INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('','880','9','Same as associated field','',1,0,0,NULL,NULL,NULL); +INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, tab, authorised_value, value_builder, seealso) VALUES ('', '001', '@', 'Koha Authority Number', '', 1, 0, 0, '', NULL, ''); + +INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','001','CONTROL NUMBER','',0,0,NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','010','LIBRARY OF CONGRESS CONTROL NUMBER','',0,0,NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','014','LINK TO BIBLIOGRAPHIC RECORD FOR SERIAL OR MULTIPART ITEM','',1,0,NULL); INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value) VALUES ('','016','National Bibliographic Agency Control Number','',1,0,NULL); -- 2.20.1