Bug 21846: DBRev 18.12.00.025

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

diff --git a/Koha.pm b/Koha.pm
index 1d4d38e..e8a639b 100644 (file)
--- a/Koha.pm
+++ b/Koha.pm
@@ -29,7 +29,7 @@ use vars qw{ $VERSION };
 # - #4 : the developer version. The 4th number is the database subversion.
 #        used by developers when the database changes. updatedatabase take care of the changes itself
 #        and is automatically called by Auth.pm when needed.
-$VERSION = "18.12.00.024";
+$VERSION = "18.12.00.025";
 
 sub version {
     return $VERSION;

diff --git a/installer/data/mysql/atomicupdate/bug_21846.perl b/installer/data/mysql/atomicupdate/bug_21846.perl
deleted file mode 100644 (file)
index 7f168de..0000000
--- a/installer/data/mysql/atomicupdate/bug_21846.perl
+++ /dev/null
@@ -1,28 +0,0 @@
-$DBversion = 'XXX';  # will be replaced by the RM
-if( CheckVersion( $DBversion ) ) {
-
-    $dbh->do('SET FOREIGN_KEY_CHECKS=0');
-
-    # Change columns accordingly
-    $dbh->do(q{
-        ALTER TABLE tags_index
-            MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
-    });
-
-    $dbh->do(q{
-        ALTER TABLE tags_approval
-            MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
-    });
-
-    $dbh->do(q{
-        ALTER TABLE tags_all
-            MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
-    });
-
-    $dbh->do('SET FOREIGN_KEY_CHECKS=1');
-
-    SetVersion( $DBversion );
-    print "Upgrade to $DBversion done (Bug 21846 - Using emoji as tags has broken weights)\n";
-    my $maintenance_script = C4::Context->config("intranetdir") . "/misc/maintenance/fix_tags_weight.pl";
-    print "WARNING: (Bug 21846) You need to manually run $maintenance_script to fix possible issues with tags.\n";
-}

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index 1298e45..f5415fc 100755 (executable)
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -17690,6 +17690,35 @@ if ( CheckVersion($DBversion) ) {
 "Upgrade to $DBversion done (Bug 22368 - Add missing constraints to suggestions)\n";
 }
 
+$DBversion = '18.12.00.025';
+if( CheckVersion( $DBversion ) ) {
+
+    $dbh->do('SET FOREIGN_KEY_CHECKS=0');
+
+    # Change columns accordingly
+    $dbh->do(q{
+        ALTER TABLE tags_index
+            MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
+    });
+
+    $dbh->do(q{
+        ALTER TABLE tags_approval
+            MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
+    });
+
+    $dbh->do(q{
+        ALTER TABLE tags_all
+            MODIFY COLUMN term VARCHAR(191) COLLATE utf8mb4_bin NOT NULL;
+    });
+
+    $dbh->do('SET FOREIGN_KEY_CHECKS=1');
+
+    SetVersion( $DBversion );
+    print "Upgrade to $DBversion done (Bug 21846 - Using emoji as tags has broken weights)\n";
+    my $maintenance_script = C4::Context->config("intranetdir") . "/misc/maintenance/fix_tags_weight.pl";
+    print "WARNING: (Bug 21846) You need to manually run $maintenance_script to fix possible issues with tags.\n";
+}
+
 # SEE bug 13068
 # if there is anything in the atomicupdate, read and execute it.