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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-42 / +16 lines)
Lines 235-243 INSERT INTO `auth_tag_structure` (`authtypecode`, `tagfield`, `liblibrarian`, `l Link Here
235
		('', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
235
		('', '683', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
236
		('', '684', 'AUXILIARY INSTRUCTION NOTE [CLASSIFICATION FORMAT]', 'AUXILIARY INSTRUCTION NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
236
		('', '684', 'AUXILIARY INSTRUCTION NOTE [CLASSIFICATION FORMAT]', 'AUXILIARY INSTRUCTION NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
237
		('', '685', 'NOTE--SOURCE DATA FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--SOURCE DATA FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
237
		('', '685', 'NOTE--SOURCE DATA FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--SOURCE DATA FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
238
		('', '68a', 'HISTORY NOTE [CLASSIFICATION FORMAT]', 'HISTORY NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
239
		('', '686', 'NOTE--SOURCE DATA NOT FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--SOURCE DATA NOT FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
238
		('', '686', 'NOTE--SOURCE DATA NOT FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--SOURCE DATA NOT FOUND (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
240
		('', '68b', 'RELATIONSHIP TO SOURCE NOTE [CLASSIFICATION FORMAT]', 'RELATIONSHIP TO SOURCE NOTE [CLASSIFICATION FORMAT]', 1, 0, NULL),
241
		('', '687', 'NOTE--USAGE (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--USAGE (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
239
		('', '687', 'NOTE--USAGE (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 'NOTE--USAGE (SUBJECTS) [OBSOLETE, CAN/MARC ONLY]', 1, 0, NULL),
242
		('', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
240
		('', '688', 'APPLICATION HISTORY NOTE', 'APPLICATION HISTORY NOTE', 1, 0, NULL),
243
		('', '700', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 1, 0, NULL),
241
		('', '700', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 'ESTABLISHED HEADING LINKING ENTRY--PERSONAL NAME', 1, 0, NULL),
Lines 1510-1541 INSERT INTO `auth_subfield_structure` (`authtypecode`, `tagfield`, `tagsubfield` Link Here
1510
		('', '684', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1508
		('', '684', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1511
		('', '685', 'a', 'Source consulted and information found', 'Source consulted and information found', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1509
		('', '685', 'a', 'Source consulted and information found', 'Source consulted and information found', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1512
		('', '685', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1510
		('', '685', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1513
		('', '68a', 'a', 'New number--Single number or beginning number of span', 'New number--Single number or beginning number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1514
		('', '68a', 'b', 'Previous number--Single number or beginning number of span', 'Previous number--Single number or beginning number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1515
		('', '68a', 'c', 'Classification number--ending number of span', 'Classification number--ending number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1516
		('', '68a', 'd', 'Date of implementation of authoritative agency', 'Date of implementation of authoritative agency', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1517
		('', '68a', 'e', 'Local implementation date', 'Local implementation date', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1518
		('', '68a', 'f', 'Title and publication date', 'Title and publication date', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1519
		('', '68a', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1520
		('', '68a', 't', 'Topic', 'Topic', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1521
		('', '68a', 'z', 'Table identification', 'Table identification', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1522
		('', '68a', '2', 'Edition number', 'Edition number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1523
		('', '68a', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1524
		('', '68a', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1525
		('', '68a', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1526
		('', '686', 'a', 'Source consulted and information found', 'Source consulted and information found', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1511
		('', '686', 'a', 'Source consulted and information found', 'Source consulted and information found', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1527
		('', '686', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1512
		('', '686', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1528
		('', '68b', 'a', 'Number in edition described in field 084--Single number or beginning number of span', 'Number in edition described in field 084--Single number or beginning number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1529
		('', '68b', 'b', 'Number in primary source edition--Single number or beginning number of span', 'Number in primary source edition--Single number or beginning number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1530
		('', '68b', 'c', 'Ending number of span', 'Ending number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1531
		('', '68b', 'i', 'Explanatory text', 'Explanatory text', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1532
		('', '68b', 'o', 'Number where instructions are found--Single number or beginning number of span', 'Number where instructions are found--Single number or beginning number of span', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1533
		('', '68b', 't', 'Topic', 'Topic', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1534
		('', '68b', 'z', 'Table identification', 'Table identification', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1535
		('', '68b', '2', 'Edition number', 'Edition number', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1536
		('', '68b', '5', 'Institution to which field applies', 'Institution to which field applies', 1, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1537
		('', '68b', '6', 'Linkage', 'Linkage', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1538
		('', '68b', '8', 'Field link and sequence number', 'Field link and sequence number', 0, 0, 0, NULL, NULL, NULL, 0, 0, '', '', ''),
1539
		('', '687', 'a', 'Source consulted and information found', 'Source consulted and information found', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1513
		('', '687', 'a', 'Source consulted and information found', 'Source consulted and information found', 1, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1540
		('', '687', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1514
		('', '687', '6', 'Linkage', 'Linkage', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1541
		('', '688', 'a', 'Application history note', 'Application history note', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
1515
		('', '688', 'a', 'Application history note', 'Application history note', 0, 0, 6, NULL, NULL, NULL, 0, 0, '', '', ''),
Lines 1941-1947 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
1941
    WHERE authtypecode = '' AND
1915
    WHERE authtypecode = '' AND
1942
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1916
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1943
                      '154','253','353','453','553','668','671','676',
1917
                      '154','253','353','453','553','668','671','676',
1944
                      '684','685','686','687','68a','68b','753','754',
1918
                      '684','685','686','687','753','754',
1945
                      '761','763','764','765','766','768') AND
1919
                      '761','763','764','765','766','768') AND
1946
    tagfield NOT IN ('110','111','130','148','150','151','155','162',
1920
    tagfield NOT IN ('110','111','130','148','150','151','155','162',
1947
                     '180','181','182','185','034','640','641','642',
1921
                     '180','181','182','185','034','640','641','642',
Lines 1955-1961 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
1955
    WHERE authtypecode = '' AND
1929
    WHERE authtypecode = '' AND
1956
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1930
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1957
                      '154','253','353','453','553','668','671','676',
1931
                      '154','253','353','453','553','668','671','676',
1958
                      '684','685','686','687','68a','68b','753','754',
1932
                      '684','685','686','687','753','754',
1959
                      '761','763','764','765','766','768') AND
1933
                      '761','763','764','765','766','768') AND
1960
    tagfield NOT IN ('110','111','130','148','150','151','155','162',
1934
    tagfield NOT IN ('110','111','130','148','150','151','155','162',
1961
                     '180','181','182','185','034','640','641','642',
1935
                     '180','181','182','185','034','640','641','642',
Lines 1975-1981 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
1975
    WHERE authtypecode = '' AND
1949
    WHERE authtypecode = '' AND
1976
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1950
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1977
                      '154','253','353','453','553','668','671','676',
1951
                      '154','253','353','453','553','668','671','676',
1978
                      '684','685','686','687','68a','68b','753','754',
1952
                      '684','685','686','687','753','754',
1979
                      '761','763','764','765','766','768') AND
1953
                      '761','763','764','765','766','768') AND
1980
    tagfield NOT IN ( '100','111','130','148','150','151','155','162',
1954
    tagfield NOT IN ( '100','111','130','148','150','151','155','162',
1981
                      '180','181','182','185','034','640','641','642',
1955
                      '180','181','182','185','034','640','641','642',
Lines 1989-1995 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
1989
    WHERE authtypecode = '' AND
1963
    WHERE authtypecode = '' AND
1990
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1964
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1991
                      '154','253','353','453','553','668','671','676',
1965
                      '154','253','353','453','553','668','671','676',
1992
                      '684','685','686','687','68a','68b','753','754',
1966
                      '684','685','686','687','753','754',
1993
                      '761','763','764','765','766','768') AND
1967
                      '761','763','764','765','766','768') AND
1994
    tagfield NOT IN ( '100','111','130','148','150','151','155','162',
1968
    tagfield NOT IN ( '100','111','130','148','150','151','155','162',
1995
                      '180','181','182','185','034','640','641','642',
1969
                      '180','181','182','185','034','640','641','642',
Lines 2009-2015 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2009
    WHERE authtypecode = '' AND
1983
    WHERE authtypecode = '' AND
2010
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1984
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2011
                      '154','253','353','453','553','668','671','676',
1985
                      '154','253','353','453','553','668','671','676',
2012
                      '684','685','686','687','68a','68b','753','754',
1986
                      '684','685','686','687','753','754',
2013
                      '761','763','764','765','766','768') AND
1987
                      '761','763','764','765','766','768') AND
2014
    tagfield NOT IN ( '100','110','130','148','150','151','155','162',
1988
    tagfield NOT IN ( '100','110','130','148','150','151','155','162',
2015
                      '180','181','182','185','640','641','642','643',
1989
                      '180','181','182','185','640','641','642','643',
Lines 2023-2029 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2023
    WHERE authtypecode = '' AND
1997
    WHERE authtypecode = '' AND
2024
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1998
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2025
                      '154','253','353','453','553','668','671','676',
1999
                      '154','253','353','453','553','668','671','676',
2026
                      '684','685','686','687','68a','68b','753','754',
2000
                      '684','685','686','687','753','754',
2027
                      '761','763','764','765','766','768') AND
2001
                      '761','763','764','765','766','768') AND
2028
    tagfield NOT IN ( '100','110','130','148','150','151','155','162',
2002
    tagfield NOT IN ( '100','110','130','148','150','151','155','162',
2029
                      '180','181','182','185','640','641','642','643',
2003
                      '180','181','182','185','640','641','642','643',
Lines 2043-2049 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2043
    WHERE authtypecode = '' AND
2017
    WHERE authtypecode = '' AND
2044
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2018
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2045
                      '154','253','353','453','553','668','671','676',
2019
                      '154','253','353','453','553','668','671','676',
2046
                      '684','685','686','687','68a','68b','753','754',
2020
                      '684','685','686','687','753','754',
2047
                      '761','763','764','765','766','768') AND
2021
                      '761','763','764','765','766','768') AND
2048
    tagfield NOT IN ( '100','110','111','148','150','151','155','162',
2022
    tagfield NOT IN ( '100','110','111','148','150','151','155','162',
2049
                      '180','181','182','185');
2023
                      '180','181','182','185');
Lines 2056-2062 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2056
    WHERE authtypecode = '' AND
2030
    WHERE authtypecode = '' AND
2057
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2031
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2058
                      '154','253','353','453','553','668','671','676',
2032
                      '154','253','353','453','553','668','671','676',
2059
                      '684','685','686','687','68a','68b','753','754',
2033
                      '684','685','686','687','753','754',
2060
                      '761','763','764','765','766','768') AND
2034
                      '761','763','764','765','766','768') AND
2061
    tagfield NOT IN ( '100','110','111','148','150','151','155','162',
2035
    tagfield NOT IN ( '100','110','111','148','150','151','155','162',
2062
                      '180','181','182','185');
2036
                      '180','181','182','185');
Lines 2075-2081 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2075
    WHERE authtypecode = '' AND
2049
    WHERE authtypecode = '' AND
2076
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2050
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2077
                      '154','253','353','453','553','668','671','676',
2051
                      '154','253','353','453','553','668','671','676',
2078
                      '684','685','686','687','68a','68b','753','754',
2052
                      '684','685','686','687','753','754',
2079
                      '761','763','764','765','766','768') AND
2053
                      '761','763','764','765','766','768') AND
2080
    tagfield NOT IN ( '100','110','111','130','150','151','155','162',
2054
    tagfield NOT IN ( '100','110','111','130','150','151','155','162',
2081
                      '180','181','185','014','020','022','031','640',
2055
                      '180','181','185','014','020','022','031','640',
Lines 2089-2095 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2089
    WHERE authtypecode = '' AND
2063
    WHERE authtypecode = '' AND
2090
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2064
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2091
                      '154','253','353','453','553','668','671','676',
2065
                      '154','253','353','453','553','668','671','676',
2092
                      '684','685','686','687','68a','68b','753','754',
2066
                      '684','685','686','687','753','754',
2093
                      '761','763','764','765','766','768') AND
2067
                      '761','763','764','765','766','768') AND
2094
    tagfield NOT IN ( '100','110','111','130','150','151','155','162',
2068
    tagfield NOT IN ( '100','110','111','130','150','151','155','162',
2095
                      '180','181','185','014','020','022','031','640',
2069
                      '180','181','185','014','020','022','031','640',
Lines 2109-2115 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2109
    WHERE authtypecode = '' AND
2083
    WHERE authtypecode = '' AND
2110
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2084
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2111
                      '154','253','353','453','553','668','671','676',
2085
                      '154','253','353','453','553','668','671','676',
2112
                      '684','685','686','687','68a','68b','753','754',
2086
                      '684','685','686','687','753','754',
2113
                      '761','763','764','765','766','768') AND
2087
                      '761','763','764','765','766','768') AND
2114
    tagfield NOT IN ( '100','110','111','130','148','151','155','162',
2088
    tagfield NOT IN ( '100','110','111','130','148','151','155','162',
2115
                      '181','182','185','014','020','022','031','640',
2089
                      '181','182','185','014','020','022','031','640',
Lines 2123-2129 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2123
    WHERE authtypecode = '' AND
2097
    WHERE authtypecode = '' AND
2124
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2098
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2125
                      '154','253','353','453','553','668','671','676',
2099
                      '154','253','353','453','553','668','671','676',
2126
                      '684','685','686','687','68a','68b','753','754',
2100
                      '684','685','686','687','753','754',
2127
                      '761','763','764','765','766','768') AND
2101
                      '761','763','764','765','766','768') AND
2128
    tagfield NOT IN ( '100','110','111','130','148','151','155','162',
2102
    tagfield NOT IN ( '100','110','111','130','148','151','155','162',
2129
                      '181','182','185','014','020','022','031','640',
2103
                      '181','182','185','014','020','022','031','640',
Lines 2143-2149 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2143
    WHERE authtypecode = '' AND
2117
    WHERE authtypecode = '' AND
2144
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2118
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2145
                      '154','253','353','453','553','668','671','676',
2119
                      '154','253','353','453','553','668','671','676',
2146
                      '684','685','686','687','68a','68b','753','754',
2120
                      '684','685','686','687','753','754',
2147
                      '761','763','764','765','766','768') AND
2121
                      '761','763','764','765','766','768') AND
2148
    tagfield NOT IN ( '100','110','111','130','148','150','155','162',
2122
    tagfield NOT IN ( '100','110','111','130','148','150','155','162',
2149
                      '180','182','185','014','020','022','031','640',
2123
                      '180','182','185','014','020','022','031','640',
Lines 2157-2163 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2157
    WHERE authtypecode = '' AND
2131
    WHERE authtypecode = '' AND
2158
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2132
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2159
                      '154','253','353','453','553','668','671','676',
2133
                      '154','253','353','453','553','668','671','676',
2160
                      '684','685','686','687','68a','68b','753','754',
2134
                      '684','685','686','687','753','754',
2161
                      '761','763','764','765','766','768') AND
2135
                      '761','763','764','765','766','768') AND
2162
    tagfield NOT IN ( '100','110','111','130','148','150','155','162',
2136
    tagfield NOT IN ( '100','110','111','130','148','150','155','162',
2163
                      '180','182','185','014','020','022','031','640',
2137
                      '180','182','185','014','020','022','031','640',
Lines 2177-2183 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2177
    WHERE authtypecode = '' AND
2151
    WHERE authtypecode = '' AND
2178
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2152
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2179
                      '154','253','353','453','553','668','671','676',
2153
                      '154','253','353','453','553','668','671','676',
2180
                      '684','685','686','687','68a','68b','753','754',
2154
                      '684','685','686','687','753','754',
2181
                      '761','763','764','765','766','768') AND
2155
                      '761','763','764','765','766','768') AND
2182
    tagfield NOT IN ( '100','110','111','130','148','150','151','162',
2156
    tagfield NOT IN ( '100','110','111','130','148','150','151','162',
2183
                      '180','181','182','014','020','022','031','640',
2157
                      '180','181','182','014','020','022','031','640',
Lines 2191-2197 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2191
    WHERE authtypecode = '' AND
2165
    WHERE authtypecode = '' AND
2192
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2166
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2193
                      '154','253','353','453','553','668','671','676',
2167
                      '154','253','353','453','553','668','671','676',
2194
                      '684','685','686','687','68a','68b','753','754',
2168
                      '684','685','686','687','753','754',
2195
                      '761','763','764','765','766','768') AND
2169
                      '761','763','764','765','766','768') AND
2196
    tagfield NOT IN ( '100','110','111','130','148','150','151','162',
2170
    tagfield NOT IN ( '100','110','111','130','148','150','151','162',
2197
                      '180','181','182','014','020','022','031','640',
2171
                      '180','181','182','014','020','022','031','640',
(-)a/installer/data/mysql/updatedatabase.pl (-1 / +8 lines)
Lines 7139-7144 if ( CheckVersion($DBversion) ) { Link Here
7139
    SetVersion ($DBversion);
7139
    SetVersion ($DBversion);
7140
}
7140
}
7141
7141
7142
$DBversion = "3.13.00.XXX";
7143
if ( CheckVersion($DBversion) ) {
7144
    $dbh->do("DELETE from auth_tag_structure WHERE tagfield IN ('68a','68b')");
7145
    $dbh->do("DELETE from auth_subfield_structure WHERE tagfield IN ('68a','68b')");
7146
    print "Upgrade to $DBversion done (Bug 10687 - Delete erroneous tags 68a and 68b on default MARC21 auth framework)\n";
7147
    SetVersion($DBversion);
7148
}
7149
7142
=head1 FUNCTIONS
7150
=head1 FUNCTIONS
7143
7151
7144
=head2 TableExists($table)
7152
=head2 TableExists($table)
7145
- 

Return to bug 10687