Attachment #107113 for bug #5087

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

Lines 8-12 if( CheckVersion( $DBversion ) ) { Link Here

(-)a/installer/data/mysql/atomicupdate/bug_5087_-_add_opac_option_field_to_export_formats.perl (+7 lines)
8	\|);	8	\|);
9	}	9	}
10		10
		11	unless ( index_exists( 'export_format', 'used_for_idx' ) ) {
		12	$dbh->do(q\|
		13	ALTER TABLE export_format
		14	ADD KEY `used_for_idx` (`used_for` (191));
		15	\|);
		16	}
		17
11	NewVersion( $DBversion, 5087, "Add export_format.staff_only" );	18	NewVersion( $DBversion, 5087, "Add export_format.staff_only" );
12	}	19	}

Lines 691-696 CREATE TABLE `export_format` ( Link Here

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
691	`used_for` varchar(255) DEFAULT 'export_records',	691	`used_for` varchar(255) DEFAULT 'export_records',
692	`staff_only` TINYINT(1) NOT NULL DEFAULT 0,	692	`staff_only` TINYINT(1) NOT NULL DEFAULT 0,
693	PRIMARY KEY (`export_format_id`),	693	PRIMARY KEY (`export_format_id`),
		694	KEY `used_for_idx` (`used_for` (191)),
694	KEY `staff_only_idx` (`staff_only`)	695	KEY `staff_only_idx` (`staff_only`)
695	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';	696	) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';
696		697
697	-

Return to bug 5087