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

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-98 / +62 lines)
Lines 1942-1948 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
1942
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1942
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1943
                      '154','253','353','453','553','668','671','676',
1943
                      '154','253','353','453','553','668','671','676',
1944
                      '684','685','686','687','68a','68b','753','754',
1944
                      '684','685','686','687','68a','68b','753','754',
1945
                      '761','763','764','765','766','768');
1945
                      '761','763','764','765','766','768') AND
1946
    tagfield NOT IN ('110','111','130','148','150','151','155','162',
1947
                     '180','181','182','185','034','640','641','642',
1948
                     '643','644','645','646');
1946
1949
1947
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
1950
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
1948
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
1951
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 1953-1969 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
1953
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1956
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1954
                      '154','253','353','453','553','668','671','676',
1957
                      '154','253','353','453','553','668','671','676',
1955
                      '684','685','686','687','68a','68b','753','754',
1958
                      '684','685','686','687','68a','68b','753','754',
1956
                      '761','763','764','765','766','768');
1959
                      '761','763','764','765','766','768') AND
1957
1960
    tagfield NOT IN ('110','111','130','148','150','151','155','162',
1958
-- delete especific tags
1961
                     '180','181','182','185','034','640','641','642',
1959
1962
                     '643','644','645','646');
1960
DELETE FROM auth_tag_structure WHERE authtypecode = 'PERSO_NAME' AND
1961
    tagfield IN ('110','111','130','148','150','151','155','180','181','182','185',
1962
                 '034','640','641','642','643','644','645','646');
1963
1964
DELETE FROM auth_subfield_structure WHERE authtypecode = 'PERSO_NAME' AND
1965
    tagfield IN ('110','111','130','148','150','151','155','180','181','182','185',
1966
                 '034','640','641','642','643','644','645','646');
1967
1963
1968
-- ******************************************************
1964
-- ******************************************************
1969
1965
Lines 1980-1986 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
1980
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1976
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1981
                      '154','253','353','453','553','668','671','676',
1977
                      '154','253','353','453','553','668','671','676',
1982
                      '684','685','686','687','68a','68b','753','754',
1978
                      '684','685','686','687','68a','68b','753','754',
1983
                      '761','763','764','765','766','768');
1979
                      '761','763','764','765','766','768') AND
1980
    tagfield NOT IN ( '100','111','130','148','150','151','155','162',
1981
                      '180','181','182','185','034','640','641','642',
1982
                      '643','644','645','646');
1984
1983
1985
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
1984
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
1986
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
1985
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 1991-2007 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
1991
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1990
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
1992
                      '154','253','353','453','553','668','671','676',
1991
                      '154','253','353','453','553','668','671','676',
1993
                      '684','685','686','687','68a','68b','753','754',
1992
                      '684','685','686','687','68a','68b','753','754',
1994
                      '761','763','764','765','766','768');
1993
                      '761','763','764','765','766','768') AND
1995
1994
    tagfield NOT IN ( '100','111','130','148','150','151','155','162',
1996
-- delete especific tags
1995
                      '180','181','182','185','034','640','641','642',
1997
1996
                      '643','644','645','646');
1998
DELETE FROM auth_tag_structure WHERE authtypecode = 'CORPO_NAME' AND
1999
    tagfield IN ('100','111','130','148','150','151','155','180','181','182','185',
2000
                 '034','640','641','642','643','644','645','646');
2001
2002
DELETE FROM auth_subfield_structure WHERE authtypecode = 'CORPO_NAME' AND
2003
    tagfield IN ('100','111','130','148','150','151','155','180','181','182','185',
2004
                 '034','640','641','642','643','644','645','646');
2005
1997
2006
-- ******************************************************
1998
-- ******************************************************
2007
1999
Lines 2018-2024 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2018
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2010
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2019
                      '154','253','353','453','553','668','671','676',
2011
                      '154','253','353','453','553','668','671','676',
2020
                      '684','685','686','687','68a','68b','753','754',
2012
                      '684','685','686','687','68a','68b','753','754',
2021
                      '761','763','764','765','766','768');
2013
                      '761','763','764','765','766','768') AND
2014
    tagfield NOT IN ( '100','110','130','148','150','151','155','162',
2015
                      '180','181','182','185','640','641','642','643',
2016
                      '644','645','646');
2022
2017
2023
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2018
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2024
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
2019
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 2029-2045 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2029
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2024
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2030
                      '154','253','353','453','553','668','671','676',
2025
                      '154','253','353','453','553','668','671','676',
2031
                      '684','685','686','687','68a','68b','753','754',
2026
                      '684','685','686','687','68a','68b','753','754',
2032
                      '761','763','764','765','766','768');
2027
                      '761','763','764','765','766','768') AND
2033
2028
    tagfield NOT IN ( '100','110','130','148','150','151','155','162',
2034
-- delete especific tags
2029
                      '180','181','182','185','640','641','642','643',
2035
2030
                      '644','645','646');
