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

(-)a/installer/data/mysql/atomicupdate/Bug-19360_Add_Link_text_field_to_items.sql (-1 / +12 lines)
Line 0 Link Here
0
- 
1
ALTER TABLE items ADD link_text varchar (200) DEFAULT NULL;
2
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);
3
INSERT INTO marc_subfield_structure (tagfield, tagsubfield, liblibrarian, libopac, repeatable, mandatory, kohafield, tab, isurl, hidden, frameworkcode, defaultvalue) VALUES 
4
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'AR', NULL),
5
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'BKS', NULL),
6
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'CF', NULL),
7
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'FA', NULL),
8
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'IR', NULL),
9
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'KT', NULL),
10
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'SER', NULL),
11
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'SR', NULL),
12
(952, 'k', 'Link text', 'Link text', 0, 0, 'items.link_text', 10, 1, 0, 'VR', NULL)

Return to bug 19360