Lines 2144-2146
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value,
Link Here
|
2144 |
|
2144 |
|
2145 |
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) |
2145 |
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) |
2146 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode=''; |
2146 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='995' AND frameworkcode=''; |
2147 |
- |
2147 |
|
|
|
2148 |
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) |
2149 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength FROM marc_subfield_structure WHERE tagfield='952' AND frameworkcode=''; |
2150 |
|
2151 |
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) |
2152 |
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' |
2153 |
FROM marc_tag_structure |
2154 |
WHERE frameworkcode="" AND tagfield IN ( |
2155 |
SELECT tagfield |
2156 |
FROM marc_subfield_structure |
2157 |
WHERE ( |
2158 |
kohafield="biblio.title" |
2159 |
OR kohafield="biblio.author" |
2160 |
OR kohafield="biblioitems.publishercode" |
2161 |
OR kohafield="biblioitems.editionstatement" |
2162 |
OR kohafield="biblioitems.publicationyear" |
2163 |
OR kohafield="biblioitems.isbn" |
2164 |
OR kohafield="biblio.seriestitle" |
2165 |
) AND frameworkcode="" |
2166 |
); |
2167 |
INSERT INTO marc_subfield_structure(tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, frameworkcode, seealso, link, defaultvalue, maxlength) |
2168 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength |
2169 |
FROM marc_subfield_structure |
2170 |
WHERE frameworkcode="" |
2171 |
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" ); |