2036
DELETE FROM auth_tag_structure WHERE authtypecode = 'MEETI_NAME' AND
2037
    tagfield IN ('100','110','130','148','150','151','155','180','181','182','185',
2038
                 '640','641','642','643','644','645','646');
2039
2040
DELETE FROM auth_subfield_structure WHERE authtypecode = 'MEETI_NAME' AND
2041
    tagfield IN ('100','110','130','148','150','151','155','180','181','182','185',
2042
                 '640','641','642','643','644','645','646');
2043
2031
2044
-- ******************************************************
2032
-- ******************************************************
2045
2033
Lines 2056-2062 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2056
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2044
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2057
                      '154','253','353','453','553','668','671','676',
2045
                      '154','253','353','453','553','668','671','676',
2058
                      '684','685','686','687','68a','68b','753','754',
2046
                      '684','685','686','687','68a','68b','753','754',
2059
                      '761','763','764','765','766','768');
2047
                      '761','763','764','765','766','768') AND
2048
    tagfield NOT IN ( '100','110','111','148','150','151','155','162',
2049
                      '180','181','182','185');
2060
2050
2061
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2051
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2062
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
2052
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 2067-2083 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2067
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2057
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2068
                      '154','253','353','453','553','668','671','676',
2058
                      '154','253','353','453','553','668','671','676',
2069
                      '684','685','686','687','68a','68b','753','754',
2059
                      '684','685','686','687','68a','68b','753','754',
2070
                      '761','763','764','765','766','768');
2060
                      '761','763','764','765','766','768') AND
2071
2061
    tagfield NOT IN ( '100','110','111','148','150','151','155','162',
2072
-- delete especific tags
2062
                      '180','181','182','185');
2073
2074
DELETE FROM auth_tag_structure WHERE authtypecode = 'UNIF_TITLE' AND
2075
    tagfield IN ('100','110','111','148','150','151','155','180','181','182','185'
2076
                 );
2077
2078
DELETE FROM auth_subfield_structure WHERE authtypecode = 'UNIF_TITLE' AND
2079
    tagfield IN ('100','110','111','148','150','151','155','180','181','182','185'
2080
                 );
2081
2063
2082
-- ******************************************************
2064
-- ******************************************************
2083
2065
Lines 2094-2100 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2094
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2076
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2095
                      '154','253','353','453','553','668','671','676',
2077
                      '154','253','353','453','553','668','671','676',
2096
                      '684','685','686','687','68a','68b','753','754',
2078
                      '684','685','686','687','68a','68b','753','754',
2097
                      '761','763','764','765','766','768');
2079
                      '761','763','764','765','766','768') AND
2080
    tagfield NOT IN ( '100','110','111','130','150','151','155','162',
2081
                      '180','181','185','014','020','022','031','640',
2082
                      '641','642','643','644','645','646');
2098
2083
2099
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2084
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2100
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
2085
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 2105-2121 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2105
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2090
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2106
                      '154','253','353','453','553','668','671','676',
2091
                      '154','253','353','453','553','668','671','676',
2107
                      '684','685','686','687','68a','68b','753','754',
2092
                      '684','685','686','687','68a','68b','753','754',
2108
                      '761','763','764','765','766','768');
2093
                      '761','763','764','765','766','768') AND
2109
2094
    tagfield NOT IN ( '100','110','111','130','150','151','155','162',
2110
-- delete especific tags
2095
                      '180','181','185','014','020','022','031','640',
2111
2096
                      '641','642','643','644','645','646');
2112
DELETE FROM auth_tag_structure WHERE authtypecode = 'CHRON_TERM' AND
2113
    tagfield IN ('100','110','111','130','150','151','155','180','181','185',
2114
                 '014','020','022','031','640','641','642','643','644','645','646');
2115
2116
DELETE FROM auth_subfield_structure WHERE authtypecode = 'CHRON_TERM' AND
2117
    tagfield IN ('100','110','111','130','150','151','155','180','181','185',
2118
                 '014','020','022','031','640','641','642','643','644','645','646');
2119
2097
2120
-- ******************************************************
2098
-- ******************************************************
2121
2099
Lines 2132-2138 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2132
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2110
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2133
                      '154','253','353','453','553','668','671','676',
2111
                      '154','253','353','453','553','668','671','676',
2134
                      '684','685','686','687','68a','68b','753','754',
2112
                      '684','685','686','687','68a','68b','753','754',
2135
                      '761','763','764','765','766','768');
2113
                      '761','763','764','765','766','768') AND
2114
    tagfield NOT IN ( '100','110','111','130','148','151','155','162',
2115
                      '181','182','185','014','020','022','031','640',
2116
                      '641','642','643','644','645','646');
2136
2117
2137
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2118
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2138
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
2119
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 2143-2159 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2143
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2124
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2144
                      '154','253','353','453','553','668','671','676',
2125
                      '154','253','353','453','553','668','671','676',
2145
                      '684','685','686','687','68a','68b','753','754',
2126
                      '684','685','686','687','68a','68b','753','754',
2146
                      '761','763','764','765','766','768');
