Lines 2221-2224
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value,
Link Here
|
2221 |
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) |
2221 |
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) |
2222 |
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=''; |
2222 |
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=''; |
2223 |
|
2223 |
|
|
|
2224 |
INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode) |
2225 |
SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' |
2226 |
FROM marc_tag_structure |
2227 |
WHERE frameworkcode="" AND tagfield IN ( |
2228 |
SELECT tagfield |
2229 |
FROM marc_subfield_structure |
2230 |
WHERE ( |
2231 |
kohafield="biblio.title" |
2232 |
OR kohafield="biblio.author" |
2233 |
OR kohafield="biblioitems.publishercode" |
2234 |
OR kohafield="biblioitems.editionstatement" |
2235 |
OR kohafield="biblioitems.publicationyear" |
2236 |
OR kohafield="biblioitems.isbn" |
2237 |
OR kohafield="biblio.seriestitle" |
2238 |
) AND frameworkcode="" |
2239 |
); |
2240 |
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) |
2241 |
SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, defaultvalue, maxlength |
2242 |
FROM marc_subfield_structure |
2243 |
WHERE frameworkcode="" |
2244 |
AND kohafield IN ("biblio.title", "biblio.author", "biblioitems.publishercode", "biblioitems.editionstatement", "biblioitems.publicationyear", "biblioitems.isbn", "biblio.seriestitle" ); |
2245 |
|
2224 |
SET FOREIGN_KEY_CHECKS=1; |
2246 |
SET FOREIGN_KEY_CHECKS=1; |
2225 |
- |
|
|