Bug 21946: DBRev 20.06.00.022

[koha.git] / installer / data / mysql / atomicupdate / bug_21946.perl

diff --git a/installer/data/mysql/atomicupdate/bug_21946.perl b/installer/data/mysql/atomicupdate/bug_21946.perl
deleted file mode 100644 (file)
index e5bbc86..0000000
--- a/installer/data/mysql/atomicupdate/bug_21946.perl
+++ /dev/null
@@ -1,20 +0,0 @@
-$DBversion = 'XXX';
-if( CheckVersion( $DBversion ) ) {
-    unless ( column_exists('itemtypes', 'parent_type') ) {
-        $dbh->do(q{
-            ALTER TABLE itemtypes
-                ADD COLUMN parent_type VARCHAR(10) NULL DEFAULT NULL
-                AFTER itemtype;
-
-        });
-    }
-    unless ( foreign_key_exists( 'itemtypes', 'itemtypes_ibfk_1') ){
-        $dbh->do(q{
-            ALTER TABLE itemtypes
-            ADD CONSTRAINT itemtypes_ibfk_1
-            FOREIGN KEY (parent_type) REFERENCES itemtypes (itemtype)
-        });
-    }
-    SetVersion( $DBversion );
-    print "Upgrade to $DBversion done (Bug 21946 - Add parent type to itemtypes)\n";
-}