[Koha-cvs] koha/misc/sql-datas/en/mandatory 02_authorities...

[Ryan Higgins]

CVSROOT:	/sources/koha
Module name:	koha
Changes by:	Ryan Higgins <rych>	07/03/20 05:05:22

Modified files:
	misc/sql-datas/en/mandatory: 02_authorities_normal_marc21.sql 

Log message:
	adding 001 tag/subfield

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/misc/sql-datas/en/mandatory/02_authorities_normal_marc21.sql?cvsroot=koha&r1=1.2&r2=1.3

Patches:
Index: 02_authorities_normal_marc21.sql
===================================================================
RCS file: /sources/koha/koha/misc/sql-datas/en/mandatory/02_authorities_normal_marc21.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -b -r1.2 -r1.3
--- 02_authorities_normal_marc21.sql	9 Mar 2007 15:45:39 -0000	1.2
+++ 02_authorities_normal_marc21.sql	20 Mar 2007 05:05:22 -0000	1.3
@@ -78,8 +78,8 @@
 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, 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);