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