2127
                      '761','763','764','765','766','768') AND
2147
2128
    tagfield NOT IN ( '100','110','111','130','148','151','155','162',
2148
-- delete especific tags
2129
                      '181','182','185','014','020','022','031','640',
2149
2130
                      '641','642','643','644','645','646');
2150
DELETE FROM auth_tag_structure WHERE authtypecode = 'TOPIC_TERM' AND
2151
    tagfield IN ('100','110','111','130','148','151','155','181','182','185',
2152
                 '014','020','022','031','640','641','642','643','644','645','646');
2153
2154
DELETE FROM auth_subfield_structure WHERE authtypecode = 'TOPIC_TERM' AND
2155
    tagfield IN ('100','110','111','130','148','151','155','181','182','185',
2156
                 '014','020','022','031','640','641','642','643','644','645','646');
2157
2131
2158
-- ******************************************************
2132
-- ******************************************************
2159
2133
Lines 2170-2176 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2170
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2144
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2171
                      '154','253','353','453','553','668','671','676',
2145
                      '154','253','353','453','553','668','671','676',
2172
                      '684','685','686','687','68a','68b','753','754',
2146
                      '684','685','686','687','68a','68b','753','754',
2173
                      '761','763','764','765','766','768');
2147
                      '761','763','764','765','766','768') AND
2148
    tagfield NOT IN ( '100','110','111','130','148','150','155','162',
2149
                      '180','182','185','014','020','022','031','640',
2150
                      '641','642','643','644','645','646');
2174
2151
2175
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2152
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2176
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
2153
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 2181-2197 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2181
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2158
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2182
                      '154','253','353','453','553','668','671','676',
2159
                      '154','253','353','453','553','668','671','676',
2183
                      '684','685','686','687','68a','68b','753','754',
2160
                      '684','685','686','687','68a','68b','753','754',
2184
                      '761','763','764','765','766','768');
2161
                      '761','763','764','765','766','768') AND
2185
2162
    tagfield NOT IN ( '100','110','111','130','148','150','155','162',
2186
-- delete especific tags
2163
                      '180','182','185','014','020','022','031','640',
2187
2164
                      '641','642','643','644','645','646');
2188
DELETE FROM auth_tag_structure WHERE authtypecode = 'GEOGR_NAME' AND
2189
    tagfield IN ('100','110','111','130','148','150','155','180','182','185',
2190
                 '014','020','022','031','640','641','642','643','644','645','646');
2191
2192
DELETE FROM auth_subfield_structure WHERE authtypecode = 'GEOGR_NAME' AND
2193
    tagfield IN ('100','110','111','130','148','150','155','180','182','185',
2194
                 '014','020','022','031','640','641','642','643','644','645','646');
2195
2165
2196
-- ******************************************************
2166
-- ******************************************************
2197
2167
Lines 2208-2214 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here
2208
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2178
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2209
                      '154','253','353','453','553','668','671','676',
2179
                      '154','253','353','453','553','668','671','676',
2210
                      '684','685','686','687','68a','68b','753','754',
2180
                      '684','685','686','687','68a','68b','753','754',
2211
                      '761','763','764','765','766','768');
2181
                      '761','763','764','765','766','768') AND
2182
    tagfield NOT IN ( '100','110','111','130','148','150','151','162',
2183
                      '180','181','182','014','020','022','031','640',
2184
                      '641','642','643','644','645','646');
2212
2185
2213
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2186
INSERT INTO auth_subfield_structure (authtypecode, tagfield, tagsubfield, liblibrarian, libopac, repeatable,
2214
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
2187
mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, kohafield, frameworkcode)
Lines 2219-2235 mandatory, tab, authorised_value, value_builder, seealso, isurl, hidden, linkid, Link Here
2219
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2192
    tagfield NOT IN ( '058','063','068','084','088','140','143','153',
2220
                      '154','253','353','453','553','668','671','676',
2193
                      '154','253','353','453','553','668','671','676',
2221
                      '684','685','686','687','68a','68b','753','754',
2194
                      '684','685','686','687','68a','68b','753','754',
2222
                      '761','763','764','765','766','768');
2195
                      '761','763','764','765','766','768') AND
2223
2196
    tagfield NOT IN ( '100','110','111','130','148','150','151','162',
2224
-- delete especific tags
2197
                      '180','181','182','014','020','022','031','640',
2225
2198
                      '641','642','643','644','645','646');
2226
DELETE FROM auth_tag_structure WHERE authtypecode = 'GENRE/FORM' AND
2227
    tagfield IN ('100','110','111','130','148','150','151','180','181','182',
2228
                 '014','020','022','031','640','641','642','643','644','645','646');
2229
2230
DELETE FROM auth_subfield_structure WHERE authtypecode = 'GENRE/FORM' AND
2231
    tagfield IN ('100','110','111','130','148','150','151','180','181','182',
2232
                 '014','020','022','031','640','641','642','643','644','645','646');
2233
2199
2234
-- ******************************************************
2200
-- ******************************************************
2235
2236
- 

Return to bug 10488