From 34d03cca64bcf2d8627ef96de7c6e7cf41a476e8 Mon Sep 17 00:00:00 2001 From: Phil Ringnalda Date: Sat, 4 Mar 2023 19:26:22 -0800 Subject: [PATCH] Bug 33138: Don't copy tag 147 to authority MARC frameworks We shouldn't be including tag 147 in every authority MARC framework we install, since like all 1xx authority tags there should only be one per record. It only belongs in a NAME_EVENT framework, which we don't install. Test plan: 1. Apply patch, kd && ku or however you like to restart 2. Administration - Authority types - Actions button for Default - MARC structure 3. In the search box below the text "Select an authority framework" enter 147 and click OK 4. Once you see that it exists in Default, switch the dropdown to each of the other frameworks and verify it doesn't appear in any. --- .../mandatory/authorities_normal_marc21.yml | 32 +++++++++---------- 1 file changed, 16 insertions(+), 16 deletions(-) diff --git a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml index 8e9178ee77..1015243e90 100644 --- a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml +++ b/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.yml @@ -32748,7 +32748,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ('110','111','130','148','150','151','155','162', + tagfield NOT IN ('110','111','130','147','148','150','151','155','162', '180','181','182','185','034','640','641','642', '643','644','645','646');" @@ -32762,7 +32762,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ('110','111','130','148','150','151','155','162', + tagfield NOT IN ('110','111','130','147','148','150','151','155','162', '180','181','182','185','034','640','641','642', '643','644','645','646');" @@ -32775,7 +32775,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','111','130','148','150','151','155','162', + tagfield NOT IN ( '100','111','130','147','148','150','151','155','162', '180','181','182','185','034','640','641','642', '643','644','645','646');" @@ -32789,7 +32789,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','111','130','148','150','151','155','162', + tagfield NOT IN ( '100','111','130','147','148','150','151','155','162', '180','181','182','185','034','640','641','642', '643','644','645','646');" @@ -32802,7 +32802,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','130','148','150','151','155','162', + tagfield NOT IN ( '100','110','130','147','148','150','151','155','162', '180','181','182','185','640','641','642','643', '644','645','646');" @@ -32816,7 +32816,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','130','148','150','151','155','162', + tagfield NOT IN ( '100','110','130','147','148','150','151','155','162', '180','181','182','185','640','641','642','643', '644','645','646');" @@ -32829,7 +32829,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','148','150','151','155','162', + tagfield NOT IN ( '100','110','111','147','148','150','151','155','162', '180','181','182','185');" - "INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable, @@ -32842,7 +32842,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','148','150','151','155','162', + tagfield NOT IN ( '100','110','111','147','148','150','151','155','162', '180','181','182','185');" # CHRONOLOGICAL TERMS AUTHORITY FIELDS/SUBFIELDS. X48 @@ -32854,7 +32854,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','150','151','155','162', + tagfield NOT IN ( '100','110','111','130','147','150','151','155','162', '180','181','185','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32868,7 +32868,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','150','151','155','162', + tagfield NOT IN ( '100','110','111','130','147','150','151','155','162', '180','181','185','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32881,7 +32881,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','148','151','155','162', + tagfield NOT IN ( '100','110','111','130','147','148','151','155','162', '181','182','185','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32895,7 +32895,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','148','151','155','162', + tagfield NOT IN ( '100','110','111','130','147','148','151','155','162', '181','182','185','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32908,7 +32908,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','148','150','155','162', + tagfield NOT IN ( '100','110','111','130','147','148','150','155','162', '180','182','185','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32922,7 +32922,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','148','150','155','162', + tagfield NOT IN ( '100','110','111','130','147','148','150','155','162', '180','182','185','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32935,7 +32935,7 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','148','150','151','162', + tagfield NOT IN ( '100','110','111','130','147','148','150','151','162', '180','181','182','014','020','022','031','640', '641','642','643','644','645','646');" @@ -32949,6 +32949,6 @@ sql_statements: '154','253','353','453','553','668','671','676', '684','685','686','687','753','754', '761','763','764','765','766','768') AND - tagfield NOT IN ( '100','110','111','130','148','150','151','162', + tagfield NOT IN ( '100','110','111','130','147','148','150','151','162', '180','181','182','014','020','022','031','640', '641','642','643','644','645','646');" -- 2.26.1