From e40fa1af65723cfa59140473e67fa55bae72bd15 Mon Sep 17 00:00:00 2001
From: Lucas Gass <lucas@bywatersolutions.com>
Date: Tue, 26 Jul 2022 16:51:12 +0000
Subject: [PATCH] Remove atomicupdate file

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
---
 .../data/mysql/atomicupdate/bug_30899.pl      | 57 -------------------
 1 file changed, 57 deletions(-)
 delete mode 100755 installer/data/mysql/atomicupdate/bug_30899.pl

diff --git a/installer/data/mysql/atomicupdate/bug_30899.pl b/installer/data/mysql/atomicupdate/bug_30899.pl
deleted file mode 100755
index 4701bc4690..0000000000
--- a/installer/data/mysql/atomicupdate/bug_30899.pl
+++ /dev/null
@@ -1,57 +0,0 @@
-use Modern::Perl;
-
-return {
-    bug_number => 30899,
-    description => "Check borrower_attribute_types FK constraint (30449 follow-up)",
-    up => sub {
-        my ($args) = @_;
-        my ($dbh, $out) = @$args{qw(dbh out)};
-
-        if( foreign_key_exists('borrower_attribute_types', 'category_code_fk') ) {
-            $dbh->do( q|ALTER TABLE borrower_attribute_types DROP FOREIGN KEY category_code_fk| );
-            if( index_exists('borrower_attribute_types', 'category_code_fk') ) {
-                $dbh->do( q|ALTER TABLE borrower_attribute_types DROP INDEX category_code_fk| );
-            }
-        }
-
-        if (
-            !foreign_key_exists(
-                'borrower_attribute_types', 'borrower_attribute_types_ibfk_1'
-            )
-          )
-        {
-
-            my $sth = $dbh->prepare(
-                q{
-                SELECT category_code
-                FROM borrower_attribute_types
-                WHERE category_code NOT IN (SELECT categorycode FROM categories);
-            }
-            );
-
-            $sth->execute;
-
-            my @invalid_categories;
-            while ( my $row = $sth->fetchrow_arrayref() ) {
-                push( @invalid_categories, $row->[0] );
-            }
-
-            if (@invalid_categories) {
-                die "The 'borrower_attribute_types' table contains "
-                  . "references to invalid category codes: "
-                  . join( ', ', @invalid_categories );
-            }
-
-            if ( !index_exists( 'borrower_attribute_types', 'category_code' ) )
-            {
-                $dbh->do(q|
-                    ALTER TABLE borrower_attribute_types ADD INDEX category_code (category_code)
-                |);
-            }
-            $dbh->do(q|
-                ALTER TABLE borrower_attribute_types
-                    ADD CONSTRAINT borrower_attribute_types_ibfk_1 FOREIGN KEY (`category_code`) REFERENCES `categories` (`categorycode`)
-            |);
-        }
-    },
-};
-- 
2.39.5