[Koha-bugs] [Bug 16354] Fix FK constraints for edifact_messages table

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16354

Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |bgkriegel at gmail.com

--- Comment #5 from Bernardo Gonzalez Kriegel <bgkriegel at gmail.com> ---
(In reply to Brendan Gallagher from comment #4)
> Pushed to Master - Should be in the May 2016 Release.  Thanks!

(In reply to Brendan Gallagher from comment #4)
> Pushed to Master - Should be in the May 2016 Release.  Thanks!

Hi Brendan,
I have a failure in updatedatabase here,
perhaps each sentence neeeds it's own $dbh->do

$dbh->do(q{
        ALTER TABLE edifact_messages
        DROP FOREIGN KEY emfk_vendor,
        DROP FOREIGN KEY emfk_edi_acct,
        DROP FOREIGN KEY emfk_basketno;
        });

$dbh->do(q{
        ALTER TABLE edifact_messages
        ADD CONSTRAINT emfk_vendor FOREIGN KEY ( vendor_id ) REFERENCES
aqbooksellers ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
        ADD CONSTRAINT emfk_edi_acct FOREIGN KEY ( edi_acct ) REFERENCES
vendor_edi_accounts ( id ) ON DELETE CASCADE ON UPDATE CASCADE,
        ADD CONSTRAINT emfk_basketno FOREIGN KEY ( basketno ) REFERENCES
aqbasket ( basketno ) ON DELETE CASCADE ON UPDATE CASCADE;
        });

-- 
You are receiving this mail because:
You are watching all bug changes.