[Koha-bugs] [Bug 31673] DB update of bug 31086 fails: Cannot change column 'branchcode': used in a foreign key constraint

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

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

Keith Sorbo <keith at thesorbos.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |keith at thesorbos.com

--- Comment #2 from Keith Sorbo <keith at thesorbos.com> ---
To help those who don't use diff, I have extracted the relevant sql to the
following:

ALTER TABLE reserves DROP FOREIGN KEY reserves_ibfk_4; 
ALTER TABLE reserves MODIFY COLUMN `branchcode` VARCHAR(10) COLLATE
utf8mb4_unicode_ci NOT NULL;
ALTER TABLE reserves ADD CONSTRAINT reserves_ibfk_4 FOREIGN KEY (branchcode)
REFERENCES `branches` (`branchcode`) ON DELETE CASCADE ON UPDATE CASCADE;

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