@@ -, +, @@ web installer kohadev): ALTER TABLE `biblioitems` MODIFY COLUMN `publishercode` varchar(255); ALTER TABLE `biblioitems` DROP INDEX `publishercode`; ALTER TABLE `biblioitems` ADD INDEX `publishercode` (`publishercode`); ALTER TABLE `deletedbiblioitems` MODIFY COLUMN `publishercode` varchar(255); ALTER TABLE `deletedbiblioitems` DROP INDEX `publishercode`; ALTER TABLE `deletedbiblioitems` ADD INDEX `publishercode` (`publishercode`); UPDATE systempreferences SET value="23.0600006" WHERE variable = "Version"; --- 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` --