View | Details | Raw Unified | Return to bug 29341
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_29394.pl (+17 lines)
Line 0 Link Here
1
use Modern::Perl;
2
3
return {
4
    bug_number => "29341",
5
    description => "Remove foreign keys on pseudonymized_transactions",
6
    up => sub {
7
        my ($args) = @_;
8
        my ($dbh, $out) = @$args{qw(dbh out)};
9
        for my $fk ( qw( pseudonymized_transactions_borrowers_ibfk_2 pseudonymized_transactions_borrowers_ibfk_3 pseudonymized_transactions_ibfk_1 ) ) {
10
            if ( foreign_key_exists( 'pseudonymized_transactions', $fk ) ) {
11
                $dbh->do(qq{
12
                    ALTER TABLE pseudonymized_transactions DROP FOREIGN KEY $fk
13
                });
14
            }
15
        }
16
    },
17
}
(-)a/installer/data/mysql/kohastructure.sql (-5 / +1 lines)
Lines 4230-4239 CREATE TABLE `pseudonymized_transactions` ( Link Here
4230
  PRIMARY KEY (`id`),
4230
  PRIMARY KEY (`id`),
4231
  KEY `pseudonymized_transactions_ibfk_1` (`categorycode`),
4231
  KEY `pseudonymized_transactions_ibfk_1` (`categorycode`),
4232
  KEY `pseudonymized_transactions_borrowers_ibfk_2` (`branchcode`),
4232
  KEY `pseudonymized_transactions_borrowers_ibfk_2` (`branchcode`),
4233
  KEY `pseudonymized_transactions_borrowers_ibfk_3` (`transaction_branchcode`),
4233
  KEY `pseudonymized_transactions_borrowers_ibfk_3` (`transaction_branchcode`)
4234
  CONSTRAINT `pseudonymized_transactions_borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`),
4235
  CONSTRAINT `pseudonymized_transactions_borrowers_ibfk_3` FOREIGN KEY (`transaction_branchcode`) REFERENCES `branches` (`branchcode`),
4236
  CONSTRAINT `pseudonymized_transactions_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)
4237
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4234
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
4238
/*!40101 SET character_set_client = @saved_cs_client */;
4235
/*!40101 SET character_set_client = @saved_cs_client */;
4239
4236
4240
- 

Return to bug 29341