View | Details | Raw Unified | Return to bug 23675
Collapse All | Expand All

(-)a/installer/data/mysql/en/marcflavour/marc21/mandatory/marc21_framework_DEFAULT.yml (-2 / +7 lines)
Lines 78185-78191 sql_statements: Link Here
78185
  - "UPDATE marc_subfield_structure SET maxlength=24 WHERE tagfield='000';"
78185
  - "UPDATE marc_subfield_structure SET maxlength=24 WHERE tagfield='000';"
78186
  - "UPDATE marc_subfield_structure SET maxlength=40 WHERE tagfield='008';"
78186
  - "UPDATE marc_subfield_structure SET maxlength=40 WHERE tagfield='008';"
78187
78187
78188
  # Create the ACQ framework based on the default framework, fields 952 only
78188
  # Create the ACQ framework based on the default framework, fields 000 and 952 only
78189
  - "INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
78190
     SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' FROM marc_tag_structure WHERE tagfield='000' AND frameworkcode='';"
78191
78192
  - "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)
78193
     SELECT tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, authorised_value, authtypecode, value_builder, isurl, hidden, 'ACQ', seealso, link, '     nam a22     7a 4500', maxlength FROM marc_subfield_structure WHERE tagfield='000' AND frameworkcode='';"
78194
78189
  - "INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
78195
  - "INSERT INTO marc_tag_structure(tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, frameworkcode)
78190
     SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' FROM marc_tag_structure WHERE tagfield='952' AND frameworkcode='';"
78196
     SELECT tagfield, liblibrarian, libopac, repeatable, mandatory, authorised_value, 'ACQ' FROM marc_tag_structure WHERE tagfield='952' AND frameworkcode='';"
78191
78197
78192
- 

Return to bug 23675