@@ -, +, @@ --- .../atomicupdate/Bug-19360_Add_Link_text_field_to_items.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/Bug-19360_Add_Link_text_field_to_items.sql --- a/installer/data/mysql/atomicupdate/Bug-19360_Add_Link_text_field_to_items.sql +++ a/installer/data/mysql/atomicupdate/Bug-19360_Add_Link_text_field_to_items.sql @@ -0,0 +1,12 @@ +ALTER TABLE items ADD link_text varchar (200) DEFAULT NULL; +INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, isurl, hidden, defaultvalue) VALUES (952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, NULL); +INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, isurl, hidden, frameworkcode, defaultvalue) VALUES +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'AR', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'BKS', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'CF', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'FA', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'IR', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'KT', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'SER', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'SR', NULL), +(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'VR', NULL) --