From e40fa1af65723cfa59140473e67fa55bae72bd15 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Tue, 26 Jul 2022 16:51:12 +0000 Subject: [PATCH] Remove atomicupdate file Signed-off-by: Lucas Gass --- .../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