@@ -, +, @@ web installer --- installer/data/mysql/db_revs/230600007.pl | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) --- a/installer/data/mysql/db_revs/230600007.pl +++ a/installer/data/mysql/db_revs/230600007.pl @@ -17,16 +17,36 @@ return { }); say $out "Updated deletedbiblioitems.place to text"; + $dbh->do(q{ + ALTER TABLE `biblioitems` + DROP INDEX `publishercode` + }); + say $out "Remove index on biblioitems.publishercode"; $dbh->do(q{ ALTER TABLE `biblioitems` MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' }); say $out "Updated biblioitems.publishercode to text"; + $dbh->do(q{ + ALTER TABLE `biblioitems` + ADD INDEX `publishercode` (`publishercode`(191)) + }); + say $out "Create index on biblioitems.publishercode"; + $dbh->do(q{ + ALTER TABLE `deletedbiblioitems` + DROP INDEX `publishercode` + }); + say $out "Remove index on deletedbiblioitems.publishercode"; $dbh->do(q{ ALTER TABLE `deletedbiblioitems` MODIFY COLUMN `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and 264$b)' }); say $out "Updated deletedbiblioitems.publishercode to text"; + $dbh->do(q{ + ALTER TABLE `deletedbiblioitems` + ADD INDEX `publishercode` (`publishercode`(191)) + }); + say $out "Create index on deletedbiblioitems.publishercode"; $dbh->do(q{ ALTER TABLE `biblioitems` --