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', |