https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31673 Keith Sorbo <keith@thesorbos.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |keith@thesorbos.com --- Comment #2 from Keith Sorbo <keith@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.