1 $DBversion = 'XXX'; # will be replaced by the RM
2 if( CheckVersion( $DBversion ) ) {
4 $dbh->do('SET FOREIGN_KEY_CHECKS=0');
6 # Change columns accordingly
9 MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
13 ALTER TABLE tags_approval
14 MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
19 MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
22 $dbh->do('SET FOREIGN_KEY_CHECKS=1');
24 SetVersion( $DBversion );
25 print "Upgrade to $DBversion done (Bug 21846 - Using emoji as tags has broken weights)\n";
26 my $maintenance_script = C4::Context->config("intranetdir") . "/misc/maintenance/fix_tags_weight.pl";
27 print "WARNING: (Bug 21846) You need to manually run $maintenance_script to fix possible issues with tags.\n";