Attachment #107168 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 693-698 CREATE TABLE `export_format` ( Link Here

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

Return to bug 5087