https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18086 --- Comment #35 from Victor Grousset/tuxayo <victor@tuxayo.net> --- Comment on attachment 168810 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=168810 Bug 18086: Add FK constraints for branchcode and categorycode Review of attachment 168810: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=18086&attachment=168810) ----------------------------------------------------------------- ::: installer/data/mysql/kohastructure.sql @@ +4962,5 @@
/*!40101 SET character_set_client = utf8 */; CREATE TABLE `overduerules` ( `overduerules_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'unique identifier for the overduerules', + `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'foreign key from the branches table to define which branch this rule is for (if blank it''s all libraries)', + `categorycode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'foreign key from the categories table to define which patron category this rule is for',
Is there a reason for adding "COLLATE utf8mb4_unicode_ci" ? It's already set exactly like that on the whole table. -- You are receiving this mail because: You are watching all bug changes.