|
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" ); |