[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);