Attachment #19357 for bug #10488

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

Lines 1942-1948 INSERT INTO auth_tag_structure (authtypecode, tagfield, liblibrarian, libopac, r Link Here

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/authorities_normal_marc21.sql (-98 / +62 lines)
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