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