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

Keith Sorbo <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]

--- Comment #2 from Keith Sorbo <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to