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

(-)a/installer/data/mysql/updatedatabase.pl (-6 / +6 lines)
Lines 12345-12365 print "Upgrade to $DBversion done (Bug 12478 - Elasticsearch support for Koha)\n Link Here
12345
12345
12346
$DBversion = "3.23.00.051";
12346
$DBversion = "3.23.00.051";
12347
if ( CheckVersion($DBversion) ) {
12347
if ( CheckVersion($DBversion) ) {
12348
$dbh->do(q{
12348
    $dbh->do(q{
12349
        ALTER TABLE edifact_messages
12349
        ALTER TABLE edifact_messages
12350
        DROP FOREIGN KEY emfk_vendor,
12350
        DROP FOREIGN KEY emfk_vendor,
12351
        DROP FOREIGN KEY emfk_edi_acct,
12351
        DROP FOREIGN KEY emfk_edi_acct,
12352
        DROP FOREIGN KEY emfk_basketno;
12352
        DROP FOREIGN KEY emfk_basketno;
12353
12353
        });
12354
    $dbh->do(q{
12354
        ALTER TABLE edifact_messages
12355
        ALTER TABLE edifact_messages
12355
        ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
12356
        ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
12356
        ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
12357
        ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
12357
        ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE;
12358
        ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE;
12358
        });
12359
        });
12359
12360
12360
print "Upgrade to $DBversion done (Bug 16354 - Fix FK constraints for edifact_messages table)\n";
12361
    print "Upgrade to $DBversion done (Bug 16354 - Fix FK constraints for edifact_messages table)\n";
12361
        SetVersion($DBversion);
12362
    SetVersion($DBversion);
12362
            }
12363
}
12363
12364
12364
12365
12365
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12366
# DEVELOPER PROCESS, search for anything to execute in the db_update directory
12366
- 

Return to bug 16361