This patch introduces an index for the used_for column
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
|);
}
+ unless ( index_exists( 'export_format', 'used_for_idx' ) ) {
+ $dbh->do(q|
+ ALTER TABLE export_format
+ ADD KEY `used_for_idx` (`used_for` (191));
+ |);
+ }
+
NewVersion( $DBversion, 5087, "Add export_format.staff_only" );
}
`used_for` varchar(255) DEFAULT 'export_records',
`staff_only` TINYINT(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`export_format_id`),
+ KEY `used_for_idx` (`used_for` (191)),
KEY `staff_only_idx` (`staff_only`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Used for CSV export';